Inventor General Discussion

Inventor General Discussion

Reply
Active Member
documentation
Posts: 8
Registered: ‎03-21-2008
Message 1 of 13 (2,175 Views)
Accepted Solution

Automatic BOM export

2175 Views, 12 Replies
08-24-2012 09:23 AM

We are looking for a way to export BOM's without having to open individual IDW's.

 

We were unable to find such a function in either Inventor or Vault Workgroup. We have found customized function for export but each file has to be opened. Is there such a function available that we might have missed or third party?

 

We are currently working with 2011 versions of Inventor and Vault Workgroup, soon to be migrated to 2013.

 

Thank you.

Have you tried to just export the bom (all levels) to excel from the top level assembly..

You don't need to open any of the subassemblies at all that way.. You get the complete indented BOM.

I understand you want to export  the BOM from the drawing but drawings may contain multiple parts lists.

If you don't mind exporting the BOM directly from the assemblies, another thought is to use some iLogic code and wrap this up in a Task Scheduler custom task.

 

If you unzip attached 2013 files in a folder called c:\test, start Inventor and follow the instructions from this blog post (the post uses a different iLogic rule but the principles remain the same), you will see two Excel files with BOM info show up in the c:\test folder after running the custom task. Use the exe in attached zip (not the one from the blog post).

The names of the assemblies you are interested in need to be stored in myfiles.csv and can be customized to your needs. The ilogic code that I used can be found in Externalrule.txt.

 

Bob

If you want particular columns in a particular position, it is still possible to use my proposed technique but you will have to code considerably more. There is an API Example available that explains how to do custom BOM columns..


Search with the keyword "BOMquery" in the API Help.

 

It is quite easy to convert VBA code to iLogic code. The conversion typically consists in dropping the "Set" and "Sub"

statements and providiing the proper Inventor enum statements.

 

Bob 

*Expert Elite*
mrattray
Posts: 2,538
Registered: ‎09-13-2011
Message 2 of 13 (2,149 Views)

Re: Automatic BOM export

08-24-2012 09:58 AM in reply to: documentation

A .net solution using Inventor Apprentice may work.

Mike (not Matt) Rattray

*Expert Elite*
jdkriek
Posts: 545
Registered: ‎03-29-2007
Message 3 of 13 (2,133 Views)

Re: Automatic BOM export

08-24-2012 11:17 AM in reply to: mrattray

There are plenty of solutions that won't require you to manually open your files, but the program or application will still be opening the files in the background. The best solution is a stand-alone application I've found.

Jonathan D. Kriek

Autodesk Inventor Certified Expert
Microsoft Certified Application Developer
_____________________________________________________
Did I help you? Please choose Accept as Solution or Kudos below
Active Member
documentation
Posts: 8
Registered: ‎03-21-2008
Message 4 of 13 (2,120 Views)

Re: Automatic BOM export

08-24-2012 11:52 AM in reply to: jdkriek

Thank you for the response, would you happen to have examples or names of stand-alone applications? We dont mind if they all have to be opened by the program as long as we do not have to manually open them ourselves.

 

Here is a bit more detail on what we are trying to do.

 

We are working with assemblies composed of +/- 2500 total parts. From the main assembly we extract the BOM. from here we would like to feed this list to an application/function to gather all sub-assembly BOM's associated to the project and create related parts list files (ie:xls,csv, etc...)

*Expert Elite*
mcgyvr
Posts: 7,248
Registered: ‎12-01-2004
Message 5 of 13 (2,107 Views)

Re: Automatic BOM export

08-24-2012 01:30 PM in reply to: documentation

Have you tried to just export the bom (all levels) to excel from the top level assembly..

You don't need to open any of the subassemblies at all that way.. You get the complete indented BOM.

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

-------------------------------------------------------------------------------------
2015 Product Design Suite Ultimate
Windows 7 64 bit
Core i7 4820k processor (OC'd to 4.4Ghz), Nvidia GTX 770, 16G RAM


*Expert Elite*
Curtis_Waguespack
Posts: 3,000
Registered: ‎03-08-2006
Message 6 of 13 (2,097 Views)

Re: Automatic BOM export

08-24-2012 01:50 PM in reply to: documentation

Hi documentation,

 

As mcgyvr suggested, you can get the entire assembly from the top level model.

 

If you're looking to automate it from there, you can use something like the snippet posted here:

http://forums.autodesk.com/t5/Autodesk-Inventor-Customization/Recurssive-BOM/m-p/3507166#M38941

 

 

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





*Expert Elite*
blair
Posts: 4,449
Registered: ‎11-13-2006
Message 7 of 13 (2,090 Views)

Re: Automatic BOM export

08-24-2012 03:39 PM in reply to: Curtis_Waguespack

BOMxTrator works from outside the Inventor enviroment as well. Can be found on the cbliss.com website

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

IV2015 SP1 PDSU / Sim Mech 2015 r1 /
Win7-64
EVGA X79 - Classified, iCore7 3930k 32Gb Quad-Channel
950Gb (2 x 500Gb Sata III SSD RAID0 Adaptec 6805E Controller)
Nvidia GTX-690 Classified - 344.75
SpacePilot Pro 10.2.0 / 17.2.0.11011 / 4.17
Delta Tau Chi ΔΤΧ
Product Support
bobvdd
Posts: 577
Registered: ‎11-23-2005
Message 8 of 13 (2,049 Views)

Re: Automatic BOM export

08-27-2012 11:18 AM in reply to: blair

I understand you want to export  the BOM from the drawing but drawings may contain multiple parts lists.

If you don't mind exporting the BOM directly from the assemblies, another thought is to use some iLogic code and wrap this up in a Task Scheduler custom task.

 

If you unzip attached 2013 files in a folder called c:\test, start Inventor and follow the instructions from this blog post (the post uses a different iLogic rule but the principles remain the same), you will see two Excel files with BOM info show up in the c:\test folder after running the custom task. Use the exe in attached zip (not the one from the blog post).

The names of the assemblies you are interested in need to be stored in myfiles.csv and can be customized to your needs. The ilogic code that I used can be found in Externalrule.txt.

 

Bob

Member
a_angel
Posts: 3
Registered: ‎08-31-2012
Message 9 of 13 (2,010 Views)

Re: Automatic BOM export

08-31-2012 07:42 AM in reply to: bobvdd

The procedure works great, what I would like to know is how to edit the external rule file such that it outputs to a given excel template.

 

For example columns Part #, Description, Material, QTY with the columns fit to width. I found some similar commands in the boards but have not managed to get them to work.

 

Thanks in advance

Product Support
bobvdd
Posts: 577
Registered: ‎11-23-2005
Message 10 of 13 (1,990 Views)

Re: Automatic BOM export

08-31-2012 01:24 PM in reply to: a_angel

If you want particular columns in a particular position, it is still possible to use my proposed technique but you will have to code considerably more. There is an API Example available that explains how to do custom BOM columns..


Search with the keyword "BOMquery" in the API Help.

 

It is quite easy to convert VBA code to iLogic code. The conversion typically consists in dropping the "Set" and "Sub"

statements and providiing the proper Inventor enum statements.

 

Bob 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.