JMeter tutorial 07 - How to read data from CSV File | Parameterization in JMeter

Hi Guys!
This video covers the concept of Parameterization, i.e. how to read data from CSV File in JMeter.
Learning:
What is Parameterization?
Parameterization is the process of creating multiple test data for single/multiple users in a test script

Why Parameterization?
Let’s say You have the task to load test the login functionality of the application under test. Since, it is a load test, you can not test it with a single login. In this case, you need to test it with multiple test data and hence you need to use the concept of parameterization.

Steps to parameterize your test data:
1)Put the test data in CSV file
2)Configure JMeter to read those test data from CSV file by adding Config Element - CSV data set config
3)Replace hard coded test data with variable

Fields under CSV dataset config:

1)Filename: This refers to the path to the CSV file which contains the test data
2)File Encoding: The encoding technique by which you want to read the CSV file eg: UTF-8
3)Variable Names: List your variable names(comma separated) to match the columns in the CSV file. You can keep this field empty if you want to use first line of CSV file as variable name
4)Ignore First Line: Set this field to True if you want to ignore the first line of CSV file, else take the default value -False. It is used only if Variable Names is not empty
5)Delimiter: ',' by default, you can set anything else too
6)Allow Quoted Data: Set this field to True if you have double quotes in CSV columns, else take the default value -False
7)Recycle on EOF: Set this field to True if you want JMeter to restart from the beginning when the End Of File is reached, else take the default value -False
8)Stop Thread on EOF: Set this field to True if you want to stop the current thread if EOF is reached; else take the default value -False;
9)Sharing Mode: It selects threads which share the same file pointer

==================================================================

JMeter Tutorial Playlist:

Git and GitHub Tutorial Playlist:

Automation Anywhere Tutorial Playlist:

UiPath Tutorial Playlist:

[farazshaikh]

Hi 🙋‍♂️
All videos are very helpful and easy to understand.
My question is how can we fetch data from csv file for POST request ?
Awaiting for your reply
Thanks 😊

[AmitKumar-cxs]

Wonderful session there any online batch currently running for Jmeter? Please provide the contact info

[vnecksurferdude]

wow, the Sharing Mode drop down options...thanks for explaining them. Now I COmPLEtelY understand it all.

[ankitapatel]

Hi Mam
Your're really explaining worthy and helpful, appreciated thanks

[kotamyogeswarreddy]

very clear explanation.Tq so much mam...

[modernlifemanager]

Hello Please help me with query.
What would be the possible failure reason for a script if the environment gets changed for example from UAT env to pre-production environment.

[BrijeshKumar-gzec]

Hello
Jmeter does load and performance testing. The config file is also there but it is only verify the content.
Who verifies or also checks the performance? or uploaded the file and verified its final result for testing purpose what should be done please make sure all the final result and html report is also clear all. Make the fully and concise report with purpose and all..

[hiteshkumar]

thanks for knowledge sharing videos. video quality is not so good (720p). please update them with atleast 1080p.

[mrinal]

Hi, In search sampler, Path is - /wiki/jmeter. But when you created record video tutorial(video 03), Path was - /search-redirect.php. Again in video 8, path becomes - /search-redirect.php. How ma'am?

[uzairsiddiqui]

Hi, Thanks alot for this video, I have one question, How can give the image parameter (attributes) in Body Data Like Firstname, Lastname, Profile_image Field for the Post Query in HTTP Request.

[jayeshmahadik]

Hi Mam, PLease explain Sharing Mode in detail.what is the purpose of different option provided in sharing mode

[nealkaffrey]

Hello
I have seached North America and I got the error in Jmeter. But when I searched North_America test script passed. (I search North America in Wikipedia Then modified the CSV file as north_america). why jemeter do not search north america? and to we can add ' _ ' in searching

[VAudioVideo]

For the "Send Parameters With the Request" section/table, for me if I replace "Value" columns with junk values, but not delete the "Jmeter" in the "Path" field (where it is "/wiki/Jmeter") as you mention at around 5:10, then the execution still takes me to the correct web page. So is my test still valid like this - meaning will my response time still be accurate and resemble how an actual person submits the request? Also, if i do delete "JMeter" in the path, the response also returns the JMeter page (as long as the "search" parameter is "JMeter". But if I also leave the other parameters as junk, it will still work. so this is confusing).

[gavinjames]

If i have integer values like No of Month in csv file and it contains all integer values in it and i want to pass dynamically in Body Data tab of particular HTTP request for integer values then how to do it
For example for string data we pass [" ${username}"] in Body data tab for string values.

[hiteshkumar]

I have an entry as "Asia, America" in CSV file and set the Jmeter csv config with delimeter with, and Allow quoted Data True, still getting the error in execution

[behumanfrst]

I have post operations with different payloads each time, how do I config to have multiple payloads to invoke same API?

url: abc.com/testdata
operation: POST
payload1: {"k1":"Have more data here"}

payload2: {"k1":"Have further more data"}

[anmoldhiman]

hi there, i am not able to get send parameters with the the request in searchinwikipedia even after creating video and all, which make me difficult to understand the video please help.

[Ganesh.Vaka_]

Hi,
We need complere explanation for the paramitrization of the sharing modes of all threads, current thread group, current thread

[Jagdeesh_mimicry]

if we have multiple hard coated values in our script what will approac?

[markjon]

hi mam iam sravan i have a query about jmeter every time am going to command prompt i can give the path of my result folder my cmd promt showing error like there is no file external or internal