...
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
...