Problem Description:

How to export QuickBooks Data to OpenOffice using QXL

Solutions: 

Download and install OpenOffice on your system.

Start QXL Desktop

Export the QuickBooks Company Data

Once the export is complete, the output folder showing the list of files will open automatically.

The output folder will contain the exported files.

Start your OpenOffice application on your Desktop.

Click on the "Open" option to navigate the exported files' Output folder.

Double-click on any file to open it with the OpenOffice application.

Or

Select any file and click on "open" with the OpenOffice application.

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 using QXL & I want to export QuickBooks Data to MS Access.

How can I export QuickBooks Data to MS Access using QXL?

Solution:

You can export QuickBooks Data to MS Access using QXL.

First, you need to create an MS Access database file (.accdb) and save it to your disk drive.

Create a new ODBC DSN for MS Access, which will point to the MS Access Database.

Search for ODBC or navigate to C:\Windows\SysWOW64\ folder and find odbcad32.exe and double click on odbcad32.exe

Switch to System DSN

Select Microsoft Access Driver (*.mdb, *.accdb)

Input the Data Source Name and click "Select."

Navigate to the folder containing your MS Access database file.

I have already created an ODBC DSN for MS Access below the properties of the DSN. 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 Access" 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=QXLMSA

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 MS Access. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to MS Access.

Problem Description:

I want to export QuickBooks Data using QXL.

I want to schedule QXL for exporting QuickBooks Data. So it will automatically ship QuickBooks Data at the scheduled time.

But I don't know how I can use QXL with the Scheduler.

Solution:

You can configure the QXL export option by creating the shortcut using QXL & can use the shortcut in the scheduler.

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

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

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

For example, QXL.exe Silent

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

For Example, QXL.exe Run

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

The shortcut is created on the desktop.

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

Use Scheduler:

You can use any desktop-based scheduler (for example, "QScheduler"). QuickBooks and QuickBooks SDK are desktop-based and not designed to run as a service. QODBC & QXL are also desktop-based applications. Thu,s you will need an active desktop session (someone logged into the machine). You may not be able to use the service-based scheduler like "Task Scheduler." In this example, we are using Z-Cron, but you can use any other desktop-based scheduler.

Please refer to the following article for how to install QScheduler - https://qxl1.com/links/3047

QScheduler can be accessed from the Desktop.

QScheduler can also be accessed from the Windows Start Menu.

When the application starts for the first time, it will contain no tasks.

Click the "Ok" button to continue.

To create a new scheduled task, click the "Add" button.

Input the "Task Name", then click the browse button to select the application/batch file you want to run on a regular interval.

In this example, we will use the QXL Application and schedule it to export all the data of the QuickBooks company - "QuickBooks company A".

To identify the task, I am naming the task “QXL CompanyA Hourly Export”.

You can add multiple tasks if you wish to export data from various QuickBooks companies.

After the application is selected, it will automatically populate the working directory.

The ‘Working Directory’ option is useful if your application or script is looking for a file in the current folder, so you can set the current folder to where the file is.

If you wish to change the ‘Working Directory’, you may click the browse button next to the ‘Working Directory’ input box.

You can specify the command-line arguments/parameters required by your application.

In this example, I will be using the QXL Parameter file, which contains the settings being passed to the program. For more details about the QXL Parameter file, please refer to http://qodbc.com/links/2938.

Input the starting time and date to begin the task and the repeat interval.

Click Close to save the task and return to the ‘Task List&rsquo.

For QScheduler Options/Settings, click the Wrench Icon.

Enable Start QScheduler automatically when you sign in to Windows.

Click on the ‘Close’ button to close the form.

To minimize the QScheduler to the System Tray, click the minimize icon.

To maximize QScheduler, click the ‘QScheduler’ icon from the system tray.

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

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