CSV import with multiple comments

I am converting an XML file into a CSV to import a bunch of issues into JIRA 6.4

Using this documentation
https://confluence.atlassian.com/jira064/importing-data-from-csv-720412846.html

Here is the example format listd

Assignee, Summary, Description, Attachment, Comment
Admin, "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;Admin; This comment works"

How would I change that if the issue had multiple comments tied to it? Clearly I don't comma seperate them :P.

2 answers

1 vote

Hi Taylor,

Maybe I don't understand your request.  You want to import issues into JIRA 6.4 from CSV and you would like to import an issue that has multiple comments.  If that is incorrect let me know.

If that is what you're trying to do you would just separate the values as it states in Importing Data from CSV:

You can import issues with multiple comments by entering each comment in a separate column.

In the example you provided, "01/01/2012 10:10;Admin; This comment works," if you wanted to add a second and third comment you would two other column headings of Comment and add the comment under the columns:

Assignee, Summary, Description, Attachment, Comment, Comment, Comment
Admin, "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;Admin; This comment works", "01/01/2012 10:10;Admin; This second comment works", "01/01/2012 10:10;Admin; This third comment works"

Cheers,

Branden

Hmmm, okay that would work, but what if I am doing multiple issues, each with different numbers of comments?

I would like to know this also! The documentation doesn't explain how to do this..

I have the same issue. How to import issues with multiple Comments with an admin CSV import. I want to create the issues, and within the same import process import the comments. If this is not possible is it possible then to import the comments in a separate import process? Which key fields are mandatory then to have in then in the CSV file. Do I add a record/line with the Issue key and a single comment per line, and add a next comment with the same issue key in a next record/line to import the next comment if there are multiple comments in an issue in my exported data?

 

Thanks for some feedback!

I have prepared the CSV as mentioned above; however i am stuck at mapping. There is no 'comment' column in dropdown to map to (as shown in screenshot below).

So where do I import the comments?

JIRA CSV Comment Import.png

@Sufian Rashid:map it with "Comment body"field.

Hi,

What can I do, if the Comment body field does not appear?

In the Projetc config it appears under fields, but not during the import guide (Map fields). Could it be because in Project config only "Comment" and "Comments" is listed, but not "Comment body"?

1 vote

Hi everyone,

Branden's previous answer is correct.   You can import multiple comments on an issue if you're using the external CSV import.  You just need to create a separate column for each comment, with the same header name.  In turn Jira will import these as separate comments.  This is explained during the import process:

working1.png

The hard part here is making sure that your CSV file is formatted correctly.   The number of comment columns your CSV file is expected to have is dependent on the issue with the largest number of comments.   So if you have an issue that has 50 comments and that is the one with the most comments, your CSV file would be expected to have 50 comment columns in order to maintain the formatting.   Obviously the other issues won't have values for all 50 comment fields, but at least one issue would.

To reiterate on Branden's example,

 

Assignee, Summary, Description, Comment, Comment, Comment
Admin, "Issue demonstrating the CSV attachment import", "sample description.", "01/01/2012 10:10;Admin; First comment", "01/01/2012 10:10;Admin; This second comment", "01/01/2012 10:10;Admin; This third comment"
Admin, "another issue with only one comment", "blah test description", "01/01/2012 10:10;Admin; only comment for this issue", ,

This sample CSV only imports 2 issues.  The first has 3 different comments, but the latter only has a single comment.  You will notice that the last issue imported does have an additional two commas to help identify that there is no value to be imported for this field.  

 

@Sufian RashidIn your case, I'm concerned to learn if you are perhaps using the Bulk create CSV import instead of the external CSV import.  These two features in Jira are similar and often confused, but they have different options.  I don't believe the Bulk create let's you map comments fields in.  But if you go to the Cog Icon -> System -> External System Import  and then select CSV, you will find that this import process will allow you to select the comment body as information to be imported.

@Andrew HeinzerThanks for directing me in the right direction.

is this done only by an admin? Because I don't see these options

@Alphy Joseph,

External System Import is only accessible by admins.

 

For more details please see also:

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

27,215 views 2 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you