I haven't don't any nibble bill project so i am not aware of its configuration details but here are some of the feature of mod_nibble (reference to wiki url <a href="http://wiki.freeswitch.org/wiki/Mod_nibblebill">http://wiki.freeswitch.org/wiki/Mod_nibblebill</a>),<br>
<ul><li> Debit credit/cash from accounts real-time
</li><li> Allow for billing at different rates during a single call
</li><li> Allow for warning callers when their balance is low (via audio, in-channel)
</li><li> Allow for disconnecting or re-routing calls when balance is depleted
</li><li> Allow billing functions listed above to operate with multiple concurrent calls
</li></ul>This means you can have packages where you offer users say X amount of free minutes and when they are all used up, you can start charging cost Y WITHOUT dropping user's call. All you need to do is (reference to JM's reply below),<br>
<br>1. Set X in cash column, and deduct 1 per 60 seconds. If you are billing on different time scale then per minute charges then cash value would be,<br><br>Cash = X * 1/T<br><br>Where,<br>X = number of free minutes in package<br>
T = billing interval in minutes<br><br>So, if you have 30 free minutes and 30 second billing interval then cash would be 30 x 1/0.5 = 60.<br><br>2. After X minutes have passed during a call (i.e. when cash value becomes zero), you can change billing rate to whatever you want to charge user on per minute basis (or whatever your billing interval may be) without dropping the call (but it would be good to warn user about it before you start charging him money).<br>
<br>Lastly using different tables schema for mod_nibble may not be a good idea. I recommend using a standard billing table like mod_nibble already has. You can of course extend this schema to store addition information of your choice OR you can use SQL Views to combine different tables and behave as a single table for any pre-existing reports etc. But do remember that SQL Views are normally Read Only in nearly all modren DBMS.<br>
<br>Thank you.<br><br><br><div class="gmail_quote">2009/10/10 João Mesquita <span dir="ltr"><<a href="mailto:jmesquita@freeswitch.org">jmesquita@freeswitch.org</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I am testing the latest version of nibblebill so let me see if I can help you with your questions.<br><br>jm<br><br><div class="gmail_quote"><div class="im">On Fri, Oct 9, 2009 at 12:39 AM, Ahmed Munir <span dir="ltr"><<a href="mailto:ahmedmunir007@gmail.com" target="_blank">ahmedmunir007@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> I want to ask three questions related to mod_nibble bills, as I'm listing down below;<br>
<br>1- Can we select/use dynamic tables for billing using nibble bill?<br></blockquote></div><div>What do you mean for dynamic tables? Like LCR does that you can specify your own SQL statement to be executed? If that's what you are asking, no, but it would be a nice todo.<br>
</div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
2- Can we define more than two tables and attributes in nibblebill.conf.xml?<br></blockquote></div><div>What else do you want to define and how do you imagine it to behave?<br> </div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
3-
As Nibble bill is use to deduct amount of user account, Can we deduct
minutes instead of cash? Because my case is, if a user buy a package
and I only want to deducts his/her minutes. How we can resolve it by
nibble bill? / What other way we can resolve it?<br></blockquote></div><div>When we say cash on the column, we are really saying just a number that is being deducted, that's it. If you deduct 1 every 60 seconds, you will have your "cash" converted to minutes, won't you?<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
<br>Kindly advise soon.<br clear="all"><br>-- <br>Regards,<br><font color="#888888"><br>Ahmed Munir<br><br><br>
</font><br></div>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">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></blockquote></div><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>
<br></blockquote></div><br><br clear="all"><br>-- <br>________________________________________________________<br>| |<br>| FATAL ERROR --- O X |<br>
|_______________________________________________________|<br>| You have moved the mouse. |<br>| Windows must be restarted for the changes to take effect. |<br>| <OK> |<br>
####################################/<br><br><br>Muhammad Shahzad<br>-----------------------------------<br>CISCO Rich Media Communication Specialist (CRMCS)<br>CISCO Certified Network Associate (CCNA)<br>Cell: +92 334 422 40 88<br>
MSN: <a href="mailto:shari_786pk@hotmail.com">shari_786pk@hotmail.com</a><br>Email: <a href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a><br>