Post call survey CCX 14.0.1

[shaijal123]

I need to create a script in UCCX 14.0.1 to conduct a post-call survey. After a customer service call, callers will be prompted to rate their experience on a scale from 1 to 10.
I can pass the result to DB with agent name, extension and the customer feedback. if you have a sample script please provide

[Carlo Poggiarelli · Accepted solution]

Hi ,

Are you sure about your CCX Version?

I added a Script that could help you to achieve what you need.

You have to modify the DB queries to match your tables and values.

Please Let Me know

HTH

Regards

Carlo

[shaijal123]

Many Thanks, version is 12.5, 14.x is CUCM version :).

in my case, only Q1 with menu selection is sufficient i think, can you check the screen shot pls

[Carlo Poggiarelli]

Hi

Sure That section could be enough but you need to asjust the queries and the DB connection on CCX Side in order to make that script work.

Thanks for you kind vote.

Please let me know if you need further info.

Regards

Carlo

[shaijal123]

I have received the database table details and credentials. Could you please provide guidance on how to establish communication with the database? I can see the data source configuration in UCCX. 

I already prepared script and folowing details will be push to DB.  

INSERT INTO surveys(eventDateTime,agentID,extension,phonenumber) VALUES($Grade)