Hello Community,
I attempted to migrate data from QuickBooks Desktop to Business Central using the Microsoft Data Export Tool but encountered an error during the process.
Additionally, I am using QuickBooks Desktop 22.0, whereas Microsoft's documentation states that the Data Export Tool is only compatible with QuickBooks versions 2017 and 2018. Given this limitation, I am unsure how to proceed.
I would appreciate any suggestions or alternative approaches to resolve this issue. One option I am considering is migrating QuickBooks Desktop to QuickBooks Online first, and then transferring data from QuickBooks Online to Business Central. Has anyone tried this approach for migration?
Below is the error message I encountered when exporting data from QuickBooks using the Data Export Tool:
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:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
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.
---------------------------------------------------------------------------------------------------------------------------
Any insights or recommendations would be greatly appreciated!
Thanks in advance.