The aPriori BOM Loader can import components, component specific information, and the structure of engineering BOMs. Each line of a BOM you want to import must contain data specific to a single component and data for an instance of a component must be represented on a single line.

For example, labor and material costs should not be itemized on unique rows under a particular component. Instead, labor and material costs must be loaded as columns and mapped directly to the relevant aPriori fields.

The BOM Loader imports only CSV file formats, so you must first convert Microsoft Excel or other formats to CSV files. The files must use a North American locale, so that decimals are represented by periods (.) and not by commas (,) as in EU locales.

Column headings must contain the names of the attributes you intend to map to aPriori fields in the first row of the CSV file. The BOM Loader requires that the following aPriori fields be mapped to columns in your CSV file:

Required user defined attributes for component must also be mapped. For more information about user defined attributes, see the aPriori System Administration Guide.

aPriori will create assembly components as inferred by the BOM Loader’s assumptions. For more information, see BOM Loader assumptions below.