/
Importing Test Suites (Executions) from Excel File
Edit

Importing Test Suites (Executions) from Excel File

 

 

Overview

You can import test suites that were previously exported from QMetry.

First, export the test suite in Excel format. Make the necessary changes in the exported file. Use the Import feature in the Test Suite module to upload the updated file back. For example, if the execution statuses for a large number of test suites have changed, the QA Manager can update the statuses in an Excel file and import it into QMetry.

Notes

  • The file size should be a maximum of 10 MB.

  • Test Suite supports only the Re-import feature.

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

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

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

You can export test suites from QMetry through Bulk Operations, which provides options to Export as XLSX and Export as CSV. Refer to Exporting Test Suites for more details.

 

Export Options and Corresponding Import in QMetry

  1. Export Test Suite(s) with Steps in Multiple Rows: When you re-import test suites, the changes in Test Case Step Execution Status and Test Case Step Comments will only be considered.

  2. Export Test Suite(s) without Steps: When you re-import test suites, the changes in Test Case Execution Status and Test Case Comment will only be considered.

 

Importing Test Suites

Download either of the following test suite execution templates and enter the data to import.

Download Template

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. Users can import the exported test suites without test case steps and update the test case executions. The test step status will be updated to the status of the test case.

  1. Select the exported Excel file containing test suite details.

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

  3. The system schedules the import process. You can view the progress in the Notification window.

Refer to Notification Window for Import Progress for more details.