Environment versions
Network:
Windows 2000 Server
You may want to use XMLAdapter with a schema. XMLTOCURSOR is very limited. I tried this with the XML documents from some insurance companies that I need to deal with, and it didn't work well. Then I changed to XMLAdapter. It seems to work okay, though I'm posting a question here now.
>We have a system that currently imports a NAILBA (2.1) text file of insurance data to update our policy information. The insurance company is now switching to the ACORD standard which uses an XML format. I have tried testing the file they sent using XMLTOCURSOR() and am not having much luck. I am using the following code:
>
>xfile = 'xmlSample.xml'
>xstring = FILETOSTR(xfile)
>XMLTOCURSOR(xstring,'sample')
>
>It doesn't look like all the data is being imported - I can view the XML file and I don't see all of the data in the VFP cursor. Is anyone familiar with working with ACORD? Or anyone have any better ways to import the XML file?
>
>Thanks,
>Doug
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only