Problem Description:

I am using QXL & I want to run the Balance Sheet standard report through QXL. I can see the report on the list. But I want to change the report parameter.

How can I add multiple levels similar to the QuickBooks application (UI) report?

Solution:

You can change the report query & parameter from the QXL Report Settings tab.

The first step in changing the report parameter is to click on the settings icon for QXL options details.

Input following

Output Table Name = BalanceSheetStandard

Report Query/Command = sp_report BalanceSheetStandard show Amount_Title, NestedText1,NestedText2,NestedText3,NestedText4, Amount parameters DateMacro = 'ThisMonthToDate', ReportDetailLevelFilter='All'

You can modify the report query using the Report Query/Command box.

You can refer to the QXL Data Layouts site for details about different report parameters.

Navigate to the above link & click on the region of the QuickBooks edition you are using.

You will be redirected to the QuickBooks region link. Click on the "ALPHABETICAL LISTING OF ALL REPORTS" under the "REPORT OVERVIEW" label.

You will be presented with a list of reports. Search for the "BalanceSheetStandard" report & click on "Parameters" to get details about all supported parameters for the BalanceSheetStandard report.

If you are using a QuickBooks USA user, then you can refer to the direct link for PARAMETERS AND VALUES FOR BalanceSheetStandard

You can use any of the supported parameters in the report query.

You need to modify the report query & click the "Add or Update" button to update the report query.

The modified report query will be updated on the list.

By repeating the above process, you can add different reports with different supported parameters per your requirement.

The report will be exported by clicking on the Export icon from the QXL Main Window.

Report Exported.

Problem Description:

You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. You can export QuickBooks Data to Sybase using QXL. I am using QXL & I want to export QuickBooks Data to Sybase.

How can I export QuickBooks Data to Sybase using QXL?

Solution:

First, you need to create a database in Sybase for storing QuickBooks Data. You need to use Interactive SQL & execute the following query to create the database.

create database dbname on default ="1G"

For Example:

create database QXL on default ="1G"

Note: default ="1G" will set the database size to 1GB. You need to create a bigger database if your company file contains more data.

The database is created in Sybase.

By default, the Sybase database does not allow null values in database fields.

There is a field value that could be null during export. So, we need to change this property. We can modify it by using the following query.

sp_dboption <database_name>,
"allow nulls by default," true

For Example:

sp_dboption QXL,
"allow nulls by default," true.

Note: You need to execute the above query in the Master database.

The query is executed. Now, you are ready to export QuickBooks data to Sybase.

After that, you need to create an ODBC DSN for Sybase, which will point to the Sybase Database.

I have already created an ODBC DSN for Sybase below the properties of the DSN. We will test the connection of Sybase DSN by providing Sybase database information & clicking the "Test" button.

Sybase ODBC DSN test connection successful. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "Sybase" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name;Port=PortNo;Database=DBName;User Id=Uid;Pwd=pwd;

For Example: DSN=QXL_SYBASE;Port=5000;Database=QXL;User Id=sa;Pwd=css@123#;

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into Sybase. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to Sybase. You can verify it using the query below.

Select * from sysobjects where type="U"

Problem Description:

I am using QXL & I want to export QuickBooks Data to PostgreSQL.

How can I export QuickBooks Data to PostgreSQL using QXL?

Solution:

You can export QuickBooks Data to PostgreSQL using QXL.

First, you need to create an ODBC DSN for PostgreSQL, which will point to the PostgreSQL Database.

I have already created an ODBC DSN for PostgreSQL below the properties of the DSN. We will test the connection of PostgreSQL DSN by providing PostgreSQL database information & clicking the "Test" button.

PostgreSQL ODBC DSN test connection successful. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "PostgreSQL" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=QXL_PostgreSQL

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into PostgreSQL. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to PostgreSQL.

Problem Description:

I am using QXL & I want to export QuickBooks Data to Oracle.

How can I export QuickBooks Data to Oracle using QXL?

Solution:

You can export QuickBooks Data to Oracle using QXL.

First, you need to create an ODBC DSN for Oracle, which will point to the Oracle Database.

I have already created an ODBC DSN for Oracle below the properties of the DSN. We will test the connection of the Oracle DSN by clicking the "Test Connection" button.

Oracle ODBC DSN test connection successful. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "Oracle Database" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name;User Id=UID;Pwd=Password;

For Example: DSN=QXL_ORACLE;User Id=scott;Pwd=tiger;

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into Oracle. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to Oracle.

Problem Description:

I am using QXL & I want to export QuickBooks Data to MariaDB.

How can I export QuickBooks Data to MariaDB using QXL?

Solution:

You can export QuickBooks Data to MariaDB using QXL.

First, you need to create an ODBC DSN for MariaDB, which will point to the MariaDB Database.

I have already created an ODBC DSN for MariaDB below the properties of the DSN.

We will test the connection of MariaDB DSN by clicking the "Test DSN" button.

MariaDB ODBC DSN test connection successful. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "MariaDB" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=QXL_MariaDB

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into MariaDB. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to MariaDB.

Problem Description:

I am using QXL & I want to export QuickBooks Data to DB2.

How can I export QuickBooks Data to DB2 using QXL?

Solution:

You can export QuickBooks Data to DB2 using QXL.

First, you need to create an ODBC DSN for DB2, which will point to the DB2 Database.

I have already created an ODBC DSN for DB2 below the properties of the DSN.

We will test the connection of DB2 DSN by providing DB2 by clicking the "Connect" button.

DB2 ODBC DSN test connection is successful. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "IBM DB2" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=QXL_DB2

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into DB2. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to the DB2.

Problem Description:

I am using QXL Online & I want to run a Profit and Loss by a Class report through QXL Online. I can't see the report on the list.

How can I run the Profit and Loss by Class report using QXL Online?

Solution:

I'm sorry to inform you that the ProfitAndLossByClass report is unavailable via Intuit API. So It is not available in QODBC Online.

You can use the ProfitAndLossStandard report & add the parameter SummarizeColumnsBy = 'Classes' in the report. So you can fetch the ProfitAndLossByClass report using QXL Online.

