asterisk users - Aug 2008 - Need application, CID number match list to call cell phone

Hi All,

I received a request for a special application and need some guidance.
 Cust has there own Asterisk PBX with SIP phones, pretty standard
setup.

They want an after hours application that checks inbound caller ID
numbers and matches them to a list, say 5 to 10 numbers of special VIP
customers, if there is a match on the list, then forward the call
straight to a cell phone, instead of ringing local extension and then
to voicemail.

The customer also wants to be able to manage this VIP list and the
call forward cell phone number themselves, so it needs to be
configured, numbers added and deleted, through a web page on the PBX.

So I'm thinking I need a dialplan app that has to interface with a
MySQL database that holds the list of numbers, so I can build a
webpage to add/delete the numbers.

Any ideas would be much appreciated.

Thanks.

JR
---------------------
JR Richardson
Engineering for the Masses

Hey JR,

Is this a one VIP to one cell number match? Or is it on VIP to multiple cells?

On Tue, Aug 26, 2008 at 7:28 PM, JR Richardson <jmr.richardson at
gmail.com> wrote:
> Hi All,
>
> I received a request for a special application and need some guidance.
>  Cust has there own Asterisk PBX with SIP phones, pretty standard
> setup.
>
> They want an after hours application that checks inbound caller ID
> numbers and matches them to a list, say 5 to 10 numbers of special VIP
> customers, if there is a match on the list, then forward the call
> straight to a cell phone, instead of ringing local extension and then
> to voicemail.
>
> The customer also wants to be able to manage this VIP list and the
> call forward cell phone number themselves, so it needs to be
> configured, numbers added and deleted, through a web page on the PBX.
>
> So I'm thinking I need a dialplan app that has to interface with a
> MySQL database that holds the list of numbers, so I can build a
> webpage to add/delete the numbers.
>
> Any ideas would be much appreciated.
>
> Thanks.
>
> JR
> ---------------------
> JR Richardson
> Engineering for the Masses
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> AstriCon 2008 - September 22 - 25 Phoenix, Arizona
> Register Now: http://www.astricon.net
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>


-- 
*****************************
Bruce Reeves, dCAp
EUS Networks
Office: 212-624-5943
Web: www.euscorp.com
****************************

On Tuesday 26 August 2008 19:28:17 JR Richardson wrote:
> I received a request for a special application and need some guidance.
>  Cust has there own Asterisk PBX with SIP phones, pretty standard
> setup.
>
> They want an after hours application that checks inbound caller ID
> numbers and matches them to a list, say 5 to 10 numbers of special VIP
> customers, if there is a match on the list, then forward the call
> straight to a cell phone, instead of ringing local extension and then
> to voicemail.
>
> The customer also wants to be able to manage this VIP list and the
> call forward cell phone number themselves, so it needs to be
> configured, numbers added and deleted, through a web page on the PBX.
>
> So I'm thinking I need a dialplan app that has to interface with a
> MySQL database that holds the list of numbers, so I can build a
> webpage to add/delete the numbers.
>
> Any ideas would be much appreciated.
Sounds like a good use of func_odbc, something along the lines of:

func_odbc.conf:
[APPROVED]
dsn=asterisk-mysql
read=SELECT COUNT(*) FROM approved_table WHERE callerid='${ARG1}'

extensions.conf:
exten => foo,1,GotoIf(${ODBC_APPROVED(${CALLERID(num)})}?callout)
exten => foo,n,Voicemail(foo,u)

And then your web app is pretty easily just a frontend to your database table.

-- 
Tilghman

Hi JR, 

This may help you - we were using it to route calls from friends through the
IVR so they hit us directly. You'll have to modify it to suit your dialplan,
but it should be a good starting point. 

http://www.voipphreak.ca/2006/11/26/asterisk-14-php-rolodex-howto-script/


Thanks,
Matt G

: http://www.voipphreak.ca
: http://www.ratemydialplan.com


-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of JR Richardson
Sent: Tuesday, August 26, 2008 8:28 PM
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] Need application, CID number match list to call
cell phone

