ProActive Manager

ProActive Manager >

ProActive Manager is a big piece of the ICMechanical, is a utility that quickly and easily manages the properties of the elements, such as Name, Description, Code, Material etc… It allows you to create BOMs in the 3D scene, you can create them easily and in many different ways with a lot of settings.

ProActive Manager

There is also Configurations management, Search functions and a number of small smart tools built in. With this tool you can work directly on the BOM in the 3D scene and add, delete and modify the Properties of parts and assemblies very quickly and easily!

Subsections of ProActive Manager

ProActive Manager Dialog

ProActive Manager

ProActive Manager >

Drop the ProActive Manager icon from the Tool Catalog into the scene, or click the icon in the Add-ins tab, in the IC Mechanical group; this dialog will open.

ProActive Manager

1 Left

In the Left Side scene management, here you can choose how to view the scene browser, in fact the icons in the upper part are used to turn on/off, suppress…

While in the bottom edge there are four tabs, the first is the Scene Browser, the second By Type is a tree divided by type of elements grouped automatically into: assemblies, parts, sheetmetals, 3D curves, external links, fasteners and steels; the third tab Included in BOM separates the elements included or not included in the bill of material; finally, the fourth tab Serach containing the results of the search function. see more here…

2 Right

On the Right Side there are also here some tabs whose number changes according to what is selected in the browser on the left.

There is the Scene tab which shows the properties of the open * .ics file. The BOM tab to manage the data of the bill; the Element tab which shows the geometric data of the elements. The Configuration tab that manages the configuration of the file and finally the Search tab, where you can search and manage searches for elements in the open file. see more here…

3 Bottom

In the Bottom Side of the dialog the Bill Of Materials is shown (normally it is hidden, to show it you have to create a BOM ).

Above the BOM grid there are icons for Exporting the BOM, printing it and managing its display, while below, one or more BOM tabs, with the name of the selected file or assembly, and in square brackets which [BOM configuration name] was used to create it. see more here…

To view the BOM you want, you need to create a configuration and set it in BOM settings to choose what to include, and how to format the different columns, etc.

Subsections of ProActive Manager Dialog

Left panel - Browser

ProActive Manager

Icons

In the upper left part of the dialog box, there are some icons to control the tree view display:

ProActive Manager

ico><
Some icons appear in the TreeView to indicate that the elements contains particular information:
Assembly Name in Bold Blue Font - it means it has AutoNaming
ico>< - it means it has Attachments
ico>< - it means it has Revisions
ico>< - it means it has PostIt Note
ico>< - it means it has Status Color
ico>< - it means it is a linked file and ico>< the path.

Actions

ico>< - Select in the Scene the selected TreeNodes
ico>< - Update the TreeViews, Refresh, Expand and Collapse All
ico>< - Select Element in BOM Grid (only active when there is a BOM grid)
ico>< - Hide Selected Elements, Hide Unselected and Show All
ico>< - Ghost Selected Elements, Ghost Unselected, UnGhost All
ico>< - Zoom on Selected Item
Each click rotates the view by 90 degrees, but if the item is selected in the scene, the first click shows it in the browser and in the BOM tab
ico>< - Set Trasparent All Other Parts
ico>< - Suppress All Other Parts
ico>< - Suppress/UnSuppress the Selection
ico>< - Exchange Selection
ico>< - Create new configuration (only active when use Suppress All Other Parts)

BOM Management

icons to manage the BOM:

ProActive Manager

ico>< - Create BOM
ico>< - BOM Settings
ico>< - Open Settings Dialog…
ico>< - Open BOM Configuration Manager…

Utils

and some utility icons:

ProActive Manager

ico>< - Search by Properties
SearchThe results will be shown in the Search tab (see bottom of this page)
ico>< - Set TreeView Sort Option
TreeView SortSorts by PartName, Creation date, PartNumber or Category; the last option sets the new sorting to the SceneBrowser
ico>< - Search and Replace Text inside elements
dialog ico>< - Rename Children Parts (active only when an assembly is selected)
dialog

Tabs

In the bottom edge there are four tabs:

Scene Browser

It is the same tree view as the scene

ProActive Manager

By Type

Is a treeview divided by type of elements grouped automatically into: assemblies, empty assemblies, parts, sheetmetals, 3D curves, external links, fasteners and steels; it is also possible - with the right click - to Suppress/Unsuppress all elements in the group.