The first step in changing the report parameter is to click on the settings icon for QXL Online options details.

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

You can see the default report query in Report Query/Command box.

You can modify the report query from Report Query/Command box.

You can refer QODBC Table/Report Documentation site for details about different report parameters.

Click on the "ALPHABETICAL LISTING OF ALL REPORTS" under the "REPORT OVERVIEW" label.

You will be presented with a list of reports. Search for the "ProfitAndLossStandard" report & click on "Parameters" to get details about all supported parameters for the ProfitAndLossStandard report.

You can refer direct link for ReportParameter: ProfitAndLossStandard

You can use any of the supported parameters in the report query.

I am changing the report query as below:

For Example: sp_report ProfitAndLossStandard RowData, TextLable, Amount_Title, Amount parameters DateMacro = 'ThisYearToDate', ReportBasis='Cash', SummarizeColumnsBy = 'Classes'

You need to modify the report query & click the "Add or Update" button to update the report query.

The modified report query & was added to the export list.

By repeating the above process, You can add a different report with different supported parameters per your requirement.

The report will be exported by clicking on the Export icon from QXL Setup Screen.

Report exported.

Tags: QuickBooks Online, QBO, QXL Online, Profit and Loss, Profit, Loss, Online Report

Problem Description:

I am using QXL & I want to run a Profit and Loss by Class report through QXL. I can see the report in the list. But I want to change the report parameter.

How can I change the report parameter & run the updated report?

Solution:

You can change the report parameter from the QXL Report Settings tab.

The first step in changing the report parameter is to click on the settings icon for QXL options details.

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

You can see the default report query in the Report Query/Command box.

You can modify the report query from the Report Query/Command box.

You can refer to the QODBC Data Layouts site for details about different report parameters.

Navigate to the above link & click on the region of the QuickBooks edition you are using.

You will be redirected to the QuickBooks region link. Click on the "ALPHABETICAL LISTING OF ALL REPORTS" under the "REPORT OVERVIEW" label.

You will be presented with a list of reports. Search for the "ProfitAndLossByClass" report & click on "Parameters" to get details about all supported parameters for the ProfitAndLossByClass report.

If you are a QuickBooks USA user, then you can refer to the direct link for PARAMETERS AND VALUES FOR: ProfitAndLossByClass.

You can use any of the supported parameters in the report query.

I am changing the report query by adjusting the DateMacro parameter value to 'ThisMonthToDate.'

For Example: sp_report ProfitAndLossByClass show Amount_Title, Text, Label, Amount parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'Class'

You need to modify the report query & click the "Add or Update" button to update the report query.

The modified report query & was added to the export list.

By repeating the above process, you can add different reports with different supported parameters per your requirement.

The report will be exported by clicking on the Export icon from the QXL Setup Screen.

Report exported.

Problem Description:

How to build shortcuts to export multiple QuickBooks company files using QXL with one click?

Solution:

Please refer to the steps & video for building shortcuts to export multiple QuickBooks company files using QXL with one click.

Requires - QXL v17.0.0.023 or Above. Click here to download the latest version of QXL Desktop.

1. Start QuickBooks & load your company file & log in to your company file as an Admin.

2. Start QXL using the QXL shortcut placed on your desktop & click the "Export" button.

3. QuickBooks will prompt for authorizing QXL to connect with QuickBooks. Please accept the certificates.

4. After accepting the certificate, QXL will export your company file data.

5. Close QXL after the export is completed.

6. Create a QXL Parameter file from a default parameter file. When you install QXL, at that time, the sample parameter file is installed in the "C:\Users\Your User Name\Documents\QXL\" folder. Copy the default parameter file & paste it into the same folder & rename the pasted parameter file with your company file name.

7. Open the renamed parameter file & use the "CompanyFilePath" parameter from the file & provide your company file path in the parameter file. In this tutorial, we have used the export mode "Direct." You can change the export mode as per your requirement. You can add/update other parameters in a text file as per your requirement & save the parameter file. You can refer to QXL Command line arguments/parameters for more details about QXL Parameters.

8. Make a copy of the QXL shortcut & rename it with your company file name.

9. Copy the file path of your parameter file & add it to your QXL shortcut file. Right-click on the QXL shortcut file, click "Properties," & add the parameter file path in the double quotation marks after QXL.exe in the target box & apply the shortcut changes by clicking the "Apply" & "OK" buttons.

10. Double-click the QXL shortcut to export company file data automatically.

11. Similarly, you can create a QXL shortcut for your other company files.

Also, refer to the following:

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 a scheduled time.

But I don't know how I can use QXL with the 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, the 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, another 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 are also desktop-based applications. 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 the link below:

Download Z-Cron

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

After Installation, please start Z-Cron and add a task by clicking 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 the export. In this example, I prepare the export twice daily (i.e., 8:00 AM & 5:00 PM).

Click on the "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 open to the existing task. To create a new task, click the "Create new CronJob" 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 "."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 the export. In this example, I prepare the export twice daily (i.e., 9:00 AM & 6:00 PM).

There should be a time gap between the export schedules 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 QXL this time. So don't schedule to export two more company files simultaneously at the same 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 job by clicking on "Save."

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

You can create a batch file & can insert ds-commands commands-commands commands for exporting QuickBooks data for multiple company files. So it will export data from various 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 the name of the file that you'd like & click on. "ve."

The batch file is created.

You can schedule a batch file using the scheduler. It will be run on schedule time. For scheduling the bafiles file, you can refer to the above steps. Just one step change, the path of the batch file, the 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 using the sample below. 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 the provided parameters.

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

You can configure different configurations & 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 the provided parameters.

After the exporting data is completed, the 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 the command line argument exceeds 8191 characters. Refer 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 command below.
cd C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks Online

Execute the command line argument by using the sample below. 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 the provided parameters.

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

You can configure different configurations & 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 the provided parameters.

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

Also, refer to QXL Command line arguments/parameters.ters

T ags: Command line arguments, DOS, parameters

Parameters available in the QXL

Run = The parameter is used for running QXL in the foreground (i.e., QXL will be visible during execution).

example: QXL.EXE Run

