Export Profile Wizard
The ATR CustomTools Export Profile Wizard is a simplified tool for creating a ATR CustomTools Export Profile. The created profile can be used to produce a simple and customizable SOLIDWORKS BOM Excel Report.
The wizard creates a simplified starting point for an Excel Report profile, which you can further modify via ATR CustomTools Options, in the more advanced and powerful settings of Export Profile Editor. In the editor, you can also define other types of export handlers: XSL/Script, Cloud Connected, Odoo ERP, or Dynamics NAV integration.
-
Selecting the ATR CustomTools Export command automatically launches the
Export Profile Wizard if:
- No Export profiles are defined in the currently active ATR CustomTools Profile
- Enable Wizard in Command Manager is set in the Export Profiles Options
- If there are some Export profiles, the Export button in the ATR CustomTools Command Manager tab will have <Create New Export Profile> item for launching the wizard. Enable Wizard in Command Manager option rules the visibility of this item.
- Launch Wizard... button in Export Profiles Options.
Select the structure type to export. Parts only type usually works well for packing lists, purchase orders, or similar listings, whereas Full structure is often used during the assembly or manufacturing process.
| Parts only | Will list all part components that are not Excluded from BOM. Also assembly components will be listed, if they have Hide option selected for Child component display when used as a subassembly setting in their Configuration Properties. This is the same behavior as in SOLIDWORKS BOMs. Quantities shown in this BOM Type are total quantities in respect to the main assembly. |
| Full structure | Will list all non-suppressed components that are not Excluded from BOM. Child component display when used as a subassembly setting is respected by default. The report uses a small set of Excel columns to mimic the design's structure indentation with Part Number. |
| Include cut list items | Will list also cut list items. This option is available only if Full structure is selected. |
Select configurations to export.
| Active/Referenced Configuration | Exported configuration is either the active configuration of the currently open design, or the referenced configuration of the exported component. The report will be an Excel document with a single sheet. |
| All configurations | Each configuration structure is exported to a separate Excel sheet of the same document. |
This page is only visible if the current ATR CustomTools Profile has Model Properties.
To export ATR CustomTools Properties from your models, you can drag & drop items from the ATR CustomTools Attributes listing to the Exported Columns listing.
Three compulsory fields are automatically added. These fields cannot be removed with the wizard.
| Part Number | SOLIDWORKS Part Number. By default it is the Document Name but it can also be configured to be Configuration Name or User Specified Name at the design document's Configuration Properties. The wizard locks this as the first column. |
| Material Quantity |
For parts and assemblies, the material quantity is the reference count in the parent assembly multiplied by possible BOM quantity factor defined in the component's properties. Material Quantity is the reference count if the BOM quantity factor is not defined. For Weldment cut list items, the material quantity is the total length value of the cut list item. For other cut list item types it is the reference count. |
| Preview | Preview picture of the component embedded to the Excel column. Part preview is used for cut list items by default. The wizard locks this as the last column. |