[QXL-ALL] How to use QXL with Scheduler
Posted by Jack - QODBC Support on 14 April 2017 09:38 AM
How to use QXL with Scheduler
I want to export QuickBooks Data using QXL.
I want to schedule QXL for exporting QuickBooks Data. So it will automatically export QuickBooks Data on scheduled time.
But I don't know how can I use QXL with Scheduler.
You can configure QXL export option by creating the shortcut using QXL & can use the shortcut in the scheduler.
The first step in configuring the application is to click on settings icon for QXL options details.
In General tab, You will find two buttons which will create the export shortcut on your desktop.
1. QXL - Silent Mode which will export data in silent mode (does not display QXL Window).
For Example: QXL.exe Silent
2. QXL - Direct Export Mode which will export data in direct mode (display QXL Window).
For Example: QXL.exe Run
By clicking on "Create a shortcut on desktop" button you will get below popup message & click "OK" it will create the shortcut on the desktop.
The shortcut is created on the desktop.
You can use above shortcut in your scheduled application to export QuickBooks Data using QXL.
You can use any desktop based scheduler (example "Z-Cron"). QuickBooks, QuickBooks SDK are desktop based and not designed to run as service. QODBC & QXL is also a desktop based application. Thus you will need an active desktop session(someone logged into the machine). You may not be able to use the service based scheduler like "Task Scheduler". In this example, we are using Z-Cron but you can use any other desktop based scheduler.
You can download Z-Cron from below mentioned link:
After downloading Z-Cron, please install it on your machine.
After Installation please start Z-Cron and add task by Clicking the "Task" button.
Enter Task Title in Label box & enable "Activate Task" option to activate the scheduled task and choose Program by clicking ".." button.
Select QXL shortcut from the desktop which we created from above steps & click "OPEN".
If you want to run QXL in the background, then insert parameter "Silent".
If you want to run QXL in the foreground, then insert parameter "Run".
Now navigate to "Scheduler" tab to schedule export. In this example, I am scheduling export to every day two times (i.e. 8:00 AM & 5:00 PM).
Click on "Every day" button to select all weekdays & click on "Scheduler" to configure schedule timing.
Select time & click on "Save".
Now save the scheduled job by clicking the "Save" button.
The scheduled job is saved.
The scheduled task is ready for the execution. It will be run on schedule time.