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!
