CSV import with multiple comments from multiple users

Question

Hello Team,

I am trying to import a bunch of issues into JIRA 7.6.4 through a CSV file. The file consists of multiple comments from different users.

I want "eriper" (as highlighted in the attached screenshot) to be the one who has commented but unfortunately in this case it takes the user(Consultant-Jowaheer Khushbu who is importing the csv file).

Subject/Title,create time,Close time,Assignee,state,Priority,Type,Comment,Comment,Reporter
Queue for MCB Select,5/16/2018 11.00 ,5/16/2018 12.00,Unassigned,new,3 Medium,Service Request,5/16/2018 11.00; eriper; comment1,5/16/2018 11.00; eriper; comment2,ERIPER

Please assist.

Thanks,

Khushbu

Khushbu Jowaheer · Answer

Hello Mirek,

I has been able to import the comment with the correct author and correct date.

The issue was the date format. Jira has a standard date format which is dd/mmm/yy h:mm a. So i had to change the date format in the comment as per this format.

Thanks,

Khushbu

Mirek · Answer

Unfortunately I am not seeing the whole picture in order to say what might be wrong. You would need to at least put as example exactly one CSV row that you would like to import and the result of it, so that we can check. As a alternative solution you can also start "slowly" by adding more and more information to CSV (column by colum) and check when you observer the problem. You can also try to add only comments to an existing issue.

This documentation might help you preparing a good file:

https://confluence.atlassian.com/adminjiraserver071/importing-data-from-csv-802592885.html#ImportingdatafromCSV-format

Khushbu Jowaheer · Answer

Hello Mirek,

The username is "eriper". I have not included the "Description" value in my case.

I apologise for providing the wrong screenshot, but i tried replacing the "description" with "comment1" and "comment2" I get the same as shown in the screenshot.

Actually I was trying to import issues for a JIRA Service Desk project. Is it because of this reason the import did not go well or maybe I am missing something somewhere?

Thanks,

Khushbu