Save View Results in Table listener as a csv file in jmeter

csvjmeterperformance-testingsave

I am running a test script on jmeter and I want to save the results I obtained from the 'View Results in Table' listener. I just don't understand how I would do this the same way I save the results in the Summary Report and Aggregate Report listener; that is, there is no 'Save Table Data' in the bottom of the View Results in Table unlike the other listeners. How can I do this?

Best Answer

Summary Report and Aggregate Report have "Save Table Data" button because the majority of values in them are calculated.

View Results in Table listener just displays raw data therefore it does not require to calculate anything hence there is no "Save Table Data" button.

I am under impression that you are using JMeter a little bit wrong. Normally you should not be saving listeners output separately, moreover you don't even need the listeners during the test run.

Run your test in command-line non-GUI mode like:
```
jmeter -n -t test.jmx -l results.jtl
```
After your test is done open JMeter GUI add a listener of your choice to Test Plan and open results.jtl file with that listener

Make sure that all the listeners are either disabled or deleted during the test execution as they cause huge memory overhead which may cause lesser throughput or even ruin your test. See Greedy Listeners - Memory Leeches of Performance Testing arcticle for more detailed explanation.

Related Solutions

Mysql – How to output MySQL query results in CSV format

From Save MySQL query results into a text or CSV file:

SELECT order_id,product_name,qty
FROM orders
WHERE foo = 'bar'
INTO OUTFILE '/var/lib/mysql-files/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Note: That syntax may need to be reordered to

SELECT order_id,product_name,qty
INTO OUTFILE '/var/lib/mysql-files/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM orders
WHERE foo = 'bar';

in more recent versions of MySQL.

Using this command, columns names will not be exported.

Also note that /var/lib/mysql-files/orders.csv will be on the server that is running MySQL. The user that the MySQL process is running under must have permissions to write to the directory chosen, or the command will fail.

If you want to write output to your local machine from a remote server (especially a hosted or virtualize machine such as Heroku or Amazon RDS), this solution is not suitable.

Android – Save bitmap to location

try (FileOutputStream out = new FileOutputStream(filename)) {
    bmp.compress(Bitmap.CompressFormat.PNG, 100, out); // bmp is your Bitmap instance
    // PNG is a lossless format, the compression factor (100) is ignored
} catch (IOException e) {
    e.printStackTrace();
}

Best Answer

Related Solutions

Mysql – How to output MySQL query results in CSV format

Android – Save bitmap to location

Related Topic