Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
Victor,
I have come across the invalid character more than once. A simple solution is to open the XML with Excel. Excel will tell you exactly the line and the character where the problem starts. You can than open any text editor to check the character itself. Take it out and you import should be fine.
I have created a routine that checks the created XML file for these characters and it either replaces them or removes them.
Regards,
Ron
>Thanks guys - I stumbled across a freeware gizmo that's getting me the record counts (all I really needed)...
>I'll come back and address this later tonight..
>
>
>>I created an XML file like this:
>>
>>CURSORTOXML('cust', 'cust.xml', 1, 512, 0, 'cust.xld')
>>
>>...and now I try to do this:
>>
>>XMLTOCURSOR("c:\vv\cust.xml","curcust",512)
>>
>>..and its failing. I have serveral files and they're all failing.
>>
>>Sometimes I see this: "msxml3.dll: The sytem cannot locate the object specified."
>>
>>The other problem is that some of the data was encrypted...so I'll see an error
>>like "XML Parse error: An invalid character was found in text content. Line 11933, Position 24," - then says the field name and the encrypted jibberish that's there.
>>
>>Anyone have any ideas?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement