Driver using Multiple csv files

[Mythili parasuraman]

Hello all,

I've been practising the keyword driven framework using single excel worksheet with Test case,test step and test data sheets.

Now, I am trying on multiple csv files in the suit,group, navigation and scenario folders ..if anyone has tried this framework, pls give me some examples.

1. suite folder

   suite_01.csv    -----> included in the script

   

   Group Name   Iterations  ----> column names

   grp_01         1

2. Group folder

   grp_01.csv         -----> read from the suite_01.csv

   

   Navigation name  iterations

    nm_01             1

3. Navigation folder

   nm_01.csv          -----> read from the grp_01.csv

    Window name     Scenario 

    Calculator        1

4. Scenario folder

   calculator.csv     ------> read from the nm_01.csv and go to the scenario number 1

  

   Scenario  Desc  first num   sec num ....

If anyone give me some example as how to read a folder and the csv files inside that and move on the next folder  that would be really appreciated.

Thanks much

Mythili

[iTeLearn Help Team]

Mythili,

You need to use the same logic that Karthik used for Test Case and Test Steps.

Create one more file with Tet Suite and put the same logic.

Thanks,

Mythili

--
You received this message because you are subscribed to the Google Groups "QTP eLearn Team" group.
To unsubscribe from this group, send email to qtp-elearn-te...@googlegroups.com.
Visit this group at http://groups.google.com/group/qtp-elearn-team?hl=en-US.
 
 

--
iTeLearn Help Team

tech...@iTeLearn.com

QTPeLearn.com | SeleniumeLearn.com

Join me on YouTube and LinkenIn

[Jitendra.S]

Hi,

Use File system object ..That is best way to handle any file which is present in folder ..I am using FSO in my current project It is very efficient for our project ..

could you please tell me what you want to achieve ? Step by step..

~J~

[Mythili parasuraman]

Hi,

Thanks much for the response.

To use the FSO, I need to Create a reference to the Microsoft Scripting Runtime object library in each .csv file? Please advice.

Following is my scenario to create the framework .

This framework has four folders to navigate.

First - is Suite folder under this folder many .csv files will be placed. To run a specific file, I will include that file name in the driver script for eg. Suite_01.csv, when it opens it reads the group name and iteration column.

suite folder

   suite_01.csv    -----> included in the script

  

Group Name	Iterations
grp_01	1

 

 

 

 

Second -  it identifies grp_01 is the group name and navigate to the group folder and open the grp_01.csv file. When it opens it reads the navigation name and iteration column.

Group folder

   grp_01.csv         -----> read from the suite_01.csv

Navigation name	iterations
nm_01	1

     

Third – identifies the navigation file as nm_01.csv and goes to the navigation folder to locate that file, and reads the window name and scenario number.

Navigation folder

   nm_01.csv          -----> read from the grp_01.csv

Window name	Scenario
Calculator	1

 

Fourth – once the window name and scenario number is read it navigates to the scenario folder to locate the correct scenario numbers and window names and navigate thru the application.

4. Scenario folder

   calculator.csv     ------> Window name is been read from the nm_01.csv and go to the scenario number 1.

Scenario	Description	Call	Navigate	Exit	Save	Add	Detail	Delete	Close
1	1	Save			TRUE	TRUE
	2	Add

    

Please let me know. Thanks much.

[iTeLearn Help Team]

Mythili,

As suggested earlier, please use the same concept of xls files as used for testcase, testdata etc.

Thanks,