Hi Jim,

I would use the MSXML parser directly to do this.

pamela

>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>
>
>