Hello, Do you mind posting the database schema? -- Richard Cook [EMAIL PROTECTED] Tel: 705-497-9320 - ext 2010
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
