Sending DTMF tones to a CRM database for lookup


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

Any ideas on how to go about it ?

Asterisk 11.14.2 built by root @ on a x86_64 running Linux on 2014-12-10 18:13:31 UTC

[[email protected] ~]# cat /etc/schmooze/pbx-version

FreePBX is licensed under the GPL
Copyright© 2007-2017

How much of this are you building?

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.

If the web page supports get requests with the clients number as a variable then you can do this using Adat from TTTelecom.