Questions tagged [csv-file]
Comma-Separated Values or Character-Separated Values (CSV) is a standard "flat file database" format for storing tabular data in plain text, consisting of an optional header row that lists the table fields delimited by commas or tabs or other delimiter character, followed by one or more rows (newline separated) representing the table records as delimited lists of the values. Newlines and separator characters can appear within (quoted) fields.
33
questions
0
votes
0answers
21 views
Source for non-standard CSV formats
I need to test the capabilities of a CSV import utility. I am becoming familiar with RFC 4180 and W3C tabular format, and I plan on testing those. I want to test other valid formats.
Is there a ...
2
votes
1answer
324 views
How to send double quotes in postman csv data file
I have the following request body:
{
username:{{user}},
password:{{pass}}
}
The expected structure of the request is :
{
username:"something",
password:"something"
}
if the request body is ...
1
vote
1answer
166 views
Add extra columns in the existing csv using jmeter
I have a csv file contains around 1000+ rows. I need to add some extra columns in the existing file and also corresponding values of each row of information using jmeter script.Please can someone help ...
0
votes
1answer
2k views
JMETER: Getting timestamp error in log file when giving CSV filename in Summary Report
When I am giving a CSV filename path in Summary Report, I get an error to see log file. I see log file and it shows:
2019-01-30 14:23:38,146 WARN o.a.j.s.CSVSaveService: Unknown column name
2019-01-...
1
vote
1answer
615 views
Selenium/Java reading CSV file using open csv
UserName,Password
User1,Pwd1
User2,Pwd1
User3,Pwd3
Assume there is a csv file with user names and passwords as I've mentioned above. I need to read the csv file and store data in a hash map using ...
1
vote
4answers
259 views
How to compare two files without looking at the contents
The same file was loaded in to two different environments, and I need to compare the outputs (without opening them up)
My only thought is to compare the file size - because if they're both 5726kb ...
0
votes
1answer
373 views
Performance issue - Robot Framework vs Python
I am currently working on the development of a keyword that allows to separate the contents of a text file into 2 parts and create 2 new files containing each of these 2 parts.
The file format is ...
1
vote
2answers
481 views
Compare web content with the CSV File
I want to compare my data in CSV with the web content. The data in CSV file comprises of multiple rows and column. How can I verify that the data inputted on the web is correct comparing it with the ...
4
votes
1answer
424 views
Selenium downloads tmp file instead of CSV file
When I download a CSV file from a blob URL, the downloaded file always has a ".tmp" extension and wrong file name. When downloading the same file manually, the file extension and file name both are ...
1
vote
1answer
559 views
How to use __iterationNum() custom function in JMeter to assign csv file to Http Request
Here I'm assigning CSV file on the basis of loop count so that done by using __iterationNum() JMeter custom function (custom JMeter Function plugin added to JMeter) But this stuff is not working for ...
2
votes
1answer
615 views
How to assign CSV file without using ${__threadNum} in JMeter
I'm facing problem with assigning the CSV file on the basis of loop count, not on the basis of thread count.
For example -> address1.csv, address2.csv......addressn.csv
So it is very easy to do the ...
4
votes
2answers
855 views
Selenium IDE data-driven storing special characters from csv file
I'm using selenium IDE and readCSV command from a CSV file.
Within the file I have Lägg till Värdorder inside a cell. I'm using command storeCellValue and echo the value.
But it looks like this L�gg ...
2
votes
3answers
4k views
JMeter: Write data in CSV file as rows and columns
Can someone please help how to write data in CSV file as rows and columns?
I have below code:
import java.io.FileWriter;
import com.opencsv.CSVWriter;
// I am extracting all vars.get from XPath
...
1
vote
2answers
3k views
Jmeter - Variables from input file to output file
Is there a way to write variables from csv input file to the .csv output file?
i have input.csv with
planID |planNum
---- |----
1 | 123456
Also, I have user defined variable: ...
3
votes
1answer
2k views
JMeter Report Dashboard
Most recent version of JMeter has an option to generate Report Dashboard which is great, but i am struggling to customize it to match my needs.
I am running performance tests for every new version of ...
1
vote
1answer
376 views
JMETER - run next HTTP request after first iteration is finished
I have one HTTP request, .csv file with 50 different inputs, 50 rows in .csv
I would like to start next iteration of HTTP request only after first one is finished.
I could use ramp up period, but i ...
0
votes
2answers
4k views
JMeter Change thread name or label in result file
I am using .csv file to read data input
.csv file header:
ID | Design | Type | forname | secondName
1 | design1 | type1 | displayinResults | displayinResults2
Now, i am using ID, Design and Type as ...
0
votes
1answer
3k views
Jmeter CSV Data Set Config to skip first row
I am trying to run HTTP request using JMeter with parameters inside .csv file and it is working as expected.
As i am using 8 different request, with different inputs, header would be really helpful. ...
2
votes
2answers
10k views
How to upload a csv file from local machine using robot framework script?
Is there any option in robot framework to upload a csv file ( or any kind of file ) from local machine ?
Here is my testing scenario -
While clicking on 'Upload file' button a new window will pop ...
3
votes
2answers
3k views
JMeter looping through CSV
I have two CSV files which I need to use in a loop. I am using jp@gc - Variables from CSV file. The contents are:
File #1
File successfuly parsed, 10 variables found:
${1} = e79d29ec-f356-4682-b601-...
2
votes
3answers
10k views
Can I copy data from a CSV file and use it in a website using only Selenium IDE
Right now I'm running selenium test script in which I have get data from a CSV file and paste in a site.So can I copy data from a CSV file and paste in a test script in Selenium IDE.
It would be of ...
5
votes
4answers
8k views
Issue with Reading CSV file when doing Distributed testing in Jmeter
I have a satisfactory test plan, that I have been using to test with from single load generation server to our application server which reads data from a CSV file. I have been been asked to setup and ...
4
votes
3answers
5k views
Automating file comparison (different formats like csv, text etc)
I am trying to automate the file comparison which are available in different formats.
Is there any tool which can be helpful for this scenario?
1
vote
6answers
1k views
Are there any tools to test whether the response code is not equal to 404 or etc by reading the URLs from a CSV file
I want to check the status code of a URL by reading the URL from a CSV file and "hitting it" with a browser.
How can I achieve this functionality? Are there any tools for that?
2
votes
2answers
840 views
How can I validate CSV exports from my application?
My application has a daily task which exports certain activities to CSV files. In the ideal world, admins would check those files daily to make sure they are sane and the application is behaving as ...
2
votes
4answers
2k views
Data Testing for Massive CSV/XML files
Some background:
I am automating for continuous deployment a massive amount of massive files that are in different data structures that gather different data. I know this is vague but sadly, that is ...
2
votes
2answers
6k views
CSVs and JMeter: using variables from a line in multiple samplers
I'm trying to create a test with JMeter to log in many users and test a website. Each user has a username, a password, and a special id number. The associated id number needs to go into the URL for ...
1
vote
2answers
6k views
Problems with reading from CSV in while condition in JMeter
With different users I need to log to the same page and with every user I need to send same requests which contain some numbers that I have stored in CSV file (001, 002, 003) in every column one ...
2
votes
2answers
7k views
JMeter: Iterating over a set of CSV files over a set of links - nested loops
I have a set of JSP Pages for each I have a set of links to use for the response time measurements.
In order to aggregate the results correctly I am trying to run a foreach controller over a loop ...
7
votes
4answers
20k views
Performance testing with 100 users: how to read links from CSV file in JMeter?
I am using JMeter to do performance testing of a site.
I need to test various links of a site (no need to login) with 100 users and loop it for some number of times. I want to put those links in a ...
2
votes
1answer
5k views
Using a variable in the filename textfield of CSV dataset config in JMeter
I want to parameterize the filename textfield of CSV dataset config. I am writing into different files for every user that I'm using in JMeter, hence I need to parameterize the filename option in the ...
1
vote
1answer
437 views
In QC, under the Dashboard module can reports be saved in .csv format?
In QC - Dashboard module - I have a report which has huge data that exceeds Excel limit. Is there a way to save it in .CSV format?
4
votes
1answer
2k views
Automation for export tasks (Word/PDF/CSV)
I am looking for ideas for automating export tasks you would usually see in reports (SSRS SQL Server Reporting Services example - Export to PDF/Excel/CSV). What I have observed is when you export data,...
