<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Calibri">Its kind of tricky because it depends on the
granularity with which you want to manage your rates (i.e. how
long and complicated your prefixes/regexs are), and this in turn
depends a bit on how you get billed by your carriers.<br>
<br>
For instance, our csv files which we generate from a separate db,
and then upload as csv to sipwise are generally more than 30,000
lines ... simply because we are charged, and therefore charge on,
at very granular destinations.<br>
<br>
However, if you have a very simple set of (cost and price)
tarrifs, you might only charge one rate per country (which is
about 200 countries)... this seems unlikely as most carriers will
at the very least have national and mobile rates per country.<br>
If that is all you need, you can find a standard set of ISO
country and dial codes here <a class="moz-txt-link-freetext" href="https://countrycode.org/">https://countrycode.org/</a><br>
<br>
<br>
Cheers<br>
Gavin<br>
<br>
<br>
</font>
<div class="moz-cite-prefix">On 02/09/2015 11:51, Alessandro
Bolletta wrote:<br>
</div>
<blockquote
cite="mid:F52F175DFC537F48A43937B50B44BCA282059EBF@EXCHANGE.mediaspot.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.imprintuniqueid, li.imprintuniqueid, div.imprintuniqueid
{mso-style-name:imprintuniqueid;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
span.stilemessaggiodipostaelettronica17
{mso-style-name:stilemessaggiodipostaelettronica17;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.StileMessaggioDiPostaElettronica23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 2.0cm 2.0cm;}
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]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="color:#1F497D;mso-fareast-language:EN-US">Hi Greg,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:#1F497D;mso-fareast-language:EN-US">yep, I
know, but i’m creating manually a csv with outbound fee
rules when I could copy (only) rules instead, starting by an
already working csv file.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Da:</b> Greg Lipschitz
[<a class="moz-txt-link-freetext" href="mailto:Greg@thesummitgroup.com.au">mailto:Greg@thesummitgroup.com.au</a>]
<br>
<b>Inviato:</b> mercoledì 2 settembre 2015 12.50<br>
<b>A:</b> Alessandro Bolletta
<a class="moz-txt-link-rfc2396E" href="mailto:alessandro@mediaspot.net"><alessandro@mediaspot.net></a>;
<a class="moz-txt-link-abbreviated" href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Oggetto:</b> RE: csv fee destinations<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">Hi
Alessandro,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">Your
rating is going to be dependent on your carrier buy and
your rrp sell pricing.
<o:p></o:p></span></p>
</div>
<p class="imprintuniqueid"> <o:p></o:p></p>
<p class="imprintuniqueid"><b><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Greg Lipschitz |
Director | The Summit Group</span><o:p></o:p></b></p>
<p class="imprintuniqueid"><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif">E:
<a moz-do-not-send="true"
href="mailto:Greg@thesummitgroup.com.au" title="Click to
send email to Greg Lipschitz">
Greg@thesummitgroup.com.au</a> | W: <a
moz-do-not-send="true"
href="http://www.thesummitgroup.com.au" title="">
<a class="moz-txt-link-abbreviated" href="http://www.thesummitgroup.com.au">www.thesummitgroup.com.au</a></a></span><o:p></o:p></p>
<p class="imprintuniqueid"><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif">The
Summit Group (Australia) Pty Ltd | P: 1300 049 749 | Level
1, 39 Railway Road, Blackburn VIC 3130<br>
The Summit Group (USA) LLC | P: 321 216 3844 | Suite 1003,
364E Main Street, Middletown DE 19709<br>
Postal: P.O. Box 3225, Doncaster East VIC 3109</span><o:p></o:p></p>
<p class="imprintuniqueid"> <o:p></o:p></p>
<p class="imprintuniqueid"><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif">Follow
us on
</span><a moz-do-not-send="true"
href="http://www.facebook.com/thesummitgroup/"><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif">Facebook</span></a><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif"> |
</span><a moz-do-not-send="true"
href="http://www.linkedin.com/company/1942329"><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif">LinkedIn</span></a><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif"> |
</span><a moz-do-not-send="true"
href="http://twitter.com/summitgroupau/"><span
style="font-size:10.0pt;font-family:"Calibri",sans-serif">Twitter</span></a><o:p></o:p></p>
<div>
<div>
<div>
<div class="MsoNormal" style="text-align:center"
align="center"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif;color:black">
<hr align="center" size="2" width="100%">
</span></div>
<div id="divRpF739804">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">From:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">
Spce-user [<a class="moz-txt-link-abbreviated" href="mailto:spce-user-bounces@lists.sipwise.com">spce-user-bounces@lists.sipwise.com</a>] on
behalf of Alessandro Bolletta
[<a class="moz-txt-link-abbreviated" href="mailto:alessandro@mediaspot.net">alessandro@mediaspot.net</a>]<br>
<b>Sent:</b> Wednesday, 2 September 2015 8:15 PM<br>
<b>To:</b> <a moz-do-not-send="true"
href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Subject:</b> [Spce-user] csv fee destinations</span><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="color:black">Hi
everybody,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">is
there anyone who can provide me a CSV file with
rating rules for all countries ready to be
imported?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">--<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Alessandro
Bolletta<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Mediaspot
Srl<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>