How to
Go to AMPI panel
Imports → Download the CSV template.
Open the template file in excel.
Fill in the rows in the following manner:
branch - select a branch configured in the platform you are uploading to. sparepart can be used as it is by default available.
branchIsAdvanced - leave as 0
status - leave as draft
author - the person’s login email that will be the designated as the part’s author
shortId - leave empty
stlFile - fill in here the file name + extension.
Delete columns beginning by “scores.” - e.g. scores.econ or scores.tech, etc.
branch, branchIsAdvanced, status, author must not be empty.
3D Files: For each row, the stlFile column contains the name+extension of the file to append - example.stl, example2.catpart, example3.sldprt, etc.
Attachments: Fill in the values.standard.attachments with the full name + extension of the file: ex: drawing.tiff, drawing2.pdf, etc
Note: If you are nesting the drawings/3d models inside a folder, the import.csv must contain the path. Example: My zipped folder called import has within it:
The import.csv.
A folder called 3DModels with the files inside.
→ Each row in the import.csv will have the following path mentionned in the stlFile column: 3DModels/example1.catpart, 3DModels/exampl2.sldpart, etc.
It is required to save the file under the name “import.csv” and in the csv format.
Select the import.csv and 3d files you wish to import > send to > compressed (zipped) folder
The zip file structure then becomes:
9. Go back to the platform and select Imports > New import. The dialog box for the import file selection opens. Click on select file. This opens another dialog box in order to select the folder/file you wish to upload.
10. If only CSV files show, click on all files, select your folder and start the upload.
Click on start to begin the upload
The import prompt - a first line of defense against errors
The import dialog box is capable of detecting incorrect formatting at a core level. It will not evaluate if the part data is correctly formatted (this comes in a second step). However, it will ensure that the main parameters used for the upload process are correctly formatted.
Examples of errors during import:
properties are unknown
the file is incorrectly formatted
In the case of the latter, this is generally due to the csv format in excel being regional. The csv that gives the above error is formatted as:
It is important to save the file correctly splitting the columns :
Steps during the upload
The steps during the upload process are:
Validation pending
Validation Success
Import Success
In case of failure:
Validation Error
Validation Pending
Immediately after selecting the file to import, the platform will start validation. This process ensures that every row and therefore part being uploaded is correctly configured.
Validation Success
In the case that the validation is successful, the import line will update from pending to success.
The steps that follows is:
Validation Success
This means that the file is correctly configured and no further action is required.
In case of error during validation, the user receives:
Validation Error
This state of error represents a correctly configured file, as the platform can locate all the necessary data within it. However the data in the file itself can be incorrectly formatted. Such as having too many decimals or incorrect wording inside a part property.
By hovering on the download button enables to download the validation report. In the validation report can be found the rows where an error occurs. Fixing these rows in the original import file and re-uploading the file will result in a successful import.
