You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Nalini <na...@gmail.com> on 2011/06/29 00:50:03 UTC

How to export the result files

When i tried to Write the results to file / Read from file option in View
Results in Table Listener(Tried to export the results in .CSV format) i am
getting the results in below format  

<?xml version="1.0" encoding="UTF-8"?>
<testResults version="1.2">
<httpSample t="763" lt="354" ts="1309298555984" s="true" lb="HTTP Request"
rc="200" rm="OK" tn="Thread Group 1-1" dt="text" by="157246"/>
<httpSample t="822" lt="381" ts="1309298556749" s="true" lb="HTTP Request"
rc="200" rm="OK" tn="Thread Group 1-1" dt="text" by="157069"/>
<httpSample t="1491" lt="441" ts="1309298557986" s="true" lb="HTTP Request"
rc="200" rm="OK" tn="Thread Group 1-2" dt="text" by="156654"/>
<httpSample t="430" lt="365" ts="1309298559479" s="true" lb="HTTP Request"
rc="200" rm="OK" tn="Thread Group 1-2" dt="text" by="157069"/>
<httpSample t="324" lt="259" ts="1309298559987" s="true" lb="HTTP Request"
rc="200" rm="OK" tn="Thread Group 1-3" dt="text" by="157075"/>
       
why it is do? Why i am not getting the exact results format which i get in
Jmeter? Then how can i export the result file where i will get the same
format like Jmeter?

With Regards
Nalini Ravikumar

--
View this message in context: http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4533620.html
Sent from the JMeter - User mailing list archive at Nabble.com.

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


Re: How to export the result files

Posted by sebb <se...@gmail.com>.
On 30 June 2011 00:38, Nalini <na...@gmail.com> wrote:
> Thanks depak and seb. Yes it is comfortable with Summary report and Aggregate
> report Listeners. But i am finding difficult with View Result in table
> listener.

That listener does no processing of the samples at all, so I'm not
sure I understand why you would want to save the visual data.

Save the test data as CSV, and you can then load it into a spreadsheet
or whatever for further processing.

> With regards
> Nalini
>
> --
> View this message in context: http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4537129.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> 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 export the result files

Posted by Nalini <na...@gmail.com>.
Thanks depak and seb. Yes it is comfortable with Summary report and Aggregate
report Listeners. But i am finding difficult with View Result in table
listener.

With regards
Nalini

--
View this message in context: http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4537129.html
Sent from the JMeter - User mailing list archive at Nabble.com.

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


Re: How to export the result files

Posted by sebb <se...@gmail.com>.
On 29 June 2011 20:50, Deepak Shetty <sh...@gmail.com> wrote:
>>The results are not getting exported  in a tabular column as it looks like
> in Jmeter.
> You need to reload the file in the listener. You can get raw CSV , but I
> dont think you can directly get the data as the listener displays. You can
> also post process the XML using the included XSL stylesheet to get a summary
> table that looks just like the listener

Some Listeners - e.g. Summary Report - have a "Save" button that
allows the visible results to be saved.

> regards
> deepak
>
>
> On Wed, Jun 29, 2011 at 12:45 PM, Nalini <na...@gmail.com> wrote:
>
>> Can any one help me in this point? Even when i changed the configurations,
>> i
>> am getting the output in xml format itself. The results are not getting
>> exported  in a tabular column as it looks like in Jmeter.
>>
>> With Regards
>> Nalini
>>
>> --
>> View this message in context:
>> http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4536382.html
>> Sent from the JMeter - User mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> 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 export the result files

Posted by Deepak Shetty <sh...@gmail.com>.
>The results are not getting exported  in a tabular column as it looks like
in Jmeter.
You need to reload the file in the listener. You can get raw CSV , but I
dont think you can directly get the data as the listener displays. You can
also post process the XML using the included XSL stylesheet to get a summary
table that looks just like the listener

regards
deepak


On Wed, Jun 29, 2011 at 12:45 PM, Nalini <na...@gmail.com> wrote:

> Can any one help me in this point? Even when i changed the configurations,
> i
> am getting the output in xml format itself. The results are not getting
> exported  in a tabular column as it looks like in Jmeter.
>
> With Regards
> Nalini
>
> --
> View this message in context:
> http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4536382.html
> Sent from the JMeter - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

Re: How to export the result files

Posted by Nalini <na...@gmail.com>.
Can any one help me in this point? Even when i changed the configurations, i
am getting the output in xml format itself. The results are not getting
exported  in a tabular column as it looks like in Jmeter.

With Regards
Nalini

--
View this message in context: http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4536382.html
Sent from the JMeter - User mailing list archive at Nabble.com.

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


Re: How to export the result files

Posted by Nalini <na...@gmail.com>.
Hi Bruce

Thanks for the reply. I tried changing the result configuration and i am
getting below error from Jmeter GUI tool.

*"Error Loading result file. See Log file"*

When i looked at the Jmeter.log file, i am getting below error.

*2011/06/28 17:12:45 WARN  - jmeter.save.CSVSaveService:
java.lang.NumberFormatException: For input string: "" 
2011/06/28 17:12:45 WARN  - jmeter.save.CSVSaveService: Error parsing field
'timeStamp' at line 1 java.text.ParseException: Unparseable date: "" 
2011/06/28 17:12:45 WARN  - jmeter.reporters.ResultCollector: Problem
reading JTL file:
/bg1/nalini/Downloads/jakarta-jmeter-2.4/bin/Sample_V4.csv* 

Why it is showing this error and what is the meaning for this?Please help on
this point

Thanks in advance

With Regards
Nalini

With Regards


--
View this message in context: http://jmeter.512774.n5.nabble.com/How-to-export-the-result-files-tp4533620p4533668.html
Sent from the JMeter - User mailing list archive at Nabble.com.

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


Re: How to export the result files

Posted by Bruce Ide <fl...@gmail.com>.
Oh! Did you click on the "Configure" button to the right? There are like 87
different things you can enable. It'd probably look a lot more like what you
see in jmeter if you enable all those things. Maybe you can leave some of
them out, if there are only certain options you're interested in...

-- 
Bruce Ide
FlyingRhenquest@gmail.com