When I Open a Filter Results in Excel, Some Fields Do Not Export with Proper Values

ian.silver

I have a filter to display a selection of tickets from a JSM project.  It works as expected, displaying all chosen columns, including custom fields for Affected Services (from our service registry) and Linked Assets (from our Device42 integration):

However, when I click on the Open in Excel button...

The resulting Excel workbook displays error messages in those custom field cells:

I don't think this is necessarily important, but here are screenshots of the field definitions as well:

When I use the export button and choose CSV, I get a value, but not the human-readable: value:

Is this a known issue?  Or am I doing something wrong?  I'm stumped!

Hannes Obweger - JXL for Jira

Hi @ian.silver

it indeed seems like both these fields are not correctly implemented for the Excel export. The Affected services field is owned by Atlassian, so you could consider filing a bug about that. For the other field: Is that a 3rd party field? Or is that the built-in Assets objects custom field?

One thing that may be worth trying is to check out some solutions from the Atlassian Marketplace. There's quite a few dedicated export apps, and I myself happen to work on an app - JXL for Jira - that at least exports the Affected services field nicely; for the other field, that depends on the exact implementation.

This is how this looks in action:

... and this is the export:

Another advantage is that you can export any number of issues in one go.

Any questions just let me know,

Best,

Hannes