JIRA data archival

[nidhis]

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

[Deleted user]

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@\"\" \" " 

[nidhis]

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]

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?

[Deleted user]

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

[nidhis]

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?

[Midori]

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