Import and Export Test Data Sets

SimplifyQA enables users to import and export test data sets, allowing for efficient data-driven testing. This ensures test cases can be executed with different input data sets without manually modifying test scripts.

Importing Test Data Sets

1. Navigate to Test Data Management

• Open the User Navigation Panel.

• Go to Test Management > Test Data.

• Click on the “View Details” button of the relevant test data.

1. Importing Test Data

• On the top right, you will find the Excel Import/Export button.

• Click on “Import Excel” from the dropdown menu.

• A pop-up window will appear with an option to upload an Excel file.

• You will be prompted to drag and drop a file or browse through your computer to select the file.

• You can also download a sample file which will provide you with a template in which you can fill with the test data and can be uploaded.

1. Prepare the Excel file

Before uploading, ensure that the test data file follows these guidelines:

• Column Names should match the parameter names used in the test case.

• Sequence Number must be provided for each iteration to maintain execution order.

• Data Format should be consistent (e.g., date fields, numeric values).

1. Upload the File

• Once the file is selected, click upload.

• The tool will validate the data and display a confirmation message upon successful import.

• And click Save, to save the data.

Note: To import data to a function, select function data from function module or test data management. Function data cannot be imported from within test case data.

Exporting Test Data Sets

1. Navigate to Test Data Management

• Open the User Navigation Panel.

• Go to Test Management > Test Data.

• Click on the “View Details” button of the relevant test data.

1. Export the Data

• On the top right, click the Excel Import/Export button.

• Select “Export Excel” from the dropdown menu.

• All the iterations of The data will be downloaded as an Excel file (.xlsx).

• Open the file to view or modify test data as needed.

Best Practices for Managing Test Data

• Use consistent naming conventions for parameters.

• Keep test data files updated to reflect real-world scenarios.

• Ensure data integrity by avoiding missing or incorrect values.

• Regularly export test data for backup and reuse.

By efficiently importing and exporting test data, teams can streamline their test execution and improve data-driven testing workflows in SimplifyQA.