CSV import creating new issues instead of updating existing issues

[Ramu Konidena]

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.

[Ramu Konidena]

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]

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

[Ramu Konidena]

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.

[Teresa Douglas]

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?

[Suneetha Bandaru]

Hi @Teresa Douglas and @Ramu Konidena ,

I am facing the same issue that I am not getting the "Issue Key" in the drop down to map. It is causing an issue that new ticket is being created instead of updating the same ticket. Did you get the resolution for this issue by any chance? If yes, please let me know.

Thanks in advance!

Suneetha

[Teresa Douglas]

@Suneetha Bandaru  I don't recall getting an answer and I did a brief test this morning and still face the issue.

[Vinod Kotiya]

Issue Key will be shown through Admin System import. That's another import module only for admins.

[Suneetha Bandaru]

Hi All, after trying different things and going through articles, I found a work around for this.

- Go to "System" from the wheel icon option on the right side top corner.

- Open "External System Import" 

- Switch to the old Experience (this is very important step for me to see the Issue Key)

- Select CSV option and proceed. 

FYI @Teresa Douglas 

Atleast for me, I could not find the "Issue Key" drop-down until I changed to old Experience. Hope this helps!

[Mohanraj Thangamuthu]

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

[Ramu Konidena]

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?

Regards.
Ramu