Exporting Phone Contacts -Personal Directory-Personal Address Book CUCM 10.5

[Janderso6]

Hello,

Is it possible to extract/export Phone Contacts from Personal Directory-Personal Address Book? Currently I have a user that has imported over 150+ contacts on his Cisco IP Phone in Personal Dircectory-Personal Address book. Just finished updating all the records with a 9 in front of them manually using Cisco Self Care Portal because Application Dial Rules are not working for CUCM 10.5 and 79XX series phones so had to manually change each phone contact to allow the user to use Personal Address Book in  Personal Directory from his Cisco Phone.

I can't see the personal address book contacts in Call manager to copy or export incase the user phones breaks. Self Care Portal does not allow me to export the contacts or copy them.

Is there a tool that allows you export the phone contacts in case his phone breaks or even to make changes rather than updating each record manually?

Please help

[Mohammed Khan]

Hi Janderso6,

You can export personal address book by  opening CUCM CLI and type below this commands :
show tech table personaladdressbook csv
show tech table personalphonebook csv
and then "file get activelog FileName" to get the files.

Note: There is no way to add these entries via BAT.

HTH,

Regards,

Mohammed Noor

[mattepps645]

Hi Mohammed,

Those commands worked great and I have exported both directories.  But, how do you import them again onto a new CUCM ?  I have recently migrated users off a CUCM v9 onto a newly built CUCM v11.5 and am being asked to try and reinstate these directories.

Best wishes,

Matt

[Aaron Harrison]

You can use AXL to retrieve and insert the records to the DB. I have previously written tools to do this..

Aaron

[mcappelli]

Hello Aaron,

Is it possibile use your tool to retrieve the records from DB ?

Thank you in advance

Marco

[Aaron Harrison]

Hi Marco

Perhaps - they may require some maintenance for 10.x.

PM Me.

Aaron

[Aaron Smith]

Sir, I have questions about exporting, updating and adding, and re-importing Personal Address Books in CUCM 10.5.

[Aaron Harrison]

Then you should ask the questions. 

[Aaron Smith]

We are partnered with a customer that runs a separate TMS/Video implementation. Instead of adding almost 200 users to our CUCM so that the Video Endpoints are in our directory, we wanted to create something like a Personal Directory and allow users to use it since almost no one in our deployment uses their Personal Directories.

How would I go about adding these partnered users to a Personal Directory in bulk?

You'd stated you had tools that would do it, but required updating for CUCM 10.

Thank you,
Aaron

[Pascal Blumenthal]

Hi Aaron

I have the same issue. I could export the calls but I'm not able to see the user ID. 

It is like this and I have no idea to which end user I need to add those entries.

Table:personalphonebook
pkid	fkenduser	fkpersonaladdressbook	tkpersonalphonenumber	phonenumber	personalfastdialindex
CHAR(36)	CHAR(36)	CHAR(36)	INTEGER	VARCHAR(50)	INTEGER
0bc28bc6-fbc7-71a7-93dc-8d45e57dedfc	ec4d20cd-52fb-4143-a578-2c8d23e52eab	730438d8-ed09-37d1-d6b3-c3276d64c5bc	21	000447528251051	0
001f818d-fb1d-22fc-985c-3602fd6ce848	233a023f-ed7e-41b8-8d0f-0c2e3bb61358	8d64c772-252e-175a-5c88-a1ffcbd43394	11	907781118254	0
01310aca-4b72-d261-2d0e-1ad5f15a620e	ec4d20cd-52fb-4143-a578-2c8d23e52eab	502baa8a-dacb-dc3c-b347-71722fb1cb1e	21	0004916096296284	0

Maybe you can share your tool with me as well?

Thank you very much.

Best regards,

Pascal

[Jareeshali K C]

Hi Janderso6,

Could you able to find any work around to import and export personal contacts and speed dial configured?

[carlos.perez1]

Hi Experts,
Do you know how many contacts as a personal directory can be stored on the 8841-8851 phones?

The corporate directory part is created locally in the CUCM or synchronized with AD, but I would like to know how many contacts I can save or create as a personal directory

Regards.

Carlos P.