I am working on a system that will be getting data feeds in the Life/Health ACORD standards.

Have you been to WWW.ACORD.ORG?

They have schema information you can download there, I think they that diffent standards for Life/Health vs P&C. I have not been able to get VFP to use the schema using the XMLAdapter.

When I used XMLTOCURSOR on the raw file it had all the data, but much of it was not parsed out into fields I needed, it was stored as text in a MEMO fields.

I found that Excel 2003 was pretty good at opening the files and that helped me get a sense of what data I wanted to extract.

I ended up pulling the elements I needed out of the file by searching for the XML tags of interest.

cFile = GETFILE("XML")
cSTR = FILETOSTR(m.cfile )
cSTR2 =  STREXTRACT(cSTR,'<OLife>',"</OLife>",1,5)
cComm = "<oP>" + CHR(13) + CHR(10) 
	FOR i = 1 to OCCURS(UPPER("<Policy "),UPPER(cStr2))
		cComm = cComm + CHR(13) + CHR(10) +  STREXTRACT(cSTR2,'<Policy ',"</Policy>",i,5) + CHR(13) + CHR(10) 
	ENDFOR
cComm = cComm+ CHR(13) + CHR(10) + "</oP>"
XMLTOCURSOR( m.cComm,"POLICY")

Can you say what insurance company it is?


>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