Importing Test Cases

As a Project user, you can import Test Cases in your Jira project only if you have one of the following permissions.

  1. ADMINISTER PROJECTS,
  2. BULK CHANGE,
  3. DELETE ISSUES

A CSV delimited or XLSX file is required when importing data.

Prepare your CSV File

Start by preparing a CSV file to Import (see sample file which you can download)

Below is an example file that has been prepared.

The main thing to take note of is ‘Link Requirement’ is a column to identify which Asset you wish to Link your Test Case to when you import them in Jira.

The following fields can be included in the CSV file. HEADLINE and CASE TYPE being the mandatory fields.

HEADLINE
CASE TYPE
DESCRIPTION
PRIORITY
STEP ID
STEP
TEST DATA
EXPECTED RESULT
LABELS
COMPONENT
LINKED TEST CASE(S)
LINK REQUIREMENT (ISSUE)
LINK REQUIREMENT (TEST FOLDER)
PLAIN TEXT
Bdd-GERKIN

Vansah supports linking Test Cases to

A Jira Issue

A Test Folder and 

Other Test Cases

If you wish to Link your Test Case to multiple Requirements, simply include the Jira Issue Keys or Test Folder paths as a comma delimited inside the Link Requirement cell.

Example: The following will link the Test Case to your Test Folder based on the folder tree path and the two Jira Issue Keys (TD-90 and TD-87)

Link Requirement = TD/e2end test plan (release)/2 issue linked burnup chart/, TD-90, TD-87

To get the folder path of a Test Folder

1. Simply expand the Folder inside your Test Repository folder tree.

2. Click on the Folder Name to copy its path to your clipboard.

 

1. Include a new column in your import file titled “LINKED TEST CASE(S).”

2. In this column, provide the Test Case Key that you want to link to the new Test Case, along with the associated Project Key, separated by a hyphen.

For Example, 

To link the new Test Case with existing Test Cases C1 and C2 from the NPT Project (Project Key: NPT), enter “NPT-C1” and “NPT-C2” in the LINKED TEST CASE(S) column, as illustrated in the image below.

Start the Import Process

  1. Log in to Jira with an administrator account or a user with “Bulk Change permission
  2. Go to Vansah >  Settings 
  3. Select Data > Import Cases
  4. Drop a file or Choose a file
  5. Click Next
  6. Map File Fields to Vansah Fields

          7. Click Next to validate all provided columns have been mapped appropriately.

          In case of any changes, a user may choose to click Back button and change the given file.

          8. Click Next to see the final Result.

          A success message will be displayed.

          8. Go back to Test Cases screen and refresh the page to see your imported Test Cases.

          Related Articles