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

[Gerry Jacobsen]

Ruddy

> Run a script that will loop on every existing npa-nxx

that is what is not wanted. Internationally there is no list of dialing codes that is chiseled in stone. Any operator can create break-out codes as deep as he wishes.

Using predefined destination code lists has usually two results:

1. Your rate is too high in relation to the market, no business.
2. Your rate it too low, you get cherry-picked (if you dont have some sort of loss protection)

Gerry


On 27 Sep 2012, at 15:26, Ruddy Gbaguidi wrote:

> 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
>  
> --
> _____________________________________________________________________
> -- 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/9ca20fd9/attachment-0001.htm>