Re: [Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db?

2004-09-24 Thread Patrick
On Fri, 2004-09-24 at 04:32, Scott Lykens wrote: [snip] Then I have a perl script that reads each file in and puts them into a MySQL table. [snap] Would you mind sharing the perl script and the database schema? TIA, Patrick ___ Asterisk-Users

Re: [Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db?

2004-09-24 Thread Scott Lykens
On Fri, 24 Sep 2004 15:02:53 +0200, Patrick [EMAIL PROTECTED] wrote: Would you mind sharing the perl script and the database schema? Perl script and database layout are below. Its not pretty since I never intended it for external consumption but it does get the job done. If you unzip the files

Re: [Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db?

2004-09-24 Thread Patrick
On Fri, 2004-09-24 at 17:03, Scott Lykens wrote: [snip] Perl script and database layout are below. [snap] Thanks! Regards, Patrick ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To

RE: [Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db?

2004-09-23 Thread Brian Rozmierski
, September 23, 2004 5:51 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db? There used to be an NPA NXX sql on 1 of the asterisk site's. http://www.fnords.org/~eric/asterisk/ I doubt you will find a nice

Re: [Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db?

2004-09-23 Thread Scott Lykens
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