?
Solved

Capturing SMDR data over serial port in excel

Posted on 2013-06-12
2
Medium Priority
?
937 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 79

Accepted Solution

by:
arnold earned 1000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

How To Create Custom / Distinctive Ring Tones on Polycom Phones Purpose and Overview When creating a custom ring tone, you have simple aspirations: to make your phone cooler than everyone else's. Perhaps you need a louder ringer. Perhaps you w…
I recently purchased a Bluetooth headset called the Music Jogger (model BSH10). The control buttons on it look like this: One of my goals is to use it as the microphone and speakers for Skype calls. In that respect, it works well. However, I …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

770 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