Introduction & contents
This document describes what kinds of test information users can import from qTest into TestRail, how to export that data from qTest, and the steps they need to take to prepare and import that data into TestRail. And also describes what data can and cannot be imported, and offers workarounds for situations where data can't be imported into TestRail.
For sample export/import files, download this attachment.
Features & limitations
TestRail supports importing test cases with all the supported fields, from header fields, to template fields, including separated test steps and custom fields, via CSV.
The table below enumerates the data that is supported when importing test cases via CSV and the limitations. While TestRail doesn’t support adding custom fields for separated test steps, we will guide you through how to import the values contained in these fields to the “Additional step information” field, so you won’t lose your data.
To import Test Cases with custom fields from qTest to TestRail, matching custom fields must be created in TestRail first.
Exporting test case data from qTest
qTest supports exporting test cases in Excel format from the Test Design page. To do so, select the folders you want to export, click Export Test Case Reports and then Test Case Detail report.
This will display the Export Test Case dialog, where you can select the fields you wish to include in your Excel export file for the migration. We also recommend checking the Merge test cases into one sheet option in order to import all test cases to TestRail in one go. After selecting the fields, click the OK button on the bottom of the dialog and the download will be initiated.
Processing test case data
In case you exported multiple modules and want the test cases to be created in separate sections accordingly, you need to unmerge the cells and fill the unmerged cells with the same value. How you do this depends on the tool you are using, but you should achieve a result similar to the image below.
After finalizing this process and any other changes you see necessary to your Excel files, you just need to save them as CSV in order to import your test cases to TestRail.
Importing test case data into TestRail
All the fields from qTest test cases can be mapped to TestRail fields as per the table below. For fields that may not exist by default in TestRail, you can create a new custom field to map your data to.
|qTest CSV columns||TestRail fields|
|Test Step Description||Section|
|Test Step Expected Result||Priority|
|Custom Field 1||CUSTOM FIELD|
* Status is a TestRail Enterprise only feature which allows managing test case design approval. If you are on an Enterprise license, you can customize the Status field values to match the qTest statuses in Administration > Customizations > Case Statuses. If you are not on an Enterprise license, you can create a custom field to map these values in Administration > Customizations > Case Fields.
Importing test case data into TestRail is very straightforward. Just navigate to the project you want to import the test cases to and follow the steps below.
- Navigate to the Test Cases page
- Click the Import Cases icon on the top of the page and select Import from CSV
- On the first step of the import dialog:
- Select the CSV file you want to import
- Select the Section you want the file to be imported to
- Set the CSV delimiter to be a comma (or the delimiter you used when saving the file)
- Set the Start Row to 1
- Set the Template to Test Case with Individual Steps
- Click Next
- On the second step of the import dialog:
- Set the Row Layout to Test cases use multiple rows and
- Set the Column to detect new test cases value to Name
- Map the CSV columns to TestRail fields (you can see a simple example on the image below)
- Check the option Ignore test cases/records without a title
- Click Next
- On the third step of the import dialog:
- Select Remove HTML tags from CSV values for all fields
- Map the values from dropdown fields to the respective value in TestRail
- Click Next
- On the fourth and last step of the import dialog:
- Confirm the information processed by TestRail is as expected
- Click Import
Viewing imported data in TestRail
You should now see your imported test cases as per the image below.
By opening one of the test cases, you should be able to see the data was correctly imported, as per the image below.