Export History in Usable Format

[Mathew Lederman]

Trying to export issue data from an old server instance of Jira (3.13.2) into a simple excel or txt file. Each project doesn't appear to have it's own export, so from what I can tell I'm exporting the entire instance.

The file exports on the server as a .gz which I then extracted, but the file doesn't have an extension. Unfortunately the file is too large for Notepad or Notepad++ to read, and Excel encounters the following error:

Details: "Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: '', hexadecimal value 0x0F, is an invalid character. Line 4028867, position 1.)"

I can open the file in Chrome, but that's not a very user-friendly format of the data.

Any recommendations on how to get this data to a user-friendly format?

[Mirek]

Hi @Mathew Lederman 

Jira 3.13.12.. is reeeaally old version :) .. I do not think I remember how it was but what exactly is the reason that you want to do this "export"? Do you want to get some specific issues from a specific project? Do you want to keep history of all tickets in an offline mode just for reference?

[Mathew Lederman]

Yeah, I'm not sure how this team has been working on such an outdated instance, but they've made it work one way or another.  We need to keep the history of all tickets for auditing purposes after we shut down the instance.

[Mirek]

How many data/tickets overall you have on this instance? 

[Mathew Lederman]

There are about 700k issues across two projects. I did find a way to change the export limit in the URL here. Unfortunately trying to export this number of issues through a browser download isn't ideal.