| Purpose & Benefits |
|---|
| For Manufacture feature users, this function allows you to create and update BoM Assembly processes and BoM Assembly records automatically by importing data from an ASCII CSV file. |
The Product records for both the Assemblies and their components must already be setup in TASBooks (via program 5.1.1) – MultiTAS will not create these records.
Important
The file containing the records for import must be output from your third party software or spreadsheet as a CSV file and stored in an accessible folder. The order, format and size of the fields/columns for each record are critical for the import to succeed. Full details of the current file specifications, which must be used to output your data from your third party software, are documented separately in TAS Data Transfer File Specs which you can obtain from the Infoplex website, together with a TAS Data Transfer Toolkit containing sample files. It is crucial that you and/or your third party software provider follow these specifications. The specifications also give you useful information about how the program behaves if the import file contains blank or invalid data in the various fields/columns.
Click the […] button to locate and load the CSV file containing the data to be imported. When you click the Import button, an ASCII text log file is created in the same folder as the import file. The log contains details of each assembly processed and any errors encountered during the processing run. You should check this file after every run.
For processing to continue successfully, the Import ASCII CSV file must conform to the Assembly Import specification. The file is read sequentially and its records are checked against the BoM Process and BoM Assembly files. If an assembly exists the records are updated with the ASCII details. If the assemly does not exist then new Process and Assembly records are created, plus related Extended Description records if appropriate.
The Progress bar lets you to see the progress of the import. The processing of hundreds of records is completed in seconds. Once the import run has completed a message appears advising of success or failure. You are informed of the renaming of the import file.
If there are any errors during the import you are informed with a message. You are also offered the opportunity to view the LOG file immediately.
The import file is renamed to help prevent processing twice by mistake and the Log file is assigned a corresponding name. This is explained in detail in the Renaming & Log Naming Convention section in the Appendices.
Click Cancel to return to the main program.