Closed

Comport datastream to sql database

We need a simple C/C++ program that can read and write a text formatted ascii datastream from/to a serial communication port and a sql database.

The serial port can be either a physical port or a virtual serial port( for usb/serial converters)

The datastream is human readable in form of ascii characters.

The datastream contains a start and stop token.

The program shall read a text file at startup and this text file will tell the program the ip address of the (my)sql server, the username, database name and the table name to be used. There are two tables initially. One for read and one for write.

Incoming communication from the serial port shall be placed in the table at the end of the table.

The program shall monitor the outgoing table and if a new port is detected the data in this post shall be written to the serial port according to the prescribed format.

The program does not need to create the tables or manage the tables in any way. For incoming data the program assumes that the fields exist. For outgoing data, the program shall use the field list in the init-file ( same file that describe ip-address, username etc.)

The data flowing to/from the serial port shall always be of the format:

STARTDATA <field name1> <data1> <field name2> <data2> ...<field name n> <data n> ENDDATA

Skills: C Programming, Data Processing, Engineering

See more: sql contains datastream, sql database program, simple file database, my sql create database, comport sql database, comport sql, comport formatted text, SQL, sql data, sql c, serial port , serial communication, ip monitor, database sql, communication port, read usb serial port, simple sql program, virtual usb serial, usb data read program, physical token, serial read file, simple program database, text sql, create usb, database processing

About the Employer:
( 1 review ) Drammen, Norway

Project ID: #242888