Page background
Support item image

Automating Imports

Salesmatrix version 6 allows the user to automate the importing of data using the Windows Scheduled Tasks Control

Additional Script command for Auto-loading Scripts
Most of these correspond with the options under advanced settings in the Import Options screen. The options can be set so that for example imports can happen monthly for a normal 2-year date set, Weekly for the last 3 months and daily for the past months. Each import can be set so that they go to separate datasets and do not overlap each import.

Setting Line in Script



The ODBC Database Source Name. If this is not set, then the default name set in Tools/Options is used.



1      All Transactions
2      Last Month
3      Last 3 Months
4      Last 12 Months

If this is not set then the default range will be the last 2 years



1      Daily
2      Weekly
3      Fortnightly
4      Semi-Monthly
5      4-Weekly
6      Monthly
7      Quarterly
8      Half-Yearly
9      Annual


The dataset name as normally entered in the Import Options. If this is set it will overwrite the existing set of data on the disk with the latest set. 



 1    Use Advanced Dates



To automate the import, simply go to the 'Scheduled Tasks' control panel and in the Run entry area type the following line:

application scriptfile
application = the full pathname of the Salesmatrix application
scriptfile = the full pathname of the script file you wish to load.

Ensure the "Start in:" directory is the same as the directory where the Salesmatrix application is.
Next, click on the Schedule tab and enter in the details regarding when and how often you want the import to run.

When the import runs using the Scheduled Tasks control, there is a minimum of screen activity. A few small information dialogs may appear in the top left corner of the screen and at the completion of an import a dialog will display that the import is complete. This will disappear after a few seconds, so will not affect other activities on the computer.