You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Antonio Gallardo <ag...@agssa.net> on 2005/01/26 14:00:15 UTC
Re: transformation from XML to excel only works with one element
set
Yep. Your guess is right! You are overwrite the first with the second. You
need to use a variable to move to the next row. As a solution, try to use
JXTemplate.
Best Regards,
Antonio Gallardo.
On Mie, 26 de Enero de 2005, 6:04, Philipp Rech dijo:
> Hello Cocooners,
>
> [Cocoon Version 2.1.6]
>
> i have the following xml file (see below) which is the result of a db
> querry
> (from Cocoon)... when i transfrom it with the stylesheet (see below) using
> the
> transfomer within Cocoon an excel sheet opens but with only one row in it
> (the
> one with the last id) but i need all elements in diferent rows... so only
> the
> last <row> element with the <eventid>2</eventid> gets displayed but not
> both of
> them... my guess was thet the first one is processed but is overwritten by
> the
> last one (see my xml and xsl file below)
>
> thank you very much!
> phil
>
> ps: i already asekd on the poi-user list but
> got no reply...
>
>
> here is my xml file:
> --------------------------------
> <?xml version="1.0" encoding="ISO-8859-1" ?>
> <page>
> <content>
> <rowset xmlns:sql="http://apache.org/cocoon/SQL/2.0"
> xmlns="http://apache.org/cocoon/SQL/2.0">
> <row>
> <eventid>3</eventid>
> <typeofcontrol>Control Type A</typeofcontrol>
> <trafficdirection>Entry</trafficdirection>
> <checkpoint>Blue Border</checkpoint>
> <klassification>illigal</klassification>
> <checklocation>black sea</checklocation>
> <guard_1>Philipp</guard_1>
> <guard_2>Peter Pan</guard_2>
> <objection>smug</objection>
> <dtg>2005-01-01</dtg>
> <location>black sea</location>
> <description></description>
> <numberofpersons>3</numberofpersons>
> <observed>Yes</observed>
> </row>
> <row>
> <eventid>2</eventid>
> <typeofcontrol>Control Type B</typeofcontrol>
> <trafficdirection>Leave/trafficdirection>
> <checkpoint>Airport</checkpoint>
> <klassification>illigal entry</klassification>
> <checklocation>airport hall 2</checklocation>
> <guard_1>Philipp</guard_1>
> <guard_2>Stepht</guard_2>
> <objection>illigal enrty</objection>
> <dtg>2005-01-12</dtg>
> <location>airport somewhere</location>
> <description>none</description>
> <numberofpersons>1</numberofpersons>
> <observed>No</observed>
> </row>
> </rowset>
> </content>
> </page>
> ---------------------------------
>
>
> here is my xsl file:
>
> -----------------------------
>
> <?xml version="1.0"?>
> <xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:sql="http://apache.org/cocoon/SQL/2.0"
> xmlns:gmr="http://www.gnome.org/gnumeric/v7"
> >
>
> <xsl:template match="/">
> <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7">
> <gmr:Sheets>
> <gmr:Sheet DisplayFormulas="false" HideZero="false"
> HideGrid="false"
> HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
> OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
> <gmr:Name>BIHS - Event Data</gmr:Name>
> <gmr:MaxCol>2</gmr:MaxCol>
> <gmr:Cols DefaultSizePts="48">
> <gmr:ColInfo No="0" Unit="48" MarginA="2" MarginB="2"
> Count="7"/>
> </gmr:Cols>
> <gmr:Rows DefaultSizePts="12.8">
> <gmr:RowInfo No="0" Unit="12.8" MarginA="0" MarginB="0"
> Count="9"/>
> <gmr:RowInfo No="10" Unit="12.8" MarginA="1" MarginB="0"
> Count="24"/>
> </gmr:Rows>
> <gmr:Cells>
> <xsl:apply-templates/>
> </gmr:Cells>
> </gmr:Sheet>
> </gmr:Sheets>
> </gmr:Workbook>
> </xsl:template>
>
>
>
> <xsl:template match="sql:eventid">
> <gmr:Cell Col="0" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
>
> <xsl:template match="sql:typeofcontrol">
> <gmr:Cell Col="1" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
>
> <xsl:template match="sql:trafficdirection">
> <gmr:Cell Col="2" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
>
>
> <xsl:template match="sql:checkpoint ">
> <gmr:Cell Col="3" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
>
>
>
> <xsl:template match="sql:klassification">
> <gmr:Cell Col="4" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
>
>
> <xsl:template match="sql:guard_1">
> <gmr:Cell Col="5" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
> <xsl:template match="sql:guard_2">
> <gmr:Cell Col="6" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
> <xsl:template match="sql:objection">
> <gmr:Cell Col="7" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
> <xsl:template match="sql:dtg">
> <gmr:Cell Col="8" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
> <xsl:template match="sql:location">
> <gmr:Cell Col="9" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
> <xsl:template match="sql:description">
> <gmr:Cell Col="10" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template> <xsl:template match="sql:numberofpersons">
> <gmr:Cell Col="11" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template> <xsl:template match="sql:observed">
> <gmr:Cell Col="12" ValueType="60">
> <xsl:variable name="rownumber"><xsl:number level="any"
> from="content"
> count="row"/></xsl:variable>
> <xsl:attribute name="Row">
> <xsl:value-of select="$rownumber"/>
> </xsl:attribute>
> <gmr:Content>
> <xsl:apply-templates/>
> </gmr:Content>
> </gmr:Cell>
> </xsl:template>
>
>
>
> </xsl:stylesheet>
>
>
> ----------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: transformation from XML to excel only works with one element set
Posted by Philipp Rech <re...@iuw.fh-darmstadt.de>.
jxtg? okay, but i need microsoft excel as and ouput format and
i do't see how JXTG could help me here...
i would need one excel-row for each row element...
i was thinking that i miss a <xsl:for-each ...> instruction
but i dunno where/how to apply this...
(the transformation works fine to WML and PDF btw)
any hints? (stylesheet > see below)
thanks a lot!
philipp
> Yep. Your guess is right! You are overwrite the first with the second. You
> need to use a variable to move to the next row. As a solution, try to use
> JXTemplate.
>
> Best Regards,
>
> Antonio Gallardo.
>
> On Mie, 26 de Enero de 2005, 6:04, Philipp Rech dijo:
> > Hello Cocooners,
> >
> > [Cocoon Version 2.1.6]
> >
> > i have the following xml file (see below) which is the result of a db
> > querry
> > (from Cocoon)... when i transfrom it with the stylesheet (see below) using
> > the
> > transfomer within Cocoon an excel sheet opens but with only one row in it
> > (the
> > one with the last id) but i need all elements in diferent rows... so only
> > the
> > last <row> element with the <eventid>2</eventid> gets displayed but not
> > both of
> > them... my guess was thet the first one is processed but is overwritten by
> > the
> > last one (see my xml and xsl file below)
> >
> > thank you very much!
> > phil
> >
> > ps: i already asekd on the poi-user list but
> > got no reply...
> >
> >
> > here is my xml file:
> > --------------------------------
> > <?xml version="1.0" encoding="ISO-8859-1" ?>
> > <page>
> > <content>
> > <rowset xmlns:sql="http://apache.org/cocoon/SQL/2.0"
> > xmlns="http://apache.org/cocoon/SQL/2.0">
> > <row>
> > <eventid>3</eventid>
> > <typeofcontrol>Control Type A</typeofcontrol>
> > <trafficdirection>Entry</trafficdirection>
> > <checkpoint>Blue Border</checkpoint>
> > <klassification>illigal</klassification>
> > <checklocation>black sea</checklocation>
> > <guard_1>Philipp</guard_1>
> > <guard_2>Peter Pan</guard_2>
> > <objection>smug</objection>
> > <dtg>2005-01-01</dtg>
> > <location>black sea</location>
> > <description></description>
> > <numberofpersons>3</numberofpersons>
> > <observed>Yes</observed>
> > </row>
> > <row>
> > <eventid>2</eventid>
> > <typeofcontrol>Control Type B</typeofcontrol>
> > <trafficdirection>Leave/trafficdirection>
> > <checkpoint>Airport</checkpoint>
> > <klassification>illigal entry</klassification>
> > <checklocation>airport hall 2</checklocation>
> > <guard_1>Philipp</guard_1>
> > <guard_2>Stepht</guard_2>
> > <objection>illigal enrty</objection>
> > <dtg>2005-01-12</dtg>
> > <location>airport somewhere</location>
> > <description>none</description>
> > <numberofpersons>1</numberofpersons>
> > <observed>No</observed>
> > </row>
> > </rowset>
> > </content>
> > </page>
> > ---------------------------------
> >
> >
> > here is my xsl file:
> >
> > -----------------------------
> >
> > <?xml version="1.0"?>
> > <xsl:stylesheet version="1.0"
> > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> > xmlns:sql="http://apache.org/cocoon/SQL/2.0"
> > xmlns:gmr="http://www.gnome.org/gnumeric/v7"
> > >
> >
> > <xsl:template match="/">
> > <gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v7">
> > <gmr:Sheets>
> > <gmr:Sheet DisplayFormulas="false" HideZero="false"
> > HideGrid="false"
> > HideColHeader="false" HideRowHeader="false" DisplayOutlines="true"
> > OutlineSymbolsBelow="true" OutlineSymbolsRight="true">
> > <gmr:Name>BIHS - Event Data</gmr:Name>
> > <gmr:MaxCol>2</gmr:MaxCol>
> > <gmr:Cols DefaultSizePts="48">
> > <gmr:ColInfo No="0" Unit="48" MarginA="2" MarginB="2"
> > Count="7"/>
> > </gmr:Cols>
> > <gmr:Rows DefaultSizePts="12.8">
> > <gmr:RowInfo No="0" Unit="12.8" MarginA="0" MarginB="0"
> > Count="9"/>
> > <gmr:RowInfo No="10" Unit="12.8" MarginA="1" MarginB="0"
> > Count="24"/>
> > </gmr:Rows>
> > <gmr:Cells>
> > <xsl:apply-templates/>
> > </gmr:Cells>
> > </gmr:Sheet>
> > </gmr:Sheets>
> > </gmr:Workbook>
> > </xsl:template>
> >
> >
> >
> > <xsl:template match="sql:eventid">
> > <gmr:Cell Col="0" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> >
> > <xsl:template match="sql:typeofcontrol">
> > <gmr:Cell Col="1" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> >
> > <xsl:template match="sql:trafficdirection">
> > <gmr:Cell Col="2" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> >
> >
> > <xsl:template match="sql:checkpoint ">
> > <gmr:Cell Col="3" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> >
> >
> >
> > <xsl:template match="sql:klassification">
> > <gmr:Cell Col="4" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> >
> >
> > <xsl:template match="sql:guard_1">
> > <gmr:Cell Col="5" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> > <xsl:template match="sql:guard_2">
> > <gmr:Cell Col="6" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> > <xsl:template match="sql:objection">
> > <gmr:Cell Col="7" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> > <xsl:template match="sql:dtg">
> > <gmr:Cell Col="8" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> > <xsl:template match="sql:location">
> > <gmr:Cell Col="9" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> > <xsl:template match="sql:description">
> > <gmr:Cell Col="10" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template> <xsl:template match="sql:numberofpersons">
> > <gmr:Cell Col="11" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template> <xsl:template match="sql:observed">
> > <gmr:Cell Col="12" ValueType="60">
> > <xsl:variable name="rownumber"><xsl:number level="any"
> > from="content"
> > count="row"/></xsl:variable>
> > <xsl:attribute name="Row">
> > <xsl:value-of select="$rownumber"/>
> > </xsl:attribute>
> > <gmr:Content>
> > <xsl:apply-templates/>
> > </gmr:Content>
> > </gmr:Cell>
> > </xsl:template>
> >
> >
> >
> > </xsl:stylesheet>
> >
> >
> > ----------------------------------
> >
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: [SOLVED] transformation from XML to excel only works with one element set
Posted by Philipp Rech <re...@iuw.fh-darmstadt.de>.
Hello,
thank you Jan it works! Here is my new stylesheet
maybe it is usefull for someone...
bye now!
philipp
-------------------------------------------------
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:sql="http://apache.org/cocoon/SQL/2.0"
xmlns:gmr="http://www.gnome.org/gnumeric/v7">
<xsl:template match="/">
<gmr:Workbook>
<gmr:SheetNameIndex>
<gmr:SheetName>BIHS-Reporting-Events</gmr:SheetName>
</gmr:SheetNameIndex>
<gmr:Sheets>
<gmr:Sheet>
<gmr:Name>BIHS-Reporting-Events</gmr:Name>
<gmr:Styles>
<gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="99">
<gmr:Style HAlign="8" VAlign="4" WrapText="1" Orient="1" Shade="0"
Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF"
PatternColor="0:0:0" Format="General">
<gmr:Font Unit="10" Bold="1" Italic="0" Underline="0"
StrikeThrough="0">
Helvetica
</gmr:Font>
</gmr:Style>
</gmr:StyleRegion>
</gmr:Styles>
<gmr:Cells>
<xsl:call-template name="headerrow"/>
<xsl:apply-templates select="/page/content/sql:rowset/sql:row"/>
</gmr:Cells>
</gmr:Sheet>
</gmr:Sheets>
</gmr:Workbook>
</xsl:template>
<xsl:template name="headerrow">
<gmr:Cell Row="0" Col="0" ValueType="60">Event ID</gmr:Cell>
<gmr:Cell Row="0" Col="1" ValueType="60">Type of Control</gmr:Cell>
<gmr:Cell Row="0" Col="2" ValueType="60">Traffic Direction </gmr:Cell>
<gmr:Cell Row="0" Col="3" ValueType="60">Check Point</gmr:Cell>
<gmr:Cell Row="0" Col="4" ValueType="60">Classification</gmr:Cell>
<gmr:Cell Row="0" Col="5" ValueType="60">Location of crime</gmr:Cell>
<gmr:Cell Row="0" Col="6" ValueType="60">1'th Guard</gmr:Cell>
<gmr:Cell Row="0" Col="7" ValueType="60">2'nd Guard</gmr:Cell>
<gmr:Cell Row="0" Col="8" ValueType="60">Objection</gmr:Cell>
<gmr:Cell Row="0" Col="9" ValueType="60">Date</gmr:Cell>
<gmr:Cell Row="0" Col="10" ValueType="60">Location of crime</gmr:Cell>
<gmr:Cell Row="0" Col="11" ValueType="60">Description</gmr:Cell>
<gmr:Cell Row="0" Col="12" ValueType="60">Nr. of Persons</gmr:Cell>
<gmr:Cell Row="0" Col="13" ValueType="60">Observed by guard</gmr:Cell>
</xsl:template>
<xsl:template match="sql:row">
<xsl:variable name="row" select="position()"/>
<gmr:Cell Row="{$row}" Col="0" ValueType="60">
<xsl:value-of select="sql:eventid"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="1" ValueType="60">
<xsl:value-of select="sql:typeofcontrol"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="2" ValueType="60">
<xsl:value-of select="sql:trafficdirection"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="3" ValueType="60">
<xsl:value-of select="sql:checkpoint"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="4" ValueType="60">
<xsl:value-of select="sql:klassification"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="5" ValueType="60">
<xsl:value-of select="sql:checklocation"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="6" ValueType="60">
<xsl:value-of select="sql:guard_1"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="7" ValueType="60">
<xsl:value-of select="sql:guard_2"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="8" ValueType="60">
<xsl:value-of select="sql:objection"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="9" ValueType="60">
<xsl:value-of select="sql:dtg"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="10" ValueType="60">
<xsl:value-of select="sql:location"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="11" ValueType="60">
<xsl:value-of select="sql:description"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="12" ValueType="60">
<xsl:value-of select="sql:numberofpersons"/>
</gmr:Cell>
<gmr:Cell Row="{$row}" Col="13" ValueType="60">
<xsl:value-of select="sql:observed"/>
</gmr:Cell>
</xsl:template>
</xsl:stylesheet>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org