Hi all,
Here is an extract from an XML file that I am getting from a third party vendor with 1 record that I am trying to get into cursors in VFP. I want to strip out the authentication> area as well as the
and put customers, billing, sales, shipping and contact into cursors ?
Please help! I am new to the whole XML thing and unsure as to how to go about this.<?xml version="1.0" encoding="UTF-8"?>
<export_customers_response>
<authentication>
<revision>2.0</revision>
<reseller_shortcut>eric</reseller_shortcut>
<user_email>test@test.com</user_email>
</authentication>
<customers>
<customer>
<customer_number>AC0127</customer_number>
<address_id>626</address_id>
<name>acme corp</name>
<address1>1234 lane ave</address1>
<address2 />
<address_line1>1234 lane ave</address_line1>
<address_line2 />
<city>powell</city>
<state>Ohio</state>
<state_abbrv>OH</state_abbrv>
<zip>43065</zip>
<country>United States</country>
<country_abbrv>USA</country_abbrv>
<phone />
<fax />
<website />
<lead_source />
<tax_exempt />
<tax_id />
<comments />
<terms>No Terms</terms>
<credit_limit />
<sales>
<name>Lundin, Eric</name>
<email>eric.lundin@cnet.com</email>
<price_profile>22% Mark-Up</price_profile>
<price_profile_email>channelsupport@cnet.com</price_profile_email>
</sales>
<billing>
<address_id>627</address_id>
<title />
<firstname>pat</firstname>
<lastname>leneghan</lastname>
<company>acme corp</company>
<address1>1234 lane ave</address1>
<address2 />
<city>powell</city>
<state>Ohio</state>
<state_abbrv>OH</state_abbrv>
<zip>43065</zip>
<country>United States</country>
<phone />
<extension />
</billing>
<shipping>
<address_id>627</address_id>
<title />
<firstname>pat</firstname>
<lastname>leneghan</lastname>
<company>acme corp</company>
<address1>1234 lane ave</address1>
<address2 />
<city>powell</city>
<state>Ohio</state>
<state_abbrv>OH</state_abbrv>
<zip>43065</zip>
<country>United States</country>
<phone />
<extension />
</shipping>
<contact>
<address_id>166722</address_id>
<title />
<firstname>pat</firstname>
<lastname>leneghan</lastname>
<company>acme corp</company>
<address1>1234 lane ave</address1>
<address2 />
<city>powell</city>
<state>Ohio</state>
<state_abbrv>OH</state_abbrv>
<zip>43065</zip>
<country>United States</country>
<phone />
<extension />
<home_phone />
<home_extension />
<fax />
<fax_extension />
<email>pleneghan@aol.com</email>
<mobile />
<mobile_extension />
<pager />
<website />
<other />
<other_extension />
</contact>
</customer>
</customers>
</export_customers_response>
