Importing Test Cases
Filling in a Test Case Import File
Importing test cases via an Excel file allows you to mass create or mass modify a portfolio of tests. You can import test cases and their attributes, settings, and datasets, as well as their links to requirements.
This feature is very useful:
- during a migration from a third-party tool;
- to retrieve a portfolio of tests from a document;
- to mass modify test cases already in Squash TM.
You can import test cases from .xls, .xlsx, .xlsm, and zip files.
Info
The import feature is only available for "Admin" and "Project Leader" profiles.
You can download an import template for Excel and .Zip files from the import pop-up in the Test Cases workspace.
Focus
You cannot import BDD test cases.
You cannot modify a test case format (Standard/Gherkin/BDD) through importing.
Excel Import File Structure
The import file is composed of five tabs:
- The TEST_CASES tab contains information related to the test cases to import such as location, description, importance, etc.;
- The STEPS tab contains information related to a classic test case's test steps.;
- The PARAMETERS tab contains information related to a test case's parameters;
- The DATASETS tab contains information related to datasets;
- The LINK_REQ_TC tab contains information to link test cases to requirements that already are in Squash TM.
Focus
The import file must follow these rules:
- The name of the 5 tabs must not be changed;
- The headings of columns must not be changed;
- The blank rows must not be interpreted;
- The cells must not be merged;
- The order of the rows does not matter;
- The import is done row by row.
TEST_CASES Tab
Column name | Description | Expected value |
---|---|---|
ACTION | Value that indicates the action you want to perform. | Required Field C: to create (Create) U: to update (Update) |
TC_PATH | Test case path. It starts with "/project name" and ends with the test case. It includes the name of the project because the import is cross-projects. | Mandatory Field For example: - /project/folder/testcase |
TC_NUM | Test case position in its folder. - CREATE Mode: if not entered, considered as the last item of the folder. If entered, the case test is created at that position. - UPDATE Mode: if not entered, information is ignored. If you enter a position number that is different from the current order, the test case is moved to that different position. |
|
TC_UUID | Test case Universal Unique Identifier - CREATE Mode: if entered, the test case is created under this UUID. If not entered, the test case is created with an auto-generated UUID. - UPDATE Mode: the value of the TC_UUID is not considered. You cannot modify a case test's UUID when it is already in the database . |
If entered, the value of the TC_UUID column must match the regular expression: [0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12} |
TC_REFERENCE | Test case reference | |
TC_NAME | Test case name. - CREATE Mode: the field is ignored. - UPDATE Mode: allows you to rename a test case |
|
TC_MILESTONE | Name of the milestone(s) related to the test case. If an object is linked to several milestones, each of the milestone must be entered in the matching column, separated with a "|". UPDATE Mode: if the column is blank, the existing links will be deleted. |
For example, if a test case is related to two milestones: Milestone1|Milestone 2 |
TC_WEIGHT_AUTO | If, during the import, the value is at "1", Squash TM deduces the weight of the test case according to its related requirements, including the requirements related to called test cases If the column or the value is not entered, the default value taken into account is "0". |
- "1" : If the weight calculation is automatic - "0" : If the weight value is manually entered. |
TC_WEIGHT | Test case weight code. If TC_WEIGHT_AUTO = 1, the indicated value for TC_WEIGHT is ignored. |
- VERY_HIGH - HIGH - MEDIUM - LOW [Default value] |
TC_NATURE | Test case nature code | - NAT_ATDD - NAT_BUSINESS_TESTING - NAT_FUNCTIONAL_TESTING - NAT_NON_FUNCTIONAL_TESTING - NAT_PERFORMANCE_TESTING - NAT_SECURITY_TESTING - NAT_UNDEFINED [Default value] - NAT_USER_TESTING |
TC_TYPE | Test case type code | - TYP_COMPLIANCE_TESTING - TYP_CORRECTION_TESTING - TYP_END_TO_END_TESTING - TYP_EVOLUTION_TESTING - TYP_PARTNER_TESTING - TYP_REGRESSION_TESTING - TYP_UNDEFINED [Default value] |
TC_STATUS | Test case status code | - APPROVED - OBSOLETE - TO_BE_UPDATED - UNDER_REVIEW - WORK_IN_PROGRESS [Default value] |
TC_DESCRIPTION | Test case description | |
TC_PRE_REQUISITE | Test case prerequisite | |
TC_CREATED_ON | Test case creation date. Dates are exported in date cells or cells in ISO 8601 format. | Format: YYYY-MM-DD If the date is not entered, the current date is used. |
TC_CREATED_BY | Creator login. | If not entered, the login of the user who did the import is used. |
TC_KIND | Test case format code If not entered, the test case is imported as a standard test case. |
Format : - STANDARD - GHERKIN - KEYWORD (BDD) |
TC_SCRIPT | Test case Gherkin script | |
TC_AUTOMATABLE | Eligibility to the automation of the test case | - M : To instruct [Valeur par défaut] - Y : Eligible - N : Non eligible |
TC_CUF_<cuf's code> | One column by custom field. In the heading, replace <cuf's code> by the custom field's code. |
Value linked to the custom field |
STEPS Tab
Column name | Description | Expected value |
---|---|---|
ACTION | Value which indicates the action to perform. | Mandatory field C: to create (Create) U : to update (Update) |
TC_OWNER_PATH | Path to the test case that owns the test step. | Mandatory field For example : - /project/folder/testcase |
TC_STEP_NUM | Position number of the test step (starts at 1) For the import, the numbers do not have to be consecutive: the relative order between the different TC_STEP_NUM is used. If two test steps have the same position number or if there is no value, the order of apparition in the file is used. |
|
TC_STEP_IS_CALL_STEP | To indicate whether this test step is an action or a called test case. | - "0" if the step is a test step [Default value] - "1" if the step is a called test case |
TC_STEP_CALL_DATASET | This column is only taken into account if TC_STEP_IS_CALL_STEP = "1" | - "INHERIT" if the chosen option is to not choose a dataset, the calling test case inherits the settings of the called test case - <NAME> : names the chosen dataset |
TC_STEP_ACTION | - Step action - Or path towards the called test case |
For example, for a test case call: CALL /project/folder/called_TC_name |
TC_STEP_EXPECTED_RESULT | - Step expected result - If STEP_IS_CALL_STEP = 1, this column is ignored |
|
TC_STEP_CUF <cuf's code> | One column per custom field. In the heading, replace <cuf's code> by the test step's custom field code. | Value linked to custom field |
PARAMETERS Tab
Column name | Description | Expected value |
---|---|---|
ACTION | Value that indicates the action to perform. | Mandatory field C: to create (Create) U: to update (Update) |
TC_OWNER_PATH | Path towards the test case that owns the parameter | Mandatory field For example: - /project/folder/testcase |
TC_PARAM_NAME | Parameter name, must only contain the following characters: [0-9], [a-z], [A-Z] et [-,_]. | Mandatory field |
TC_PARAM_DESCRIPTION | Parameter description |
DATASETS Tab
Column name | Description | Expected value |
---|---|---|
ACTION | Value that indicates the action to perform. | Mandatory field C: to create (Create) U : to update (Update) |
TC_OWNER_PATH | Path to the test case that owns the dataset. | Mandatory field For example : - /project/folder/testcase |
TC_DATASET_NAME | Dataset name | Mandatory field |
TC_PARAM_OWNER_PATH | Path to the test case that owns the parameter. This column is needed for parameters from test cases called by the dataset owner test case. | |
TC_DATASET_PARAM_NAME | Name of the parameter for which the value is entered. It must only contain the following characters: [0-9], [a-z], [A-Z] et [-,_]. During the import, if there is no matching parameter, the value is ignored. | Mandatory field |
TC_DATASET_PARAM_VALUE | Corresponding value for the specified pair {dataset | parameter}. |
LINK_REQ_TC Tab
To link test cases to requirements already in the repository, the 3 fields are mandatory.
Column name | Description | Expected value |
---|---|---|
REQ_PATH | Requirement path from the project name to the requirement name (current version) NB: Current version name can differ from version to link name | For example: - /project/folder/requirement - /project/PARENTrequirement/CHILDrequirement |
REQ_VERSION_NUM | Requirement to link number | |
TC_PATH | Test case path from project name to test case name | For example: /project/folder/testcase |
Info
With an Excel import, you can format all rich text fields such as the desription or test steps by using HTML tags.
Structure of the .Zip Import File
The .zip file contains the folders, subfolders, and the entirety of the test cases to import.
For each test case to import, you must create an Excel file. Each file must contain a tab with the test case's information. The tab name must match the test case to import name.
These files must be in their corresponding folders so that test cases are imported at the right location in the library of the test case's workspace.
For example:
- To import 10 test cases, you need 10 Excel files.
- To import a test case in a folder entitled "Folder1": you must create a folder entitled "Folder1" and in that folder, put the Excel file which contains the information of the test case to import. Zip the folder for import.
Focus
A .zip import does not allow you to import Gherkin and BDD test cases;
With a .zip import, you can only import one project at a time;
With a .zip import, you can create only new test cases;
A .zip import does not allow you to import parameters, datasets, and test case links.
A test case's Excel file tab must contain the following tags in this order:
Tag | First value | Second value | Comment |
---|---|---|---|
Description | Enter the test case description. | This data will be in the test case's "Description" field | |
Importance | Enter the importance of the test case by choosing one of the following normed values: - VERY_HIGH - HIGH - MEDIUM - LOW. |
This data will be in the test case's "Importance" field | |
Created_by | Enter the creator's login | This data will be in the test case's "Created by" field. | |
Created_on | You can either enter the date (including the hour) in a date cell or in a text cell in the DD/MM/YYYY format. | This data will be in the test case's "Created by XXX on " field | |
Action_step | Enter the action to perform. | Enter the expected result. | Each time this tag is present, a new test step is created. Test steps are created in the file's order (from top to bottom). |
Prerequisite | Indicate the information to add in the test case's "Prerequisite". | If several ranks of the Excel file are filled in with this tag, the different values are concatenated in the "Prerequisite" field. |
For example:
The test case information is in the first tab. This tab's name is the same as the test case's "Test case 1".
Test Cases Imports Case Studies
Squash TM allows you to import a tree of test cases from a .xls or .zip file.
To perform this import, you must fill in an Excel file and follow these recommendations Excel import file structure then import it by using the Import option in the Test Cases workspace. You can simulate the import to verify the coherence of the import file before importing it.
Learn more
For more details on the steps to follow to perform an import, please visit this page: Import an object.
Importing allows you to create test cases with all the features available in the Test Cases workspace.
Creating a Tree of Test Cases
The tree is very important because it allows you to organize the tests repository. Importing allows you to create a precise tree of the folders and test cases to import in several projects at once.
If the folders are not in Squash TM during the import, they are created by the import.
For example:
For the path: /Project1/Folder1/Subfolder1/Testcase1
Testcase1 is added to Project1, in Subfolder1, located in Folder1.
Importing test cases with a custom list
If a custom list is set up for the nature and/or the type of test cases in the project, in the import file, you must enter the desired option code in the columns "TC_NATURE" and/or "TC_TYPE"
For example:
- To have a custom list with several options, including one, "Nature2", linked to the code "N2".
- In the Excel file, enter the value of the option code in the column "TC_NATURE": in this case "N2".
- When the file is imported, the test case is created and the "Nature" field is filled in with "Nature2"
Importing Test Cases with Custom Fields
If custom fields (CUF) are set up for the project's test cases, in the import file, you can fill in the column "TC_CUF_
"TC_CUF_<cuf code>" Column Content:
Custom field type | Expected value |
---|---|
Tag | Tag1|Tag2 |
Checkbox | 'true' or 'false' |
Drop-down menu | Option tag |
Numérique | For example : '50', '12,8' |
Numerical digit | 'YYYY-MM-DD' |
Simple text | Unformatted text with 255 characters maximum |
Rich text | To import the formatted text, it must be in HTML format |
Importing Test Cases with Links to Requirements
The "LINK_REQ_TC" tab of the import file must be filled in with the requirement path, the version number, and the path of the test case to link. For the linking to work, the requirement must already be in the repository.
The information is visible after the import in the test case's anchor Requirements verified by this test case.
Importing test steps
The "STEPS" tab allows you to import test steps for a Standard test case. The step's number, action, and expected result are entered in the file.
Import using parameters and datasets
The tabs “PARAMETERS” and “DATASETS” enable you to import parameters and datasets to a test case. You can also add the parameter directly to the test step using the “STEPS” tab.
For example:
For a test case on the connection to an app, you can import the 2 parameters "Login" and "Password", as well as the 3 datasets corresponding to the connection of 3 different profiles: "Admin", "Project Leader", and "Guest".
Learn more
To know more about parameters and datasets, please visit the page: Variabilising classic test case.
Importing a test case calling another test case
Enter the calling test case in the "TEST_CASES" tab. Then, in the "STEPS" tab, fill in the following columns:
- In the "TC_STEP_IS_CALL_STEP" column, enter the value "1" to indicate that this test step is a test case call.
- In the "TC_STEP_ACTION" column, enter the following information: "CALL <called test case path>. (For example: CALL /project/folder/called-tc)
- You do not have to fill in the "TC_STEP_EXPECTED_RESULT" column.
Info
If the called test case is not in the test repository, it must be in the "TEST_CASES" tab in the import file.
Learn more
To know more about test cases calls, please visit the page: Modularising : Call a third-party test case.
Importing a Gherkin Test Case with a Script
To import a Gherkin test case and its script, you must fill in specific columns in the "TEST_CASES" tab:
- "TC_KING" Column: GHERKIN
- "TC_SCRIPTING_LANGUAGE" Column: The test case Gherkin script
Focus
You cannot import BDD test cases.