Skip to main content
rbrooks1-Visitor
1-Visitor
November 18, 2014
Question

How do I get a complete BOM out of Creo

  • November 18, 2014
  • 8 replies
  • 11573 views

Can anyone explain how to get a complete bom out of Creo into Excel (or similar) please?

This is a very simple task for Solidedge or Solidworks but seems to be missing from Creo.

My problem is in two parts:

1. How do I display a complete BOM table showing everything including all sub assemblies and parts, we have tried every option we can think of but some sub assemblies won't show up.

2. How do I get the BOM from creo to excel. Saving as CSV doesn't work because it only exposrts the first 665 lines of the BOM and the BOM is over 4000 long.

Thnaks in advance


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.

8 replies

StephenW
StephenW23-Emerald III
23-Emerald III
November 18, 2014

You can get an indented BOM from TOOLS - MODEL - then apply on the top level radio button. This creates a text file in your working directory which will be your assembly file name .inf.1 (don't worry about displays in the embeded browser, I think that is worthless)

I usually just import that in to excel and filter it as I need. It does add some useless feature info at the bottom that I simply delete out.

neomechanikos1-Visitor
1-Visitor
November 18, 2014

Another method:

  1. Arrange your model tree how you would like your BOM to appear (hide features, add parameter columns, etc.)
  2. Click on the settings button in the model tree
  3. Then click on "save model tree".....not to be confused with "save settings file"
  4. Open the created TXT file in excel

You may also want to save various tree settings for quick BOM export and resetting back to default. I haven't tested this method with something as large as 4000 parts yet.

gkoch2-Explorer
2-Explorer
November 28, 2014

Hello Richard,

were the hints from Stephen and Eric helpful. Did you manage to output your BOM?

wluter1-Visitor
1-Visitor
December 5, 2014

I have a similar problem but it involves the BOM on the drawing. I want "reference models" as I call them to be automatically filtered in the BOM (without having to filter the BOM table) AND have the ability in Windchill to show the BOM only - not the whole document tree.

FYI - everything we want is brain-dead simple in SolidWorks. You can RMB click on the model tree and there are settings for 'Include In BOM", "Include Children in BOM", and "Show When inserting assembly" or something like that. They have all the bases covered to my experience. With these 3 things you can

1) Show only top level assembly in BOM

2) Show only children and skip top level assembly in BOM

3) "Hide" some parts when inserted in a higher level assembly

These settings are carried on the "link" not the file, so you can change them on a "per usage" basis.

If someone can help with these problems (without having to restructure Winchill or write macros) let me know.

dschenken1-Visitor
1-Visitor
December 6, 2014

You might follow up with this Component Parameter in repeat Region - http://portal.ptcuser.org/p/fo/st/thread=56143

It touches on creating component level (link) parameters. You'll be most interested in http://portal.ptcuser.org/x/fo/st/imagelb?fid=27878&topic=3 which is image006.png on the above page.

wluter1-Visitor
1-Visitor
December 8, 2014

Thanks - I'll look into it. Seems a lot more complicated than simply picking a checkbox on a form as in other CAD packages.

bgramman1-Visitor
1-Visitor
July 7, 2015

Simplified Logic Inc specializes in bi-directional Excel to Creo or Creo to Excell data transfer this with an application called Nitro-BOM.  Please see this Website: Simplified Logic, Inc. and YouTube Channel:  Simplified Logic, Inc. - YouTube

Terms & ConditionsAccessibility statement