AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Invalid Character Expand / Collapse
Author
Message
Posted 1/7/2008 5:53:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/8/2008 12:19:44 PM
Posts: 3, Visits: 4
My PTI gives me an Unhandled exception when it gets to reading my Items from Peachtree.  I've looked at the Details and I don't know which item it is freaking out on.  Is there anyway to see exactly which item it is not liking?

Thanks!

Post #3669
Posted 1/7/2008 7:08:16 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
Hi

When you get the error, click on the Details button and copy all of the text, and paste all of it into your topic reply.

And confirm - this error occurs when it shows that PTI is reading the PeachTree Items?

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3670
Posted 1/7/2008 7:24:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/8/2008 12:19:44 PM
Posts: 3, Visits: 4
Hi, Joyce.

Yes, it dies at the same point everytime and it is when it is retrieving Items.  See below for the information you requested:

Thanks!

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

************** Exception Text **************
System.Xml.XmlException: Invalid character in the given encoding. Line 967, position 70.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   at System.Xml.XmlTextReaderImpl.InvalidCharRecovery(Int32& bytesCount, Int32& charsCount)
   at System.Xml.XmlTextReaderImpl.GetChars(Int32 maxCharsCount)
   at System.Xml.XmlTextReaderImpl.ReadData()
   at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
   at System.Xml.XmlTextReaderImpl.ParseText()
   at System.Xml.XmlTextReaderImpl.ParseElementContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.Xmldocument.Load(XmlReader reader)
   at System.Xml.Xmldocument.Load(String filename)
   at AyaNovaPTI.Util.1()
   at AyaNovaPTI.Util.PopulatePTListCache()
   at AyaNovaPTI.Util.PreFlightCheck()
   at AyaNovaPTI.MainForm.2()
   at AyaNovaPTI.MainForm.(Object , EventArgs )
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
   at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AyaNovaPTI
    Assembly Version: 3.7.0.0
    Win32 Version: 3.7.0.0
    CodeBase: file:///C:/Program%20Files/Ground%20Zero%20Tech-Works%20Inc/AyaNova%203/AyaNovaPTI.exe
----------------------------------------

Post #3671
Posted 1/7/2008 7:44:44 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
Thank you for posting the information.

The key part of the error is Invalid character in the given encoding. Line 967, position 70.

I would suggest that because you get this error while PTI is loading the PeachTree items, confirm that none of your PeachTree Items have special characters in their names or other fields in the Item entry screen.

If they do, edit, and than try loading PTI again - does it now load? Note if the Line and position numbers change as if they do that means that you edited one but may have others that need editing

Let me know.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3672
Posted 1/7/2008 7:52:36 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
Hi again

I thought I had seen this error before but it wasn't coming up in any support emails or elsewhere on the forum, but I was pretty sure I had seen it somewhere - if you review the PTI Manual's Common Errors & Issues section, the third issue down provides a screenshot and example of this same error.

The solution listed is as posted above, if the issue occured while loading of items it is because one or more PeachTree parts are using a non-English character. For example, Cárdenas (note the ascent on the á) and although you may have been able to enter them into PeachTree, when exporting or importing using xml PeachTree will not recognize any characters other than English. 

You need to go through your PeachTree items and make sure none of them are using special characters in any of their fields (name, street, etc), save and than run PTI again.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3673
Posted 1/7/2008 4:59:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/8/2008 12:19:44 PM
Posts: 3, Visits: 4
Joyce,

Yeah, I came to all the same conclusions you have by going through the manual.  I knew it was supposedly an invalid char, per my thread topic.  However, my conundrum is that we have about 1000 items listed in Peachtree and a cursory examination of the item names have yielded no non-english characters.  Without having to dig through the item descriptions of over 1000 items, is there no way to see which item is causing the problem during the import process?  PTI pulls from an xml, correct?  Where is this xml located so I can go to the line and object it refers to?

Thanks!

Post #3674
Posted 1/7/2008 7:03:32 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
Hi

Sorry, no, PTI 3 doesn't keep the PeachTree items xml file to be able to identify which specific PeachTree item is the issue. 

A suggestion with PTI 3 is to perform an PeachTree export of your inventory items to a CSV file so that you can manually view all of the fields at once to see which are using special characters.

Do note that development will be looking into having the item xml file available when PTI v4 is run via the C:\Documents and Settings\yourname\Local Settings\Temp We are working to releasing the new AyaNova 4 and its version 4 optional add-ons this week

AyaNova 4 has a number of new features - check out http://forum.ayanova.com/Topic3569-97-1.aspx#bm3627

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3675
Posted 1/8/2008 11:38:51 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 7:45:59 AM
Posts: 1,866, Visits: 4,324
Hi again

If using PTI 3.7.0.0:

  • Close out of PTI
  • Download 3.7.1AyaNovaPTI.zip
  • Use WinZip to extract
  • Overwrite the existing AyaNovaPTI.exe file
  • Now run PTI
  • It will still give you the same error, but now you will find the PTitems.xml file in C:\Documents and Settings\yourname\Local Settings\Temp folder

And in some cases, if you open using Internet Explorer, it may tell you right off the bat which item is at fault with the special charcter. Otherwise, use it to browse through to find the special character(s)

Also note that AyaNova 4 was released today.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3685
Posted 1/9/2008 11:35:29 AM