Hi All,

I received a request for a special application and need some guidance.
 Cust has there own Asterisk PBX with SIP phones, pretty standard
setup.

They want an after hours application that checks inbound caller ID
numbers and matches them to a list, say 5 to 10 numbers of special VIP
customers, if there is a match on the list, then forward the call
straight to a cell phone, instead of ringing local extension and then
to voicemail.

The customer also wants to be able to manage this VIP list and the
call forward cell phone number themselves, so it needs to be
configured, numbers added and deleted, through a web page on the PBX.

So I'm thinking I need a dialplan app that has to interface with a
MySQL database that holds the list of numbers, so I can build a
webpage to add/delete the numbers.

Any ideas would be much appreciated.

Thanks.

JR
---------------------
JR Richardson
Engineering for the Masses

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

AstriCon 2008 - September 22 - 25 Phoenix, Arizona
Register Now: http://www.astricon.net

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

On Tue, 26 Aug 2008, JR Richardson wrote:
> Hi All,
>
> I received a request for a special application and need some guidance.
> Cust has there own Asterisk PBX with SIP phones, pretty standard
> setup.
>
> They want an after hours application that checks inbound caller ID
> numbers and matches them to a list, say 5 to 10 numbers of special VIP
> customers, if there is a match on the list, then forward the call
> straight to a cell phone, instead of ringing local extension and then
> to voicemail.
>
> The customer also wants to be able to manage this VIP list and the
> call forward cell phone number themselves, so it needs to be
> configured, numbers added and deleted, through a web page on the PBX.
>
> So I'm thinking I need a dialplan app that has to interface with a
> MySQL database that holds the list of numbers, so I can build a
> webpage to add/delete the numbers.
>
> Any ideas would be much appreciated.

> Is this a one VIP to one cell number match? Or is it on VIP to multiple
> cells?
> 
> On Tue, Aug 26, 2008 at 7:28 PM, JR Richardson <jmr.richardson at
gmail.com>
> wrote:
> > Hi All,
> >
> > I received a request for a special application and need some guidance.
> >  Cust has there own Asterisk PBX with SIP phones, pretty standard
> > setup.
> >
> > They want an after hours application that checks inbound caller ID
> > numbers and matches them to a list, say 5 to 10 numbers of special VIP
> > customers, if there is a match on the list, then forward the call
> > straight to a cell phone, instead of ringing local extension and then
> > to voicemail.
> >
> > The customer also wants to be able to manage this VIP list and the
> > call forward cell phone number themselves, so it needs to be
> > configured, numbers added and deleted, through a web page on the PBX.
> >
> > So I'm thinking I need a dialplan app that has to interface with a
> > MySQL database that holds the list of numbers, so I can build a
> > webpage to add/delete the numbers.
> >
[JR Richardson] 
The info I have is one cell phone, like an on-call cell that gets passed
around to on-call individuals.  But being able to change this number to a
different cell from time to time is required.

Thanks.

JR

> They want an after hours application that checks inbound caller ID
> numbers and matches them to a list, say 5 to 10 numbers of special VIP
> customers, if there is a match on the list, then forward the call
> straight to a cell phone, instead of ringing local extension and then
> to voicemail.
>
> The customer also wants to be able to manage this VIP list and the
> call forward cell phone number themselves, so it needs to be
> configured, numbers added and deleted, through a web page on the PBX.
This functionality already exists in FreePBX, which is essentially a
web GUI with a database backend that makes some Asterisk programming
tasks quite easy for people who only know how to point and click. In
FreePBX speak,

* you would do the CID matching in "Internal Routes", and have the
various CID matches jump to
* the cell phones, which you configure as "Extensions"
* you also need a "Trunk" to do the outbound dialing for the cell
phones, but you configure which trunk to dial out on in the
"Extensions" dialogue.

This might be a pain to join to your existing Asterisk dialplan now,
but if you think they're going to keep adding similar features and
want web GUIs on them, you might want to go the "use something that
already does the job" route.