View - Excel (Current fields) - columns being excluded

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?

3 answers

1 accepted

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

0 vote
Thomas Schlegel Community Champion Aug 23, 2012

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

0 vote

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?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

47 views 0 11
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you