Inventor Customization

Reply
Contributor
ddavis
Posts: 20
Registered: ‎04-20-2011
Message 1 of 8 (1,045 Views)

iLogic BOM Manipulation

1045 Views, 7 Replies
11-30-2012 10:10 AM

I'm not sure if this has been discussed here before, if so please accept this apology in advance.

 

When we create a manifold assembly we like to itemize each part individually. Meaning that if we have 5 valves that are the same, we show those as 5 separate items on the BOM. This makes for easier troubleshooting with a customer over the phone. Unfortunately there appears to be no way to manage this natively within Inventor, so we have to edit the BOM manually which defeats the whole idea of automated BOMs. I was hoping some code could come to the rescue. One thought I had was to export the BOM to excel and then have some automation within excel to re-number and sort the BOM, once complete import it back into Inventor in a table. I think this has issues of its own, but I'm not sure of another way.

 

I have attached a sample of the manually modified BOM incase I was unclear.

 

If anyone has some thoughts on this it would be greatly appreciated.

 

Thank you,

 

Darek

Contributor
ddavis
Posts: 20
Registered: ‎04-20-2011
Message 2 of 8 (983 Views)

Re: iLogic BOM Manipulation

12-07-2012 08:55 AM in reply to: ddavis

I have made some progress on this though I could use some help going forward. I have used the iLogic BOM export code from http://inventortrenches.blogspot.com/2011/06/ilogic-export-parts-list-with-options.html and have formatted it how I would like. I then with help created a macro for excel that automates the BOM restructuring. I then use this file as the "template" for the BOM export. This works quite well, as once I open the exported .xls I can run the macro and see the change. 

 

Now my question(s) is how can I call an instance of Excel to open, allow the user to make any additional changes then save and exit. Meanwhile Inventor is waiting for this to finish. Now once this is complete I would like to import this newly created BOM back in to my drawing with some pre-defined column heights and widths.

 

Is this something that is possible?

 

Thanks you any input and support anyone can offer.

 

Darek

 

*Expert Elite*
Curtis_Waguespack
Posts: 2,799
Registered: ‎03-08-2006
Message 3 of 8 (979 Views)

Re: iLogic BOM Manipulation

12-07-2012 09:21 AM in reply to: ddavis

Hi ddavis,

There are some examples that might help at these links:

http://forums.autodesk.com/t5/Autodesk-Inventor/Is-it-possible-to-export-selected-colums-of-a-BOM-to...

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

http://forums.autodesk.com/t5/Autodesk-Inventor-Customization/iLogic-to-change-parts-list-style/m-p/...

 

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.





Contributor
ddavis
Posts: 20
Registered: ‎04-20-2011
Message 4 of 8 (977 Views)

Re: iLogic BOM Manipulation

12-07-2012 09:57 AM in reply to: Curtis_Waguespack

Chris,

 

Thank you for those examples they were very helpful. A couple additional questions though. Is there a value that can be set to bring the excel window in focus? As it currently works it opens but behind everything else. This would be useful and probably less confusing for my colleagues. Additionally is there any way in which to import this excel file back as a general table through iLogic?

 

Chris thanks again for all of your help. You and your website are a great resource.

 

Darek

*Expert Elite*
Curtis_Waguespack
Posts: 2,799
Registered: ‎03-08-2006
Message 5 of 8 (968 Views)

Re: iLogic BOM Manipulation

12-07-2012 12:56 PM in reply to: ddavis

Hi ddavis,

 

Let's backup a bit. Can you provide more detail on the unique valve name/PNs? I suspect we might be able to tweak the BOM to accomodate this without the need for excel, but I might be wrong.

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.





Contributor
ddavis
Posts: 20
Registered: ‎04-20-2011
Message 6 of 8 (961 Views)

Re: iLogic BOM Manipulation

12-07-2012 02:27 PM in reply to: Curtis_Waguespack

Curtis,

 

Thank you again for your help with this. What am I looking to do is un-roll the BOM so to speak. I don't want items with the same part number to be given the same item number. I could not find a way to do this within Inventor natively so I thought I needed to create a set of rules to make it happen. I have attached a quick assembly and the related files. On the drawing I show the standard Inventor created BOM and on the right I show the "restructured" BOM. I used your rule to export the BOM into excel, then I used a macro there to "un-roll" the items. Lastly I used the general table command and selected the output .xls file. This is the final part that I am trying to automate, though if it can be done a better way, I'd be glad to hear it.

 

The template .xls and the iLogic code are available from a previous post in this thread if you have any use for them.

 

Darek

Contributor
ddavis
Posts: 20
Registered: ‎04-20-2011
Message 7 of 8 (959 Views)

Re: iLogic BOM Manipulation

12-07-2012 02:28 PM in reply to: Curtis_Waguespack

Curtis,

 

It turns out that I can only upload files under 1.5 MB, mine is 3.0. Is there a way that I can get these to you via email?

 

Darek

Contributor
ddavis
Posts: 20
Registered: ‎04-20-2011
Message 8 of 8 (938 Views)

Re: iLogic BOM Manipulation

12-11-2012 03:46 PM in reply to: Curtis_Waguespack

Curtis,

 

I have uploaded and shared the files via DropBox, hopefully you'll have no issue retrieving them.

 

http://dl.dropbox.com/u/4129076/BOM%20Test.zip

 

Thanks again for your help.

 

Darek

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube