[QXL-ALL] QXL options and settings
Posted by Rajendra Dewani (QODBC Support) on 27 June 2016 03:30 PM
QXL options and settings
QXL options and settings/Configuration:
The first step in configuring the application is to click on settings icon for QXL options details.
QXL Optimizer Setup:
What is 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. When you access any table, QXL will gather data from QuickBooks and will store it in Optimizer file. Next time when you query the same table, QXL will request differential records which are added, modified and deleted from QuickBooks and will sync it to Optimizer file. This way QXL will have to only get the differential records instead of entire data set from QuickBooks. As a result, you will notice performance gain when compared to working without Optimizer.
Initial optimization of data 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.
Use Optimizer brings some data to a local cache to increase retrieval performance for queries. 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. With very large company files we suggest running synchronization after hours. You can change the path of Optimizer folder by clicking "Browse" button.
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.
Create Table from the sheet option will create the table from the spreadsheet (for Excel 2010 or above in [xlsx] format only.)
Table Styles option used for formatting Excel cell by choosing predefined styles (for Excel 2010 or above in [xlsx] format only.) You can select pre-defined style using the dropdown.
Header Color option used for changing Excel Column Header Color (for Excel 2010 or above in [xlsx] format only.). You can change header color using "Click to change header color" button.
Table Settings Tab:
In Selected Table option you can select the table by double clicking on the table name. You can select all table by clicking "All". You can clear selection by clicking "None". You can invert table selection by clicking "Invert".
Custom Query Tab:
You can update existing query by double clicking on table name & modify query Custom Query box. After changing query click on "Add or Update" button to update query.
You can remove existing query by double clicking on table name & click on "Remove Selected" button to delete query.
Report Setting Tab:
You can choose default report from the drop down list & add the report for export.
Select any report from the drop down list & click on "Add or Update" button to add the report for export.
If you want to add Custom report using different parameters, then you can add it by writing report query & output report name.
You can remove existing report by double clicking on report name & click on "Remove Selected" button to delete the report.
You can modify existing report by double clicking on report name. Report name & query/command will be shown in Output Table Name box & Report Query/Command box. You need to modify report & "Add or Update" button to update report query.
Pro Edition Tab: