Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

cucm 8.5 bulk edit extension numbers.

Hi guys

We have a customer who is moving from 4 digit extension to a 6 digit plan. I have phones registered to call manager with 4 digit number already.

What is the best way to update the extension numbers to adhere new dial plan.

Can anyone share the ideas please.

I was trying to export the config. Update it. And import it. But what I have noticed is that in the export config directory number option doesn't even exists.

Thanks in advance.

Sent from Cisco Technical Support iPad App

23 REPLIES

cucm 8.5 bulk edit extension numbers.

Hi.

Using bulk administration and exporting all phones detail, you should obtain what you need.

I've already done this task in the past and I used this tool.

HTH

Regards

Carlo

Please rate all helpful posts "The more you help the more you learn"
New Member

Re: cucm 8.5 bulk edit extension numbers.

hi

Thanks for your reply. I have tried that. This generates a .tar file which contains a csv file. When I open that file with excel. I get an error message saying the file is too big. May be row or column exceed the maximum value of 256.

I don't know what to do next.

Sent from Cisco Technical Support iPad App

Super Bronze

Re: cucm 8.5 bulk edit extension numbers.

Hi

Yes, Excel isn't man enough for this task - if you have users with multiple lines or lots of speed dials itexceeds the maximum columsn available.

You could try OpenOffice which seems better (in some ways - in others it's worse).

Either way you have to take care that the editor you use doesn't make unwanted edits (like inserting quotes or other formatting). I wrote some tools for our organisation for manipulating the CSVs for this type of task.

The other alternative is to use AXL. THe attached zip contains some java code you can extract to a directory, and create yourself an input file with lines like this:

1201,Test2PT,4444

This example would find line 1201 in partition Test2PT, and renumber it to '4444'.

You would run the program by going to a command prompt in the extracted directory and typing this (all one one line of course and using appropriate values to access your CUCM):

extensionsupdatedn.exe -username=ccmadministrator -password=mypassword -hostname=192.168.0.86 -input=ExtensionRemaptest.csv


You should of course do a couple of test extensions before doing a large batch.

Also allow plenty of time for testing etc, and go through anything else that might rely on extension numbers:

  • Translation patterns
  • People's CFA/CFNA/CFB settings that may point to particular extension numbers
  • Telephone number attribute in the end user directory

And so on..

Aaron

Please rate helpful posts..

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

cucm 8.5 bulk edit extension numbers.

Hi Aaron,

I have a huge number of DN  to change and unfortunately your software returns me the following error:

C:\c>extensionsupdatedn -username=c -password=c -hostname=192.168.1.59 -input=e1.csv

Exception in thread "main" java.lang.NoClassDefFoundError: extensionsremapdn/ExtensionsRemapDN

Caused by: java.lang.ClassNotFoundException: extensionsremapdn.ExtensionsRemapDN

        at java.net.URLClassLoader$1.run(Unknown Source)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.net.URLClassLoader.findClass(Unknown Source)

        at java.lang.ClassLoader.loadClass(Unknown Source)

        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

        at java.lang.ClassLoader.loadClass(Unknown Source)

Could not find the main class: extensionsremapdn.ExtensionsRemapDN.  Program will exit.

Could you have a look ?

Kind regards

Thomas

New Member

cucm 8.5 bulk edit extension numbers.

I'm getting the same. Did you ever resolve this? Did you take another approach?

New Member

cucm 8.5 bulk edit extension numbers.

Hi Aaron,

Do you have any update about the error.. the system return me the same error:

Exception in thread "main" java.lang.NoClassDefFoundError: extensionsremapdn/ExtensionsR

Caused by: java.lang.ClassNotFoundException: extensionsremapdn.ExtensionsRemapDN

        at java.net.URLClassLoader$1.run(Unknown Source)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.net.URLClassLoader.findClass(Unknown Source)

        at java.lang.ClassLoader.loadClass(Unknown Source)

        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

        at java.lang.ClassLoader.loadClass(Unknown Source)

Could not find the main class: extensionsremapdn.ExtensionsRemapDN.  Program will exit.

Please, help us.

Thanks

Super Bronze

Re: cucm 8.5 bulk edit extension numbers.

Hi Christian

Not sure what I did wrong there...

Try this one.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

cucm 8.5 bulk edit extension numbers.

Hi Aaron,

This file works great... many thanks... i test it with 300 extensions and CUCM 6.0.1.2000-4 and Workss!!!

Thanks anew.

Super Bronze

cucm 8.5 bulk edit extension numbers.

No problem!

Aaron Harrison

Principal Engineer at Logicalis UK

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

cucm 8.5 bulk edit extension numbers.

Hello Aaron,

how can I use your software, if the partition of the DN to remap is ?

I have tried in different ways, but none of them works:

1201,,4444

1201,"",4444

1201,'',4444

1201,,4444

Regards.

New Member

cucm 8.5 bulk edit extension numbers.

Have you found a solution to this?

Partition is set to here as well.

New Member

cucm 8.5 bulk edit extension numbers.

Aaron... you 'da man!

You have no idea how helpful this is to me!

I found that there is a bug in 8.6 that it doesn't work with IP Communicator (fails with a "DND Option not available"). Ironically, I was just testing it against a experimental IP Communicator.  When I tried a typical 7975.. it worked like a dream.

Thanks!

Super Bronze

cucm 8.5 bulk edit extension numbers.

Glad it helped - if it's useful, please rate it :-)

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

cucm 8.5 bulk edit extension numbers.

A lot of thanks Aaron Harrison, I used your program and it worked great in a 8.6 CUCM versión (with 3,500 DNs).

In the other hand, after I made this DN upgrade, all the  endusers remain with the last Directory Number and I can't upgrade them  by BULk without changing the current user PIN.

Is there a way to upgrade the Directory Number in the EndUser without changing the current PIN? Similar as the DN procedure.

Regards

New Member

Hi Aaron,

Hi Aaron,

Would your code work on CUCM v 10.5 please?

New Member

Hi Aaron,

Hi Aaron,

it seems that there are some differences to CUCM version 10.x. I can get a connect to the database and get the output "processing..." and later "ERROR: Directory Number not found". in the csv-file i have

1234,mypartition,491234

There is a DN 1234 in the partition "mypartition" which I want to change to 491234.

Do you have an idea?

Thx in advance.

kind rgds

Manfred

New Member

Hi Aaron,

Hi Aaron,

This does not work for 10.5. do you have an updates version? is this utility available commercially / paid version that supports 10.5?

Super Bronze

Hi

Hi

I can certainly make something available for you on that basis if you like.

PM me if interested..

Thanks

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Hello Aaron,

Hello Aaron,

Were you able to make one for 10.5 version?

Regards,

Yaman Verma

New Member

Hey Aaron

Hey Aaron

Great tool, thank you for sharing. 

Did you ever make a version for 10.5? if so, can you share it?

Best regards

Allan Mancera

New Member

Hi everybody,

Hi everybody,

Did already a version of this tool AXL to version 11.5? I´m trying the upload in this forum but I get the error: ERROR: Directory Number not found

I would appreciated if there a tool for this version of CUCM.

New Member

Hi Aaron,

Hi Aaron,

I know a bit of Perl. I would like to write 2 scripts in that language. One that takes an input csv file (like in your Java program but the values will be old partition, DN, new partition) and updates the partition on a DN to a new partition. The second script takes an input csv file with DNs, it finds all devices that have that DN as a line and reboots them. I am okay with running such scripts from a cli environment. Do you know if Perl can achieve these request? Two, what documentation can you point me to so that I can build such scripts. 

Your help is greatly appreciated. 

New Member

hi.. guys.. looks like many

hi.. guys.. looks like many ppl been able to make this work.. can some one please suggets me the steps how to make this.. as i have 4 digits and becoz of series change i have to move to 5 digits now. can you guys please help me on this. i have cucm 6.1.3

5851
Views
65
Helpful
23
Replies