VM PRO integration with SQL database

[VanZenden]

Hi,

I'd like to integrate SQL database with VM PRO so when external calls come in you can also see their names (just like LDAP). I've made several modofications but I can't get it working...

I've created a test call flow with for one user:

1.) in Specific Start Point I've created Leave entry,
Start point is connected to GoTo action (which is routed to Module called SQLDB

2.)In module SQLDB I've done this:
- Database Open: pointed to SQL database, Test connection is ok.
- Databas Execute: with SQL wizard I've created entry:

select acName from TableContacts
where acPhone = '$CLI'

- Database Get Data: retrieve the next in the list.
Success is pointed to Assisted transfer

Is there anything else I should do?

have all licences (DEMO KIT)

IPO 500 R4.2(4)
VM PRO R4.2(19)

 

[SuperJenks]

Unless I dont understand your question, forget sql, you should be able to enter all your customers/outside callers phone numbers in the directory in manager that will cross reference the name you associate it with. This should be easy. Infact, you can make a excel spreadsheet (CSV) and import it into the manager for ease of typing it all in.

ACS IPO-I

 

[intrigrant]

Did you put $DB0 in the transfer action as a TAG?

 

[VanZenden]

Directory in Manager is not an option. MS Access & SQL are.

intrigrant,

in trasfer action (under Specific tab) there are 3 options (Destination, Source of transfer, Description) to put $DB0, but where exactly?

is it $DB0 or $DBD[0]?

 

[intrigrant]

Put $DBD[x] in the Description box were x can be form 0 to 5

 

[VanZenden]

Well, did that, but no luck.

I'll try with MS Access database, because I have working call-flow when someone called and if his call number was in Access database then his was routed to a AA menu, if caller number was not in database he was routed to a reception...

 

[Escorthosis]

Keep in mind that $CLI holds the line-prefix as well as the number.
So if you cell phone is 06.... and the lines are setup with the prefix 0, the $CLI would hold 006....

So if you are matching it to a database entry of 06... this would be no match.

 

[VanZenden]

I know

 

[intrigrant]

did you use dbgview to see what data is retrieved?

 

[VanZenden]

if I knew where to find that dbgview, i would

 

[intrigrant]

http://marketingtools.avaya.com/knowledgebase/ipoffice/general/debug/index.htm