[asterisk-users] IVR - Automatic Attendant database query

[Fabio]

one example using realtime:

on your database:

table: users
field: id 		>> user id
fiel: enabled 	>> 1 if user enabled

extconfig.conf

mydatabase => mysql,asterisk,users

extensions.conf

exten => s,n,Read(userid,please-your-id,3)  
exten => s,n,Realtime(mydatabase,id,${userid},user_)
exten => s,n,GotoIf($["${user_enabled}" = "1"]?s-login,1)
exten => s,n,PlayBack(ByBy)
exten => s,n,HangUp

exten s-login,1,PlayBack(HiMan)
...

-----Mensaje original-----
De: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com]En nombre de Dirk
Enrique Seiffert
Enviado el: Viernes, 07 de Julio de 2006 10:16 a.m.
Para: asterisk-users at lists.digium.com
Asunto: [asterisk-users] IVR - Automatic Attendant database query


Hello,

I am new to Asterisk, looking for a PBX solution doing and automatic
response based on a database query. I spent some hours googling, reading
manuals without too much luck. (Maybe I am just blind ...)

What we want to reach:

Caller dials in, gets prompted to dial an extension depending on the
information he is looking for. Lets say "Dial 1 if you want to know if
your account is active". After dialing the number caller gets prompted to
dial his personal code. Based on this code we need do to a query to an
external Sybase database. Depending on the query result we will play a
recording to the caller. "Yes, your account is active", "Sorry, your
account has been disabled..."

I couldn't find any examples on the auto attendent reading responses from
a database, though it looks like a common task to me. Can anybody provide
some hints, links, directions or experiences for this kind of
configuration?

Thanks a lot

Dirk


-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

-- 
Este mensaje ha sido analizado por MailScanner
en busca de viruses y otros contenidos peligrosos,
y se considera que est limpio.

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users