Hi, All

We have a sample hierarchical XML file from our vender that need to be converted into cursor, but it has error when using XMLadapter in VFP8, I don't know it is the XML file format is not correct or VFP XMLadapter has its limitation that can only accept specific format of XML.

Any help will be highly appreciated!

Jim

here is the content of sample XML:

- <transaction>
- <job copsnbr="1416657" prefix="UPD" action="1" compaynbr="1" otisid="0" otisstation="1" ordertype="2" accountnbr="1312" servicenbr="78" returnservicenbr="0" vehicletype="CAR" requestedby="PAT MILLER" refrerence="SCHEDULED" multipletype="1" pagenbr="1" numberofpages="1" multiplepagegroup="0" pieces="2" weight="14" signature="False" callback="0" insurancevalue="0" date="20031024" time="1607" driver="1424" dispatchtime="1606" quote="0" rate="45.54" courierid="0" servicetype="S. AH" returnservicetype="????" cod="False">
  <pickup company="MCGRAW HILL" contact="DAVID WELTEZE" addr1="1200 G STREET NW - BASEMENT PR" city="WASHINGTON" state="DC" zip="00000" country="USA" phone="0" ext="0" date="20031027" fromtime="1945" totime="0" instructions="GLOBAL MATERIALS SEE MIKE HOOD." pricingzone="64" dispatchzone="DT" actualdate="20031027" actualarrivetime="1900" actualdeparttime="1900" /> 
  <delivery company="DP GLOBAL MAIL - C/O EXCEL COURIER" contact="HARRY/CU/FREDDY" addr1="45675 TERMINAL DRIVE" addr2="WAREHOUSE" city="STERLING" state="VA" zip="20166" country="USA" phone="7034780140" ext="0" date="20031027" fromtime="0" totime="2145" instructions="DELIVER BY 2045!" pricingzone="76" dispatchzone="RHS" actualdate="0" actualarrivetime="0" actualdeparttime="0" /> 
  <custom /> 
  <bol bolno="5081280" pcs="1" lbs="4" /> 
  <bol bolno="05121303" pcs="1" lbs="10" /> 
  </job>
  </transaction>