Solved

Capturing CDR from PBX

Posted on 2007-11-30
2
1,051 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Let’s list some of the technologies that enable smooth teleworking. 
Outsource Your Fax Infrastructure to the Cloud (And come out looking like an IT Hero!) Relative to the many demands on today’s IT teams, spending capital, time and resources to maintain physical fax servers and infrastructure is not a high priority.
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, fr…

734 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