Using basic capabilities > Overview of using basic capabilities > Importing and exporting information > CSV and TXT format > Importing and exporting information through CSV
  
Importing and exporting information through CSV
System Architect enables definitions to be imported and exported from files that are in text format or comma‑separated value (CSV) format. This facility is accessed by selecting Dictionary > Import Definitions or Dictionary > Export Definitions.
A design represented by a diagram in System Architect consists of two basic components: the graphical diagram and the underlying symbol definitions. You can import or export only the definitions, not the graphical components of the diagrams.
Another way to import CSV files is by using the User Auto-CSV Import facility, which is described in the following subtopic.
User Auto-CSV Import
This type of import is based on encyclopedia settings and it takes place at encyclopedia open time in silent mode, meaning no user interface, messages, or reports will be presented.
To set up the information needed for this type of import, you must first run SAEM.EXE and select the destination server/encyclopedia the file(s) will be imported into and select Tools > Encyclopedia Settings.
You will be presented with a dialog containing the following settings:
User Auto CSV Import Enabled
Allowed values are Y or N (the default).
User Auto CSV Import Folder
The full path to a folder where the CSV files are to be located in subfolders named using the definition types. For example, if the path to the import folder entered into the encyclopedia setting is C:\AutoCSV, the subfolders to be created could be C:\AutoCSV\402 for CSV files containing UML Class definitions, C:\AutoCSV\15 for CSV files containing Entity definitions, and so on.
User Auto CSV Import Collision Options
The options are identical to the ones presented in the normal CSV import interface:
0 – Never replace existing definition (the default).
1 – Delete all fields then add new data.
2 – Update single fields when data supplied.
3 – Update single fields; clear field if no data.
4 – Updates ONLY: Delete all fields then add new data.
5 – Updates ONLY: Update single fields when data supplied.
6 – Updates ONLY: Update single fields – clear field if no data.
User Auto CSV Import Move Files If Success To Folder
Path to the directory where the successfully imported files will be moved to and where their import reports (that is, LOG files) will be saved. If no path is given or the path is invalid, the CSV files will not be moved and the LOG files will be saved in the directory the CSV files are located. The default value is empty.
User Auto CSV Import Move Files If Errors To Folder
Path to the directory where the import-failing files will be moved to and where their import reports (that is, LOG files) will be saved. If no path is given or the path is invalid, the CSV files will not be moved and the LOG files will be saved in the directory the CSV files are located. The default value is empty.
User Auto CSV Import Folder Controlled Collision Options
Y or N (the default). Y allows user auto CSV imports to use folder names to indicate the collision option and ignore the value in the User Auto CSV Import Collision Options setting. N disables user auto CSV imports collision options through folder names on this encyclopedia.
These folders must be created under the type name folders; allowed folder names are: 0, 1, 2, 3, 4, 5, 6. For the meaning of these collision options, click the User Auto CSV Import Collision Options setting.
Example: import_path\402\0, import_path\402\1, import_path\402\2, and so on.
When all of this information has been entered correctly and saved, the next time the encyclopedia is opened the import will take place. The import reports (that is, LOG files) will be saved according to the information specified. If saving the reports into those folders fails, System Architect will attempt to save them into the System Architect temporary folder.
If any of the encyclopedia settings are incorrect or missing, the errors will be logged in the SA2001.LOG file if System Architect is run with the -log command line argument.
This import will take place every time the encyclopedia is opened, until the User Auto CSV Import Enabled setting is changed to N.
System Architect provides other facilities for importing and exporting definitions to and from an encyclopedia, which include both the definitions and the graphical components of diagrams. This includes merge/extract between other System Architect encyclopedias.
See also
CSV and TXT format