Test data from .csv file : Automation API

[omayer]

is there code snippet for read through the entire .csv file and passing the data to test method in ranorex,
Thank you,
Beginner

[Support Team]

Hi,

Do you know the Ranorex Studio "Manage Data Source" functionality?
You can easily load your (csv, excel, ...) files with all data into your project and you can easily access them.
For additional information see the link below: http://www.ranorex.com/support/user-guide-20/lesson-3-data-driven-testing.html
If you mean something else please explain it in a more detailed way.

Thanks in advance!

Regards,
Markus
Ranorex Support Team

[omayer]

how to load csv file w/out using "Manage Data Source" functionality, i like to creae a function that will read the .csv file from external source then passing data as function parameter.
Thank you
Beginner

[Support Team]

Hi,

if you do not like to use our new data connectors with data binding, you can use attached CSVConnector.
Following code sample shows you how to use it:

...
try
{
	// Create a new CSVConnector object
	CSVConnector csvConnector = new CSVConnector(@"../../data.csv");

	// Read every row from connector and send to AddVIPApplication.
	foreach(System.Data.DataRow row in csvConnector.Rows)
	{
		String str1 = row[0].ToString();
		String str2  = row[1].ToString();
	}
}
catch (RanorexException e)
{
...

Regards,
Tobias
Support Team

[omayer]

Thank you Markus, I really like the dataconnecters and binding feature in Ranorex, the problem i am having w/binding data w/parameter, I am working on it , will keep you posted the progress.
Thank you
Beginner

[omayer]

how to view the data str1, I tried to use messagebox.show but no go

try
{
// Create a new CSVConnector object
CSVConnector csvConnector = new CSVConnector(@"../../data.csv");

// Read every row from connector and send to AddVIPApplication.
foreach(System.Data.DataRow row in csvConnector.Rows)
{
String str1 = row[0].ToString();
String str2 = row[1].ToString();
}
}
catch (RanorexException e)
{

[Support Team]

Hi,

No idea why MessageBox.Show should not work, but instead you can use Console.WriteLine(), or log the data to the Ranorex Report file, or you set a breakpoint and use the debugging mode of Studio to read the data for str1.

Regards,
Peter
Ranorex Team

[omayer]

Thank you Peter, I might need instruction or what to do w/attached file "CSVConnector.cs" on previous post .
Thanks
Beginner

[Support Team]

Hi,

Attached you will find the old Data Drive Sample. In this sample the VIP Application uses the CSV Connector.

Data Driven Test.zip

Data Driven Test

(21.64 KiB) Downloaded 33 times

Regards,
Peter
Ranorex Team

[omayer]

Thank you Peter
Beginner

[omayer]

i amg getting the error " Index was outside the bounds of the array. "

Code: Select all

void ITestModule.Run()   

           
        {
            Mouse.DefaultMoveTime = 300;
            Keyboard.DefaultKeyPressTime = 100;
            Delay.SpeedFactor = 1.0;
                                    // Create a new CSVConnector object

CSVConnector csvConnector = new CSVConnector(@"C:\Automation_Ranorex\TestData.csv");
            // Read every row from connector and send to AddVIPApplication.
               foreach(DataRow row in csvConnector.Rows)
      {                
         
                  LoginTo.userId = row["userID"].ToString();
                  LoginTo.passWord = row["passWord"].ToString();
                  MessageBox.Show(LoginTo.userId);
                                             
                 } 




Thanks
Beginner

[omayer]

Thank you all, csvconnector working as expected.
Beginner

[omayer]

How to parse data in csv File that contains this format "lastname, firstname (company name)". Thank you in advance...beginner

[Support Team]

Hi,

How to parse data in csv File that contains this format "lastname, firstname (company name)".

Like you have done it, you just have to replace "userID" with "lastname", "passWord" with "firstname" and so on.

Regards,
Markus
Ranorex Support Team

[omayer]

I do have data in csv file that looks like this " omayer,baba-(testing field)" . Now when that field gets parsed its value display as "omayer. Not the entire data, so how will i get the data that read as " omayer,baba-(testing field)"
Thank you
Beginner