You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Paul Spencer <pa...@apache.org> on 2005/07/25 17:32:30 UTC

How to configure MonitorResults in 2.1-rc1 to log the output in CSV?

How to configure MonitorResults in 2.1-rc1 to log the output in CSV?

I would like to use CSV instead of XML because it is easier to import 
the file into a spreadsheet application, i.e. OpenOffice or Excel.

Paul Spencer

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org

Re: How to configure MonitorResults in 2.1-rc1 to log the output in CSV?

Posted by Peter Lin <wo...@gmail.com>.
ahh ok. looks like I need to enhance the ResultCollector to output CSV
format. please file a feature enhancement.

peter


On 7/27/05, Paul Spencer <pa...@apache.org> wrote:
> Peter,
> Does not work. Changing the property
> jmeter.save.saveservice.output_format affects the default for "Save as
> XML" in the "Sample Results Save Configuration" window.
> 
> Below is an except from the file.
> 
> <monitorStats>
>    <stringProp name="stats.cpuload">0</stringProp>
>    <stringProp name="stats.load">19</stringProp>
>    <stringProp name="stats.health">3</stringProp>
>    <stringProp name="stats.host">foo.com</stringProp>
>    <stringProp name="stats.threadload">10</stringProp>
>    <stringProp name="stats.timestamp">1122478618179</stringProp>
>    <stringProp name="stats.port">-1</stringProp>
>    <stringProp name="stats.memload">28</stringProp>
>    <stringProp name="stats.protocol">http</stringProp>
> </monitorStats>
> 1122478618169,3706,foo.com status,200,OK,Monitor Group 1-1,text,true
> 
> 
> Notice the monitorStats are in XML format and their is a line in CSV format.
> 
> Should I add this to Bugzilla?
> 
> FYI: 2.1-rc1 is not in Bugzilla's list of versions.
> 
> Paul Spencer
> 
> 
> 
> Peter Lin wrote:
> > honestly, I haven't tried it. if you set jmeter to output in CSV using
> > jmeter.properties, it might work.
> >
> > peter
> >
> >
> > On 7/25/05, Paul Spencer <pa...@apache.org> wrote:
> >
> >>How to configure MonitorResults in 2.1-rc1 to log the output in CSV?
> >>
> >>I would like to use CSV instead of XML because it is easier to import
> >>the file into a spreadsheet application, i.e. OpenOffice or Excel.
> >>
> >>Paul Spencer
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >>
> >>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org

Re: How to configure MonitorResults in 2.1-rc1 to log the output in CSV?

Posted by Paul Spencer <pa...@apache.org>.
Peter,
Does not work. Changing the property 
jmeter.save.saveservice.output_format affects the default for "Save as 
XML" in the "Sample Results Save Configuration" window.

Below is an except from the file.

<monitorStats>
   <stringProp name="stats.cpuload">0</stringProp>
   <stringProp name="stats.load">19</stringProp>
   <stringProp name="stats.health">3</stringProp>
   <stringProp name="stats.host">foo.com</stringProp>
   <stringProp name="stats.threadload">10</stringProp>
   <stringProp name="stats.timestamp">1122478618179</stringProp>
   <stringProp name="stats.port">-1</stringProp>
   <stringProp name="stats.memload">28</stringProp>
   <stringProp name="stats.protocol">http</stringProp>
</monitorStats>
1122478618169,3706,foo.com status,200,OK,Monitor Group 1-1,text,true


Notice the monitorStats are in XML format and their is a line in CSV format.

Should I add this to Bugzilla?

FYI: 2.1-rc1 is not in Bugzilla's list of versions.

Paul Spencer



Peter Lin wrote:
> honestly, I haven't tried it. if you set jmeter to output in CSV using
> jmeter.properties, it might work.
> 
> peter
> 
> 
> On 7/25/05, Paul Spencer <pa...@apache.org> wrote:
> 
>>How to configure MonitorResults in 2.1-rc1 to log the output in CSV?
>>
>>I would like to use CSV instead of XML because it is easier to import
>>the file into a spreadsheet application, i.e. OpenOffice or Excel.
>>
>>Paul Spencer
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org

Re: How to configure MonitorResults in 2.1-rc1 to log the output in CSV?

Posted by Peter Lin <wo...@gmail.com>.
honestly, I haven't tried it. if you set jmeter to output in CSV using
jmeter.properties, it might work.

peter


On 7/25/05, Paul Spencer <pa...@apache.org> wrote:
> How to configure MonitorResults in 2.1-rc1 to log the output in CSV?
> 
> I would like to use CSV instead of XML because it is easier to import
> the file into a spreadsheet application, i.e. OpenOffice or Excel.
> 
> Paul Spencer
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org