The Auto Import is used to automate the EZ-Scan Database import to run on a scheduled basis, using the task scheduler in Windows.
It is typically run overnight to import data to the main database from branch databases.
Go to Start>All Programs>Accessories>System Tools>Scheduled Task to open the Task Scheduler. This will open an explorer window with your scheduled tasks. Click on Add Scheduled Task to start the Scheduled Task Wizard.
The next screen will ask you to select the program to schedule
Click 'Browse' and browse to C:\EZ-Scan\Tools\pstAutoImpDB.exe
Name the task and choose when to run.
The task scheduler will need to run as a user that has rights to both the databases being imported as well as the database being imported into, and rights to the locations where all images are stored. NOTE: If the does not have rights to any of the necessary files and directories, the import will fail.
The last screen will confirm your settings.
The Auto Import settings are contained in the pstAutoImpDB.ini in the Windows directory. It needs to be edited to tell the program what jobs to run and to set the properties of each job.
Open the file in notepad and edit the settings for your job or jobs. You can have just as many jobs scheduled as necessary. Just add a new job section for each one.
Here is an example of the entries in the INI file.
[AutoImpDb]
Silent = 0
[JOB1]
Silent = 1
Delete = 1
DateFrom=
DateTo=
ImportImagePath=C:\EZ-Scan\Test\Images\
ImportPath=C:\EZ-Scan\Test\
ImportFilename=EZ-Scan.mdb
DestinationDatabase=C:\EZ-Scan\EZ-Scan.mdb
LogFilePath=C:\EZ-Scan\
IgnoreImportedFlag = 0
[JOB2]
Silent = 1
Delete = 1
DateFrom=
DateTo=
ImportImagePath=C:\Ez-Scan\TestiMPORT\iMAGESBranch2\
ImportPath=C:\Ez-Scan\TestiMPORT\
ImportFilename = Branch2.mdb
DestinationDatabase=C:\Ez-Scan\TestImport\Main.mdb
LogFilePath=C:\Ez-Scan\
IgnoreImportedFlag = 0
The jobs must be named sequentially [JOB1],[JOB2],[JOB3], etc and will be run in the order listed.
Silent under the heading AutoImpDb will run the Auto Import in silent mode with no user interface.
Silent under each job section will overide the setting in AutoImpDb. Typically Silent will be set to 1 (True)
DateFrom and DateTo refer to the Date Process of the items in the database. It will allow you to import items in a specific date range.
This is the path to the images being imported.
This is the path to the database being imported.
This is the filename of the database being imported.
This is the path and filename of the database that the data and images will be imported into.
This will allow items to be imported that were imported previously, if set to 1 (True)
This is the directory that the log file will be created in.
Once the settings are complete the auto import is ready to go and will run as scheduled in the Task Scheduler. The log file will contain the details of the import.