ā01-04-2017 04:54 AM
Hi all,
i would like to do a custom reporting on CUIC and extract the information about the chat contact.
In order to do this, i saw that there is the TextCustomerDetails table on UCCX where this information is located.
The problem is that actually these information is not stored in any table ( This has been confermed by TAC Cisco) but they can be shown on finesse when accepting chat only.
Another way to find this information is to use Rest APIs through SM but in this case i cannot do any CUIC report
Is there any chance to obtain these information on the database ( on UCCX or SM ) ?
Solved! Go to Solution.
ā01-06-2017 12:33 AM
Hi Stefano,
The details provided in the chat form while initiating a chat request into the contact center is part of the socialContact extensionFields in SocialMiner. However, it is not persisted in CCX.
You are right about using SocialMiner REST APIs to extract this information, but there is no database in UCCX or SM that you can connect CUIC to and run a report to fetch this information.
However, you can persist this information (pulled from a SocialMiner REST API) in an external database instance and then create a CUIC report with the appropriate queries. Supported databases are MS SQL Server and Informix IDS.
Hope this answers your questions.
Thanks,
Nagendra U M
ā01-06-2017 12:33 AM
Hi Stefano,
The details provided in the chat form while initiating a chat request into the contact center is part of the socialContact extensionFields in SocialMiner. However, it is not persisted in CCX.
You are right about using SocialMiner REST APIs to extract this information, but there is no database in UCCX or SM that you can connect CUIC to and run a report to fetch this information.
However, you can persist this information (pulled from a SocialMiner REST API) in an external database instance and then create a CUIC report with the appropriate queries. Supported databases are MS SQL Server and Informix IDS.
Hope this answers your questions.
Thanks,
Nagendra U M
ā01-12-2017 03:11 AM
Hi Nagendra,
thanks for your support.
Stefano
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide