Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export JIRA Data

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?

like image 827
duedl0r Avatar asked Aug 17 '11 12:08

duedl0r


People also ask

Can Excel pull data from Jira?

You can import Jira issues into MS Excel sheet using either your saved filters or custom JQL queries. You can also re-use any MS Excel file generated by Jira to get you started.

Can you export reports from Jira?

In your plan, click the Reports tab to display the reports section for your plan. From the switch report menu, select Releases or Scope. If necessary, click and configure the display settings of the report. Click the Export button > select the location where you want to save the CSV file.


3 Answers

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.

like image 126
Gupta Avatar answered Oct 03 '22 23:10

Gupta


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.

like image 25
Felix Leipold Avatar answered Oct 03 '22 22:10

Felix Leipold


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.

like image 39
jpvantuyl Avatar answered Oct 03 '22 22:10

jpvantuyl