[Asterisk-Users] Last callers script?

2005-01-05 Thread Mike Dent
Hi,
Is there some script which can be called from a * extension to
playback the recent incoming
callers on a particular PSTN line?

In the UK 1471 is a BT number which plays back the most recent callers
number, it also
gives you the option to call this number back (now charging you for
this service too!).

Is there anything similar in asterisk-land?
thanks
Mike
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
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] Last callers script?

2005-01-05 Thread Roger Gulbranson
On Wed, 2005-01-05 at 11:00, Mike Dent wrote:
 Hi,
 Is there some script which can be called from a * extension to
 playback the recent incoming
 callers on a particular PSTN line?
 
 In the UK 1471 is a BT number which plays back the most recent callers
 number, it also
 gives you the option to call this number back (now charging you for
 this service too!).
 
 Is there anything similar in asterisk-land?

I have an AGI script (a modified version of calleridnamelookup.agi)
that, among other things, stores the channel and callerid in a mysql
DB.  The AGI is called from within my IVR processing on all the inbound
channels.  I happen to use this for a web page that displays the most
recent 20 calls.

Writing an AGI script to take a channel and find the last inbound
callerid should be an easy thing to do (once you have the data).

No doubt there are other ways to achieve the same result.  DBget/DBput
could be used, for example.

___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
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] Last callers script?

2005-01-05 Thread John Middleton
See

http://www.wheely-bin.co.uk/asterisk/ check this link - I've
implemented it and it works, at least in the test environment.

John



On Wed, 5 Jan 2005 16:00:56 +, Mike Dent [EMAIL PROTECTED] wrote:
 Hi,
 Is there some script which can be called from a * extension to
 playback the recent incoming
 callers on a particular PSTN line?
 
 In the UK 1471 is a BT number which plays back the most recent callers
 number, it also
 gives you the option to call this number back (now charging you for
 this service too!).
 
 Is there anything similar in asterisk-land?
 thanks
 Mike
 ___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com
 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
Asterisk-Users@lists.digium.com
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] Last callers script?

2005-01-05 Thread Mike Dent
That sounds like it might just be the ticket Roger.
I like the web page idea too.
Would you be willing to share it please?
Thanks
Mike



On Wed, 05 Jan 2005 11:32:08 -0500, Roger Gulbranson
[EMAIL PROTECTED] wrote:
 On Wed, 2005-01-05 at 11:00, Mike Dent wrote:
  Hi,
  Is there some script which can be called from a * extension to
  playback the recent incoming
  callers on a particular PSTN line?
 
  In the UK 1471 is a BT number which plays back the most recent callers
  number, it also
  gives you the option to call this number back (now charging you for
  this service too!).
 
  Is there anything similar in asterisk-land?
 
 I have an AGI script (a modified version of calleridnamelookup.agi)
 that, among other things, stores the channel and callerid in a mysql
 DB.  The AGI is called from within my IVR processing on all the inbound
 channels.  I happen to use this for a web page that displays the most
 recent 20 calls.
 
 Writing an AGI script to take a channel and find the last inbound
 callerid should be an easy thing to do (once you have the data).
 
 No doubt there are other ways to achieve the same result.  DBget/DBput
 could be used, for example.
 
 ___
 Asterisk-Users mailing list
 Asterisk-Users@lists.digium.com
 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
Asterisk-Users@lists.digium.com
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] Last callers script?

2005-01-05 Thread Roger Gulbranson
On Wed, 2005-01-05 at 15:52, Mike Dent wrote:
 That sounds like it might just be the ticket Roger.
 I like the web page idea too.
 Would you be willing to share it please?

I've attached the agi script.

My web site is written in Mason which probably doesn't interest many
folks.

The table I use is:

mysql describe asterisk_callerid_history;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| timestamp | datetime| YES  | MUL | NULL|   |
| callerid  | varchar(80) | YES  | | NULL|   |
| channel   | varchar(50) | YES  | | NULL|   |
+---+-+--+-+-+---+

If you know SQL figuring out how to 'select' the table for either a web
page or a lookup agi script should not be a big deal.


calleridnamelookup.agi
Description: Perl program
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users