JMeter Beginner Tutorial 15 - How to read data from CSV file (Parameterisation)

more from Raghav - automationstep...
Step 1 : Add config element - CSV Data Set Config
Step 2 : Add details in CSV Data Set Config
Step 3 : Update value fields: ${variable_name}
Step 4 : Run and validate
----------- PERFORMANCE TESTING -----------
JMeter Beginner - bit.ly/2oBbtIU
JMeter Intermediate - bit.ly/2oziNVB
JMeter Advanced - bit.ly/2Q22Y6a
JMeter Tips & Tricks - bit.ly/2NOfWD2
Performance Testing - bit.ly/2wEXbLS
_______ ONLINE COURSES TO LEARN _______
Visit - automationstepb...
----------- UI TESTING -----------
Selenium Beginners - bit.ly/2MGRS8K
Selenium Java Framework from Scratch - bit.ly/2N9xvR6
Selenium Python - bit.ly/2oyMp5x
Selenium Tips - bit.ly/2owxc50
Selenium Builder - bit.ly/2MKNtlq
Katalon Studio - bit.ly/2wARFdi
Robot Framework - bit.ly/2Px6Ue9
----------- API TESTING -----------
Web Services (API) - bit.ly/2MGafL7
SoapUI - bit.ly/2MGahmd
Postman - bit.ly/2wz8LrW
General - bit.ly/2PYdwmV
----------- MOBILE TESTING -----------
Mobile Playlist - bit.ly/2PxpeUv
----------- CI | CD | DEVOPS -----------
Jenkins Beginner - bit.ly/2MIn8EC
Jenkins Tips & Trick - bit.ly/2LRt6xC
Docker - bit.ly/2MInnzx
----------- VERSION CONTROL SYSTEM -----------
Git & GitHub - bit.ly/2Q1pagY
----------- JAVA -----------
Java Beginners - bit.ly/2PVUcXs
Java Tips & Tricks - bit.ly/2CdcDnJ
----------- MAVEN -----------
Maven - bit.ly/2NJdDRS
----------- OTHERS -----------
Redis- bit.ly/2N9jyCG
Misc - bit.ly/2Q2q5xQ
Tools & Tips - bit.ly/2oBfwoR
QnA Friday- bit.ly/2NgwGpw
Sunday Special - bit.ly/2wB23BO
Ask Raghav- bit.ly/2CoJGWf
Interviews - bit.ly/2NIPPxk
All Playlists - bit.ly/2LSiezA
----------- Follow -----------
Facebook - / automationstepbystep
Twitter - / automationsbs
KZbin - / automationstepbystep
Never Stop Learning
Raghav

[@RaghavPal]

Check online courses & training - automationstepbystep.com/

[@shipinpk706]

can you explain this concept with stepping thread group?

[@deepakMCA2009knit]

I must say to thank you for all your free and handy tutorials of Jmeter. Before 4 to 5 years I had automation skill along with Jmeter. I am working in a big MNC right now and in these 5 years MNCs never ever given me chance to continue my this skill and I forgot about it. You are helping me to get that confidence back and making me able to say them, Hey give me some automation work or Good Bye !! Happy Guru Purnima 'The Teacher' :)

[@RaghavPal]

Deepak, I am so glad that this is helping you. Thanks for your message and Keep Learning. All the best.

[@venkatasuresh8649]

Who does not like this. Your explanation is awesome

[@RaghavPal]

Thanks Venkata

[@RK-gj8um]

Thank you Raghav, your explanation is very good

[@aksluva8]

hey Raghav, great tutorials loved it. Very simple explanation.

[@reddevilmelbourne]

Raghav, this session is great and your presentation as well. Can you please make a session on Beanshell post processor and how to export data from response json to csv file. Thanks in Advance

[@RaghavPal]

sure Akhil, will make it.

[@elsiemuthiani5921]

awesome teaching thanks very well understood and practiced

[@RaghavPal]

You are welcome Elsie

[@GautamKumar-dg8qc]

Hi thanks for the video I have one doubt as you mentioned that 3 rows are there so we took 3 iterations, what if we take the iterations as infinite then it will repeating again again right. Like 1,2,3 then 1,2,3... and so on infinitely right?

[@RaghavPal]

Gautam Yes, you're correct. When you set the iterations to "Infinite" in the JMeter CSV Data Set Config, it will continuously repeat the rows in the CSV file, effectively creating an endless loop. Here's a detailed explanation of how it works: 1. CSV Data Set Config Setup: - You add a CSV Data Set Config element to your test plan. - You specify the path to the CSV file containing the data rows. - You set the "Recycle on EOF?" option to "True" (this is the default). - You set the "Stop thread on EOF?" option to "False." - You set the "Number of threads" (virtual users) to your desired value. - You set the "Loop Count" to "Infinite." 2. Iteration Process: - JMeter starts reading data from the CSV file, feeding it to each virtual user. - When it reaches the end of the CSV file (EOF), it rewinds to the beginning and starts reading again, continuously repeating the rows. - This cycle continues indefinitely, as long as the test is running and the "Loop Count" is set to "Infinite."

[@GautamKumar-dg8qc]

@@RaghavPal got it, thanks for reply.

[@Pinguofficial1234]

Thanks for the Jmeter classes very useful Can I know if we can have multiple excel sheets and access them?

[@RaghavPal]

Hi Nagma, you can, you can create multiple csv data set config for that, and add the data set config as a child of the request where you want to use the data

[@aashisoni6018]

This video is so helpful and easy to understand. I want to know is there any way to pass multiple values in HTTP header manager through CSV?

[@RaghavPal]

Hi Aashi, can check this stackoverflow.com/questions/19541133/jmeter-use-csv-for-setting-http-header

[@aashisoni6018]

