JIRA data archival

Hi Team,

My requirement is in our organisation we want to archive the data in JIRA every year end of year for coming few years.

For the same we have option to take export of filter from JIRA and save it somewhere.

But we require an automated solution to get the filter result directly to a file and sent to server.

I have tried fetching data from database, but there are so many tables from which data is coming so its difficult to fetch .

can you sugegst any workaround ind etail for above requirement?




6 answers

Do you have the JIRACLI? If so, you can just export issues per project including all its attachments. You can also run a separate action for getting the comments. I use this for archiving projects.

jira --action runFromIssueList --project "PROJKEY" --common "--action runFromAttachmentList --issue @issue@ --common \"--action getAttachment --issue @issue@ --id @attachmentId@ --file \"\"@issue@/@attachment@\"\" \" " 

PDF Automation can capture your issues, with all their fields, comments, change histories, attachments (see the screenshot!) in PDF files that can be stored anywhere and can be indexed by any search mechanism.

You can automatically execute a JQL query, generate the PDF document, then either email this or save it to the filesystem.

See the automation tutorial

but we want to automate it for next archivals.


It shoukd take 1 year data from JQL , export it to a file and save on server.

how can we do that?

Just take the nightly backup xml that JIRA is generating for you. That should suffice for your requirement I think smile


No, as i require to take backup based on a selection criteria for all closed issues for specific project.

That filter should be exported in Excel, this thing how can we automate?




Once i take export from JIRA as Excel all fields, it shows around 440 fields, then i remove manually the 100 around fields which are not required for my export.


This process next time for archival also we will have to do, as if i create a filter and configure 300 columns there, it will be very big task, any sugegstions?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

242 views 6 0
Join discussion

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