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

[Niranjan Teegala]

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

[Bob Swift · Accepted solution]

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.

[Midori]

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

[Niranjan Teegala]

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

[Jobin Kuruvilla [Adaptavist]]

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.

[Vasiliy Zverev]

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