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.



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.

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 votes

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
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

244 views 6 0
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