Export History in Usable Format

Question

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?

Mathew Lederman · Answer

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.

Mirek · Answer

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

Mathew Lederman · Answer

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.