Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Processing an XML file to VFP cursors
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00904549
Message ID:
00966959
Views:
8
Terry
>Are there reasons certain types of XMLs will not load to XMLAdapter? I >guess I am wondering if XMLAdapter/XMLToCursor are fully W3C.

Did you check XmlAdapter in the VFP9 Beta? It includes support for hierarchical XML, XPath expressions and some more stuff...

Jaime

>Well at least you made it back! It's nice to know someone gets vacation time!:)
>
>As I desperately waited for your response, I did some reading. Evan Delay was talking about this stuff two years ago, so I am behinf the times!
>
>What I learned is the XMLs I am usining are Hieracrhal rather rather than tablular. So I am working on a "crawler". I have the crawler working pretty well in the section of the manifest (XML) where a particular node does not have a root sibling. I am trying to get a "(leaf) crawler" working in sections of the XML where the root parent node does have siblings. ANy advice or pointers appreciated.
>
>However, I did find a free tool ( http://www.vbxml.com/xpathvisualizer/ ) that loads an XML and then, based the Xpath query, will highlite those nodes participating in the query results.
>
>Are there reasons certain types of XMLs will not load to XMLAdapter? I guess I am wondering if XMLAdapter/XMLToCursor are fully W3C.
>
>Thanks
>
>
>>Terry
>>Sorry , i have been away for a veeeeeeeery long time, due to huge projects that came in all together ( as always ). To answer the question you're going to ask: Yes, it's all exclusively plain-vanilla VFP, with native data and the whole panoplie...
>>About your question concerning moving Java DOM, i don't know ditch...don't think of me as a XML guru or something, it's just that i had to learn it in order to maintain the zillion Web Services i developed with VFP the last 2 years :-)
>>
>>Jaime
>>
>>>Jamie,
>>>Thanks for helping Carmel an I with this post.
>>>
>>>I am moving some Java DOM services to M$'s IXMLDOM. Could you offer any advice on that transition?
>>>
>>>
>>>>Carmel
>>>>If you use VFP8, just check out the XMLAdapter Class.
>>>>If you are using previous versions, you should manually scan your xml using XMLDom and enter the data into your tables.
>>>>Scannig your data manually would look something like the following:
>>>>ox = CreateObject("MSXml.DOMDocument")
>>>>ox.Load( YourXmlSource ) && or ox.LoadXML( YourXMLString )
>>>>myXmlString = ox.DocumentElement
>>>>** now retrieve some fields **
>>>>myRevNode = myXmlString.SelectSingleNode( "authentication/revision" )
>>>>myRevision = myRevNode.Text
>>>>myResNode = myXmlString.SelectSingleNode( "authentication/reseller_shortcut")
>>>>MyReseller = myResNode.Text
>>>>
>>>>** loop through the customer nodes
>>>>myCustomers = myXmlString.SelectNodes( "customers" )
>>>>for each oCostumer in myCustomers
>>>>   tmpName = oCostumer.SelectSingleNode("customer/name")
>>>>   ? tmpName.Text
>>>>endfor
>>>>** it's a pain, i know, but you can control everything
>>>>
>>>>HTH
>>>>Jaime
>>>>
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform