similar to: How to get long distance carrier to provide separate billing for several companies that share a PRI to LEC?

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

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

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

4 CENTS A MINUTE LONG DISTANCE ANYTIME State to State and Intrastate 24 Hours a day 7 Days a week NO SWITCHING LONG DISTANCE COMPANIES NO MONTHLY FEE 10 minute minimum per call 4 CENTS A MINUTE ANY TIME JUST DIAL 10-15-335 1+(AREA CODE)+NUMBER At the prompt , enter this activation code 218995 (on first call only) to get this incredible rate 4 CENTS A MINUTE ANY TIME Only 40 Cents for all

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

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?

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

> > 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

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:

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

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

Hi All. Can anyone tell me how difficult it would be to change the way asterisk stores/retrieves user messages as follows? Currently mailboxes are in /var/spool/asterisk/voicemail/{context} But I need to store messages in a hash to limit the number of directories per context. All mailbox extensions are the user's 10-digit phone number (aka, DID). The parts of a DID are as follows 407

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

Has anyone had good results with an on-line database that returns a LATA based on NPA NXX? --Don Don Kelly PCF Corp People Come First 651 842-1000 888 Don Kell(y) 651 842-1001 fax -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100518/d77d09b3/attachment.htm

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:

Hi, Does anyone know anything about the following? In a hosted environment where several area DIDs are provisioned on a single server, how do most carriers establish the origination DID, number. Asterisk allows us to modify the CallerID, name, number and DNID channel variables before dialling out via SIP. Most carriers will allow us to spoof a callerID when placing a call, and pass it forward.

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 --------------

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.

Hi all, I am trying to setup a ZAP interface to do MF signaling for a handoff to a 911 tandem. The signaling I need to perform on the T1 is this: 9-1-1 Tandem: Wink CLEC end office: KP (Keypulse) NPA ST (Start) 9-1-1 Tandem: Wink CLEC end office: KP I (Info Digit) NXX XXXX ST As I'm not as familiar with the Zaptel configurabliity, I'm not really sure how to do this. Do I dial twice