Back to QMetry All Products Help Page
Importing Test Suites (Executions) from Excel File
Introduction
You can import test suite details 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.
Note
The file size should be maximum of 10 MB.
Test Suite supports only the Re-import feature.
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.
You can export test suites from QMetry through Bulk Operations. It provides options to Export as XLSX and Export as CSV. For more details on exporting test suites refer to Exporting Test Suites
Export Options and Corresponding Import in QMetry
Export Test Suite(s) with Steps in Multiple Row: When you re-import, only the changes in Test Case Step Execution Status and Test Case Step Comments are considered.
Export Test Suite(s) without Steps: When you re-import, only the changes in Test Case Execution Status and Test Case Comment are considered.
Importing Test Suites
Download either of the following test suite execution templates and enter the data to import.
To import test suites into QMetry, perform the following steps:
Go to the Test Suites module.
Click the cog icon and select Import.
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.
Select the exported excel file containing test suite details.
Click Finish to close the Import wizard and start the import process.
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.
Back to QMetry All Products Help Page