AutoCAD Inventor :: Export Parts List To CSV / Sheet Error
May 3, 2013
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
Let's say I have two independent drawings one with a single part and 1 with an assembly + parts list containing the single part.
So I would like to have an item note on the drawing sheet with the single part referring to the assy drawing, part number & Quantity for this item in the parts list.
Background: Our company has decided to switch from drafting in AutoCAD to Inventor (which we already use to model) and we have started looking at making our templates intuitive using iProperties, parameters, and functions to reduce manual entry of part information in turn to reduce human error. None of us have any experience coding besides a bit of LISP.
Problem: Perhaps it is a pipe dream, but one thing I would really like resolved is we have no connection between the Parts list information (specifically item number and quantity) on the assembly sheet and the part detail on another sheet. Our custom part detail title block pulls the material information and "Inventory Part Number" from custom iProperties we have set up at the part level, but we still need to reference the parts list in the other sheet and then manually enter the item number and quantity. Is there a way to use the "Inventory Part Number" property (which shows up in the parts list on a different sheet) to populate our custom block?
I have created an assembly that has a parts list, and in this parts list I have up to 100 mono detail drawings. I would like to know if there is a way to print all of these drawing from that list in a massive plot.
At my previous company we had something like this in AutoCAD where a script was created to look at the drawings and print all drawings mentioned in the assembly BOM and subsequent sub-assemblies, it worked beautifully.
I find that I have to print all drawings to paper or PDF individually.
We use different types of sheet metals, from stainless to bronze, and different thicknesses.
Currently, in order to show the correct material on a parts list, I have to duplicate the material Stainless Steel, and rename it to say 20 Gauge Stainless Steel. Then again for 16 Ga, 14Ga, 12 Ga, etc...
I'd like to have the parts list show the common material such as "Stainless Steel", with another column for the sheet metal style such as "20 Gauge."
We also use items such as Plastic Laminate. I'd like to create a generic material for the physical properties of "Plastic Laminate", and then change the material appearance to say "Formica #1234 Walnut". Again, i'd like to be able to put this in (2) columns on the parts list.
We 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?
Is 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
issues with parts lists generated from View representations?
This is weird but my parts list generated from View representation seem to be not accurate, when I take two assemblies that I need to create BOM for, and drop them into a new assembly, then create parts lists, its different from BOM generated from representation view that has too high numbers.
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.
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] ?
As an academic interest I was trying to convert Brian’s code for exporting Parts list with thumbnail to VB.net 2012. I just modified the below code to remove the vb6 support. I am using VS 2012 and Inventor 2014. The end result on the word report thumb nail for some parts are not visible. It goes to the error code and putting the text instead of thumb nail. At the same time Brian’s code as it is (used the exe file to install it) works fine on the same parts list with all thumb nail.
#Region "PictureToImageConverter" Public NotInheritable Class PictureToImageConverter Inherits System.Windows.Forms.AxHost Private Sub New() MyBase.New(Nothing)
We would like to put barcodes in a parts list. To create a barcode we use a special barcode font.
It's impossible to have two types of fonts within one parts list, but is there an other way? Is there code (VBA) to generate a table with an extract of the bill of materials and a barcode generated
with a special font on the fly. We would basically need a parts list with an extra column for the barcode.
is there any way to make all the rows in the BOM/parts list on an IDW the same height? I did a search on this and saw nothing new on this. the reason we need this is for a program we use after export to dwg. it is a program we use in autocad that is a txt copy lisp program to populate attributed customer title blocks.
win 7 64 bit sp1 cpu intel xeon E5-2687W0@3.106 eight core two solid state hard drives 32 gig of ram Autodesk product design suite premuim 2014 64bit Nvida quadro 4000 Space Pilot ver. 1.6.2 2010 slphantom (NNTP handle: scottl)
Want parts to be sorted from 1 ascending. Add a part number in custom properties as a number. Asks the part list to sort - ends like this: 1, 10, 11, 12, 13, 14, 15, 16,......, 2, 21, 22, 23, .......,3 , 31 and so on ?????
