Importing Test Suites from Excel

Re-import test suite execution data into QMetry using an Excel file previously exported from the system. This feature allows you to update execution status and comments in bulk, especially for projects with a high number of test cases.

Note

  • Import files up to 10 MB in size.

  • Re-import Excel files that were exported from QMetry.

  • Re-import of test suites is limited to change of Execution Status and Comments updates.

Pre-Requisites

Before importing, Export Test Suite Execution data from QMetry.

Export and Import Behavior

Table 18. Importing Test Suites

Export Format

Support Re-Import Updates

Export Test Suites with Steps in Multiple Rows

Considers only changes in Test Case Step Execution Status and Test Case Step Comments.

Export Test Suites without Steps

Considers only changes in Test Case Execution Status and Test Case Comment.



Downloading Import Templates

Download blank templates to structure your data before import.

Make sure to fill in only Execution Status and Comments to ensure successful re-import.

Importing Test Suites

To import test suites into QMetry, perform the following steps:

  1. Go to the Test Suites module.

  2. Click the Cog (⚙️) icon and select Import.

  3. Select one of the following options.

    QPro_TS_Import
    • Test Case Steps in single row: Store all the steps of a test case in a single row.

    • Test Case Steps in multiple rows: Store the steps of a test case in their individual rows.

    • Import without Steps: Import the exported test suites without test case steps and update the test case executions. The system updates the test step status to the status of the test case.

  4. Select the Excel file containing the test suite updates.

  5. Click Finish.

  6. Track Import progress from scheduled tasks.

Publication date: