Fields in Search Issues results not included in Export

The following fields are not appear on the extract (CSV) but are on the search issues summary screen results.  These fields are critical to my analysis, why are they not coming through on the CSV and what happened to the HTML export???

- Request Type (Service Desk Field)

- Organizations (service Desk field)

Additionally, all custom fields are coming through to the CSV as 'custom field'  Why would you not include the name of the field?  It creates extra work for me to go in an re-map all the fields that are all properly setup in the system.  In this case, both Request Type and Organizations are in fact NOT custom fields, but rather they are standard service desk fields

2 answers

0 vote

Based on this ticket, I think it's an open feature request

https://jira.atlassian.com/browse/JSDSERVER-826

The exported CSV has columns which follows the format

"custom field (< your field name here>)" format

So the name of the custom field is included in the bracket.

Tarun Sapra Community Champion Dec 05, 2017

Also while exporting CSV are you selecting "All fields" option?

yes I have tried that, none of the JIRA Service Desk fields will export...????  This makes that tool COMPLETELY USELESS!

Tarun Sapra Community Champion Dec 05, 2017

You can export the fields using an plugin - Better excel plugin

Integration features

 

  • You can export Excel reports directly from the Queue view (with all tickets in the queue). (supported since Better Excel Plugin 2.2.0)
  • You can export the JIRA Service Desk-specific custom field types, like SLA, Request Participants, Customer Request Type, etc., to Excel.
  • Better Excel Plugin also offers a reporting template that includes several pivot table and pivot chart worksheets to report SLA by projects, assignees, request types and request participants.

http://www.midori-global.com/products/jira-better-excel-plugin/documentation/integrations#jira-service-desk

unfortunately we are on cloud, that plug in is only available for server.....arrrggghhh

0 vote
Jack Brickey Community Champion Dec 05, 2017

@Sue Marmion, I am on cloud as well. You mention "none of the JSD fields will export" but I don't think that is really true or what you mean. Regarding the two specified fields: request types and organizations, they are exported but as you point out the data is less than ideal at best and unusable in reality. 

Organizations - is shown as Custom field (Organizations) and the value appears to be a reference ID, e.g. 1, 2, 3. Likely a simple value associated with the order of creation but not sure as I only have one org. :-)

Request Type - is shown as Custom field (Customer Request Type) and the data there is unusable, e.g. project_key/fdf01355-ef72-4103-8f90-e46df1b76d54. So good luck w/ the decoder ring on that. :-(

you might have a look at the Exporter addon for cloud. No experience with this so can't say if it will help.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,123 views 6 19
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot