Is there any method in Asterisk to enable the updating process into another SQL database through entering IVR options during the call. Thanks a lot. _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090524/2bbda876/attachment.htm
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 --
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. Thanks a lot.> Date: Sun, 24 May 2009 22:15:31 +0200 > From: philipp.kempgen at amooma.de > To: asterisk-users at 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_________________________________________________________________ More than messages?check out the rest of the Windows Live?. http://www.microsoft.com/windows/windowslive/ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090525/b512836d/attachment.htm
Un-top-posting...>> 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.>> Date: Sun, 24 May 2009 22:15:31 +0200 >> From: philipp.kempgen at 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_*() functionsOn Mon, 25 May 2009, Torintino T wrote:> 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 at sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000
Perl and AGI Piece of cake.!!! *-------------------------------------------------------* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-809-849-8087 * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo comun" *-------------------------------------------------------* ________________________________> From: torintino1 at hotmail.com > To: asterisk-users at lists.digium.com > Date: Mon, 25 May 2009 22:28:54 +0300 > Subject: Re: [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. > > > > Thanks a lot. > > > > > >> Date: Sun, 24 May 2009 22:15:31 +0200 >> From: philipp.kempgen at amooma.de >> To: asterisk-users at 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_________________________________________________________________ Get 5 GB of storage with Windows Live Hotmail. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_5gb_112008
> > 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" *-------------------------------------------------------* _________________________________________________________________ Windows Live Hotmail now works up to 70% faster. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008
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 at hotmail.com> wrote:> > >> >> 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" > *-------------------------------------------------------* > > _________________________________________________________________ > Windows Live Hotmail now works up to 70% faster. > http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008 > _______________________________________________ > -- 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
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. Good luck! CS From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Torintino T Sent: Monday, May 25, 2009 3:29 PM To: asterisk-users at lists.digium.com Subject: Re: [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. Thanks a lot.> Date: Sun, 24 May 2009 22:15:31 +0200 > From: philipp.kempgen at amooma.de > To: asterisk-users at 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 <http://www.microsoft.com/windows/windowslive/> -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090525/f98b1be7/attachment.htm