Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: SilverHead on November 22, 2011, 03:21:38 PM

Title: Importing contacts to Universal Contact Server
Post by: SilverHead on November 22, 2011, 03:21:38 PM

How could this be done? Is there any tool for that or does it has to be done by writing sql script?

The goal is to be able to get the contacts from GAD.

Thanks in adv fo the hints!!

Title: Re: Importing contacts to Universal Contact Server
Post by: René on November 23, 2011, 03:26:34 PM

Hi,

Import of contacts into UCS database is supported starting release 8.1 by using UCS Context Services API. However, you can import contact to UCS database directly using SQL. Required tables are described in the Genesys Multimedia 7.6 Selected Conceptual Data Models for the UCS Database. Critical point is generation of unique IDs.

Let me know if you need more help.

R.

Title: Re: Importing contacts to Universal Contact Server
Post by: SilverHead on November 25, 2011, 01:54:57 PM

Thanks Rene,
indeed that's what I was thinking. Genesys advised to create a custom app with sdk to generate the contacts "programmatically" as they told me lol...

Enjoy the day!

Title: Re: Importing contacts to Universal Contact Server
Post by: René on November 28, 2011, 03:30:41 PM

Using Contacts Platform SDK is another possibility but it seems to me a bit complicated for one-time import. In case you'd like to sync contacts between UCS and 3rd party system then I would vote for SDK.

R.

Title: Re: Importing contacts to Universal Contact Server
Post by: hieutx on October 22, 2017, 08:42:33 AM

Hi René,

I want import contact data to UCS DB but i don't know about structure of UCS DB. you have document about structure of UCS DB or API to import to UCS DB, please share with me.

Thanks!

Title: Re: Importing contacts to Universal Contact Server
Post by: abudwill on October 28, 2017, 05:33:49 PM

Contact portion of PSDK is the way to go.

I have done this before.

One thing to consider is - if the person you are importing already exists - do you update that record or create a new record.  Another item to consider is what bit or bits of information would you use to determine if a person exists/is unique.