Error message when you convert Intuit QuickBooks data by using the Rapid Migration Tool (RMT) for Microsoft Dynamics GP: "Illegal characters in path"

Article ID: 958367 - View products that this article applies to.
Expand all | Collapse all

Symptoms

Assume that you use the Rapid Migration Tool (RMT) for Microsoft Dynamics GP to convert Intuit QuickBooks data into the Microsoft Excel format. However, when you perform the "Exporting data into Excel" process, you receive the following error message:
Location: ExcelManager.InitializeExcelManager
Exception Type: System.ArgumentException
Source: mscorlib Message: Illegal characters in path.
TargetSite: CheckInvalidPathChars
HelpLink:

Workaround

To work around this problem, delete the special characters from the company name in Microsoft Dynamics GP 10.0. To do this, follow these steps:
  1. Use the sa login to start Microsoft Dynamics GP.
  2. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Company, and then click Company.
  3. In the Company Name field, determine whether there are any special characters. If there are, delete them. For more information about special characters, see the "More information" section.

    Note A test company that uses the <TEST> clause within the name is also affected. Temporarily delete "<TEST>" when you use the Rapid Migration Tool.
  4. To save and close the Company Setup window, click OK.
  5. Run the Rapid Migration Tool to perform the "Exporting master data into Excel" process.
  6. When the Rapid Migration Tool has completed the migration process, you can revert the company name to any name that you want, as long as it contains only Microsoft Dynamics GP-compliant characters.

More information

Special characters include, but are not limited to, the following.
Collapse this tableExpand this table
Character Name
Tilde ~
Acute accent `
Exclamation point !
At sign @
Number sign #
Dollar sign $
Percent %
Caret ^
Ampersand &
Asterisk *
Opening parenthesis (
Closing parenthesis )
En dash -
Plus sign +
Equal sign =
Opening brace {
Closing brace }
Opening bracket [
Closing bracket ]
Vertical bar |
Backslash \
Forward slash /
Quotation mark "
Colon :
Apostrophe '
Left angle bracket <
Right angle bracket >
Question mark ?
Period .
Comma ,

More information

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Properties

Article ID: 958367 - Last Review: July 14, 2012 - Revision: 3.0
Applies to
  • Microsoft Dynamics GP 10.0
  • System Manager
Keywords: 
kbexpertiseadvanced kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB958367

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com