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; } } }

Existing issue is not update via CSV Import

Project Leader_zrm642

I tried to update existing issues and create new issues via CSV import.

[Purpose of CSV import]

1. Update 2 existing issues --> update attribute of issue (e.g. due date, status )

2. Create 2 new issues

The result was failed.

Only new issues were created but existing issue was not updated.

How to update existing issue via CSV import?

Below is detail log of importing CSV files

2023-09-06 02:26:36,446 INFO - ------------------------------
2023-09-06 02:26:36,446 INFO - Importing: Issues
2023-09-06 02:26:36,446 INFO - ------------------------------
2023-09-06 02:26:36,446 INFO - Only new items will be imported
2023-09-06 02:26:36,552 INFO - External issue 10110 already exists as GOD-107, not importing.
2023-09-06 02:26:36,556 INFO - Importing issue: [externalId='autoid-3411940195770920728', summary='Refinement of Feature Update']
2023-09-06 02:26:37,228 INFO - External issue 10105 already exists as GOD-102, not importing.
2023-09-06 02:26:37,233 INFO - Importing issue: [externalId='autoid--1641133955596348178', summary='Refinement of Requirement Update']
2023-09-06 02:26:37,707 WARN - 2 of 4 issues have been skipped because they already exist in destination projects.
2023-09-06 02:26:37,710 INFO - 2 out of 4 issues successfully created
2023-09-06 02:26:37,714 INFO - ------------------------------

External issue 10110 and 10105 were skipped because there were in Jira project.

Accepted answers

All comments

Trudy P Claspill

Hello @Project Leader

Did you provide the issue keys for the existing issues in your CSV file, and did you map that field during the import process?

From where did you access the import functionality? It could be accessed from the Create Issue dialog, from the "View all issues" page, or from Administration > System > External System Import. I'm not positive, but you may be able to update existing issue only when you use the External System Import. And you definitely have to provide the issue key as part of the CSV file, so that Jira knows which issues you're trying to update.

I would put the issues you want to update in a separate CSV file from the file that contains new issues you want to create.

Project Leader_zrm642

1. Did you provide the issue keys for the existing issues in your CSV file, and did you map that field during the import process?

--> yes my csv file hase issue key

my csv issue key.png

--> I also map that

my csv mapping.png

2. From where did you access the import functionality? Administration > System > External System Import.

--> System > External System Import.

access to Import.png

3. I would put the issues you want to update in a separate CSV file from the file that contains new issues you want to create.

--> I divided it into file with only existing issues and file with only new issues and then import only existing issues file. but failed again. Below is detail log.

2023-09-06 06:39:54,564 INFO - Only new items will be imported
2023-09-06 06:39:54,709 INFO - External issue 10110 already exists as GOD-107, not importing.
2023-09-06 06:39:54,716 INFO - External issue 10105 already exists as GOD-102, not importing.
2023-09-06 06:39:54,720 WARN - 2 of 2 issues have been skipped because they already exist in destination projects.

In that log, I can find "only new items will be imported" <-- Can I change this option from new one to existing one ?

Trudy P Claspill

Don't include the Issue ID field. You need only the Issue Key field.

You must include the Summary field.

Otherwise include columns for only the fields you want to change in 1 or more issues. If you don't want to change the value in a particular issue, include the original value for that issue for that field.

I haven't used importing to update existing issues for quite some time, but based on other posts in the community it should still be possible.

roberto_sc

@Project Leader Did you manage to get this working? I'm having the exact same issue.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud