Hi, Is there a way to pass Caller Id to mod lcr and somehow to include it in a custom sql. currently my dialplan looks like this: <extension name="LCR"> <condition field="destination_number" expression="^1(\d+)$" break="never"> <action application="set" data="bypass_media=true" /> <action application="lcr" data="$1"/> <action application="bridge" data="${lcr_auto_route}"/> </condition> </extension> i guess that Caller_ID is already passed but i was thinking about making some LCR decisions based on Destination number and Caller_ID /Interstate,Intrastate for example/ Thanks for your time Regards Chav
On 2/16/2009 7:40 PM, Tchavdar Paskov wrote:
Hi, Is there a way to pass Caller Id to mod lcr and somehow to include it in a custom sql. currently my dialplan looks like this:
<extension name="LCR"> <condition field="destination_number" expression="^1(\d+)$" break="never"> <action application="set" data="bypass_media=true" /> <action application="lcr" data="$1"/> <action application="bridge" data="${lcr_auto_route}"/> </condition> </extension> i guess that Caller_ID is already passed but i was thinking about making some LCR decisions based on Destination number and Caller_ID /Interstate,Intrastate for example/
Thanks for your time
mod_lcr doesn't make any decisions based on caller id. Probably the best way to handle this would be to use profiles. You could extract the areacode and use that to determine which profile to use. It would be awkward if you want to handle all area codes -- but for a smaller set of area codes it might be sufficient.
Regards Chav
i was thinking more in direction of building custom sql that deals with both Caller_id and destination number. I'm aware that the current off the box mod_lcr has no such ability and that's why i asked if there is a way from dial plan to pass the caller_id_number channel variable to mod_lcr. Thanks ----- Original Message ----- From: "Rupa Schomaker (lists)" <freeswitch-users@lists.rupa.com> Date: Monday, February 16, 2009 9:01 pm Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR To: freeswitch-users@lists.freeswitch.org
On 2/16/2009 7:40 PM, Tchavdar Paskov wrote:
Hi, Is there a way to pass Caller Id to mod lcr and somehow to include it in a custom sql. currently my dialplan looks like this:
<extension name="LCR"> <condition field="destination_number" expression="^1(\d+)$" break="never"> <action application="set" data="bypass_media=true" /> <action application="lcr" data="$1"/> <action application="bridge" data="${lcr_auto_route}"/> </condition> </extension> i guess that Caller_ID is already passed but i was thinking about making some LCR decisions based on Destination number and Caller_ID> > /Interstate,Intrastate for example/
Thanks for your time
mod_lcr doesn't make any decisions based on caller id. Probably the best way to handle this would be to use profiles. You could extract the areacode and use that to determine which profile to use. It would be awkward if you want to handle all area codes -- but for a smaller set of area codes it might be sufficient.
Regards Chav
_______________________________________________ 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 also have another question. When i insert my custom query it looks like the profile is loaded successfully but then when i place a call or use lcr ########## default /which is where i defined the sql query/ and check the console output turns out that the switch is using the default sql guery . How i can make sure that the custom sql is the only one that is to be executed. /All required fields in the custom sql are in accordance with the requirements - it returns the exact required names and returned field number is also correct/. Thank you agai for your time Chav ----- Original Message ----- From: Tchavdar Paskov <chavpaskov@shaw.ca> Date: Monday, February 16, 2009 10:44 pm Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR To: freeswitch-users@lists.freeswitch.org
i was thinking more in direction of building custom sql that deals with both Caller_id and destination number. I'm aware that the current off the box mod_lcr has no such ability and that's why i asked if there is a way from dial plan to pass the caller_id_number channel variable to mod_lcr. Thanks
----- Original Message ----- From: "Rupa Schomaker (lists)" <freeswitch-users@lists.rupa.com> Date: Monday, February 16, 2009 9:01 pm Subject: Re: [Freeswitch-users] Passing Caller_ID to MOD_LCR To: freeswitch-users@lists.freeswitch.org
On 2/16/2009 7:40 PM, Tchavdar Paskov wrote:
Hi, Is there a way to pass Caller Id to mod lcr and somehow to include it in a custom sql. currently my dialplan looks like this:
<extension name="LCR"> <condition field="destination_number" expression="^1(\d+)$" break="never"> <action application="set" data="bypass_media=true" /> <action application="lcr" data="$1"/> <action application="bridge" data="${lcr_auto_route}"/> </condition> </extension> i guess that Caller_ID is already passed but i was thinking about making some LCR decisions based on Destination number and Caller_ID> > /Interstate,Intrastate for example/
Thanks for your time
mod_lcr doesn't make any decisions based on caller id. Probably the best way to handle this would be to use profiles. You could extract the areacode and use that to determine which profile to use. It would be awkward if you want to handle all area codes -- but for a smaller set of area codes it might be sufficient.
Regards Chav
_______________________________________________ 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
On 2/17/2009 1:18 AM, Tchavdar Paskov wrote:
I also have another question. When i insert my custom query it looks like the profile is loaded successfully but then when i place a call or use
lcr ########## default /which is where i defined the sql query/ and check the console output turns out that the switch is using the default sql guery .
lcr_admin show profiles should show you the profiles loaded and the profile's settings. "default" is a reserved profile name -- I should probably prevent that from loading.
How i can make sure that the custom sql is the only one that is to be executed. /All required fields in the custom sql are in accordance with the requirements - it returns the exact required names and returned field number is also correct/.
Thank you agai for your time Chav
Try running with debug logging turned on (f8 on the console). This will show the sql being passed to the database. == Regarding passing the callerid to the custom sql, let me see what I can come up with...
"default" is a reserved profile name -- I should probably prevent that from loading.
correction, default is not reserved...
Regarding passing the callerid to the custom sql, let me see what I can come up with...
You can now specify channel variables in your custom sql. So, you should be able to pass CID or a subset of CID to your custom sql. I've updated the wiki with info on this. beware: channel vars only work when called in the context of a session. Using a profile that uses a custom sql with channel variables from the commandline will result in an error. -Rupa
Rupa Schomaker (lists) wrote:
"default" is a reserved profile name -- I should probably prevent that from loading.
correction, default is not reserved...
Regarding passing the callerid to the custom sql, let me see what I can come up with...
You can now specify channel variables in your custom sql. So, you should be able to pass CID or a subset of CID to your custom sql. I've updated the wiki with info on this.
beware: channel vars only work when called in the context of a session. Using a profile that uses a custom sql with channel variables from the commandline will result in an error.
-Rupa
_______________________________________________ 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
do i have to upgrade to the latest trunk in order to pass channel variables to mod_lcr? Currently the version used is 1.0.trunk (12134M) Regards Chav
Rupa Schomaker (lists) wrote:
do i have to upgrade to the latest trunk in order to pass channel variables to mod_lcr? Currently the version used is 1.0.trunk (12134M) Regards Chav
You need at least 12204.
_______________________________________________ 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
Thank you very much. I'll try it and will keep you postged. Chav
participants (3)
-
Chav Paskov
-
Rupa Schomaker (lists)
-
Tchavdar Paskov