export expand children BOM

[jostroopers]

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.

[karthur1]

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.

Kirk

[jostroopers]

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?

[CCarreiras]

Hi!

You have to activate the Struture BOM view.

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

[karthur1 · Accepted solution]

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

[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.