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.

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 Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

676 views 4 16
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot