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

This widget could not be displayed.

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

This widget could not be displayed.
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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Aug 13, 2018 in Jira Service Desk

Jira Service Desk – Don’t be afraid, the journey begins with curiosity!

...be more productive while being fun to use at the same time. For some, getting started can be a bit intimidating. This is especially true if Jira Service Desk is your first exposure to Atlassian...

300 views 7 20
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