Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,651
Community Members
 
Community Events
165
Community Groups

Modify the settings for uploading data from jira

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?

1 comment

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

Jql filter export
01.PNG

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.

Thanks for the answer.

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

129 views 2 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you