Export client satisfaction comments

[sudogreg]

is there a way we can export the comments people make on our satisfaction report?

[BDTECHRob]

Re: Export client satisfaction comments

I built a custom report in navicat to export directly from the interlink database, it's not hard as all the required information is in the survey table

[Stanley Ng]

Re: Export client satisfaction comments

BDTECHRob, keen to find out how you do that...

[BDTECHRob]

Re: Export client satisfaction comments

Do you use navicat to manage the interlink database?

[Stanley Ng]

Re: Export client satisfaction comments

Yes, I do.

[BDTECHRob]

Re: Export client satisfaction comments

Ok use the below query to get the required data then build a report based on that query using this guide.
http://wiki.navicat.com/wiki/index.p..._on_a_query%3F



SELECT
surveys.surveyresult,
users.firstname,
users.lastname,
surveys.ticketno,
surveys.submittedon,
surveys.additionaldetails,
clients.clientname
FROM
surveys ,
users ,
clients
WHERE
surveys.workerid = users.commitrecid AND
surveys.clientrecid = clients.commitrecid
HAVING
surveys.submittedon >= "2013-05-01 00:00:00"

as i run this report at the end of each month the last line limits results from the begining of the month so edit that line as needed

[Stanley Ng]

Re: Export client satisfaction comments

Thanks for sharing!

[BDTECHRob]

Re: Export client satisfaction comments

No problem