Any XML export can be run as a scheduled task in Windows using the CALLRXX program (as of version 7.46.00).
Once the trigger has been set up, the “Action” for the scheduled task is:
Program: wrun32.exe (optionally with the complete path if it is not in the system PATH)
Arguments: -c omics.cfg -y omics6 -y xmlif.dll CALLRXX “arguments”
Start in: [root Rx-Universe folder] - for example, C:\RXUNIVERSE if that is where RxU is installed.
The “arguments” line must contain:
PGM=[name of xml extract program] - this field is REQUIRED
RXXAR - accounting transactions
RXXCUST - customers
RXXBREAK - breakage information
RXXJTH - job track / operator export by hour
RXXLENS - lenses
RXXORD - orders (completed and in-process if so marked in System Settings)
RXXORDD - orders deleted, needs to be run before the day-end if the lab is set to remove deleted orders permanently
RXXPO - purchase orders
RXXSTX - lens transactions
FROMDATE= date to start exporting transactions (inclusive) - ie 20220102 is Jan 2, 2022
if not specified, will start from the previous dayend date
TODATE= date to export to (inclusive) - ie 20220906 is Sept 6, 2022
if not specified, will use today’s date
FROMCUST= customer code to export from
if not specified will start at the first customer
TOCUST= customer code to export to
If not specified will export to the end of the customers
PATH= path to create the XML file(s) in - can be relative or complete
If not specified will default to the folder specified in the Dayend tab in System Settings
Examples:
-c omics.cfg -y OMICS6 -y XMLIF.DLL CALLRXX “PATH=D:\RXUNIVERSE\EXPORTS PGM=RXXORD FROMDATE=20220101 TODATE=20220131”
Will export all orders from Jan 1, 2022 to Jan 31, 2022, to file(s) in the folder D:\RXUNIVERSE\EXPORTS
Running from command line
The CALLRXX program can also be run from the command line (or invoked by a third-party system) - it does not have to be run as a scheduled task. To illustrate, the following command could be run from the root Rx-Universe folder, from the command line:
wrun32 -c omics.cfg -y OMICS6 -y XMLIF.DLL CALLRXX “PATH=D:\RXUNIVERSE\EXPORTS PGM=RXXORD FROMDATE=20220101 TODATE=20220131”
This invokes exactly the same instruction as the previous, scheduled, task.
Exit codes
When the program finishes, the following exit codes can be set:
0 - program terminated normally
100 - no input string of argmuments was given
101 - a label other than those allowed was specified (other than PGM, PATH, FROMDATE, etc).
102 - the from date is later than the to date
103 - the from customer is greater than the to customer
104 - no value for PGM was specified
105 - the program specified using PGM was not found