PawelWiki

Migrating test cases is not an easy task, if you follow the steps below, you should be successful. Reference from:

Import

Search Executions

Step 1: Create filter on source for the project that you're exporting test cases for, name it as “migration ABC tests”

Step 2: Open project and create single test cycle with all the test cases:

a) Tests → Plan Test Cycle

b) Create Cycle (+ button) → give it a name such as “Migrated API Tests” (used in step 3b)

c) Click the 3 dots button → Add Tests

d) Select “Via Search Filter” enter the name of the filter you created in Step 1 and click the “Add” button

e) Verify that you have the right amount of test cases in your test cycle.

Step 3: Export test executions to CSV

a) In the project, go to Tests → Search Test Executions

b) Perform a ZQL search as follows: cycleName = “Migrated ABC Tests” (—name comes from Step 2b)

c) Click Export (button) → CSV

d) Give short meaningful name (there is a character limit on sheet length, I recommend names no longer than 12 characters) ex. ABCExport.csv

Step 4: Since Description does not come through, it has to be copied in manually, follow the steps below:

a) go to Issues → Search for Issues

b) load up the filter from Step 1

c) Open the CSV file from Step 3 in Excel

d) Create empty column in column E

e) Add the field name Description in first row of column E

f) For each FIRST row of Issue Key (column C) type description from filter into the spreadsheet

g) For any fields that don't have anything, you need to put something, I recommend N-A

Step 5: Save the CSV file, then convert to XLS by going to File → Save As → Select Excel 97-2003 Workbook (*.xls)

Step 6: Load up destination jira server project

Step 7: Tests → Importer (if you don't see Importer, you need to enable ZAPI API in Zephyr Plugin version 4.0 and above)

Step 8: Select the following for options:

a) Project - Project name where you're importing to (ABC)

b) Issue Type - Test

c) File Type for Upload - Excel

d) Link type & Link - leave blank

e) Discriminator - By Test Name Change

f) Select file to Import - browse for the file you're importing (xls file)

Step 9: Once the file is selected, click the “Retrieve Mapping” button - you should see Excel Fields on the bottom right that you will map to the fields on the left

Step 10: Map mandatory fields in order to get the test cases:

a) Name - Test Summary

b) Step - Step

c) Result - Expected Result

d) Testdata - Test Data

Step 11: Optionally map additional fields as needed. Note for example “Component/s” must exist in project to match. They will not be created. We are mapping the following:

a) Priority - Priority

b) Component/s - Component/s

c) Comments - Comment

d) Description - Description (from Step 4)

e) Fix Version/s - Version

Step 12: Click “Import” button

Step 13: Verify if all was successful, if not review the logs

Step 14: Load up issue search, and find issues you just imported Issues → Search for issues → search using JQL: project = ABC and issuetype = Test

Step 15: Verify that all data was migrated properly - pick and choose certain criteria

Step 16: Create Cycle (see above for steps) and add the test cases to that cycle