Using Module Variable

[Deepak_Singh]

Hi All,
I am using a test suite in there are Multiple Test cases. Each Test case has 2 Module Variable's URL and Browser.
Now to change the URL and Browser I have to go to Excel and change the Data and then go to each Test case and do the binding again.

This is Time consuming and Lengthy Process. Is there a way to Declare the Variable's explicitly and just by once doing Data Binding will apply to all the test cases contained in the Suite.
Please Help.


Thanks And Regards,
Deepak

[mzperix]

Hi Deepak,

Use the Global parameters option for this. Right click on the test suite name, and select Global parameters... menuitem. See screenshot.

Every test case will have a new entry in the bind variables screen with this option.

This way you only need to change the global parameter inside Test suite, and the bindings are not lost.

Kind Regards,
Zoltán

[Deepak_Singh]

Hi Zoltán,
I have used that and it shows me "url: http://google.com browser: IE " in Iteration1
But in Test Case it shows:Current variable values: $url = '', $browser = ''


What should I do in this Case?


Regards,
Deepak

[Support Team]

Hello Deepak,

Please make sure that you bind your module variables to the global parameter.

TestCaseDataBinding.png

DataBinding.png

Regards,
Robert

[Deepak_Singh]

Hi Robert,

I have used Data Binding as well.

Regards,
Deepak

[Support Team]

Hi Deepak_Singh,

May I ask you to send your generated report file to [email protected]
This would really help us in analyzing your issue.

Regards,
Robert

[Deepak_Singh]

Hi All,

I resolved the issue.

But my question is that if I change the data in my Excel then I have to every time go to each test case and do Binding again.
I need help in reducing this pain.

Regards,
Deepak

[mzperix]

Hi Deepak,

hmm, changing the excel data should not unbind your variables. I used many times a worksheet, and changing does not looses variable. I have some questions:
- Is the excel spreadsheet in a network drive?Is it in a different folder from the Ranorex project?
- Do you use formulas in excel?
- Does different data connectors use different worksheets?
- Do you manipulate data connectors from usercode? I could imagine, that somewhere in the code the bindings get lost.
- Do you manipulate the excel sheet from code?

Best regards,
Zoltan

[Deepak_Singh]

Is the excel spreadsheet in a network drive?-No
Is it in a different folder from the Ranorex project?-No
Do you use formulas in excel?-No
Does different data connectors use different worksheets?-No
Do you manipulate data connectors from usercode?-No
Do you manipulate the excel sheet from code?-No

Regards,
Deepak

[mzperix]

OK, I tried to reproduce the issue. I could not, unfortunately. I use win7 64 bit, and Excel 2013.

Here is what I did:

1. Created an Excel connector (I checked the copy file to Project option also).
2. Added the connector to a few test cases.
3. Bind the variables.
4. opened the excel sheet
5. added some rows / edited a few rows
6. Save
7. If I went back to Ranorex studio, I got a message If I ant to Reload the Excel.
8. Clicken on Yes.

I checked the data in ranorex: everything is updated, and no variable binding is lost.

Could you tell us some more details? Can you reproduce this issue on a fresh and clean solution?

Best regards,
Zoltan