Hi,
1 - each <trace> tag will generate a SQL in the
corresponding <data> tag
Process each trace with either xsl:for-each, or write a template that matches
it and process the nodes with xsl:apply-templates.
2 - the value of columns of the SQL will come from
<LEVEL>, <TIME>, <TICKS>, <COMPONENT>, <SUBCOMPONENT>
and attribute values of <Datum> tag for e.g. Adapter
and Method. The table name is a constant.
For table names in Datum, you can extract the valua using <xsl:value-of
select="@name"/>, for the rest <xsl:value-of select="name()"/> when the element
is the current node.
3 - values of table columns will be corresponding
values of these tags
<xsl:value-of select="."/>
Use xsl:if to handle when commas are output. If you have problems in writing
the stylesheet, show it to us and explain what's the problem.
Cheers,
Jarno - Lights Of Euphoria: Show Me Your Tears (Apoptygma Berzerk vs Industrial
Heads mix)
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list