@@RaghavPal Thanks for reply, it's working, already tried.

[@pratikshatamadalge6275]

Great tutorial, Is there in other tutorial to read (Array)data from CSV file (Parameterisation)? Please suggest

[@RaghavPal]

Not yet Pratiksha

[@ayyanzchannel2.0]

Hi, You created new videos related to Rest and SOAP in Octrober 2020 so this tutorial num 15 is not making sense for me. Please guide me in this confusion.

[@RaghavPal]

Hi, I created new videos for API testing on JMeter as the old videos on that were outdated as JMeter does not have separate API sampler now.

[@abhinay5619]

Iam following automation and jmeter as well .I am implementing in our office with that skills .thanks Aditya... one question related to jmeter .my application will generate one token when we login to that ,so for performance testing how can we extract the token and how can we do load test for that ..

[@RaghavPal]

Hi Abhi, pls check regular expression extractor video kzbin.info/www/bejne/bV6xlKyQqrqEpNk

[@mydinidivya9664]

Hi Raghav, please share some details to add user defined variables in user.properties file in jmeter

[@RaghavPal]

I will do a session on this soon Divya

[@theposterguy5312]

Thanks for your Jmeter videos 👍

[@RaghavPal]

Glad you like them!

[@bandimohanreddy4251]

Nice explanation 😄

[@RaghavPal]

Thanks

[@vishalrathod-dn5sw]

Thank you so much it is working for me. Really appreciated.

[@RaghavPal]

You're welcome Vishal

[@16prish]

Hi Raghav, I have question regarding report which would be generated from different CSV data then how to identify those from report.

[@RaghavPal]

Hi Prishani, you can use the __CSVRead() function and can try some functions to get this added in reports. Not a usual thing that we do so will need to do some work for this

[@jennifergroff7832]

Thank you so much I really truly appreciate your tutorials. I am walking through them since I am new to this and do it for my job. I am not finding the Tutorial #9 at all that you created the test from, the list has changed or it is not avail any longer? Can you point me in the correct direction so I can follow this video, I really need to know how to pull data from CSV for my tests. Thank you

[@RaghavPal]

Hi Jennifer, thanks for your message. Pls check the complete playlist here - kzbin.info/www/bejne/m5K4aGxrZsuBq7M

[@patrycjah3393]

Thanks a lot! You helped a lot, again!

[@RaghavPal]

You're welcome Patrycja

[@saleemsoomro5675]

Raghav great tutorial.

[@RaghavPal]

thanks for watching.

[@anilaantu5972]

Hi Raghav, Do I need to parameterize login credentials(giving say 20 username and password in csv file, so that each login attempt will be from different user) when I do load testing for an application?

[@RaghavPal]

Hi Anila, it depends, usually people do this to get a realistic scenario. If the same user logs in there may be a chance of cache and memory built up, but that can be taken care by using Cache and cookie manager

[@anilaantu5972]

@@RaghavPal Thanks Raghav. Cookie and cache can be managed by config elements right? But do we need to take care of SSO while attempting different logins? How can I give variable names like in this video? Could you do a quick video on that? Please.

[@RaghavPal]

Hi Anila, although I will plan more sessions related to this. For now you can check - www.blazemeter.com/blog/how-load-test-saml-sso-secured-websites

[@anilaantu5972]

@@RaghavPal Thank you so much Raghav. Much appreciated! Thanks for your fantastic tutorials.

[@kishanpatel6657]

Hello Raghav sir, You are referencing about "Tutorial 9 Testing Web Services Api" ... but I can not able to find it in your playlist and I think you have replaced that video with new SOAP and REST service testing videos. so my question is can I know which URL you are using for REST-RPC, Soap-RPC and HTTP request ? Thank you for this tutorials man ... You have been doing good job ! #BlessingsFromCanada

[@RaghavPal]

Hi Kishan, yes as that video was obsolete I updated it with the latest API testing videos. You can check this - kzbin.info/aero/PLhW3qG5bs-L9sCVY1c_vox9blIrIzwEEb

[@kishanpatel6657]

@@RaghavPal Thank you for quick reply ... Appreciate it !

[@ankitkabra20]

Thanks Raghav. Tutorial is very handy and helpful. I have a question we are passing the complete Json file as input parameter How we can do that ? I want to create scenario where I CSV will feed data to all the threads with the dynamic data. Can this be achievable?.

[@RaghavPal]

hi Ankit, you can try to write a Bean Shell script to get your values from file and then run your test.

[@saiganeshn8588]

Great tutorial bro helped me a lot

[@RaghavPal]

Great to know Sai

[@nithyahari3462]

Thanks Raghav, I have a situation to pass multiple row values in single request. I am using random csv data set config. If I just use parameter name it uses same row value twice. How to make it chose different row. Something like [{$city, $email}, {$city,$email}].

[@RaghavPal]

Hi Nithya, usually once you refer it take one of the random values from csv and will use that value unless you refer the same parameter again. If you like I can check your setup. Can upload your setup image here imgbb.com/upload and send me the link

[@behumanf1rst]

Good tutorial. I have POST operations, instead of sending payload in HTTP Requests as body data, I need to send as files so that each files will have different types of payload. Do you have video for this setup?. I mean I have to use __FileToString(... __eval...)

[@RaghavPal]

Hi Kasim, not yet, you can get some help here stackoverflow.com/questions/39037049/how-to-upload-a-file-and-json-data-in-postman

[@hamifargoogle7618]

Can you please create video on parameterization on some application in which you have to supply multiple username and passwords?

[@RaghavPal]

Hi sure, I will do a session

[@andyueapisit3442]

What's tutorial that you taught about reading excel to insert Database

[@RaghavPal]

Did not get you..

[@arpitasharma5683]

