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

[Phalgun Maddali]

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? 

[Graham O'Bray]

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

[dmay]

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.

[Naveen_Sheik]

Thanks dmay - yes it worked for me too with a few exceptions, which I managed to assign manually. 

[Phalgun Maddali]

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. 

[Doug Slay]

This is still a problem for me.  My csv file shows the commentor/watcher/assignee/reporter as "dslay".  When I try to run the import it says it could not find a user dslay.  My user account is dslay@doman.net.  I would have thought it would use the user name to perform the match on, but it does not.  Any ideas?

If I update the csv file to include the user's full email address it matches and imports with no issue.  I just cannot manually make this many updates across the thousands of names in the file.

[jira guy]

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.

[Phalgun Maddali]

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 :(

[Jon Paton]

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...

[Satish Kumar Jayaram]

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. 

[Satish Kumar Jayaram]

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.

[Haris Kamil]

Worked for me! thanks!

[Mick Might]

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. 

[Prasad Kawadkar]

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

Thanks. :)

[markus_hegna]

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". 

[Jürgen Richter]

Alternative solution: 

When you export issues with Assignee + Assignee Id you'll get 

Assignee	Assignee Id
maike.wagner	5c658d858181d3640803d417

When importing map "Assignee Id" to field Assignee

[Kevin Paulus]

 We have a limited user capacity on our license & need to import projects from other instances but their users will not be joining:  Do these solutions create users? 

[Magdalena Zhisheva]

As posted by @Jürgen Richter after couple of tests on our side I was able to solve this as during the map I perform the User ID CSV column to the actual user Jira Field, i.e. 

Assignee ID -> Assignee

Reporter ID -> Reporter

Watcher ID -> Watchers 

It also works for each custom Jira fields which are containing user list. Works every time for us!

Hope it will help someone!

Best Regards,

Magdalena Zhisheva