Forums

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

Mapping issue with CSV import to update existing data

deb April 16, 2020

I am trying to update story points for a project via the Admin csv import. Here is a sample of the csv:

issue key,Summary,story points
DWT-5,,5
DWT-1,,10

On the mapping screen the below happens:

csvissue.pngWhy aren't the fields listed separately for mapping?

1 answer

0 votes
Tony Rossiter
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.
April 16, 2020

@deb 

The import/update tool will require a value in the summary field.  Can you include it in the CSV and try again?  I expect that will fix it.

deb April 16, 2020

I will try it, but why is it required? According to the documentation example  for "Update existing issues" the summary entry can be empty. Here's the examples given (see row 3)

issue key,summary,votes,labels,labels
TT-1,Original summary,1,label1,label2
TT-1,,7,label-1,label-2
TT-1,Changed summary,,,
TT-2,Original summary 2,1,label-1,label-2
TT-2,,<<!clear!>>,<<!clear!>>,   

 

deb April 16, 2020

Adding Summary value did not help:

csvissue_2.png

Tony Rossiter
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.
April 16, 2020

I can't honestly say.  I don't have any first-hand experience with this exact use case where you're updating fields for some records but not all and to get around the Summary requirement issue on most imports I just always include it.  

Hope including the summary values fixes it :D

deb April 16, 2020

Thanks, but it did not help (see above). Hopefully someone will see this who has attempted an update like this.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events