Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Capturing CDR from PBX

Posted on 2007-11-30
2
Medium Priority
?
1,058 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 2000 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

So you think no one can listen in on your VOIP conversations, eh? Well... if you haven't setup Secure Real Time Transport (SRTP), your voice communications can be hacked into by just about anyone! First, let's talk about the intended audience for…
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…
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…
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…
Suggested Courses

886 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