similar to: NPA NXX Database

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

Does anyone have the NPA NXX list for North America in comma delimited file? Only looking for: NPA, NXX, City, State Just seems it should be available free somewhere? Then comes the next step, the setting callerid name based on the NPANXX to city, state -Mark -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date:

HI all - I know, slightly off list, but.. I'm looking for a NPA NXX database with City and State. Actually it's for an Asterisk routing app I'm working on. I see several vendors that want a few bucks to those that want an arm and leg. I expect this is published somewhere by some government agency, but Google hasn't got me to it yet. Jon -------------- next part --------------

Hi Folks, Is there a way to find out the mobile/landline carrier name based on the phone number? For example, who is the mobile carrier for (415)2345678 I had heard about some query but just don't remember how/what? Thanks in advance. Ritesh -------------- next part -------------- An HTML attachment was scrubbed... URL:

I'm presently working on an office move and evaluation of telecommunications services needed at the new location. I'm presently wrastling with an issue related to portability and geography between landline carriers. Presently certain people within the organization are hopelessly in love with our 909-822-xxxx number(provided by pacbell/att). As that number is presently provisioned it

> > On a related note, I wanted our phones to display "city, st" for the > > caller-ID name in the event that none was provided. > > Interesting code. What sort of memory does * take up when you load up > all those CLID values? > > Nathan > I am a little late to this thread, but the answer is WAY TO MUCH. With 150,000 "pattern" match

I noticed while reading some posts that people were looking for a complete NPA-NXX list for all area codes and prefixes. We happen to have the entire database. So I am making it available to the public. Help is available at: http://download.sixtel.net/npa/help.txt (Caution, 20meg files) Mysql Insert for this is available at: http://download.sixtel.net/npa/npainsert.txt CSV data for

Hi, What dialplan option do I need to send a call out like this: NPA-NXX-xxxx local calls 1-NPA-NXX-xxxx - long distance Won't 'national' send it out NPA-NXX-xxxx no matter if it's long distance or not?

Hi, Do the callers in USA dialling from USA Telco lines always have to prefix the CITY/AREA code with "1" in order To successfully make a call to other USA destinations? ---- I have not been to USA (yet) :) Ta SJ

I edited the calleridname.agi patch to only overwrite the name if it is missing. The asteridex option still overwrites the name since it is our master list for known numbers. -- Steven calleridname.agi.patch: --- C:\Documents and Settings\steveb\Desktop\calleridname.agi-orig Tue Jun 13 14:37:09 2006 +++ C:\Documents and Settings\steveb\Desktop\calleridname.agi Tue Jun 13 14:37:09 2006 @@ -16,6

I've seen caller-id come through from carriers as: NPA-NXX-xxxx, 1-NPA-NXX-xxxx, and +1-NPA-NXX-xxxx My question is: what is the correct way to send Caller-ID by set standards? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100809/1866d18a/attachment.htm

Does anyone know enough about the implementation of AstDB to know whether the data structure is a Hash function, a Balanced-Tree, a b-Tree, or a Linked List? I'm trying to estimate the lookup 'cost' of a AstDB with around 160,000 keys? Obviously I already know that it WILL WORK, but the question is whether the data structure is optimal in the Berkeley DB AS IMPLEMENTED in Asterisk.

I am using realtime mysql for extensions, sip, and voicemail. Outbound call routing does not really perform well in realtime extensions due to the high number of rows in the database (300k), so I can not use it. It appears with my limited knowledge that the query method is not robust enough for large databases. Given the fact that I already have realtime and mysql configured, what are my options

Hi all, My VoIP provider (race.com) doesn't send name info with CallerID, so I wrote an AGI script that does the following: 1) If it's a toll free number (800|888|877|866), set the CallerID name to "TollFree Caller" 2) Use curl to look up the number in Google phonebook 3) If a business listing, set the CallerID name to business name, as is. 4) If it's a residential

Hello: Does anyone know of a list of milliwatt test numbers for debugging echo? Specifically I am looking for a milliwatt test number in Canada, preferrably in a 416 or 905 NPA exchange....different carriers would also be nice....ie. Bell Canada, GT, Sprint (Now Rogers Telecom) I called Rogers NOC and asked them for the milliwatt test number....they didn't even know what it was....so I

Cross posted from asterisk-biz: > > Is anyone willing to host/manage a website that people > > can simply browse that lists all current DID providers > > and their coverage areas? > It's a good idea and probably not too hard to implement, > it's just a case of deciding how far you want to go.. are > areacodes good enough? or do you need to go to NPA-NXX >

We're beginning to test MultiTech's CallFinder CDMA Units, one for Sprint PCS and one for Alltel. They sell both. Our intent is to use them as a backup line for our main office (which has a PRI) and a backup/911 line for our remote offices which are all connected via * over a VPN with no local trunks at any of them. In the interest of maximizing use of the lines, I'm putting

Is there an easy way to get information about local calling areas out of telcos? I'm trying to get a list of area codes and prefixes in my local calling area out of Verizon, and it looks like they've stopped providing the information online. Is there an easy source that I'm missing, or do I need to call them and have them mail me a copy every few months? Scott

I have been trying to make Broadvoice match incoming Caller ID and do specific things based on the number received, but due to Broadvoice requiring the "s" to start off an incoming extension, I cannot get this to work. Has anyone been able to do this? Here are some examples of my setup: from sip.conf: context=broadvoice-incoming from extensions.conf [broadvoice-incoming] exten =>

Hi, When I setup a user, I give them an extension like 570xxxxxxx. This is fine and dandy while in one area code, but we've since gone to other area codes. I'd like the user's to retain the ability to dial 7 digits no matter what number they have. Any thoughts on how to do that? EXAMPLE: User has number 7175551212. I want that when they dial 3235555 it dials 717-323-5555.