Skip to content

Defining the Test Data in HuLoop

  1. Open the Automation project you are working on.
  2. Click the Menu menu-icon available on the top right of the screen and you will get the following options:

define-test-data-menu-options
Menu Options
  • Expand the Data option and select Manage Test Data:

expand-data-select-manage-test-data

  • You will see the Manage Test Data page:
scrn-manage-test-data-page
Manage Test Data Page

To define the test data, follow these steps:

On the Manage Test Data page:

  • Enter a Name for the test data in the Name field.
  • Keep the Environment Name value as default.
  • Keep the Execution Mode to Sequential.
  • In the Test Data text area, define your test data using key-value pairs.

For example, if you need to define the following test data for employee details:

table-test-data-for-employee-details

You should define it in HuLoop Test Data Format as shown:

EmployeeID=101
Name=John Smith
Department=HR
Salary=60000
Joining Date=23-09-2022

Note:

  • Avoid using commas in numerical values (e.g., Salary=60000 instead of Salary=60,000), as commas are interpreted as separators for multiple values.
  • If you need to include a comma within a value, enclose the entire value in double quotes (e.g., Address=”123, Main Street, NY”).
  1. Click Save to store the test data.

scrn-manage-test-data-plain-view

How to Modify Test Data?

You can modify test data in the following ways:

  1. Modify Test Data in Plain View
  2. Modify Test Data in Grid View
  3. Modify Test Data by Importing an Excel File

Modify Test Data in Plain View

  1. Go to the Manage Test Data page and you will see a list of test data under the Manage Test Data section, as shown.
scrn-manage-test-data-list-of-test-data
Manage Test Data Page
  1. Click the desired test data name. It will appear in the Test Data section at the bottom of the screen:

scrn-manage-test-data-click-test-data-name

  1. Modify the values as needed.
  2. Click Save to apply the changes.

Modify Test Data in Grid View

  1. Go to the Manage Test Data page and click the test data name you want to modify. It will appear in the Test Data section at the bottom of the screen.
  2. Click Grid View to display the data in a table format.

scrn-modify-test-data-in-grid-view

  1. Each variable appears as a column header, with values as row entries.
  2. Click on the variable value and it will become editable. Make the changes and click Save button.
scrn-editing-test-data-in-grid-view
Editing Test Data in Grid View
  1. Click the three dots next to a row to insert or remove a row.
scrn-modify-test-data-row
Modify Test Data Row
  1. Click the three dots next to a column name to rename, delete, or insert a new column.
scrn-modify-test-data-column
Modify Test Data Column

Modify Test Data by Importing an Excel File

  1. Create an Excel file containing test data formatted like Grid View (column names as variables and row data as values).
sample-excel-file-containing-test-data
Sample: Excel File Containing Test Data
  1. Go to the Manage Test Data page.
  2. Click the upload icon next to the test data name you want to modify.

scrn-modify-test-data-click-upload-icon

  1. You will see a pop-up to upload the Excel file.
scrn-import-test-data-pop-up
Import Test Data Pop-Up
  1. After a successful upload, verify the test data in Plain View or Grid View by clicking the Test Data name.
scrn-updated-test-data
Updated Test Data

How to Download Test Data as Excel File?

  1. Go to the Manage Test Data page.
  2. Click the upload icon next to the test data name you want to download as excel file.

scrn-download-test-data-as-excel-file-upload-icon

  1. You will see a pop-up to download the Excel file.
scrn-downloading-test-data-as-excel-sheet-file-name
Downloading Test Data as Excel Sheet
  1. Save the test data Excel file with an appropriate name and store it in a preferred location on your computer.

How to Delete Test Data?

  1. Go to the Manage Test Data page.
  2. Click the delete icon next to the test data name you want to delete.

scrn-how-to-delete-test-data

Back To Top