CSV import format for adding comment

Amit Singh_3jjygn

Hello Team,

 

I am trying to import comment also with jira issues using csv import option but comment not getting imported.

 

Anyone tried recent importing comment using csv format? Used below formats to import comment but nothing works:

19/10/2024;10:00;abc@gmail.com;test comment.

"19/10/2024;10:00;abc@gmail.com;test comment."

Also selected comment body while mapping issues during csv under issues field.

 

Please let me know 

 

 

Lucas Modzelewski _Lumo_

Hi @Amit Singh , welcome to the Atlassian Community

In your code, definitely ';' separating date and time shouldn't be used 

"19/10/2024;10:00;abc@gmail.com;test comment."

 

Check the docs: 

Assignee, Summary, Description, Attachment, Comment 
bob@example.com, "Issue demonstrating the CSV attachment import", "Please check the attached image below.", "https://jira-server:8080/secure/attachment/image-name.png", "01/01/2012 10:10;<Atlassian account ID>; This comment works" 
bob@example.com, "CSV attachment import with timestamp,author and filename", "Please check the attached image below.", "01/01/2012 13:10;<Atlassian account ID>;image.png;file://image-name.png", "01/01/2012 10:10;<Atlassian account ID>; This comment works"

Source: https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

So the format for comment looks like this:

"01/01/2012 10:10;<Atlassian account ID>; This comment works"

to add comment for author you need their ID, check: https://confluence.atlassian.com/jirakb/create-comment-using-csv-import-on-behalf-of-another-author-1224770916.html