To create a custom BOM (to set the data you want to show and which types of attributes to include in the bom) click on the BOM Configuration Manager… button.
This is the default configuration with the three standard lines; PartNumber, Quantity and Description.
In the left part of the dialog there is the list of configurations, while on the right the list of attributes of the selected configuration (which will generate the bill of materials).
To create a new configuration click on the first button on the top left, then name the new configuration by two slow clicks on the name to change it.
To add more rows, click in the next available row in the Title column and enter a name.
The title is the name of the column itself in the BOM. Then select - in the Get value from… column - the property (Part Property) to link to that column in the BOM. A drop-down menu appears where there are several properties to choose from.
Variables available in Column Get From:
For some properties it is necessary to fill in the Option column.
|Variables Type:||returns:||option Name:|
|Quantity||quantity of the elements|
|PartNumber||part number of the element|
|Description||description of the element|
|CustomData Value||value of the CustomData||the name of CustomData contained in the element if it-s different respect the Title|
|Material Name||material name of the element|
|User Name||name of the element|
|Sizebox Height of Element||total height of the element|
|Sizebox Length of Element||total length of the element|
|Sizebox Width of Element||total width of the element|
|Thickness of SheetMetal||thickness value of sheet metal|
|Total Weight of Elements||weight value of all elements|
|External Linked Status||status of external link element true/false|
|External Linked File||path of the external link element|
|Scene Properties||file property value||the name of Property contained in the file if it-s different respect the Title|
|Combo - 1 -||the result is get from an expression string.||ex: |
<Description>-<Sizebox Length>x<Sizebox Width>
|Longest Value of Sizebox||the longest value (among L W H) of the sizebox|
|Parameter Value||parameter value||the name of Parameter contained in the element if it-s different respect the Title|
|Expression - 2 -||this field evaluate an expression using the MSExcel syntax||ex: |
|Expression Hidden - 2 -||like expression, but the result is not visible in the grid||ex: |
[Qty]*[W]*100 (Qty and W are Title)
|Position X - Relative||X value of the relative position|
|Position Y - Relative||Y value of the relative position|
|Position Z - Relative||Z value of the relative position|
|Position X - Absolute||X value of the absolute position|
|Position Y - Absolute||Y value of the absolute position|
|Position Z - Absolute||Z value of the absolute position|
|Row Counter||this value BOM row index||+ starting value (optional, otherwise it starts from 1)|
|Surface of Element||surface value of all faces of the part|
|Volume of Element||volume value of the element|
|Weight of Element in Water||weight value of the element in water|
|Mass Density||mass density value of element|
|Weight of Element||weight value of the element|
|Length of Sweep||value of the length of the guide curve of the sweep|
|Where Used||the part number of the parent assembly|
|Status Color Marker||the status of element||see here how use Status|
|Area of Unfold SM Part||the area of unfolded sheet metal|
0 or empty for real unfolded face area
1 for bounding box unfolded face area
|Perimeter of Unfold SM Part||the perimeter of unfolded sheet metal|
0 or empty for external perimeter
1 for internal perimeters (es. the holes or cuts)
2 for the sum of external and internal perimeters
|SMBend info||obtain the number and radius of bends of a sheet metal part|
|Combo ||Insert in the Option field the required values enclosed in < > brackets, brackets and contained string will be replaced by the value, all other text will remain unchanged, tag available are: |
|Expression ||Insert in the Option field the required expression, the value of Title must to be enclosed in [name of title] bracket, all MS Excel expression are valid|
|all field||if you add |
<AddToCustom> in any Option field, the Title of the field will be added to the CustomData and will be filled with the value found in Get From
The Format column set the format to display data in the BOM and is automatically filled with the correct value:
%s for text string,
%i for integer,
%f.2 for floating where the number after the dot indicates the number of decimals,
%fc.2 for custom floating where the character after fc is the decimal separator.
The Count By column is used to control which property is used to count parts/assemblies with similar properties. The number is added and displayed in the list column of the BOM (Quantity) unlike the bom in the 2D drawing, any value can be used here!
With Ref. for StructuredBOM, you can control which property should be primary, using multiple selections in Count by. It is therefore possible to summarize in the BOM with more than one property (but it is only possible when using the Multi Level BOM type).
Inherited by Children means that this field (if “Get Value from…” is set to “CustomData Value”) can be used to set the value of the father in the child parts.
Sum Column allows you to sum all the values of the column and in BOM grid a row with the totals of this column will be added.
The order of the Title column from top to bottom is also the order of the columns of the BOM grid from left to right.
The icons on the left are for:
- create a new configuration
- save the configuration
- save configuration with a new name
- open a saved configuration
- delete configuration
The icons on the right are for:
- add a new row
- delete the selected row
- move the selected row up
- move the selected row down
- expand dialog for the advanced setting
If you turn on the advanced setting, the dialog box expands down and there are three sections here:
If you directly export the BOM to txt or cvs file, you can set the separator character for the fields, the character of the decimal separator, the path (if the path is not set, the file will be saved in the current folder) and the name of the file to export the BOM, see here how for Export BOM.
MSExcel Export Settings
If you export the BOM in an excel file, you can set an Excel file to be used as a starting template and the name to be assigned to the sheet in which to export the BOM.
Folder for VirtualCode Datafiles
If you want to replace real PartNumbers with virtual codes, enter the search path here.