Exporting JIRA Service Desk Customer Survey response comments

[Bhav]

Hi, 

Has anyone found a way to export the comments customers leave after completing a JIRA Service Desk Customer Survey? 

The star ratings are searchable/exportable via "satisfaction" but I havent found away to extract the comments customers leave.

Thanks

[Aron Gombas _Midori_]

You can export the customer satisfaction rating and also the customer satisfaction comment with Better Excel Exporter (see column "F"):

[Raphael R.]

Hi Bhav,

I wonder how/where the star rating (1-5) is "searchable/exportable" (without comments) - could you please give me a hint on that? My intend is to export it to excel (without using the "Better Excel Exporter").

Cheers

[Shannon]

I don't know about server, but in cloud JSD you can do the following.

Use the JQL: Satisfaction is not null

And then pull the field "Satisfaction" into your results. It'll show up as stars in the Jira view, but when you export to CSV it is a number value.

[Raphael R.]

Thanks Shannon! Could you please be so kind to provide some screenshots? I am using JSD cloud and cannot choose/pull the field "satisfaction" nor my admin does.

[Shannon]

That is the correct JQL, so it must be a configuration situation. Maybe reach out to your admin or submit an issue with Atlassian. They'll ask for access to login to your environment and be able to tell you what about the configuration is causing the problem. 

[Sylvain Leduc]

Thanks @Shannon indeed JQL for server would be "satisfaction is not empty" and then edit columns to display the satisfaction field and export csv/current fields.

[llagos]

https://community.atlassian.com/t5/Jira-Service-Desk-questions/How-can-I-export-the-customer-satisfaction-report-in-Jira-to/qaq-p/756814

[Bhav]

Anyone else looking to do this or got other options?

Cheers

[Ivan Tovbin]

Hi Bhav,

The only way that I have found to extract these comments is to get them directly from the database.

[Bhav]

Thanks - I'm hoping there is a better/simplier way as I don't want to have database access just to extract comments inputted into JIRA. 

Cheers

[Ivan Tovbin]

Well, you can use a groovy script to write those comments into a file, that's another option.