Posted: Sun May 24, 2009 7:21 pm Post subject: [asterisk-users] Asterisk, SQL Database Update
Torintino T schrieb:
Quote:
Is there any method in Asterisk to enable the updating process
into another SQL database through entering IVR options during the call.
Depending on what you are trying to do there are various solutions:
Channel Event Logging (CEL) - http://www.asterisk.org/node/48358
AGI
System()
ODBC_*() functions
Posted: Mon May 25, 2009 6:37 pm Post subject: [asterisk-users] Asterisk, SQL Database Update
Thanks for your helpful reply.
I am not so good in coding.
simply all i need is as follow
When a call comes, goes into an IVR, and then depending on the entry option
it will connect to a remote SQL Database, to check the pre-existed data,
and in the end of the IVR the caller will enter an option that will need to be written in the SQL Database.
Can you please give me a general scenrio how this will be achieved.
and which files that i will need to modify.
Torintino T schrieb:
> Is there any method in Asterisk to enable the updating process
> into another SQL database through entering IVR options during the call.
Depending on what you are trying to do there are various solutions:
Channel Event Logging (CEL) - http://www.asterisk.org/node/48358
AGI
System()
ODBC_*() functions
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
check out the rest of the Windows Live™. More than mail–Windows Live™ goes way beyond your inbox. More than messages
Posted: Mon May 25, 2009 6:50 pm Post subject: [asterisk-users] Asterisk, SQL Database Update
Un-top-posting...
Quote:
> Torintino T schrieb:
>
>> Is there any method in Asterisk to enable the updating process into
>> another SQL database through entering IVR options during the call.
Quote:
> Date: Sun, 24 May 2009 22:15:31 +0200
> From: philipp.kempgen@amooma.de
>
> Depending on what you are trying to do there are various solutions:
> Channel Event Logging (CEL) - http://www.asterisk.org/node/48358
> AGI
> System()
> ODBC_*() functions
On Mon, 25 May 2009, Torintino T wrote:
Quote:
Thanks for your helpful reply.
I am not so good in coding.
simply all i need is as follow
When a call comes, goes into an IVR, and then depending on the entry
option it will connect to a remote SQL Database, to check the
pre-existed data, and in the end of the IVR the caller will enter an
option that will need to be written in the SQL Database.
Can you please give me a general scenrio how this will be achieved. and
which files that i will need to modify.
1) Try the database functions in dialplan (extensions.[ael|conf).
2) If it starts to get ugly, code it up as an AGI in the language of your
choice -- I prefer C.
3) Hire somebody to whack it out.
I think all database operations are ugly in dialplan, but I admit to most
of my biases :)
Thanks in advance,
------------------------------------------------------------------------
Steve Edwards sedwards@sedwards.com Voice: +1-760-468-3867 PST
Newline Fax: +1-760-731-3000
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
When a call comes, goes into an IVR, and then depending on the entry option
it will connect to a remote SQL Database, to check the pre-existed data,
and in the end of the IVR the caller will enter an option that will need to be written in the SQL Database.
Can you please give me a general scenrio how this will be achieved.
and which files that i will need to modify.
Thanks a lot.
> Date: Sun, 24 May 2009 22:15:31 +0200
> From: philipp.kempgen@amooma.de
> To: asterisk-users@lists.digium.com
> Subject: Re: [asterisk-users] Asterisk, SQL Database Update
>
> Torintino T schrieb:
>> Is there any method in Asterisk to enable the updating process
>> into another SQL database through entering IVR options during the call.
>
> Depending on what you are trying to do there are various solutions:
> Channel Event Logging (CEL) - http://www.asterisk.org/node/48358
> AGI
> System()
> ODBC_*() functions
>
>
> Philipp Kempgen
> --
> AMOOMA GmbH - Bachstr. 126 - 56566 Neuwied -> http://www.amooma.de
> Geschäftsführer: Stefan Wintermeyer, Handelsregister: Neuwied B14998
> Asterisk: http://the-asterisk-book.com - http://das-asterisk-buch.de
> Videos of the AMOOCON VoIP conference 2009 -> http://www.amoocon.de
> --
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
________________________________
check out the rest of the Windows Live™.
More than mail–Windows Live™ goes way beyond your inbox.
More than messages
_________________________________________________________________
Posted: Mon May 25, 2009 8:08 pm Post subject: [asterisk-users] Asterisk, SQL Database Update
Quote:
Thanks for your helpful reply.
I am not so good in coding.
simply all i need is as follow
When a call comes, goes into an IVR, and then depending on the entry option
it will connect to a remote SQL Database, to check the pre-existed data,
and in the end of the IVR the caller will enter an option that will need to be written in the SQL Database.
Can you please give me a general scenrio how this will be achieved.
and which files that i will need to modify.
I think that if you are not good coding you will have a few problems.
Maybe, the best solution 4u is hire external to do that. It is simple
but just in dialplan it is so difficult with AGI it is so easy but
you dont want coding.
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-849-8087
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun"
*-------------------------------------------------------*
Posted: Mon May 25, 2009 9:03 pm Post subject: [asterisk-users] Asterisk, SQL Database Update
If you have asterisk addons installed you can use the mysql
applications to make queries. I find it to be very easy if you know
how to do select and insert queries and understand the basic mechanism
of the dialplan. Other than that, you may want to hire someone to do it.
Sent from my iPod
On May 25, 2009, at 5:03 PM, Edwin Quijada
<listas_quijada@hotmail.com> wrote:
Quote:
>
> Thanks for your helpful reply.
>
>
>
> I am not so good in coding.
>
>
>
> simply all i need is as follow
>
>
>
> When a call comes, goes into an IVR, and then depending on the
> entry option
>
> it will connect to a remote SQL Database, to check the pre-existed
> data,
>
> and in the end of the IVR the caller will enter an option that will
> need to be written in the SQL Database.
>
>
>
> Can you please give me a general scenrio how this will be achieved.
>
> and which files that i will need to modify.
>
I think that if you are not good coding you will have a few problems.
Maybe, the best solution 4u is hire external to do that. It is simple
but just in dialplan it is so difficult with AGI it is so easy but
you dont want coding.
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-849-8087
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera
de lo comun"
*-------------------------------------------------------*
Posted: Mon May 25, 2009 10:42 pm Post subject: [asterisk-users] Asterisk, SQL Database Update
Nothing is difficult my friend. If you dedicate a few cups of coffee to it, a couple of days, and do some good googling, you will get it done yourself.
When a call comes, goes into an IVR, and then depending on the entry option
it will connect to a remote SQL Database, to check the pre-existed data,
and in the end of the IVR the caller will enter an option that will need to be written in the SQL Database.
Can you please give me a general scenrio how this will be achieved.
and which files that i will need to modify.
Thanks a lot.
> Date: Sun, 24 May 2009 22:15:31 +0200
> From: philipp.kempgen@amooma.de
> To: asterisk-users@lists.digium.com
> Subject: Re: [asterisk-users] Asterisk, SQL Database Update
>
> Torintino T schrieb:
> > Is there any method in Asterisk to enable the updating process
> > into another SQL database through entering IVR options during the call.
>
> Depending on what you are trying to do there are various solutions:
> Channel Event Logging (CEL) - http://www.asterisk.org/node/48358
> AGI
> System()
> ODBC_*() functions
>
>
> Philipp Kempgen
> --
> AMOOMA GmbH - Bachstr. 126 - 56566 Neuwied -> http://www.amooma.de
> Geschäftsführer: Stefan Wintermeyer, Handelsregister: Neuwied B14998
> Asterisk: http://the-asterisk-book.com - http://das-asterisk-buch.de
> Videos of the AMOOCON VoIP conference 2009 -> http://www.amoocon.de
> --
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
check out the rest of the Windows Live™. More than mail–Windows Live™ goes way beyond your inbox. More than messages
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum