Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing Yahoo shopping cart XML into VFP?
Message
 
To
14/02/2006 15:46:58
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:
01096424
Views:
14
This message has been marked as the solution to the initial question of the thread.
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
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform