<html 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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:0 0 0 0 0 0 0 0 0 0;}
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:78644704;
mso-list-template-ids:158908744;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:206375188;
mso-list-template-ids:-511821154;}
@list l1:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style>
</head>
<body lang="EN-GB" link="#0563C1" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Brilliant, thanks Nate. I can build the command lines in the spreadsheet I hold the data in. Nice one.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Gary<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">NateCCIE <nateccie@gmail.com><br>
<b>Date: </b>Monday, 12 June 2023 at 15:08<br>
<b>To: </b>Gary Parker <G.J.Parker@lboro.ac.uk><br>
<b>Cc: </b>voip puck <cisco-voip@puck.nether.net><br>
<b>Subject: </b>Re: [cisco-voip] Best Way To Bulk Update Lines/Directory Numbers?<o:p></o:p></span></p>
</div>
<div style="border:solid black 2.25pt;padding:0cm 0cm 0cm 0cm;margin-left:4.0pt;margin-top:4.0pt;margin-right:4.0pt;margin-bottom:4.0pt">
<p class="xmsonormal" align="center" style="text-align:center;line-height:12.0pt;background:#FFFFEE">
<span style="font-size:12.0pt;color:black">** THIS MESSAGE ORIGINATED OUTSIDE LOUGHBOROUGH UNIVERSITY **</span><span style="color:black">
</span><o:p></o:p></p>
<p class="xmsonormal" align="center" style="text-align:center;line-height:12.0pt;background:#FFFFEE">
<span style="font-size:12.0pt;color:black">** Be wary of links or attachments, especially if the email is unsolicited or you don't recognise the sender's email address. **</span><span style="color:black">
</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">SQL is the way to go here. <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Super easy to dump the commands into the cli, “run sql update numplan set fkroutepartition = ‘newguid’ where dnorpattern = ‘extension’”<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Call forward can be set the same way, but I don’t have that memorized still. <o:p></o:p></p>
<div>
<p class="MsoNormal">Sent from my iPhone<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">On Jun 12, 2023, at 6:41 AM, Gary Parker <G.J.Parker@lboro.ac.uk> wrote:<o:p></o:p></p>
</blockquote>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Hi folks, I’m migrating users from CUCM to Teams Phone and need to update:<o:p></o:p></p>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3">Route Partition<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3">Forward All Destination<o:p></o:p></li></ol>
<p class="MsoNormal">for a specific set of directory numbers that cannot be identified with a search based on CUCM data. The partition change will be to identify migrated numbers, the cfwdall will be to send calls out to a voice gateway that then sends the
call to our Teams tenant via SIP.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">It looks like I can do the Route Partition with an export/update line appearance job, so that’s good/simple.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">The call forward details will be different for each line. If the DN is 123456, the cfwdall will be to 901509123456, so this must be done with a custom file.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">If I do Phones -> Export Phones -> All Details’ I can see the call forward details for the lines on those phones in there, but there doesn’t seem to be a way to import that data back in as an update, only as ‘Phones -> Insert Phones’ for
new devices.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I could delete the existing phones I want to update, then Insert the modified entries back again as new phones, but I’m worried what other interactions that may break.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">The other option seems to be to do a full ‘Export -> Device Data -> Phone’ for the database tar file, edit the required lines, then Import again, but as you have to do the whole database that is very time consuming and also, I’d imagine,
service affecting?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I explored the option in the past of trying to forward calls placed to a line in the migrated partition using a transformation pattern but could not get this to work (I believe I posted about it on this list).<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">If anyone has an alternative suggestion for achieving the call forwarding I’d love to hear it.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Is there a way to forward calls from all the DNs to a kind of pilot number that then forwards again to a new destination based on the forwarding station? So, say for example, I forward calls from 635635 to 222222, some logic on 222222 forwards
the call to 901509635635; and for calls to 222333, forward to 222222, which then forwards to 901509222333<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:Courier;color:black">-- </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black">Gary Parker</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black">Unified Communications Service Manager</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:Courier;color:black">Loughborough University, IT Services</span><o:p></o:p></p>
<p class="MsoNormal"><a href="tel:+441509635635" title="tel:+441509635635"><span style="font-family:Courier">Phone - +441509635635</span></a><o:p></o:p></p>
<p class="MsoNormal"><a href="callto:g.j.parker@lboro.ac.uk" title="callto:g.j.parker@lboro.ac.uk"><span style="font-family:Courier">Teams - g.j.parker@lboro.ac.uk</span></a><o:p></o:p></p>
<p class="MsoNormal"><a href="https://www.osx.ninja/pubkey.txt" title="https://www.osx.ninja/pubkey.txt"><span style="font-family:Courier">https://www.osx.ninja/pubkey.txt</span></a><o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">_______________________________________________<br>
cisco-voip mailing list<br>
cisco-voip@puck.nether.net<br>
https://puck.nether.net/mailman/listinfo/cisco-voip<o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</div>
</body>
</html>