nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CSV Import won't update Issues, log shows "Only new items will be imported"

Lenn Bond

I am using the "system JIRA import wizard" to update existing issues. My import CSV has 3 fields - key, summary, created.

In the Setup step I am selecting the project (rather than "Defined in CSV").

In the Setup step I am defining the date format to be dd/MM/yy HH:mm

If the Fields step I see the message "You have selected Issue Key mapping. Please note that importer will update existing issues matching the Issue Key from the CSV file."

(this is what I want!)

In the Fields step I map summary>Summary, created>Date Created, key>Issue Key

I then check each of the "Map Field Value" checkboxes

In the Values step everything matches up, so I just click <Begin Import>

The import completes with the message "1 projects and 0 issues imported successfully!"

When I look in the log I see:

2019-11-01 20:12:18,181 INFO - ------------------------------
2019-11-01 20:12:18,182 INFO - Importing: Issues
2019-11-01 20:12:18,182 INFO - ------------------------------
2019-11-01 20:12:18,182 INFO - Only new items will be imported
2019-11-01 20:12:18,195 INFO - Importing issue: [externalId='autoid-1950990744408516289', summary='60002 - CERTIFICATE - Certificate of Automobile Insurance - Newfoundland and Labrador - English Only']
2019-11-01 20:12:18,233 INFO - Importing issue: [externalId='autoid-8833976040596730003', summary='60005 - CERTIFICATE - Certificate of Automobile Insurance - Prince Edward Island- English Only']
2019-11-01 20:12:18,255 INFO - Importing issue: [externalId='autoid--8219133826194254816', summary='60007 - CERTIFICATE - Certificate of Automobile Insurance - British Columbia - English only']
2019-11-01 20:12:18,287 INFO - 0 out of 3 issues successfully created

Why does it indicate "only new items will be imported" when in the prior step it said "importer will update existing issues matching the Issue Key"?

My Issue Keys perfectly match existing Issues - why did it not update them?

Accepted answers

mrcrandell.sw

try making the summaries in the csv null. Keep the column, just leave the values empty. I have had better success that way. Also the log doesn’t say anything specific about “issue updated” but when you go look at the actual issue, the fields are updated.

All comments

mrcrandell.sw

Lenn Bond

Leaving Summary as null seems to be the secret....importing via update worked as expected by doing this. Thanks!

Brian Sweet_6iukj0

I'm having the same problem. My goal is to add a resolution date to completed issues that didn't have their workflow configured properly.

Here's my CSV (using this issue as a test):

Issue key,Summary,Resolved
BS-15,,"Aug 09, 2019 3:04 PM"

As you can see, the summary field is blank for this issue, yet the log still says:

2020-02-13 20:41:50,747 INFO - ------------------------------
2020-02-13 20:41:50,747 INFO - Importing: Issues
2020-02-13 20:41:50,747 INFO - ------------------------------
2020-02-13 20:41:50,747 INFO - Only new items will be imported
2020-02-13 20:41:50,776 INFO - Importing issue: [externalId='autoid--7511088372789587672', summary='null']
2020-02-13 20:41:50,944 INFO - 0 out of 1 issues successfully created

Not sure what to try next...

mrcrandell.sw

@Brian Sweet make sure the following:

You are using the admin External system import, not the end user Import from CSV
check the date format for the system and field. They have to match

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

jira

cloud

jira-cloud

import

update