Importing Test Suites - Test Case Execution Run from Excel/CSV
Update execution data in bulk by re-importing an XLSX or CSV file previously exported from QMetry. You can update the execution status and the Test Run user-defined fields (UDFs) in bulk, which helps when a project has a large number of test cases.
Note
You can import files up to 10 MB in size.
You can only re-import files exported from QMetry.
Provide values for all mandatory Test Run UDFs in the import file. Leaving a mandatory Test Run UDF blank in the import file causes the import to fail. To view the failure details, go to Scheduled Tasks.
Values for optional UDFs can be present or blank. The import continues in both cases.
You can only use list values that already exist in QMetry. The import doesn’t create new values.
If a value doesn’t match an existing list value:
For a mandatory UDF, the import fails with an error.
For an optional UDF, QMetry ignores the value
If any column header changed, the import fails.
UDFs are read-only once a run is In Review or Closed.
Prerequisites
Before you import, Export Test Suite Execution from QMetry in a format that supports re-import. In the export, select the option that includes the columns and unique IDs required for re-import.
To include Test Run UDFs in the file, export with All Fields from the Test Suite list, or export from the Test Execution screen.
Export with Visible Fields from the Test Suite list excludes Test Run UDFs, so you can’t update them through import.
Export and Import Behavior
Export Format | Support Re-Import Updates |
|---|---|
Export Test Execution with steps in multiple rows | Considers changes in Test Case Step Status, Test Case Step Comment and Test Run UDFs. |
Export Test Execution with steps in single row | Considers changes in Test Case Step Statu, Test Case Step Comment and Test Run UDFs. |
Export Test Execution without steps | Considers only changes in Test Case Status and Test Run UDFs. |
Import Templates
Download the templates to structure your data before import.
Note
Import with Steps in Single Row or Multiple Rows: Update only the Test Case Step Status, Test Case Step Comment and Test Run UDFs. QMetry ignores changes to all other columns during import.
Import without Steps: Update only the Test Case Status and Test Run UDFs column. QMetry ignores changes to all other columns during import.
Importing Test Suites
To import test suites into QMetry, perform the following steps:
 |
Go to the Test Suites module.
Click the Cog (⚙️) icon and select .
Select one of the following options.
Test Case Steps in single row: Store all the steps of a test case in a single row.
Test Case Steps in multiple rows: Store the steps of a test case in their individual rows.
Import without Steps: Import the exported test suites without test case steps and update the test case executions.
Upload the Excel file containing the test suite updates.
Click .
Track Import progress from scheduled tasks.
Track the Import and Download the Log
To track import progress or trace import failure, do the following:
Select the Scheduled Tasks icon.
Check the status of the import task. The task shows success, failure, errors, and warnings.
To review problems, download the
log filefor the task. The log lists the Row, Cell, Type, Description, and Sheet Name for each failure or warning.