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: [email protected] > [mailto:[email protected]] 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 <[email protected]> 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: [email protected] > [mailto:[email protected]] 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
-- _____________________________________________________________________ -- 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
