User Manual

Import BOM from a CSV file

At Production planning -> BOMs -> Import from CSV it is possible to upload many bills of materials at once, e.g. a BOMs for separate products and/or multi-level BOMs. It's also possible to update existing BOMs via CSV upload.

Jump to:

  1. How to get and upload a CSV file?
  2. Which fields can be imported for items?
  3. Example import table and file.
  4. How to update existing Bills of Materials via CSV upload?
  5. Important notes.
  6. Troubleshooting.

What is CSV? CSV (Comma-Separated Values) is a universal format for importing or exporting tabular data. A CSV file can be obtained by saving/exporting e.g. an Excel file as CSV (Comma delimited) (*.csv).

When uploading the CSV file:

  1. Select and match the names of the fields corresponding to the columns in the data.
  2. Check the "The first row is heading" option if the first row of the file contains headers. Then the first row will not be imported. 
  3. Select "Do not import" as the column type if some column is not to be imported.
  4. Click Import to upload the data into the appropriate fields of the database.
  5. If importing of some data failed, a skip file will be generated and downloaded to your computer, which indicates all errors line-by-line.  

When uploading Bills of Materials, the fields that can be used are:

Product 

The product's ID number (article code), as in Stock -> Items. This is the "Product" to which the "Part" belongs to. 

The product's ID number is required on every row (this allows importing several BOMs for several products at once). 

Part The part's ID number (article code), as in Stock -> ItemsThis "Part" belongs into the BOM of the "Product". This field is required.
Quantity

The quantity per one unit of "Product". This field is required

Notes Any notes, e.g. handling instructions.
Fixed quantity A fixed (pre-defined) amount of item which is always consumed in a manufacturing order, not proportional to the order quantity. Available, if function Fixed quantity is enabled.

 

Example, importing 2 Bills of Materials:

Product Part Quantity Notes
PROD-01 PART-01 5 BOM 1: raw material 1
PROD-01 PART-02 7 BOM 1: raw material 2
PROD-02 PART-15 3 BOM 2: raw material 1
PROD-02 PART-16 9 BOM 2: raw material 2
(Up to 3000 lines can be imported at once)

Download a sample file: import-boms.csv

Updating existing Bills of Materials via CSV upload

At Production planning -> BOMs -> Import from CSV it is possible to update existing Bills of Materials by uploading a CSV file containing the new BOMs.

Upload the new bill of materials as described in the help section "Import BOM from a CSV file". If the product has a BOM, it will be replaced, if not, a new BOM will be created.

Important!

  • If the imported file contains non-Latin characters, the file must be in UTF-8 (preferred) or Unicode encoding. If Excel is used to save the file, select the "Unicode Text (*.txt)" option in the "Save as type" field. Even though the extension of the file is TXT, it can be imported as a CSV-file.
  • The limit is 3000 lines per upload. If the file is bigger, divide it into several smaller files.
  • Since importing can be a question of trial-and-error, we strongly suggest making a back-up of the databasebefore importing. In that case, if anything goes wrong, it is always possible to restore the previous session.

Issues when importing a BOM from CSV

If importing of some data failed, a skip file will be generated and downloaded to your computer, which indicates all errors line-by-line.

There are three possible reasons for issues when you import BOMs from a CSV file:

  1. Part numbers in the import file and in MRPeasy do not match. Please use only part numbers to refer to stock items.
  2. Some parts (or the product) have not been created. All stock items must exist in the software before importing BOMs.
  3. Incorrect formatting of the import file. Please check that the file contains a column with a product's part number and that this number is set on every line of the BOM.