| |||||||||
 |
| ||||||||
| |||||||||||||||
| |||||||||||||||
| Inter-Tel Ask Questions and Find Answers on Inter-Tel systems: |
| Tags: 5000, cdr, intertel, pbx, smdr |
 |
| | LinkBack | Thread Tools | Display Modes |
| |||||||||
|
| ||||||||
| |||||||||||||||
| |||||||||||||||
| Inter-Tel Ask Questions and Find Answers on Inter-Tel systems: |
| Tags: 5000, cdr, intertel, pbx, smdr |
|
| | LinkBack | Thread Tools | Display Modes |
 11-13-2007, 03:23 PM | #1 (permalink) | ||||||||
| Junior Member
Rep Power: 0  Country:  |  How do I export raw SMDR data into SQL on Inter-tel 5000? Our company is upgrading from Inter-tel Axxess to the 5000. The problem is the 5000 no longer supports serial communication. We currently use a program called Serial Logger Service (you can Google for that if you want to see it) to capture data in real time over the serial port and export each SMDR line into a SQL database via an ODBC connection as well as create a text log file. This was an inexpensive program that was designed to do nothing else but this. We already have our own custom in-house call accounting application so we don't to buy software to do anything else except export the SMDR to a database. Unfortunately we have not yet found any similar software to export SMDR logs out of an IP-based PBX system into a database. The closest I found was one that will create a text file of the logs, but not send it to a database. Does anyone have any suggestions on a piece of software to use or any other alternatives? We have also considered finding an application that could export the IP data to a virtual serial port, after which our current logger can take over. Unfortunately most applications only seem to convert data from serial to IP, not the other way around. One potential one we tested simply didn't seem to work correctly at all. Any help would be appreciated. | ||||||||
 |   |
