Is it possible for Jira defects to be extracted daily? to a pre defined template?
Hi @r2d2
Instead of exporting issues you can try https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?hosting=cloud&tab=overview which is a free app and which allows you to get data from Jira without exporting them.
You can use a JIRA filter to gather your open defects and then use the Export to export them to a CSV.
Currently this is how i extract data hoping to automate this.
I'm not an expert with automations, but it appears you can make a Scheduled Rule to run on a schedule to run your JQL Query and then export each row to a database or file somewhere.
Due to strict security policies of my organisation this rule may not be suitable.
Can you please provide some additional information on the options required to set this up?
You might want to look at this article that I wrote that shows how to connect a JQL Filter to an Excel Spreadsheet and refresh it automatically.
Integrating Jira Filters with Excel - Atlassian Community
As you wrote Excel is the preferred format, then this app can create and email or save or attach a standard XLSX spreadsheet file from issue data and do that automatically:
https://marketplace.atlassian.com/apps/1212797/better-excel-automation-for-jira-free?hosting=datacenter&tab=overview
It will connect to this other app which creates the Excel file from a template. So you can set up the headers or other details in the template, then it will be created in exactly how you wanted:
https://marketplace.atlassian.com/apps/1212652?tab=overview&hosting=server
(Discl. the first is free, the second is a paid app, both developed by our team.)
It looks like you're new here. Sign in or register to get started.
