Modify the settings for uploading data from jira

Ellen October 18, 2021

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?

4 answers

0 votes
Ellen October 20, 2021

Thanks for the answer.

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 19, 2021

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.

0 votes
Ellen October 19, 2021

Jql filter export
01.PNG

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 18, 2021

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

Suggest an answer

Log in or Sign up to answer