How to Sort comments added to JIRA issue Via CSV Import ?


We are importing JIRA issues via CSV to JIRA 5.2.9.

We have multiple fields mapped to 'Comment Body' for this import. Would like to see one field, say 'History' to be added as a comment at first and all other fields followed by it.

Basically, the first comment should be taken from the CSV header 'History'.

Is there any workaround for this ?

Thanks, Naghaveer.

1 answer

Hi Naghaveer,

you can import any field as comment, also your History field. Map this while the import process to comment. Because the comments sorted by date, you have to set it to now for example. Use the pattern written under the field while the import process (somthing like "03/03/2014 12:00:00; username1; History text", be careful of the date format).



Hi Mirko

Could you please elaborate ? How to custmize the CSV column similar to the pattern you suggested ? I understand, Nagaveer has a CSV with a column for 'History' which is mapped to Comment body.

Thanks, Vishnu.

Hi Vishnu,

You cannot modify this within the import process. The value of this field must be changed before. Open your CSV file and add the date and the username to the field which should become a comment.

Hope this helps.

Regards, Mirko

So happy that works. But how do I import multiple comments?

This is my situation:
We have JIRA3 and we are setting up JIRA6. I'm importing the issues from this year. I got a comments-column in my CSV working. But some issues have more comments from different people.
How do I import them all in the most easy way?
And: How do I EXPORT them?
Because if it takes a lot of time to to this, then I'll probably copy-paste the comments and type a line myself with name + date and do it manually. Then it's not so neat, but it won't take me forever to pinpoint out the comments and hoping it all works out.....

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

35 views 0 4
Read article

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