Solved

Capturing SMDR data over serial port in excel

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

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…
Implementing Avaya's One-X portal is pretty painless, until you want to deploy this to the Android and iPhone clients when these clients are outside of your network. The clients will also work within your local network. Here is our experience and so…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

867 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now