Importing Test Cases from Excel File

Introduction


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).



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.