Not sure the Import/Export can be used to export Phones and Device Profiles but I will check it out. <div><br></div><div>The only way I found was to use BAT Export All details and we get a csv file with 1200 plus columns which is a pain to edit. </div>
<div><br></div><div><br><div><br></div><div><br> <br><div class="gmail_quote">On Wed, Jul 14, 2010 at 8:18 PM, James Buchanan <span dir="ltr"><<a href="mailto:jbuchanan@ctiusa.com">jbuchanan@ctiusa.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">If I understand correctly, you are trying to take every DN and
put a two or three digit code in front of the existing DN.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">The easiest way to do this (if running CUCM 7 or above) is to
use the Import/Export capability. Basically, export the existing dial plan,
which will likely export as a tar file. Extract it, modify the csv file, re-tar
it, and import that tar. </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thanks,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span style="font-size:7.0pt;color:#7F7F7F">James Buchanan </span></b><span style="font-size:7.0pt;color:#7E7E7E">|</span><b><span style="font-size:7.0pt;color:#7F7F7F">
Senior Network Engineer </span></b><span style="font-size:7.0pt;color:#7E7E7E">|</span><span style="font-size:7.0pt;color:#7F7F7F"> <b>South Region </b></span><span style="font-size:7.0pt;color:#7E7E7E">|</span><b><span style="font-size:7.0pt;color:#7F7F7F">
Presidio Networked Solutions <br>
12 Cadillac Dr, Suite 130, Brentwood, TN 37027 </span></b><span style="font-size:7.0pt;color:#7E7E7E">|</span><b><span style="font-size:7.0pt;color:#7F7F7F"> </span></b><b><span style="font-size:7.0pt;color:#7E7E7E"><a href="mailto:jbuchanan@ctiusa.com" target="_blank">jbuchanan@presidio.com</a><br>
</span></b><b><span style="font-size:7.0pt;color:#7F7F7F">D: 615-866-5729</span></b><span style="font-size:7.0pt;color:#7F7F7F"> </span><span style="font-size:7.0pt;color:#7E7E7E">| <b>F:</b>
</span><b><span style="font-size:7.0pt;color:#7F7F7F">615-866-5781</span></b><span style="font-size:7.0pt;color:#7F7F7F"> | </span><b><span style="font-size:7.0pt;color:#7E7E7E"><a href="http://www.presidio.com" target="_blank">www.presidio.com</a></span></b><span style="font-size:7.0pt;color:#1F497D"> <</span><b><span style="font-size:7.0pt;color:#7E7E7E"><a href="http://www.presidio.com" target="_blank">http://www.presidio.com</a></span></b><span style="font-size:7.0pt;color:#1F497D">> </span></p>
<p class="MsoNormal"><b><span style="font-size:7.0pt;color:#7F7F7F">CCIE #25863, Voice</span></b><span style="font-size:7.0pt;color:#1F497D"><br>
<br>
</span><span style="font-size:11.0pt;color:#1F497D"></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<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">From:</span></b><span style="font-size:10.0pt">
<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a> [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>] <b>On
Behalf Of </b>Ovidiu Popa</span></p><div class="im"><br>
<b>Sent:</b> Wednesday, July 14, 2010 1:05 PM<br>
<b>To:</b> Eric Butcher<br>
<b>Cc:</b> cisco-voip<br>
</div><b>Subject:</b> Re: [cisco-voip] dial-plan modification<p></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal">I have around 900 IP phones in 2 locations + 900 EM
profiles that I need to change because of a CTI application.</p>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Ok, for the SQL but that means I need a DB specialist
:( </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Any free applications that do this via AXL that I'm not
aware of?</p>
</div>
<div>
<p class="MsoNormal">Could we use a demo version of Cisco Provisioning
Manager? </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Thanks for the input.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Ovidiu</p>
</div>
<div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">On Wed, Jul 14, 2010 at 7:52 PM, Eric Butcher <<a href="mailto:Eric.Butcher@cdw.com" target="_blank">Eric.Butcher@cdw.com</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Can you elaborate a little? You
could make a special partition and put translation patterns in them to make it
more scalable and flexible… If you want to just modify the DN’s in bulk, I
suggest using some SQL. CUCM Plugins has an AXL SQL Toolkit you might be
able to use for it.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;color:black"> </span></b></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;color:black">Eric Butcher</span></b></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;color:black">Cisco Unified Communications Engineer</span></b><b><span style="font-size:11.0pt;color:black"><br>
</span></b><b><span style="font-size:7.5pt;color:red">CDW</span></b><span style="font-size:7.5pt;color:gray"> Professional Services</span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:gray">11711 N Meridian, Ste 225</span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;color:gray">Carmel, IN 46032<br>
</span><span style="font-size:10.0pt;font-family:Wingdings;color:black">(</span><span style="font-size:7.5pt;color:black"> 317.569.4282 - IP Phone<br>
</span><span style="font-size:10.0pt;font-family:Wingdings;color:black">(</span><span style="font-size:7.5pt;color:black"> 765.744.1458 - Mobile<br>
</span><span style="font-size:10.0pt;font-family:Wingdings;color:black">*</span><span style="font-size:7.5pt;color:black"> <a href="mailto:eric.butcher@cdw.com" target="_blank">eric.butcher@cdw.com</a></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:black"><a href="http://www.cdw.com/" target="_blank">http://www.cdw.com/</a></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>
[mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Ovidiu Popa<br>
<b>Sent:</b> Wednesday, July 14, 2010 1:47 PM<br>
<b>To:</b> cisco-voip<br>
<b>Subject:</b> [cisco-voip] dial-plan modification</span></p>
<div>
<div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hello
everyone</p>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Do
you know any quick methods to change the dial-plan on a CUCM cluster (i.e.
hardcoding a site code on every phone DN)? </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Thanks,</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Ovidiu</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"> </p>
</div>
</div></div></div>
</div>
</blockquote></div><br></div></div>