RE: Database logging and log integration idea [implementation que stion]

["Schmukler, Stuart" <ss...@ebay.com>]

Folks,

I have been looking for something to process that XML data from overnight
runs, but to date I have not anything good. I have not found a way for excel
2000 or Open Office 6.0 to process the XML data.

However I have found that XMLSpy can convert the data into data base tables.
Or via an XSLT into a nearly clean HTML emulation of a CSV file.  

Enclosed is the XSL that our expert came up with to process the data.  Just
save it as a Text file with the extention of .csv from XMLSpy.  Delete the
first and third lines along with the two leading tab characters.  Vola, a
.csv for excel to use.

Now I am off to figure out how to convert timeStamp values to date and
times.


Have fun,
Stuart Schmukler



-----Original Message-----
From: Mike Stover [mailto:mstover1@apache.org]
Sent: Wednesday, October 16, 2002 10:12 AM
To: JMeter Users List
Subject: Re: Database logging and log integration idea [implementation
que stion]


Yes, that's true.  But CSV will just be a base to start from.  My point was
that, 
instead of trying to be an "open" format, JMeter should go for efficiency. 

-Mike

On 16 Oct 2002 at 10:18, Michal Kostrzewa wrote:

> Hi,
> 
> > Now I have an xml file....  Obviously lots of things parse xml and I bet
> > excel does too, just not as readily as it did csv.
> 
> I think csv has one problem xml and rdbs don't have. It can't store
relations. 
> there are some relations in jMeter - e.g. to one sample there may me
several 
> assertion results, one sample can have some subsamples... there is no
problem 
> for DB but CSV has flat structure
> 
> best regards
> Michal Kostrzewa
> 
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
> 



--
Michael Stover
mstover1@apache.org
Yahoo IM: mstover_ya
ICQ: 152975688

--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>

Re: Database logging and log integration idea [implementation que stion]

[Michal Kostrzewa <M....@pentacomp.com.pl>]

> Enclosed is the XSL that our expert came up with to process the data.  Just
> save it as a Text file with the extention of .csv from XMLSpy.  Delete the
> first and third lines along with the two leading tab characters.  Vola, a
> .csv for excel to use.

Yes, I suppose there are many methods for generating whatewer you like from 
xml. But 1) it can be time/memory consuming process 2)it's always off line 
(after doing the test) 3) I cannot imagine excel searching something in 2GB 
of samples I've collected last night... :-)

regards
Michal Kostrzewa



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>