Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Bulk Update Existing Tickets

Hi All!
So, we've had a company realignment and I'm trying to bulk update all our pre-existing Users details. According to Atlassian this should be fairly straightforward, but mine just keep creating new users


This is the information I'm going off: Import data from a CSV file | Atlassian Support

JIRA Update Info.png


My spreadsheet I'm using to import:

Spreedsheet Issue Key.png


My config file I'm using to import:

 Config File.pngConfig File 2.png  


The available fields I get when I import:
Import Issue Key.png 

Some notes:

- I have 'Status' in my spreadsheet, this does also not work it puts everything into default status whether I have specified it or not.
- Status is not in my config file, as I wanted to see if it made any difference or not

Any suggestions as to what I'm missing as to why it's not updating users and just creating new ones instead? 


1 answer

0 votes

Hello @Georgia Beckers

Thank you for reaching out.

Just to confirm, I see you mentioned you are trying to edit "Users" in the body of your question, however, I believe you are talking about "Issues". Did I understand this correctly?

Can you confirm if the destination project (CI) is company or team managed?

You can try the following steps:

  1. Ensure you are using the CSV import option of the Jira administration page, and not the one in the issue navigator (... > Import issues from CSV), as this last option will not work to update issues.
    To use the correct CSV import of the administration page you should:
    1. Click on the cog icon at the top-right of Jira > System
    2. On the left menu, select "External System Import" > CSV:
      Screen Shot 2022-09-15 at 6.11.30 PM.png
  2. Try to import the CSV without using the config file, manually mapping the fields you need
  3. Confirm your user has the correct project permissions to edit the issues you are referring to in the CSV. In fact, try to manually edit the fields you added in the CSV to any of the issues listed in the CSV and check if it properly works on Jira before the import.

Let us know if this information helps.

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events