ProActive Manager

Included in BOM

Shows the elements included in the BOM, or those not included or see them both (with the combobox below you can choose how to see them)

ProActive Manager

This tab containing the results of the search function;

search for a multiple fields:

ProActive Manager

search for a Status filter:

ProActive Manager

or the result of Search by Properties.

ProActive Manager

Note

For how to set the search function see here .

Right panel - Properties

ProActive Manager

On the right side there are some tabs whose number changes according to what is selected in the browser on the left.

Scene

This tab shows the properties of the opened file (in the top grid), while in the bottom tab “Scene Properties” you can edit them or add new ones, if you want to always add the same properties in all scenes, see here.

ProActive Manager02

BOM

In the BOM tab, you manage all the data that will be used to compile the Bill Of Materials, such as PartNumber, Description and User Name (you can also change it in the browser on the left, click on the name and click again to edit), also you can set Material Name, Color and Category, while in the bottom of the tab you manage the Custom Data.

ProActive Manager

ico>< - Search Next Part with the same PartNumber
ico>< - Serach Previous Part with the same PartNumber
ico>< - Set Status Colors on the selected elements see here

import bom

ico>< - Include or ico>< Exclude Element in BOM

ProActive Manager

(If the icon in BOM is disabled, also the fields PartNumber, Description and Quantity will be disabled.)

ico>< - Set User Quantity
If it’s active, in the grid below the quantity row is activated (the item “Computed by IronCAD” disappears) and the quantity can be entered manually

Available only for Assemblies

ico>< - ico>< - Assembly Expansion in BOM

Expand or Treat as Part, for All connected instances or Only for this Assembly

ProActive Manager

Utility and Custom Data

In the left column, you can enter the Name of the CustomData, or if you click on the dropdown menu, you can choose the name from a custom list (that you can create and modify by clicking on the <New...> field) see here for set default name

CustomData

While, in the right column enter the Value of the CustomData, again if you click on the drop down menu, you can choose the value from a custom list (which you can create and modify by clicking on the <New...> field), in addition there are two other special fields:

  • <Get From Parent> If you select this option, the value of the current CustomData is obtained from the one with the same name from the parent assembly and set in the CustomData value of the part.
  • <Set To Children> When you select this option, the current CustomData value of the assembly will be set in all child items that have a CustomData with the same title as the assembly.
    These options only copy CustomData values. Copied values do not remain “linked” to the original selected value

the icon in the name cell ico>< - Deletes the CustomData field, both the name and the value
the icon in the value cell ico>< - Sets and links the current value from an Excel cell

By typing Alt+d in a CustomData or Property field, the current date will be inserted.

Utility Icons

CustomData

ico>< - Set current UserName using PartNumber
ico>< - Set current UserName using Description
ico>< - Set current PartNumber using UserName
ico>< - Set current Description using UserName
These four tools also work with an active multiple selection in the browser.

ico>< - Set UserName using CustomValueSchema
ico>< - Set All UserNames using CustomValueSchema
ico>< - Set CustomValueSchema
Sets the field to choose to change the user name:

CustomValueSchema

ico>< - Numbering Selected Elements, read more here…
ico>< - Import CustomData, import custom data from Excel file, CVS or Text file
ico>< - Export CustomData, export custom data to a CVS or Excel file (all CustomData or DefaultTitles)
ico>< - Update Excel -> Custom fields, update custom data fields linked to an Excel file, or vice versa.

CustomData Excel

Custom Data fields that are linked to Excel are yellow and there are two icons in the cell, one ico>< to view the Excel file and the other ico>< to remove the link.

Other tabs

BOM Other tabs

In the bottom area of the BOM tab, in addition to the Custom Data fields, there are also tabs for: Revision History, PostIt Note and Attachements. And here you can add or edit all these properties very quickly.

Element

In this tab you can see the geometric data of the element such as sizebox and position, and it is also possible to change the Material Name and then calculate the volume and weight and the center of gravity (if the selection is a 3D curve, it shows the length of the curve).

ProActive Manager

Configurations

The tab shows the present configurations of the file and here you can also manage them.
To manage the configurations you can also see Configurations Manager.

ProActive Manager

Here you can search and manage searches for elements in the open file, you can search across multiple fields and with different conditions, you can search only for certain elements by selecting the icons in the top bar, and you can also save the search conditions to reuse them in other files.

