Skip to content

Instantly share code, notes, and snippets.

@chrissabato chrissabato/StatCrewFootballGame.xslt
Last active Jul 28, 2016

Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
XSLT for importing StatCrew Football game XML's into InDesign
Raw
StatCrewFootballGame.xslt
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" version="1.0" exclude-result-prefixes="msxsl">
<xsl:output method="xml" indent="yes"/>
<!-- directory where photos wil be placed -->
<xsl:variable name="photo_location" select="'file:///D:/Creative Cloud Files/CoSIDA/images/'"/>
<xsl:template match="/">
<football>
<!-- Game Information -->
<game_info>
<gameid><xsl:value-of select="/fbgame/venue/@gameid"/></gameid>
<date><xsl:value-of select="/fbgame/venue/@date" /></date>
<city><xsl:value-of select="/fbgame/venue/@location"/></city>
<stadium><xsl:value-of select="/fbgame/venue/@stadium"/></stadium>
<location><xsl:value-of select="/fbgame/venue/@stadium"/>, <xsl:value-of select="/fbgame/venue/@location"/></location>
<start><xsl:value-of select="/fbgame/venue/@start"/></start>
<attendance><xsl:value-of select="/fbgame/venue/@attend"/></attendance>
<temp><xsl:value-of select="/fbgame/venue/@temp"/></temp>
<wind><xsl:value-of select="/fbgame/venue/@wind"/></wind>
<weather><xsl:value-of select="/fbgame/venue/@weather"/></weather>
<!-- Format date from mm/dd/yyyy -->
<xsl:variable name="tempdate" select="/fbgame/venue/@date" />
<xsl:variable name="part1" select="substring-before($tempdate, '/')" />
<xsl:variable name="temp" select="substring-after($tempdate, '/')" />
<xsl:variable name="part2" select="substring-before($temp, '/')" />
<xsl:variable name="part3" select="substring-after($temp, '/')" />
<fdate>
<xsl:choose>
<xsl:when test="$part1 = '1'">January</xsl:when>
<xsl:when test="$part1 = '2'">February</xsl:when>
<xsl:when test="$part1 = '3'">March</xsl:when>
<xsl:when test="$part1 = '4'">April</xsl:when>
<xsl:when test="$part1 = '5'">May</xsl:when>
<xsl:when test="$part1 = '6'">June</xsl:when>
<xsl:when test="$part1 = '7'">July</xsl:when>
<xsl:when test="$part1 = '8'">August</xsl:when>
<xsl:when test="$part1 = '9'">September</xsl:when>
<xsl:when test="$part1 = '10'">October</xsl:when>
<xsl:when test="$part1 = '11'">November</xsl:when>
<xsl:when test="$part1 = '12'">December</xsl:when>
<xsl:when test="$part1 = '01'">January</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '02'">February</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '03'">March</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '04'">April</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '05'">May</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '06'">June</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '07'">July</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '08'">August</xsl:when> <!-- account for 2 digit month -->
<xsl:when test="$part1 = '09'">September</xsl:when> <!-- account for 2 digit month -->
</xsl:choose>&#160;<xsl:value-of select="$part2"/>,&#160;<xsl:value-of select="$part3"/>
</fdate>
</game_info>
<!-- Game Information -->
<!-- Teams -->
<xsl:for-each select="/fbgame/team">
<xsl:element name="{@vh}">
<info>
<code><xsl:value-of select="@code"/></code>
<id><xsl:value-of select="@id"/></id>
<name><xsl:value-of select="@name"/></name>
<record><xsl:value-of select="@record"/></record>
<conf_record><xsl:value-of select="@conf-record"/></conf_record>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />team/<xsl:value-of select="@id"/>.png</xsl:attribute></xsl:element>
</info>
<graphs>
<totoff_yards><xsl:attribute name="href"><xsl:value-of select="$photo_location" />graph/totoff_<xsl:value-of select="@vh"/>_<xsl:value-of select="round(totals/@totoff_yards div 700 *10)" />.png</xsl:attribute></totoff_yards>
<passing_yards><xsl:attribute name="href"><xsl:value-of select="$photo_location" />graph/totoff_<xsl:value-of select="@vh"/>_<xsl:value-of select="round(totals/pass/@yds div 700 *10)" />.png</xsl:attribute></passing_yards>
<rushing_yards><xsl:attribute name="href"><xsl:value-of select="$photo_location" />graph/totoff_<xsl:value-of select="@vh"/>_<xsl:value-of select="round(totals/rush/@yds div 700 *10)" />.png</xsl:attribute></rushing_yards>
<turnover><xsl:attribute name="href"><xsl:value-of select="$photo_location" />graph/turnovers_<xsl:value-of select="@vh"/>_<xsl:value-of select="totals/fumbles/@lost + totals/pass/@int" />.png</xsl:attribute></turnover>
<third_conv><xsl:attribute name="href"><xsl:value-of select="$photo_location" />graph/third_conv_<xsl:value-of select="@vh"/>_<xsl:value-of select="round(totals/conversions/@thirdconv div totals/conversions/@thirdatt *10)" />.png</xsl:attribute></third_conv>
<redzone><xsl:attribute name="href"><xsl:value-of select="$photo_location" />graph/third_conv_<xsl:value-of select="@vh"/>_<xsl:value-of select="round(totals/redzone/@scores div totals/redzone/@att *10)" />.png</xsl:attribute></redzone>
</graphs>
<!-- Scores -->
<scores>
<final><xsl:value-of select="linescore/@score"/></final>
<linescore>
<xsl:for-each select="linescore/lineprd">
<xsl:element name="prd">
<xsl:value-of select="@score"/>
</xsl:element>
<xsl:element name="image">
<xsl:attribute name="href"><xsl:copy-of select="$photo_location" />graph/quarter-scores_<xsl:value-of select="../../@vh"/>_<xsl:value-of select="round(@score div 30 *10)"/>.png</xsl:attribute>
</xsl:element>
</xsl:for-each>
</linescore>
</scores>
<!-- Scores -->
<!-- Totals -->
<totals>
<totoff_plays><xsl:value-of select="totals/@totoff_plays"/></totoff_plays>
<totoff_yards><xsl:value-of select="totals/@totoff_yards"/></totoff_yards>
<totoff_avg><xsl:value-of select="totals/@totoff_avg"/></totoff_avg>
<third_conv><xsl:value-of select="format-number(totals/conversions/@thirdconv div totals/conversions/@thirdatt *100, '#')" />%</third_conv>
<redzone><xsl:value-of select="format-number(totals/redzone/@scores div totals/redzone/@att *100, '#')" />%</redzone>
<turnover><xsl:value-of select="format-number(totals/fumbles/@lost + totals/pass/@int,'#')" /></turnover>
<xsl:for-each select="totals/*">
<xsl:element name="{name()}">
<xsl:for-each select="@*">
<xsl:element name="{name()}">
<xsl:value-of select="." />
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:for-each>
</totals>
<!-- Totals -->
<!-- Rushing Leaders -->
<rushing_leaders>
<xsl:for-each select="player">
<xsl:sort select="rush/@yds" data-type="number" order="descending"/>
<xsl:if test="not(position() > 5)">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
<rushing>
<att><xsl:value-of select="rush/@att"/></att>
<yds><xsl:value-of select="rush/@yds"/></yds>
<yds_avg><xsl:value-of select="format-number(rush/@yds div rush/@att, '#.#')"/></yds_avg>
<gain><xsl:value-of select="rush/@gain"/></gain>
<loss><xsl:value-of select="rush/@loss"/></loss>
<td><xsl:value-of select="rush/@td"/></td>
<long><xsl:value-of select="rush/@long"/></long>
</rushing>
</player>
</xsl:if>
</xsl:for-each>
</rushing_leaders>
<!-- Rushing Leaders -->
<!-- Passing Leaders -->
<passing_leaders>
<xsl:for-each select="player">
<xsl:sort select="pass/@yds" data-type="number" order="descending"/>
<xsl:if test="not(position() > 2)">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
<passing>
<att><xsl:value-of select="pass/@att"/></att>
<comp><xsl:value-of select="pass/@comp"/></comp>
<comp_pct><xsl:value-of select="format-number(pass/@comp div pass/@att *100, '#')"/>%</comp_pct>
<int><xsl:value-of select="pass/@int"/></int>
<yds><xsl:value-of select="pass/@yds"/></yds>
<yds_avg><xsl:value-of select="format-number(pass/@yds div pass/@comp, '#.#')"/></yds_avg>
<td><xsl:value-of select="pass/@td"/></td>
<long><xsl:value-of select="pass/@long"/></long>
<sacks><xsl:value-of select="pass/@sacks"/></sacks>
</passing>
</player>
</xsl:if>
</xsl:for-each>
</passing_leaders>
<!-- Passing Leaders -->
<!-- Receiving Leaders -->
<receiving_leaders>
<xsl:for-each select="player">
<xsl:sort select="rcv/@yds" data-type="number" order="descending"/>
<xsl:if test="not(position() > 5)">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
<receiving>
<no><xsl:value-of select="rcv/@no"/></no>
<yds><xsl:value-of select="rcv/@yds"/></yds>
<yds_avg><xsl:value-of select="format-number(rcv/@yds div rcv/@no, '#.#')"/></yds_avg>
<td><xsl:value-of select="rcv/@td"/></td>
<long><xsl:value-of select="rcv/@long"/></long>
</receiving>
</player>
</xsl:if>
</xsl:for-each>
</receiving_leaders>
<!-- Receiving Leaders -->
<!-- defensive leaders-->
<defense_leaders>
<xsl:for-each select="player">
<xsl:sort select="defense/@tot_tack" data-type="number" order="descending"/>
<xsl:if test="not(position() > 5)">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
<defense>
<tot_tack><xsl:value-of select="defense/@tot_tack"/></tot_tack>
<tackua><xsl:value-of select="defense/@tackua"/></tackua>
<tacka><xsl:value-of select="defense/@tacka"/></tacka>
<tflua><xsl:value-of select="defense/@tflua"/></tflua>
<tflyds><xsl:value-of select="defense/@tflyds"/></tflyds>
<sackua><xsl:value-of select="defense/@sackua"/></sackua>
<sacka><xsl:value-of select="defense/@sacka"/></sacka>
<sackyds><xsl:value-of select="defense/@sackyds"/></sackyds>
</defense>
</player>
</xsl:if>
</xsl:for-each>
</defense_leaders>
<!-- defensive leaders-->
<!-- Int leaders-->
<int_leaders>
<xsl:for-each select="player">
<xsl:sort select="defense/@int" data-type="number" order="descending"/>
<xsl:if test="not(position() > 1)">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
<defense>
<tot_tack><xsl:value-of select="defense/@tot_tack"/></tot_tack>
<tackua><xsl:value-of select="defense/@tackua"/></tackua>
<tacka><xsl:value-of select="defense/@tacka"/></tacka>
<tflua><xsl:value-of select="defense/@tflua"/></tflua>
<tflyds><xsl:value-of select="defense/@tflyds"/></tflyds>
<sackua><xsl:value-of select="defense/@sackua"/></sackua>
<sacka><xsl:value-of select="defense/@sacka"/></sacka>
<sackyds><xsl:value-of select="defense/@sackyds"/></sackyds>
<int><xsl:value-of select="defense/@int"/></int>
<intyds><xsl:value-of select="defense/@intyds"/></intyds>
</defense>
</player>
</xsl:if>
</xsl:for-each>
</int_leaders>
<!-- Int leaders-->
<!-- D Starters -->
<D_Starters>
<xsl:for-each select="player">
<xsl:if test="@dpos">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<pos><xsl:value-of select="@dpos"/></pos>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
</player>
</xsl:if>
</xsl:for-each>
</D_Starters>
<!-- D Starters -->
<!-- O Starters -->
<O_Starters>
<xsl:for-each select="player">
<xsl:if test="@opos">
<player>
<name><xsl:value-of select="@name"/></name>
<shortname><xsl:value-of select="@shortname"/></shortname>
<uni><xsl:value-of select="@uni"/></uni>
<class><xsl:value-of select="@class"/></class>
<pos><xsl:value-of select="@opos"/></pos>
<xsl:element name="image"><xsl:attribute name="href"><xsl:copy-of select="$photo_location" />player/<xsl:value-of select="@uni"/>.jpg</xsl:attribute></xsl:element>
</player>
</xsl:if>
</xsl:for-each>
</O_Starters>
<!-- O Starters -->
</xsl:element>
</xsl:for-each>
<!-- Teams -->
</football>
</xsl:template>
</xsl:stylesheet>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.