Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
jostroopers
Posts: 121
Registered: ‎06-24-2007
Message 1 of 6 (281 Views)
Accepted Solution

export expand children BOM

281 Views, 5 Replies
01-07-2014 12:40 PM

Is it possible to export all expand children from the model data in the BOM to excel.

I want to see all the parts in the assy so i can see in excel which parts belong to the assy.

I can copy and past but that is not what i want.

Mvg Jos
Youre drawings are as good as the symbols that compleet them.....
*Expert Elite*
karthur1
Posts: 4,203
Registered: ‎04-27-2005
Message 2 of 6 (262 Views)

Re: export expand children BOM

01-07-2014 01:49 PM in reply to: jostroopers

J,

Doing that in the iam is not the way to do it if you want to export and see what is under each sub-assy.  The way we do that is in the idw environment.

 

Start a new drawing (idw) and place a parts list of the top level assembly.  Now, you can edit the parts list and expand what sub-assys you want expanded.  After you get that the way you want it, now you can export this to excel.  I like keeping the item numbers so I can tell how things are related.

 

 

2014-01-07_1544.png

Kirk

 

 

 

 

Distinguished Contributor
jostroopers
Posts: 121
Registered: ‎06-24-2007
Message 3 of 6 (257 Views)

Re: export expand children BOM

01-07-2014 02:09 PM in reply to: karthur1

I can't expand the assy in the parts list.

And can i insert collums with parameters which are in the parts, Lengte, Breedte and so on?

 

 

 

 

Mvg Jos
Youre drawings are as good as the symbols that compleet them.....
Distinguished Mentor
ccarreiras
Posts: 736
Registered: ‎02-04-2010
Message 4 of 6 (236 Views)

Re: export expand children BOM

01-08-2014 04:10 AM in reply to: jostroopers

Hi!

 

You have to activate the Struture BOM view.

 

Did you find this reply helpful ? If so, use the  Mark Solutions!  Accept as Solution or Give Kudos!Kudos - Thank you!

Regards.
CarlosC

Autodesk Inventor 2014 Certified Professional
Autodesk Factory Design Suite Ultimate 2015
Windows 7 64Bit
*Expert Elite*
karthur1
Posts: 4,203
Registered: ‎04-27-2005
Message 5 of 6 (228 Views)

Re: export expand children BOM

01-08-2014 05:41 AM in reply to: jostroopers

In the idw, right click on the parts list and choose "Bill of Materials".  Select the Structured tab and then right click on it. Select the "View Options" and change the level from "First Level" to "All Levels".  Choose "OK", and then "Done" to close the Parts list.

 

Now right click on the parts list again in the idw and choose, Edit parts list.  YOu should now see a "+" sign in the "+/-" column.

 

Kirk

Distinguished Contributor
jostroopers
Posts: 121
Registered: ‎06-24-2007
Message 6 of 6 (223 Views)

Re: export expand children BOM

01-08-2014 06:05 AM in reply to: jostroopers

Thanks, i change the View Properties under Structure to All Levels in the BOM.

Now i can export to excel and see the expand levels with follow item numbers so i can see which part belongs to the assy.

Mvg Jos
Youre drawings are as good as the symbols that compleet them.....
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 or visit the Installation and Licensing Forum to get help installing your software.