[Asterisk-biz] global numbering plans
Bill Michaelson
bill at cosi.com
Fri Nov 25 18:39:14 MST 2005
That's very nice. Thanks for providing this.
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...
create table intlphone (dialpat varchar(60), country varchar(60),
zonetype varchar(60), description varchar(60));
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.
trixter aka Bret McDanel wrote:
>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.
>
>http://www.0xdecafbad.com/uploads/bigcountry.csv.gz
>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 :)
>
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Asterisk-Biz mailing list
>Asterisk-Biz at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-biz
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-biz/attachments/20051125/f3d7e3b6/attachment.htm
More information about the asterisk-biz
mailing list