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 <[email protected]
<mailto:[email protected]>> 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
<[email protected] <mailto:benny%[email protected]>> wrote:
Markus <[email protected] <mailto:[email protected]>>
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
--
_____________________________________________________________________
-- 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