asterisk users - Jul 2006 - 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.

You should look for dialplan (extensions.conf) commands. They include
everything you mansion. Examples include mysql queries. Maybe you spend
sometime for Sybase connections.


-----Original Message-----
From: Dirk Enrique Seiffert [mailto:ds@caribenet.com] 
Sent: Friday, July 07, 2006 4:16 PM
To: asterisk-users@lists.digium.com
Subject: [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

Dirk Enrique Seiffert ha scritto:
> Hello,
> 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?
You should look at the AGI interface, so from the dialplan you can
call a program written in any language that made the "db" query.

I made a sample for a customer with this kind of database check, in
perl this is something like 5 minutes of programming.

Bye.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20060707/2c208d23/signature.pgp

Dirk Enrique Seiffert wrote:
>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
>
>
>  
>
Take a look here:

http://www.voip-info.org/wiki-Asterisk+AGI

This will get you going on AGI. From an AGI script, you can query 
databases. We do several apps with PHP and MySQL.


Mike Clark

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@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com]En nombre de Dirk
Enrique Seiffert
Enviado el: Viernes, 07 de Julio de 2006 10:16 a.m.
Para: asterisk-users@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