Back to QMetry All Products Help Page
How to import/re-import test cases using Excel?
Introduction
QMetry allows users to import test cases from an Excel file to create new test cases as well as to make changes in existing test cases in QMetry. Two separate Test Case templates are available to download and set your test case data within corresponding template file:
Test Case with Test Steps in Single Row
Test Case with Test Steps in Multiple Rows (steps in individual rows)
The import wizard helps users import test cases directly into particular folders/sub-folders of the Test Case modules under current project.
The test cases are imported in the same order that of in the Excel file, following are some of the reasons behind it.
1. In the organization test cases are ordered to produce the most efficient test flow. Hence, the QA Manager wants that the test case import order match the excel sheet.
2. A user creates a series of test cases in a logical order to be tested, one after another- and after creating those test cases the users wants to import the excel file with the test cases in the same order as they are found in the excel file allowing them to be easily added to a test suite in the same order.
Best Practice: To carry out the import process smoothly, it is recommended that the size of file you upload should be maximum of 10 MB.
First time Import of Test Cases from Excel File
First Time Import is when the organization does not have test cases in QMetry and they import test cases for the first time. This Import is creation of test assets for the first time. Import always creates version 1.
Convert Test Case data into QMetry Format
Download either of the Test Case templates provided below. Fill the template with your test case data that you want to import into QMetry. Enter comma separated values for fields with multi-lookup list. Make sure that all the columns in the Excel file have a corresponding field in QMetry. Majority of the columns in the Excel file should map to one of the QMetry fields. If there are columns which don’t really map, define those additional fields as Manage Fields in QMetry (Administration > Manage Fields).
Download Template
TestCases with Steps in Multiple Rows.xlsx
TestCases with Steps in Single Row.xlsx
Note: The import will exclude any Graphs, Filters, Merge Cells and HTML Tags that exist in the Excel file.
Re-import of Test Cases from Excel File
Users can export test cases from QMetry, make required changes in the Excel file and re-import the file into QMetry. This re-import will update the existing test case details in QMetry. Re-import of test cases allows users to do bulk modification of already created test cases via excel. Re-import increases the existing version by 1.
You can export test cases from QMetry through Bulk Operations which provides options to Export as XLSX and Export as CSV. Refer to Exporting Test Cases for more details.
Back to QMetry All Products Help Page