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

Hi,

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).

Regards,

Mirko

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,975 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot