using the binding and itirating

[Jimmyto]

Hi all,

Have a small challenge that's been bugging me all day and need some help!

Here's my challenge, I'm sure someone has found a way how to do this.

Have an excel spreadsheet that has test cases and need to iterate thru those and enter them into a system (Jira/Zephyr). Let me explain

One iteration will be"

Column1, Column2, Column3 or TC_Name, Steps, Exp_results

TC01 Step 1
Step 2
Step 3
---------> Here where the TC needs to be saves and create a new TC which will be iteration 2 for TC#2 or next TC (TC02 below)
TC02 Step 1
Step 2
Step 3

So it looks like this! in excel
TC01 Step 1
Step 2
TC02 Step 1
Step 2
Step 3

How can I tell the Ranorex that the second iteration is the TC02? Any help, approach will be greatly apreciated!

Thanks in advance
Jimmy

[Vaughan.Douglas]

On the Data Source tab for each test case you can set the range.

range.png (18.67 KiB) Viewed 953 times

[Jimmyto]

Thanks Vaughan! Yes, that worked for only a set or one range at the time. Example did 1-5, 12-15 but it did not iterated work ho I wanted. In one TC, did range of 1, the child TC did the range but didn't move to the next.

Maybe I'm doing something wrong.. here's a snapshot

[Vaughan.Douglas]

I'm not entirely clear on how you're trying to iterate through your data. In your original post it appears that TC01 and TC02 are peers, but in your follow up you've indicated there is a child test case.

Maybe if you can explain what you're trying to do with your iterations and child test cases I can give you a better answer.

[Jimmyto]

Thanks Vaugham! I've tried many ways, my apologies if presented the child one but guessing that at the end of the day I just want to iterate and add a condition. Example If TC name IsNotNull or <> NULL then move to the next iteration. Just can't get it to work!

[Jimmyto]

Here's a sample of the data.. any suggestion, approach, anything is greatly appreciated!!

Was thinking that if the TCName <> Null then move to the next iteration.. but each set should be one test case with multiple steps.

[Vaughan.Douglas]

I don't think you're going to get something like that done without writing some code.

[Jimmyto]

Was hoping that wasn't the answer..

[Vaughan.Douglas]

Was hoping that wasn't the answer..

So you're not actually trying to run tests, you're trying to use Ranorex to create data in Jira?

[Jimmyto]

Yes to enter the test cases in Jira!

[Vaughan.Douglas]

I think there is a bulk loader for CSV files that might be helpful.

[Jimmyto]

Thanks Vaughan for all your help!

Yes, there's an import utility in which currently exploring but not the import CSV column mapping are limited. Uncertain, if it's an implementation limitation, etc.

[Vaughan.Douglas]

Good news. I think you might be able to work something out using the new conditional functionality just released in Ranorex 7.1.0. I can't tell you how yet, but reading the new material made me think of your situation.

[Jimmyto]

I'll give it a shot!