Data source Data generator - loading values from file

Question

I am trying to load my data generator data source from file.&nbsp;
The data source has two properties.
When I load the file, it puts alll the values as options for both of the properties.
How do I load the data into the different properties?

richie · Answer

Hi&nbsp;lauravachon&nbsp;
&nbsp;
If Im understanding - your datasource file has what - 2 columns of data? but despite you creating 2 properties on the datasource - its writing only 1 column's data out to the single property?
&nbsp;
I struggled using a .txt&nbsp; file to get the different column's values into separate properties when I was playing around with this a while back - Im sure there is a way - but I found a workaround that was easier.
&nbsp;
I tried the excel datasource option and it allowed me to have multiple columns of data - each column has an associated property - this successfully extracted multiple values to multiple properties - is that what you need?
&nbsp;
please see the images below of the spreadsheet and the datasource properties

&nbsp;
Hope this helps!
&nbsp;
cheers,
&nbsp;
rich
&nbsp;

richie · Answer

Hey&nbsp;lauravachon&nbsp;
&nbsp;
I did play around and I got the Datasource file option working (with multiple properties) using a .csv file and a txt file
&nbsp;
Images for correct csv setup with multiple properties are as follows:

&nbsp;
&nbsp;
Images for correct txt file setup with multiple properties are as follows:

&nbsp;
&nbsp;
Cheers,
&nbsp;
rich

lauravachon · Answer

Thanks rich for your effort.
&nbsp;
I was trying to load the values for the properties in a datagenerator test step. I gave up after a while and just entered it all manually.

&nbsp;

Forum Discussion

Data source Data generator - loading values from file

3 Replies

Recent Discussions

Smart Assertion default of "Received Data"

Vulnerable jetty files

RunTestCase input and return proeprties of the same name

Related Content

Data Source Generator

In the Data Source Generator

Generate report in SoapUI Open Source