How to import comments and attachments 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
When importing comments and attachments via CSV import, they will by default use the reporter and current date/time. In order to import these items as belonging to other users and maintaining the original date of creation, a specific format needs to be used.
Environment
Jira Server or Data Center, all currently supported versions. The documentation for the CSV import mentions date and author to be specified in imports, but the date format needs to be specific. Also, the username has to match an existing user in Jira.
Solution
The import needs to run as External System Import / CSV import, started by a Jira administrator. This example shows a correct format for importing comments:
1
"31/Mar/22 6:49 AM;charlie;new comments from importer;"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".
Was this helpful?