QXL options and settings

QXL options and settings/Configuration:

The first step in configuring the application is to click on the settings icon for details on QXL options.

General Tab:

From the General Tab, you can change the following:

1. Output Folder: - You can change the path of the output folder by clicking the "Browse" button.

2. Format: You can format the exported file to XLSX, XLS, CSV, or SQL Server.

3. SQL / ODBC Connection String: - You can set SQL / ODBC Connection String.

Note: QXL Professional Edition license is required to export data to SQL Server / ODBC Data Source.

4. Export In: - You can change the export option to Separate File or Single File.

5. Output file(s) read-only: - You can protect exported file for unwanted write. This option will set exported files to read only if you select "Yes."

6. QuickBooks Source: - You can set up a QuickBooks company file path using the "Browse" button in QXL or the Currently Opened Company File.

Advanced Tab:

From the Advanced Tab, you can change Optimizer & Messages settings as below:

QXL Optimizer Setup:

What is an Optimizer file?

When you access any table, QXL will gather data from QuickBooks and store it in an Optimizer file. When you turn on the Optimizer, QXL will bring some data to a local cache file (the optimizer file) to increase retrieval performance for queries. Next time you query the same table, QXL will request differential records that are added, modified, and deleted from QuickBooks and sync them to the Optimizer file. This way, QXL will have to only get the differential records instead of the entire data set from QuickBooks. As a result, you will notice performance gain compared to working without an optimizer.

Initial data optimization has been benchmarked at up to a 30% reduction in load time. The first time you access a given QuickBooks table, QXL, by default, optimizes access to that data, so the next time you need data from that table, it will be much faster. 

The optimizer brings some data to a local cache to increase query retrieval performance. Check to activate the optimizer.

Optimizer Database Folder specifies where the local data store will be saved on disk. The default location %AppData%\QXL - QuickBooks Data Export Data Made Easy\Optimizer is under your Windows login account name under your Documents and Settings folder. The data will be stored in a file in this folder with a name similar to the company file name with a .opt extension. If you store that data somewhere other than the default, click the browse button and select the destination folder. You can change the path of the Optimizer folder by clicking the "Browse" button. With very large company files we suggest running synchronization after hours.

Reset Optimizer File(s): This button is used to rebuild the optimized data from scratch completely. It is useful when starting with a new company if you do not want to synchronize the tables as you first encounter them and ensure that your data is 100% current.

QXL Messages:

Messages allow you to review message logs from QXL regarding errors and issues communicating with QuickBooks, clear these messages, and review messages produced by the QuickBooks qbXML SDK interface.

When selected, Display Driver Status Panel shows precisely what QXL is doing when accessing the QuickBooks data and provides a good assessment of speed using optimized and non-optimized data.

Export Options:

Create a table from the sheet option will create the table from the spreadsheet (for Excel 2010 or above in [xlsx] format only.)

The table Styles option is used for formatting Excel cells by choosing predefined styles (for Excel 2010 or above in [xlsx] format only.) You can select a predefined type using the drop-down.

Header Color option used for changing Excel Column Header Color (for Excel 2010 or above in [xlsx] format only.). You can change the header color using the "Click to change header color" button.

Table Settings Tab:

From Table Settings Tab, you can change table options as below:

1. ALL table: - This option will export all tables to the output folder.

2. Selected Table: - This option will export selected tables to the output folder.

3. Excluding Selected Table: This option will export all tables to the output folder we have not selected.

In the Selected Table option, you can select the table by double-clicking on the table name. You can select all tables by clicking "All." You can clear the selection by clicking "None." You can invert table selection by clicking "Invert."

Custom Query Tab:

From Custom Query Tab, you can write your custom query and fetch data according to your requirement.

You need to write the table name in the Custom Table Name box & write the query in the Custom Query box. After writing the table name & query, click on the "Add or Update" button to add the question.

You can update existing queries by double-clicking on the table name & modify the query Custom Query box. After changing the query, click on the "Add or Update" button to update the query.

You can remove the existing query by double-clicking on the table name & click on the "Remove Selected" button to delete the query.

Report Setting Tab:

This tab allows you to add default reports to export. You can also add a custom report with different parameters.

You can choose the default report from the drop-down list & add the report for export.

Select any report from the drop-down list & click on the "Add or Update" button to add the report for export.

If you want to add a Custom report using different parameters, you can add it by writing a report query & output report name.

You need to write the report name in the Output Table Name box & write the query in Report Query/Command box. After writing the report name & query, click on the "Add or Update" button to add the report query.

You can remove the existing report by double-clicking on the report name & click on the "Remove Selected" button to delete the information.

You can modify the existing report by double-clicking on the report name. Report name & query/command will be shown in the Output Table Name box & Report Query/Command box. You need to modify the report & "Add or Update" button to update the report query.

You can save all the above configurations by clicking the "Close" button & you can discard changes by clicking the "X" button.

Activate/Deactivate Tab:

You can Activate / Deactivate QXL by clicking on the "Activate / Deactivate" button.

Activation:

Activate is the online option for entering the CD Key issued to you upon purchasing the product to fully start QXL from the evaluation version to the entire Standard Edition purchased. Suppose you do not have internet access to activate the product from the machine you intend to use. In that case, you can use the manual option to generate an activation code from a device with internet access.

Enter CD Key & click on "Activate."

Manual Activation:

Enter the CDKey & click on "Manual."

Deactivation:

Deactivate is the online method of deactivating a currently registered version of QXL to transfer the product to another machine. If internet access is unavailable from the registered device, you can use the manual option to generate a deactivation code from a machine with internet access. Using the latest version of QXL, credit for deactivation CDKEY is received instantly. In some cases, this process will take 24 to 48 hours before your CD Key account is credited with the deactivated license, and you can reactivate the license on a different machine.

Enter the CDKey & click on "Deactivate

Manual Deactivation:

Enter CD Key & click on "Manual."

Pro Edition Tab:

You can export QuickBooks Data into SQL Server & ODBC database using Pro Edition Tab. Please refer to the below-mentioned link for more details.

How to export to SQL Server - using SQL Default Driver & ODBC

How to export to MySQL

How to export to MS Access

Note:
A QXL Professional Edition license is required to use this feature.

About Tab:

About screen shows the QXL version currently installed, whether it is an evaluation copy or fully registered. The first letter in the serial number denotes the license type installed, and the 2nd & 3rd digits are the QXL major version number. (The serial number may be required for upgrades, rebate offers, technical installation support, or the Help Desk system.)

Also, Refer:
QXL Command line arguments/parameters
How to use QXL with scheduler for multiple company files