Look at using mod_lcr for doing your A-Z rates. You can categorize your peak/offpeak/wkend rates as different profiles and then lookup based on those profiles. mod_lcr is very flexible in that you can also specify your own custom sql so if you are familiar with sql you could even put your peak/offpeak/wkend etc decisions in the SQL or in a stored procedure in the db. If you are going down the path of custom_sql, then use the patch in jira since custom_sql behavior will change post 1.0.5 and the new behavior is much more flexible. On Mon, Feb 8, 2010 at 2:40 PM, Gavin Henry <gavin.henry@gmail.com> wrote:
Hi all,
We're testing FS and mod_nibblebill for a wholesale platform. So far it's working ok via ODBC. I'd like to know how you'd recommend loading A-Z rates that have peak, offpeak and weekend rates.
I was thinking about using the conditions for destination to match the time of day:
http://wiki.freeswitch.org/wiki/Dialplan_XML#Condition
so each rate would be listed a few times in order to match the time of day.
For the destinations I was going to do ( http://wiki.freeswitch.org/wiki/Mod_nibblebill#Different_Rates_per_Area_Code ):
<extension name="uk_landline"> <condition field="destination_number" expression="^0([1-3]\d{9})$"> <action application="set" data="nibble_account=${accountcode}"/> <action application="set" data="nibble_rate=rate_tbc"/> <action application="bridge" data="sofia/gateway/sip.myprovider.co.uk/44$1"/> </condition> </extension>
I presume I can have (newbie here) multiple conditions for the time of day?
My last question is if there is a better way to load the A-Z rates rather than a massive XML file, like from a DB. I'm still new to FS so not sure how to pull in this data. I presume I could just pull it in via mod_xml_curl and do the same with saving the CDRs to a RDBMS using mod_xml_cdr?
Is this a best practice going to the RDBMS (I'm part of the OpenLDAP project so always call it RDBMS so as not confuse a user thinking about the OpenLDAP database backend) via mod_xml_curl? I would thought going directly to the RDBMS is better? I suppose it depends on the system architecture.
Thanks,
Gavin.
-- http://www.suretecsystems.com/services/openldap/ http://www.suretectelecom.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
-- -Rupa