Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: rogierbosch on July 18, 2012, 07:20:03 AM

Title: GAD newbie Database Query / Stored Procedure
Post by: rogierbosch on July 18, 2012, 07:20:03 AM

Hi you all,

I need a kickstart on GAD 7.6

I want to add an function to GAD that will write some data from 'attached data' to a SQL database. This function must be started as soon as call is connected to agent (pick-up).

Can anybody give me a start what to do, read, write..

Rogier

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: Timur Karimov on July 18, 2012, 03:04:57 PM

Hi Rogier,
did you have Genesys Desktop 7.6 Developer’s Guide ?

WBR

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: rogierbosch on July 18, 2012, 04:14:34 PM

Offcource!

Give me the page # where I can find how to create SQL connection and you are my hero. In all things i have read no line is written about (MS) SQL.

No samples via ALU/Genesys that contains third party DB connections...

.....

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: cavagnaro on July 18, 2012, 04:44:48 PM

;D Funny guy...lol made me laugh....gimme the page....
If you want to add a new functionality I doubt that Genesys or Alcatel imagined all possible ideas on the world and made a sample...
They better provided what you can control samples so you do whatever you want...it is their Hello World.
So now you have to read the guide and just add the Java code to connect and do something to an external DB. As you may already know that has nothing to do with GAD. What is on GAD side is WHEN you want to trigger this script and capture the KvP and assign them to Java variables.
Regards

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: Timur Karimov on July 18, 2012, 05:50:52 PM

Rogier,
Genesys does not sell the BIG RED BUTTON with name on it -  "MAKE ALL HAPPY" =)

In dev.guide you can found example how you can call custom code trigered by AIL events. And , as Cav said it's  early, in you custom code you can do everything what you can do with java.

WBR Tim

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: rogierbosch on July 18, 2012, 06:01:36 PM

aaaaaahhhhhhh now i am getting it.... As mentioned, i needed a kickstart and i think i have it now :)

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: rogierbosch on July 18, 2012, 06:08:33 PM

If I understand correctly: I can do anything I want within JAVA limits in combination with the events within GAD?

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: cavagnaro on July 18, 2012, 08:53:28 PM

Yep, you got it.
Now about "anything" word can be very wide on meaning...try and test understanding the limits (like browser stuff) you have. It is not the same to develop in Java for a PC without the IE on the middle for example

Title: Re: GAD newbie Database Query / Stored Procedure
Post by: René on July 19, 2012, 08:35:32 AM

Hi Rogier,

Following threads should help you:
[url=http://www.sggu.com/smf/index.php/topic,6541.msg28484.html#msg28484]http://www.sggu.com/smf/index.php/topic,6541.msg28484.html#msg28484[/url]
[url=http://www.sggu.com/smf/index.php/topic,6810.msg29638.html#msg29638]http://www.sggu.com/smf/index.php/topic,6810.msg29638.html#msg29638[/url]

R.