<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
That's very nice. Thanks for providing this.<br>
<br>
I looked at it briefly, and tried loading it into mysql. I infer that
there are supposed to be four columns, which I described with this...<br>
<br>
create table intlphone (dialpat varchar(60), country varchar(60),
zonetype varchar(60), description varchar(60));<br>
<br>
The phone is followed by a comma, the country and zonetype by
semicolons. I noticed that the the second semicolon is not
consistently present, so my importation process glues many of the
description fields onto zonetype. This isn't deliberate, is it? It
looks like it might be, but I don't think so.<br>
<br>
<br>
trixter aka Bret McDanel wrote:<br>
<blockquote type="cite"
cite="mid1132961756.3918.41.camel@rufus.home.tld">
<pre wrap="">I have compiled the last of the info that I had and I now have a 43MB
CSV file (3.5MB compressed) containing about 579,887 entries. The
information includes each country, whether its geographic (and where),
mobile, premium, etc. Even have short codes (like 911/999 for emergency
etc) for each country where available.
I didnt do a dialplan format yet, and am not sure that I will, the
original list was 5500 and that wasnt that bad to edit out the parts you
wanted, but this is different, people would spend more time editing I
think. If anyone wants it and cant figure out how to write a script to
parse the CSV lemme know and I will do something.
I make no warantees about the accuracy of this data, it most likely does
have errors, use at your own risk. If you do spot an error, omission or
other issue with the file let me know and I will see about fixing it.
<a class="moz-txt-link-freetext" href="http://www.0xdecafbad.com/uploads/bigcountry.csv.gz">http://www.0xdecafbad.com/uploads/bigcountry.csv.gz</a>
Note: winzip can deal with .gz files
This list also should correct some problems people had with incorrectly
matching entries by using wildcards, it pads with X's to ensure proper
number length. I also removed the generic country code entries as those
would match anything in the country and largely are not good for
anything - if you dont know about a specific call's cost you prolly dont
want to route it :)
</pre>
<pre wrap="">
<hr width="90%" size="4">
_______________________________________________
Asterisk-Biz mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Asterisk-Biz@lists.digium.com">Asterisk-Biz@lists.digium.com</a>
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-biz">http://lists.digium.com/mailman/listinfo/asterisk-biz</a>
</pre>
</blockquote>
</body>
</html>