Test Data
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
Section titled “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
Section titled “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.
A confirmation email is sent when the import completes. Refresh the Test Data Profiles page to see the imported profile in the folder tree.