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

Question

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.

Vera Henrichs · Answer

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

Mirko Skramusky [Communardo] · Answer

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

Vishnukumar Vasudevan · Answer

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.