Organizing csv files

Best practices, code snippets for common functionality, examples, and guidelines.
puntapret
Posts: 34
Joined: Fri Sep 14, 2012 11:05 am

Organizing csv files

Post by puntapret » Tue Oct 23, 2012 9:40 am

Hi,

I have a Test Suite that will have multiples Test Case (one test case for each of our client).

For these tests, we will use CSV files as datasources, and we will run the exe files in a standalone computer.

I'm thinking that our csv files will be organized as these folders :
-- DataTestFiles
-------Common
------------BrowserList.csv
------------MenuList.csv
-------Client_1
------------ArticleList.csv
------------UserList.csv
-------Client_2
------------ArticleList.csv
------------UserList.csv

If we check on the "Include File in Test Suite", i believe the csv files will be copied directly to the bin/Debug or bin/Release of the Test Suite (correct me if i'm wrong).

Is it possible that the files copied to bin/debug folder also have the correct folder hierarchy ? Or am i doing it the wrong way ?

Thanks in advance

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: Organizing csv files

Post by Support Team » Wed Oct 24, 2012 1:44 pm

Hello,

How about using one testsuite for each client?
In that case, you have separated data from clients.

Regards,
Markus (T)
Ranorex Support Team
.
Image

puntapret
Posts: 34
Joined: Fri Sep 14, 2012 11:05 am

Re: Organizing csv files

Post by puntapret » Fri Nov 02, 2012 11:07 am

Markus,

Thank you for the answer, i'm still reorganizing the structure of how we deal with common test and test per client (since we have multiple clients).

I will re-try to explain what we are doing here.

Our folders hierarchy :
- DataTestFiles (just a folder to hold all the data files)
---- Common
-------- BrowserList.csv
-------- DatabaseServer.csv
---- Client_1
-------- Client_1_UserList.csv
-------- Client_1_ArticleList.csv
---- Client_2
-------- Client_2_UserList.csv
-------- Client_2_ArticleList.csv
- ProjectsTest (Test Suite)
---- ProjectsTest.rxtst
- PortalTest (Test Suite Module library)
---- PortalTest.rxrep
---- PortalTest.rxrec

I have 2 questions though :

In my ProjectsTest.rxtst, i have a manage datasource so it points to folder DataTestFiles, if i check Include Files in TestSuite, it will automatically copy the DataTestFiles/Common/BrowserList.csv to the ProjectsTest folder. The problem is if i change the DataTestFiles/Common/BrowserList.csv, the file BrowserList.csv in the ProjectTest folder don't get updated. Is there a way that it will get updated automatically ?

And other thing in my PortalTest module, i have a rxrec that compare image with a screenshot (that i had in the PortalTest repository). The problem is when i use the PortalTest.rxrec in my ProjectsTest.rxtst, the test failed, since it can not find the repository images in the folder ProjectsTest/bin/debug/RepositoryImages/PortalRepositorydb443793.rximgres. Doesn't it get copied automatically ?

Thanks in advance

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: Organizing csv files

Post by Support Team » Mon Nov 05, 2012 1:20 pm

Hello,

If you select 'Include Files in TestSuite' your data files are copied only once to the project folder.
Updates on origin data files in your folders hierachy have no effect on data files in the project folder.

Which Ranorex version are you using?
Are 'ProjectsTest' and 'PortalTest' separate projects in your solution?

Regards,
Markus (T)
.
Image

puntapret
Posts: 34
Joined: Fri Sep 14, 2012 11:05 am

Re: Organizing csv files

Post by puntapret » Mon Nov 05, 2012 2:24 pm

I'm using the latest version 3.3.3.

Yes, PortalTest and ProjectTest are separate projects on the same solution.

User avatar
Support Team
Site Admin
Site Admin
Posts: 11709
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: Organizing csv files

Post by Support Team » Tue Nov 06, 2012 1:38 pm

Hello,

Concerning your issue about repository images please do the following steps:

1. Open Recording1.rxrec in your 'ProjectsTest' test suite. (create if it doesn't exist)
2. Select '(PortalTest)PortalTest' in the 'Recording1.rxrec' as shown below:
LinkRepo.jpg
LinkRepo.jpg (26.04 KiB) Viewed 2718 times
3. Select 'Link repository to project 'ProjectsTest' and click OK as shown below:
LinkRepo2.PNG
LinkRepo2.PNG (35.82 KiB) Viewed 2718 times
4. Execute your test.

Regards,
Markus (T)
.
Image