Solved

Capturing CDR from PBX

Posted on 2007-11-30
2
1,048 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Suggested Solutions

Title # Comments Views Activity
NBX V3000 Flashing Red Lights - What does this mean 5 69
Issues Recreating DHCP Scope 10 78
facetime for android 4 85
Setting up a Good IVR 2 45
The Zaptel people (www.zaptel.com) got kind of annoyed with the fact that they were getting bombarded with searches for the zaptel driver system for Asterisk (not to mention they own the trademark on zaptel). So, they kindly requested that Digium ch…
What do we know about Legacy Video Conferencing? - Full IT support needed! - Complicated systems at outrageous prices! - Intense training required! Highfive believes we need to embrace a new alternative.
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…
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…

839 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