topic Re: Excel application for Cisco call manager. in Management

Excel application for Cisco call manager.

terry duffy — Sat, 03 Jun 2023 14:19:41 GMT

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

Re: Excel application for Cisco call manager.

CraigGilliam09639 — Mon, 19 Jun 2023 20:17:10 GMT

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?

Re: Excel application for Cisco call manager.

terry duffy — Mon, 19 Jun 2023 22:39:26 GMT

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.

Re: Excel application for Cisco call manager.

CraigGilliam09639 — Tue, 20 Jun 2023 20:36:15 GMT

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.

Re: Excel application for Cisco call manager.

rob1456657 — Thu, 12 Oct 2023 17:09:27 GMT

Is this tool available for download?

Re: Excel application for Cisco call manager.

terry duffy — Thu, 12 Oct 2023 17:34:36 GMT

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?

Re: Excel application for Cisco call manager.

rob1456657 — Thu, 12 Oct 2023 17:48:29 GMT

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

Re: Excel application for Cisco call manager.

terry duffy — Mon, 16 Oct 2023 13:27:19 GMT

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.