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

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.

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.