<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Adding to the top-posted discussion of doing this for free…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>A one-time rate sheet is of no value. This is something that would need constant updating.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Think about the open source projects that provided something useful and were improved by the community for a couple years, then became static—continuing to do what they did, but not receiving any more support from the community. They may continue to be of value, even though they don’t improve.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>If the same thing happened with the rate sheet, it would quickly become not only valueless, but dangerous to rely on—and there would likely be no free replacement to enable you to stay in business.<o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>--Don</span><span lang=EN style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Don Kelly</span><span lang=EN style='color:#1F497D'><o:p></o:p></span></p></div><p class=MsoNormal><span lang=EN style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>PCF Corp<br>People Come First<br>651 842-1000<br>651 842-1001 fax</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] <b>On Behalf Of </b>C. Savinovich<br><b>Sent:</b> Wednesday, March 28, 2012 10:58 AM<br><b>To:</b> Asterisk Users Mailing List - Non-Commercial Discussion<br><b>Subject:</b> Re: [asterisk-users] Rate sheet "normalization"<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Sure someone will benefit from it. But what about all those others who are financially affected by it? I certainly do not think that someone necessarily always contributes. It ultimately affects our economy, because money doesn't circulate, and many people who are in a perfect position to disburse money just don't do it. It affects an entire industry (the software industry) that could flourish and create even better products thanks to a competition that could exists if there were financial rewards. Ultimately, free software (not open source) affects the little guy and benefits the big guys. Gone are the days when a talented programmer could create a program and make a million dollars from his basement with his talent. If your company name is not Google, if you don't do a tap and a dance to an investor, then you got no chance, as opposed to the days when you could just sell your own version of Vicidial and make money for a year.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>But rather than discussing about the pros and cons of open source, which is here to stay, I would think that some people are doomed to fail if they think they can run a business entirely on free rides. The goal of Open Source is to benefit from sharing and share ahead, but unfortunately a segment of the market has gotten to the point that it only takes but doesn't give back.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Christian Savinovich<o:p></o:p></span></p></div><div><p class=MsoNormal><em><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>VoIP & Telephony Consultant</span></b></em><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>646-982-3572<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 6.0pt;margin-left:6.0pt;margin-top:5.0pt;margin-bottom:5.0pt' id=replyBlockquote><div id=wmQuoteWrapper><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>-------- Original Message --------<br>Subject: Re: [asterisk-users] Rate sheet "normalization"<br>From: Leandro Dardini <<a href="mailto:ldardini@gmail.com">ldardini@gmail.com</a>><br>Date: Wed, March 28, 2012 10:38 am<br>To: Asterisk Users Mailing List - Non-Commercial Discussion<br><<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</a>><br><br>Continuing with the top post...<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>I believe in open source philosophy. A software or a list of telephone prefix makes no difference. If you want to make such list open source, you'll be sure somebody will contribute to maintain it update and all will benefit from it.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Leandro<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>2012/3/28 C. Savinovich <<a href="mailto:c.savinovich@itntelecom.com" target="_blank">c.savinovich@itntelecom.com</a>><o:p></o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>I really don't think it is fair for anyone to give out such work for free. Unfortunately, many people are used to asking for free software solutions for all their problems. Whatever happened to paying for someone else's time and effort?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Christian Savinovich<o:p></o:p></span></p></div><div><p class=MsoNormal><em><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>VoIP & Telephony Consultant</span></b></em><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'> <o:p></o:p></span></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 6.0pt;margin-left:6.0pt;margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>-------- Original Message --------<br>Subject: Re: [asterisk-users] Rate sheet "normalization"<br>From: Alex Balashov <<a href="mailto:abalashov@evaristesys.com" target="_blank">abalashov@evaristesys.com</a>><br>Date: Wed, March 28, 2012 10:00 am<br>To: Asterisk Users Mailing List - Non-Commercial Discussion <br><<a href="mailto:asterisk-users@lists.digium.com" target="_blank">asterisk-users@lists.digium.com</a>><br><br>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.<br><br>--<br>Alex Balashov - Principal <br>Evariste Systems LLC <br>235 E Ponce de Leon Ave <br>Suite 106<br>Atlanta, GA 30030 <br>Tel: <a href="tel:%2B1-678-954-0670" target="_blank">+1-678-954-0670</a> <br>Fax: <a href="tel:%2B1-404-961-1892" target="_blank">+1-404-961-1892</a> <br>Web: <a href="http://www.evaristesys.com" target="_blank">http://www.evaristesys.com</a>/, <a href="http://www.alexbalashov.com" target="_blank">http://www.alexbalashov.com</a><br><br>"A E [Gmail]" <<a href="mailto:all.eforums@gmail.com" target="_blank">all.eforums@gmail.com</a>> wrote:<o:p></o:p></span></p><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>On Mon, Mar 12, 2012 at 6:52 PM, Markus <<a href="mailto:universe@truemetal.org" target="_blank">universe@truemetal.org</a>> wrote:<o:p></o:p></span></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Hi,<br><br>this question is not Asterisk specific, but since there are so many experts present on this list, maybe its OK to ask anyways.<br><br>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.<br><br>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.<br><br>Does such a thing exist? I wonder how everyone else is "normalizing" their different rate sheets. With a homebrewn script?<br><br>Thanks!<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Markus,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Just what I have observed (and was even blatantly told by someone on some mailing list, can't remember exactly)<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>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<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div></div></div><div class=MsoNormal align=center style='text-align:center'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal><span class=hoenzb><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#888888'>--</span></span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#888888'><br><span class=hoenzb>_____________________________________________________________________</span><br><span class=hoenzb>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --</span><br><span class=hoenzb>New to Asterisk? Join us for a live introductory webinar every Thurs:</span><br><span class=hoenzb><a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a></span><br><br><span class=hoenzb>asterisk-users mailing list</span><br><span class=hoenzb>To UNSUBSCRIBE or update options visit:</span><br><span class=hoenzb><a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a> </span></span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p></o:p></span></p></div></blockquote></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><br>--<br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>New to Asterisk? Join us for a live introductory webinar every Thurs:<br> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><o:p> </o:p></span></p></div><div class=MsoNormal align=center style='text-align:center'><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>--<br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com">http://www.api-digital.com</a> --<br>New to Asterisk? Join us for a live introductory webinar every Thurs:<br><a href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br><a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a> <o:p></o:p></span></p></div></blockquote></div></body></html>