<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt"><div><span>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.</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent;
font-style: normal;"><span>The script initialization and local MySQL lookups are taking less than 10ms, so the caller does not notice any delays.</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span>When it's finished, I'm planning to write a short article with details.</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div><br></div> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 10pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Normando Hall <nhall@unixlan.com.ar><br> <b><span style="font-weight: bold;">To:</span></b> FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Saturday, July 5, 2014 7:53 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Freeswitch-users] The best way to IVR talks the Address based on CallerID Number<br> </font> </div> <div class="y_msg_container"><br><div id="yiv6091556179">
<div>
Hello.<br>
<br>
I am working on an IVR based on FS. This is what I want to do:<br>
<br>
I have a huge database with a few fields: 'phone number' - 'address
street' - 'address number' - 'address building' - 'address floor' -
etc.<br>
<br>
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.<br>
<br>
I was reading about <b>mod_cidlookup</b>, but I don't know if this
is the better way to achieve this. Another way I see are related to<b>
mod_db</b>, <b>mod_dptools</b>, <b>mod_easyroute</b>, etc.<br>
<br>
Thanks for your advices.<br>
<br>
Normando Hall<br>
<br>
</div>
</div><br>_________________________________________________________________________<br>Professional FreeSWITCH Consulting Services:<br><a ymailto="mailto:consulting@freeswitch.org" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br><a href="http://www.freeswitchsolutions.com/" target="_blank">http://www.freeswitchsolutions.com</a><br><br>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br><a href="http://www.cudatel.com/" target="_blank">http://www.cudatel.com</a><br><br>Official FreeSWITCH Sites<br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br><a href="http://wiki.freeswitch.org/" target="_blank">http://wiki.freeswitch.org</a><br><a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com</a><br><br>FreeSWITCH-users mailing list<br><a ymailto="mailto:FreeSWITCH-users@lists.freeswitch.org"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br><br><br></div> </div> </div> </div></body></html>