Custom BOM report possible?

[score33]

I'd like a little more info from my assemblies than the 'Info/Bill of Materials' menu option gives, such as parameters that I have set in each part.

Is there a way to do this and export all the info to a text file?

 

[robertib]

You can create a .fmt file with whatever you want in your BOM.

If you search the help files in the Fundamentals area for BOM, the first one on the list will explain what to do.

.breakdown
The %$type %$name contains the following components:
.titles Qty; Part Number; Description; Material; Supplier; Finish; Issue
-------------------------------------------------------
.row %$quantity[-5d]; %$name[-15s]; %PTC_COMMON_NAME[-30s]; %MATERIAL_NAME[-12s]; %SUPPLIER[25s]; %FINISH[-12]; %ISSUE[1s]

 

[score33]

thanks, I'll check that out.

 

[score33]

feel like an idiot, but I can't seem to find info on how to format this file...

 

[robertib]

Here is where to find the details.

 

[score33]

Hey rob, thanks for the help, but I still don't see any notes on the acutal formatting of the file.

For example, in your previous post you posted the brief section of code:

.breakdown
The %$type %$name contains the following components:
.titles Qty; Part Number; Description; Material; Supplier; Finish; Issue
-------------------------------------------------------
.row %$quantity[-5d]; %$name[-15s]; %PTC_COMMON_NAME[-30s]; %MATERIAL_NAME[-12s]; %SUPPLIER[25s]; %FINISH[-12]; %ISSUE[1s]

Most of it is pretty easy to understand, but what is the difference in using the '-' sign in the format call, or the difference between the 'd' or 's', or the function of the '$'. These are the kind of details I was looking for... granted, I could play around and see what they are, but I was hoping for a help file that just explained it.

Also, at the end of the default BOM it lists all parts required to make the assembly, regaurdless of where they are in the assembly. If I make a file with the above code it no longer gives me that list. This makes me think that there are more options to the BOM.

Not sure if you know the answer to these questions, but thanks for the help. You've got me on the right track for what I'm trying to do.

 

[score33]

Here's the info I couldn't find in the Pro/E help files:
(source)

The source of the bill of materials (BOM) output format can be configured by the configuration file option bom_format. For more information, see Configuration File Options in Pro/HELP.

The default output format for the BOM (see the following figure) is divided into two sections:

breakdown--Lists the name, type, and number of instances of each member and sub-member.

summary--Lists the total quantity of each part included in the assembly. It amounts to a ``shopping list'' of all the parts needed to build the assembly from the part level.

Default BOM Format File

A user-defined BOM output format specifies the format of the breakdown section and the summary section separately. You can include one or both sections, but you must specify the column titles, row content, and display format for each included section.

The user-defined format file contains a combination of text and formatting commands. The overall layout of the BOM is specified with the following section commands, which appear at the beginning of a line:

.breakdown--This command appears at the beginning of the breakdown section of the BOM. Lines of text following the .breakdown command appear as a heading for each assembly breakdown.

.summary--This command appears at the beginning of the summary section of the BOM. Lines of text following the .summary command appear as a heading for the summary section.

.titles, .row--These commands may be used within each section of the BOM to specify the column titles and the information to be included on the repeating rows of the BOM.

At any point in the format file, you can specify a system-supplied or a user-defined attribute:

%$--A percent sign followed by a dollar sign indicates that the next word is one of the three system-supplied attributes: name, type, or quantity. For example, %$type.

%--Any word preceded by a percent sign only is a user-defined parameter.

Text that is not a part of a parameter name is printed as it appears. For example, to print a dollar sign before the user-defined attribute price, type $%price.

System-supplied and user-defined parameters may be followed by a
C language-style format specifier, enclosed in square brackets ([ ]), that indicates the data type and printout width of the attribute's value. These format specifiers are optional, but may be needed for correct column alignment.

Examples of format specifiers are as follows:

[4s]--The preceding parameter is a string variable (text), and the field width is 4.

[3d]--The preceding parameter is an integer, and the field width is 3.

[6.2f]--The preceding parameter is a floating point variable (real number). The total field width is 6 (including a decimal point), and 2 digits follow the decimal point. Example: 400.25.

[8.8s]--The preceding parameter is a string variable. The field width is 8, and longer strings are truncated to 8 characters.

Note:

Field widths may be overridden by strings that are longer than the specified field. Use this format to ensure that the field width remains the proper size.

[-4s]--The text in this field is left-justified. (The minus sign indicates left-justification).

In each of the preceding format specifiers, the letter is optional; Pro/ENGINEER determines the type of the user-defined parameter (string, integer, or floating point) if you omit it.

Note:

You cannot use the BOM function on the Info menu to print parameters defined as ``note'' type parameters.

Entering the field [%[$total(item)]] in the format file (where item may be a user-defined parameter name) calculates the total for item. When entered within a .row command, the total is for that row only. Anywhere else, the $total() command must also be preceded by the .row command and the total is for all item within the sub-assembly or assembly. You can also use [%[$total($quantity)]], where quantity is a system-supplied attribute.

Note:

In $total(item), do not put a percent sign (%) before item or $quantity.

The system checks the format file for errors. If an error is found, the BOM format file appears in an Information Window with the error highlighted.