The only database that I am aware of that contains NPA/NXX data, Switch data, and Billing Center/Rate Code data is the LERG. It is a subscription based CDROM from Telecordia.
tim -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darren Wiebe Sent: Thursday, September 23, 2004 10:03 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Billing Fun - anybody know where to get a NPA/NXXdb? Do you plan on sharing the code when you are done? :-) Darren Wiebe [EMAIL PROTECTED] 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 >[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 _______________________________________________ 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