Starting with version 4.12 it is possible to automate the part selection for job creation by importing a Magics CSV report. The magics CSV import functionality is released with version 4.12 and needs to be activated in the admin panel under Organization → Switches.
The Magics CSV file can be imported during job creation to automatically match parts and their individual quantities with the build generated in magics. This allows for major time savings during job creation while at the same time minimizing human error and ensuring correct data.
In order for the matching logic to work, the following prerequisites need to be met in the 3YOURMIND MES:
MES activated
Order updated to any status of the “in progress” category - relevant parts are existing in MES
Workflows and workstations configured
Workflows assigned to parts
Part_ID set as first variable in the file naming format and is followed by a dash “-” in the configured format
Each part copy is written in a separate line (Setting in Materialise Magics for Build Reports)
Requirements for the Magics CSV:
3D files need to be imported to Magics with the part_id at the beginning of the file name
A Magics report needs to be exported and saved as .CSV
The names of the 3D files need to be written in the first column of the CSV
Each copy of a part in the build needs to be written to the CSV template in a separate line (e.g. a part with a quantity of 5 needs to have 5 individual lines in the CSV)
The CSV file needs to be exported in UTF-8 format
Starting with version 4.14 the Magics CSV import functionality has been improved, ignoring the following cases to succeed with the import and matching of parts and quantities:
empty lines are in the CSV
unknown parts are in the CSV
part quantity in the CSV is higher than in the MES
Job is created with available quantity in 3YD MES
An example CSV containing only the needed information is shown below. The following file represents a build containing part #437 with a total quantity of 5 (number of lines are counted) and #438 with a total quantity of 3.
437-269309_O1-pa12-10_optimized_1 437-269309_O1-pa12-10_optimized_2 437-269309_O1-pa12-10_optimized_3 437-269309_O1-pa12-10_optimized_4 437-269309_O1-pa12-10_optimized_5 438-269309_O1-pa12-10_optimized_1 438-269309_O1-pa12-10_optimized_2 438-269309_O1-pa12-10_optimized_3