Page 1 of 1

IVR Database Read Write and Intelligent queuing

PostPosted: Sat May 11, 2013 9:06 am
by bghayad
Hello;

VERSION: 2.4-309a, BUILD: 110430-1642, GoAutoDial CE 2.1, 2.6.18-238.9.1.el5.goPAE (SMP), Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz, Single Machine, Vtiger V5

Once the call reach for the telephony server, I need to be able to do database query (read and write) and get a customer profile and sending the call to the proper queue based on the customer information (his language, class, status, address, ... etc). How I can do this?

Regards
Bilal

Re: IVR Database Read Write and Intelligent queuing

PostPosted: Sat May 11, 2013 7:25 pm
by mflorell
What database is this information stored in? How do you connect to that database?

Re: IVR Database Read Write and Intelligent queuing

PostPosted: Sun May 12, 2013 2:58 am
by bghayad
Generally the databases are: oracle, MySQL, MSSQL and PostgreSQL.
As you know that these databases are possible to connect to it via ODBC or ADO or from php ...
What are the possible methods and scenarios to do this?

Regards
Bilal

Re: IVR Database Read Write and Intelligent queuing

PostPosted: Sun May 12, 2013 9:27 am
by mflorell
Custom AGI scripting.

Re: IVR Database Read Write and Intelligent queuing

PostPosted: Tue Oct 01, 2013 3:19 am
by bghayad
OK, custom AGI scripting for read/write from the database, but after getting and writing the data, I need to play menu that is configured in vicidial, also I need to route to the proper queue (based on the read data from the database), how this will be done? I will need to use the vicidial AGIs within my custom AGI or I need build complete custom AGI that includes even the routing for queue and playing the menus and in this case, I will write same as vicidial AGI scripts :) ! What will be the most practical and simple way?

Thanks for the help.

Regards
Bilal