cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1931
Views
15
Helpful
5
Replies

Exporting Users Speed Dials from UCM 5 and Importing to CUCM 8

craigjohnneeld
Beginner
Beginner

I've been asked whether or not its possible to export ALL users personal speed dials from 3 existing UCM 5.1 clusters and importing them back into a new 8.6 cluster. Anybody have any funky ideas aside from hiring a team to manually extract them and readd on the new cluster?

5 Replies 5

In theory it's possible with AXL but I have yet to be forced to figure out how. You could probably suck the database entries out from one cluster into a CSV and reimport them on the new cluster. Note that speed dials and abbreviated dial entries are stored against a specific device name, not the end user object.

Here's the AXL developer's link. Hopefully others will add to this response with more specific AXL guidence.

http://developer.cisco.com/web/axl

Cisco Unified Communications Manager Data Dictionary, Release 8.6(1)

http://www.cisco.com/en/US/partner/docs/voice_ip_comm/cucm/devguide/8_6_1/axl.html

Hi

Well - getting the speed dials out is easy enough:

admin:run sql select d.name, s.* from device d join speeddial s on d.pkid = s.fkdevice

name          pkid                                 fkdevice                             speeddialindex speeddialnumber label labelascii

============= ==================================== ==================================== ============== =============== ===== ==========

SEPWORKLAPTOP bfc1b619-bc4b-48af-9679-02993332275c a164b74d-f1dc-f1b6-c552-5c5be6953132 1              123456789       hello hello

admin:

Putting them in you would have two options.

1) Use AXL - bit more of a learning curve

2) Use SQL and Excel. Basically conjugate some commands in Excel based on the output of the command above. The pkid in the speed dial table is generated by the system, so you need to supply all the other fields to make up a command like so:

insert into speeddial (fkdevice, speeddialindex, speeddialnumber, label, labelascii) values ((select pkid from device where device.name like 'SEPWORKLAPTOP'),1,'123456789','hello','hello')

The AXLSQLToolkit can then be used to insert a long series of those commands into the database. Or prefix them with 'run sql' and put them in the server CLI if you have time on your hands.

Be aware that direct DB manipulation is a very bad idea if you don't know what you are doing. The DB should enforce basic constraints (unique indexes where necessary and so on) but may not do the same validation of character strings etc that the web interface does - so you might put something in that makes CCMAdmin explode when it reads it. Since you are extracting from a 'working' system, hopefully your info won't stop this system 'working'.

Back up the server first, test a small batch first, etc. etc.

AXL is more 'supported' in as much as it shouldn't let you 'break' the DB, but you won't get much assistance from TAC with using the API.

Regards

Aaron

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

Thanks guys,

      Can this also be done for Personal Address Book and Fast Dial entries?

Hi

It's all in the DB, and it's all accessible via AXL - so yes, it's just a matter of looking up the information in the docs Jonathan posted..

Aaron

Please rate helpful posts..

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

Thanks again both!

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers