The CSV import is a convenient way for adding and creating multiple parts at once. Furthermore, the CSV import functionality - together with CSV export - can be used for bulk editing of existing parts.
In order to perform a CSV import, a well-structured CSV file with part data is required. A convenient way of getting a valid CSV file template is to create a CSV export and delete the parts data. A CSV export file is always a valid CSV import file.
Here is an overview of the standard columns that can - and most of them should - be part of every CSV import file.
Column | Mandatory column | Explanation | Examples |
branch | Yes | Defines the part category that this part is assigned to when importing. The category corresponds to the form you would will out when creating the part manually in AMPI. The available categories (or branches) can be looked up in the admin panel under Valid values are the slug values of each branch. | branch = sparepart |
branchIsAdvanced | Yes | Determines whether the simplified or advanced from should be loaded when editing this part. See also Branches | branchIsAdvanced = FALSE |
status | No | Defines the part status that is assigned to this part when created. The available statuses can be looked up in the admin panel under Valid values are the slug values of each status. | status = draft |
author | No | Optional column during import User name of the user that should be assigned as part author. If column is not part of the import file, or value is blank, then the user performing the CSV import will be set as part author | author = xyz@3yourmind.com |
shortId | No | Can be used to match to be imported parts with parts already in AMPI. If shortId already exists, then CSV import will update the existing part with values from the CSV import instead of creating a new part. | shortId = P-12345 |
values.standard.name | yes | The name of the part. | Name = "Tube connector metal" |
A number of columns are ignored by the CSV import if they are part of the import file. Those columns are
Column | Description |
|---|---|
All score columns | Scores are always calculated inside the software, hence ignored during CSV import. |
values.standard.attachments | It is not possible to upload attachments via CSV, therefore this column is ignored. |
stl_file_id | It is not possible to upload 3d files via CSV, therefore this column is ignored. |