Blogs

Showing 1 - 5 of 32 results.
Items per Page 5
of 7
First Previous Last

Forums

« Back to Cisco TAPI Questions

Tapi Information into SQL database

Combination View Flat View Tree View
Threads [ Previous | Next ]
Tapi Information into SQL database
tapi api tsp tapi cisco
Answer
7/1/12 7:25 PM
Hi,
 
we want to write a little program which reads the following information e.g. every hour from the CISCO TAPI and saves them into a SQL database for further analysis:
 
 
- For calls that were answered:
 
Number of calls for the given time frame (5 min, 10 min, 60 min samples)
Time until the call the was answered (this is often group into 0-20, 21-40, 41-60 and 60+ second groupings)
(Average) Duration of the call
 
- For calls that weren’t answered
 
Number of calls for the given time frame (5 min, 10 min, 60 min samples)
Time until the call the was dropped (this is often group into 0-20, 21-40, 41-60 and 60+ second groupings)
 
- For calls that received an engaged tone
 
Number of calls for the given time frame (5 min, 10 min, 60 min samples)
 
These reports are normally defined for one telephone number or a group of numbers.
 
I'm completely new to this API and I would really appreciate any information or sample code for this. Maybe somebody also has already a suggested database schema for the data from the API.
 
Thanks
Daniel
 
Flag

RE: Tapi Information into SQL database
Answer
9/11/12 7:52 PM as a reply to Daniel Schmitz.
The TAPI is used to dynamically monitor phone devices, receiving events in real time for call state changes (e.g. new call, hangup, etc.)  If you want to use this type of API for collecting call statistics, the application will need to continously monitor the target devices, and calculate call times and meta-data based on TAPI events.
 
The type of application you are describing may be better served by using the UC Manager Call Detal Records facility:
 
http://developer.cisco.com/web/sxml/docs
Flag

Collateral


No files available