GAD newbie Database Query / Stored Procedure

[rogierbosch]

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

[Timur Karimov]

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

WBR

[rogierbosch]

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...

.....

[cavagnaro]

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

[Timur Karimov]

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

[rogierbosch]

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

[rogierbosch]

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

[cavagnaro]

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

[René]

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.