Modify the settings for uploading data from jira

[Ellen]

Hi,

How to remove the header and footer of the report with information about jira?
When unloading filter information from Jira to an excel file, we need to leave only the filter information.
If there are no settings in jira, is it possible to create them?

[Ellen]

Thanks for the answer.

[Nic Brough -Adaptavist-]

Ok, great, that link leads to an export that is built by a load of template files embedded in the code in your Server.

You cannot configure the header and footer out of the exports, they're hard-coded, but if your admins are happy to make (unsupported, but safe) changes to your installation, then you can get rid of them.

Somewhere in your installation you'll find a couple of files with names like "search excel header".vm  (I can't remember precise names or location, but probably under <install>/webapp/WEB-INF/classes/templates somewhere).

You can edit these (keep a backup copy somewhere safe!) and remove the lines that are spitting out the header and footer lines. 

Again, totally from memory:

Leave in the first line which will say something about disabling html escaping in both files.

For the footer file, you should be able to just remove the single table in there, leaving only the first and last line ( </body> ). 

The header is a bit more complex, you'll need to keep the first chunk of it, as the export needs the xml definitions and styles to make the file valid, and I'd recommend leaving in the bit that says "if no issues, tell the user the file is deliberately empty".  Like the footer though, there's a table which generates the lines you want rid of - get rid of the whole table.

[Ellen]

Jql filter export

[Nic Brough -Adaptavist-]

What export/download from Jira are you using to get the file from it?