Solved

Capturing CDR from PBX

Posted on 2007-11-30
2
1,045 Views
Last Modified: 2013-12-27
Well, our call Accounting system crashed a month or so back. We cannot find a copy of the Call Accounting Software and for whatever reason only the data file was being backup not the rest of the system....

So, the setup is as follows....

We have a MITEL SX-2000 Light as our PBX and we have an Omnitronix DataLink 880 to pull the CDR data from the PBX.

The Omnitronix is setup to FTP push data to an FTP server I setup. The data is pushed every 2 minutes and appended to the data file.

I have an Access Database I created that is linked to the Data file. I've created all the queries, forms and reports and everything is working decent at the moment, but we do have 1 problem.

I'm guessing on half of the fields as to what they are! So this is making my queries a bit limited....

I've got date, time, duration, Internal Source, Outside Source and Outside Destinations correct (I think).

But there are a few fields that I'm not sure of (maybe transfers, conference call or something else).
0
Comment
Question by:Luke92881
2 Comments
 
LVL 25

Accepted Solution

by:
kode99 earned 500 total points
ID: 20399398
Dug up this incomplete field list from some Mitel non-technical docs,

 - Date
 - Start Time
 - Duration of Call
 - Calling Party
 - Time to Answer
 - Digits Dialed
 - Call Completion Status
 - Called Party
 - Transfer/Conference Call
 - Third Party
 - Account Code
 - Call Identifier
 - Call Sequence Identifier

There is a manual that details all the data you get but unfortunatly it is only available to developers registered with Mitel.  Its called 'Data Interfaces Specification Programmer Reference'.

Here's a link to the program if you want to check into it,

http://www.mitel.com/DocController?documentId=9971

I went down this road with Nortel some  time ago and it just wasn't worth it unless you were developing a commercial product.  I do not know the details of Mitels requirments maybe they are not so bad.

There is also a Mitel users group which might be helpful as I doubt you are the only one looking for this information.

http://www.mitel.com/DocController?documentId=10165

They may also provide the CDR information through tech support.  Probably worth a try if you have not asked.
0
 
LVL 3

Author Comment

by:Luke92881
ID: 20402436
I just happen to have the number of fields imported that you have listed and some of them I had already figured out just by looking at them.... Looks like that is the list I need! I don't think it is in that exact order but I think I can figure it out from here.

Thank you!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wanted to query Cisco Call Manager CDR records from MS SQL Server? Here's how! CUCM can be configured to upload a CDR file to a given FTP server every minute. This article will show you how to set this up, schedule the import of this data an…
There are no good configuration guides for HP-H3C router to LYNC on the web. :( Big statement, but we havent been able to find one yet. We did find the following document useful, but the information was not enough to use H3C router for use as a L…
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…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

809 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