Hi Raghav, Your tutorials are very helpful I am functional tester but need to work now on performance testing so your tutorial are very helpful. Getting below error: Connection timed out while running a post request and providing input parameters from csv file

[@RaghavPal]

Hi Arpita, check if the correct values are referred from CSV, You can do debugging like this kzbin.info/www/bejne/bXusZHp6Zc6Zitk

[@snehalsangle1782]

If I am using Stepping Thread Group, there is no option like loop, so if i want to parameterise request do i have to add threads same as number of parameters. I mean 2 threads for 2 parameters?

[@rajashekharkorva6212]

Thank you, Raghav. Is there a way to read the data from CSV in non-GUI mode. If not, how can we use multiple values for a single parameter when we run from command line.

[@RaghavPal]

Hi Rajashekhar, if you have configured to use data from csv, it will work even from commandline. Pls try and see if you get any issues. You can check this too for help - stackoverflow.com/questions/38082400/passing-csv-data-set-config-file-as-parameter-to-jmeter/38085980#38085980

[@rajashekharkorva6212]

@@RaghavPal Thanks again Raghav. The link you shared helped. I really appreciate it!!

[@samueldepablos3853]

How do I make each Vuser take an unused (unique) data value from the text file on the first iteration and keep the same value for all iterations and occurrences?. Thanks.

[@RaghavPal]

Hi Samuel, you can see the settings in CSV data set config You can also use functions for this

[@himanshudx24]

Hi Raghav can you please share the link of the previous video as the 9th video i see in the playlist doesnt have weather information as mentioned in this video, Thanks!

[@RaghavPal]

Hi Himanshu, I believe this refers to the API web services video, I have added it as tutorial 11. I had earlier removed it as it became outdated with the new changes in JMeter, Now I have added it again and also updated the description. Pls check - kzbin.info/www/bejne/m5K4aGxrZsuBq7M

[@himanshudx24]

Hi Raghav do you have any video where we can test login with multiple users using the blazemeter script? thank you for replying to all the queries your videos are helpful!

[@RaghavPal]

Hi Himanshu, I have shown how to record a jmx script using blazemeter chrome extension here - kzbin.info/www/bejne/sJ-UdYaLj5unbJY As of yet, I do not have a video to show multiple user working with blazemeter tool

[@himanshudx24]

Hi Raghav thanks for your prompt reply I have followed that video and it works for me but I was thinking if I could test for 10-15 different users how can I do that with blazemeter script

[@RaghavPal]

I will plan a session on this

[@vinay24c]

Hi Sir, Thanks for your videos. I want to substitute (example 10 unique data) in my single request like each occurrence in LoadRunner, is there any way to achieve the same in JMeter, please assist it.

[@RaghavPal]

Vinay Yes, there are a few ways to substitute different data in a single request in JMeter. One way is to use the *CSV Data Set Config* element. This element allows you to specify a CSV file that contains the data that you want to substitute. The CSV file should have one row for each data point, and the columns in the file should match the names of the variables in your request. To use the *CSV Data Set Config* element, you need to add it to your test plan and then configure it with the path to the CSV file. You can also specify the delimiter that is used in the CSV file, and the number of rows that you want to read. Here is an example of how to use the *CSV Data Set Config* element: ``` ``` In this example, the CSV file is called `data.csv` and the delimiter is a comma. The `numberOfLines` attribute is set to 10, which means that the element will read the first 10 rows of the file. The data in the CSV file will be substituted into the variables in your request. For example, if your request has a variable called `username`, the value of the `username` variable will be replaced with the first value in the first row of the CSV file. Another way to substitute different data in a single request is to use the **BeanShell PostProcessor** element. This element allows you to execute a BeanShell script before or after a request is executed. The BeanShell script can be used to read data from a file, generate random data, or perform other operations. The data that is generated by the BeanShell script can then be substituted into the variables in your request. Here is an example of how to use the *BeanShell PostProcessor* element: In this example, the BeanShell script is stored in the `script` attribute. The `script` attribute can contain any valid BeanShell code. The BeanShell script can be used to read data from a file, generate random data, or perform other operations. The data that is generated by the BeanShell script can then be substituted into the variables in your request. I hope this helps

[@vedikasharma4258]

Hi Raghav , its not reading my csv file , instead of value taking the variables. Please help for the issue.

[@RaghavPal]

If you are giving headers in your csv file, then don't provide variables name in csv data set config element. It will directly be taken from csv file. If you provide the variables, then the first row will also be considered as values.

[@YSmedvednikova]

It is possible to set variable "http request" type by csv-file? For example GET, PUT, UPDATE and so on

[@RaghavPal]

When using JMeter with a CSV Data Set Config, you can indeed set the HTTP request type dynamically based on values from your CSV file. Let's explore how you can achieve this: 1. CSV Data Set Config: - The CSV Data Set Config element in JMeter allows you to read lines from a CSV file and split them into variables. - By default, it assumes that the CSV file is comma-separated (CSV), but you can customize the delimiter. 2. Scenario: - Suppose you have a CSV file with columns like `RequestType`, `Endpoint`, and other relevant data. - You want to dynamically set the HTTP request type (GET, PUT, etc.) based on the `RequestType` column from the CSV. 3. Steps: - Here's how you can achieve this: 1. Create Your CSV File: - Your CSV file should include columns like `RequestType`, `Endpoint`, and any other relevant data. - Example: ``` RequestType,Endpoint GET,/api/resource1 PUT,/api/resource2 POST,/api/resource3 ``` 2. Configure CSV Data Set Config: - Add a CSV Data Set Config element to your JMeter test plan. - Specify the path to your CSV file. - Set the delimiter to match your CSV file (e.g., semicolon `;` in your case). 3. Use Variables in HTTP Request: - In your HTTP Request sampler, use variables for the request type and endpoint. - Example: - Set the HTTP Method field to `${RequestType}`. - Set the Path field to `${Endpoint}`. 4. Run Your Test: - JMeter will read the values from the CSV file line by line. - For each iteration, it will set the `RequestType` and `Endpoint` variables accordingly. - Your HTTP requests will use these dynamically set values. 4. Example: - Suppose your CSV file contains the following lines: ``` RequestType,Endpoint GET,/api/resource1 PUT,/api/resource2 POST,/api/resource3 ``` - During execution, JMeter will use the values from the CSV to make requests like: - GET: `/api/resource1` - PUT: `/api/resource2` - POST: `/api/resource3` Remember to adjust the column names and structure according to your specific use case. With this approach, you can dynamically set the HTTP request type based on values from your CSV file.

