Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xmltocursor problem! help!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01236123
Message ID:
01238531
Vues:
16
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
Fil
Voir

Click here to load this message in the networking platform