| 11-22-2007, 03:10 PM | #2 (permalink) | |||||||||
| Moderator   ITEngineer is Not ready for Winter
Rep Power: 4 Gender:  Country: | You can capture the SMDR to any PC with a terminal program using IP, just set it up and capture the SMDR. Quote:
__________________ Life is a highway.... | |||||||||
| | |
| 11-24-2007, 10:25 PM | #3 (permalink) | ||||||||
| Junior Member
Location: Upstate New York Rep Power: 0 Gender: Country: | I think the easiest way for you to accomplish your goal is to use the diagnostic monitor software inter-tel provides for the 5000. It can capture smdr data to a log file. If you have an in house developer, you could have him code a job to bulk import the logfile a set intervals. This should take a code pounder about 10 minutes to code. You can also bulk import a flat logfile into SQL with the bcp command line utility or the import wizard in SQL management studio (I am assumming microsoft SQL). If not using the diagnostic monitor you can use a terminal program but the 5000 requires a certain hand shake before transmitting smdr, "#0#0#0#32" as I recall. I will look have to check my notes for that. Last edited by woody; 11-24-2007 at 10:33 PM. | ||||||||
| | |
| 11-28-2007, 01:36 PM | #4 (permalink) | ||||||||
| Junior Member 
Rep Power: 3 Country: | SMDR via Serial This has been a thorn in my side for a long time now. Yes Woody is correct that there needs to be a log in string that is send in hex format. I like Woody's idea with the SQL. I myself have been working on getting the data out of the 5000 with out using the Diagnostics Monitor. The issue with the Diag. Monitor is that a Text file can only log so much, especialy on a busy system. Plus it doesn't have the ability to save itself after it reaches a set size and then rename the file so it can continue on with more data. The same concept as the Legacy VPU's message file (log, log1, log2, log3, etc....) I think JudgeMan has the same goal in mind. We need the ability to capture the SMDR data via IP and have a program on windows spool it to a buffer, archived log file or sent to a real-time stream (virtual serial port). I have some information that I will add below. Please let me know if there is anything I can do to help. .....and please anyone that can make this work to a serial output, don't be shy..... Hopefully the moderator that has "all 32 Inter-Tel certs" can help out on this one. If not I'm going to sick Jacob and Charlie on him. LOL | ||||||||
| | |
| 11-29-2007, 03:47 PM | #5 (permalink) | ||||||||
| Junior Member
Rep Power: 0 Country: | SMDR to Serial Am some what new to this, but will tell you where I have gotten so far. We have 16 sites on axxess systems. All smdr info had to get back to a serial port on the mainframe. I use "etherpaths" from dcbnet.com to accomplish this. I feed the serial to the serial side of the etherpath. patch ethernet side into lan, transmit over f/r wan. Use second etherpath,at hq, pull serial off and connect to serial port on mainframe controller. I can control the i.p. the etherpath connects to and the port, and of course all serial is configurable. This company just bought another dealership, and now has a inter-tel 5000 system. I'm currently working with Md. Tel. to see if I can send a login string from the etherpath to the switch and have it stream serial. Will update if I find out anything more. | ||||||||
| | |
| 12-26-2007, 03:34 PM | #6 (permalink) | ||||||||
| Junior Member
Location: Arizona Rep Power: 0 Gender: Country: | Accessing SMDR via IP I wrote a program to access SMDR via IP on an Inter-Tel 5000 or Axxess. I've been working with the person that initiated this thread, Judgeman, to get this working. Thanks to Judgeman's help in testing/debugging, I'm ready to make this available to anybody that wants it. Here's some background: (I've edited the text below from another e-mail, so hopefully it still makes sense). The situation you are in is not unique. However, it's not common enough for Inter-Tel to want to do anything about it. Instructions for how to access the SMDR stream via IP are free available in the OAI toolkit. You can e-mail developer@inter-tel.com for more information. The idea here is that authors of call accounting software will incorporate this into their package. Unfortunately, this doesn't fit everybody. Some people have home grown solutions, and other have products from companies that don't exist anymore. The frustrating thing for me is that this problem is actually not very difficult to solve. Several months ago, I wrote a Perl script that does exactly what you want. It's called SMDRBridge, and it provides a connection between the IP-based SMDR and a serial port. It optionally logs to a file as well. Somebody has even modified it to deposit each record into a SQL database. As an Inter-Tel (now Mitel) employee, there are some limitations on what I'm allowed to do, but I got specific permission to make this program available. You are welcome to it (free!). If you are a programmer type, you can even get a copy of the source (Perl). The only real gotcha is that it hasn't really been deployed much outside my home lab and a couple of real users. This means that it's not quite perfect, but I think it may be good enough to serve your needs. If you have some patience, I can likely tweak the program to meet your needs in my spare time. I've attached a PDF describing the functionality. If you want more information, send me a personal message. | ||||||||
| | |
| 12-27-2007, 11:50 AM | #8 (permalink) | ||||||||
| Junior Member
Rep Power: 0 Country: |  Yes, thanks to T-Bone we were able to solve our problem. His Perl program reads the Inter-tel SMDR data over IP, exports it to a serial port, and saves it in text logs that rotate into a new file every day. I added a SQL database export to our version of his program using some simple Perl examples online. That's all we really need so we don't have to monitor the serial port at all now. | ||||||||
| | |
| 12-28-2007, 06:45 AM | #9 (permalink) | ||||||||
| Moderator ITEngineer is Not ready for Winter
Rep Power: 4 Gender: Country: | Thanks for the program T-Bone. Let us know how things progress and I am sure many others will be able to use your program. __________________ Life is a highway.... Last edited by ITEngineer; 12-28-2007 at 06:49 AM. | ||||||||
| | |
| 01-28-2008, 06:16 PM | #10 (permalink) | ||||||||
| Junior Member
Location: Richmond, VA Rep Power: 0 Gender: Country: | Inter-Tel SMDR Options All, Just a heads up for you. My company, Scannex, actually manufacture an inexpensive IP buffer device that can connect to the Inter-Tel 5000 and store the SMDR records. The unit can then deliver the records to central software via TCP/IP, FTP Push or even as an Email attachment.  As Woody mentioned the Inter-Tel requires a number of hex characters to "handshake". Our device has this option built into its firmware. A single port device is $895 US list. Storage is 32Mb.  The unit can be seen at our web site. (Sorry cannot post our URL yet - Haven't made 15 posts.  )ip.1-32 Hope this helps. Terry Kelly | ||||||||
| | |
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
 Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Inter-tel 5000 in Singapore | rhill52 | Inter-Tel | 1 | 07-03-2007 06:08 PM |
| Export data from LC-Win (Hicom)?? | chand0x | Siemens / Rolm | 2 | 06-06-2007 04:05 AM |
| Rs232 Data Logger (smdr Caprure) Free www.eltima.com/products/rs232-data-logger/ | jrgmayo | Panasonic | 1 | 06-05-2007 12:17 PM |
| Call Logging data export | goldberg | ALCATEL | 2 | 04-12-2007 06:08 PM |
| SMDR and loss of data | Shooter | BCM and Norstar | 1 | 05-21-2004 04:27 PM |
Linear Mode