[@kirankumarsuri9195]

Thanks Raghav for educating us with your excellent videos.........I tried the above video in jmeter5.1 same like you but I have getting issues particularly the city name is not taken from the csv file. I checked in Google the reason for that.In "CSV Data Set Config" section if I don't give anything at Variable Names(comma-delimited) I have been getting this issue if I give the column names for which I want to pass the parameters this issue is not coming. I watched your current video many times even then also the issue didn't solve until I give column names for which I want to pass the parameters. Can you please help to understand it version specific issue or anything else as I see most of the features in your videos not available in 5.1.......please clarify

[@RaghavPal]

Hi Kiran, hope you have not missed any steps. I have not yet checked with ver 5.1. You can try with an older version to ensure if its version issue

[@ullaschandrakar8557]

Raghav,Could you please make a session on how to do Parameterisation for Web application testing for example like i need to perform load with different user

[@RaghavPal]

Hi Ullas, i will make it but can take some time

[@ullaschandrakar8557]

hi Raghav,not an issue I have done this not an issue

[@dishantsharma6122]

Hi, Raghav Hope you doing well !! I have a query can you please tell that how can I add or fetch users to my API call from an excel file.

[@RaghavPal]

Hi Dishant, try to use excel in the same way we have used csv. Also see some online examples stackoverflow.com/questions/48987834/reading-content-from-excel-using-jmeter

[@noormohammad5740]

Thanks a ton brother .... God bless you

[@RaghavPal]

Thanks for the wishes Noor

[@saichandrapokala8627]

Hi Raghav, My json body has around 50 input fields. Each time I only have to change one filed. So as per the video should I create parameters for all my input fileds.

[@RaghavPal]

Hi Saichandra, I may have not got your scenario completely, but its as per your need. Whatever value you want to get from csv you can do that and if you want to hardcode some values that is okay, you can give it directly in your test.

[@neelimapatnaik4327]

Hi Raghav, but how to configure parameter present in csv , while running scripts in jenkin

[@RaghavPal]

Hi Neelima, you can create a parameterized job in jenkins

[@deepanparikh9547]

Hi Raghav, thanks for the tutorials. How can I capture parameters dynamically on Jmeter? do you have any video on it? Thanks.

[@RaghavPal]

Hi Deepan, what exactly is meant by capture parameters dynamically. You can check all JMeter videos here - automationstepbystep.com/online-courses/

[@sanketnegi1]

Great learning.. But I have a doubt.. I want to execute each iteration with a different column value.. in while controller.. can you tell how can I do it?

[@RaghavPal]

Hi Sanket, I will need some details, Let's say in your csv file you have a column "username" and in your requests you have a variable called "username" Now when you parameterize using csv, on execution, it will take values from username column. and will take the next row in each iteration, So you can add the values you need in the new rows. Now what exactly from here do you need

[@sanketnegi1]

@@RaghavPal So I have columns username1 username2 and username3 Now in while controller (which will run thrice) I want to use username1 in the first loop, Username2 in second loop and username3 in the third loop. Also I just noticed while controller runs just once every thread. So if we use loop 10 with thread 1 it will just go inside while controller only once.

[@RaghavPal]

I believe username1, 2 and 3 are all used in the same place in request, if that is true, you can keep a single column and add all the values in sequence

[@nareshpallapothula6389]

Thanks for the sessions Raghav, I have a question like - If we have multiple thread groups in a Plan, Can we pass data from csv file as one row to one thread group and next row to another thread group and so on? Can we do that ?

[@RaghavPal]

Hi Naresh, thanks for watching, just is if you need something similar to what is explained in this post - www.blazemeter.com/blog/csv-data-set-config-in-sharing-mode-made-easy

[@keerthirajkitty2860]

Hi Raghav Pal, thank you for this informative videos. These videos shows how to test web pages. Can you please share how to test Mobile applications using Jmeter.

[@RaghavPal]

You're welcome Keerthiraj. Pls check here - kzbin.info/aero/PLhW3qG5bs-L_Eosy1Nj1tKHC5jcBAVkPb Other courses - automationstepbystep.com/909-2/online-courses/

[@camilohenaobravo1766]

Usted me ayuda en todo lo que necesito saber !!!!!

[@RaghavPal]

Muy bienvenido Camilo

[@camilohenaobravo1766]

Graciasss mil gracias amigo, se que me ayudaras mucho para el proyecto de grado!!@@RaghavPal

[@RaghavPal]

Muy bienvenido

[@sudhakarr825]

Thanks for your Videos Pal, I have beginner learning Jmeter watching your videos. can you please explain how to select CSV data to take sequentially when we are running for Multiple user test

[@RaghavPal]

Hi Sudhakar, you can use critical section controller. Pls check is this what you need - stackoverflow.com/questions/51298120/i-want-to-fetch-the-data-from-csv-in-sequential-order-in-jmeter-what-should-be-d

[@PrincetonKurtz-zn9qv]

Hi Raghav ,Suppose for multi user load test I want to login with different usernames & passwords from CSV file then what values should be under "Variable names " box ? I should left it blank ?

