Is their a way to export details of an issue to a CSV file at a particular stage of issue

Guys need help... we are looking for a way to export details of an issue when it reaches a gate of approval in SDLC Process. I am finding an add on to do that... is there any way that we can export the details and keep stacking the file with new tickets as it comes to that gate of approval.

 

Thanks,

Niranjan Teegala

5 answers

1 accepted

You can add a CLI post function to the appropriate transition that runs a getIssueList action to export the issue data to a CSV file. You would use the jql parameter with "key = %original_key%" to get only the issue being transitioned. You would either need a uniquely named file (by timestamp or similar) or use --append to keep adding rows to an existing file.

0 vote
Vasiliy Zverev Community Champion Jan 11, 2016

Does it means that you need to add some informaton about issue to the file every time when it is set to a certain status? Or you can analise change history to get values of requaed fields st the moment of some transition

0 vote

You can create a filter for the status and export it to Excel from the issue navigator, does that work?

Ideally, you should just display the filter on the JIRA dashboard and shouldn't worry about the export at all but the export is there if needed.

Thanks Jobin... but I was looking for a different method of export mechanism... with out manual intervention...

Thanks Bob... I will try your suggested method... I think this is what I am looking for...

You can intelligently intercept the status changes with the super-powerful JIRA Automation Plugin, then:

  1. Either use the PDF Automation Plugin to capture the current status of the issue to a PDF file. It has the advantage that you can also capture the attachments, comments and other data that do not really fit the CSV fileformat.
    Guide for PDF automations
  2. Or use the Excel Automation Plugin to capture the current status to an Excel sheet. Although it has major advantages over CSV, this add-on does not support incrementally adding new lines to an existing spreadsheet.
    Guide for Excel automations

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

59 views 0 5
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