Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Automate Defect Extract

r2d2 February 27, 2023

Is it possible for Jira defects to be extracted daily? to a pre defined template?

5 answers

1 accepted

0 votes
Answer accepted
Alex Koxaras -Relational-
Community Champion
February 27, 2023

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.

r2d2 February 27, 2023

Due to strict security policies of my organisation this rule may not be suitable.

1 vote
Aron Gombas _Midori_
Community Champion
February 28, 2023

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

0 votes
Derek Fields (RightStar)
Community Champion
February 27, 2023

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

0 votes
Dan Breyen
Community Champion
February 27, 2023

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.

r2d2 February 27, 2023

Can you please provide some additional information on the options required to set this up?

0 votes
Dan Breyen
Community Champion
February 27, 2023

You can use a JIRA filter to gather your open defects and then use the Export to export them to a CSV.

r2d2 February 27, 2023

Currently this is how i extract data hoping to automate this.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events