/
Import from Excel
Edit

Import from Excel

 

Overview

Import requirements and test cases stored in traditional Excel or comma separated (CSV) format directly into QMetry. To perform the import, ensure you have the necessary access rights to the target project.

There are three major steps involved in import from Excel:

  1. Convert the requirement or test case file (XLS, XLSX, CSV) into QMetry field format.

  2. Import the file and map the QMetry fields and file columns.

  3. Verify the imported requirements or test cases.

 

Difference between Import and Re-import

The following table describes the difference between Import and Re-import.

Sr.No

 Component

Import 

Re-import

1

Definition

Import is the creation of test assets for the first time.

Import always creates version 1.

Re-import is a bulk modification of already created test assets. This simplifies bulk editing.

Re-importing increases the existing version by 1.

2

Supported Formats

XLS, CSV, XLSX

XLS, CSV, XLSX

3

What can be imported?

1. Requirements
2. Test Cases
3. Issues

1. Requirements
2. Test Cases
3. Test Suites - Only Executions Status


4

What is mandatory to be mapped? 

1. Summary and all mandatory fields.
2. Folder Paths if the assets are to be arranged in different folders.
3. Fields that are not mapped will be empty.

  1. Map Entity Key with ID.

  2. Summary and all mandatory fields.

  3. Map folder only if there are changes to folder path and you want to move assets from one folder to another.

  4. Unmapped fields are picked from the previous version of the corresponding test asset.

 

Also Read: