[Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXXdb?

Richard Cook richard at aspworld.com
Thu Sep 23 22:34:49 MST 2004


Hello,

Do you mind posting the database schema?
 
--
Richard Cook
richard at aspworld.com
Tel: 705-497-9320 - ext 2010
 
 

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Scott Lykens
Sent: Thursday, September 23, 2004 10:32 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Billing Fun - anybody know where to get
aNPA/NXXdb?

The NANPA maintains this database and the full database is available in 8
files. I have imported this into a MySQL table and can query based on rate
center and npa-nxx.

I use wget -a using a file containing the following:

http://www.nanpa.com/nanp1/cnutlzd.zip
http://www.nanpa.com/nanp1/csutlzd.zip
http://www.nanpa.com/nanp1/eautlzd.zip
http://www.nanpa.com/nanp1/enutlzd.zip
http://www.nanpa.com/nanp1/esutlzd.zip
http://www.nanpa.com/nanp1/wnutlzd.zip
http://www.nanpa.com/nanp1/wputlzd.zip
http://www.nanpa.com/nanp1/wsutlzd.zip

Then I have a perl script that reads each file in and puts them into a MySQL
table.

I hope this helps with that you are looking for.

sl
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users





More information about the asterisk-users mailing list