Silent = The parameter is used for running QXL in the background (i.e., QXL will not be visible during execution).

example: QXL.EXE Silent

DefaultPath = The parameter is used for setting up the export folder path where the output will be placed.
Note: Folder path should not end with the backslash ("\").

example: QXL.EXE Silent DefaultPath="C:\My Folder\QXL Output Folder"

ExportType = The parameter is used to set up the format of exported files to XLSX, XLS, CSV, SQL, or ODBC.

example: QXL.EXE Silent DefaultPath="C:\My Folder\QXL Output Folder" ExportType="CSV"

ExportIn = The parameter is used for setting up the exported file in Separate Files or single files - values True/False.

UseOptimizer = The parameter is used to enable or disable Optimizer - values True/False.

OptimizerFilePath = The parameter is used to change the Optimizer File location. If you want to store the Optimizer file at a different location, then you can provide the file path where the Optimizer file will be created. - e.g., "C:\QXL\Optimizer"
Note: Folder path should not end with a backslash ("\")

CreateTableForExcel = The parameter is used for creating a table from the sheet (for Excel 2010 or above in [xlsx] format only.) - values True/False

ExcelHeaderColor = The parameter is used for changing Excel Column Header Color (for Excel 2010 or above in [xlsx] format only.)- values Hex color codes without # - e.g., 808080
Refer to HTML Color Codes for more details about the color code.

ExcelTableStyles = The parameter is used for formatting Excel cells by choosing predefined styles (for Excel 2010 or above in [xlsx] format only) - values
Dark1
Dark2
..
Dark10
Light1
Light2
...
Light21
Medium1
Medium2
...
Medium28

TableSelection = The parameter is used for selecting a table from different options (i.e., ALL/Selected Table/Excluding Selected Table). - Value 0=All, 1=Selected tables specified in TablesToExport, 2=other then the tables specified in TablesToExport

TablesToExport = The parameter specifies which table you want to export. values ="Table1,Table2" example -TablesToExport="Vendor,Company,Class"
Note: You need to use "TableSelection" when you specify a table using the "TablesToExport" parameter. If you don't use "TableSelection," QXL will ignore the "TablesToExport" parameter value & export according to the config file setup.

DefaultODBCConnectionName = The parameter is used for defining which ODBC Connection to be used (value is the index of the ODBC connection list) value = 0, 1, or 2
For example, you have created four connections, as shown in the image below. The connection name "SQL" will be used as "Value = 0", in the same way, connection name "MSA" will be used as "Value = 1, & connection name "MYSQL" will be used as "Value = 2".

ConfigFile = The parameter is used for specifying which config file to use. - e.g. "C:\Users\Dewani\config.xml"

ReportQueries = The parameter is used to export specific report(s). -
e.g. ReportQueries= "<ReportQueries><ReportQuery0><Name value="GeneralLedger" /><Value value="sp_report GeneralLedger show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, Memo_Title, SplitAccount_Title, Debit_Title, Credit_Title, RunningBalance_Title, Blank, TxnType, Date, RefNumber, Name, Memo, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisMonthToDate'" /> </ReportQuery0></ReportQueries>"

CustomQueries = The parameter is used for fetching specific table data through your custom query according to your requirement.
e.g. CustomQueries= "<CustomQueries><CustomQuery0><Name value="Txn June" /><Value value="Select * from Transaction where TxnDate >= {d'2017-06-01'} and TxnDate <= {d'2017-06-30'}" /></CustomQuery0></CustomQueries>"

Note: The value of ReportQueries & CustomQueries should not contain any line feed.

SetExportFilesReadOnly = The parameter is used for protecting exported files from unwanted writes. This option will only set exported files to read if you set the value to "True." - values True/False.

Additional Parameters for QuickBooks Desktop Edition

CompanyFilePath = The parameter is used for setting up the QuickBooks company file path in QXL, OR You can use it. (dot) to indicate the currently open company file. QXL will use the company file specified in the config file if you don't set the company file path.
e.g. CompanyFilePath="C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 13.0\sample_product-based business.qbw"

Additional Parameters for QuickBooks Online Edition

QBODefaultConnectionName = The parameter is used for defining which QuickBooks Online Company Connection to be used (value is the index of the QuickBooks Online connection list) value = 0, 1, or 2
For Example, If you have created three connections to QuickBooks Online company as in the below image, then the connection name "Sandbox USA" will be used as "Value = 0", Same way connection name "Sandbox CA" will be used as "Value = 1" & connection name "Sandbox IN" will be used as "Value = 2".

Export data using QXL Parameters

There are two ways to export QuickBooks/QuickBooks Online data using QXL Desktop/QXL Online.
1. Using Parameter file.
2. Provide parameters using command-line arguments.

Example of using a parameters file with QXL

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

QXL Desktop sample parameter file:

QXL Online sample parameter file:

Sample parameter file opened.

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

You can write the parameters in a text file & use a Parameter file with QXL.

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

In the General tab, you will find two buttons that will create the export shortcut on your desktop.

1. QXL - Silent Mode, which will export data in silent mode (does not display the QXL Window).

2. QXL - Direct Export Mode will export data in direct mode (display QXL Window).

In this example, I use the first option (i.e., QXL - Silent Mode).

By clicking on the "Create a shortcut on desktop" button, you will get the below pop-up message & clicking "OK" will create the shortcut on the desktop.

The shortcut is created on the desktop.

Now, we will modify the shortcut by right-clicking on the shortcut & click "Properties."

The shortcut property window is open. Navigate to the "ShortCut" tab & add the below text in the "Target" box & save the configuration by clicking "OK."

"C:\Program Files (x86)\FLEXquarters.com Limited\QXL for QuickBooks\QXL.exe" "C:\Users\Raj\Documents\QXL\ABC Company.txt"

The shortcut is saved on the desktop. You can run it by double-clicking the shortcut.

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

QXL will start exporting data as per the provided parameters.

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

Note: The shortcut supports up to 260 characters in the "Target" box, in which the QXL path took 76 characters. So you can use the shortcut when the command line arguments are limited to under 260 characters. So please ensure that your parameter file path & QXL path character total do not exceed 260 characters. Please shorten the parameter file path if it exceeds 260 characters.

Also Refer: How to use QXL with a scheduler for multiple company files.

Tags: Command line arguments, shortcuts, background, silent, parameters

Problem Description:

I am using QXL & I want to balance the sheet with a class report through QXL. I can see the information on the list. But I want to change the report parameter.

How can I change the report parameter & run the updated report?

Solution:

You can change the report parameter from the QXL Report Settings tab.

The first step in changing the report parameter is to click on the settings icon for QXL options details.

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

You can see the default report query in the Report Query/Command box.

You can modify the report query from the Report Query/Command box.

You can refer to the QODBC Data Layouts site for details about different report parameters.

Navigate to the above link & click on the region of the QuickBooks edition you are using.

You will be redirected to the QuickBooks region link. Click on the "ALPHABETICAL LISTING OF ALL REPORTS" under the "REPORT OVERVIEW" label.

You will be presented with a list of reports. Search for the "BalanceSheetByClass" report & click on "Parameters" to get details about all supported parameters for the BalanceSheetByClass report.

If you are a QuickBooks USA user, then you can refer to the direct link for PARAMETERS AND VALUES FOR: BalanceSheetByClass.

You can use any of the supported parameters in the report query.

I am changing the report query by adding the AccountFilterType parameter & changing the date period by using the DateFrom & DateTo parameters.

For Example: sp_report BalanceSheetByClass parameters DateFrom = {d'2021-01-15'}, DateTo= {d'2021-06-30'}, AccountFilterType='AccountsReceivable'

You need to modify the report query & click the "Add or Update" button to update the report query.

The modified report query & was added to the export list.

By repeating the above process, you can add a different report with different supported parameters per your requirement.

The report will be exported by clicking on the Export icon from the QXL Main Window.

Report Exported.

QXL Professional Edition options and settings / Configuration:

The first step in configuring the application is to click on the settings icon for QXL options details & navigate to the Pro Edition tab.

Pro Edition Tab:

You can export QuickBooks Data into SQL Server & ODBC database using the Pro Edition Table. Please refer to the details for each option.

1. SQL / ODBC Connection:- You can see the list of added connections from the drop-down list.

2. Add New:- You can add a new SQL / ODBC connection by clicking on the "Add New" button.

3. Connection Name:- You can insert any value for Connection Name. Using the Connection Name, you can recognize the SQL / ODBC connection that you want to configure.

4. Connection String:- You need to insert a valid connection string for connecting to the SQL / ODBC database.
Sample SQL Server Connection String Format: Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;
Sample ODBC Connection String Format: DSN = Data Source Name

5. Connection Type:- You can choose the connection type using this option.
If you want to export data to the SQL Server database, select "SQL Server Driver" as a Connection Type.
If you want to export data to the ODBC database, select "ODBC Data Source" as a Connection Type.

6. TableName Prefix:- You can set the prefix before exporting tables. The default TableName Prefix is "QXL." So all exported table names will have the prefix "QXL" (i.e., QXLAccount, QXLCustomer, QXLInvoice, et.).

Note: You should use a unique TableName Prefix, which is unavailable in your database. If you use TableName Prefix, which is already available in the destination database, then the destination table data will be replaced.

It would be best if you used a unique TableName Prefix, unavailable in your database. For Example, if you use TableName Prefix "TB" & you already have a table in your database with Prefix "TB," the destination table data will be replaced with source data. To avoid this type of issue. It would be best if we use "QXL" as a prefix.

7. Mapping Type:- You can set the ODBC Mapping Type for a different database from the drop-down list. You can select the mapping type:

• Microsoft Access for MS Access database.
• Microsoft SQL Server for SQL Server database.
• MySQL Server for MySQL database.
• Firebird Database for Firebird database.
• Others/Custom Mapping for the rest of the ODBC Database.

Others/Custom Mapping:- You can set custom mapping for different data types as per your destination database. If your ODBC database supports a different data type instead of the type mentioned below, then you need to write the data type name in the textbox for the respective data type.

• Int16: It is a value type. It has a minimum capacity of -32768 and a Maximum capacity of +32767. It is signed and takes 16 bits.
• Int32: It is a value type. It has a stored minimum capacity of -2147483648 and a Maximum capacity of +2147483647. It is signed and takes 32 bits.
• Int64: It is a value type. It is signed and takes 64 bits. Its stored Minimum capacity is 9,223,372,036,854,775,808, and its Maximum capacity is +9,223,372,036,854,775,807.
• Boolean: The Boolean type represents the values true and false. Boolean data refers to the logical structure of how the machine language interprets the language. Boolean data refers to the logical structure of how the machine language interprets the language. Boolean data refers to the logical structure of how the machine language interprets the language. Although only two values are possible, they are rarely implemented as a single binary digit for efficiency reasons.
• Byte: A group of binary digits or bits (usually eight) operated on as a unit.
• Decimal: A decimal number, or just decimal, refers to any number written in decimal notation, although it is more commonly used to refer to numbers that have a fractional part separated from the integer part with a decimal separator.
• Double: Double-precision numbers store an approximation of an actual number. Double precision floating-point. It will handle most decimals.
• DateTime: The DateTime type is used for values that contain both date and time parts.
• String: A string is a sequence of characters, either as a literal constant or as a variable.
• Memo: A Memo field can help store large amounts of alphanumeric information. The Memo data type allows up to 65,536 alphanumeric characters with options to set several properties, such as rich text formatting. Some typical uses for this data type would be a note, comments, description, or address field.
• Keyword Escape Chars: It will be used to escape a character mentioned in the first textbox with a character mentioned in the second textbox.
  For example, if you want to change ` with,' then you need to write ` in the first textbox & ' in the second textbox.
• Field Name Limit: If your database supports a limited table/field name length, then you can set a limit from this textbox.
  For Example, if you write 20 in the Field Name Limit text box, then all table & field names are created within the 20-character limit.
• Boolean Value: You can configure a Boolean value as either 1:0 or True: False.

8. Delete:- You can delete unwanted connections by clicking on the "Delete" button.

9. Save:- You can save/update connection information by clicking on the "Save" button.

Problem Description:

I am using QXL & I want to export QuickBooks Data to an ODBC Database.

How can I export QuickBooks Data to an ODBC Database using QXL?

Solution:

You can export QuickBooks Data to an ODBC Database using QXL.

In this example, we will show you how to export QuickBooks Data to SQLITE (ODBC Database) using QXL.

First, you need an ODBC connector to connect to the ODBC database.

You need to download & install the ODBC connector on your system.

After installing the ODBC connector, you need to configure the ODBC DSN, which will point to the ODBC Database.

I have already created an ODBC DSN for SQLite. Below is the property of the DSN.

We will use this DSN in QXL. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "Others/Custom Mapping" as a Mapping Type.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=SQLITE

You can configure data mapping as per your ODBC Database. You can choose different data types as per your ODBC Database.

For example, if your ODBC database supports smallint instead of Int16, then you need to write smallint in the text box of Int16. In the same way, you can change ODBC Mapping for different datatypes as per your ODBC Database.

After changing the ODBC Mapping as per your ODBC Database, click the "Test Connection" button.

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into an ODBC Database. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to the SQLITE (ODBC Database).

Problem Description:

I am using QXL & I want to create a report that will pull the following items.

Selectable Date Range, Invoice Number, Ship to Address 1-5, Ship to City, Ship to State, Ship to Zip, PO#, Item, Qty.

How to export QuickBooks Data daily for the current date filter using QXL?

Solution:

You can export QuickBooks Data daily for your desired date using QXL.

The first step is to start QXL. Click the Options/Settings icon.

Under the "General" tab, click "Comma Separated Value (CSV)."

To add a desired date filter, you need to create a custom query & add it to the export list.

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

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 query.

For Example:

SELECT {fn CURDATE()} as DateRange, RefNumber as InvoiceNumber, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4, ShipAddressAddr5, ShipAddressCity, ShipAddressState, ShipAddressProvince, ShipAddressCounty, ShipAddressPostalCode, ShipAddressCountry, ShipAddressNote, PONumber As PO#, SalesOrderLineItemRefFullName, SalesOrderLineQuantity As QTY FROM SalesOrderLine where {fn CURDATE()} = TxnDate

If you wish to pull the last 7 days' data, you may use the query below.

For Example:

SELECT {fn CURDATE()} as DateRange, RefNumber as InvoiceNumber, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4, ShipAddressAddr5, ShipAddressCity, ShipAddressState, ShipAddressProvince, ShipAddressCounty, ShipAddressPostalCode, ShipAddressCountry, ShipAddressNote, PONumber As PO#, SalesOrderLineItemRefFullName, SalesOrderLineQuantity As QTY FROM SalesOrderLine where TxnDate >= ({fn CURDATE()}-7) and TxnDate <= ({fn CURDATE()})

Click "Close" to save the configuration, & You should be back to the QXL Main screen.

The data will be exported by clicking on the Export icon from the QXL Main Screen.

The data is exported into a CSV file.

Also Refer: How to use QXL with Scheduler.

Problem Description:

I am using QXL & I want to export QuickBooks Data to SQL Server.

How can I export QuickBooks Data to SQL Server using QXL?

Solution:

You can export QuickBooks Data to SQL Server using QXL. There are two ways to export QuickBooks Data to SQL Server.

1. Using SQL Server default driver.
2. Using SQL Server ODBC Driver

Using the SQL Server default driver

The first step in adding an SQL Server connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "SQL Server Driver" as a Connection Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample SQL Server Connection String Format: Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

For Example: Server=WIN-O8RQBVCMJFC;Database=Desktop;User Id=sa;Password=sa;

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into SQL Server. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to the SQL Server.

Using SQL Server ODBC Driver

First, you need to create an ODBC DSN for SQL Server, which will point to your Database.

I have already created an ODBC DSN for SQL Server below the properties of the DSN.

SQL Server ODBC DSN test connection successful. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "Microsoft SQL Server" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=QXLSQL

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into SQL Server. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to the SQL Server.

Problem Description:

I am using QXL & I want to export QuickBooks Data to MySQL.

How can I export QuickBooks Data to MySQL using QXL?

Solution:

You can export QuickBooks Data to MySQL using QXL.

First, you need a MySQL ODBC connector to connect to the MySQL database.

You need to download & install the MySQL ODBC connector on your system.

Refer: Download Connector/ODBC to download the MySQL ODBC connector.

After installing the MySQL ODBC connector, you need to configure the MySQL ODBC DSN, which will point to the MySQL Database.

Refer: Configuring a Connector/ODBC 5. x DSN on Windows to configure MySQL ODBC DSN.

I have already created an ODBC DSN for MySQL. Below is the property of the DSN.

MySQL ODBC DSN test connection successful. We will use this DSN in QXL. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "MySQL Server" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=MYQXLANSI

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now the data is ready to export into MySQL. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to MySQL.

Problem Description:

I am trying to export data from QXL. I have selected ItemAssembliesCanBuild & other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the following error message after export.

ERROR [00000] [QODBC] Error: 3120 - Object "X" specified in the request cannot be found. 

Solution:

ItemAssembliesCanBuild Query does require ItemInventoryAssemblyRef(ListID or FullName) and TxnDate in the WHERE Clause to perform the query in QuickBooks SDK.

You will get this error when you execute a query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate.

So it would be best to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through a custom query. 

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 query.

For Example:
SELECT * FROM ItemAssembliesCanBuild where ItemInventoryAssemblyRefFullName='assembly item' and TxnDate={d'2018-01-01'}

After adding the query, please try to export again. You will not get the error.

Problem Description:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the error message below.

The current version of QuickBooks cannot work with the specified company data file.

Error Occurred:[QODBC] QuickBooks Begin Session Failed. Error = 80040409. The current version of QuickBooks cannot work with the specified company data file.

Solution:

You may encounter the above error when your QuickBooks company file is updated to a higher version of QuickBooks, and you are trying to use it in an older version of QuickBooks.

For Example:

If you try to open the QuickBooks 2017 company file in QuickBooks 2016 or a lower version, you will get the above error.

You can open QuickBooks company files in the same version or a higher version of QuickBooks. However, you can't open QuickBooks company files in older QuickBooks versions.

Problem Description:

I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the below error after export.

ERROR [42S00] [QODBC] Column not found

Solution:

There might be some syntax issues in your query.

You will get this error When you use the wrong column name in the query.

Please verify the column name used in your custom query and try again.

Please refer to QODBC Data Layout (Schema) for more detail about table schema.

Problem Description:

I am trying to export data using QXL. After that, I clicked on the QXL export button I got the following error after export.

[QODBC] Error: 3260 - Insufficient permission level to perform this action

Solution:

You may encounter the above error if the QuickBooks user does not have permission to access data in QuickBooks.

Please try removing "FLEXquarters QODBC " from the Integration Application and try to connect.

Refer to how to remove QODBC Related Certificates from Integrated Application Under QuickBooks for more details.

If a currently logged-in QuickBooks user is restricted from accessing a particular module in the QuickBooks Application (UI), the user will not be able to access the same from QXL.

QXL uses QODBC, and QODBC uses QuickBooks SDK to communicate with QuickBooks. QuickBooks SDK, by default, currently uses the logged-in QuickBooks user access right. Integrated Application user rights will be overridden if any user is logged into the QuickBooks Application (UI).

Refer to User Access Rights within QuickBooks for more details.

Problem Description:

I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the following error after export.

Invalid field definition

Solution:

You may encounter the above error when there is a data type schema mismatch in the ODBC database while creating the new table or inserting the record into the destination database.

In this case, you need to raise a support ticket with us under the department "QXL Technical Support."

Please share QXL & SDK logs, Screenshots of the issue, & Screenshots of all the tabs QXL Option/Settings Tabs.

You can find logs from QXL Setting -- > Advanced -- > Messages -- > Review QXL Messages & Review SDK Messages

You may Click Here to raise a support ticket.

Problem Description:

I am trying to export data from QXL. I have used Custom Query. After that, I clicked on the QXL export button I got the following error after export.

ERROR [42S00] [QODBC] Invalid table name

Solution:

There might be some syntax issues in your query.

You will get this error when you use the wrong Table name in the query.

Please verify the table name used in your custom query and try again.

Please refer to QODBC Data Layout (Schema) for more details about the table schema.

Problem Description:

I am trying to export data from QXL. After that, I clicked on the QXL export button I got the following error after export.

Object reference not set to an instance of an object

Solution:

Please update QXL to the latest version.

You can download QXL's latest version by clicking here.

If you still face the issue, please raise a support ticket with us under the department "QXL Technical Support."

Please share QXL & SDK logs, Screenshots of the issue, & Screenshots of all the tabs QXL Option/Settings Tabs. You can find logs from QXL Setting -- > Advanced -- > Messages -- > Review QXL Messages & Review SDK Messages

You may Click Here to raise a support ticket.

Problem Description:

I am trying to export data from QXL. I have selected Transaction & other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the following error message after export.

System.OutOfMemoryException

Solution:

You will get the above error if your table contains extensive data.

As your table contains many records, you need to put limits on your query & export data.

So it would be best if you executed the query through a custom query.

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 query.

For Example:
select * from Transaction where TxnDate >= {d '2016-10-01'} AND TxnDate <= {d '2016-11-01'}

In the same way, you can add the query for the different date periods.

After adding the query, please try to export again.

Problem Description:

I am trying to export data using QXL. After that, I clicked on the QXL export button I got the following error after export.

Error when attempting to update the value

Solution:

Please update QXL to the latest version.

You can download the latest version by clicking here.

If you are still facing the issue, your company file might have some data issues.

Please raise a support ticket with us under the department "QXL Technical Support." 

Please share QXL logs, a Screenshot of the issue, & Screenshot of all the tabs of QXL Option/Settings Tabs. You can find logs from QXL Setting -- > Advanced -- > Messages -- > Review QODBC Messages

You can Click Here to raise a support ticket.

If possible, please share your company file with us

Refer: How to zip and upload the company file

Problem Description:

I am trying to export data to my ODBC database using QXL. After that, I clicked on the QXL export button I got the following error after export.

Syntax error in CREATE TABLE statement

Solution:

There might be a syntax error when creating the ODBC database table at export time.

In this case, you need to raise a support ticket with "QXL Technical Support."

Please share QXL logs & raise a support ticket. You can find logs from QXL Setting -- > Advanced -- > Messages -- > Review QODBC Messages

You can Click Here to raise a support ticket.

Refer: How to connect/reconnect QXL Online

Step 1 - Download QXL Online

If you haven't already downloaded QXL Online, go to the download page now. 

Don't forget to read the "Readme" file during installation for the latest information on QXL Online setup, new features, and other driver information. 

Save the self-extracting executable "QXLOnlineSetup.exe" in a temporary directory or your "My Documents" folder to extract the installation files.

Step 2 - Running the Installer:

Click on the Install program from within Windows to install the driver. Select the destination directory to install the QXL Online support files. Click "OK" to continue. 

The QXL - QuickBooks Online Data Export Made Easy® has been successfully installed on your computer. You can begin to use it because it will immediately run as a 30-day evaluation version. 

Refer: How to connect QXL Online with QuickBooks Online

Problem Description:

I am trying to export data from QuickBooks Online using QXL Online. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in QXL Online.

After reviewing the Output folder, I noticed some of the tables are not exported & found the following error in the error logs from the export table folder:

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: ValidationException was thrown. At Intuit.Ipp.QueryFilter.QueryService`1

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: The Response Stream was null or empty.

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: No connection could be made because the target machine actively refused

ERROR [00000] [QODBC] Error: 10000 -. QuickBooks message: An existing connection was forcibly closed by the remote host

GatewayTimeout error

Solution:

The above-mentioned error is returned randomly from the Intuit API. Sometimes, the Intuit API does not provide the proper response to data requests & may throw the above error.

When you receive such an error, you need to retry & export a particular table.

Tags: QuickBooks Online, QBO, QXL Online, API

In this example, we will show you how to get data from two or more tables into a single spreadsheet.

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

Now we change the exported file configuration from the General tab Export In Single File option.

Now we will configure the table export option from the Table Settings tab.

We will choose the Selected Table option & select the table which you want to export.

In this tutorial, I select three tables (i.e., Account, Bill, and BillingRate). After selecting the table, click on close to save the configuration.

Now we will export data by clicking on the Export data icon.

QXL has started exporting tables.

Export completed.

The exported file got opened. All three tables are exported into one spreadsheet.

Problem Description:

I want to refresh my spreadsheet automatically from the QXL-exported spreadsheet. So, my spreadsheet data gets updated automatically using the QXL exported spreadsheet.

How to create an MS Excel spreadsheet that automatically updates data from QXL exported Excel files? 

Solution:

Note: In recent versions of Microsoft Excel (including Excel 365), the Microsoft Query (Legacy) feature is hidden by default from the Get Data tab.
Please refer to Troubleshooting - How to enable Microsoft Excel 365 - Legacy Microsoft Query.

Please follow the steps below to create an MS Excel spreadsheet, which gets updated data automatically from the QXL exported spreadsheet data:

1. Create a New MS Excel file. 

2. Navigate to the "Data" tab & click on "Connections" to add a QXL exported spreadsheet connection.

3. Add a connection by clicking on "Add."

Click on "Browse for More."  

Navigate to the XL Exported sheet folder. 

The Default QXL Export sheet folder path is "This PC" --> "Documents" --> "QXL" --> YourQuickBooksCompanyName.

In this example, the QXL export sheet folder path is: "This PC" --> "Documents" --> "QXL" --> Rock Castle Construction.

Select the QXL exported Excel file that you want to use as a source & click on "Open."

Click "OK."

Connection added. Click the "close" button.

4. Import Data from the added connection by clicking on "Existing Connection."

Select the connection & click on "Open."

Configure the Imported Data property & click "OK."

5. Data Imported.

Now we are hiding a column that we don't want to use. You can hide column/columns by selecting a column/columns suitable, clicking on it, & click on "Hide."

In this example, I want to see only an Unpaid Invoice. So, I have filtered the IsPaid column.

I have added a new column, Due Date, which will get data from the DueDate field. We are converting this DueDate data to a date using the DATEVALUE function.

By converting it to a DateTime data type, the value displayed in Excel is numeric, and the correct value is shown only after formatting the cell.

Now we will hide the Original DueDate column & add the Aging column, which we use for counting the Aging Days of the invoice payment due.

We can count aging using the DATEDIF function.

Now, let us sort the data according to the customer name & use conditional formatting to show aging data. 

After applying all the formatting, the data looks as follows.

To refresh your Excel sheet report, use the QXL Application and click the "Export" button. Once your source is updated, you can restore your Excel sheet.

To refresh the Excel sheet report, click the "Refresh All" button from the menu Data-->Refresh All menu.

Problem Description:

I am trying to export data from QXL. After the export is completed. I got the "Export Completed. One or more tables were not exported" status in QXL.

After reviewing the Output folder, I noticed some of the tables are not exported & found the following error in the error logs from the export table folder:

This feature is not enabled or not available in this version of QuickBooks. 

Solution:

This is not an error. This is only a warning and can be safely ignored. You will receive this warning when QXL tries to access a feature in QuickBooks that is not available in your installed QuickBooks version. You will not receive this warning if you exclude the tables that produce the warning(s) from the export list.

Problem Description:

I have installed QXL and QuickBooks. I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I click on the QXL export button, I get a message from QuickBooks saying The certificate is invalid.

Solution:

Please download & install QXL's latest version & test again.

If the above does not resolve the issue, then please follow the steps below:

Please make sure you are connected to the internet from the machine to validate the certificate.

Please check the property at c:\Windows\SysWOW64\qxlfqqb32.dll or c:\Windows\System32\qxlfqqb32.dll from the Digital Signature tab.

Please click on Details to check the certificate.

Please click on Install Certificate to install a certificate.

Please follow the installation steps below.

Please finish the installation by clicking on Finish. After installation, please restart the machine and test the connection.

If the above solution does not work, then you need to manually install the certificate by using the link below:

http://www.symantec.com/business/support//index?page=content&pmv=print&impressions=&viewlocale=&id=TECH218029

Problem Description:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the error message below.

Unable to connect to QuickBooks. Ensure that QuickBooks is installed and running on this machine and that it is logged in as an Administrator to the Company file.

Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. S0000 00000 [QODBC] QuickBooks Begin Session Failed. Error = 80040408, Could not start QuickBooks.

Solution:

The error message above indicates that QuickBooks is not running.

Step 1: Launch QuickBooks and Open the Company File

Open QuickBooks Desktop.

Log in to the desired company file using the QuickBooks user "Admin".

Log in to QuickBooks as the "admin" user to authorize the connection to the QuickBooks company file.

This is a one-time activity for each new application you want to connect to QuickBooks Data.

Step 2: Test connection using QXL

Go to Start → QXL

Click the Export/Run button.

Problem Description 1:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message.

Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine and is logged in as Admin to the Company file. Make certain the QuickBooks Company file is in Single User Mode and try again. Or try removing the QXL Integrated application certificate in QuickBooks. Steps: Start QuickBooks Pro/Premier/Enterprise, log in to your company file as 'Admin,' switch to 'Single user mode,' go to File->Preferences, select the integrated applications area, Select 'FLEXquarters QODBC,' Click Properties, verify it is QXL. Switch to QXL and click Export. Click OK, and remove the QXL-related integrated Applications.

Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 8004041a. This application does not have permission to access this QuickBooks company data file. The QuickBooks administrator can grant access permission through the Integrated Application preferences.

Problem Description 2:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message.

Unable to connect to QuickBooks. Solution: Try removing the QXL Integrated application certificate in QuickBooks. Steps: Start QuickBooks Pro/Premier/Enterprise, log in to your company file as 'Admin,' switch to 'Single user mode,' go to File->Preferences, select the integrated applications area, Select 'FLEXquarters QODBC,' Click Properties, verify it is QXL. Switch to QXL and click Export. Click OK, and remove the QXL-related integrated Applications.

Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 80040420, The QuickBooks user has denied access.

Problem Description 3:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message.

Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine and is logged in as Admin to the Company file. Make certain the QuickBooks Company file is in Single User Mode and try again. Or try removing the QXL Integrated application certificate in QuickBooks. Steps: Start QuickBooks Pro/Premier/Enterprise, log in to your company file as 'Admin,' switch to 'Single user mode,' go to File->Preferences, select the integrated applications area, Select 'FLEXquarters QODBC,' Click Properties, verify it is QXL. Switch to QXL and click Export. Click OK, and remove the QXL-related integrated Applications.

Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. S0000 00000 [QODBC] QuickBooks Begin Session Failed. Error = 8004041d. This application cannot log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for an automatic login through the Integrated Application preferences.

Solution:

Please make sure QuickBooks runs on this machine, and the user is logged in as Admin to the Company file. Also, make certain the QuickBooks Company file is in Single User Mode and try to connect again.

It should pop up the Data Access Certificate on QuickBooks. Please accept the Certificate & test again.

If the above does not resolve the issue, please start QuickBooks, log in as Admin, and switch QuickBooks to single-user mode.

Try removing "Flexquarters QODBC" from the Integration Application in QuickBooks.

Please refer to how to remove QODBC Related Certificates from Integrated Application Under QuickBooks.

After performing the above steps, try to connect again.

Tags: Unable to connect to QuickBooks using QXL

Problem Description:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message.

Unable to connect to QuickBooks. Make sure QuickBooks runs on this machine, and the Company file is loaded.

Error Occurred: ERROR [00000] [QODBC] Begin Session Failed. S0000 00000 [QODBC] QuickBooks Begin Session Failed. Error = 80040417. If the QuickBooks company data file is not open, a call to the "BeginSession" method must include the name of the data file.

Solution:

Please navigate to QuickBooks & make sure that QuickBooks is running & the company file is loaded in QuickBooks. If the QuickBooks company file is not loaded in QuickBooks, you will get this error.

Problem Description:

I am trying to export data from QXL. But when I clicked on the QXL export button, I got the following error message.

Unable to connect to QuickBooks. Popup window(s) in the QuickBooks application MUST be closed before QXL can communicate with QuickBooks.

Error Occurred: ERROR [00000] [QODBC] QuickBooks Begin Session Failed. Error = 80040414. A modal dialog box is showing in the QuickBooks user interface. Your application cannot access QuickBooks until the user dismisses the dialog box.

Solution:

Please navigate to QuickBooks & make sure that there is no modal pop-up window open in QuickBooks. If any modal pop-up window is available in QuickBooks, you will get an "Error = 80040414; A modal dialog box is showing in the QuickBooks user interface....". QuickBooks says that a modal connection is active for this part of QuickBooks, and you need to wait.

It would be best if you closed this modal popup window in QuickBooks & export data using QXL.

QXL does not have control over the modal pop-up window in QuickBooks. QXL cannot suppress or bypass this type of dialogue. It would be best if you disabled the modal pop-up from QuickBooks.

Tags: Unable to connect to QuickBooks using QXL

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 the SQL / ODBC Connection String.

Note: A 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 follows:

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 only have to get the differential records instead of the entire data set from QuickBooks. As a result, you will notice a 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. 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, the 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 the Table Settings Tab, you can change table options as follows:

1. ALL tables: - 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 the Custom Query Tab, you can write your custom query and fetch data according to your requirements.

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 the 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 the CD Key & click on "Manual."

Pro Edition Tab:

You can export QuickBooks Data into SQL Server & ODBC database using the Pro Edition Tab. Please refer to the link below 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:
The 
About screen shows the QXL version currently installed, whether it is an evaluation copy or a fully registered copy. 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

Problem Description:

I was able to use QXL earlier. Our company recently upgraded to QuickBooks Pro 2016 and can no longer connect with QXL, as it says QXL is not licensed for this QuickBooks edition.

Solution:

QXL licensing is not upward compatible, only backward, meaning you need a registered 2017 QXL License CDKEY to work with QuickBooks 2017. QXL 2017 license CDKEY will work with QuickBooks 2002- 2017 Pro and Higher.

For Example:

A QXL 2016 License will allow you to connect to QuickBooks 2002- 2016 Pro and Higher. But you can't use it with QuickBooks 2017.

To use QuickBooks 2017, you need to purchase a QuickBooks 2017 license CDKEY. Please get in touch with our sales team to purchase/upgrade the license.

Step 1 - Download QXL

If you haven't already downloaded QXL, go to the download page now. Don't forget to read the "Readme" file during installation for the latest information on QXL setup, new features, and other driver information. Save the self-extracting executable "QXLSetup.exe" in a temporary directory or your "My Documents" folder to extract the installation files.

Step 2 - Running the Installer:

Click on the Install program from within Windows to install the driver. Select the destination directory to install the QXL support files. Click "OK" to continue.

The QXL - QuickBooks Export Made Easy® has been successfully installed on your computer. You can begin to use it because it will immediately run as a 30-day evaluation version.

Step 3 - Use QXL:

After installation, you may notice the following icons on the desktop.

QXL – Silent Mode - It uses the last saved settings of QXL and automatically starts executing the data export with no user interface.QXL – Direct Mode - It uses the previously saved settings of QXL and automatically starts executing the data export with the user interface, i.e., displaying progress data export.QXL – Manual execution of Data Export/Update Settings/Activation-Deactivation. You can select tables and destinations to which the files should be exported. Start QuickBooks, log in to your company file, switch back to QXL, and click Export Data.

After the export is completed. The exported data folder will open.

Exported data is placed at the below location by default: C:\Users\User Name\Documents\QXL\

QXL Features:

1. Export QuickBooks Data to XML format via QODBC.

2. Export QuickBooks Data to CSV format via QODBC.

3. Ability to choose export file(s) location.

4. Ability to export to Separate files or a single file.

5. Ability to export all selected, tabled, or excluded tables.

6. Ability to save your default settings from Options.

Also, Refer:
QXL options and settings