CSV Import errors - "Commenter named null not found"

[Deleted user]

I've been trying for hours to get a CSV import to work. Sometimes the import successfully imports multiple comments, but most of the time I get the error:

Commenter named null not found. Creating issue with currently logged in user instead

 I've tried formatting the comments as:

MM/dd/yyyy hh:mm;user@domain; this is a comment
MM/dd/yyyy hh:mm;user; this is a comment
MM/dd/yyyy hh:mm;<user ID>; this is a comment

 And I keep getting the same error. At the end of the import, comments are created under my name and all the comment data, including date and user, appears in the body of the comment in Jira. Please help!

[Ivan Lima · Accepted solution]

Hi @[deleted], most likely, you're getting this error because of the date format. I would test with a small file, a couple of lines, and a plain text editor. I assume you are importing via External System Import. Check your date format under the Setup step, and make sure your file matches that. For example, if your date format is dd/MMM/yy h:mm a, your file should have something like 01/Dec/2012 10:10 am.

"01/Dec/2012 10:10 am;603edc4*******05eb763; This comment works 1"

In this example, I'm using the Account ID, but the email address is also supported. Have a look at Import data from a CSV file.

[Deleted user]

The date format for created, updated, resolved date and comment date is all the same, and I've specified that date format under the Setup step. Doesn't matter which format I use, I'm still getting the same error. Weirdly, the created/updated/resolved dates are importing just fine - it's just comments that aren't working!

[Ivan Lima]

I recently experienced a similar scenario and got it working by updating the date format and using the account ID. Are you able to share a screenshot of your setup step with the date format you have and a sample of your CSV, specifically the comments portion?

[Deleted user]

Turns it out was the :00 seconds on the CSV!