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.<div>
<br></div><div>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.</div><div><br><div class="gmail_quote">On Mon, Feb 8, 2010 at 2:40 PM, Gavin Henry <span dir="ltr"><<a href="mailto:gavin.henry@gmail.com">gavin.henry@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi all,<br>
<br>
We're testing FS and mod_nibblebill for a wholesale platform. So far<br>
it's working ok via ODBC. I'd like to know how you'd recommend loading<br>
A-Z rates that have peak, offpeak and weekend rates.<br>
<br>
I was thinking about using the conditions for destination to match the<br>
time of day:<br>
<br>
<a href="http://wiki.freeswitch.org/wiki/Dialplan_XML#Condition" target="_blank">http://wiki.freeswitch.org/wiki/Dialplan_XML#Condition</a><br>
<br>
so each rate would be listed a few times in order to match the time of day.<br>
<br>
For the destinations I was going to do<br>
(<a href="http://wiki.freeswitch.org/wiki/Mod_nibblebill#Different_Rates_per_Area_Code" target="_blank">http://wiki.freeswitch.org/wiki/Mod_nibblebill#Different_Rates_per_Area_Code</a>):<br>
<br>
<extension name="uk_landline"><br>
<condition field="destination_number" expression="^0([1-3]\d{9})$"><br>
<action application="set" data="nibble_account=${accountcode}"/><br>
<action application="set" data="nibble_rate=rate_tbc"/><br>
<action application="bridge"<br>
data="sofia/gateway/<a href="http://sip.myprovider.co.uk/44$1" target="_blank">sip.myprovider.co.uk/44$1</a>"/><br>
</condition><br>
</extension><br>
<br>
<br>
I presume I can have (newbie here) multiple conditions for the time of day?<br>
<br>
My last question is if there is a better way to load the A-Z rates<br>
rather than a massive XML file, like from a DB. I'm still new to FS so<br>
not sure how to pull in this data. I presume I could just pull it in<br>
via mod_xml_curl and do the same with saving the CDRs to a RDBMS using<br>
mod_xml_cdr?<br>
<br>
Is this a best practice going to the RDBMS (I'm part of the OpenLDAP<br>
project so always call it RDBMS so as not confuse a user thinking<br>
about the OpenLDAP database backend) via mod_xml_curl? I would thought<br>
going directly to the RDBMS is better? I suppose it depends on the<br>
system architecture.<br>
<br>
Thanks,<br>
<br>
Gavin.<br>
<br>
<br>
--<br>
<a href="http://www.suretecsystems.com/services/openldap/" target="_blank">http://www.suretecsystems.com/services/openldap/</a><br>
<a href="http://www.suretectelecom.com" target="_blank">http://www.suretectelecom.com</a><br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a 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>
</blockquote></div><br><br clear="all"><br>-- <br>-Rupa<br>
</div>