How to import comments with author and date using the CSV importer
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Platform Notice: Cloud Only - This article applies to Atlassian products on the cloud platform.
When importing comments and attachments via CSV import, they will by default use the reporter and current date/time. A specific format needs to be used to import these items as belonging to other users and maintain the original date of creation.
Solution
Please note that this solution only works when using the CSV import available from the page ⚙ >System > Import & Export > External System Import, which only Jira Administrators can access. This example shows the correct format for importing comments:
1
"31/Mar/24 6:49 AM;<Atlassian Account ID>;New Comment"The CSV data needs to have summary and project fields as required. Each comment should be in a separate CSV column, with the header "Comment".
If you aren’t sure of your Atlassian account ID, you can log in to your Jira Could site, click on your avatar on the top-right corner of the page, and go to Profile. The last part of the URL of the Profile page is your Atlassian account ID.
For eg: https://<yoursitename>.atlassian.net/jira/people/<Your Atlassian account ID>
Was this helpful?