Solved

Capturing SMDR data over serial port in excel

Posted on 2013-06-12
2
910 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 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