Re: [asterisk-users] Rate sheet normalization
Internet. Senseless and merciless A E [Gmail] wrote 29.03.2012 10:28: Wow! ...all the poor guy wanted to know was if there was any tool available for normalization of carrier rate sheets! -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
On Wednesday 28 March 2012, C. Savinovich wrote: The Way to make money is to help folks use the open source items in the most efficient manner Nobody wants to pay me $2,000 to install and configure A2billing, which in my view, is a fairly low price for my time. There are people who do that for less than $500. I do know the tricks and formulas of how to make money in calling cards, but go tell the customer, they don't care. I don't care either, I am very busy in my consulting business, but it is unfortunate that the better income source for developers just doesn't exist anymore. baldrickSounds like a bag of grapefruits to me!/baldrick -- AJS Answers come *after* questions. -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
Am 28.03.2012 20:17, schrieb C. Savinovich: The Way to make money is to help folks use the open source items in the most efficient manner Nobody wants to pay me $2,000 to install and configure A2billing, which in my view, is a fairly low price for my time. There are people who do that for less than $500. I do know the tricks and formulas of how to make money in calling cards, but go tell the customer, they don't care. I don't care either, I am very busy in my consulting business, but it is unfortunate that the better income source for developers just doesn't exist anymore. I would make much more money if A2billing weren't open source and I would selling copies of my own version of A2billing, probably even developing a better product, definitely with the request that initiated this thread included ;) Why don't you go ahead then and start to code such a program? If you don't have the time personally then you could hire someone and at the same time create a new job in the USA. :) I'm pretty sure there are a bunch of people who would be happy to pay money for a better a2billing. Including myself :) -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
On 03/29/2012 03:47 PM, Markus wrote: I'm pretty sure there are a bunch of people who would be happy to pay money for a better a2billing. Including myself :) Have you looked at jbilling.com ? It's F/OSS with commercial support. Regards, Patrick -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
On Mon, Mar 12, 2012 at 6:52 PM, Markus unive...@truemetal.org wrote: Hi, this question is not Asterisk specific, but since there are so many experts present on this list, maybe its OK to ask anyways. I'm having a hard time normalizing rate sheets from different providers. What I mean with this: the goal is to always get the cheapest rate for a given destination. What I would like to do is throw like 10 rate sheets from different providers together and as output get a single rate sheet with only the cheapest rates. However, some providers are listing a country, lets say Germany, as code 49 with a specific rate, and another provider will list each city individually, and each code separately, e.g. Berlin 4930, Hamburg 4940 etc., and probably different cities have different rates as well. Now, if the 49 route of the first provider is cheaper, my system (a2billing) will still use the more expensive 4930 code because it is more specific. I'm looking for some awesome, smart tool that will automatically normalize all these code differences and output a clean ratesheet with only the cheapest rates. Does such a thing exist? I wonder how everyone else is normalizing their different rate sheets. With a homebrewn script? Thanks! Markus, you're not the first person and certainly not the last person who's ever asked about this. I had tried this on several mailing lists a little while ago. A tool that could handle 10 or maybe even 5 provider rate-sheets all of which can potentially completely differ in formats from each other. Even worse are the rate update sheets from each provider which are many a times different from the initial rate sheets that the provider may have given you and then again they will differ from the rate updates from the remaining 4 providers you've just painstakingly inserted into your DB. Given the popularity of Asterisk and other popular OSS based telephony platforms with several successful businesses running 100s of millions of minutes, you'd think at least a few have sorted this problem out. But I believe those who have, never respond to these emails as it took them quite a bit of effort to create such a tool and aren't willing to just give it away. Just what I have observed (and was even blatantly told by someone on some mailing list, can't remember exactly) You may have to advertise in the commercial / business list or offer a bounty. There are several commercial solutions available but I think they all come as a feature of a larger billing/rating/routing platform -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
We solve this problem for our customers all the time, in various situationally-specific ways. But yes, we are not really in a position to genericise it and give it away. It's not because we are greedy. The time and resources just aren't there. -- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Atlanta, GA 30030 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/, http://www.alexbalashov.com A E [Gmail] all.efor...@gmail.com wrote: On Mon, Mar 12, 2012 at 6:52 PM, Markus unive...@truemetal.org wrote: Hi, this question is not Asterisk specific, but since there are so many experts present on this list, maybe its OK to ask anyways. I'm having a hard time normalizing rate sheets from different providers. What I mean with this: the goal is to always get the cheapest rate for a given destination. What I would like to do is throw like 10 rate sheets from different providers together and as output get a single rate sheet with only the cheapest rates. However, some providers are listing a country, lets say Germany, as code 49 with a specific rate, and another provider will list each city individually, and each code separately, e.g. Berlin 4930, Hamburg 4940 etc., and probably different cities have different rates as well. Now, if the 49 route of the first provider is cheaper, my system (a2billing) will still use the more expensive 4930 code because it is more specific. I'm looking for some awesome, smart tool that will automatically normalize all these code differences and output a clean ratesheet with only the cheapest rates. Does such a thing exist? I wonder how everyone else is normalizing their different rate sheets. With a homebrewn script? Thanks! Markus, you're not the first person and certainly not the last person who's ever asked about this. I had tried this on several mailing lists a little while ago. A tool that could handle 10 or maybe even 5 provider rate-sheets all of which can potentially completely differ in formats from each other. Even worse are the rate update sheets from each provider which are many a times different from the initial rate sheets that the provider may have given you and then again they will differ from the rate updates from the remaining 4 providers you've just painstakingly inserted into your DB. Given the popularity of Asterisk and other popular OSS based telephony platforms with several successful businesses running 100s of millions of minutes, you'd think at least a few have sorted this problem out. But I believe those who have, never respond to these emails as it took them quite a bit of effort to create such a tool and aren't willing to just give it away. Just what I have observed (and was even blatantly told by someone on some mailing list, can't remember exactly) You may have to advertise in the commercial / business list or offer a bounty. There are several commercial solutions available but I think they all come as a feature of a larger billing/rating/routing platform -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
On 03/28/2012 03:15 PM, Raj Mathur (राज माथुर) wrote: Times change -- the way to deal with that is to adapt I don't think you'll get any serious disagreement on that from anyone here. -- Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Atlanta, GA 30030 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/, http://www.alexbalashov.com/ -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
Am 16.03.2012 04:14, schrieb Ast Coder: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. Ok, but how would this system handle FAS? Call shows as connected but it's still ringing to the caller. And probably won't get connected to the callee ever. I.e. cases where the route is just faulty in some way and it will ring forever but actually no one will ever get connected. How do you differentiate between nobody is home and route is faulty... -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
If we had reports of every call, we could downgrade status of routes that had frequency calls not completed that were outside the norm. --Don -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Markus Sent: Friday, March 16, 2012 9:47 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Rate sheet normalization Am 16.03.2012 04:14, schrieb Ast Coder: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. Ok, but how would this system handle FAS? Call shows as connected but it's still ringing to the caller. And probably won't get connected to the callee ever. I.e. cases where the route is just faulty in some way and it will ring forever but actually no one will ever get connected. How do you differentiate between nobody is home and route is faulty... -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
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 asteriskcod...@gmail.comwrote: 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 benny+use...@amorsen.dkwrote: Markus unive...@truemetal.org 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
Re: [asterisk-users] Rate sheet normalization
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 asteriskcod...@gmail.com mailto:asteriskcod...@gmail.com 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 benny+use...@amorsen.dk mailto:benny%2buse...@amorsen.dk wrote: Markus unive...@truemetal.org mailto:unive...@truemetal.org 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
Re: [asterisk-users] Rate sheet normalization
On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) Regards, -- Raj -- Raj Mathur || r...@kandalaya.org || GPG: http://otheronepercent.blogspot.com || http://kandalaya.org || CC68 It is the mind that moves || http://schizoid.in || D17F -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) Most definitely! I'll get in touch off-list. :) -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. On Thu, Mar 15, 2012 at 8:42 PM, Markus unive...@truemetal.org wrote: Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) Most definitely! I'll get in touch off-list. :) -- __**__**_ -- 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-**usershttp://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
Re: [asterisk-users] Rate sheet normalization
Our system just rolls over until it finds a carrier that will take it. Up to 30 different routes are supported, and rollover is pretty instantaneous in most cases. -- This message was painstakingly thumbed out on my mobile, so apologies for brevity and errors. Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Atlanta, GA 30030 Tel: +1-678-954-0670 Fax: +1-404-961-1892 Web: http://www.evaristesys.com/, http://www.alexbalashov.com On Mar 15, 2012, at 11:14 PM, Ast Coder asteriskcod...@gmail.com wrote: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. On Thu, Mar 15, 2012 at 8:42 PM, Markus unive...@truemetal.org wrote: Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) Most definitely! I'll get in touch off-list. :) -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. I think that it may not be humanly possible and also not possible to have a separate automated setup to ring destinations and prioritize according to Quality or Least-rates. BUT I am sure that real-time call success rate(or ASR) via multiple providers and sorting providers accordingly for particular destinations is possible or maybe available. Provided a good piece of code is written which analyses the call status / quality and then picks favourite carrier/provider for any destination. !! Not sure if anyone can understand it completely ;) I am thinking in terms of DynamicRouting or LCR modules from Kamailio or OpenSIPS. Regards, Sammy On Fri, Mar 16, 2012 at 8:14 AM, Ast Coder asteriskcod...@gmail.com wrote: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. On Thu, Mar 15, 2012 at 8:42 PM, Markus unive...@truemetal.org wrote: Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) Most definitely! I'll get in touch off-list. :) -- __**__**_ -- 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-**usershttp://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
Re: [asterisk-users] Rate sheet normalization
How about a central coop that manages the “normalized” rate sheet and distributes it with “unknown” call quality metrics for each route. Coop members report call quality for all calls/routes so the call quality metrics can be updated in the rate sheet and distributed to members. --Don Don Kelly PCF Corp People Come First 651 842-1000 651 842-1001 fax From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of SamyGo Sent: Thursday, March 15, 2012 11:45 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Rate sheet normalization So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. I think that it may not be humanly possible and also not possible to have a separate automated setup to ring destinations and prioritize according to Quality or Least-rates. BUT I am sure that real-time call success rate(or ASR) via multiple providers and sorting providers accordingly for particular destinations is possible or maybe available. Provided a good piece of code is written which analyses the call status / quality and then picks favourite carrier/provider for any destination. !! Not sure if anyone can understand it completely ;) I am thinking in terms of DynamicRouting or LCR modules from Kamailio or OpenSIPS. Regards, Sammy On Fri, Mar 16, 2012 at 8:14 AM, Ast Coder asteriskcod...@gmail.com wrote: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. On Thu, Mar 15, 2012 at 8:42 PM, Markus unive...@truemetal.org wrote: Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) Most definitely! I'll get in touch off-list. :) -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
Good Idea but that means all the members of the coop use the same vendors and it may not be suitable for servers having a bad network with a premium quality provider and thus mark it as bad, whereas others are marking it as Good. !! On Fri, Mar 16, 2012 at 10:00 AM, Don Kelly d...@donkelly.biz wrote: How about a central coop that manages the “normalized” rate sheet and distributes it with “unknown” call quality metrics for each route. Coop members report call quality for all calls/routes so the call quality metrics can be updated in the rate sheet and distributed to members. --Don Don Kelly PCF Corp People Come First 651 842-1000 651 842-1001 fax ** ** ** ** *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *SamyGo *Sent:* Thursday, March 15, 2012 11:45 PM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] Rate sheet normalization ** ** So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. ** ** I think that it may not be humanly possible and also not possible to have a separate automated setup to ring destinations and prioritize according to Quality or Least-rates. BUT I am sure that real-time call success rate(or ASR) via multiple providers and sorting providers accordingly for particular destinations is possible or maybe available. Provided a good piece of code is written which analyses the call status / quality and then picks favourite carrier/provider for any destination. !! Not sure if anyone can understand it completely ;) I am thinking in terms of DynamicRouting or LCR modules from Kamailio or OpenSIPS. ** ** Regards, Sammy ** ** On Fri, Mar 16, 2012 at 8:14 AM, Ast Coder asteriskcod...@gmail.com wrote: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. ** ** So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. ** ** ** ** On Thu, Mar 15, 2012 at 8:42 PM, Markus unive...@truemetal.org wrote:*** * Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): ** ** On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) ** ** Most definitely! I'll get in touch off-list. :) -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
So the best fit is to create a piece of code which mixes providers and destinations. 1- Sort those with at first rate and then as time passes by(utilization) it rearranges the carriers according to quality metrics or economical rates or success ratios. Like an AI system which enhances itself with passage of time. On Fri, Mar 16, 2012 at 10:06 AM, SamyGo govoi...@gmail.com wrote: Good Idea but that means all the members of the coop use the same vendors and it may not be suitable for servers having a bad network with a premium quality provider and thus mark it as bad, whereas others are marking it as Good. !! On Fri, Mar 16, 2012 at 10:00 AM, Don Kelly d...@donkelly.biz wrote: How about a central coop that manages the “normalized” rate sheet and distributes it with “unknown” call quality metrics for each route. Coop members report call quality for all calls/routes so the call quality metrics can be updated in the rate sheet and distributed to members. --Don Don Kelly PCF Corp People Come First 651 842-1000 651 842-1001 fax ** ** ** ** *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *SamyGo *Sent:* Thursday, March 15, 2012 11:45 PM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] Rate sheet normalization ** ** So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. ** ** I think that it may not be humanly possible and also not possible to have a separate automated setup to ring destinations and prioritize according to Quality or Least-rates. BUT I am sure that real-time call success rate(or ASR) via multiple providers and sorting providers accordingly for particular destinations is possible or maybe available. Provided a good piece of code is written which analyses the call status / quality and then picks favourite carrier/provider for any destination. !! Not sure if anyone can understand it completely ;) I am thinking in terms of DynamicRouting or LCR modules from Kamailio or OpenSIPS. ** ** Regards, Sammy ** ** On Fri, Mar 16, 2012 at 8:14 AM, Ast Coder asteriskcod...@gmail.com wrote: I would be more interested in a system where quality routes are tested with different providers because rate really doesn't matter if a call can't be placed or if a destination is a fake one. We have seen many fake destinations with top tier providers but they had the best rates so the strategy to pick them first really didn't work. ** ** So, maybe a subscription service where a dialler system continuously tests routes with a list of 10 providers so that it's established which routes actually work and then allow that data to be downloaded for usage. ** ** ** ** On Thu, Mar 15, 2012 at 8:42 PM, Markus unive...@truemetal.org wrote:** ** Am 15.03.2012 17:20, schrieb Raj Mathur (राज माथुर): ** ** On Thursday 15 Mar 2012, Markus wrote: 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... Is it possible to get samples? I'd be interested in looking into developing a script that can handle this problem generically, and presumably you're available to alpha- and beta-test in any case :) ** ** Most definitely! I'll get in touch off-list. :) -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
Markus unive...@truemetal.org 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
Re: [asterisk-users] Rate sheet normalization
Am 15.03.2012 00:35, schrieb Benny Amorsen: Markusunive...@truemetal.org 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. a2billing chooses the cheapest rate if there is more than 1 rate for a prefix that matches exactly. I'm not a programmer so I can't tell you how they do it internally. The call is simply passed to a2billing.php via DeadAGI. I know that the a2billing guys are currently working on fixing exactly the mentioned issue, but it's unknown when that will be done. I was just hoping there was some software out there that I can throw 10 different ratesheets at with different length of codes and it will output a single true LCR ratesheet cut down to the official worldwide codes. Thanks! -- _ -- 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
Re: [asterisk-users] Rate sheet normalization
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 benny+use...@amorsen.dkwrote: Markus unive...@truemetal.org 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
