Skip to main content
B
btheobald1-Visitor
1-Visitor
December 9, 2016
Solved

BOM Customization (search for either or parameter)

  • December 9, 2016
  • 1 reply
  • 5396 views

HI all,

I'm creating a customized BOM report, in which I need to able to include the string content of the part 'Description' parameter. This currently works fine as I've edited the 'bom_format.bft'  file as required. However, it is now a little more complex as some of the assemblies are using legacy parts generated overseas which do not contain a 'Description' parameter but an 'equivalent alternative'. My question is how to get the BOM report to search for the 'equivalent alternative' parameter in the absence of the 'Description' parameter?

I have successfully managed to do this with BOM tables in drawings, but in this instance I am generating the report from the assembly via the 'Bill of Materials'  route.

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

The steps are as follows:

1. Create a blank drawing (no associate models) and add a repeat region with whatever columns / parameters you want.

2. Save the drawing somewhere all of your users has access (network drive).

3. Record mapkey that opens the drawing and adds an assembly. My mapkey changes the filter to assemblies to make it easier on the user.

4. Add a manual pause so the user can choose the assembly and master rep. My manual pause says:

Select an assembly and then click the "open" button.

Then choose a simplified rep before clicking "Resume"

5. Then continue the mapkey and use the find tool to seach for the Table ID (should be table 0 if you started from a blank drawing)

6. After you have selected the table, export it on the table tab to a text or csv file. I export mine to a text file and I use the @ symbol as a delimiter in my repeat region to prevent mix ups in excel for things like descriptions that might have commas in them.

7. Close and erase the drawing.

If you want to get really fancy you can then add an @system at the end of your mapkey that calls a script to open excel and import the text file.

1 reply

M
MartinHanak24-Ruby III
24-Ruby III
December 9, 2016

Hi,

functionality you are looking for is not available in Assembly mode when using Bill of Materials command.

MH

B
btheobald1-VisitorAuthor
1-Visitor
December 9, 2016

Martin,

Thanks for your reply. Is there not a way of defining a relation  i.e. an 'ELSE' script which searches for the 'Description' parameter, but if not found searches for the 'alternative' contained within the Part model parameters?

I live in hope.

Bob

M
MartinHanak24-Ruby III
24-Ruby III
December 9, 2016

Hi,

you can define relations in repeat region in Drawing mode. Bill of Materials command in Assembly mode does not have such functionality implemented.

MH

Terms & ConditionsAccessibility statement