CSV import creating new issues instead of updating existing issues

Ramu Konidena July 27, 2023

Hi all,

I have a company-wide project where I created a few test issues through GUI - I am trying to update these by exporting them to ExcelCSV format, making changes and then importing them back to Jira. All my different attempts are resulting in creation of new issues instead of existing issues being updated. The issue repros even with a newly created item.

Config file (sample)

{
"config.version" : "2.0",
"config.project.from.csv" : "false",
"config.encoding" : "UTF-8",
"config.file.id" : "5458d2c0-3187-4639-r0af-fefca7aa6ebf",
"config.email.suffix" : "@",
"config.file.name" : "Jira_Oneitemtest.csv",
"config.field.mappings" : {
"Issue key" : {
"jira.field" : "issue-id",
"userChanged" : "true",
"manualMapping" : "true"
},
"Summary" : {
"jira.field" : "summary",
"userChanged" : "true",
"manualMapping" : "false"
}
},
"config.csv.file.id" : null,
"config.value.mappings" : {
"Issue key" : {
"AKTT-283" : "AKTT-283"
}
},
"config.delimiter" : ",",
"config.project" : {
"project.type" : null,
"project.key" : "AKTT",
"project.description" : null,
"project.url" : null,
"project.name" : "Scrum-Company",
"project.lead" : "712120:9031a066-2418-4d47-b2dd-ee9cb099fe9e"
},
"config.date.format" : "dd/MMM/yy h:mm a"
}

Import log:

2023-07-27 18:46:02,376 INFO - Importer started!
2023-07-27 18:46:02,376 INFO - Engine is running in Import mode
2023-07-27 18:46:02,469 INFO - All issues will be imported to project: Scrum-Company (AKTT)
2023-07-27 18:46:02,492 INFO - Creating issue: [externalId='AKTT-283', summary='Testing import and export 3']
2023-07-27 18:46:02,500 INFO - Issue does not have issue type selected, the affected issues will be created with default issue type [Story]
2023-07-27 18:46:03,136 INFO - Issue created successfully with Key [AKTT-284], [externalId='AKTT-283', summary='Testing import and export 3']

 

Any inputs on what could be going wrong here?

 

Thanks.
Ramu.

2 answers

1 vote
Mohanraj Thangamuthu
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 27, 2023

Hello, While importing the .csv file to update the fields you need to make sure to map Issuekey, issuetype field.

Screenshot 2023-07-28 at 10.13.11 AM.png

Ramu Konidena July 28, 2023

Sorry for incorrectly posting my reply as an answer:

 

Thanks for the reply - as shown in the screenshot below- I am not seeing Issue Key in the dropdown box - not sure what's going on - any ideas?

Issuekey_notfound.jpg

 

Regards.
Ramu

0 votes
Ramu Konidena July 28, 2023

Issuekey_notfound.jpg

Thanks for the reply - as shown above - I am not seeing Issue Key in the dropdown box - not sure what's going on - any ideas?

 

Regards.
Ramu

Mohanraj Thangamuthu
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 30, 2023

Looks like .csv file does not have issuekey. Is this file exported from another Jira instance ?

Ramu Konidena July 31, 2023

No, it is from the same Jira instance. The csv file does have the issue key. As you can see the screenshot above, the source does have it. I tried creating a brand-new project and I see the same behavior (Gui does not give the option to select Issue Key mapping during export). I will try this with a different project in a different Jira instance later today and see what happens.

Thank you.
Ramu.

Like Mohanraj Thangamuthu likes this
Teresa Douglas April 12, 2024

I am having the same issue as reported by Ramu.  Any response as to why issuekey is not in GUI as a field to map to?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events