Skip to main content
Question

Multiple parts BOM extraction

  • August 23, 2022
  • 4 replies
  • 600 views

Forum|alt.badge.img+2

Hello,

I am looking for a way to export the BOM (structure, components, etc.) from multiple parts into a .csv or .xlsx file. I realize this may require a macro. Reason: I need this list for 1000’s of parts for analytics.

The list should have the PN tied to the structure (repeat the part number for each component; see column B)

Example:

Inputs: List of 1000’s of parts

Process: ???

Output: List of 1000’s of parts with corresponding structure

See image for a basic example.

Thanks for any help or direction!

-Shockwave

 

4 replies

Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • August 23, 2022

Try this thread:

 


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • August 24, 2022

@ShawnBerk - Thanks for the response and suggestion. I looked at that thread but it is only for 1 BOM. However, my admin showed me a way to get the output without a macro. 

  1. >Engineering>Structure>Manufacturing Structures
  2. Search: Enter the top level parts in “Parent part no:”
  3. I copied and pasted my list from excel into word and replaced all paragraph returns with a “;”. Then I copied that semi-colon delimited list into the “Parent Part No:” field.
  4. The result is 1000+ top levels with BOM’s in one list
  5. I can now determine where parts are used across the platform using manually filtering or pivot tables in excel

Search for multiple parts here: >Engineering>Structure>Manufacturing Structures


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • October 5, 2023

Is there a way to do this but get the cost of each part (add column)? 🤔

I can get the costed BOM for a single part from “Product Structure”, but I would like to extract multiple parts in one shot similar to the above.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • October 5, 2023

I figured out something that works: “Manufacturing structures” and add cost columns. 

Right click in column headers and select “column chooser”.