Genesys CTI User Forum

Genesys CTI User Forum => Genesys-related Development => Topic started by: RDB on April 25, 2011, 10:46:35 AM

Title: Retreiving Transcripts from UCS
Post by: RDB on April 25, 2011, 10:46:35 AM

In one of our requirements for Chat multimedia client, we need to retreive the stored transcripts from UCS for performing some operations. Need help in achieving the same. Any help appreciated.

Thanks.

Title: Re: Retreiving Transcripts from UCS
Post by: cavagnaro on April 25, 2011, 05:46:33 PM

Using GAD you can do that...it is a normal function when GAD has a connection to UCS...

Title: Re: Retreiving Transcripts from UCS
Post by: fnunezsa on April 25, 2011, 07:14:35 PM

If you don't want to use GAD for this, the you must develop a custom tool using Genesys SDK.

Title: Re: Retreiving Transcripts from UCS
Post by: fnunezsa on April 25, 2011, 07:31:22 PM

The reason for this is that Transcripts are stored in Character Large Object (CLOB) fields in Interaction table in UCS database, fields names are Text and StructuredText.

Maybe you can try the procedure depicted in http://www.ibm.com/developerworks/websphere/library/techarticles/0611_singh1/0611_singh1.html to convert from CLOB to VARCHAR but I don't believe such convertion will be supported by Genesys Tech Support should you need anything from them about this matter.

Title: Re: Retreiving Transcripts from UCS
Post by: RDB on May 07, 2011, 07:41:08 PM

We are developing only an interface application for Chat.
But to perform post handling of transcripts, we need to have them. We are
not using GAD.

@fnunezsa: U mean another tool to retrieve transcripts??

Title: Re: Retreiving Transcripts from UCS
Post by: fnunezsa on May 09, 2011, 05:20:05 PM

Yes, that's what I meant. You have to develop a tool (new application) using Genesys SDK to retrive those transcripts. Genesys SDK provides the methods for that.