Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing Yahoo shopping cart XML into VFP?
Message
From
15/02/2006 12:31:03
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01096308
Message ID:
01096526
Views:
14
Martin:

Thank you!! This certainly put me on the right (X)path...


Pertti


>Hi Pertti,
>
>Yes, no problema..
>
>loXML=CREATEOBJECT("Microsoft.XMLDOM")
>loXML.async=.F.
>loXML.SetProperty("SelectionLanguage","XPath")
>loXML.validateOnParse=.f.
>
>If loXML.load("http://lib.store.yahoo.net/lib/vw/OrderList.xml")
>   loXML.Validate()
>   * All schedule elements
>   loxx=loXML.documentElement.selectNodes("*/AddressInfo")
>   FOR lii=0 to loxx.length-1
>       loNode=loxx.item(lii)
>       ?"CPCURRENT()",;
>         STRCONV(loNode.GetAttribute("type"),11),;
>        STRCONV(lonode.childNodes(0).childnodes(0).text,11)
>   NEXT
>endif
>
>
>MESSAGE# 963774
>
>MartinJ
>
>
>>Anyone?
>>
>>Don't know much about XML...
>>
>>But I know that I need to import Yahoo shopping cart XML data into VFP 8. Here's a sample XML data address: http://lib.store.yahoo.net/lib/vw/OrderList.xml
>>
>>If someone could actually give me an example of the code to read this stuff into VFP cursors, that would be **great**. If not, I would certainly appreciate at least some guidance/ideas. I have WebConnect 4.65.
>>
>>
>>Thanks!
>>
>>
>>Pertti
Pertti Karjalainen
Product Manager
Northern Lights Software
Fairfax, CA USA
www.northernlightssoftware.com
Previous
Reply
Map
View

Click here to load this message in the networking platform