View - Excel (Current fields) - columns being excluded

[Ian Kidd]

I have a user who is using a shared filter (created by someone else) to view a list of tasks on JIRA. When they click on View > Excel (Current Fields) to save this view as a spreadsheet, some of the fields that are displayed on the screen are not included in the spreadsheet.

Any ideas why not?

[Ian Kidd · Accepted solution]

Thanks: inspecting again confirms user error - thanks for your suggestions anyway.

[Nic Brough -Adaptavist-]

If the fields are on screen, then they should be included in the download.

However, that assumes that the authors of the field have seen fit to include the code required to generate the output in Excel format (it's usually just text, but not always)

All the custom fields, including the ones bundled in by default, in Jira are provided by plugins. If you take apart these plugins, you find they've got a structural file which says "use file X for viewing the data, file Y to edit it, file Z to export it to excel, (and other stuff)" and then you can find those templates buried in the resources. If a field is missing the "file Z to export it to excel", then Jira has no choice but to drop it on export.

What fields are going missing? Can you narrow them down to a specific type of field? If so, can you tell us what that is?

[Thomas Schlegel]

Hi,

There is a limitation mentioned here: https://confluence.atlassian.com/display/JIRA/Exporting+Search+Results+to+Microsoft+Excel

This will only show the custom fields that are available for all of the issues in the search results. For example, if a field is only available for one project and multiple projects are in the search results then that field will not appear in the Excel document. The same goes for fields that are only available for certain issue types.

Maybe this is the reason for the missing columns.

Cheers

Thomas