[asterisk-users] IVR and MySQL

2007-08-14 Thread Fabio Ardeola
Hi Does somebody know if I can save the answers made by the caller person on the IVR menu in a MySQL Database? If yes, can I save the CallerID as well? Thanks, Fabio Luggage? GPS? Comic books? Check out

Re: [asterisk-users] IVR and MySQL

2007-08-14 Thread Thiago Maluf
Hi Fabio, of course that you can. One way to do it is working with app MYSQL(), where you will put your sql as argumment. read more in http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL good luck, Thiago Maluf Resende. 2007/8/14, Fabio Ardeola <[EMAIL PROTECTED]>: > > Hi > > Does somebody kno

Re: [asterisk-users] IVR and MySQL

2007-08-14 Thread Atis
On 8/14/07, Thiago Maluf <[EMAIL PROTECTED]> wrote: > Hi Fabio, > of course that you can. > > One way to do it is working with app MYSQL(), where you will put your sql as > argumment. > read more in > http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL That's possible, but i wouldn't recommend o

Re: [asterisk-users] IVR and MySQL

2007-08-14 Thread James FitzGibbon
On 8/14/07, Atis <[EMAIL PROTECTED]> wrote: > > That's possible, but i wouldn't recommend on large production system. > Using MySQL you would need to connect and disconnect all the time, and > it takes resources.. I would suggest to append that info to CDR > userfield (if you are storing your CDR i

Re: [asterisk-users] IVR and MySQL

2007-08-14 Thread Fabio Ardeola
James / Atis / Thiago Let say that the user entry during the call is a reference number of a house to rent. Would be possible to check if the reference number is a valid entry on the MySQL database and then base on its answer define the next menu item on the IVR menu. Thanks, Fabio --- James Fi

Re: [asterisk-users] IVR and MySQL

2007-08-14 Thread James FitzGibbon
On 8/14/07, Fabio Ardeola <[EMAIL PROTECTED]> wrote: > > > Let say that the user entry during the call is a > reference number of a house to rent. Would be possible > to check if the reference number is a valid entry on > the MySQL database and then base on its answer define > the next menu item on

Re: [asterisk-users] IVR and MySQL

2007-08-16 Thread Jon Farmer
I write such apps all the time, i have written IVR apps that talk to SQL Server (Sage500), MySQL, our credit/debit card processing system. Regards Jon --- Thiago Maluf <[EMAIL PROTECTED]> wrote: > Hi Fabio, > of course that you can. > > One way to do it is working with app MYSQL(), where >

Re: [asterisk-users] IVR and MySQL

2007-08-16 Thread Jon Schøpzinsky
31206709 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Atis Sent: 14. august 2007 14:14 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] IVR and MySQL On 8/14/07, Thiago Maluf <[EMAIL PROTECTED]> wrote: >

Re: [asterisk-users] IVR and MySQL

2007-08-16 Thread Andreas Sikkema
> > One way to do it is working with app MYSQL(), where you > will put your sql as > > argumment. > > read more in > > http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL > > That's possible, but i wouldn't recommend on large production system. > Using MySQL you would need to connect and discon

Re: [asterisk-users] IVR and MySQL

2007-08-16 Thread Atis
On 8/16/07, Andreas Sikkema <[EMAIL PROTECTED]> wrote: > Using MYSQL() (or equivalent) heavily in the dialingplan is IMHO the > nicest way of doing things like this. You can do lots of simultaneous > calls before getting into trouble. Well, it is simple, but creates a LOT of load. Plus, if you mig