|
|
Rank: Newbie
Joined: 11/19/2009 Posts: 8 Location: Australia
|
Hi All,
when I click the "Output" tab after mapping XML to Access mdb, I am getting an error:
Failed to load XML file..... (Message "character #xDBC0 is grammatically unexpected")
How can I fix this? What is the "wrong" symbol in the XML I should be looking for?
Thanks!
Chris
|
|
Rank: Newbie
Joined: 10/28/2002 Posts: 1,283 Location: AT
|
Hi,
please post the actual xml file and schema so that we have something to work with.
|
|
Rank: Newbie
Joined: 11/19/2009 Posts: 8 Location: Australia
|
Thank you for replying. it looks as the problem is because of the XML size.
Every time when I try large XML files with mapForce, it shoes the same error "character #xDBC0..."
Are there any tricks how to work with large files 200MB and more?
Thanks
|
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
Best of all is to split them in multiple smaller files - starting with MapForce v2010 you are able to process multiple files at once.
|
|
Rank: Newbie
Joined: 11/19/2009 Posts: 8 Location: Australia
|
Can I split large XML files with some Altova applications?
|
|
Rank: Newbie
Joined: 10/28/2002 Posts: 1,283 Location: AT
|
Theoretically you could split a file into several output files by using xslt2, and Altova offers an xslt engine in the form of AltovaXML (a free component).
https://www.altova.com/altovaxml.html
The problem lies in the fact that the xml file must still be loaded into memory all at once and this is where the size becomes prohibitive i.e. with a 200 MB source file you will almost certainly run into memory problems as xml is memory intensive.
Therefore for your particular scenario there really is no Altova tool which can help you to split the 200MB source file into several smaller more easily managable files.
|
|
Rank: Newbie
Joined: 11/19/2009 Posts: 8 Location: Australia
|
Finally, I have resolved it by splitting into several XML files. I have been using firstobject editor with a custom foal code. I tried splitting files up to 500MB; works great
|
|
|
guest |