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. |