Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Modify the settings for uploading data from jira

Elena 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
Elena October 20, 2021

Thanks for the answer.

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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
Elena October 19, 2021

Jql filter export
01.PNG

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
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