OK, here's my situation - I am working on making a dynamic table using a xls file with an xml file. Trying to get it to do anything dynamic using XSLT has been very difficult for me, as I never know what I can or can't do.
Here's the trimmed down XML file:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="logger.xsl"?>
<!-- !DOCTYPE log SYSTEM "logger.dtd" -->
<log>
<record>
<date>2009-02-23T08:46:52</date>#time and date to the milisecond that this event occured
<millis>1235400412162</millis>#also the date and time just in millisecond format. this is the number of milliseconds from jan 1 1970
<sequence>0</sequence>
<logger>com.dtw.bpo.Application</logger>
<level>FINER</level>
<class>com.dtw.bpo.Application</class>
<method>main</method>
<thread>10</thread>
<message>ENTRY</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412256</millis>
<sequence>1</sequence>
<logger>com.dtw.bpo.Application</logger>
<level>INFO</level>
<class>com.dtw.bpo.Application</class>
<method>main</method>
<thread>10</thread>
<message>Application App is initializing...</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412271</millis>
<sequence>2</sequence>
<logger>com.dtw.util.LoggingMgr</logger>
<level>FINER</level>
<class>com.dtw.util.LoggingMgr</class>
<method>getInstance</method>
<thread>10</thread>
<message>ENTRY</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412271</millis>
<sequence>2</sequence>
<logger>com.dtw.util.LoggingMgr</logger>
<level>FINER</level>
<class>com.dtw.util.LoggingMgr</class>
<method>getInstance</method>
<thread>10</thread>
<message>ENTRY</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412272</millis>
<sequence>3</sequence>
<logger>com.dtw.util.LoggingMgr</logger>
<level>FINER</level>
<class>com.dtw.util.LoggingMgr</class>
<method>LoggingMgr</method>
<thread>11</thread>
<message>ENTRY</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412271</millis>
<sequence>4</sequence>
<logger>com.dtw.util.LoggingMgr</logger>
<level>FINER</level>
<class>com.dtw.util.LoggingMgr</class>
<method>loadProperties</method>
<thread>10</thread>
<message>ENTRY</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412271</millis>
<sequence>5</sequence>
<logger>com.dtw.util.PropertiesMgr</logger>
<level>SEVERE</level>
<class>com.dtw.util.PropertiesMgr</class>
<method>getInstance</method>
<thread>10</thread>
<message>Initalizing PropertiesMgr in getInstance() method</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412287</millis>
<sequence>6</sequence>
<logger>com.dtw.util.PropertiesMgr</logger>
<level>FINER</level>
<class>com.dtw.util.PropertiesMgr</class>
<method>init</method>
<thread>10</thread>
<message>ENTRY</message>
</record>
<record>
<date>2009-02-23T08:46:52</date>
<millis>1235400412287</millis>
<sequence>7</sequence>
<logger>com.dtw.util.PropertiesMgr</logger>
<level>FINER</level>
<class>com.dtw.util.PropertiesMgr</class>
<method>loadProperties</method>
<thread>10</thread>
<message>ENTRY</message>
</record>
</log>
Here's the .xls file i've been putting together:
<?xml version="1.0" ?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<head>
<script type="text/javascript">
var rowID;
rowID=1
</script>
<script type="text/javascript">
function insRow(rowID)
{
var x=document.getElementById('myTable').insertRow(row ID)
var y=x.insertCell(0)
var z=x.insertCell(1)
z.colSpan=8;
y.innerHTML=""
z.innerHTML=""
}
</script>
</head>
<body>
<h1>Application Log</h1>
<script type="text/javascript">
document.write("<h1>Application Log</h1>);
</script>
Date: <input type="text" name="BeginDate" size="20"/> to <input type="text" name="EndDate" size="20"/>
<input type="button"
onclick="myfunction(BeginDate, EndDate)"
value="Filter"/>
<br />
<br />
Milliseconds: <input type="text" name="BeginMillis" size="20"/> to <input type="text" name="EndMillis" size="20"/>
<input type="button"
onclick="myfunction('MillisFilter')"
value="Filter"/>
<br />
<br />
Sequence: <input type="text" name="BeginSeq" size="20"/> to <input type="text" name="EndSeq" size="20"/>
<input type="button"
onclick="myfunction(BeginSeq, EndSeq)"
value="Filter"/>
<br />
<br />
<table id="myTable" border="1">
<tr style="background-color:PowderBlue;font-size:70%;">
<th>M</th>
<th>DATE</th>
<th>MILLIS</th>
<th>SEQ</th>
<th>LOGGER</th>
<th>LEVEL</th>
<th>CLASS</th>
<th>METHOD</th>
<th>THREAD</th>
</tr>
<xsl:for-each select="log/record">
<tr style="font-size:70%; font-family:lucida console;">
<script type="text/javascript">
rowID=7
</script>
<td style="color:green; font-size:25px" id="changer" onclick="insRow(rowID)">*</td>
<td><xsl:value-of select="date" /></td>
<td><xsl:value-of select="millis" /></td>
<td><xsl:value-of select="sequence" /></td>
<td><xsl:value-of select="logger" /></td>
<td><xsl:value-of select="level" /></td>
<td><xsl:value-of select="class" /></td>
<td><xsl:value-of select="method" /></td>
<td><xsl:value-of select="thread" /></td>
</tr>
<tr style="font-size:100%; font-family:lucida console;">
<td></td>
<td colspan="8" bgcolor="khaki"><xsl:value-of select="message" /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
If you apply the two together, you should see cells highlighted in yellow. I want those to be hidden when the page loads. I want it so that the user can click the asterisk on the left and then it shows the highlighted message row for that record. But, I don't know how to manipulate the data to do that.
Is there a way to easily create dynamic IDs for each row? Can I store the message line into a variable and then create a new cell on the row that is clicked on and bring in the text somehow? I'm clueless on the best way to approach this, everything I've tried has failed and i've worked on this for at least 6 hours now. A huge thanks to anyone who can help out or point me in the right direction.
Is there a way to store XML text in a javascript variable?
