I'm implementing something similar with mod_perl. The inbound call is handed over to a Perl script which looks up the caller in the database (which is an import from Google Contacts), checks the availability in another database (which is an export from Google Calendar), and then plays various prompts in one of 3 languages, depending on the caller's prefix and attributes in the phonebook. The script initialization and local MySQL lookups are taking less than 10ms, so the caller does not notice any delays. When it's finished, I'm planning to write a short article with details. ________________________________ From: Normando Hall <nhall@unixlan.com.ar> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Sent: Saturday, July 5, 2014 7:53 AM Subject: [Freeswitch-users] The best way to IVR talks the Address based on CallerID Number 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 tomod_db, mod_dptools, mod_easyroute, etc. Thanks for your advices. Normando Hall _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org