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?

Regards,

Nidhi

 

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

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

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?

 

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?

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

444 views 1 15
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot