Loop over Dataset

Create Dataset

1. From Automate Dialog
2. From Node

From Automate Dialog

1. Open the Automate dialog.
2. Navigate to the Data tab.
3. Click on the drop-down arrow for Data Source and select Create New.
4. Set the Data Source name to user_details.csv.
   info The Data Source is where the data will be stored. Currently supports csv files.
   A single Data Source can contain multiple Datasets. So all datasets pertaining to user may be clubbed into a single Data Source of user_details.csv.
   These files reside in <sahipro>/userdata/scripts/flowchartsdata/<project_name>/datasets folder.
5. Enter a dataset identifier in the Dataset. (If not provided, it will be default).
6. Choose the attribute from Add Columns drop-down. Eg. $user.firstname, $user.lastname.
   infoWe need to provide values for these attributes.
   For other attributes which are not specified in the dataset, data generators will be used.
7. Type the values for the attributes below the attribute names.
   
8. Click on Save.

From Node

1. On the flowchart page, right click on the Node for which dataset needs to be created.
2. Click on Data Loop.
3. In the Attach Datadet dialog box, under Data Dource drop-down, select Create.

4. The Edit Dataset dialog opens up. Enter the required data and save.

Run Dataset

Path Level

1. On the Automate dialog, go to Data tab
2. Select the Data Source and a Dataset(group name) to associate it with the Path.
3. Select the dataset row to run by default when run from Automate dialog.
4. Click on Run button on Automate dialog.
5. On the Run Settings dialog, select the Run Normal Path and click on Run button.
6. The flow executes one time and uses the select dataset row.

View Report

1. Open the report by clicking on the Reports button/option either from the Automate dialog or from the flowcharts page.
2. The detailed report shows the execution with the used dataset row details.

Flowchart level/Project Level

1. Click on Run button on the flowchart page or the project page.
2. On the Run Settings dialog, select the Run Normal Path and click on Run button.
3. The flow will be run multiple times to exercise each row of the dataset. For each row in the dataset, an individual target website browser will open and the steps will be carried out.

View Report

1. Open the report by clicking on the Reports button/option.
2. The detailed report shows the multiple path execution with the used dataset row details.

Node level

• Lets take another example where the flowchart verifies the cart total for books purchase.

• The Add $books and Verify $cart total keyword will be automated and extracted as follows:

1. Click on Add $books and Verify $cart total node and choose Data/Loop from the menu.
2. Choose the Data Source and Dataset or Create a new one.

3. Data source and dataset may be set from a variable as well.

4. The keyword in the Node will be run in a loop over all rows of the dataset.

View Report

1. Open the report by clicking on the Reports button/option.
2. The detailed report shows the multiple path execution with the used dataset row details. The keyword Add $books and Verify $cart total has executed thrice.

Data / Loop Boundary

• Lets take the above example but split the keyword Add $books and Verify $cart total into two nodes.
  
  • The Add $books and Verify $cart total keywords will be automated and extracted individually as follows:
  
  1. Click on Add $books node and choose Data / Loop from the menu to attach the dataset books.csv with the node.
  2. Click on Add $books node and choose Data / Loop Boundary from the menu. Choose Start from the options to set the starting point of the data loop.
  
  3. Click on Verify $cart totalnode, click Data / Loop Boundary and select End to set the end of the data loop.
  • When executed, the whole flow will be executed once but within that flow the set of nodes within the data loop boundary will be executed multiple times to exercise each row of the dataset.

  View Report

  1. Open the report by clicking on the Reports button/option.
  2. The detailed report shows the path execution with the used dataset row details. The keywords Add $books and Verify $cart total both have executed three times.
  
  info Note:

  • The selected row from a dataset will execute only in cases of Path run, Run Till Here and Run This.
  • Flowchart level run and Project level run will use all the rows of the dataset irresepective of the selection of rows.
  • Data/Loop and Data/Loop Boundary options will use all the rows of the dataset.
  • Flowchart level or Project level run will run the whole flow multiple time to exercise each row of the dataset. For each run, a new browser will open.
  • You can change the dataset or click Edit to edit the dataset.

  Environment based Datasets

  Datasets can be overridden to use different data in different environments.
  For example, to use different data for default, QA and production environments.
  
  
  • Create a new dataset as shown here.
    
  • Open the Edit Dataset dialog.
    • To create new environment, click on the drop-down near Env and select Add New.
    • Enter the env name in the prompt.
    • This will clear the Edit Dataset dialog and a new folder with given env name will be created under datasets folder of the project.
    • Enter the required data and save.
  • To set the environment of execution, set sahi_env variable in External Variables under Advanced Run Settings section of Run Settings dialog before running.
    Data will be picked from data file of given environment instead of the default dataset.
  info Note:

  • A dataset must exist in the default environment before it can be overridden in other environments.
  • If the given environment does not have a dataset, data is picked up from the default dataset.
  next Flowchart Paths & Branches