ico>< - Start Search
ico>< - Clear Search TreeView
ico>< - Clear Search Grid
ico>< - Add Search Condition
ico>< - Remove Search Condition
ico>< - Save, Delete, Apply Search Condition
ico>< - Search by Status Colors
ico>< - Include/Exclude Elements in the Search
ico>< - Search Case Sensitive

ProActive Manager

Note

The results of the search function are displayed in the Search tab on the left see here.

Bottom panel - BOM Grid

ProActive Manager

In the Bottom Side of the dialog the Bill Of Materials is shown, normally it is hidden, to show it you have to create a BOM.

Icons

Above the BOM there are some icons to control the grid:

ico>< - Update BOM and Import from Excel

import bom

ico>< - Export Grid BOM in txt format or in other formats:
see here how to set Export BOM

export bom

ico>< - Print Preview Grid BOM (open dialog)

print preview

ico>< - Print Grid BOM (directly)
ico>< - Autoresize All Columns during resizin of the dialog
ico>< - Auto Fit all the columns of the BOM
ico>< - Save the Template file of Columns Layout
ico>< - Restore the Columns Layout usin Template file

ico>< - Show Parent CustomData to Children Elements
ico>< - Clear Parent CustomData to Children Elements
Show/Clear Assembly CustomData in Children Parts, only if you have enabled the “Inherited by Children” setting in a BOM configuration.

ico>< - Toggle Selection Mode
Allows you to select multiple grid cells, useful for copying and pasting them in other areas or in other applications such as Word, Excel…

ico>< - Set Custom Sort

sort

Normally to sort the grid you can click on the column name, with Set Custom Sort you can sort the grid by more than one column.

sort setting

ico>< - Set Row Filter

Row Filter

When the option is enabled, a new icon appears at the top of the rows, clicking on which brings up a menu for selecting a quick filter or a custom one.

Row Filter setting

ico>< - Open the BOM in a new dialog, (is up there on the right), effectively detaching the BOM grid in a separate window; this behavior can be set as the default choice in BOM Settings -> BOM Option Grig
ico>< - Close BOM, (is up there on the right) closes the active BOM grid.

ProActive Manager

At the bottom of the BOM there are one or more BOM tabs, with the name of the selected file or assembly, and in square brackets which [BOM configuration name] was used to create it.

In the example above there are two ones, the first of the entire file and the second of the Shaft assembly only, both with the configuration [Material_Weigth].

To view the BOM you want, you need to create a configuration and set it in BOM settings to choose what to include, and how to format the different columns, etc.

Create BOM

ProActive Manager

To create a BOM, the file (the red IronCAD icon) or an Assembly in the Scene Browser must be selected, then click the Create BOM button.

The dialog box expands at the bottom and the BOM is shown.
For an explanation of the icons, see here.

Each created BOM will appear in a new tab showing at the bottom (if it is not already an existing one, in this case it is updated).

ProActive Manager

The tab name is composed of the name of the selected file or assembly and enclosed in square brackets the name of the [ BOM configuration ] used to create it.

In the example above there are two ones, the first of the entire file CX500 Transmission.ics with the configuration [Default] and the second of the Shaft assembly only, with the configuration [Material_Weigth].

Tip

To close the active BOM tab, click the red cross icon on the right side.

Config BOM

ProActive Manager

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.

ProActive Manager

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).

ProActive Manager

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.

ProActive Manager

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.

Show all Variables available in Column Get From:

For some properties it is necessary to fill in the Option column.

