Solved

Capturing SMDR data over serial port in excel

Posted on 2013-06-12
2
907 Views
Last Modified: 2013-07-01
We just had an SMDR card installed on our Toshiba Strata CIX100 system. I can see the raw output information in hyper terminal. This was as far as our tech would take it. It is now my responsibility to get this information into some sort of database. Since we just need to see the information I figured putting it in an excel spreadsheet would be the easiest to do this.

Is there a way to capture this data in an excel spreadsheet that doesn't involve purchasing PBX software. Since we just need the data and don't need to do any reporting I figure there has to be a free solution somewhere.
0
Comment
Question by:nirsait
2 Comments
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 39249434
You could attach a resource to a serial port and read the data and then act on it.
What systems do you have (Linux?)
Are you good with scripting in Linux perl that attaches to the serial port into which smdr data is streamed.
vbscript, powershell on a windows system that can be attached to a serial port.

Example/discussion
http://windows7themes.net/connecting-to-com-serial-port-via-powershell.html
http://blogs.msdn.com/b/powershell/archive/2006/08/31/writing-and-reading-info-from-serial-ports.aspx

You can then have powershell process the data into a DB.
Excel file can become large or require file management as part of the processing.

Usually a vendor provides for a way to access smdr data.
0
 

Author Comment

by:nirsait
ID: 39290621
Not what I was looking for but I found a program that I am working with trying to get the correct data out.
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…
Almost all Internet protocol telephones have built-in switches at the back that allow you to connect your personal computer to one port and use the other port to connect your phone to to a Cisco switch.   Why we need to connect the PC to the pho…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

821 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