Importing BOM data

Importing BOM data bruce Wed, 06/24/2020 - 12:11

BOM data is typically a list of components and their properties. It's main purpose is to specify the components for purchasing. Macaos can import BOM data from a text file or from an Excel .xls spreadsheet file. In both cases, the data must be in a table form, where each row represents a component and each column represents a single component property (such as designator, manufacturer part number, value, etc).

Click on the Import button in the Bill of materials actions toolbar to select a BOM file for import. Alternatively, click on the small down-arrow in the lower right corner of the button to import a file which is already attached to the product.

A spreadsheet file is loaded directly into the Import BOM dialog box. When importing a text file, the format must first be specified (much like when importing PnP data). It is also possible to copy data from an open spreadsheet directly into the Source BOM file grid (by right-clicking the cell that will become the top left corner of the pasted data).

Import BOM data

To import the BOM, do the following:

  • If necessary, specify the number of header rows to ignore, and the prefix character for comment lines to ignore.
  • Where possible, the column contents are automatically identified. (This may not always be accurate, so automatic column mappings should be checked.)
  • Specify the input column numbers for the remaining output fields.
  • Specify parameters for individual columns, as necessary.

Designator: If the designator field lists multiple designators, specify the separator character (typically a comma, semicolon or space). The import module automatically converts designator ranges like C2-C4 to individual designators (C2, C3 and C4). Check off for Allow - in designator to prevent designator range conversion.

Value: Up to three source columns may be assigned to the Value column. The contents of the source columns will be concatenated, separated by a space character.

Description: Up to three source columns may be assigned to the Description column. The contents of the source columns will be concatenated, separated by a space character.

Mounting style: If no column is specified, you may select a default mounting style, which will be applied to all components. Otherwise, you must specify specify an SMD text and a Thru-hole text. Components which match one of these texts will be assigned a mounting style of SMD or TH (respectively). The mounting style will remain unassigned for components which do not match.

Do not place: Specify a Do not place text. Components which match this text will be marked as not to be installed.

Additional info: Up to three source columns may be assigned to the Additional info column. The contents of the source columns will be concatenated to the component’s Original description property, separated by a space character. (The Original description property is the normally the component description imported from Pick and Place data.)

Supplier name and SKU: Supplier names and SKUs must be paired. They can be taken from a single source column or from two source columns. If there are multiple values in a column, then a separator character must be specified. Typical separators are comma, semicolon or space.

  • If the supplier name and SKU are in a single column, specify the source column as the Supplier SKU column and specify the character that separates the names and SKUs. (The supplier name column must be set to zero.)
  • If the source has separate columns for supplier name and SKU, specify both source columns. If each column has multiple values, then specify the character that separates the values.

It is possible to edit the text in either grid, by clicking on a cell and entering the desired text. You can change the text in an entire column, or in selected cells, by right-clicking on the grid. It is also possible to add an extra column to the source grid (for example, to add mounting style data). Note: In most cases, it is best to edit the source grid, since changes to the parsed grid will be lost if any of the column mapping parameters are changed.

Check off for Save settings to store column mapping parameters as default values for future BOM import. Click on the Clear stored settings button to reset all column mapping parameters and default values.

If there are components that might need further attention after import, set a check mark by each of them. This will create a component alert, and the component will be highlighted with red text in the component list. Note: Component alerts are not saved with the product. You should resolve all alerts before closing the ADM.

Components may be automatically marked as allowing equivalent or better alternates to the specified manufacturer part number if any of the Mark as Equivalent or better boxes are checked. By default, all components of the specified type(s) will be marked. To exclude components from being so marked, their designators should be listed in the except list, separated by commas (without spaces).

Once the data format has been correctly specified, click the OK button to import the data.

Components in the BOM which do not already exist on a component layer are automatically placed in a 10 mm grid to the left of the PCB. These should be moved to their correct location.