Page 1 of 1

Organizing csv files

Posted: Tue Oct 23, 2012 9:40 am
by puntapret
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

Re: Organizing csv files

Posted: Wed Oct 24, 2012 1:44 pm
by Support Team
Hello,

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

Regards,
Markus (T)
Ranorex Support Team

Re: Organizing csv files

Posted: Fri Nov 02, 2012 11:07 am
by puntapret
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

Re: Organizing csv files

Posted: Mon Nov 05, 2012 1:20 pm
by Support Team
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)

Re: Organizing csv files

Posted: Mon Nov 05, 2012 2:24 pm
by puntapret
I'm using the latest version 3.3.3.

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

Re: Organizing csv files

Posted: Tue Nov 06, 2012 1:38 pm
by Support Team
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
3. Select 'Link repository to project 'ProjectsTest' and click OK as shown below:
LinkRepo2.PNG
4. Execute your test.

Regards,
Markus (T)