Unable to export comments in excel

Rahul Aich [Nagra]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2014

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

2 votes
Answer accepted
danluin April 10, 2014

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.

2 votes
Midori
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 12, 2014

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 vote
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 25, 2014

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

Rahul Aich [Nagra]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2014

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.

0 votes
Mark Biro May 31, 2016

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 Sign up to answer