Knowledgebase: FAQ
[QXL-Desktop] How to use QXL with the scheduler for multiple company files
Posted by Jack - QODBC Support on 05 July 2017 12:56 PM

How to use QXL with the scheduler for multiple company files

Problem Description:

I want to export QuickBooks Data for multiple company files using QXL.

I want to schedule QXL for exporting QuickBooks Data. So it will automatically export QuickBooks Data for multiple company files on scheduled time.

But I don't know how I can use QXL with Scheduler for multiple company files.

Solution:

You can use the QXL Parameter file for exporting QuickBooks data from multiple company files.

When you install QXL at that time sample parameter file is installed in the "C:\Users\Your User Name\Documents\QXL\" folder.

Sample parameter file opened. You can use the "CompanyFilePath" parameter & can provide your company file path in the parameter file.

You can copy this file & rename it as "My Company.txt," e.g., "Company A.tx.".

After copying the parameter file, You can provide your company file path using the "CompanyFilePath" parameter. Also, You can add/update other parameters in a text file as per your requirement. Refer to QXL Command line arguments/parameters for more details about QXL Parameters. Similarly,e way you can create a separate parameter file for other company file(s).

You can use the above Parameter file in your scheduled application to export QuickBooks Data using QXL.

Use Scheduler:

You can use any desktop-based scheduler for (example, "Z-Cron"). QuickBooks and  QuickBooks SDK are desktop based and not designed to run as a  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 Schedule.". In this example, we use Z-Cro,n, but you can use any other desktop-based scheduler.

You can download Z-Cron from below mentioned link:

Download Z-Cron

After downloading Z-Cron, please install it on your machine.

After Installation,n please start Z-Cron and add a  task by the "Task" button.

Enter Task Title in the Label box & enable the "Activate Task" option to activate the scheduled task and choose Program by clicking the ".." button.

Select QXL.exe from the QXL installation folder; click "OPEN."

QXL Default installation path:

For 32-bit OS: "C:\Program Files\FLEXquarters.com Limited\QXL for QuickBooks"

For 64-bit OS: "C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks"

After selecting QXL.ex,e insert the parameter file path in the "Parameter:" box.

Note: You need to provide the ide parameter file path in the quotes below
For Example: "C:\Users\Raj\Documents\QXL\Company A.txt"

Now navigate to the "Scheduler" tab to schedule export. In this example, I prepare export twice daily (i.e., 8:00 AM & 5:00 PM).

Click onthe  "Every day" button to select all weekdays & click on "Scheduler" to configure scheduled time, select extra time & click on "Save.".

Now save the scheduled job by clicking on "Save.".

The scheduled task is ready for execution. It will be run on schedule time. The scheduled job is as ved.

Now we will create a new task for the anthe the other company file. We can complete a new task by clicking on the "Task" button from Z-Cron.

Z-Cron is opentoh the existing task. To create ate new tas,k clon the "Create new CronJob" button.

Enter Task Title inthe  Label box & enable the "Activate Task" option to activate the scheduled task and choose Program by clicking ".." button.

Select QXL.exe from the QXL installation folder; click "."IN".

QXL Default installation path:

For 32-bit OS: "C:\Program Files\FLEXquarters.com Limited\QXL for QuickBooks"

For 64-bit OS: "C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks"

After selecting QXL.exe, insert the parameter file path in the "Parameter:" box.

Note: You need to provide the ide parameter file path in the quotes below
For Example: "C:\Users\Raj\Documents\QXL\Company B.txt"

Now navigate to the "Scheduler" tab to schedule export. In this example, I prepare export twice daily (i.e., 9:00 AM & 6:00 PM).

There should be a time gap between the export schedule of two or more company filThe timelines. The ntimtimtimtimtime gap depends on the export time of your QuickBooks company file data. Note: You can run only instances of QXLthis this time. So don't schedule to export two more company files simultaneously time.

Click on the "Every day" button to select all weekdays & click on "Scheduler" to configure schedule timing.

Select a time & click on "." ."

