Getting input serial data directly into a an app

Wireless & IoT
1

I’m needing to get input serial data directly into a an application like Excel or mysql.

There is software like “http://www.superlogics.com/specpage.asp?Items=1004” or “http://www.taltech.com/products/winwedge.html” that would work but the price of the software is a bit high

for this current project.

Anyone know of any freeware out there for the windows os

to input serial data into win apps without using expensive OTS software? Roll your own VB or C samples out there to do this?

2

Save the data to a file and read that into the application. Not as neat but easy to implement. Time-stamping the data will help.

Leon

3

archendekta:
I’m needing to get input serial data directly into a an application like Excel or mysql.

Checkout Windmill

http://www.windmill.co.uk/newsletter.html

The DAQ software is free to a point (you have to sign up to the newsletter) there is a lot of advice about getting serial input to Exel etc.

Regards

Dez Ellis

4

It sounds like you need a program that monitors the serial port, formats the data, and writes a data file that can be read by Excel. One of the easiest paths is to create a comma delimited or comma separated value (CSV) file. These files can be directly opened by Excel and be imported into MySQL. A lot depends upon the nature of the serial data, but it isn’t hard to write a small program to do this. I’ve seen or written similar programs in C++, Java, Liberty BASIC, and PERL.

5

You might find this helpful:

http://www.theabramgroup.com/basicstamp/

It’s mainly for communicating with Basic STAMPS, but it does explain how to use the free VB5 to read a serial port.

6

Thanks sylvie369 & dez.ellis, just what I’m looking for I believe. Appreciate the other suggestions too, and will put them in me toolbox too.

7

Another suggestion. Format your output as CSV. I do this with robotic telemetry and capture the output to file using hyper terminal. Then just open with Excel or OpenOffice.

Alternatively, there are free libs and compilers for C and Java.

FWIW,

Jay

8

Leon & Jay, thanks. I’ll try your suggestions too, it will make for a good practice & tool.

9

Labview can do this I believe.

Bryan