Skip to main content
B
btheobald1-Visitor
1-Visitor
November 1, 2016
Question

BOM schedule table export to include additional part parameters. Is this possible?

  • November 1, 2016
  • 4 replies
  • 1850 views

I'm tasked with exporting a BOM schedule table as CSV file (Part No:, Description & Quantity) -straight forward 'Save Table-Save As' etc. However, I need to also capture additional part parameters that are not included in the table i.e. Volume & Material. Is this possible?

Thanks in advance.

Bob


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.

4 replies

Chris3
Chris321-Topaz I
21-Topaz I
November 1, 2016

Add these to your repeat region:

Material: &asm.mbr.ptc_material.PTC_MATERIAL_NAME

Volume: &asm.mbr.PRO_MP_VOLUME

B
btheobald1-VisitorAuthor
1-Visitor
November 1, 2016

Chris,

Thanks for your prompt response. However, if I've understood correctly,  revising the 'repeat region' as you've suggested will now show these parameters in the table, which is not what I'm after. The BOM schedule table needs to exhibit only: Part No:, Description & Quantity. However, the exported CSV to Excel  needs to  include the additional Volume and material parameter  information.

I'm now thinking that I need to follow the 'Tools-> Bill of Materials' route and define a customized BOM format file ( *.fmt), which sources the , Part No:, Description, Volume & Material parameters of  each part in the assembly.

Am I barking up the wrong tree?

Regards,

Bob

Chris3
Chris321-Topaz I
21-Topaz I
November 1, 2016

For this kind of thing I have a blank drawing with a repeat region on it. I have a mapkey that opens the blank drawing and prompts the user to add an assembly. Then the mapkey saves the repeat region as a csv file and closes and erases the drawing. Then I call an external script that opens that csv in Excel. This way you can add whatever filters and parameters you want and it is only temporary.

There may be other ways to do it, but that is how I do it.

Terms & ConditionsAccessibility statement