[Asterisk-Users] 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 ___ 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
Re: [Asterisk-Users] Billing Fun - anybody know where to get a NPA/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 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 ___ 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
Re: [Asterisk-Users] Billing Fun - anybody know where to get a NPA/NXX db?
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? ___ 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
Re: [Asterisk-Users] Billing Fun - anybody know where to get a NPA/NXX db?
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