OCS and import data

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

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

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

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

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.

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?

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

Thk for all. Its running by this way :slight_smile: