Getting Error while exporting Quickbooks desktop data through Microsoft Data Exporter Tool

Question

Hello,

I am using Microsoft Data Export Tool to export my QuickBooks Desktop data.

I am able connect to QuickBooks using data export tool. On clicking of export button, it exports 3 items , Account , Bills and Credit Memo. As it starts to export Customer I get the following error, where it tells there is something wrong with byte.

I am attaching the error images as well as the detailed error.

I am not able to figure out how to resolve this issue.

Detailed ERROR

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80040301): An exception occurred! Type:UTFDataFormatException, Message:invalid byte 2 (x) of a 3-byte sequence.SAXParseException: error at line 2379, column 20 in XML data.
   at Interop.QBFC13.IQBSessionManager.DoRequests(IMsgSetRequest request)
   at Microsoft.DataMigrations.QBDConnector.QBDDataContext.QBSession.InvokeRequest[TResponse](Action`1 constructRequest)
   at Microsoft.DataMigrations.QBDConnector.QBDDataContext.<GetCustomers>b__17_0()
   at Microsoft.DataMigrations.QBDConnector.QBDDataContext.InvokeWrappedException[TResult](Func`1 invoke)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9290.0 built by: NET481REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Microsoft.DataMigrations.WindowsDesktopApp
    Assembly Version: 1.0.10.16
    Win32 Version: 1.0.10.16
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Data%20Exporter/Microsoft.DataMigrations.WindowsDesktopApp.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9251.0 built by: NET481REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9282.0 built by: NET481REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0 built by: NET481REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0 built by: NET481REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9277.0 built by: NET481REL1LAST_B
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0 built by: NET481REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0 built by: NET481REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.DataMigrations.QBDConnector
    Assembly Version: 1.0.10.16
    Win32 Version: 1.0.10.16
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Data%20Exporter/Microsoft.DataMigrations.QBDConnector.DLL
----------------------------------------
System.ComponentModel.Composition
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.Composition/v4.0_4.0.0.0__b77a5c561934e089/System.ComponentModel.Composition.dll
----------------------------------------
Newtonsoft.Json
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.1.19813
    CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Data%20Exporter/Newtonsoft.Json.DLL
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0 built by: NET481REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Runtime.Serialization
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9241.0 built by: NET481REL1LAST_C
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
----------------------------------------
System.Xml.Linq
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9037.0 built by: NET481REL1
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.8.9214.0 built by: NET481REL1LAST_B
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

RCV · Answer

We know how hard it is to experience issues with exporting your QuickBooks data through the Microsoft Data Exporter Tool, AGBT900. Especially when you're trying to get important tasks done. Let's perform some troubleshooting steps to export customer data.

We appreciate you for providing us with a screenshot and in-depth details of your concern. Let's make sure we have an updated version of the Microsoft Data Exporter Tool since older versions may not work properly with newer QuickBooks Desktop versions. Then, try exporting the data again.

If the dataset is large, try exporting the customer list in smaller batches to help us isolate any damaged data entries. You can also filter the data by date range or alphabetically divided segments to make it more manageable. Then, we need to identify if a specific part of the data is causing the issue. To learn more about exporting info with QuickBooks Desktop, you can check out this article: Import and export data in QuickBooks Desktop.

If the same thing happens, ensure your QuickBooks version meets the following criteria:

Your operating system and QuickBooks are fully updated.
The Microsoft Data Exporter Tool and QuickBooks Desktop are compatible with your operating system and meet all system requirements.
Your system meets the minimum requirements specified by Intuit for QuickBooks Desktop of the version you're using.

Once done, check you have proper permissions to access the QuickBooks company file before exporting the customer's data. The Windows user account running the Data Exporter needs full access. Right-click the application icon and select Run as administrator to run QuickBooks or the Data Exporter Tool as an administrator.

Moreover, you can refer to these articles to help you import and export lists or files to and from QuickBooks Desktop:

The Community is only one post away if you need help with exporting your company data or have any QuickBooks-related concerns. We are always here to help, AGBT900.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded