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 you

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: Hi Fabio

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 disconnect all

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 might

[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

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 know if

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 on large

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 in

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

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 the IVR