Import from CSV not working with a whitespace in the username

[Barbara Hernandez]

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]

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

[Kai Becker]

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

[Barbara Hernandez]

Hi Kai,

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

Thank you