Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Zephyr for JIRA Importer Utility - Bulk update a field (Description)

Jorden K Epps
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 25, 2020

Hello all,

I searched the knowledgebase, but didn't find a solution.

I used the JIRA Importer tool to import test cases from an Excel spreadsheet. That went well except the description didn't import. I think it was because when I added that column to my Excel spreadsheet, I left an empty column between the Description column and  the previous column that contained test case data.

I exported all of the test cases with the missing Description from JIRA/Zephyr to a .csv files. I then deleted all columns except for Issue Key and Summary (I saw another post that said that those are required fields). I then added a column named  Description with the data I want to update for each test case. I then saved the .csv file as an .xlsx file.

I've tried using the JIRA Importer to then import/update the existing test cases. I selected my Project, and Issue type "Test", my .xlsx file, clicked "Retrieve Mappings", and set my "Discriminator" to "By Test Case Name Change" (I've actually tried all options except "By Empty Row").

I then mapped as follows:

Name = Summary

Issue Key [To add steps] = Issue Key

Description = Description

I click "Import", and the Importer tool tells me that it "Created/Updated xx test cases", however when I check the test cases they are not updated. Nor do I see new test cases created.

 

What am I doing wrong?

Thanks in advance!

-JordenSample Update xls.jpgZephyr Mapping.jpgUpdate Success.jpg

1 answer

1 vote
jagadeesh madhura
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 26, 2020

Hi Jordan,

  • Your mapping is correct, I feel description field is not added to the create issue screen, please recheck once and try again 

Ref: https://zephyrdocs.atlassian.net/wiki/spaces/ZFJ0400/pages/422576142/Import

If you are still facing issue can you please raise support ticket, so that our team will check the issue 

https://support.smartbear.com/message/?prod=zephyr

Suggest an answer

Log in or Sign up to answer