AGG Software Forums

Online Help Center => Data loggers and plug-ins => Topic started by: gotama on March 03, 2015, 12:32:11 PM



Title: logging rs232 data to SQL Server
Post by: gotama on March 03, 2015, 12:32:11 PM
Hi all, I have a weighbridge terminal which logs rs232 data to a text file using hyperterminal. Instead, I need to collect the rs232 data to SQL server in real-time. I am currently trying out the trial software Advanced Serial Data Logger with the SQL module, because it seems to have all the tools required.

Does anyone have a procedure, tutorial or some basic steps I need to do to setup the AGG software and collect rs232 data to an SQL database in real-time ?

Here are the fields I have in the SQL database:
Date, Time, RCD_code, customer, Name, product, description, Plate_no, Document_no, Tare, Gross, Net

If it helps, I Attached a sample of the text file with rs232 data which is sent to the text file. This data I need to send to SQL.   

Any help would be greatly appreciated  :)


Kristian Cachia




Title: Re: logging rs232 data to SQL Server
Post by: Arthur Grasin on March 03, 2015, 12:50:33 PM
Hello, Kristian.

Please, look here:
http://www.aggsoft.com/serial-data-logger/tutorials.htm

Your data is at fixed positions. Therefore you should use this parsing method in our ASCII Data Parser.