AutoCAD Inventor :: ILogic And Export Parts List In A IDW
Nov 18, 2010I need to generate an iLogic rule exporting Parts List (not BOM) from a IDW to a specific folder in XLS format.
Using Autodesk AutoCAD Inventor 2011
I need to generate an iLogic rule exporting Parts List (not BOM) from a IDW to a specific folder in XLS format.
Using Autodesk AutoCAD Inventor 2011
I curently have a rule that generates a part list automatically in a drawing. the problem is that I want the rule to be continuisly running but it keeps generating 2,3,5... parts lists. I need an if statment to check if a parts list already exists.
iLogicVb.UpdateWhenDone = True On Error Resume Next ' Set a reference to the drawing document. ' This assumes a drawing document is active. Dim oDrawDoc As DrawingDocument oDrawDoc = ThisApplication.ActiveDocument 'Set a reference to the
[Code].....
im trying to programatically add a parts list into a drawing whilst programatically creating the drawing - the code works fine without the parts list code. The error its showing is 'Parameter incorect' on the line that sais PartsList.add(... In the past when ive got this error with other code it has been because ive used an incorrect parameter (e.g. decimal instead of an integer).
My error is somewhere inside the oPartsList.add(>>ERROR SOMEWHERE HERE<<<)
oDrawDoc = InvApp.Documents.Add(Inventor.DocumentTypeEnum.kDrawingDocumentObject,AssyTemplate,True)
oSheet = oDrawDoc.Sheets.Item(1)
[Code].....
I have got some ilogic code that i have patched together to sort my parts list in inventor which works great but it will not update all sheets at the same time as when we design we have multiple sheets with parts list on and the odd one without.
add to this code to update all sheets partlists and also recognise that some sheets will not have partslists on so this will need to skip.
below is code that is used to sort
Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 4558 StartFragment: 314 EndFragment: 4526 StartSelection: 314 EndSelection: 314
SyntaxEditor Code Snippet
Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 4558 StartFragment: 314 EndFragment: 4526 StartSelection: 314 EndSelection: 314
[Code] ...........
Below are 2 rules that run in succession to create and save a parts list from a base view in a drawing.
I am now trying to set the parts list style to a custom style, ideally while creating the list.
Also, I have to manually go into the list to turn off visibility of certain items (based on material), does I can do this with Ilogic? I ask because these steps precede a rule that automates placing base views of all parts in the parts list. If I could get the style and visibility right, I could automate the entire process.
Looking for changing such a style with ilogic?
Inventor & Vault Pro 2012
Windows 7, 64bit
Core i7 920@2.67
8GB
CREATE PARTS LIST____
' Set a reference to the drawing document.
' This assumes a drawing document is active.
Dim oDrawDoc As DrawingDocument
oDrawDoc = ThisApplication.ActiveDocument
'Set a reference to the active sheet.
[Code] .....
I am creating a drawing controlled by ilogic. The assembly can vary in size considerably so I have set the IDW to change between sheet size A3 and A2 accordingly using ilogic. However, when the sheet size is changed, the parts list stays in a static position.
Currently, the parts list is situated in the top right corner up against the title block and the border. So when changing from Size A3 to Size A2, the parts list ends up in the middle of the page. Is there anyway i can control the position of the parts list so it changes with the sheet size change?
I know I could simply move the partslist to the bottom left corner, which is a work around. However, I'd like to be able to keep the drawings in line with the company standard.
I am Trying to add the category Field to the parts list, if a sting exists in the field. I want to run this as a rule at the Drawing Level. I can check if there is a sting in the Category Field But not sure how to add this in the Parts List.
View 4 Replies View RelatedAt my company when producing drawings for manufacture we require a sheet for any steel profiles to be cut!..We do this by selecting the assembly from base view,hitting model view tab, selecting presentation and choosing the relevant profile from the drop down!
Once the profile is placed, we highlight the view and hit the parts list tab which obviously creates a parts list, but for the whole assembly, we then have to edit the parts list by turning off the visibility of the lines of all the parts which are not relevant!!...as you can imagine this is quite a laborious task if you have 50 different profiles.
The reason for this is to show the qty, steel grade and part number to the suppliers. My question is, any code that will take the lines of the parts list that are not relevant to the selected view and turn the visibility of those lines off?
I'm trying to create an iLogic rule that will print a text string to a cell or coloum of a parts list in inventor.
My code so far...
Sub Main()
On Error Resume Next
Dim oDrawDoc As DrawingDocument
oDrawDoc = ThisApplication.ActiveDocument
[code]......
I want to print what is in the Message Box into a cell in the parts list, and i am stumped. The cell i am trying to print to is a user property in the Parts List.
I am trying to make an iLogic rule that gets mutliple strings from different places, and prints them to a user property in the Parts List.
My ultimate goal is to print the drawing number, sheet number and the item column value to the user property with the format being...
"XXXXX-X-X"
So far, i can get the drawing number from an iProperty and the sheet number easily. But im getting stumped on obtaining the item coloum value and printing it to the same row.
This is what i have so far...
Dim DWGNUM As String = iProperties.Value("custom", "DWG Number")
SheetNumber = Mid(ThisDoc.Document.ActiveSheet.Name, InStr(1, ThisDoc.Document.ActiveSheet.Name, ":") + 1)
MessageBox.Show(DWGNUM+"-"+SheetNumber, "DXF Number")
And print the message box output to a column in the parts list
I need an ilogic rule to autmoatically change the style of the parts list in a drawing file.The parts list style already exist in the drawing.
View 2 Replies View RelatedI'm trying to create an iLogic rule that will print a text string to a cell or column of a parts list in inventor.My code so far...
Sub Main()
On Error Resume Next
Dim oDrawDoc As DrawingDocument
oDrawDoc = ThisApplication.ActiveDocument
[code]...
I want to print what is in the MessageBox into a cell in the parts list, and i am stumped.The cell i am trying to print to is a custom property in the Parts List.
You can't export parts list to Excel file but you can export CSV file without any problems.
View 3 Replies View RelatedWe would like to be able to export parts lists from our drawings into Excel, so we can build a master item list on a project to get purchasing information on long lead purchased items early in the design phase.
We are thinking of exporting the part list to an Excel file named the same as the drawing file each time the drawing is checked in to the vault. We will have another VBA routine that does some sorting and other magical things to build the master list in Excel.
I have a drawing with multiple sheets (spool drawings) all with there own parts list and I need to export them all to excel. This takes a long time when you have 100 sheets. So my question is how can I do this, how should the code look like?
View 2 Replies View RelatedIs there a specific reason that you can only export a parts list from a .IDW to a MS Excel 5.0/95 format? Is there a conflict with the newer formats of Excel?
Inventor 2013
Windows 7 Professional 64-bit SP1
HP EliteBook 8470w
Processor: Intel(R) Core(TM) i7-3610QM CPU @ 2.30GHz
Memory: 16 GB
AMD FirePro M2000
3D Connexion SpacePilot
Inventor Professional 2012.like many companies we export our parts lists (in our case, .csv) for our MRP system. I borrowed and modified Curtis' ilogic code that I found in previous posts on these forums to fit our needs. The only thing I'm getting hung up on is the sheet in which the parts list is found.
Right now the code is pointing only to sheet 1 to find the parts list. Unfortunately some of our assembly drawings have many sheets and the parts list can be on any of them. So whenever I run the rule in a drawing that doesn't have the parts list on sheet 1 I get an error. Is there some way for Inventor to search all the sheets? or at the least search on the active sheet?
'name for .csv file
name = iProperties.Value("Project", "Part Number")
'path for .csv file
folderName = "L:CadLink"
Dim oDoc As Inventor.DrawingDocument
oDoc = ThisDoc.Document
[code]....
how I can export an assembly parts list to a text file that can be opened by notepad?
I want to do this from the IAM file, rather than from an IDW file.
I had resized the File>Open dialog in Inventor. I had resized it so that it was quite large so I realized pretty quickly when I opened another file, that the window size had rest to its original size.
What I found was that if I export a parts list to excel, then go to File>Open, for some reason the size of my file>open dialog is cleared.
How can I export the blocks that i created to create a parts list.
I have a drawing with several different custom Blocks in it that i created. How can i extract the blocks to a excel spreadsheet so i can see how may parts(blocks) i need to order?
On the main sheet of my drawing I have the overall Parts List. Shows almost all parts except for the few that we don't want to list. On the second sheet I inserted a Parts List to show only parts that are shown in a detail on that page, made the rest non-visible.
On the main sheet there is an item (#13) that has a QTY of 3. Two of those Three are optional parts. What I'm trying to do is insert a custom part into the Parts List, give it an item number of 13A and put in the description "OPTIONAL", then do an Override in the balloon to show 13A.
I get it in the Parts List, Apply it, close it, save the drawing. Looking at the Parts List, item #13A is there, but item #14 is gone. I go back into the Parts List and 13A is there and there's a blue box around the item # and the description. I uncheck Static Value and number 14 shows up (item # and the description).
Then I go over to sheet two, open that Parts List and it lists 13A at the bottom with all the info I added in sheet one and it's non-visible. Go back to sheet one, open the Parts List and there is no 13A to be found.
My parts list on my idw do not update when I make changes to the model. Specifically, I have deleted a bolted connection on my design and replaced with a different components but the parts list table does not update - all I see is a lightning bolt in the browser next to the parts list but I cannot update it here.
Autodesk Inventor Professional 2013 SP2 64-Bit Edition
Windows 7 HP Z400, Intel Xeon W3550 3.07GHz
12.0GB RAM, ATI FirePro V4800 (FireGL)
I was using virtual parts to add nuts and bolts to a drawing in 2013
I can make a VP bolt in the assembly, no problem, set it's size, weight, etc.
In the VP itself, there is no option for number of bolts I want it to emulate. For arguement's sake the weight was 1 pound per bolt (they are big bolts).
I can go into the BOM and say quantity 60, hit done and save the assembly.
If i open the drawing, the parts lists shows 60lbs for the 60 bolts total - which it should when summing the weight.
The problem is the BOM/assembly. If the weight of my assembly (without bolts) is 10,000lbs, the assembly sees the VP weighing 1lb and says the total weight is 10,001 lbs. Am i going to have to pattern a fake part to get this to work right? Shouldn't the total weight take into account the quantity set in the Bom??
Is there a way to display the density of materials that are assigned to varius parts in the parts list on a drawing? I don't need the mass of the parts I just need the material density to show up next to their respective parts.
For example, if I have a part with [steel mild] material assinged to it (no matter the size) I need a column in the BOM on the drawing to show: 490.684 lbs/ft^3. "Worry when there's something to worry about."
I have an assembly with a lot of purchased parts. I need to create a buy out list for purchasing. I've done this many times in the past and have a template set up for this purpose.
So now the problem, In this assembly, I have subassemblies showing up on my parts only parts list.
One of the subassemblies cinsists of two purchased parts. Both parts are set to purchased in the Bill of materials. If I do a parts only list on this assembly, it works as expected, showing two purchased parts. However, if I put that assembly into a higher level assembly, A parts only parts list shows the assembly instead of the individual parts.
IV 2010 Suite
Been working over an idw MANY times due to project lag.Today I opened it up and tried adding balloons to an already ballooned assembly.
The parts list has not changed, and is "structured".But, if I try adding balloons, they tag each part, not the entire assembly.
Also, I verified this by trying to add another parts list, which defaults to "parts only".
I can't show my data set, b/c it's HUGE, plus it's proprietary.
IV 2010 Suite
Digital Storm PC:
EVGA & Intel components
Win 7 Pro 64 bit
I have a .idw that I'm trying to make a parts list on. I select parts list and highlight everything. There are two screws that are not showing up on the parts list. I cannot select them manually either. It's acting like they are not there. Even if I do a complete parts list (adding the assemblies parts into one big list), they still don't show up.
How can I select these parts? What is wrong with them that they do not show up in the parts list?
It seems like most people output the whole BOM. I only want to data in the Part Number column, preferably as a list of strings.
Here's what I have so far:
foreach (Sheet oSheet2 in aDoc.Sheets){ for (int i = 1; i < (oSheet2.PartsLists.Count+1); i++) { var oPartsList = oSheet2.PartsLists[i]; for(int k = 1; k < oPartsList.PartsListColumns.Count+1; k++) { if (oPartsList.PartsListColumns[k].Title.Equals("PART NUMBER")) { //what goes here??? } } }}
I've been using the "Phantom" BOM Structure to roll up duplicate .ipt's when I have more than one sub-assembly within a higher .iam and it has worked well.
Question - is it possible to adjust settings so that the .iam that I "Phantom" itself remains as a visable line item in the Parts List while still rolling up like .ipt's?
I have a drawing and I need to get a list of parts. I see *most* solutions use the parts list on the sheet itself. I will not have access to that. Is there a way to get a list of parts WITHOUT accessing oSheet.PartsList[1] ?
Win7 x64 - 16gb ram
i7 3610qm
FirePro M4000
Inventor 2013
ETO 6.1
Trying to have ilogic find parts in an assembly that start with 900C7 so I can link the to a cell in excel showing the QTY and the LENGTH..
Right now I am just trying to get ilogic to find and list them then I know I can move to the next step..
Example:
900C71.250
900C72.125
900C7A.750
900C7P1.1875
And many more.
Here is what I have but it keeps posting the NOTHING message box. I have a few of the parts in the assembly and a few none 900C7 parts.
Dim openDoc As Inventor.DocumentDim docFile As Inventor.DocumentDim assemblyDoc As AssemblyDocumentDim partOcc As ComponentOccurrenceDim FNamePos As LongDim docFName As StringDim oList As Collection = New CollectionopenDoc = ThisApplication.ActiveDocumentIf openDoc.DocumentType
[Code] .....
Here is a screen shot of the excel file what I am trying.