<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>This is fantastic Nick. Thanks for sharing. I'm sure many of us will find this useful. Even if only to begin playing with this stuff and using the code you provided as a basis.<br><br>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>"Bad grammar makes me [sic]" - Tshirt<br><br><br>----- Original Message -----<br>From: "Nicholas Mooney" <Nicholas.Mooney@astrazeneca.com><br>To: cisco-voip@puck.nether.net<br>Sent: Thursday, May 7, 2009 3:10:37 AM GMT -05:00 US/Canada Eastern<br>Subject: Re: [cisco-voip] Adding names for outside callers<br><br>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Hi,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Found the solution to my problem in the end - with some help
from Cisco. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">The solution attached allows you to have a script that runs on
your PSTN gateway that polls a www server for the name of any incoming caller's
ANI. You need to build your own www site, script and database to return to the
results - however you probably already have most of this in the form of an
internal company phonelist. We are using CUCM 6 & 7 and a 2821 for the voice
infrastructure, and IIS and SQL which is feed from Active Directory for the
database infrastrucutre. It all works perfectly with about 3000 numbers in the
database.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">The functionality is enabled by a TCL script that goes on the
PSTN gateway router. The script came from Cisco initially and works like this:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Router gets an incoming PSTN call that matches the DID dial peer.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Router executes the attached script (caller_name.tcl)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">caller_name.tcl sends a www POST request with the parameter
"ani" which is the caller's number / ani to your www server</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">you build a website at <a href="http://x.x.x.x/IPTelephony/Default.asp" target="_blank">http://x.x.x.x/IPTelephony/Default.asp</a>
that takes the ani as a POST and looks it up in your corporate directory</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">your script at <a href="http://x.x.x.x/IPTelephony/Default.asp" target="_blank">http://x.x.x.x/IPTelephony/Default.asp</a>
must return either the plain text-only name like "Joe Bloggs" or
another string like "Unknown Caller" -- no html or anything else,
just characters</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">the characters/string returned from the script is displayed on
the screen of the IP Phones</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">You need to get the caller_name.tcl script and do this:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> change x.x.x.x to the IP of your webserver</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> change y.y.y.y to the IP of your publisher</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> load the script into the TFTP root on your publisher</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> setup your x.x.x.x website and scripts and database
(the hard bit)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> add these commands to your gateway:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">application</span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">service caller
tftp://y.y.y.y/caller_name.tcl</span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">dial-peer voice 4000 pots</span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> description Incoming
PSTN Calls</span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> service caller</span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> incoming called-number
99999999..$</span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> direct-inward-dial</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">and your done…</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Also - if you use remote destinations / mobility / snr then the
CUCM will overwrite whatever ANI response the tcl script gets. So if altering
name is set for a remote destination (mobile phone) then it will overwrite
whatever the gateway puts there.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Hope this helps someone --- it really should be a standard
feature from Cisco but its not. It seems whenever I replace a PABX with a Cisco
solution this is one of the first things users ask for - as most PABX's could have
global name / outside number combinations in a directory or abbreviated
numbering.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Nick.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; border-width: medium medium medium 1.5pt; padding: 0cm 0cm 0cm 4pt;">
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US"> Jason Burns [mailto:burns.jason@gmail.com] <br>
<b>Sent:</b> Friday, 28 November 2008 2:59 PM<br>
<b>To:</b> Mooney, Nicholas<br>
<b>Cc:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Adding names for outside callers</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">The Mobility feature in
CallManager 6.X might do what you're looking for.<br>
<br>
When the remote device associated with a particular user calls in, CallManager
does know which user is making the inbound call. I don't know what the display
info would be on these calls though.</p>
<div>
<p class="MsoNormal">On Thu, Nov 27, 2008 at 9:40 PM, Mooney, Nicholas <<a href="mailto:Nicholas.Mooney@astrazeneca.com" target="_blank">Nicholas.Mooney@astrazeneca.com</a>>
wrote:</p>
<p class="MsoNormal">Hi<br>
<br>
We have a requirement for our staff with mobile/cell phones calling to
CallManager to have their name displayed when the phone is ringing, along with
their number.<br>
<br>
I know it can be achieved on ARC Enterprise if you add the external numbers to
phone book, but we need it display on all general SCCP handsets (such 7942).<br>
<br>
Any ideas? Can the names be added on the gateway (h.323) or through a
translation pattern or a TCL script?<br>
<br>
Up to 500 names/numbers would be needed.<br>
<br>
Regards,<br>
<br>
Nick<br>
<br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></p>
</div>
<p class="MsoNormal"> </p>
</div>
</div>
<br>_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
</div></body></html>