/
Importing Test Cases

Importing Test Cases

Owned by Donal Cheung (Unlicensed)
Jul 06, 2016

Download ZFJ Importer (jar file) - https://bitbucket.org/zfjdeveloper/zfj-importer/downloads

 

How to use ZFJ Importer - https://bitbucket.org/zfjdeveloper/zfj-importer/wiki/Home

 

Matching Excel Columns to JIRA Fields. * required Columns

 

If you are importing multiple sheets from one excel document, make sure the columns on each sheet are the same. Example: Test Case ID is on column A for all sheets.

 

 

JIRA Field

Excel Column

Name*

This will be the name of the test cases. Example: Test Scenario/Summary

Step*

Test steps.

Result*

This is the expected results

Testdata*

Test data.

ExternalId*

An ID field is required. If there isn’t one in the excel doc just make a column with numbers 1 to N. For test cases with multiple steps just use the same ID for the extra rows.

Labels

Labels. No spaces are allowed so use _ for spaces.

Comments

Comments/Notes

Versions

Version - Need to exist on JIRA already

Components

Components - Need to exist on JIRA already

Priority

Priority – Highest, High, Medium, Low, Lowest. The default is Medium if left blank

Assignee

Leave blank if Unassigned

Description

Description.

Due Date

Due Date

Issue Key* (Required for accurate import)

Issue Key will be “Test”. Must Include or else the import will not be accurate.

 

 

Sample Excel Test Case:

https://docs.google.com/spreadsheets/d/1TDfVIUPp_hSFVpavqLr1DXeN_5_i_h4MdNcVWPMR-UM/edit?usp=sharing

Notes:

  • The ZFJ Importer can allow you to import test cases with test steps but does not have the functionality to update existing test cases in Jira.
  • Versions and Components must be defined on Jira before you can import them. You must also add Components to the test screen by going to the cogs icon on the top right and click projects. Then select “Screens” tab and click on Create issue screen. You can add Component/s to the list.
  • It is recommended to use By Empty Row as the Discriminator since test cases may have the same name and test cases with multiple steps causes errors for By ID Change. If the excel document does not have empty rows in between the test cases then you can add them in. Google how to enter empty rows excel sort function.
  • Required Columns can have blank fields but it will show up on Jira as null.
  • Sometimes the importer bugs and says success but does not actually import. Clicking the Connect button again and then selecting the project and issue type again usually works. Otherwise you may have to restart the importer.
  • Depending on the number of test cases, the importer can take a while to import everything. When the Start Import button is not grey anymore that means it’s finished.

 

Filter by label

There are no items with the selected labels at this time.