[@RaghavPal]

Hi Princeton In JMeter, when you want to use different usernames and passwords from a CSV file for a multi-user load test, you need to specify the variable names that correspond to the columns in the CSV file. Here's what you should do: 1. Create a CSV file with columns for usernames and passwords, for example: ``` username,password user1,password1 user2,password2 user3,password3 ``` 2. Add a CSV Data Set Config element to your Test Plan in JMeter. 3. In the CSV Data Set Config element, set the "Filename" field to the path of your CSV file. 4. In the "Variable Names" field, you should enter the names of the variables that correspond to the columns in your CSV file. For example, if your CSV file has columns named "username" and "password", you should enter `username,password` in the "Variable Names" field. Make sure the names match exactly (case-sensitive). 5. In your HTTP Request, use the variable names in the format `${variable_name}` to refer to the values from the CSV file. For example, if you want to use the username and password values from the CSV file, you can use `${username}` and `${password}` in the appropriate fields of the HTTP Request. By setting the correct variable names in the "Variable Names" field, JMeter will automatically read the values from the CSV file and assign them to the corresponding variables during the load test. Each thread/user will then use a different set of credentials from the CSV file.

[@AmongManyWays]

hey raghav, first of all excellent tutorial on jmeter. I had a query. i need to test an rest api which creates an element in db taking 5 parameters . In return it throws the id of resource created. Similarly i have to test equivalent delete api which just takes the id. How to go about it using jmeter ? Do i have to manually enter values in csv ? How would u do it ?

[@RaghavPal]

Hi, you can use correlation to pass values from one request to another. Watch - kzbin.info/www/bejne/bV6xlKyQqrqEpNk

[@ameni630]

Thanks a lot :) Could you help me please: I work with the SOAP web service: How to manage a csv file with 3 columns and each column represents a variable in a SOAP request?

[@RaghavPal]

Hi Ameni, you can create the variables as per the column headers and then follow the same process. it should work

[@rajukp1]

Hi Raghav, You are a great tutor. Thanks for your help. I request you to please add the notes that you prepared while teaching us if you have it. Sorry if I am bothering you

[@RaghavPal]

Hi Kalyan, I am glad it helped. Untill now i have been writing the steps down on a notepad as shown in the videos and i also copy the same in the description of the video. Will try to add more description for everyone's help. Keep Learning.

[@gavinjames9476]

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

[@RaghavPal]

HI Gavin, the process should remain same, can check this stackoverflow.com/questions/50933586/jmeter-read-data-numbers-from-csv-file-in-jmeter

[@motochronicles4816]

Dear Raghav,If u r reading it.....can u please dedicate some time to modify this video and show this feature on a webservice test using HTTP request now that SOAP request desnt exist in Jmter. I am running into lot of issues in my current project. Appreciate your help on this.

[@RaghavPal]

Hi, I will do, I will plan to update the required videos

[@rafishaik9336]

hi Raghav, This session is grate and your presentation is good... but i have a small doubt ,I have to register In account ex:FB then i want to pass all parameters from csv file .It is possible As like above video.

[@RaghavPal]

Hi Rafi, yes you can parametrise any test.

[@janardhanrajagopal6064]

Thank you raghav!!! Your videos are really helpful. I tried the same and it is reading 2nd row first, followed by 3rd row and then reading the data from 1st row. could you please let me know the reason for this.

[@RaghavPal]

Hi Janardhan, can you check if you are selecting all correct values in csv data set config

[@janardhanrajagopal6064]

I selected recycle eof as true. if I select that value as false and if file has 1 row of data, my request is failing and it shows request as Eof

[@janardhanrajagopal6064]

I selected recycle eof as true. if I select that value as false and if file has 1 row of data, my request is failing and it shows request as Eof

[@RaghavPal]

Does your csv file has headers? Also check if you get any information in the logs.

[@nurilha]

what if I want to simulate 2 users? i want first row to simulate user 1 and 2nd row of csv to simulate user 2. At the moment you have 1 user doing both requests.

[@RaghavPal]

Hi Nuril, this should help you - dzone.com/articles/how-to-pick-different-csv-files-at-jmeter-runtime

[@milakhan8734]

Hi raghav, this series is by far the most clearest video series for a Jmeter beginner. One question, is it possible to configure each concurrent user(thread) is using different data from the csv file? Eg each user has unique login id and password for a login action?

[@RaghavPal]

Hi Jameela, Pls see if this is what you need - www.blazemeter.com/blog/csv-data-set-config-in-sharing-mode-made-easy/

[@tatsianamiatliuk7404]

Thanks a lot! Raglav, your video helped me to solve my issue by using this config element )

[@RaghavPal]

Glad to know this Tatsiana

[@jonb3769]

Thank you Raghav, good tutorial...you have personal classes?

[@RaghavPal]

Hi JD, thanks for watching. Yes, I give classes morning 6 to 7 IST. You can connect on [e-mail]

[@MrKris2009]

Hi Raghav, I have question. I am using csv config where I want to pass a variable name in the Filename. So, I have created a user define variable as filename = ${__P(filename, default_filename)}. But it is not recognized in CSV_config when used as ${filenamr}. I tried __P and __property also

[@RaghavPal]

Hi, Pls check the spelling ${filenamr}

[@shivanandn7290]

Hi Raghav, Very helpful videos. I am using JMeter 3.0 and testing with sampler SOAP/XML-RPC Request, I am trying pass parameter from Csv file as ${XYZ}, but it’s reading it as ${XYZ} instead of value. Please advise.

[@RaghavPal]

Hi Shiva, in case you have given headers in your csv file, do not give any values in the Vairables Name field of CSV Data Set Config

[@09yuvrajsinh]

