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 to*mod_db*, *mod_dptools*, *mod_easyroute*, etc. Thanks for your advices. Normando Hall
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@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@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
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
But this will not scale very well, it has to load and execute the interpreter for each call, but if there are not very many, it should work fine. Stanislav Sinyagin <ssinyagin@yahoo.com> wrote:
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 ---------------------------------------------------- Alternatives:
---------------------------------------------------- _________________________________________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
of course, you're completely right. In my case, it's only one human user behind the server. It would scale perfectly to one call every few seconds, but not much more. ________________________________ From: "covici@ccs.covici.com" <covici@ccs.covici.com> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Cc: "nhall@unixlan.com.ar" <nhall@unixlan.com.ar> Sent: Sunday, July 6, 2014 12:06 AM Subject: Re: [Freeswitch-users] The best way to IVR talks the Address based on CallerID Number But this will not scale very well, it has to load and execute the interpreter for each call, but if there are not very many, it should work fine. Stanislav Sinyagin <ssinyagin@yahoo.com> wrote:
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 ---------------------------------------------------- Alternatives:
---------------------------------------------------- _________________________________________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com _________________________________________________________________________ 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
participants (4)
-
covici＠ccs.covici.com
-
Normando Hall
-
Stanislav Sinyagin
-
William King