[Asterisk-biz] global numbering plans

[trixter aka Bret McDanel]

On Fri, 2005-11-25 at 20:39 -0500, Bill Michaelson wrote:
> 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.
> 

no its if I have the data I keep it in their format (they used
semicolons) the only thing I added to their description string was the
country.  You can be assured that its 
number,country; other stuff may have semicolons or be empty

also note that its a semicolon then a space.  Dunno if that matters to
you.

technically its a 2 column csv I could make it 3 easily enough by not
adding the semicolon after the country and instead using a comma, if
that is prefered ...  it wouldnt even be that hard to write a script to
parse that out.  could even do it in bourne shell with cut and echo :)



-- 
Trixter http://www.0xdecafbad.com     Bret McDanel
UK +44 870 340 4605   Germany +49 801 777 555 3402
US +1 360 207 0479 or +1 516 687 5200
FreeWorldDialup: 635378
http://www.sacaug.org/ Sacramento Asterisk Users Group
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.digium.com/pipermail/asterisk-biz/attachments/20051125/a02c1975/attachment.pgp