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
