The local telco is now going 10 digit dialing even for local (free) calls which used to be 7 digit. For a while no problem, everyone will continue to dial 7 digits, and I'll add the area code. But pretty soon everyone will become used to 10 digits. There are about 40 3 digit local exchanges. I'd like to store the exchanges in a database, and use the dialplan to check them. I can figure that out. I've looked at the Berkeley DB. That works pretty well, if the exchanges are all stored. But it looks like the exchanges have to be entered 1 by 1 from the CLI. And can only be reviewed, corrected, or deleted from the CLI. I haven't found any simple frontend for the DB. I'd also consider sqlite3, but from the sqlite3 .conf.sample, it's only for CDR. In any event, I couldn't find a simple frontend. I'd prefer not to go into mysql etc for such a simple project. sean
Barry L. Kline
2009-May-25 21:50 UTC
[asterisk-users] howto store local exchange prefixes ?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 sean darcy wrote:> I've looked at the Berkeley DB. That works pretty well, if the exchanges > are all stored. But it looks like the exchanges have to be entered 1 by > 1 from the CLI. And can only be reviewed, corrected, or deleted from the > CLI. I haven't found any simple frontend for the DB.I do this be writing a dialplan which adds those entries. The first entry checks to see if the DB has been initialized and if so, skips to the lookup. Otherwise it loads each into the database before the lookup. It's very easy to write a quick script to generate the dialplan code. Barry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFKGxKvCFu3bIiwtTARAuZLAJ4uZw/76Pefz9y1fdQRCS03qFGmOACfeR98 fD8binGxr+c9mMriW6GXjC0=ETQ2 -----END PGP SIGNATURE-----
sean darcy wrote:> The local telco is now going 10 digit dialing even for local (free) > calls which used to be 7 digit. For a while no problem, everyone will > continue to dial 7 digits, and I'll add the area code. But pretty soon > everyone will become used to 10 digits. > >Lucky you. Other states require 11 digits for all calls, regardless, and yet others require 10 digit for local and 11 digit for toll, they way the NANP was SUPPOSED to evolve, until the inmates took over the asylum and each state ( in the US ) PUC sets the numbering plan and splits vs overlays. John Novack> There are about 40 3 digit local exchanges. I'd like to store the > exchanges in a database, and use the dialplan to check them. I can > figure that out. > > I've looked at the Berkeley DB. That works pretty well, if the exchanges > are all stored. But it looks like the exchanges have to be entered 1 by > 1 from the CLI. And can only be reviewed, corrected, or deleted from the > CLI. I haven't found any simple frontend for the DB. > > I'd also consider sqlite3, but from the sqlite3 .conf.sample, it's only > for CDR. In any event, I couldn't find a simple frontend. I'd prefer not > to go into mysql etc for such a simple project. > > sean > > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > >-- Dog is my co-pilot
Jimmy Godbout
2009-May-26 02:01 UTC
[asterisk-users] howto store local exchange prefixes ?
Check on www.localcallingguide.com. You'll find all npanxx that are local to your exchange. Jimmy> -----Original Message----- > From: seandarcy2 at gmail.com > Sent: Mon, 25 May 2009 21:39:30 -0400 > To: asterisk-users at lists.digium.com > Subject: Re: [asterisk-users] howto store local exchange prefixes ? > > Barry L. Kline wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> sean darcy wrote: >> >>> I've looked at the Berkeley DB. That works pretty well, if the >>> exchanges >>> are all stored. But it looks like the exchanges have to be entered 1 by >>> 1 from the CLI. And can only be reviewed, corrected, or deleted from >>> the >>> CLI. I haven't found any simple frontend for the DB. >> >> I do this be writing a dialplan which adds those entries. The first >> entry checks to see if the DB has been initialized and if so, skips to >> the lookup. Otherwise it loads each into the database before the >> lookup. It's very easy to write a quick script to generate the dialplan >> code. >> >> Barry > > Maybe I've not explained this correctly. I know, or can look up, the 40+ > local exchanges that are local. I can parse the dial EXTEN to determine > the exchange. I can check the exchange against a DB. I want to determine > which exchanges are "local". I do not want to store an exchange dialed > by a user. > > How can I store a lot of 3 digit numbers which I then can check against > an EXTEN to determine a local number? > > sean > > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users____________________________________________________________ Receive Notifications of Incoming Messages Easily monitor multiple email accounts & access them with a click. Visit http://www.inbox.com/notifier and check it out!
Danny Nicholas
2009-May-26 13:57 UTC
[asterisk-users] howto store local exchange prefixes ?
Now that I've slogged through everyone else's reply and got to the original post, here's an idea. You seem to have the dialplan part worked out; why not do a simple HTML interface to do the Berkley maint using asterisk -rx to do the CLI reads/pokes? With asterisk -rx you can automate 90+ percent of CLI functions. -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of sean darcy Sent: Monday, May 25, 2009 4:29 PM To: asterisk-users at lists.digium.com Subject: [asterisk-users] howto store local exchange prefixes ? The local telco is now going 10 digit dialing even for local (free) calls which used to be 7 digit. For a while no problem, everyone will continue to dial 7 digits, and I'll add the area code. But pretty soon everyone will become used to 10 digits. There are about 40 3 digit local exchanges. I'd like to store the exchanges in a database, and use the dialplan to check them. I can figure that out. I've looked at the Berkeley DB. That works pretty well, if the exchanges are all stored. But it looks like the exchanges have to be entered 1 by 1 from the CLI. And can only be reviewed, corrected, or deleted from the CLI. I haven't found any simple frontend for the DB. I'd also consider sqlite3, but from the sqlite3 .conf.sample, it's only for CDR. In any event, I couldn't find a simple frontend. I'd prefer not to go into mysql etc for such a simple project. sean _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users