PartsBox offers a powerful BOM (Bill of Materials) import feature, allowing you to bring in BOMs from various CAD/eCAD packages in CSV or TSV format. This functionality lets you quickly transfer your design data into PartsBox for efficient inventory management, purchasing, and production.
Any CAD program that can export a BOM in CSV or TSV format can be used with PartsBox. Customer have successfully imported data from KiCad, OrCad, Cadence Allegro, Mentor PADS, Proteus, EAGLE (now part of Autodesk Fusion), Diptrace, EasyEDA, gEDA.
To create a new project by importing an existing BOM, use the 'Import' button in the 'Projects' section. This will prompt for the file to be uploaded. Upload a CSV/TSV file exported from your CAD program.
PartsBox will try to parse your BOM and display the preliminary results. Please adjust the 'Field separator' and 'Character encoding' options first until the BOM is correctly parsed and the first few example rows are shown. Please make sure that the 'First line contains column names' checkbox is correctly set for your BOM.
Afterwards, adjust the mapping from BOM columns to PartsBox BOM fields. There is a 'Guess' button which will use heuristics to make a best-effort guess at column mappings, but please always review the results carefully.
The imported BOM is shown below the column mapping table, once you map the required columns.
The available BOM field choices are:
You can import BOM entries either when creating a new project, or into any existing project.
To save time on future imports, you can save your column mapping settings as a preset for quick access later.
After importing a BOM into PartsBox, each line that represents a part has to be matched to a specific part that has already been created. There is no way to automatically create parts while importing a BOM because of ambiguity and potential costly mistakes: there are many parts with the same name. The matching can be done automatically if the parts have already been created in several ways that are tried in order:
It is highly recommended to store either ID Anything™ codes or CAD keys in the CAD part database and export those in the BOMs to get quick, effortless and precise matching.
Entries which have not been matched to parts will be highlighted. For those entries, you can either create additional parts and retry the matching (see below), or open each of the entries and do the matching manually, possibly also creating a new part in the process. It is also possible to un-match the entry if you made a mistake.
To retry the matching, you can select some or all entries in the BOM and use the 'Selected | Match entries' menu option. This will retry the matching for all selected entries. You can also un-match multiple entries if needed.
PartsBox takes BOM management a step further by allowing you to include services or labor entries in your BOMs. This feature enables you to account for costs associated with PCB assembly, testing, packaging, or any other relevant services. These service/labor BOM entries can have offers attached, just like parts, enabling accurate pricing of the entire production process, not just the components.
Offers for service/labor BOM entries share similar characteristics with part offers:
By leveraging PartsBox's comprehensive BOM import capabilities and the ability to include services and labor, you can efficiently manage your inventory, purchasing, and production processes, ensuring accurate costing and streamlined operations.
BOM entries are checked for correctness, to help avoid mistakes and to allow structural BOM editing. The quantity for a given line item must match the number of designators. For example, a BOM entry with a quantity of 2 and designators C1, C2 is correct, but a quantity of 2 and a single designator C1 is likely a mistake. PartsBox displays warnings when this happens, and this will also make merging BOM entries with these mistakes impossible.