Thank you Raghav. All of your tutorials are really informative and helpful. I have one request. Can you also come up with Selenium Web Driver 3.0 tutorials?

[@RaghavPal]

Yuvraj i am glad you found it helpful. I will soon be starting a series on Selenium and will cover Se web driver 3.0 also.

[@seliniumjava7477]

Automation Step-by-Step - Raghav Pal x

[@RaghavPal]

Please watch this - Selenium Beginner - kzbin.info/aero/PLhW3qG5bs-L_s9HdC5zNshE5Ti8jABwlU

[@RamandeepKaur-pl9kr]

Hi Raghav, what is the concept of data pool. if i need to run my login-logout script for more than one user, then where all places i need to replace user ID and password with variables. and what should be th search criteria for that. I started to learn Jmeter few days back. started with your tutorials. These videos are really helpful. But i'm running through issues when i'm trying to work on actual scripts. Thanks!

[@RaghavPal]

Hi Ramandeep, you can parametrise your data in csv file and then in your HTTP Sampler request you have section for Parameters, Here you can replace with the variable names.

[@SameeraSenarathna]

Nicely Explained. Keep up the great work.

[@RaghavPal]

Thanks Sameera

[@EvergreenWonders]

Excellent session. loved it. Sir, can we have a session on how to write to CSV file using Jmeter, please.

[@RaghavPal]

Hi Vikas, thanks for the message. Usually we can export results in csv, Is there any specific use case for your example

[@guraband]

Very useful video. Thank you!

[@RaghavPal]

You're welcome

[@binaacharya5886]

Raghav, can you please import the excel file and convert it into json format and store the json result in one of the variable so that it can be used in next process as well

[@RaghavPal]

Hi Bina, this can be done, but will need some custom coding

[@binaacharya5886]

@@RaghavPal can you please post a video on this

[@RaghavPal]

I will plan but can take some time

[@binaacharya5886]

@@RaghavPal any update about this problem?

[@ralucastreja]

Hello Raghav, I am interested to know how I can parametrise variable information (not static one, like the one in a csv file). I managed to connect to the DB using a JDBC connection configuration, but how can I use the variable that stores the constantly changing IDs from the database?

[@RaghavPal]

Hi Raluca, in the JMeter playlist there are videos for JDBC and variables handling. Please check if you are able to get help from that. kzbin.info/aero/PLhW3qG5bs-L-zox1h3eIL7CZh5zJmci4c

[@Naturelover-ny3vj]

Hi If i want run only one iteration and with 3rd row testdata then how can i do that?

[@RaghavPal]

Hi To run only one iteration and with 3rd row test data in JMeter, you can do the following: 1. **Open the JMeter test plan.** 2. **In the `Test Plan` element, right-click and select `Add` > `Sampler`.** 3. **From the list of samplers, select `HTTP Request`.** 4. **In the `HTTP Request` dialog, enter the URL of the web page that you want to test.** 5. **In the `Test Data` tab, select the `3rd row` from the `Data Set` list.** 6. **In the `Iterations` field, enter `1`.** 7. **Click `Save`.** Once you have made these changes, JMeter will only run the HTTP Request sampler once, and it will use the data from the 3rd row of the test data set. Here is an example of how to do this in JMeter: ``` HTTPSamplerProxy sample1 = new HTTPSamplerProxy(); sample1.setUrl("www.example.com/"); sample1.setMethod("GET"); sample1.setTestData("3rd row"); sample1.setIterations(1); ``` Once you have added this code to your JMeter test plan, you can run the test by clicking on the `Run` button. The test will only run once, and it will use the data from the 3rd row of the test data set. I hope this helps

[@raghava007jakka]

hi raghav .. how can i check a senario where can i download Files in load testing can u please help in this regard with example

[@RaghavPal]

hi Raghav, i will try to upload a video with example soon on this.

[@RaghavPal]

HI Raghav , here is your video - How to test File Download - kzbin.info/www/bejne/iqvUlWSuiLWWadU

[@amoujahid]

Great tutorial. Thx a lot

[@RaghavPal]

You're welcome Abdallah

[@pradyumnavaradpande3688]

Hi Raghav, Really great videos! Thank you so much for sharing! I would like to know, how can we insert response assertions to check our results. In this video, we have used 2 loop so we will get two different results. 1. now if I want to use response assertion 1 for first value which is coming from csv. 2. And response assertion 2 for second row value from csv. How to do this? Could you please help me ?

[@RaghavPal]

Hi Pradyumna, Can you not add the assertions in diff columns of same row. It will be easier that way

[@pradyumnavaradpande3688]

​@@RaghavPal Hi Thanks for your prompt response. As per your suggestion, I should add variable in my request then same variables should mention in (Jmeter variable Name to use) field in response assertion. am I right? but what I want to achieve is that, there are total 5 rows in csv for first 3 values when executed in database it should get updated and I get the status as updated but for last 2 values I should get error code

[@RaghavPal]

Hi Pradyumna, I may get more information about your scenario if I take a deeper look. But for general, The way parameterization works is you create variables and refer the variables from an external location. If the variables is provided multiple values, the test runs multiple times with each row or set of data, Now this is the standard way. You can write scripts to do this in a diff way as required.

[@pradyumnavaradpande3688]

​@@RaghavPal Thank you so much Raghav! Now I am able to validate it by adding Beanshell Assertion but while exporting results and I still believe that I am not using the jmeter options properly. can you please help me? Please let me know if you need any further information, I will share with you

[@RaghavPal]

Happy to know that Pradyumna. I will suggest that you first check the required information online As I might not get enough time to go deeper into the setup

[@akado5663]

Thank you, Raghav. All of your tutorials, as usual, are really informative and helpful and great. I have an issue in Jmeter 3.3 when I add Add config element - CSV Data Set Config to thread Group then the test plan is not running (nothing to see in the tree) . When I remove the CSV Data Set Config element than by run of the test plan is again the response to see in the tree. is it a new BUg in Jmeter 3.3.? do you know something regarding this.

[@RaghavPal]

Hi, can you check the logs. There might be some issue.

[@akado5663]

Thanks Raghav, it was an issue with excel. instead of comma I changed it to the semicolon and was working fine

[@BhushanPatil-pf4kn]

Reghav, Can we use Selenium script for Jmeter to perform Load testing ??

[@RaghavPal]

hi Bhushan, the answer is yes. In fact there is a webdriver plugin for JMeter. Can check that.

[@shriprasadgujare8639]

what if we want particular field from list of data in CSV?

[@RaghavPal]

Hi Shriprasad, as far as I know, JMeter does not provide any in-built feature for this, you may have to add some scripts, Check this - sqa.stackexchange.com/questions/23360/how-to-read-a-particular-row-cell-data-of-csv-into-a-variable-in-jmeter

[@saikatdebnath4515]

Hi Raghav , i was using special characters to read data from CSV file which i used to Login to account. And it looks like special characters are not taking (example- @ and #). any idea why ? Thanks in advance

[@RaghavPal]

Hi Saikat, you can change the encoding, Check blog.e-zest.com/how-to-read-special-characters-from-csv-in-jmeter

[@newbienewbie4994]

Hi, Thanks for the tutorial. Quick question- if I want to run this from an EC2 instance then the file needs to be hosted on that box? is there a way for us to specify to get the file from an S3 bucket? Thanks!!

[@RaghavPal]

Hi, yes you can do that, You will need to add a script for that. stackoverflow.com/questions/45084164/s3-access-in-a-jmeter-script You can also use jenkins and then can get the file from s3 or any source code repository before starting JMeter test

[@Sasshi33]

Hi Raghav bro, I need a help from your side. Created CSV data set config for login modules only. in CSV file mentioned two users. It's logged in successfully displayed in jmeter but in the data base entries are not inserted into user log table. Without using CSV the values are inserted into corresponding table while running in jmeter.

[@RaghavPal]

Hi Sasshi Kumar, that ideally should not be the case, But I found something similar here stackoverflow.com/questions/33133263/jmeter-csv-data-parameterize-in-script-but-not-updated-in-system-database

[@Sasshi33]

@@RaghavPal thank you so much ..... Brother....

[@djvh2]

Just as a heads up, the video does not show Raghav use the variable for appid when he modifies REST-RPC-Request. He uses the city variable but leaves appid hard coded. I'm sure he meant to change both.

[@sumit0352]

Hi Raghav, Thanks for the video. Could you please prepare a video on how to do performance testing with 50 different concurrent users using csv? This should include end to end flow of the app.

[@RaghavPal]

I will plan Sumit

[@arjunmh1132]

login page any JMeter video is there. FOR check multiple user

[@RaghavPal]

Hi Arjun, you can find all here - automationstepbystep.com/

[@shankarlingam4702]

Bro excellent tutorials bro we expect more tutorials on selenium webdriver, jira....

[@RaghavPal]

will add more videos soon

[@mayanksoni9994]

it was a helpful session. And I would like to know, how can i pass input payload from csv for post method.

[@RaghavPal]

Hi Mayank, the process will be the same. You can goto your message body or parameters and parameterize using variables and refer from csv

[@swarnendubhattacharjee2201]

Hi Raghav.. 1.how can we randomise the parameters added in the CSV ? Say if I have 10 credential values in param list and I want random of that to be chosen in each run? 2. If I add parameters in the path of a request,it's failing with Illegal character in path at index ...path/${Param} at java.net.URI$Parser.fail(Unknown Source)

[@RaghavPal]

Hi Swarnendu, this can help stackoverflow.com/questions/18479960/random-selection-from-csv-file-in-jmeter

[@HareshPatel-92]

Hello Raghav, I am looking for your help on JWT token. How do Generate JWT token using Jmeter? I have used JWT Pre-Processor and it did not help me. Thank you in advance for your help

[@RaghavPal]

Haresh Before we dive into generating a JWT token, can you please provide more information about the token you need to generate? Specifically: * What is the algorithm used for signing the token (e.g., HS256, RS256)? * What are the claims or payload elements required in the token (e.g., username, email, expiration time)? * Do you have any specific headers or custom fields that need to be included in the token? Choose the Right Approach Since you've already tried the JWT Pre-Processor, we can explore alternative approaches. We can use either: * A Beanshell Pre-Processor * A JSR223 Pre-Processor (with Groovy or JavaScript) Both of these options allow us to write custom code to generate the JWT token. Step 1: Write the JWT Token Generation Code Let's use a Beanshell Pre-Processor as an example. We'll use the `java-jwt` library to generate the token. Add a Beanshell Pre-Processor to your JMeter test plan and paste the following code: ```java import io.jsonwebtoken.Jwts; import io.jsonwebtoken.SignatureAlgorithm; // Set your secret key (replace with your own) String secretKey = "your_secret_key_here"; // Set the payload claims (replace with your own) String username = "johnDoe"; String email = "[e-mail]"; long expirationTime = 3600000; // 1 hour // Create the JWT token String token = Jwts.builder() .setSubject(username) .claim("email", email) .setExpiration(new Date(System.currentTimeMillis() + expirationTime)) .signWith(SignatureAlgorithm.HS256, secretKey) .compact(); // Store the token in a variable vars.put("jwtToken", token); ``` This code generates a JWT token with the specified claims and signs it with the provided secret key using the HS256 algorithm. Step 2: Use the Generated Token in Your Request Now that we have generated the JWT token, we need to include it in our request. You can do this by adding a `Header Manager` to your request and setting the `Authorization` header to `Bearer ${jwtToken}`. That's it! Run your JMeter test, and the JWT token should be generated and included in your request. -

[@HareshPatel-92]

@@RaghavPal using HS256

[@HareshPatel-92]

Also, I have signature string and Header: { "alg": "HS256", "typ": "JWT" } and 7 values in payload e.g.: { "string_1": "Value_One", "String_2": "Value_Two", ----- :String_7": "Value_Seven" }

[@RaghavPal]

ok

[@sharadsinha3835]

Hi Raghav ,I have to implement j meter in my project i.e. chat bot application how could I implement could you please help me out?

[@RaghavPal]

Hi Sharad, not much exp with Chatbox. Pls try online help stackoverflow.com/questions/56426571/how-to-measure-performance-testing-for-chat-bots-using-jmeter-or-any-tool www.blazemeter.com/blog/5-ways-to-load-test-popular-chat-plugins-with-jmeter/

[@jaybeebuenaflor7394]

Hello sir thank you for the tutorial. I have a similar question I found on stackoverflow I am a JMeter new user. I have the following scenario - To search for a Name in search text box. Parameterized the Name in CSV. But while searching instead of entire name being passed as parameter i.e. ${Name}, I need to pass each character of ${Name} to individual HTTP Request, say for request 1, parameter is N, Request 2 - Parameter a and so on and the search result is displayed for the last request when N, a, m, e have all been passed. How do i handle this using Jmeter? Hope you can help me on this. Thank you so much!

[@RaghavPal]

Hi Jaybee, you will either need to provide data from CSV in the same way as you need or use some scripting sampler to fragment the text and give as parameter

[@jaybeebuenaflor7394]

@@RaghavPal thank you for the response, sir. May I ask if you have a tutorial on scripting sampler?

[@RaghavPal]

Not yet, I will plan to add

[@sayalimohadikar6685]

is there a way to read external JSON file from Jmeter and then use its values?

[@RaghavPal]

Hi Sayali, replied to your other comment. I believe you will need to add some scripting for that. I have not tried, can get some help here - stackoverflow.com/questions/30589715/how-to-read-external-json-file-from-jmeter

[@harishsaraf3621]

Thanks Raghav, Can you tell me how to configure to send unique data everytime for a single csv file used by more than 2 users

[@RaghavPal]

Hi Hari, in case of excel we can have formula added in cells that will do the job. For csv I think you can use FUNCTIONS like RANDOM FUNCTION

[@faizfarook7754]

Thanks bro for the video. I have one issue with this. For me the jmeter has taken only the first row of csv file, though I have given multiple iteration.Could you please help me?

[@RaghavPal]

Hi Faiz, that should not be the case. Pls re-check if you have missed any steps.

[@faizfarook7754]

@@RaghavPal iam using jmeter 5.1.1. is there any thing else to do in this version?

[@RaghavPal]

I believe not, although I will check.

[@faizfarook7754]

@@RaghavPal thank you so much bro.

[@lilyphan8686]

Raghav, thank you so much for not only sharing your knowledge but being a good teacher! I have never done any load test before and my application is pretty much similar to gmail in the sense that I need to login, do some search, send some emails, upload/download some files. My task is to see how the app behaves with some 7000 concurrent users (given that certain percentage of users would take certain actions as listed above.)My question is: Do I need to use parameterization for the 6000 users here? Or simply raise the number of threads to 7000 would be enough to say it's a load test? If parameterization is needed, I guess I have to create 7000 users first in the database BEFORE even create a test plan in JMeter? Could you please give me some guidance !! Thanks a bunch!!

[@RaghavPal]

hi Lily, i am glad that you are learning from this channel. If your aim is just to load test the application you can go with same user and increase number of threads. Some tips: Always use a stable client for this test. Preferably a remote(cloud) machine. This will not compromise your network during the test + you can compare your future runs on the same configuration. Always note down client and server configuration.

[@marzioforte9364]

Nice presentation!

[@amrutakulkarni9281]

i want to set key for api load testing ...i am anable to take key in parameter and value in body please can you help me.

[@RaghavPal]

Hi Amruta, I did not completely get you, Is the key part of body, or headers. You can check JMeter header manager or authorization manager components

[@rahulsingh848]

Hello Raghav. Thank you so much for this nice tutorial. I have one doubt. We have 3 http request in a thread group and we are using same .CSV file for all the request. We have 3 rows in the csv file and we want to pick different row for different requests. Can we do that ?

[@RaghavPal]

Yes you can do that. You can give different column headers in your csv and refer the same in your jmeter.

[@manasranjan3854]

Thankyou Raghav, all your videos are really helpful.I came across an scenarion to read data from csv file using csv data set config but in the csv file values are written in double quotes like 3,290,"15,000" . I am able to get value from csv file for 3 and 290 but got stuck for "15,000" ?I need your help.I am writing xpath assertion for xml request like ()for eg..//program/@programid='{$programid}) but facing issue for the data point "15,000"

[@RaghavPal]

Hi Manas, this should help you - stackoverflow.com/questions/40271781/jmeter-wont-read-list-of-quoted-csvs-from-a-csv-file

[@manasranjan3854]

Thanks , it worked for me . I just tweak set Allow quoted data to true in CSV data set config

[@RaghavPal]

Great to know this Manas

[@surajjibhakate9198]

can we have a video where more than 1 csv files can be used in a single thread group?

[@RaghavPal]

I will check on this Suraj

[@puneettomer875]

Raghav can you please tell me ? How can I take 1st row only for all iteration??

[@RaghavPal]

Hi Puneet, in CSV data file config sampler, there are fields like: Recycle on EOF Sharing mode This should help you Can also check this :stackoverflow.com/questions/13470441/use-same-row-per-thread-from-a-csv-data-set-in-jmeter