Peter Braidwood
2004-Dec-22 04:53 UTC
[Asterisk-Users] Matching Caller ID against a database of knowncallers
Hi, I use a simple script to query a 2 table's in a MySQL database. This is called using AGI. The first one has got about 200 rows in it each one is a caller ID number and a name. If I get a match then I set CLI to "name <number>" The second table has over 10,000 rows in it. It has all the telephone exchanges in the UK in it with the prefixes for the exchange. If I haven't found a match in the first table then I search the second one and set the CLI to "area name <number>" Doing this has no apparent delay to the call. Peter> -----Original Message----- > From: Eric Bishop [mailto:asterisk.eric@gmail.com] > Sent: 22 December 2004 06:13 > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: [Asterisk-Users] Matching Caller ID against a database of > knowncallers > > > Hi All, > > Is it possible to match caller ID on incoming calls against say text > file of know numbers and diaplay the name rather than the numerical > caller ID? > > I know some handsets such as the SNOM 190 can do this from within the > handset, but I would like it done and updated centrally at the > Asterisk box..... > _______________________________________________ > 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 > > ______________________________________________________________ > __________ > This e-mail has been scanned for all viruses by Star. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________ > __________ >________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________
Eric Bishop
2004-Dec-22 05:24 UTC
[Asterisk-Users] Matching Caller ID against a database of knowncallers
Would you mind posting the script and extensions.conf entry to the list? On Wed, 22 Dec 2004 11:53:42 -0000, Peter Braidwood <Peter@braidwood.co.uk> wrote:> Hi, > > I use a simple script to query a 2 table's in a MySQL database. This is called using AGI. > > The first one has got about 200 rows in it each one is a caller ID number and a name. If I get a match then I set CLI to "name <number>" > > The second table has over 10,000 rows in it. It has all the telephone exchanges in the UK in it with the prefixes for the exchange. If I haven't found a match in the first table then I search the second one and set the CLI to "area name <number>" > > Doing this has no apparent delay to the call. > > Peter > > > -----Original Message----- > > From: Eric Bishop [mailto:asterisk.eric@gmail.com] > > Sent: 22 December 2004 06:13 > > To: Asterisk Users Mailing List - Non-Commercial Discussion > > Subject: [Asterisk-Users] Matching Caller ID against a database of > > knowncallers > > > > > > Hi All, > > > > Is it possible to match caller ID on incoming calls against say text > > file of know numbers and diaplay the name rather than the numerical > > caller ID? > > > > I know some handsets such as the SNOM 190 can do this from within the > > handset, but I would like it done and updated centrally at the > > Asterisk box..... > > _______________________________________________ > > 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 > > > > ______________________________________________________________ > > __________ > > This e-mail has been scanned for all viruses by Star. The > > service is powered by MessageLabs. For more information on a proactive > > anti-virus service working around the clock, around the globe, visit: > > http://www.star.net.uk > > ______________________________________________________________ > > __________ > > > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ >
Peter Braidwood
2004-Dec-22 08:58 UTC
[Asterisk-Users] Matching Caller ID against a database of knowncallers
The scripts and details are here http://www.networks.org.uk if anyone is interested Regards Peter> -----Original Message----- > From: Eric Bishop [mailto:asterisk.eric@gmail.com] > Sent: 22 December 2004 12:25 > To: Peter Braidwood; Asterisk Users Mailing List - Non-Commercial > Discussion > Subject: Re: [Asterisk-Users] Matching Caller ID against a database of > knowncallers > > > Would you mind posting the script and extensions.conf entry > to the list? > > > On Wed, 22 Dec 2004 11:53:42 -0000, Peter Braidwood > <Peter@braidwood.co.uk> wrote: > > Hi, > > > > I use a simple script to query a 2 table's in a MySQL > database. This is called using AGI. > > > > The first one has got about 200 rows in it each one is a > caller ID number and a name. If I get a match then I set CLI > to "name <number>" > > > > The second table has over 10,000 rows in it. It has all the > telephone exchanges in the UK in it with the prefixes for the > exchange. If I haven't found a match in the first table then > I search the second one and set the CLI to "area name <number>" > > > > Doing this has no apparent delay to the call. > > > > Peter > > > > > -----Original Message----- > > > From: Eric Bishop [mailto:asterisk.eric@gmail.com] > > > Sent: 22 December 2004 06:13 > > > To: Asterisk Users Mailing List - Non-Commercial Discussion > > > Subject: [Asterisk-Users] Matching Caller ID against a database of > > > knowncallers > > > > > > > > > Hi All, > > > > > > Is it possible to match caller ID on incoming calls > against say text > > > file of know numbers and diaplay the name rather than the > numerical > > > caller ID? > > > > > > I know some handsets such as the SNOM 190 can do this > from within the > > > handset, but I would like it done and updated centrally at the > > > Asterisk box..... > > > _______________________________________________ > > > 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 > > > > > > ______________________________________________________________ > > > __________ > > > This e-mail has been scanned for all viruses by Star. The > > > service is powered by MessageLabs. For more information > on a proactive > > > anti-virus service working around the clock, around the > globe, visit: > > > http://www.star.net.uk > > > ______________________________________________________________ > > > __________ > > > > > > > > ______________________________________________________________ > __________ > > This e-mail has been scanned for all viruses by Star. The > > service is powered by MessageLabs. For more information on > a proactive > > anti-virus service working around the clock, around the > globe, visit: > > http://www.star.net.uk > > > ______________________________________________________________ > __________ > > > > ______________________________________________________________ > __________ > This e-mail has been scanned for all viruses by Star. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ______________________________________________________________ > __________ >________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________