{"id":1117,"date":"2017-02-28T15:02:32","date_gmt":"2017-02-28T15:02:32","guid":{"rendered":"https:\/\/loadfocus.com\/blog\/?p=1117"},"modified":"2024-02-26T08:06:15","modified_gmt":"2024-02-26T08:06:15","slug":"how-to-save-apache-jmeter-results-to-a-csv-file-or-xml-file","status":"publish","type":"post","link":"https:\/\/loadfocus.com\/blog\/2017\/02\/how-to-save-apache-jmeter-results-to-a-csv-file-or-xml-file","title":{"rendered":"How to Save Apache JMeter Results to a CSV file or XML file?"},"content":{"rendered":"<\/span> 2<\/span> minutes read<\/span><\/span>

Here are details on how to save or export the results of your Apache JMeter test script to a CSV or XML file.<\/p>\n

Setup<\/h3>\n

1. Open Apache JMeter (here is how to start Apache JMeter on Mac<\/a>) and right click Test Plan<\/strong> and Add -> Threads (Users) -> Thread Group<\/strong>
\n2. Right click Thread Group<\/strong> and Add -> Samplers -> HTTP Request<\/strong>
\n3. Add example.com<\/strong> to the Server input field of the HTTP Request<\/strong>
\n4. Right click Thread Group and Add -> Listeners -> Aggregate Report<\/strong><\/p>\n

More details on how to load test a web server with Apache JMeter<\/a>.<\/p>\n

Save Apache JMeter Results to a CSV file<\/h3>\n

1. Configure the filename in the Filename<\/strong> field of the Aggregate Report<\/strong>
\ni.e.: [FULLPATH]\/results.csv<\/strong>
\nwhere [FULLPATH] is the path on the disk to the directory where you want to save the Apache JMeter results.
\n2. Run the test script
\nResult
\nA file with the results.csv<\/strong> name should now be created at the path specified.<\/p>\n

Save Apache JMeter Results to a XML file<\/h3>\n

1. Go in the Aggregate Report<\/strong> and click the Configure<\/strong> button
\n2. Check the Save as XML<\/strong> field in the top left corner.
\n3. Change the extension of the filename to XML i.e. [FULLPATH]\/results.xml<\/strong><\/p>\n

Result
\nA file with the results.xml name should now be created at the path specified.<\/p>\n

Save results to current test script location<\/h3>\n

If you want to use the current test script location as the destination of your Apache JMeter test scripts, you can follow the below steps:<\/p>\n

1. Right click the Thread Group<\/strong> and Add -> Config Element -> User Defined Variables<\/strong>
\n2. Add a new variable called resultsfile<\/em> and for the value use the following:<\/p>\n

For CSV: ${__property(user.dir)}${__BeanShell(File.separator,)}result.csv\nFor XML: ${__property(user.dir)}${__BeanShell(File.separator,)}result.xml\n<\/code><\/pre>\n<\/a>\n
(make sure the Save to XML<\/strong> is checkbox checked in the Aggregate Report)<\/p>\n
3. Go to the Aggregate Report<\/strong> and add the ${resultsfile} in the Filename field.<\/p>\n
Result
\nA file with the results.csv<\/em> or results.xml<\/em> name should now be created at the path specified.<\/p>\n
Dynamic Filenames<\/h3>\n
In order not to overwrite the result values from the JMeter script, we can append a timestamp to the filename:<\/p>\n
\nFor CSV: ${__property(user.dir)}${__BeanShell(File.separator,)}result_${__time(yyyyMMdd-HHmmss)}.csv\nFor XML: ${__property(user.dir)}${__BeanShell(File.separator,)}result_${__time(yyyyMMdd-HHmmss)}.xml\n<\/code><\/pre>\n
(make sure the Save to XML<\/strong> is checked in the Aggregate Report<\/strong>)<\/p>\n
Apache JMeter note:<\/strong>
\nDon’t use GUI mode for load testing, only for Test creation and Test debugging!
\nFor load testing, use NON GUI Mode & adapt Java Heap to your test requirements<\/p>\n","protected":false},"excerpt":{"rendered":"
<\/span>  2<\/span> minutes read<\/span><\/span>Here are details on how to save or export the results of your Apache JMeter test script to a CSV or XML file. Setup 1. Open Apache JMeter (here is how to start Apache JMeter on Mac) and right click Test Plan and Add -> Threads (Users) -> Thread Group 2. Right click Thread Group…  Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,48],"tags":[205,203,204],"class_list":["post-1117","post","type-post","status-publish","format-standard","hentry","category-apache-jmeter","category-test-automation","tag-save-aggregate-report-to-file","tag-save-jmeter-results-to-csv-file","tag-save-jmeter-results-to-xml-file"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts\/1117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/comments?post=1117"}],"version-history":[{"count":2,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts\/1117\/revisions"}],"predecessor-version":[{"id":2977,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts\/1117\/revisions\/2977"}],"wp:attachment":[{"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/media?parent=1117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/categories?post=1117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/tags?post=1117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}