I want to loop throught this XML and capture per MU the HEX value for all the COUNTRY’s listed. In one XML I have many MU’s and in one MU I have one property but many MUV’s.
The problem is not how to put this in a DB but how to extract this info from the XML. I tried to work on the XML sample, but I fail to extract what I need.
Could somebody help me? I think even untested air-code would already help me at this point.
Have you looked at this project: Examples/Text/XMLExample?
Run it and select your XML file and it will show you the contents in a hierarchical ListBox. You can check out the code to see how it find and displays everything.
XML in Xojo is no more difficult than in any other language. You have to deal with the hierarchy/tree structure either way. As Gert demonstrates, XQL is your friend.
Paul, yes I worked on that to start with, but I found it quite hard to understand. I tested it on a lot of XML files, and it’s always working. I’m impressed, but I did not understand how it is done.
Tim, thanks for confirming XQL is the way forward. There is not a lot of info on XQL in the documentation, but it is very similar to XPath.