TechSpot

Converting raw data to an access database

By jwr_1986
Jul 5, 2007
Topic Status:
Not open for further replies.
  1. I've realized after looking over a call accounting package, that is as basic as we want it to be, that all they are really doing is taking data off the serial port and putting it into an access database. I tried hyper terminal and sure enough the data comes in beautifully. So now I just need a way to go from that data to an access database and telling it that each column mean this or that. For example the first column is the long call indicator. The next few are the call start time.

    The data is coming out of an old mitel sx-200 from the serial printer port in the rear. It was designed to hook up directly to a printer. If there is a nice little program out there that could do this I'd be very interested. The reason I'm not just buying the commercial software is that it is over $1000 and it really is just displaying the data.

    Thanks for your thoughts.

    Jesse
     
  2. Nodsu

    Nodsu TS Rookie Posts: 9,431

    Well, the software is there, it just costs money :D

    Do you need the data in real time? You could just dump the serial input to a text file and then import from that text file to Access, Excel or whatever.
     
  3. jwr_1986

    jwr_1986 TS Rookie Topic Starter Posts: 58

    The costing money part I understand, it's the costing a really large amount of money for what appears to be little work that bothers me. We don't need real time so the text file might be perfect. I'm not familiar with doing this though so I'd appreciate any information that you could provide. Thanks.

    Jesse
     
  4. jwr_1986

    jwr_1986 TS Rookie Topic Starter Posts: 58

    Ok, a little Googling and a virus scan latter, I found an open source data logger. It is working beautifully so now all I need is a better knowledge of access. That I can manage though. Thanks for your help.

    Jesse
     
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.