logging rs232 data to SQL Server

[gotama]

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

[Arthur Grasin]

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.