Export JIRA Data

G

5

9

What is the best way to export all JIRA data (projects, issues, ...)? I saw that there is an API and a plugin mechanism which probably can provide all the information. But what is the easiest way to export the data? Does it work out of the box or do I have to implement a plugin?

Germany answered 17/8, 2011 at 12:12 Comment(2)

What do you want to do with the exported data? Save it as a backup, create reports, ... ? – Maggi 17/8, 2011 at 12:38

@user714965: I want to use a different issue tracker. – Germany 17/8, 2011 at 12:40

W

4

Generally, there are two main approaches to backup your JIRA data. The first one is to back up your database in which JIRA info is stored. The second one is to use the “Backup Data to XML feature”, which is a JIRA feature. Personally, I prefer the second one, because it can be restored to any database engine (MySQL, MSSQL, etc). In addition, as far as it is Xml, it can be compressed to a great extent.

Widget answered 17/8, 2011 at 12:27 Comment(2)

And this backup feature obviously covers all the data, right? Looks like the way to go.. I'm just curious, why there are some plugins which export issues. Why is that needed if there is a XML backup feature? – Germany 17/8, 2011 at 14:11

Yes, that's right. Those domain specific exporter plug-ins are designed to export issues to different formats, e.g. Excel files, CVS files, Microsoft project files or even files that can be imported by other issue tracking systems. – Widget 17/8, 2011 at 14:46

T

2

I have written a little ruby utility that uses JIRA's REST API to export all tickets for a given project to the local file system. It is available as a ruby gem, so the installation is trivial.

The tickets are saved as individual JSON files. The tool also supports incremental updates.

Tabaret answered 19/3, 2015 at 14:2 Comment(0)

A

1

I'm using JIRA v1000.747.1 which has native export to CSV of issues.

If you navigate to https://[your-jira-instance]/issues you should see a query screen with results. Fine tune that via the UI or go to the Advanced menu to do more complicated JQL. Then you can click the export button (upper right) to export to XML/Word/HTML/CSV.

Alyworth answered 15/2, 2017 at 18:22 Comment(0)

M

0

The following add-ons will work out of the box, they are configurable and there is no need to code anything:

Better Excel Plugin for XLSX output
PDF View Plugin for PDF output

You can use both free for 30 days, which should be sufficient to migrate your data to the new issue tracker.

Recommended topics

Hot tags