Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Mat on October 06, 2008, 12:40:36 PM

Title: Connection from CCPulse to a external D.B using Java Script
Post by: Mat on October 06, 2008, 12:40:36 PM

Hello

I need to connect from CCPulse whith an other data base, access or my sql for extract information and meke new formulas using the two information

Thank You

Title: Re: Connection from CCPulse to a external D.B using Java Script
Post by: Mat on October 06, 2008, 02:30:02 PM

La conexión la consigo con


wscript = new ActiveXObject("wscript.shell")
path = wscript.CurrentDirectory
mdb = path + "\\PruebaJava.mdb"
conn = new ActiveXObject("adodb.connection")
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ mdb +";User Id=admin;Password="
conn.open(connString);
Select * from Clientes;

Ahora para hacer consultas o insertar datos?

Title: Re: Connection from CCPulse to a external D.B using Java Script
Post by: Mat on October 06, 2008, 03:45:57 PM

wscript = new ActiveXObject("wscript.shell")
path = wscript.CurrentDirectory
mdb = path + "\\PruebaJava.mdb"
conn = new ActiveXObject("adodb.connection")
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ mdb +";User Id=admin;Password="
conn.open(connString);
("SELECT Nombre FROM Clientes");

But when I´m going to create a new view a box said me that the sql snetence was removed

I need to show in CCPulse the actual agents logued in and the agent should be logued this are in my data base


Thank you

Title: Re: Connection from CCPulse to a external D.B using Java Script
Post by: cavagnaro on October 06, 2008, 03:50:29 PM

? And why not use StatServer tables instead?

Title: Re: Connection from CCPulse to a external D.B using Java Script
Post by: Mat on October 07, 2008, 07:42:57 AM

I need show in CCPulse the number of agent logged in and show our planification. Then I will create a thresold  if aggent loged < agent planificated.

Thank you