[Freeswitch-users] The best way to IVR talks the Address based on CallerID Number

[William King]

You can do any form of SQL statements in a lua script. Checkout how to
create a dbh connection.

William King
Senior Engineer
Quentus Technologies, INC
1037 NE 65th St Suite 273
Seattle, WA 98115
Main:   (877) 211-9337
Office: (206) 388-4772
Cell:   (253) 686-5518
william.king at quentustech.com

On 07/04/2014 10:53 PM, Normando Hall wrote:
> Hello.
> 
> I am working on an IVR based on FS. This is what I want to do:
> 
> I have a huge database with a few fields: 'phone number' - 'address
> street' - 'address number' - 'address building' - 'address floor' - etc.
> 
> When I receive a call I will query the CallerID into de 'phone number'
> field. If found it, the phrase macro says something like "Hello, your
> address is xxxx, xxx" If the caller confirm pressing 1, then we will use
> this query results to activate other systems in the server, such as
> storing or trigger an event. I was recorder each street name and numers
> with an annoucer (broadcaster) into a separate wav files.
> 
> I was reading about *mod_cidlookup*, but I don't know if this is the
> better way to achieve this. Another way I see are related to*mod_db*,
> *mod_dptools*, *mod_easyroute*, etc.
> 
> Thanks for your advices.
> 
> Normando Hall
> 
> 
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0x1DD0C305.asc
Type: application/pgp-keys
Size: 30859 bytes
Desc: not available
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140705/f662828b/attachment-0001.bin