asterisk users - Sep 2004 - Billing Fun - anybody know where to get a NPA/NXX db?

Hello;

I've been playing with a nifty Open Source java based report writer
called Datavision (datavision.sourceforge.net) and I've managed to write
enough logic to calculate phone bills at different rates from the MySQL
cdr's. (cdr_addon_mysql)  Eventually I want to have sets of rate
structures for each user of the system - so I can bill client A at 3
cents a minute and client B at 2 cents, etc... 

Anyway, my question is: where can I get a copy of the NPA/NXX db without
paying an arm and a leg for it?  The NPA's are a free zipped up .mdb
(gag) file on this page: http://www.nanpa.com/area_codes/index.html 

I also came across a 1999 version of the whole shebang in a text file
here: http://sd.wareonearth.com/~phil/npanxx/

It would be nice to be able to accurately lookup city and state for 
billing.  Anybody have a resource?

Thanks,

Thomas Hutton

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 complete 1 for free unless you parse the
npana data yourself which you could do. I did it recently not exactly
fun. Still might not be 100% though.

-- William

iH

you can find NPA-NXXs listed here by region

http://nanpa.com/reports/reports_cocodes_assign.html

- hcir

On Sep 23, 2004, at 5:15 PM, Thomas Hutton wrote:
> Hello;
>
> I've been playing with a nifty Open Source java based report writer
> called Datavision (datavision.sourceforge.net) and I've managed to 
> write
> enough logic to calculate phone bills at different rates from the MySQL
> cdr's. (cdr_addon_mysql)  Eventually I want to have sets of rate
> structures for each user of the system - so I can bill client A at 3
> cents a minute and client B at 2 cents, etc...
>
> Anyway, my question is: where can I get a copy of the NPA/NXX db 
> without
> paying an arm and a leg for it?  The NPA's are a free zipped up .mdb
> (gag) file on this page: http://www.nanpa.com/area_codes/index.html
>
> I also came across a 1999 version of the whole shebang in a text file
> here: http://sd.wareonearth.com/~phil/npanxx/
>
> It would be nice to be able to accurately lookup city and state for
> billing.  Anybody have a resource?

Do you plan on sharing the code when you are done? :-) 

Darren Wiebe
darren@hagenhomes.com

Thomas Hutton wrote:
>Hello;
>
>I've been playing with a nifty Open Source java based report writer
>called Datavision (datavision.sourceforge.net) and I've managed to write
>enough logic to calculate phone bills at different rates from the MySQL
>cdr's. (cdr_addon_mysql)  Eventually I want to have sets of rate
>structures for each user of the system - so I can bill client A at 3
>cents a minute and client B at 2 cents, etc... 
>
>Anyway, my question is: where can I get a copy of the NPA/NXX db without
>paying an arm and a leg for it?  The NPA's are a free zipped up .mdb
>(gag) file on this page: http://www.nanpa.com/area_codes/index.html 
>
>I also came across a 1999 version of the whole shebang in a text file
>here: http://sd.wareonearth.com/~phil/npanxx/
>
>It would be nice to be able to accurately lookup city and state for 
>billing.  Anybody have a resource?
>
>Thanks,
>
>Thomas Hutton
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users@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
>
>
>  
>

Hello,

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

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@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@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

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