Now save the scheduled jobcliclickinginginginginginglick on "Save.".

The scheduled job is safely scheduled used task is ready the execution. It will be run on schedule time.

You can create a batch file & can insert ds-commands command commands-commands commands for exporting QuickBooks data for multiple company files. So it will export data fvariousiple company files one by one.

To create a batch of the file, you need to open "Notepad" & write the below command.

cd "C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks"

QXL.exe "C:\Users\Raj\Documents\QXL\Company A.txt"

QXL.exe "C:\Users\Raj\Documents\QXL\Company B.txt"

Save your file by heading to ", "le," "Save As"

Select "All Files (*.*)" as "Save as type:" and Enter not name of the file that you'd like & click on. "ve."

The batch file is created.

You can schedule batch file using the scheduler. It will be run on schedule time. For scheduling bafilesfile you can refer above steps. Just one step change, the path of the batch file rest of the steps are the same as above.

 

Example of Command line arguments/parameters for QXL Desktop

You can run QXL through the ugh command prompt & can set parameters.


You can open the command prompt by searching "cmd" in the from-start menu & can open the command prompt by clicking on the  "Command Prompt" icon.


The Command Prompt has opened. Navigate to the "QXL for QuickBooks" folder by typing the command below.
cd C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks

 

Execute the command line argument by usthe ing below sample. You can add/remove/chase no par value per your requirement.
QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ExportType="XLSX" -ExportIn="True" -CompanyFilePath="C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 13.0\sample_product-based business.qbw" -UseOptimizer="False" -CreateTableForExcel="True" -ExcelHeaderColor="808080" -ExcelTableStyles="Dark4" -DefaultODBCConnectionName="0" -TableSelection="1" -TablesToExport="Entity,Company,Class"

 


QXL will start exporting data as per provided parameters.


After the exporting data is complete, the QXL application will close automatically.


You can configure different confilesfile & can theme them through the ugh "ConfigFile" parameter. You need to provide the path of your QXL config file as below.
QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ConfigFile="C:\My Folder\Exported Data\Rock Castle Construction\config.xml"


QXL will start exporting data as per provided parameters.


After the exporting data is completthe ed, QXL application will close automatically.

 

Note: The command prompt supports up to 8191 characters as a command line argument. So you cannot use more than 8191 characters as a command line argument. You can use a parameter file if command line argument exceeds 8191 characters re: to QXL Command line arguments/parameters for more details about QXL Parameters.

 

Example of Command line arguments/parameters for QXL Online


You can run QXL through the ugh command prompt & can set parameters.
You can open the command prompt by searching "cmd" in the from start menu & can open the command prompt by clicking on the "Command Prompt" icon.

 


The Command Prompt has opened. Navigate to the "QXL for QuickBooks Online" folder by typing the below command.
cd C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks Online

 

Execute the command line argument by usthe ing below sample. You can add/remove/chase no par value per your requirement.
QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ExportType="XLSX" -ExportIn="True" -UseOptimizer="True" -OptimizerFilePath="%AppData%\QXL - QuickBooks Online Data Export Made Easy\Optimizer\ABC" -CreateTableForExcel="True" -ExcelHeaderColor="808080" -ExcelTableStyles="Dark4" -DefaultODBCConnectionName="0" -QBODefaultConnectionName="1" -TableSelection="1" -TablesToExport="Customer,Company,Class"

 

QXL will start exporting data as per provided parameters.

 


After the exporting data is complete, the QXL application will close automatically.

 


You can configure different confilesfile & can theme them through the ugh "ConfigFile" parameter. You need to provide the path of your QXL config file as below.
QXL.exe Run DefaultPath="C:\My Folder\Exported Data" -ConfigFile="C:\My Folder\Exported Data\Rock Castle Construction\config.xml"

 


QXL will start exporting data as per provided parameters.

 


After the exporting data is completthe ed, QXL application will close automatically.

 

 

Also, Refer to QXL Command line arguments/parame.ters

T ags: Command line arguments, DOS, parameters

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).