JIRA data archival

Question

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?

Regards,

Nidhi

nidhis · Answer

Hi,

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?

nidhis · Answer

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?

unknown · Answer

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

https://confluence.atlassian.com/jira/automating-jira-backups-185729637.html