How to read multiple csv files dynamically with jmeter

Question

I'm trying to read multiple csv files from a specific folder using Jmeter

Until now I read one csv file and I could loop it with a thread that runned X times when X- is the number of lines in the file. I was counting the number of lines in the csv file before the thread with a bean_shell like that:

    import org.apache.jmeter.services.FileServer;
String DirPath = FileServer.getFileServer().getBaseDir();
FileReader fileReader = new FileReader(new File(DirPath + "/files/App1.csv"));
LineNumberReader lineReader = new LineNumberReader(fileReader);
int linenumber = 0;
while (lineReader.readLine() != null){
linenumber++;
}
props.put("rowsnumberApp", Integer.toString(linenumber));

Now, I want to read multiple files from a folder, when the amount of files in the folder can dynamically change,

The files names will be like that:

app1

app2

app3

app...

I have this code to read all files from the folder:

import org.apache.jmeter.services.FileServer;
String DirPath = FileServer.getFileServer().getBaseDir();
File folder = new File(DirPath + "/files");
File[] files = folder.listFiles();
int counter = 1;
for (File file : files) {
    vars.put("file_" + counter, file.getAbsolutePath());
    counter++;
}

Each file has different amount of lines (but at least I have the same soap-request for all of them)

I realized that using a loop controller on csv gives only the first line.

And as you can see I already have the code part for reading files from a folder and counting the number of lines,

I just need a way to connect all of this to be able to loop for all csv files in the folder

so any idea?

user7294900 user7294900 · Accepted Answer · 2017-08-03T08:46:56

Using 2 Loops, first save how many files by:

vars.put("fileLength", files.length);

Create first Loop with ${fileLength} as loop count

Add Counter start with 0 Maximum ${fileLength} Increment 1 Reference Name cnt

Inside loop read as your first beanshell change to use counter

FileReader fileReader = new FileReader(new File(DirPath + "/files/file_" + vars.get("cnt")));

Update your current implementation with the counter:

import org.apache.jmeter.services.FileServer;
String currentFileIndex = vars.get("cnt");
String DirPath = FileServer.getFileServer().getBaseDir();
FileReader fileReader = new FileReader(new File(DirPath + "/files/file_" + currentFileIndex ));
LineNumberReader lineReader = new LineNumberReader(fileReader);
int linenumber = 0;
while (lineReader.readLine() != null){
linenumber++;
}
props.put("rowsnumberApp" + currentFileIndex , Integer.toString(linenumber));

How to read multiple csv files dynamically with jmeter

2 Answers