Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I would like to make a mapkey that export the BOM list from an assembly to excel.
typically this is the chain
However i would like to automate this process, by saving the list to a given location and start a batch file which den dumps the bom list into my database.
Is this possible?
My ideas:
Is it somehow also possible to get out which assembly that particular part belongs to?
I set the model tree to show only components and then expand all . Then save the tree. The result is space-character indented text file and can be parsed pretty easily for structure. Groups and patterns make for a small twist, but accounting for those is easy enough once the realization they need treatment is clear.
Basically, every time the indent increases, unless a group or pattern, the level increases and all those parts are in that assembly. If the level decreases then that's the end of an assembly, If it's a group or pattern, then if the level decreases by one or more, that's the end of the group or pattern. Keep the current assembly on a stack and pop the correct number off whenever the indent decreases.
A couple of searched threads to look at:
Are you using Windchill or some other PDM system that would have your structure?
This is a OOTB function for Windchill from either the assembly file or the WTpart.