> yeah that's what i thought. dont need Perl to put it into right format.
My Perl log file processor is part of a Perl testing suite that runs other
test tools (say, apache bench) in parallel with JMeter as needed. I need the
log file parser to convert all logs into a common format for import to
Excel.
But there is a general need for a filter that "understands" JMeters log
format. One reason you may want to use it is to avoid problems with logs for
HTTP 302 redirects.
Here's an example: a normal JMeter log entry looks like this (truncated for
brevity):
-------------------------------------
<sampleResult ... time="156" ... />
-------------------------------------
But if this HTTP request went through two redirects before hitting the final
page, JMeter generates nested log entries that look like this:
-------------------------------------
<sampleResult ... time="2750">
<sampleResult ... time="2468" ... />
<sampleResult time="141" .../>
<sampleResult ... time="141" .../>
</sampleResult>
-------------------------------------
The outermost element time is the sum of times of the nested elements.
When I directly importing this JMeter log file into Excel 2002, I got three
entries for this operation, with all three showing the total time: (i.e.
time got tripled)
-------------------------------------
Login 2750
Login 2750
Login 2750
-------------------------------------
I had documented this in the regex put up in the wiki.
Sonam Chauhan
--
Electronic Commerce, Corporate Express Australia Ltd.
Phone: +61-2-9335-0725, Email: [EMAIL PROTECTED]
> -----Original Message-----
> From: nlunebur [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 2 December 2004 9:18 AM
> To: JMeter Users List
> Subject: Re: Excel tips and tricks
>
> yeah that's what i thought. dont need Perl to put it into right format.
> just go to excel and import data, select the delimiter and off u go!
> as explained by Guiseppe.
>
> nicole
>
> Giuseppe Ielpa wrote:
>
> >Are you sure it is needed to filter the log by Perl?
> >I made a try with my Excel 2002 installation, and I
> >proved that it is able to open XML files.
> >
> >Just try File|Open, by setting file type as XML file
> >and it should work.
> >
> >Best
> >
> >Giuseppe Ielpa
> >[EMAIL PROTECTED]
> >
> >
> >
> >
> >
> >>-----Original Message-----
> >>From: Sonam Chauhan [mailto:[EMAIL PROTECTED]
> >>Sent: Wednesday, December 01, 2004 1:45 AM
> >>To: 'JMeter Users List'
> >>Subject: Excel tips and tricks
> >>
> >>
> >>Hi - What Peter said below got me thinking... a few people
> >>here (including
> >>me) use Excel to analyse JMeter logs. It would be good for us
> >>to share tips and tricks, or even jointly develop macros, etc.
> >>
> >>
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
