Import Test Data Profile

This article explains how to import a Test Data Profile into Testsigma. With the folder structure enhancement, Test Data Profiles are organized under Features and Scenarios, so imported profiles are placed within that hierarchy.

Prerequisites

Before you begin, ensure that you have:

Reviewed Folder Structure for Test Data Profiles.

An XLSX file ready to import in the supported format.

Import File Format

To import a test data profile, you need an XLSX file with data in a supported format. Below is an example of the data that an XLSX file should have.

Name	Description	ExpectedToFail	Username	Password
Iteration1	First value	YES	username1	password1
Iteration2	2nd value	NO	username2	password2
Iteration3	Third value	YES	username3	password3
Iteration4	Fourth value	NO	username4	password4
Iteration5	Fifth value	YES	username5	password5
Iteration6	Sixth value	NO	username6	password6
Iteration7	Seventh value	YES	username7	password7
Iteration8	Eighth value	NO	username8	password8
Iteration9	Ninth value	YES	username9	password9
Iteration10	Tenth value	NO	username10	password10

The following are the mandatory fields that should be present in the XLSX file.

Name: Name of the test data set that the corresponding row would contain.
Description: Description for that row of that test data.
ETF: This would be either ‘YES’ or ‘NO’, depending on whether you expect the test case to fail with this test data or you expect it to pass.

Steps to Import Test Data Profile

From the left navigation bar, go to Test Data > Test Data Profiles, open the List View.
Click Import.
In the Select Location dialog, select the Feature and then the Scenario where you want to import the profile. The selected Scenario appears under Target Scenario at the bottom of the dialog.
In the Import Test Data Profile dialog, select Browse File and choose the file to upload.
Enter a Name for the test data profile, select the columns you want to encrypt, and click Import.