How to Share Test Data
After you have created a Test Data set for one test, you may want to use the same data in other tests, or share this data with users in your Workspace, or in other Workspaces. Shared test data can be either a spreadsheet or a data entity. You can share test data either within the current workspace, or export it from one workspace and import it into another.
You can open saved test data entities in any other test in the same workspace. The test data integration covers Performance tests, Functional tests, API Monitoring tests, and Virtual Services.
This article covers:
- Video demo
- Share spreadsheets within the workspace
- Share data entities within the workspace
- Export Data Entities to other workspaces
- Preview Shared Test Data
- Unshare Test Data
Video demo
The following video quickly summarizes using shared data entities consistently across all different test types.
Share spreadsheets within the workspace
Create Shared Folders for Spreadsheets
To share a spreadsheet within a Workspace, ask a Workspace administrator to create a shared folder and to upload the CSV files there.
- Prepare spreadsheets with test data as usual.
Example: The column names will become the test parameter names, and the rows contain the test data values. - Save the spreadsheets in CSV format.
- Log on as a Workspace Administrator.
- Click Settings > Workspace > Shared Folders.
- To create a new Shared Folder, click Plus, give the new folder a name (without spaces!), and press Enter.
- Click a shared folder to open it.
- Drag and drop the CSV files from your local machine onto the drop area, or click to browse to file to upload them.
The uploaded files become available to workspace members.
Attach CSVs from shared folders to a test
After the Shared Folder and its contents are ready, team members can attach shared test data to their tests.
- Open a test and go to the Configuration tab.
- Click the Test Data button.
- Click Plus, and then select Attach... CSV File from Shared Folders.
The Shared Folders window opens. - Select the desired folders so that a checkmark appears, then click Accept to use the selected test parameters in your test definition.
Remove shared CSVs from a test
To stop using shared test data in a test, return to the Shared Folders window, and deselect the shared folder. The test data remains available for other users of this workspace.
Share data entities within the workspace
In addition to sharing spreadsheets, you can also share data entities with team members in the same Workspace. To share a test's local data entity, save it to the workspace. The saved data entity contains copies of all test parameters.
For more information about creating data entities, see How to Use Test Data.
Follow these steps:
- Open a test and go to the Configuration tab.
- Click the Test Data button.
- Click the ellipsis menu and select Save to Workspace.
The Save Test Data Entity window opens. - Define a Test Data Entity Name that helps your team members to identify what to use this test data for, and click Save.
- Open a test into which you want to load the data entity, and go to the Configuration tab.
- Click the Test Data button.
- Click the ellipsis menu and select Load From Workspace.
- Select a test data entity and click Open.Opening a data entity overwrites all current test parameters and settings in the test.
Export Data Entities to other workspaces
You can export a data entity as a zip file to your local computer, and import it into any test with test data support in another workspace. The zip file contains all test parameters, attached CSV files, and CSV files from shared folders.
- Open the source test and go to the Configuration tab.
- Click the Test Data button.
- Click the ellipsis menu and select Export to File.
- Define the Test Data Entity Name and click Export.
You download the data entity as a ZIP file. - Open the target test and go to the Configuration tab.
- Click the Test Data button.
- Click the ellipsis menu and select Import.
- Select the exported ZIP file and Click Open.Importing a data entity overwrites all current test parameters and settings in the test.
After the import, you can remove test parameters that you don't need, and add new test parameters to the test.
Import Shared Folders
- Export the data entity from the source Workspace.
- Work with the workspace administrators of the target workspace to recreate the Shared Folder structure and have them upload the CSV files from the source Workspace.
- Go to the target workspace and open a test.
- Click the Test Data button and click the Plus button.
- Select Import Data Entity From Exported File.
- Select the exported ZIP file and Click Open.Importing a data entity overwrites all current local test parameters and settings in the test.
Preview Shared Test Data
Each Data Entity appears as a tab in the Data Settings / Iteration window of the test it is used in.
You can also click Test Data in the top navigation to open the Test Data Management window to preview the values of all shared Data Entities in this workspace.
Unshare Test Data
Unshare a spreadsheet
To prevent everyone from using a shared data set (for example, because it is outdated), return to the Shared Folders window, and deselect the shared folder.
Then click the delete button to remove the spreadsheet for everyone in the Workspace.
Unshare a Data Entity
- Click Test Data in the top navigation.
The Test Data Management window shows the list of shared Data Entities in this workspace.
- Hover the mouse over the Actions column of a shared data entity.
Inline action buttons appear. - Click the Delete action to remove the data entity from all tests.