CSV file for EBOMs
Each row in the CSV file contains product data for one article. An article can be a subassembly, or a single part.
- Article number
The article number is the number associated with that particular article or subassembly. It should be unique within your organisation. The article number is usually either determined by a Product Data Management (PDM) system, or by an Enterprise Resource Planning (ERP) system. If you have neither, you'll have to create your own numbers.
- Quantity
The quantity of the article in that particular place in the EBOM hierarchy.
- Article name
The description of the article. Don't make them too long, yet it's useful to make them so that humans can interpret them easily.
- Revision
The revision of that particular article. This can be numerical (1, 2, 3, and so on) or alphabetical (A, B, C, and so on).
- Unit
The unit measure of the article. As a default, that can be 'Pieces', 'Gram', 'Kilogram', 'Liter', 'Milliliter', 'Meter' and 'Millimeter'. If left empty, Baseboard assumes 'Pieces' by default.
- Parent article number
This is where the hierarchy comes in. It's the article number of the subassembly of which this particular article is a part. If left empty, Baseboard assumes this article to be a 'top level' article, meaning it is not part of any subassembly.
For the CSV, make sure to always use headers. An example:
Article number | Quantity | Article name | Revision | Unit | Parent article number |
M1001 | 1 | AR4 Assembly | A | Pieces | |
M0049 | 1 | J1 Base Assembly | A | Pieces | M1001 |
M0001 | 1 | J1 Base Plate | A | Pieces | M0049 |
M0002 | 1 | Turret Housing | A | Pieces | M0049 |
P0043 | 4 | M4x10 set screw | A | Pieces | M0049 |