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
4,294,209
Community Members
 
Community Events
165
Community Groups

User does not exist error when importing CSV File (External System Import)

This is for the Cloud version of JIRA Software.

I am trying to bulk create-and-assign using the CSV import function. My CSV file contains the assignee in username format. I did not check the 'map field value' as suggested by https://confluence.atlassian.com/jirasoftwarecloud/creating-issues-using-the-csv-importer-764478441.html#CreatingissuesusingtheCSVimporter-RunningtheCSVfileimportwizard . I still cant create the tasks. I always get the error :

  • Issue can't be created due to the error/s [ User 'redacted' does not exist. ]

The user 'redacted' has been added to the project with the Developer role, and yet this issue happens. I tried to change from username to the actual user name in "Firstname Lastname" format, no luck. 

 

Any ideas? 

4 answers

I am also having this issue. This is the first time since doing this monthly for a year. Something on Jira's end must have changed.

When I use the @Graham to see my user ID I see this:

[Graham O'Bray|~accountid:5b3149d263379b3ac420d300]

My user ID = gobray (which is what I always used to reference when I did my prior bulk load froM CSV)

I tried using the account ID with no success....any ideas?

 

Thanks,

Graham

I run into same problem, and was able to (kind of) deal with it.

It turned out that user name, shown in Jira, even on user profile page, doesn't actually match internal user code. But when you try to mention user in a comment, it resolves to correct code.

 

For example, I have a user with name John D, and it shows alias @JohnD on his page. When I try to import issues with assignee `johnd` - it fails.

When I enter comment, `@johnd` is replaced with [~jdoe] 

I try to import issues with assignee `jdoe` - it works like a charm.

 

And there is no other place in Jira, where I could find this actual user code.

I didnt find a solution for this.

Finally imported 100+ tasks manually without any assignee.

To ease this, what I did was to create a separate CSV per user, import it without assignee, bulk select the group and assign to the same user. This way I didnt have to do 100+ assignments, just a few. 

adding the user as username should work without any errors while importing data through CSV. Firstname Lastname format is not supported while importing assignee.

Check to see if the user is active and exists in JIRA. Check the permissions to see if developer is assignable user.

thanks for the reply. 

adding the user as username doesnt work. I get the same user 'username' not found error. 

user is active, exists in JIRA, and has the developer permission. I am able to edit an existing issue and assign to this user. Note that I am having this problem with 5 different users. 4 of them are new to JIRA cloud, added recently, but 1 of them has already used multiple JIRA cloud projects. 

is there a hidden requirement for the users to login to the project at least once before they are 'discoverable' for the csv import tool? i plan to try that later today. If that doesnt work, i will just import my 100+ tasks without any assignee and then assign them manually :(

Like it_helsinki_ JIRA Admin likes this

I am having the same Issue - testing importing CSV to cloud -

I can assign 2 of my users but cannot seem to assign a third

The User I am having issues with is an admin user (as am i)

I use their jira ID and also tried their email address... no luck ... I have 500+ issues to import ... need to be able to do this...

I am also facing this same issue. We triple checked that all user id exist also relevant privilege is given to those ids in Permission scheme, still I am not to upload data. 

As per the suggestion given in another discussion thread, I removed the email id (which suppose to be the user id) and gave the only the user id without domain name. 

Ex:- if my user id is tom@domain.com, I gave only tom. I removed @domain.com. It imported properly.

Like # people like this

Worked for me! thanks!

Nice. This worked for me too i.e. replacing homer.simpson@cartoon.com / "Homer S" with "homer.simpson" in the CSV file.

 

I've given up trying to bulk update and Move issues from next-gen to classic project types due to many other problems, so CSV exports/ imports will suffice for the moment. 

Like Prasad Kawadkar likes this

The "homer.simpson" solution worked for me as well.

Thanks. :)

Tried importing issues as of now. Had the same struggles as the rest of the people in this tread.

But it worked when i set the user id to this format "name@domain.com". 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,175 views 34 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you