how to write data to csv in jmeter using beanshell scripting

Question

I am new to jmeter,and in my company we are doing webservices testing using jmeter.My requirement is i am using csv data config file for web services testing and here i want to update each row of csv file with test results and i am using beanshell postprocessor,please help

Ex: csv contains:

Test Case,Dates,Numbers,Results
Total test cases are 16 and i want to update as below for each test case
TC_001,9-03-2016,001,PASS
TC_002,9-03-2016,0002,FAIL

and so one...

Result = "FAIL";
Response = prev.Get....();
If(Response.Contains("Valid"));
Results="PASS";
f = new FileOutputStream("/tmp/oders.csv", true);
p = new PrintStream(f); 
this.interpreter.setOut(p); 
print(Results + "," + Result);
f.close();
P.Close();

Raj Kumar Das · Accepted Answer · 2019-11-20 18:01:07Z

3

import java.io.File;
import org.apache.jmeter.services.FileServer;  //jmeter spelling corrected
import java.io.FileWriter;
import java.io.PrintWriter;
import java.util.Arrays;
import java.io.Writer;

File file = new File("csvFilePath");
FileWriter fstream = new FileWriter(file, true);
// true, will append the file if already exist

BufferedWriter out = new BufferedWriter(fstream);
out.write("Save your data which you want to save");
out.write("Save your data which you want to save");

out.close();
fstream.close();

edited Nov 20, 2019 at 18:01

Raj Kumar Das

53 bronze badges

answered Feb 16, 2018 at 10:37

Ankit Gupta

7865 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitri T · Accepted Answer · 2016-03-09 05:52:29Z

2

It might not be the best idea as:

You may have problems with re-using this file
You may run into a situation when 2 or more threads will be concurrently writing to the file and it will result in data loss, file corruption or IO Exception

I would recommend adding your "Test Case", "Dates" and "Numbers" variables to JMeter's .jtl results file instead using Sample Variables property like:

Given you have 3 variables: TestCase, Date and Number
Add the following line to user.properties file (it is located under /bin folder of your JMeter installation)
```
sample_variables=TestCase,Date,Number
```
On next JMeter restart you will see "TestCase", "Date" and "Number" variable values appended to .jtl results file.

It is also possible to pass the setting as a command-line parameter like:

jmeter -Jsample_variables=TestCase,Date,Number -n -t /path/to/testplan.jmx -l /path/to/results.jtl

References:

answered Mar 9, 2016 at 5:52

Dmitri T

169k5 gold badges91 silver badges149 bronze badges

1 Comment

Rajesh Qa Over a year ago

Hi,Thank you for your reply but if i declare directly in user.properties then it is useful for this scenario but if i want to do another soap request then parameters will change so every time for every web services adding in user.properties means how can i ?

Nagaraju Dorasala Subbaraidu · Accepted Answer · 2017-03-27 03:10:07Z

0

I would like to share my experience using BeanShell PostProcessor to write variables to a file.

I captured few responses from the server using "Regular Expression Extractor" and saved it to few variables Var1 & Var2 and when I wrote these variables to a file using "BeanShell PostProcessor", I have observed that it works fine when we run a test with single thread but with multi thread test, the data was being lost.

Say When I inject 100 transactions, I was able to see only 97 records in the output file.

So the best option is to set sample_variables in user.properties file so that you can get the variables out in your .jtl results file.

answered Mar 27, 2017 at 3:10

Nagaraju Dorasala Subbaraidu

1

Collectives™ on Stack Overflow

how to write data to csv in jmeter using beanshell scripting

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related