Retreiving Transcripts from UCS

[RDB]

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.

[cavagnaro]

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

[fnunezsa]

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

[fnunezsa]

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.

[RDB]

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??

[fnunezsa]

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.