How to save JMeter Aggregate Report results to a CSV file using command prompt?

csv jmeter command-prompt
Harshdeep picture Harshdeep · Nov 3, 2011 · Viewed 40.5k times · Source

I have been using JMeter in GUI mode for composing all the test cases required for load testing my service but for actual testing I need to execute tests in non-GUI mode. How do I save the results of Aggregate report in csv file using command-prompt.

Thanks in advance.

Answer

Aliaksandr Belik picture Aliaksandr Belik · Nov 3, 2011

Just as alternative: you may do this directly from the Aggregate Report listener.

1. set filename/template for results file:

resultsFile = ${__property(user.dir)}${__BeanShell(File.separator,)}result_${__time(yyyyMMdd-HHmmss)}.csv

2. configure Aggregate Report listener as shown below:

enter image description here

CSV-file generated in this case will differ from generated via GUI/"Save Table Data" one.

If it is not acceptable you'll better use method with JMeterPluginsCMD from previous answer:

java -jar JMeterPluginsCMD.jar --generate-csv aggregateResults.csv --input-jtl testResults.jtl --plugin-type AggregateReport

Related questions

Using CSV file to read test data from

I need to test a various links of a site (no need to login) with 100's of users and loop it for some number of times using JMeter. I want to put those links in a "CSV file", so that …

Read More
JMeter CSV Dataset Config: how to move through variables in the same thread?

I'm using a CSV dataset config element, which is reading from a file like this: abd sds ase sdd ssd cvv Which, basically, has a number of 3 letter random string. I'm assigning them to a variable called ${random_3}. Now, I …

Read More
Random selection from CSV file in Jmeter

I have a very large CSV file (8000+ items) of URLs that I'm reading with a CSV Data Set Config element. It is populating the path of an HTTP Request sampler and iterating through with a while controller. This is fine …

Read More