Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Nacimdz on August 28, 2014, 03:35:08 PM

Title: OCS and import data
Post by: Nacimdz on August 28, 2014, 03:35:08 PM

Hello ,

We are on version 8 for the framework, GVP 8 running ,OCS 8.1.000.19
running, and multiswitch pabx Alcatel.

We need to inject calls in callinglist OCS by automatic way  from an external database or xml files.

Do you know how to go about it to make relation between database and ocs?
Maybe by SDK?

Thk you for your help

Title: Re: OCS and import data
Post by: cavagnaro on August 28, 2014, 06:22:19 PM

???? Just import the data into the tables as insert queries...

Title: Re: OCS and import data
Post by: Fra on August 29, 2014, 08:09:06 AM

[quote author=Nacimdz link=topic=8495.msg37387#msg37387 date=1409240108]
We need to inject calls in callinglist OCS by automatic way  from an external database or xml files.

Do you know how to go about it to make relation between database and ocs?
Maybe by SDK?

[/quote]
If you intend to automatise the import of calling lists, you will need to build an application that gets the lists from whatever source, manipulates them and then populates the OC database with insert queries.
An alternative would be using a HTTP request to OCS of an AddRecord type - see the Outbound Reference guide.
Lastly, I'm fairly confident that at least in the past the Interaction SDK was exposing a way to add records, you may want to check the relevant docs.

Fra

Title: Re: OCS and import data
Post by: Nacimdz on September 01, 2014, 09:31:33 AM

Thk FRA for the update.

What i want to do its to import data from an external database to ocs. Without make an automatic import by right clik.

Thk you

Title: Re: OCS and import data
Post by: cavagnaro on September 01, 2014, 11:08:17 AM

There is no magic way, as said, SQL INSERT queries would do the job, just create a JOB, a Trigger or something on your other DBM. If you have no clue ask a DBA.
On Genesys side as Fra said would be via APIs but I think will be too much work just for a pure INSERT.

Title: Re: OCS and import data
Post by: Nacimdz on September 01, 2014, 11:51:12 AM

Thk cavagnaro, i'm understand.

The JOB you are talking abour, is made from OCM calling list? Insert record and advanced mode? SQl lines?
Or there is another place to do it?

Title: Re: OCS and import data
Post by: cavagnaro on September 01, 2014, 12:31:19 PM

Job on your BD Server (MSSQL, Oracle, etc). You program to start at 11pm for example, read your tables and do an insert on OCS calling lists, aka, tables

Title: Re: OCS and import data
Post by: Nacimdz on September 10, 2014, 04:56:56 PM

Thk for all. Its running by this way :)