[asterisk-users] Rate sheet "normalization"

[Markus]

With like 10 different ratesheets from 10 different providers, of which 
many change their rates every few days, manually doing it in Excel is 
too time consuming...


Am 15.03.2012 07:26, schrieb SamyGo:
> could MS-Excel possibly be the easiest way to do that normalization !
> just merge two rate sheets put some formulas in there and use it in your
> A2billing or XYZ tool  !
>
> On Thu, Mar 15, 2012 at 10:07 AM, Ast Coder <asteriskcoding at gmail.com
> <mailto:asteriskcoding at gmail.com>> wrote:
>
>       A2Billing doesn't do that. A2Billing in fact has a lot of
>     shortcomings one of which is this exact issue.
>
>     I would suggest running rate sheets against each other for finding
>     true LCR and then only uploading the rates that are cheaper into the
>     system. In most cases there are not such high differences but if
>     there are then this is the only way. I know rate normalization talk
>     comes up all the time on FreeSwitch Freenode channel and it probably
>     does on OpenSIPs as well. Check there for some good advice.
>
>
>
>
>     On Wed, Mar 14, 2012 at 7:35 PM, Benny Amorsen
>     <benny+usenet at amorsen.dk <mailto:benny%2Busenet at amorsen.dk>> wrote:
>
>         Markus <universe at truemetal.org <mailto:universe at truemetal.org>>
>         writes:
>
>          > Does such a thing exist?
>
>         How does a2billing do it? It should be pretty easy in an AGI. If
>         you can
>         afford a linear lookup per call, just grep through the array of
>         prefixes
>         to find the ones matching a particular call, then pick the
>         cheapest from
>         the results.
>
>         If you need something faster than linear it gets tricky. It would be
>         tempting to preprocess the list to say 5 digits, do a hash lookup on
>         those, and then use the process above.
>
>
>         /Benny
>
>
>         --
>         _____________________________________________________________________
>         -- Bandwidth and Colocation Provided by
>         http://www.api-digital.com --
>         New to Asterisk? Join us for a live introductory webinar every
>         Thurs:
>         http://www.asterisk.org/hello
>
>         asterisk-users mailing list
>         To UNSUBSCRIBE or update options visit:
>         http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
>     --
>     _____________________________________________________________________
>     -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>     New to Asterisk? Join us for a live introductory webinar every Thurs:
>     http://www.asterisk.org/hello
>
>     asterisk-users mailing list
>     To UNSUBSCRIBE or update options visit:
>     http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                 http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>     http://lists.digium.com/mailman/listinfo/asterisk-users