XML exports

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)
RXXORDU - orders that are unvalid (status “U”)
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