[xsl] help with looping thru children

Subject: [xsl] help with looping thru children
From: "Lyn Stewart-Hunter" <Lyn@xxxxxxxxxxxxxxxx>
Date: Wed, 3 May 2006 10:07:31 -0700
Howdy.  I was able to use some past help to get header data to repeat in
a CSV format, but I then couldn't figure out where to put the for-each
to loop thru all EVENTS (or whatever structure would work).  From the
XML I would like a row in a CSV file for every EVENT (and include the
SUMMARY.REFERRING_URL).

I am also getting the DOWNLOAD on the 'wrong' row (maybe a new template
at that level?) and need to figure out how to get FUNNEL.CONVERSION ID
listed after its EVENT - if that's easy for someone to show me.  But I
am most interesting capturing each EVENT and maintaining the SUMMARY
data for each row - I don't know xml very well, so examples are ideal.

thank you. Lyn

My current output looks like:
2004-04-12 11:54:48 PST,HBX Home,Simple eBook,http://w w
w.google.com/search?q = web +analytics,ENDROW

XML is:
<?xml version='1.0' encoding='utf-8' ?>
<SESSION>
<SUMMARY>
<REFERRING_URL>http://w w w.google.com/search?q = web
+analytics</REFERRING_URL>
<BROWSER> MSIE 6.0</BROWSER>
</SUMMARY>
<EVENTS>
<EVENT>
<TIMESTAMP>2004-04-12 11:54:48 PST</TIMESTAMP>
<VIEW>
<PAGENAME>HBX Home</PAGENAME>
<CONTENT>/Products/HBX</CONTENT>
<RELOADS>1</RELOADS>
</VIEW>
<FUNNELS>
<FUNNEL>
<IS_CONVERSION_LEVEL>3</IS_CONVERSION_LEVEL>
<FUNNEL_ID>1123</FUNNEL_ID>
<FUNNEL_LEVEL>1</FUNNEL_LEVEL>
</FUNNEL>
</FUNNELS>
</EVENT>
<EVENT>
<TIMESTAMP>2004-04-12 11:56:46 PST</TIMESTAMP>
<VIEW>
<PAGENAME> Download Page</PAGENAME>
<CONTENT>/Products/HBX/Downloads</CONTENT>
</VIEW>
<FUNNELS>
<FUNNEL>
<IS_CONVERSION_LEVEL>3</IS_CONVERSION_LEVEL>
<FUNNEL_ID>1123</FUNNEL_ID>
<FUNNEL_LEVEL>3</FUNNEL_LEVEL>
</FUNNEL>
</FUNNELS>
</EVENT>
<EVENT>
<TIMESTAMP>2004-04-12 11:56:58 CST</TIMESTAMP>
<DOWNLOAD>Simple eBook</DOWNLOAD>
</EVENT>
</EVENTS>
</SESSION>
+++++++++++++++++++++
XSL is:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0">
	<xsl:output method="text"
		encoding="ISO-8859-1"/>

	<xsl:strip-space elements="*"/>

	<xsl:template match="/">
		<xsl:apply-templates select="SESSION"/>
	</xsl:template>

	<xsl:template match="SESSION">
		<xsl:apply-templates select="EVENTS"/>
	</xsl:template>

	<xsl:template match="SUMMARY">
		<xsl:value-of select="REFERRING_URL"/>
		<xsl:text>,</xsl:text>
	</xsl:template>

	<xsl:template match="EVENTS">
                <xsl:value-of select="//TIMESTAMP"/>
		<xsl:text>,</xsl:text>
                <xsl:value-of select="//PAGENAME"/>
		<xsl:text>,</xsl:text>
                <xsl:value-of select="//DOWNLOAD"/>
		<xsl:text>,</xsl:text>
		<xsl:apply-templates select="../SUMMARY"/>
               <xsl:text>ENDROW&#013;&#010;</xsl:text>

	</xsl:template>
</xsl:stylesheet>

Current Thread