/
Importing Test Suites (Executions) from Excel File

Back to QMetry All Products Help Page

Importing Test Suites (Executions) from Excel File

Introduction

You can 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

  • You can import files up to 10 MB in size.

  • You can only re-import Excel files that were exported from ​QMetry​​.

  • The re-import of test suites is limited only to change of Execution Status and Comments.

  • The re-import feature is used to update bulk execution of test cases via excel.

  • Any updates in the fields, other than Status or Comments, is ignored.

 

Pre-Requisites

Before importing, you must first ​Export Test Suites from QMetry​​ It provides options to Export as XLSX and Export as CSV.

 

Export Options and Corresponding Import in QMetry

Export Format

Supported Re-import Updates

Export Format

Supported Re-import Updates

Export Test Suites with Steps in Multiple Rows

The system considers only changes in Test Case Step Execution Status and Test Case Step Comments.

Export Test Suites without Steps

The system considers only changes in Test Case Execution Status and Test Case Comment.

 

Downloading Import Templates

Download blank templates to structure your data before import.

Download Template

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.

  1. Select any of the following options:

    • Test Case Steps in single row: Select this option to store all the steps of a test case in a single row.

    • Test Case Steps in multiple rows: Select this option to store the steps of a test case in their individual rows.

    • Import without Steps: Select this option to import test cases without test case steps. You can 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.

  1. Select the Excel file containing test suite updates.

  2. Click Finish to close the Import wizard and start the import process.

  3. You can track the progress in ​Scheduled Tasks​​.

 

Back to QMetry All Products Help Page