On 19/12/2012, at 4:55 PM, Gerry Orkin wrote:

> Hi all
> 
> I have no XML experience and I need help with extracting data from a tree. 
> Hope someone can point me in the right direction - I've looked at the XML 
> lesson on the RunRev site but I can't transfer what I've learnt there to my 
> situation for some reason (well, the reason is I'm new to this and confused 
> :)).
> 
> Here's my XML:
> 
> 
> <item>
>                       <title>The XYZ Podcast: Episode #291</title>
>                       <pubDate>Thu, 06 Dec 2012 15:30:57 +0000</pubDate>
>                       <guid 
> isPermaLink="false"><![CDATA[8282b5a5e0aaf2f2c1b8407ca813deb3]]></guid>
>                       
> <link><![CDATA[http://XYZpodcast.com/the-XYZ-podcast-episode-291]]></link>
>                       <media:thumbnail 
> url="http://assets.libsyn.com/item/2148560"; />
>                       <description>Some show notes go here</description>
>                       <enclosure length="57854477" type="audio/mpeg" 
> url="http://traffic.libsyn.com/XYZpodcast/XYZPodcast291-Dec06-12.mp3"; />
> </item>
> <item>
>                       <title>The XYZ Podcast: Episode #292</title>
>                       <pubDate>Thu, 06 Dec 2012 15:30:57 +0000</pubDate>
>                       <guid 
> isPermaLink="false"><![CDATA[8282b5a5e0aaf2f2c1b8407ca813deb3]]></guid>
>                       
> <link><![CDATA[http://XYZpodcast.com/the-XYZ-podcast-episode-292]]></link>
>                       <media:thumbnail 
> url="http://assets.libsyn.com/item/2148560"; />
>                       <description>Some show notes go here</description>
>                       <enclosure length="43852797" type="audio/mpeg" 
> url="http://traffic.libsyn.com/XYZpodcast/XYZPodcast291-Dec20-12.mp3"; />
> </item>
> 
> (That goes on for 322 items!)
> 
> There is other, non-repeating stuff at the top of the feed that I've not 
> pasted here, and I can get the contents of those nodes with no problem at 
> all. But how do I then extract all the sub-nodes under the <item> node into a 
> table?

Does your list of items have a parent node? Odd if it doesn't.

I'm guessing it does so you can do something like this:

put 1 into tIndex
repeat for each line tNode in revXMLChildNames(treeID,"/items",cr,"item",true)
        repeat for each line tChildNode in 
revXMLChildNames(treeID,"/items/"&tNode,cr,,false)
                put revXMLNodeContents(treeID,"/items/"&tNode&"/"&tChildNode) 
into tData[tIndex][tChildNode]
        end repeat
        add 1 to tIndex
end repeat

> 
> Thanks in advance!
> 
> Gerry
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

--
M E R Goulding 
Software development services
Bespoke application development for vertical markets

mergExt - There's an external for that!

_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to