How to export issue and comment in CSV with proper format to import

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

このページの内容は、サポート対象外のプラットフォームに関連しています。したがって、アトラシアンは、そのためのサポートの提供を保証できません 。この資料は情報提供のみを目的としているため、お客様自身の責任でご使用ください。

目的

The guides in How to add comments to Excel export will only allow user to export the comments, but does not allow user to re-import the issue with comments using CSV import due to improper format of the comment. JIRA would need the proper format of  "User;date Time stamp; Comments text" to be able to import back the comment to JIRA instance.

ソリューション

  1. Use the following plugin to export issue and comment together in CSV https://marketplace.atlassian.com/plugins/com.deiser.jira.exporter

  2. The plugin will automatically separate the date, commenter and comment's content, 

  3. Modify the excel by combining the three fields and adding a semicolon delimiter using below formula as an example.

    =AJ6&";"&AK6&";"&AL6

    AJ6: Date Column
    AK6: Commenter
    AL6: Comment body

  4. By default, the plugin will export those comments to three columns

    To understand better how concatenation works please refer to this page: https://support.microsoft.com/en-us/kb/280388

  5. By default, the plugin will export those comments to three columns

  6. Select the first empty columns on the right side of the table and enter the formula respectively according to you column number

  7. You will notice that the three columns data have been concatenate with additional ';' between them

  8. Click + Drag at the bottom right of the resulted column to the bottom of our data so that the formula is copied to all other columns below. Copy all those new columns.

  9. Paste-Text-Only to replace the existing comment column by default, the plugin will export those comments to three columns

  10. Delete the rest of the data in AK6: Commenter and AL6: Comment body

  11. Delete the rest of the columns, leaving only the column with the concatenated data.

  12. Proceed to upload your CSV file to you JIRA instance

説明The guides in How to add comments to Excel export will only allow users to export the comments but does not allow a user to re-import the issue with comments using CSV import due to an improper format of the comment.
製品Jira
プラットフォームサーバー
最終更新日: 2018 年 10 月 10 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.