Preparing the Data to Import Test Cases
How to Import User(s)
Learn how to import users into QA Touch
Data Migration Testlink
Migrate data from TestLink into QA Touch
Requirements Import
Import project requirements quickly and easily
Modules Import
Import modules/sections into your QA Touch project
Test Cases Import
Learn how to import test cases from other tools
Test Cases Import Bulk Update
Bulk update and import multiple test cases at once
Data Migration TestRail
Migrate your TestRail data into QA Touch
Objective:
Converting test cases written in google sheets to an uploadable format supported by QATouch with help of a script.
Why use a script?
The current test case has the below limitations and needs to be formatted in a way that is compatible with QATouch migration.
Please download APP Script Code
Existing Test Case Template (Limitations):
- Every step added is entered in the next new cell.
- We do not mention the Module name for the test case.
- Merged rows are present in between the test cases.
- Test name column allows duplicate values.
The existing Test Case Step Template
QATouch Supported Format (Expected):
- Module and test case name field is mandatory in the tool.
- All field values of a test case should be on a single cell.
- Merged rows are not accepted.
- Test name field won’t allow duplicate values.
QA Touch Template
Script logic:
The script will identify the row type of each row using the following conditions.
| Rowtype | Conditions | Action |
|---|---|---|
| Empty | All columns are empty | No Action |
| Header or Comment | If ID(col-1) OR TestName (col-2) OR Test description(col-3) OR Test tags (col-4) has any value (not empty) | Delete that row |
| Test Steps | Test Name & Description is empty & (Either Steps/Result is not empty) | Add row id to the array |
| Test Case Start | Test Name & Description is NOT empty & (Either Steps/Result is not empty) |
|
Please download APP Script Code
Excel sheet - APP Script
Here you can download the script Copy and Paste APP Script Code in the editor.
If you getting above error message, need to add a Service,
- Click Services enable “Google Sheets API”
- Click Save button
Success message