Importing Test Suites (Executions) from Excel File
Overview
You can import test suites that were previously exported from QMetry.
To do this, first export the test suites into an Excel file. After making the necessary updates in the exported file, you can re-import it. The Import feature within the Test Suite module makes it easy to bring the updated data back into the system.
For example, there are a large number of test suites with updated execution statuses. The QA Manager can update the statuses directly in the exported Excel file. By importing the modified file back into QMetry, the execution statuses are updated automatically.
Notes
The Test Suite module supports only the re-import feature; it does not support fresh import.
It is different than Requirement or Test Case import. The re-import of test suites only supports updating Execution Status and Comments.
Best Practice: To carry out the import process smoothly, it is recommended that the size of the file you upload should be a maximum of 10 MB.
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
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.
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.
Steps to Import Test Suites
To import test suites, perform the following steps:
Go to the Test Suites module.
Click on the settings icon on the toolbar and select Import.
It opens the QMetry Import screen to import Test Suites. Select the exported Excel file containing test suite details.
Select either of the options as required:
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.
Click Finish to close the Import wizard and start the import process.
After completing the import wizard process, the import will be scheduled. You can view the progress in the notification window on the application header. This allows scheduled imports to run in the background and allows the user to continue with their other work.
Refer to Notification Window for Import Progress for more details.