{"id":2165,"date":"2021-12-01T14:49:23","date_gmt":"2021-12-01T14:49:23","guid":{"rendered":"https:\/\/loadfocus.com\/blog\/?p=2165"},"modified":"2023-09-03T14:10:06","modified_gmt":"2023-09-03T14:10:06","slug":"how-to-use-csv-data-set-to-configure-jmeter-tests","status":"publish","type":"post","link":"https:\/\/loadfocus.com\/blog\/2021\/12\/how-to-use-csv-data-set-to-configure-jmeter-tests","title":{"rendered":"How to Use CSV Data Set to Configure JMeter Tests"},"content":{"rendered":"<\/span> 3<\/span> minutes read<\/span><\/span>\n

Apache JMeter<\/a> is a Java-based, open source testing tool, which can help you create and run functional and load tests for Websites, APIs (REST and SOAP) and other web services.<\/p>\n\n\n\n

In this example we are going to have a look on how to create and run a JMeter test using a CSV file<\/strong> for our data, and consume the data in our test from that CSV file.<\/p>\n\n\n\n

First, let’s open JMeter and create a new JMeter test script. <\/p>\n\n\n\n

Add a Thread Group<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Inside the Thread Group add the following:<\/p>\n\n\n\n


CSV Data Set Config<\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n


HTTP Request<\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

View Results Tree<\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Configure the CSV Data Set Config<\/h2>\n\n\n\n

Why do we need a CSV Data Set Config<\/strong> config element?<\/p>\n\n\n\n

Because the CSV Data Set Config<\/strong> is used to read lines from a file, and split them into variables, and is exactly what we need to be able to generate this data-driven tests.<\/p>\n\n\n\n

Inside the CSV Data Set Config<\/strong> there are few fields you need to configure in order to run Apache JMeter tests and load the data for the test from a CSV file.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The Filename<\/strong> is the property which defines the name of the file to be read and we can use relative paths with respect to the JMX test script. <\/p>\n\n\n\n

So to use a CSV file located in the same folder as the JMX file, simply add .\/ in front of the CSV filename: .\/file1.csv<\/code><\/strong><\/p>\n\n\n\n

In order to use the values extracted from the CSV file, we need to define the variable names, in our case is a list of users and passwords, so we’ll add user,password (names must be separated by the delimiter character).<\/p>\n\n\n\n

Note: JMeter supports CSV header lines: if the variable name field empty, then the first line of the file is read and interpreted as the list of column names.<\/em><\/p>\n\n\n\n

Next step is to choose the delimiter, we found out that the easiest to use is the comma delimiter, so in our CSV file we’ll separate the key,value pairs with a comma as below:<\/p>\n\n\n\n

John1,password1<\/code><\/p>\n\n\n\n

John2,password2<\/code><\/p>\n\n\n\n

John3,password3<\/code><\/p>\n\n\n\n

More details on the CSV Data Set Config can be found in the JMeter docs<\/a>.<\/p>\n\n\n\n

Configure the HTTP Request<\/h2>\n\n\n\n

Now, in the HTTP Request Sampler we are going to use the values extracted from the CSV file by appending the variable names at the end of the PATH for the GET request:<\/p>\n\n\n\n

https:\/\/example.com?${user}&${password}<\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We are going to run the JMeter test script we’ve created and check in the View Results Tree listener that the values for the PATH field in each request are going to be updated with the values extracted from the CSV file used in the CSV Data Set Config.<\/p>\n\n\n\n

And we can see that the GET requests made have the following Paths:<\/p>\n\n\n\n

GET https:\/\/example.com?John1&password1<\/code><\/p>\n\n\n\n

GET https:\/\/example.com?John2&password2<\/code><\/p>\n\n\n\n

GET https:\/\/example.com?John3&password3<\/code><\/p>\n\n\n\n

Run JMeter Tests with CSV Data Files in the Cloud<\/h2>\n\n\n\n

Now that we have a JMeter JMX test script and a CSV file used by the JMX file to inject the data in the test, we can run this test in the cloud from multiple cloud locations with thousands of virtual concurrent users using the JMeter Cloud Load Testing Tool<\/a>.<\/p>\n\n\n\n

Just go to New JMeter Test page, and upload the JMX<\/strong> and CSV files<\/strong> and hit the Run Test<\/strong> button, and your test will automatically run in the cloud:<\/p>\n\n\n\n

\n
https:\/\/d2woeiihr4s5r6.cloudfront.net\/loadtesting\/video\/new-jmeter-test-original.mp4<\/a><\/video><\/div>\n<\/div><\/figure>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

START TESTING TODAY<\/strong><\/a><\/h3>\n\n\n\n
\n\n\n\n

Written by Bogdan Vazzolla<\/a>.<\/em><\/p>\n\n\n\n

LoadFocus<\/a> is a cloud testing platform, a load and stress testing tool<\/a> which provides the infrastructure to run tests with thousands of concurrent users, from multiple cloud locations<\/a>, in less than a few minutes, keep history of the results, compare different runs to inspect performance improvements or performance degradation.<\/em> It also supports running JMeter load tests from the cloud<\/a><\/em> and monitoring and audit web and mobile performance<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

<\/span> 3<\/span> minutes read<\/span><\/span>Apache JMeter is a Java-based, open source testing tool, which can help you create and run functional and load tests for Websites, APIs (REST and SOAP) and other web services. In this example we are going to have a look on how to create and run a JMeter test using a CSV file for our… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":2289,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,9,6,48],"tags":[369,368],"class_list":["post-2165","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apache-jmeter","category-load-testing","category-performance-testing","category-test-automation","tag-csv-data-set-jmeter-load-tests","tag-jmeter-csv-data-config"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts\/2165","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=2165"}],"version-history":[{"count":2,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts\/2165\/revisions"}],"predecessor-version":[{"id":2775,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/posts\/2165\/revisions\/2775"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/media\/2289"}],"wp:attachment":[{"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/media?parent=2165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/categories?post=2165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/loadfocus.com\/blog\/wp-json\/wp\/v2\/tags?post=2165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}