[xsl] Grouping Data Problem

Subject: [xsl] Grouping Data Problem
From: Jeff Killingsworth <JKillingsworth@xxxxxxxxxx>
Date: Wed, 29 May 2002 12:21:58 -0400
I have multiple web site and have built a way to log all errors on these
sites in to files for later reference.  I have also built a way to parse
each file to get me the number of errors from each file per site. All of the
data is returned in the form of xml (see below).
My trouble is in the grouping mainly because of the multiple files that can
represent one file.

Here is what I am trying to do:
	1) Loop through each site
	2) Get a distinct error count per day for each site.

I have tried using an xsl:key but can not get it to work.

Please help.


[ XML ]
----------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<data>
   <site name="www.111.COM">
      <file date="5/25/2002" error_count="28">e:\2002_05_25.csv</file>
	<file date="5/26/2002" error_count="28">e:\2002_05_26.csv</file>
	<file date="5/27/2002" error_count="288">e:\2002_05_27.csv</file>
	<file date="5/28/2002" error_count="516">e:\2002_05_28.csv</file>

	<file date="5/29/2002" error_count="22">e:\2002_05_29.csv</file>
	<file date="4/29/2002" error_count="41">e:\old\2002_04_29.csv</file>

	<file date="4/30/2002" error_count="2">e:\old\2002_04_30.csv</file>
	<file date="5/1/2002" error_count="3">e:\old\2002_05_01.csv</file>
	<file date="5/2/2002" error_count="8">e:\old\2002_05_02.csv</file>
	<file date="5/3/2002" error_count="6">e:\old\2002_05_03.csv</file>
	<file date="5/4/2002" error_count="1">e:\old\2002_05_04.csv</file>
	<file date="5/5/2002" error_count="1">e:\old\2002_05_05.csv</file>
	<file date="5/6/2002" error_count="12">e:\old\2002_05_06.csv</file>
	<file date="5/7/2002" error_count="78">e:\old\2002_05_07.csv</file>
	<file date="5/7/2002" error_count="6">e:\old\2002_05_07.csv.1</file>
	<file date="5/8/2002" error_count="1">e:\old\2002_05_08.csv</file>
	<file date="5/9/2002" error_count="24">e:\old\2002_05_09.csv</file>
	<file date="5/10/2002" error_count="3">e:\old\2002_05_10.csv</file>
	<file date="5/11/2002" error_count="8">e:\old\2002_05_11.csv</file>
	<file date="5/12/2002" error_count="4">e:\old\2002_05_12.csv</file>
	<file date="5/15/2002" error_count="9">e:\old\2002_05_15.csv</file>
	<file date="5/17/2002" error_count="2">e:\old\2002_05_17.csv</file>
	<file date="5/18/2002" error_count="9">e:\old\2002_05_18.csv</file>
	<file date="5/19/2002" error_count="5">e:\old\2002_05_19.csv</file>
	<file date="5/22/2002" error_count="79">e:\old\2002_05_22.csv</file>
	<file date="5/23/2002" error_count="64">e:\old\2002_05_23.csv</file>
	<file date="5/24/2002" error_count="46">e:\old\2002_05_24.csv</file>
   </site>
   <site name="www.222.ORG">
	<file date="5/24/2002" error_count="7">E:\2002_05_24.csv</file>
	<file date="5/25/2002" error_count="7">E:\2002_05_25.csv</file>
	<file date="5/26/2002" error_count="17">E:\2002_05_26.csv</file>
	<file date="5/27/2002" error_count="19">E:\2002_05_27.csv</file>
	<file date="5/28/2002" error_count="16">E:\2002_05_28.csv</file>
      <file date="5/29/2002" error_count="13">E:\2002_05_29.csv</file>
   </site>
   <site name="www.333.ORG">
      <file date="5/24/2002" error_count="79">E:\2002_05_24.csv</file>
      <file date="5/25/2002" error_count="42">E:\2002_05_25.csv</file>
      <file date="5/26/2002" error_count="22">E:\2002_05_26.csv</file>
      <file date="5/27/2002" error_count="33">E:\2002_05_27.csv</file>
      <file date="5/28/2002" error_count="19">E:\2002_05_28.csv</file>
      <file date="5/29/2002" error_count="9">E:\2002_05_29.csv</file>
   </site>
</data>

Thanks,
______________________ 
Jeff Killingsworth 

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread