XMLTOCURSOR('xmlfile.xml',"xmlcursor",512+1024)>I haven't really worked with XML at all but now I need to get an XML file into VFP tables (and back). My XML file looks something like this (very simplified) - where do I start?
><?xml version="1.0" encoding="windows-1252" ?> > - <BATCH_FILE> > - <CLASS> > <ACTION>ADD</ACTION> > <CLASS_CODE>ADY2107</CLASS_CODE> > <CLASS_START_DATE>2006/01/19</CLASS_START_DATE> > <CLASS_END_DATE>2006/06/15</CLASS_END_DATE> > <CLASS_TYPE>NA</CLASS_TYPE> > <LANGUAGE_TYPE>E</LANGUAGE_TYPE> > <CLASSROOM_TYPE>1</CLASSROOM_TYPE> > - <SEGMENT> > <ACTION>ADD</ACTION> > <MINISTRY_DFND_CRS>SBI3C</MINISTRY_DFND_CRS> > <LOCAL_DEV_CRS /> > <CREDIT_VALUE>01.00</CREDIT_VALUE> > </SEGMENT> > - <SEGMENT> > <ACTION>ADD</ACTION> > <MINISTRY_DFND_CRS>SBI3U</MINISTRY_DFND_CRS> > <LOCAL_DEV_CRS /> > <CREDIT_VALUE>01.00</CREDIT_VALUE> > </SEGMENT> > </CLASS> > - <CLASS> > <ACTION>ADD</ACTION> > <CLASS_CODE>ADY2109</CLASS_CODE> > <CLASS_START_DATE>2005/09/06</CLASS_START_DATE> > <CLASS_END_DATE>2006/06/15</CLASS_END_DATE> > <CLASS_TYPE>NA</CLASS_TYPE> > <LANGUAGE_TYPE>E</LANGUAGE_TYPE> > <CLASSROOM_TYPE>1</CLASSROOM_TYPE> > - <SEGMENT> > <ACTION>ADD</ACTION> > <MINISTRY_DFND_CRS>SNC2D</MINISTRY_DFND_CRS> > <LOCAL_DEV_CRS /> > <CREDIT_VALUE>01.00</CREDIT_VALUE> > </SEGMENT> > - <SEGMENT> > <ACTION>ADD</ACTION> > <MINISTRY_DFND_CRS>SNC2P</MINISTRY_DFND_CRS> > <LOCAL_DEV_CRS /> > <CREDIT_VALUE>01.00</CREDIT_VALUE> > </SEGMENT> > </CLASS> > </BATCH_FILE> >