The Auto SQL Import Resources command enables you to import resources into DMS via a predefined SQL script.  This command is the same as selecting the Interface | SQL Import | Resource Import via SQL manually from the DMS menu.  The SQL script is defined using Interface | Import Settings | Resource Import SQL Scripts.

In order to import resources into DMS automatically, the user name provided for the login must have access to the “Enable Auto User Login”. 

The parameter for the automatic import jobs is:

       AutoSQLImportResources=command file        

For example, to login to the database ProdData with a user name of Frank Jones to import resources via an SQL script using the command file C:\Program Files\Dynafact\ImportRscCmd.TXT the following would be used:

"C:\Dynafact\Production\DMS\DMSEnt.exe" "UserIniFolder=C:\Dynafact\Production\DMS\User\" “AutoUserName=Frank Jones” DatabaseName=ProdData “AutoSQLImportResources=C:\Program Files\Dynafact\Import Job  ImportRscCmd.TXT"  "AutoLogOut"      

The “command file” is an existing text file that holds the SQL import command information.  The command file parameters must never be surrounded in quotation marks even if the parameter has a space in it.  The following commands are given in the schedule command file: 

1. SQLScriptName =(The name of the existing DMS SQL script to run)
2. ReportStatusFilename=(Filename to write the import status and any errors to.  If not given, the default filename of import folder\ ImportResourceSQLStatus.TXT will be used.

The following example shows a command file that will run the SQL script "Import Resources" and write the import status to a file called "ReportStatusFilename=C:\Program Files\Dynafact\DMS\Export\SomeResults.Txt":

SQLScriptName=Import Resources

ReportStatusFilename=C:\Program Files\Dynafact\DMS\Export\SomeResults.Txt