I would like to make a mapkey that export the BOM list from an assembly to excel. typically this is the chain activate the assembly in the model tree right click ->view server properties activate structure tab Multilevel report actions ->export list to xlsx 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: was to make a trail file and play this off, another idea was to read the html url "proep://local_proesession?oid=00134755.ASM&item=ASSEMBLY&id=0&action=info&action_mode=bom" but this only works inside the creo browser make a script that runs on windchill use some software (hotkeys) that simulate your mouse and keyboard clicks Is it somehow also possible to get out which assembly that particular part belongs to?This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

K

kskatun

10-Marble

Question

Export bom list to excel

Forum|Forum|9 years ago
August 4, 2016
3 replies
30082 views

I would like to make a mapkey that export the BOM list from an assembly to excel.

typically this is the chain

activate the assembly in the model tree
right click ->view server properties
activate structure tab
Multilevel report
actions ->export list to xlsx

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:

was to make a trail file and play this off,
another idea was to read the html url "proep://local_proesession?oid=00134755.ASM&item=ASSEMBLY&id=0&action=info&action_mode=bom" but this only works inside the creo browser
make a script that runs on windchill
use some software (hotkeys) that simulate your mouse and keyboard clicks

Is it somehow also possible to get out which assembly that particular part belongs to?

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

2D Drawing

D

dschenken

1-Visitor

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.

R

RonSt.Pierre