[asterisk-biz] Algorithms for generating dialing codes and rates?

[Ruddy Gbaguidi]

Well, this is a classic database job.

Create your customer_rate with npa-nxx.

Run a script that will loop on every existing npa-nxx, and for each on of
them, will query your providers table, get the best one add your margin and
insert into the npa-nxx table.

You can contact me off the list and show me what your schema looks like so I
can help.

 

Thanks

 

From: asterisk-biz-bounces at lists.digium.com
[mailto:asterisk-biz-bounces at lists.digium.com] On Behalf Of Avi Marcus
Sent: 2012-09-27 07:44 
To: Commercial and Business-Oriented Asterisk Discussion
Subject: Re: [asterisk-biz] Algorithms for generating dialing codes and
rates?

 

Ruddy, he's asking the next question...

I have my routing table, but I want to provide the customer with an a-z or
just npa-nxx rate list.

How do I automatically comb my database for each possible destination
sub-type to generate a rate deck, and properly merge carriers with my
pre-defined profit margin?

 

It's not a simple question...




-Avi





On Thu, Sep 27, 2012 at 1:31 PM, Ruddy Gbaguidi <plugworld at micnes.com>
wrote:

Hi
It all depends on your database design.
What you can do is first have a provider's rates table.
It will have the provider name/id, the destination prefix, and price.
So, when you have a full destination number (eg 10 digits), you run a query
where the number contains the provider prefix.
Then you order by prefix length descending and by price ascending..

It is called least cost routing.



-----Original Message-----
From: asterisk-biz-bounces at lists.digium.com
[mailto:asterisk-biz-bounces at lists.digium.com] On Behalf Of Gerry Jacobsen
Sent: 2012-09-27 03:26
To: Commercial and Business-Oriented Asterisk Discussion
Subject: [asterisk-biz] Algorithms for generating dialing codes and rates?

Hello,

is anyone aware of algorithms or software which can generate customer rate
tables with dialing codes and rates from given provider rates - without
having a predefined destination, dialing code table for customers ?

Inputs:

- several offers from providers with break-out codes and rates
- parameter: maximum break-out code length
- parameter: profit margin

Output:
- Customer rate table with breakout codes / destinations and rates

Anyone?

TIA

Gerry


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz



--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-biz mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-biz

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-biz/attachments/20120927/e9b12551/attachment.htm>