Capturing SMDR data over serial port in excel

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.
nirsaitAsked:
Who is Participating?
 
arnoldConnect With a Mentor Commented:
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
 
nirsaitAuthor Commented:
Not what I was looking for but I found a program that I am working with trying to get the correct data out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.