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

How to set the Assignee during Import Issues from CSV now that User Names are gone?

I import batches of issues frequently from CSV files.  I always set the Assignee = the Atlassian user name.  But this new change has just gotten in my way:

I can no longer see the user names on the Site Admin.

Does anyone know what I set the Assignee field equal to in the CSV?  Is it the Full Name?  If so, does it have to be in quotes?

3 answers

1 accepted

2 votes
Answer accepted

Hello @Ericka Samuels,

I've actually just had the same question when importing issues from CSV files. We still can see usernames in the URL: let's say you're looking at your user profile, the URL should be

I've just checked a user created today and he also has username = firstname.lastname, so I guess Atlassian gets the portion of their email address before the "@" character as their username.

Hope this helps,

- Manon

@Manon Soubies-Camy  MANY MANY MANY THANKS!!!!

Glad it helped! I'm still checking if we can do it any other way, it doesn't seem very user-friendly to check the URL :)

Perhaps the Cloud REST API could be useful?

Thank You @Manon Soubies-Camy You just solved a problem I have been working on for 2hrs!! Using firstname.last name has worked!!

Like Manon Soubies-Camy likes this

It doesn't seem like this works any more. My user profile link looks like this:

(I manipulated the hex string for privacy). 

For the heck of it, I tried putting in that hex string as my username in the import mapping, and that didn't work either.

Hi @Josh Varga,

I've reached out to Atlassian support team and the only way to get the usernames now is to export users and check their usernames on the CSV file. It's annoying to have to do an extra step to get usernames, but at least we're able to retrieve this data.

Like # people like this

@Manon Soubies-Camy that's indeed annoying and unfortunate. I wasn't sure if I'd get any traction here so I created a new question on this. Someone told me that in JIRA Cloud usernames are usually the part of the email before the @ symbol. In this case, it worked for me! 

Yep, that's also what I assumed - glad you worked it out! I reached out to Atlassian because I wasn't sure how to check usernames for old users (i.e., users created when they were still able to changer their own username). Now we're all set :)

Update: Nevermind, this works by mapping to the prefix of the email address of the user.  It seemed to default to addresses, but if I import from the main menu, not a project, I have the option to specify my own suffix.

When I export our Jira users to CSV there is no username field.  There are fields: id, full_name, and email.  I have tried all three of these values and the mapping fails.  I see no way to find user names which can be used in issue import.

For some of our accounts I'm capable to find the appropriate user ID for a CSV import by usage of the auto-complete of the JIRA issue search: Typing into the search field "Assignee =" then starting to type a well-know user name will show a drop-down with accounts. Clicking on the desired user will add a user ID into the search field. This user ID worked in many cases, but not all.

Finally JIRA support solved my issue: In JIRA Cloud I was capable to access "CSV Import" by the three dots menu at the "Advanced search for issues" page without the required admin privileges (looks like a bug). After I got the admin privileges for my project and used the correct import page (accessible via 'Jira Settings' / 'System' / 'External System Import') I was capable to import and assign issues by usage of the team member mail addresses. 

Like # people like this

@Matt_Sielski   It worked when I used Email Address instead of Name.

Like # people like this

email address works!

I can confirm that mapping to the full email address works.

I got the full address from the User Management section of the Admin page, then mapped a spreadsheet value to it in the 'Jira Settings' / 'System' / 'External System Import' tool. 

Thanks everyone for the help!

Adding user id in place of username works.. :) 

Even if you're importing to a different instance?

Foy my case I had to use the user ID in the csv, as the username was not working. With the userID it was successful. Got the userID from clicking on the user and in the url can see the id like so :

Suggest an answer

Log in or Sign up to answer

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