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.

• By default, all data iterations will be exported and downloaded as an Excel file (.xlsx).

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

Note: When exporting test data that includes functions, the Excel file will contain separate sheets for better organization. Parameters at the test case level will appear in the “TC” sheet, while each function will have its own dedicated “FN” sheet, making it easy to manage and review complex data sets.

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.