This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Grouping Data Problem


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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]