Excel application for Cisco call manager.

[terry duffy]

I created this app in Excel with VBA Microsoft forms and using various Cisco API calls.

It can quickly copy a lot of phones from one model to a different model.

Create new UCCX agents and MACD work, adding or removing a user from a phone.

Quick Youtube video demonstration:

https://youtu.be/xFEIM6Kxv0w

[CraigGilliam09639]

Outstanding. I`m needing to do this same type application. Questions if you don`t mind. Is excel doing the api calls to Call Manager?

[terry duffy]

Yes, Excel is making the API calls. I'm manually creating the AXL SOAP strings and sending them to the CUCM server, then manually parsing the results from the CUCM.

I created a blog that shows how I did some of this: https://ciscocande.wordpress.com/

The blog shows an very early version of the app, before I started using Microsoft forms.

I had started from scratch, learning how to program and learning how to use the CUCM API at the same time.

[CraigGilliam09639]

Great job. I have done some with SoapUI and Postman but having a front end to be able to allow like helpdesk to do the task would be awesome. 

[rob1456657]

Is this tool available for download?

[terry duffy]

Unfortunately no, I created this specific for our environment, I have considered building a generic one with an enterpriser settings page, so it could be used in other CUCM installations.

Which application function are you mostly interested in? Phone copy?

[rob1456657]

Yes, that's correct. I have VBA knowledge, is it difficult to change the connection string to the CUCM installation?

[terry duffy]

The connection string is simple, I have other items hardcoded specifically for our environment, that would need a separate configuration page along with the server IP address for your server.