Importing data into DMS can be accomplished by either using a formatted text file or importing data from an external database via SQL.  For importing and exporting via text files, see Text File Importing and Exporting.  To import via SQL, see SQL Importing.

When importing data to DMS, retain and merge is used for making changes to existing jobs.  Retain and merge specifies which fields may be changed during an import and which fields cannot be changed.  The retain and merge settings apply to both the text file importing and SQL importing.

Importing has an option that enables you to modify and add to operations that are being imported via SQL or a text file by using the Import Interface Table.  As each operation is read in, and if the operation has a match in the Import Interface Table, the operation is modified and extra operations can be added to the import. 

When information is imported into DMS using a SQL script or a text file, DMS can optionally send an email to let you know the status of the import.  Use Import Email Settings to setup emailing of status reports.

DMS Auto execution commands have exit codes for SQL and Text importing as well as for Schedule Runs and Auto reporting. 

The exit codes are as follows:

SQL & Text Imports

0        Process completed without error

1        Unknown error/abnormal termination

2        Command file not found

3        Invalid auto import SQL Script name or text file name

10        Import warnings occurred but there are not any errors

11        Import errors occurred and there may be warnings as well

Scheduler

0        Process completed without error

1        Unknown error/abnormal termination

2        Invalid auto schedule run command

4        Invalid auto schedule run start date

10        Schedule warnings occurred but there are not any errors

11        Schedule errors occurred and there may be warnings as well

Auto Reports

1        Unknown error/abnormal termination

7        Report name was not given for the AutoReport command (see status file).

8        Cannot find Action Name for the AutoReport command (see status file)