I want to be able to send DTMF tones ( as numbers ) to our local MySQL customer database via an IVR
Basically, caller calls in, gets an IVR to say " Please enter your account number from your telephone keypad " and then those digits get passed to the database for customer lookup.
The lookup then actions a web page pop up with the customer details
There are lots of examples where people dial in and the digits are captured and passed to another application. Check out some of the SugarCRM interfaces for examples. If you’re doing this at the “source code” level, it couldn’t hurt to follow those examples.
There are functions on FreePBX/Asterisk that let you capture digits if you want to completely roll your own.
If someone were to contact us in support to do this, we would create a small block of custom code to prompt for the account code and set a channel variable. You would use Zulu to pop up a URL whenever your users’ phone rings. Depending on your needs, you might need an AGI file to communicate with the CRM as well.