Unable to export comments in excel

Hi

I am trying to perform a CSV import from a jira to another jira instance. However, when i take a excel export from my jira, it does not export the field comments.

I am on jira 6.2

How do i export comments in an excel?

Rahul

4 answers

1 accepted

Hi guys,

I'm glad to introduce you our new JIRA add-on: Exporter (https://marketplace.atlassian.com/plugins/com.deiser.jira.exporter)

It was released yesterday and its features are basically to export issue comments and issue transitions summaries from the issue navigator to Microsoft Excel in the way you need.

I invite you to try it ... maybe it will be very useful for you.

Please, don't hesitate to use our issue tracker (https://jira.deiser.com) to report any issue during trial period. Also your feedback will be very appreciated.

Cheers,

Daniel.

Better Excel Plugin will export the comments to an Excel spreadsheet for you in any possible way:

  • All comments
  • Latest comment only
  • Public comments only
  • Basically any other custom logic

Since the exporting logic is defined by some special placeholder tags and can be even capture in Groovy scripts, you can meet any exporting requirement.

See the full manual

 

1 votes

You don't.

The comments are potentially open-ended, very long and hard to parse. Jira simply doesn't have a template for exporting them, so you won't get them.

There are a handful of plugins and scripted fields that enable comments to come out, but they don't do anything particularly clever with the formatting, it's a huge single block, so you'd be looking at having to parse them out, and you wouldn't retain the meta data on import anyway

CSV isn't really that suitable for Jira to Jira transfers, I'd be looking at project export/import, Jelly, the CLI, etc

Thanks Nic that helps. We are only importing 35 odd issues, so possibly we can get away with manually copying the comments on the target.

Hi there,

 

With JExcel PRO you can export your issues to XLSX (or HTML) with the images, comments and attachments.

You can even see the comments in the grid!

 

Feel free to try it:

https://marketplace.atlassian.com/plugins/com.moresimp.jexcel.pro/server/overview

 

I hope you will like it. :)

 

Cheers, Mark

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

3,129 views 13 19
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