Conversant to Informix 5

[BIS]

Does anybody have any experience with using voice@work? I am trying to querry the CMS (informix) database from the conversant using voice@work. I know it is possible but can't seem to figure out how. Any hints, helps and pointers much appreciated.

 

[ukcomms]

As usual there are many ways to achieve this, but first some questions.
Do you want to access RealTime or Historical Data from the CMS?
If Realtime, what will be the required refresh rate.?
If Historical,conversant sits on top of an Oracle Database and custom tables can be created to receive data from an external source such as ftp'd files,Sql statements etc.
Another option would be Netcare Prof Services from Avaya.

Regards
Paul

 

[BIS]

Thanks for the response! All I need for the time being is to be able to querry the dvdn table, so historical. With the oracle database, I guess I will ned to create an ODBC link of some sort (Net8?) to access an external table, I am not quite sure how to set this up. Also, I am not quite sure how to set up a custom table. Do I simply create one that is identical to the dvdn table on Informix? Help.....

 

[europe]

Depending on the Version CONVERSANT you have you can have some packaged application from NICE Centerpoint on the conversant. They have the appplication you are looking for to acces the CMS database tables.

have a look at

http://www.centerpointusa.com

Please let me know if the information that was provided is helpfull.
Edwin Plat
A.K.A. Europe

 

[BIS]

Thanks europe, I am aware of the centerpoint packages. Unfortunately these were only delivered free with v8 and I am on v7. So I am looking of doing this the hard way. Any ideas...

 

[ukcomms]

If the data required is from a DVDN table you should be able to create an Informix SQL statement that runs once a day and outputs to a file. I would only export the data required i.e. VDN Num and ACDCalls.
Next ftp the file from cms to conversant.
Create Oracle Table with VDN and ACDCalls ( conversant manuals explain how ).
Run a script on Conversant that loads file into Oracle Table.

Hope this helps
Paul

 

[BIS]

Thats certainly a good start. I hope I can figure out how to automate all this, but that comes later. Many thanks..

 

[europe]

Well BIS,

Just to make sure you're well informed I posted this reply, this info comes straigh from AVAYA:

Four CenterPoint Solutions packaged applications (Agent Assist Automated Service Observing, Customer Experience Observing, Callback Manager and Form Manager) are included at no additional charge with the Base System software on all new and upgraded V7.0 and later CONVERSANT Systems. If your customer intends on using any of these packages, provide the appropriate input on the 'CenterPoint' form to ensure that the technical checks for these packages are processed. These technical checks may require additional software or hardware for proper application operation.

Enjoy!!!

Please let me know if the information that was provided is helpfull.
Edwin Plat
A.K.A. Europe

 

[BIS]

europe,
thanks for that one, seems the rep I have been talking to was not aware (hmm) of that detail. Time for another go at them I guess...

 

[BIS]

oh, and by the way, what's the name of the package that can access the CMS database tables? Can this be incorporated into voice@work with an external function of some sort?

 

[telcoguy]

If you want to do it the real hard way, you can command-line query, or in a shell script of course to get the data from the tables, We have been doing that for some time now and very succeessfully.
What you have to do is write a shell script to output the table data into a delimited file for example.
This is a portable format that can insert into whatever you like.
I use dsplit as an example:
I'll give you a sample of the script:

/cms/toolsbin/cmsql -q < /export/home/cmssvc/dsplit.sql > /export/home/cmssvc/dsplit.txt

This would be the SQL statement it calls, put it in a file called dsplit.sql for example

select * from dsplit where row_date = DATE(CURRENT) - 1

Build a script around this, you can schedule with CRON, and you have a fully automated export. Then pick it up from the other server, and import it there.

Rob

 

[BIS]

europe,
Where exactly did you get the quote from? Thanks in advance.I know you said &quot;straight from avaya&quot; but is that the web or...?

 

[europe]

The information comes out of the GES Configuration Application (CIS) Version 3.9.0.00 that AVAYA provides to all distribution channels in EMEA.

It is a tool AVAYA and AVAYA resellers use to make system configurations.

I used to work for AVAYA about 2 years ago, then we used the OMNI tool, and even then Agent Assist and Customer Assist software was packaged with a new Conversant.

Hope this helps

Please let me know if the information that was provided is helpfull.
Edwin Plat
A.K.A. Europe

 

[BIS]

Thanks.

 

[BIS]

Just an update. Apparently, according to Avaya, this only applies to conversants bought after October 1st 1999 -and guess what, we bought ours in September....

 

[BIS]

OK, I have managed to export a simple text file from Informix. I have run a simple sql statement, like &quot;select vdn from wvdn where vdn=1234&quot; and saved this as a text file. I can easily ftp this to the conversant. Next obstacle:

How do I import this result into a table in Oracle. I can easily create a table with two colums, VDN and acdcalls, but how do I update this table with the contents of the text file. Can anybody out there help me out?