Finding user names to bulk upload issues via CSV

Dominique Clark October 8, 2023

My project requires a product owner field to be populated in order to create tasks via bulk CSV upload. We have just transitioned to the new cloud version of jira. 

Previously, to find someone's user name I would search for issues assigned to them and then switch from basic to JQL search and copy their name which would usually be a combination of letters their first and last name. EG John Smith would be "josmit"

Now I am trying to bulk upload in the new version of Jira and the old user names are no longer being recognized. When I search for the user and switch to JQL in new jira, the names appear like this: "john.smith" I tried to copy this version also and it wasn't recognised in the bulk upload. I also tried to click on the user name to see their profile to find their user name and that did nothing. 

So my question is... how do I find the correct format for individual user names in cloud jira in order to assign them as the product owner when bulk uploading from a csv file? 

Thanks in advance for answering :) 

2 answers

0 votes
Ivan Lima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 9, 2023

Try using the user's accountId. It will work. See https://community.atlassian.com/t5/Jira-questions/how-to-find-accountid/qaq-p/1111436 for more details on how to find the accountId. Also, try using the CSV bulk import with a smaller subset and make sure that you and the users in the CSV have the proper permissions.

0 votes
Juan Mateo Gonzalez October 8, 2023

Hi Dominique! Can you try giving the full email address instead of the username? Last week I had the same problem when trying to massively import issues from a previous instance and I solved it by changing the username in the user fields (system as reporter or assignee and also custom fields of the user selector type) to the email address electronic.

 

Regards!! 

Dominique Clark October 8, 2023

Thank you for the suggestion, unfortunately I just tried it and this didn't work either.

Juan Mateo Gonzalez October 8, 2023

Strange! make you sure that those user exist in your instance. If you can provide a screenshot whit log error

 

Regards!

Dominique Clark October 8, 2023

Thanks again for your answer. I tried again to upload and just used myself as the product owner for all tasks and got the same error: validation error.pngIf it's relevant I can make myself the product owner of tasks just by editing a single jira. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events