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]

Re: Grouping Data Problem


Hello Jeff,

it's difficult to understand, what you really want. Is it a grouping 
problem or only a summing problem. From your "what I am trying to do" I 
assume the last. But you always have the error_count per site per day. 
Maybe it's still a grouping problem. Hmm? I think it's easier, when you 
sent the expected output from the below XML or explained it in another way.

Joerg

Jeff Killingsworth wrote:
> 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]