We now support auto-reconciliation of BOMs that are uploaded along with your design files. 

Please note that this is a relatively new feature and thus the following guidelines need to be followed to ensure that your BOM is utilized in the auto-reconciliation process:

Basic Requirements:

  • Only .csv or .tsv files are accepted. 
  • The BOM must be uploaded at the same time a new project or a new revision is created.

File format requirements

The file should conform to RFC 4180 with the following exceptions

  • The column separator may be either "," or tab or ";"
  • The line ending may be any valid line ending, i.e. Windows, Linux or Macintosh line endings.
  • Empty lines are allowed.

There has to be a header row identifying the columns. 

  • Other content is allowed before the header row and will be ignored.

Take note that as per RFC 4180 if the content of any column field contains the separator character then it needs to be quoted, the only difference is that the separator character is not necessarily ",".

  • So for example if the content is one, two or three then it should appear in the file as "one, two or three" 

File content requirements

The following data must be supplied:

Reference designators

  • A comma separated list of identifiers that unambiguously identifies a component in the electrical schematic or on a printed circuit board.
  • Note that if the column separator is "," then this field must be quoted when it has more than one identifier because "," is used to separate multiple identifiers.
  • An identifier must not include the "," character because it is used as the separator when multiple identifiers are present.
  • This column is used to associate the data from the rest of the row with the imported Project BOM line.

Manufacturer part number 

  • (MPN) The MPN will appear on the Project BOM line as the BOM CSV MPN attribute.

The following data may additionally be supplied:

Manufacturer

  • The name of the manufacturer which matches the MPN.
  • The manufacturer name will appear on the Project BOM line as the BOM CSV manufacturer attribute.

Distributor part number 

  • (DPN)The DPN will appear on the Project BOM line as the BOM CSV DPN attribute.

Distributor

  • The name of the distributor which matches the DPN. The distributor name will appear on the Project BOM line as the BOM CSV distributor attribute.

Description

  • A free form description of the part.
  • This is not currently added to the Project BOM line as an attribute.

Quantity

  • The number of components for this BOM line.
  • This is not currently added to the Project BOM line as an attribute.

Accepted Column Names

The following names are accepted for the different columns (difference in case is ignored):

Reference designators

  • designator
  • reference
  • references
  • position
  • ref des
  • reference designators
  • referenceDesignators
  • reference\ndesignator
  • reference(s)
  • referencedesignators
  • refdes
  • parts

Manufacturer part number (MPN)

  • manufacturer p/n
  • manufacturer part number
  • manufacturer part number 1
  • manufacturerpartnumber
  • manufacturer part #
  • part number
  • partnumber
  • mpn
  • designation
  • manufacturer_pn
  • manufacturer pn
  • mfg pn
  • pn
  • manufacturer_1_part_number
  • lcsc part #
  • manufacturer_part_number
  • mfr part number
  • mfg p/n

Manufacturer

  • manufacturer
  • manufacturer 1
  • mfg
  • manufacturor
  • manufacturer_1
  • manufacturer_name

Distributor part number (DPN)

  • distributor part number
  • dpn
  • supplier p/n
  • supplier part number
  • supplier part number 1
  • digikey part
  • vendor part number
  • s1 part number

Distributor

  • supplier
  • supplier 1
  • vendor
  • distributor

Description

  • description
  • part description

Quantity

  • quantity
  • line quantity
  • qty


For automatic reconciliation you may alternatively specify your part numbers directly in your EDA tool: http://docs.circuithub.com/managing-your-projects/how-should-i-specify-part-numbers-in-my-eda-tool

Did this answer your question?