How can I schedule the Variable Scanner?

How can I schedule the Variable Scanner?

It is possible to schedule the running of the Variable Scanner by using a command line and then using Windows' Task Scheduler in order to schedule the batch file.

Firstly, you need to install and configure the Variable Scanner so that it scans your system. You will need to configure the connection string to the webservice control database, the directories that you wish to scan and set up the directory for the output files.

Please refer to https://support.apteco.com/portal/en-gb/kb/articles/using-the-variable-scanner for more information on configuring the Variable Scanner.

Once you have configured the Variable Scanner for your system, open it and from the File menu choose Save As



Choose a suitable location and file name for the file 



and then click Save



A dialog box will prompt you to say that the settings have been saved.
Click OK to this.

We then need to create a batch file which references this settings file.

As an example, let's say the settings file has been saved in D:\faststats\Build\VarUsage\Batch File\VariableScannerSettings.xml

We need to create a batch file like this:

"C:\Program Files\Apteco\FastStats Variable Scanner\Apteco.FastStatsVariableScanner.Console64.exe" "D:\FastStats\Build\VarUsage\Batch File\VariableScannerSettings.xml"

the Apteco.FastStatsVariableScanner.Console64.exe is a 64-bit version of the FastStats Variable Scanner which can be run from the command line.

The parameter after the path to the .exe is the path to the settings .xml file.

NB: if the paths contain spaces then you will need to enclose the path(s) within double quotes.

If you run the batch file then it should run a Variable Scan.

With the batch file configured, we can then use Windows' Task Scheduler to schedule the running of this task as required.

We can add a Task where the Action runs the batch file:



And set the Trigger to be the schedule we require


    • Related Articles

    • PS Unable to find the versioned file

      In Q3 23 we changed the default stance on versioned selections to error if it can not find the latest version available for the selection that is being used in the Campaign. To revert this back to use versioned files in the db, please set this in the ...

    • FastStats Service not producing log files

      The obvious thing to check is that the log file path and file name has been configured and that this exists. It is also worth checking the Log level. If this is set to Warning or Error then it will only write out warnings and errors. Try setting this ...

    • Add a Portion of an Array Variable in a Data Grid

      When adding an array variable onto a data grid it will give you all of the options in the array. What if you were only interested in a portion of the array variable. I'll be using this variable Newspapers in this example from our holidays database. ...

    • FastStats not showing most recent release on splash screen launchpage

      When you run a FastStats Launcher (or FastStats local) then the log in page should show a list of features in the splash page to the right of the log-in panel: If this is not showing the release notes which correspond to the software version (you can ...

    • Issue with date ranges in selections reverting to "Earliest to Latest" on Q1 2024 release.

      Several users reported an issue that when creating selections within FastStats which included a date variable and contained a selection using a Date Range,. They found that after making changes to the other parts of the selection and subsequently ...