Skip to main content
T
tleati12-Amethyst
12-Amethyst
September 21, 2015
Solved

Export customized BOM list

  • September 21, 2015
  • 2 replies
  • 7358 views

Hello,

I usually have to export a list of the totals of commercial parts (like screws, nuts, washers etc etc, common parts outsourced from suppliers) included in assemblies, in order to give it to the purchase office.

In Creo (prametric and windchill), we codify them as Cxxxxx (C stands for "commercial") where xxxxx is an internal code.

I would like, one I have finished an assembly, to export a Bill Of Materials containing ONLY them, without necessity to export the complete BOM, then erase rows etc etc...so I am searching for a function, if present, that would allow me to do this. In addition, it would be hugely useful to have, in this list, in addition to the file name and its total quantity in the master assembly (present by default in Creo BOM list), also the name assigned to the parts (e.g., if C00002 is a hex head screw M10x30, the part file name is C00002 and the part name is "hex head screw M10x30").

Anyone knows how to do it or has some suggestions?

thanks

bye bye


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.
Best answer by MartinHanak

Tomasso,

use the following filter

&asm.mbr.name  == c*

&asm.mbr.name  != c*_*

See attchached data.

MH

2 replies

M
MartinHanak24-Ruby III
24-Ruby III
September 21, 2015

Tomasso,

Bill Of Materials command available in Assembly mode does not enable to apply filter. Filtering functionality is available in Drawing mode, where you can create table containing repeat region and save its contents in csv format.

MH

T
tleati12-AmethystAuthor
12-Amethyst
September 21, 2015

Hi Martin,

thanks for your reply. Do you know how to do the table? We have tables of components for balloons but only at the first level (parts and subassemblies contained in the master assembly), and I really do not understand how to edit repeat regions in order to show what you are meaning, let alone with filters too.

thanks

bye

M
MartinHanak24-Ruby III
24-Ruby III
September 21, 2015

Tomasso,

see uploaded exmple drawing dd.drw.

It contains repeat regions with following attributes.

rr_attributes.png

One repeat region is filtered using expression ... &asm.mbr.name  == c*

rr_filter.png

MH

L
lsrutkowski1-Visitor
1-Visitor
September 21, 2015

Tomasso,

You mentioned in your post that you also have Windchill.  You should be able to create a new table view for your assembly structure there and then export the results (if you have 10 or later, you can directly import the view into Excel).  I often find that the way filtering is presented in Windchill is easier to work with.  An added benefit of performing the work in WC is that the filter could then be made visible to other users for use in any assembly.

T
tleati12-AmethystAuthor
12-Amethyst
September 22, 2015

Hi Larry,

yes we have Windchill too and in fact I had posted a discussion in the Windchill session too. Indeed yes it should be easier there, but the problem is that, for the moment, in WC I cannot manage to extract a list containing only Cxxxx components (without the "_" at the end), I do not know how to do it and the wildcards characters seem to work only in the search function unfortunately.

Bye bye

Terms & ConditionsAccessibility statement