<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:#000066;}
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:#000066;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>There is an UPDATE feature but unless I’m misunderstanding
your request it won’t do what you want to do. If you want to change the external
phone number mask field on every line with an extension that begins with X to
234555XXXX or if you want to change the forward busy internal destination to
4500 on every phone in a certain calling search space then the UPDATE tool is
perfect. But if you want it to change the line text label to something
different on each line of 1000 phones (each line text label has a different
value), then the update tool won’t work. Your description of what you are
trying to achieve is vague – I assume that you want to have a spreadsheet
that has something like:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>EXT NEW LINE
TEXT LABEL<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>1000 Joe Smith<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>1001 Bob Jones<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>1003 Ann Johnson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>1307 Mike Regal<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>(and so on)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>And then you want BAT to go thru the above file and if it finds
ext. 1000 then it should overwrite the existing line text label with Joe Smith
and then on ext. 1001 replace the existing line text label with Bob Jones,
etc., etc. It won’t to this. If this is what you want I don’t know
of any other way than either AXL or deleting and recreating the phones (or
updating each line manually).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If anyone else knows of an easier or better way it I’m all
ears.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-Go0se<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a href="http://atc.go0se.com">http://atc.go0se.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> Anthony Kouloglou
[mailto:akoul@dataways.gr] <br>
<b>Sent:</b> Wednesday, May 20, 2009 12:38 PM<br>
<b>To:</b> Go0se<br>
<b>Cc:</b> 'Dana Tong (AU)'; 'ci >>
"cisco-voip@puck-nether.net"'<br>
<b>Subject:</b> Re: [cisco-voip] Update Specific Line Fields in CUCM 6.1(2)
using BAT<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Hi
Goose,<br>
you mean what Dana suggested, is not possible? I will have to delete the phones
before reentering them?<br>
There is no way to update the phones?<br>
<br>
Thanks<br>
Anthony<br>
</span><br>
Go0se wrote: <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If you are using BAT you would need to export the phone
information, “massage” it back into a new BAT file (or files) with
required changes, delete the existing phones, and then re-import the phones
from the new BAT file(s). IF YOU DO THIS BE SURE YOU HAVE AUTO REGISTRATION
TURNED OFF otherwise all your phones will auto register after you do the delete
and the new import will fail. If you have a lot of phones to update, I’ll
give you a word of advice from experience… I would suggest you perform
this on a small subset of phones first before you “shotgun blast” a
large number of phones.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If you simply wish to change the Caller ID on x number of phones
from their individual extensions to say the company’s main number you can
do so via the UPDATE LINES function (BULK ADMINISTRATION | PHONES |ADD/UPDATE
LINES | UPDATE LINES). You can perform a query that finds the extensions you
wish to change, then in the UPDATE LINES section check the box next to
“external phone number mask” and in the box enter the main phone
number of the company. You cannot, however, do a query that will parse a BAT
file full of something like “current caller id” and “new
caller id” fields getting it to do a glorified “search and
replace”. I believe you would need to resort to AXL for something like
that.</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-Go0se</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a href="http://atc.go0se.com">http://atc.go0se.com</a></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> </span><o:p></o:p></p>
<div>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> <a
href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>
[<a href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Anthony Kouloglou<br>
<b>Sent:</b> Wednesday, May 20, 2009 2:22 AM<br>
<b>To:</b> Dana Tong (AU)<br>
<b>Cc:</b> ci >> <a href="mailto:cisco-voip@puck-nether.net">"cisco-voip@puck-nether.net"</a><br>
<b>Subject:</b> Re: [cisco-voip] Update Specific Line Fields in CUCM 6.1(2)
using BAT<br>
<b>Importance:</b> Low</span><o:p></o:p></p>
</div>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Hi,<br>
do i have to delete those phones?<br>
I cannot see anywhere update phones.<br>
If i try to insert phones that are already registered, i get an error message.<br>
Also, i have tried to to inserted lines with bat.xlt but i get an error message
after i click on export to BAT format "compile error, sub or function not
defined"</span><o:p></o:p></p>
</div>
</body>
</html>