Variables Typereturnsoption Name
Quantityquantity of the elements
PartNumberpart number of the element
Descriptiondescription of the element
CustomData Valuevalue of the CustomDatathe name of CustomData contained in the element, if different respect the Title
Material Namematerial name of the element
User Namename of the element
Sizebox Height of Elementtotal height of the element
Sizebox Length of Elementtotal length of the elementonly for sheetmetal, SM_UNFOLD = returns the length of the unfolded sheet
Sizebox Width of Elementtotal width of the elementonly for sheetmetal, SM_UNFOLD = returns the width of the unfolded sheet
Thickness of SheetMetalthickness value of sheet metal
Total Weight of Elementsweight value of all elements
External Linked Statusstatus of external link element true/false
External Linked Filepath of the external link element
Scene Propertiesfile property valuethe name of Property contained in the file, if different from the Title
Combo 1the result is get from an expression string.ex: <Description> - <Sizebox Length> x <Sizebox Width>
Longest Value of Sizeboxthe longest value (among L W H) of the sizebox
Parameter Valueparameter valuethe name of Parameter contained in the element, if different from the Title
Expression 2this field evaluate an expression using the MSExcel syntaxex: CONCATENATE ([Description] , "-" , "Tot.Weight gr.=" , ([Qty]*[W]*1000))
Expression Hidden 2like expression, but the result is not visible in the gridex: [Qty]*[W]*100 (Qty and W are Title)
Position X - RelativeX value of the relative position
Position Y - RelativeY value of the relative position
Position Z - RelativeZ value of the relative position
Position X - AbsoluteX value of the absolute position
Position Y - AbsoluteY value of the absolute position
Position Z - AbsoluteZ value of the absolute position
Row Counterthis value BOM row index+ starting value (optional, otherwise it starts from 1)
Surface of Elementsurface value of all faces of the partinsert unit of measure: mmq cmq mq ftq inq ydq (default mmq)
in case of tube, rectangular, and square hollow steels calculate only the external surface
+TopFaces also calculates the area of the faces at the top and bottom of the steel
Volume of Elementvolume value of the element
Weight of Element in Waterweight value of the element in water
Mass Densitymass density value of element
Weight of Elementweight value of the elementto calculate Steels without cuts <STEEL_RAW>
Length of Sweepvalue of the length of the guide curve of the sweep
Where Usedthe part number of the parent assembly
Status Color Markerthe status of elementsee here how use Status
Area of Unfold SM Partthe area of unfolded sheet metal0 or empty for real unfolded face area
1 for bounding box unfolded face area
Perimeter of Unfold SM Partthe perimeter of unfolded sheet metal0 or empty for external perimeter
1 for internal perimeters (es. the holes or cuts)
2 for the sum of external and internal perimeters
SMBend infoobtain the number and radius of bends of a sheet metal partONLYQTY for obtain only the number of bends
Price in IPROBOMPriceListobtain the price stored in the file IPROBOMPriceList.xlsxsee here how use PriceList
Element IDreturns the ID of the elementthe text entered as an option will be prefixed to the ID number

FieldTags accepted
1. ComboInsert 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: <PartNumber> <Description> <@CustomName> <Sizebox Height> <Sizebox Legth> <Sizebox Width> <MaterialName> <Quantity> <ElementName>
2. ExpressionInsert 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 fieldif 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
if you add <SUM> in any numeric Option field, it will sum all numerical values

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; it should be used in conjunction with the commands in the BOM grid “Show Parent CustomData to Children Elements” and “Clear Parent CustomData to Children Elements”.

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.

ProActive Manager

The icons on the left are for: ico><

  • 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: ico><

If you turn on the advanced setting, the dialog box expands down and there are three sections here:

ProActive Manager

Export BOM

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 Bill of Materials to an Excel file, you can designate a specific initial template file and sheet for the BOM to be exported to. This feature allows for greater customization and efficiency in the export process.

Folder for VirtualCode Datafiles

If you want to replace real PartNumbers with virtual codes, enter the search path here.

Subsections of Config BOM

Management of Price

ProActive Manager

Possibility to manage the prices related to elements in the ProActveBOM. All the prices and the rules about the price calculation are store in the file IPROBOMPriceList.xlsx, stored in the ..\Prefs\ folder of IC-Mechanical.

The meaning of the fields is:

  • PriceCode/PartNumber: This is the key search about the price; it could be a custom data named PriceCode or, if the custom doesn’t exist, the PartNumber of the element.
  • Price: It’s the unitary price to be used for the elaboration.
  • Unit of Measure: That is a integer value that define the way to calculate the final price; at the moment, the available values are:
    • 1 - Unit Price
    • 2 - by Linear Meter
    • 3 - by Square Meter
    • 4 - by Cube Meter
    • 5 - by Kg Weight
    • 20 - by Linear Millimeters
    • 30 - by Square Millimeters
    • 40 - by Cube Millimeters

In order to have the Price reported in the BOM, it’s necessary to define a field in the BOMConfig related to the Price:

ProActive Manager

  • All the parts or assemblies (treated as part) are elaborated in order to get a price.

