JMeter Beginner Tutorials | Tips n Tricks 9 💡 How to Create Aggregate Result csv from command line

Step 1 : Add JMeterPlugins-Standard lib

Step 2 : Run your test and get jtl file

Step 3 : Use JMeterPluginsCMD.bat to generate aggregate csv result file from jtl file

syntax:

JMeterPluginsCMD.bat --generate-csv "location of csv file" --input-jtl "location of jtl file" --plugin-type AggregateReport

Use JMeterPluginsCMD tool with Plugin Type = AggregateReport

References:
________________________________________________________________

Do like, share and subscribe

Keep Learning,
Raghav
_________________________________________________________________

Learn JMeter step-by-step for Beginners

_______ ONLINE COURSES TO LEARN ________

[kakwanisatish]

Hi Raghav,

I'm aware of another way of creating aggregate result csv from jtl file.

There are chances of you already knowing this, still I thought of no harm in communicating it to you :)


Below are the steps :


1) Open Jmeter

2) Add listener - - > Aggregate Report

3) Click browse button  - - > Navigate to the path where your jtl file is saved and open the file.

4) Jmeter should load the aggregate report, click on 'Save Table Data' button present at bottom

5) It should generate aggregate report csv as required


Please correct me if have mentioned anything wrong.

[ashishprabhakar]

You Saved me Raghav thank you so much buddy for this useful video.

[dharanikumar]

Awesome Raghav i love it, from now i will travel with you :)

[sandext]

Great video Raghv. My jmeter version is 5.1.1 and these steps didn't work. Looks like jmeter has changed a lot in release 5.0 onward. Please share steps to do the same in jmeter 5.1.1 version also. would be a big help. Thanks

[vishalsood]

hey Raghav, thanks for this video

But can we create a summary report in CSV with non GUI mode

[namanvohra]

Hey Raghav, by any chance, could u please let me know how can I calculate standard deviation from JMeter aggregate report? I know the easiest way is to get it from summary report, but I don't want to redo all testing 😥

[JUGIXXXX]

In your video, percentile columns for 90%, 95% and 99% had been created by this plugin.
I also used plugin version 1.4.0. as you did. But in my generated csv, there was only 90% line.
Then I checked the sources (also for versions 1.3.1 and 1.3.0). In all of them, only 90% was calculated.
So output having only 90% line is correct.
Now I wonder why your csv contains also the other percentile columns.
Can you imagine how this can be?

[manekagayomi]

Hi Raghav,
From the 10 th video we unable to watch.It says it is private video.same issu in the "Postman" too.

[JeffryRajan]

How to display only transaction controller names and not sampler names in aggregate graph

[mohdsarfraz]

why we are using lengthy steps. we just need to import Abc.jtl into aggregate listener then export into *.csv

[maythuta]

Hello! I follow all the steps. But it just comes out a csv file without any data! How should I do.

[rajidamuluri]

Can we add a timestamp to results file created from command line

[mishkakamtikar]

Hi raghav i followed all steps i am getting the below error - ERROR: java.lang.NoSuchMethodError: 'void org.apache.jmeter.save.CSVSaveService.saveCSVStats(java.util.List, java.io.FileWriter, java.lang.String[])'
*** Problem's technical details go below ***


i am using below ocde - --generate-csv LMSaggv.csv" --input-jtl --plugin-type AggregateReport

[charankumar]

What modification we have to do for grouping all samples in CSV file?

[maheshgoud]

Hi Guys
I am Getting Below Error when i try to create CSV from command line

ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initialization logging.

Please suggest me.

[adityau]

i have also tried with the below command and facing the below error
-jar CMDRunner.jar --generate-csv --input-jtl --plugin-type AggregateReport
ERROR: No suitable tool class provided in params
*** Problem's technical details go below ***
Home directory was detected as:
Exception in thread "main" No suitable tool class provided in params
at
at
at Method)
at Source)
at Source)
at Source)
at

[IqraNaz-qq]

Hi @RaghavPal I am facing this issue in jmeter 5.5
--generate-csv --input-jtl --plugin-type AggregateReport

'JMeterPluginsCMD' is not recognized as an internal or external command,
operable program, or batch file.
even batch file is present in jmeter lib/ext folder