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

2 votes
Accepted answer

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 vote

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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,723 views 17 21
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