Solved

Reading Data from Cisco CUCM Call Manager 8.0 for Calls Recorded through ASP.NET VB

Posted on 2010-09-22
8
2,038 Views
Last Modified: 2013-12-27
Hi All,

We have installed Cisco VOIP in our network and we have the Cisco CUCM 8.0 call manager set up. We need to be able to query the CUCM database from ASP.NET using VB code, and retrieve data from it into our SQL like caller ID, direct extension called.

I know we can export CDR data from CUCM directly and dump it into SQL, but i need to do the opposite: We are making an application to be installed on some user machines which uses triggers when new call received by a user to show a popup screen on the spot with information of caller (after quering the caller ID number with our own SQL database for user information). Any feedback is highly appreciated.

Thanks!!
0
Comment
Question by:i_harfoush
  • 3
  • 3
8 Comments
 
LVL 9

Expert Comment

by:Alex Bahar
ID: 33742821
You can monitor the calls for certain extensions/users on the client machine using Cisco JTAPI. On the Call Manager you have to activate the CiscoCTI service, enable CTI on the User configuration page associated to the extension, create CTI port and CTI route point associated to the user/extension you want to monitor.
 You can download the JTAPI/TAPI client driver on the Call Manager plugins page. You need to configure the JTAP/TAPI driver with the Call manager user credentials. When activated, the JTAPI client will register to the Call Manager like a softphone with the same phone extension. hence it will receive the call information (CallerID) when a new call is made to this phone. Your CTI application running on the client PC will communicate with the JTAPI/TAPI device to learn the CallerID when a new call comes in.
This may sound complicated if you are not a Call Manager admin as there are multiple steps involved in the configuration. I gave you the necessary pointers. You need to learn the details by reading references.
Check the following links as a starting point.
Cisco Unified TAPI Developers Guide for Cisco Unified Communications Manager  
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/tapi_dev/7_0_1/CUCM_TAPI_Dev_Guide.html
Computer Telephony Integration
http://www.ciscosystems.com/en/US/docs/voice_ip_comm/cucm/admin/3_1_1/ccmsys/a08cti.html
Cisco JTAPI operations and developer resources
http://developer.cisco.com/web/jtapi/home
http://developer.cisco.com/web/jtapi/wikidocs/-/wiki/Main/Cisco%20Unified%20JTAPI%20Operations-by-Release%20Matrix
0
 
LVL 9

Accepted Solution

by:
Alex Bahar earned 500 total points
ID: 33742864
Take a look at the examples here > Utilizing TAPI from ASP.NET
http://www.julmar.com/blog/mark/2006/11/14/UtilizingTAPIFromAnASPNETApplication.aspx
0
 

Author Comment

by:i_harfoush
ID: 33743016
Thanks Abahar for the feedback, i will review the attached links and i will keep you updated with results my attempts. Thanks again!
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 9

Expert Comment

by:Alex Bahar
ID: 33743215
No worries. There are plenty of references about TAPI & .NET programming on the net. For you, getting the call manager TAPI client will be the tricky part, I guess.
I hope it all goes well.
0
 

Author Closing Comment

by:i_harfoush
ID: 33786411
Fine answer
0
 

Author Comment

by:i_harfoush
ID: 33786418
I have downloaded the TAPI for .Net and checked all the links above but this only helps in how to use the PC as a dialer through the modem configured. I could not find anything on how to connect to Cisco CallManager database and read data from it directly. Even on Cisco website nothing is stated in there. Anyway i will close this and grant you the points, we will be working around this in another way through the call agent popup screen. Thanks mate!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Although VoiceOver IP has been around for a while, internet connections have only recently become fast enough to provide good call quality. Now, VoIP has become a real option for businesses looking at ways to improve their business model. In this ar…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now