CSV export

marciszewskimarek

I would like to know what would be the best way to export data extracted from Jira to csv file. I need to build a script that creates a summary of epic task and its subtasks as far as logwork is concerned plus some additional information. 

I have already build some scripts using script runner that extracts necessary information. 

Is there a way to create csv from within script during a transition e.g. when closing a task? Or maybe a link that would allow the file to be downloaded or added as a comment on the closing issue. Does Jira enables this feature?

Is making a call to Jira REST API from within a script using script runner is a good idea?

If yes what steps should I take into consideration?

I know this is possible to create a filter and amend its url so that in the end we get a link to a file that we can download which is a .csv file. But it looks like this is quite limited in the way that I would like to create csv that grabs information from many different issues where filters narrow the searches down?

Petter Gonçalves

Hello @marciszewskimarek

Welcome to the Atlassian Community!

I'm not sure if I completely understood your request, but I believe you are looking for a way to export issues to CSV when they get transitioned to a specific status in your workflow. Is that correct?

I believe the best way to achieve your goal would be by using a Jira filter indeed, properly restricting its parameters to only return the issue that was just updated. Let me give you an example:

1. Create a filter to get the issues moved to the status "Done" in the last 1 minute, optionally setting the "BY" parameter if you want to only include the issues closed by you:

   status CHANGED to done AFTER -1m BY "youruser"

2. Once you change your status, navigate to the filter and export it using the UI, or optionally using your own script to automatically run the export.  You can get the exact call to export the filter at the development tools of your browser.

If that option does not work for you, could you please give us more details on how you plan to use this exported file?

Additionally to the option above, there are also other automation third-party apps that you can use to properly schedule CSV exports on a time frame. You can take a look at our Atlassian Marketplace to get some options.

Let us know if you have any questions.