« previous next »
Pages: [1]   Go Down

Author Topic: OCS and import data  (Read 3518 times)

Offline Nacimdz

  • Newbie
  • *
  • Posts: 15
  • Karma: 0
OCS and import data
« 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


Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: OCS and import data
« Reply #1 on: August 28, 2014, 06:22:19 PM »
???? Just import the data into the tables as insert queries...
Logged

Offline Fra

  • Hero Member
  • *****
  • Posts: 856
  • Karma: -3
Re: OCS and import data
« Reply #2 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
Logged

Offline Nacimdz

  • Newbie
  • *
  • Posts: 15
  • Karma: 0
Re: OCS and import data
« Reply #3 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
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: OCS and import data
« Reply #4 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.
Logged

Offline Nacimdz

  • Newbie
  • *
  • Posts: 15
  • Karma: 0
Re: OCS and import data
« Reply #5 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?
Logged

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Re: OCS and import data
« Reply #6 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
Logged

Offline Nacimdz

  • Newbie
  • *
  • Posts: 15
  • Karma: 0
Re: OCS and import data
« Reply #7 on: September 10, 2014, 04:56:56 PM »
Thk for all. Its running by this way :)
Logged
Pages: [1]   Go Up
« previous next »