When the field related to Price is defined, the elements in the scene are elaborated in this way:

  1. If the element has a custom data named PriceCode, this will be used to search a correspondence with the first column of the Excel file.
  • If PriceCode is not defined, it will be used the value of PartNumber.
    • If in Option of GetValue in IPROBOMPriceList you use <MATERIAL> tag, will be used the value of Material.
    • If in Option of GetValue in IPROBOMPriceList you use <PARTNAME> tag, will be used the value of PartName.
    • If in Option of GetValue in IPROBOMPriceList you use <PARTNUMBER> tag, will be used the value of PartNumber.
    • If in Option of GetValue in IPROBOMPriceList you use <MyCustomTitle> tag, will be used the value of MyCustomData
  1. After the calculation, the resulted price will be reported on the grid.
  2. If the correspondence is found, the price is calculated using the properties (Unit=quantity, Linear=length, Square=area, Cube=volume, Kg=weight) of the element.
Info

Price calculation is also done using the “formula” in Excel’s Price column; this allows the use of a formula within square brackets [ ], where the valuation variable is defined by the % character.

For example, one can evaluate the price based on whether the length (or weight) is greater or less than a given value.

Examples of formula are:

  • [IF(% > 200, 20, 10)]
  • [SWITCH(%; 100;10;200;20;300;30; 500)]
  • [IFS(% >= 300; 30; % >= 200; 20; %>=100; 10; TRUE; 1)]

As example this formula:
[IF(% > 200, 20, 10)] with Unit of Measure set to 20,it means:

If the calculated Length is greather of 200 mm, use the price 20. In other case use 10.

ProActive Manager

Note

When the element is an assembly, all the children’s elements are evaluated, and the sum of the prices is reported in the grid. ProActive Manager

BOM Settings and Preset

ProActive Manager

Before creating the BOM, you can select a configuration to use, a filter by category, the types of items to display in the BOM and some other options. First, click the drop-down menu (arrow) on the BOM Settings button.

ProActive Manager Configuration

Choose which BOM configuration to use (how to create the configuration).

ProActive Manager Category

Choose an optional filter by Category (how to create the Category filters).

ProActive Manager Status

Choose an optional filter by Color Status (how to use Color Status).

ProActive Manager Type

The BOM Type of the flyout menu allows you to check which parts and how should be displayed in the BOM and how to create the BOM itself.

ProActive Manager Options

The BOM Options of the flyout menu allow you to include additional BOM data and set other options.

Subsections of BOM Settings and Preset

Status Color Filter

The Status Color Filter in the pop-up menu allows you to choose which parts to display in the BOM based on their assigned status.

ProActive Manager Status

You can choose to include/exclude all states or just some of them.

For how to activate the display of the Color States in the TreeView see here BOM Settings Dialog

ProActive Manager Status

For how to assign color status to elements, see here, for how to use the status in the BOM, see Config BOM, and for how to search for elements based on their status, see here.

BOM Type

The BOM Type of the flyout menu allows you to check which parts and how should be displayed in the BOM and how to create the BOM itself.

ProActive Manager

Top Level BOM

Displays only the elements in the top level of the Scene Browser or the elements below the selected assembly.

Only Parts BOM

Show parts only and excludes all assemblies that use the Expand option in BOM; however, assemblies that use Treat as Part are considered “parts” and appear in the BOM.

Flat BOM

It shows a flat structure as BOM Parts Only, but here you can also choose to include or not include the assembly using Treat as Part or Expand.

And whether to include in count the children parts of Assemblies not in BOM.

ProActive Manager

With the Options menu you can select how assemblies using the Treat as Part setting should be handled and whether they should be shown (or not shown) in the BOM.

Treatment

  • Treat as Assembly - forces all assemblies set to Treat as Part to expand (so ignore treats as part).
  • Treat as Part - then use Treat as Part just as they are set.

Add to BOM

  • Add the item to the BOM - then show these assemblies as parts in the BOM.
  • Don’t add the item to the BOM - so do not show these assemblies in the BOM.

Structured BOM (Stop on Assemblies Treated as Part)

It does not show parts that are included in assemblies set as Treat As Part. The generated BOM will manage the element numbers in different columns (Level 0, Level 1, etc.) thus re-applying the Scene Browser tree.

Multi Level BOM (Force Expand on All Assemblies)

Shows all elements below the selected layer, even if assemblies use the Treat as Part setting. This is a great way to create a complete list of projects with all components.

Multi Assemblies BOM

Automatically create multiple tabs with BOMs, where each tab is a BOM of each assembly in the 3D file.

The Level n° option allows you to set the depth of the search in the tree.

A super fast way to create multiple BOMs at once ;-)

Multi BOM by Category

Automatically create multiple tabs with BOMs, where each tab is a BOM divided by Category.

Youtube video - BOM Type
Tip

If you want to create a specific BOM configuration for each category, you must give the Configuration the same name as the category.

ProActive Manager

BOM Options

The BOM Options of the flyout menu allow you to include additional BOM data and set other options.

ProActive Manager

Include All CustomData

Adds a column for each custom data value found in parts/assemblies. Items that do not have a certain custom value will have one blank box per row, which can also be manually filled in directly in the paragraph list, it’s also an easy way to fill in the BOM.

Include Unfolded SheetMetal Parts

It also shows the Unfolded SheetMetal Parts in the BOM. By default these are not displayed in IronCAD unless they are explicitly unfold.

Include Suppressed Elements

It also includes all the off (suppress) parts/assemblies, so you can get a complete list of everything in the 3D scene.

Counts Parts using Assembly Number

It means that the number of a parts is calculated from the number of the assembly in which it is included and not how many parts are actually contained in the assembly.

Include Element having Empty PartNumber

Items that have no item PartNumber are also counted and give them a “ND_xxx” temporary serial number. This number is not actually saved in the item but is only displayed in the BOM.

Include Element having Empty Description

Items that have no item Description are also counted in the BOM.

Elaborate Children of Not in BOM Assemblies

Also considers parts of assemblies not in the BOM, so they are processed and shown in the BOM.

Compact Layout for Structured BOM

Merges the Levels columns of the BOM Structured and Multi Level into one and creates the numbering based on the nesting of parts and assemblies ex. 1, 1.1, 1.2… 2, 2.1, 2.2, 2.2.1, 2.2.2…

Set Category Filters

Set up filters for categories, so you can create BOMs that include/exclude certain categories.

ProActive Manager

Categories can be created with the Category tool or in the BOM tab of the ProActive Manager.

Update Excel->Custom during the BOM

If there are CustomData linked to the Excel file, they are updated automatically.

BOM Settings Dialog

ProActive Manager

In the BOM Settings dialog you can set the default values for the BOM Type and BOM Options for the Grid,

ProActive Manager

and for the export options to Excel.

ProActive Manager

File and CustomData Properties

You can also always and automatically assign additional properties to all files you open in: Default File Properties and/or Default CustomData Properties.

ProActive Manager

In CustomData, you can choose to assign them to assemblies only, parts only, or both; and the field name will be set automatically to the assembly or part see here for more options.

Work in BOM

ProActive Manager

Once the BOM is created, you can easily see which parts and assemblies do not have certain types of attributes or values and write them directly into the BOM cell.

All values written in the cells (which are actually the properties and customdata of the parts/assemblies) are added directly to each object, so there is no save button.

In the upper right part of the window is the BOM tab; there you can see (and also edit) all the properties of the selected part/assembly.

To view the properties of another part/assembly, double-click on another row in the BOM or select another part of the tree.

Changes made to the BOM grid are reflected in the BOM tab.

Double-clicking on a BOM cell updates and selects the corresponding element in the Scene Browser.

Export BOM

ProActive Manager

On the left side, directly above the BOM grid, there are three buttons dedicated to exporting and printing.

ico>< - Export Grid BOM in txt format or in other formats:

You can choose between:

  • MSExcel - exports the BOM to an Excel file
    • This item is visible only if multiple BOM sheets are open:
    • all Sheets to MSExcel files - exports all BOMs to separate Excel files.
    • all Sheets to a single Excel File - exports all BOMs to a single Excel file with each BOM in its own sheet.
  • PDF - exports only the BOM grid
  • PDF with Preview - exports the BOM grid and generates a preview of the element for each row
  • XPS - exports only the BOM grid
  • MSWord - exports only the BOM grid
  • CSV - exports only the BOM grid
  • Open File Automatically On Export - is an option that opens the file after exporting.
Tip

For exporting to Excel you can activate multiple options such as two preview types and file properties, see here.

ico>< - Print Preview Grid BOM (open dialog), creates a preview where you can see how the BOM grid looks on the press sheet and you can also print directly to the default printer.

ico>< - Print Grid BOM (directly), prints directly to the default printer without any preview.

If you want a different order of the grid columns, you need to open the configuration manager and change the order in the configuration list and then update the BOM again.