Import from CSV not working with a whitespace in the username

Question

Hi everybody,

I'm trying to bulk import tickets wth CSV format, but I'm having problems with the Assignee field.

The usernames in our Jira use name and last name with whitespace, eg. "Barbara Hernandez", and jira is converting to lowercase and deleting the whitespace, hence, I get an error saying the user "barbarahernandez" does not exist.

Is there any way to write it in the CSV that jira can understand and parse correctly?

Nicketa · Answer

While exporting CSV, try export all. It will also include jira db ids. That will help if importing in same server.

Barbara Hernandez · Answer

Hi Kai,

Sorry I didn't mention but I'm using Jira Server. Is there a way to find out the ID?

Thank you

Kai Becker · Answer

Hi @Barbara Hernandez

Welcome to the community and thank you for your question.

For importing issues to Jira cloud via CSV you have to options to identify the user:

* email address
* Atlassian Account ID

For a full mapping please review this article: https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/#Tips-for-importing-CSV-data-into-Jira-fields