Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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 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 @Paul Greig 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 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

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

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!

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. 

Suggest an answer

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

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,496 views 22 32
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