Overview
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.
Standard Columns
Here is an overview of the standard columns that can - and most of them should - be part of every CSV import file.
...
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. |
Custom Property Columns
...
To import values into custom properties the column names need to match the property configuration in the admin panel. The following naming convention must be followed
variables.<name space>.<variable name>
Example
To import lead time into AMPI you add a column as follows to your CSV:
variables.custom.leadTimeExact
What values are accepted in each column depends on the property type of the respective column. The following table explains what values are expected in relation to the property type.
Property Type | Description | Example |
|---|---|---|
Boolean | Fill in values using [TRUE, FALSE] | Qualification Required = TRUE |
Choice | Slug of a choice value. Check the corresponding property in the admin panel to find out the exact slug values available. | Demand frequency = demandOneTime |
Currency | Decimal values with maximum two digits after the decimal point | Current part price = 12.84 |
Files | Attachments cannot be imported into AMPI via CSV | |
Float | Decimal numbers | Min wall thickness = 0.4 |
Integer | Whole numbers, can also be negative | Lead time = 25 |
Multiple-Choice | Slugs of choice values separated by a space " " | Manufacturing method = milling turning sheetMetal |
Size | Size (dimensions) is a special property type in AMPI. Next to the x,y,z dimension you need to provide a shape type s = {sphere, cylinder, cuboid}. | Ex. 1 Ex. 2 Ex. 3 |
String | For text fields simply fill in the text as needed. | Manufacturer = "Company XYZ" |