Hello SmartBear Community,Is it possible to execute all test cases in an execution plan multiple times based on variables in an Excel table?ExampleIteration 1:Test case 1: Login as "user 1"Test case 2: Logout as "user 1"Iteration 2:Test case 1: Login as "user 2"Test case 2: Logout as "user 2"Iteration n:Test case 1: Login as "user n"Test case 2: Logout as "user n"The user data is saved in an Excel table and there should be as many iterations until all rows have been run through.Best regards,Christopher

In this code example, you have a main function that launches the application. It then reads the data input and then calls various functions to perform actions; populates the UI controls with the data input, then performs checks. This is repeated until all the data has been read. Application then closes, and data-driven test ends. function Main() { TestedApps.Orders.Run(); let orders = Aliases.Orders; let mainForm = orders.MainForm; let driver = DDT.ExcelDriver("../../TestBook.xlsx", "TestSheet", true); while (! driver.EOF()) { OpenForm(mainForm); let orderForm = orders.OrderForm; let groupBox = orderForm.Group; PopulateForm(groupBox, driver); Checkpoint(driver); CloseForm(orderForm); driver.Next(); } CloseApplication(mainForm, orders); } You have to plan your tests and organise your tests, so that they are called correctly

HI Chris2024, the other way to achieve it is as below: Create a script (Drive) which drives your execution and add only this in your execution and internally you can handle to read your excel using ADODB for excel. loop through the record set object which holds the value of your user (user 1, user 2, _, , user n) call the methods or the functions written in your script

What you want to achieve, is described in Data-Driven Testing

So far I have only been able to find documented solutions for creating data-driven test cases. Unfortunately, there are no solutions for creating data-driven execution plans. How would you implement the example shown above in Testcomplete?

Execution Plan allows tests to be executed in order or n-number of times. You have to use Data-Drive Testing.

Forum Discussion

Chris2024

Occasional Contributor

12 days ago

Multiple execution of a test plan with different values from an Excel table

Hello SmartBear Community,

Is it possible to execute all test cases in an execution plan multiple times based on variables in an Excel table?

Example

Iteration 1:
- Test case 1: Login as "user 1"
  Test case 2: Logout as "user 1"
Iteration 2:
- Test case 1: Login as "user 2"
  Test case 2: Logout as "user 2"
Iteration n:
- Test case 1: Login as "user n"
  Test case 2: Logout as "user n"

The user data is saved in an Excel table and there should be as many iterations until all rows have been run through.

Best regards,
Christopher

12 Replies

Mr_Bro
Champion Level 0
10 days ago
HI Chris2024,

the other way to achieve it is as below:

Create a script (Drive) which drives your execution and add only this in your execution and internally you can handle to read your excel using ADODB for excel.

loop through the record set object which holds the value of your user (user 1, user 2, _, , user n)

call the methods or the functions written in your script
rraghvani
Champion Level 3
12 days ago
What you want to achieve, is described in Data-Driven Testing
- Chris2024
  Occasional Contributor
  11 days ago
  So far I have only been able to find documented solutions for creating data-driven test cases. Unfortunately, there are no solutions for creating data-driven execution plans. How would you implement the example shown above in Testcomplete?
  - rraghvani
    Champion Level 3
    11 days ago
    Execution Plan allows tests to be executed in order or n-number of times. You have to use Data-Drive Testing.