mrfactorytalknovice

Hello I am using codesys v3.5. I am using the CAA File library to read/write lines of text from a file stored on my Festo PLC. I have found out how to read 1 line of text from my text file. But how do I read the next set of lines within the text file separately until the end of file is reached? Example: Read line 1 Read line 2 Read line 3 Read line 4 End of File I know I would normally put the code in a "Repeat" loop until end of file ...but what should the code look like to read all lines until all lines have been read or End of File? thanks Jay

Hello All This is my first Transaction Manager project. I have a working configuration in Transaction Manager 10.20 that successfully writes PLC Data to an SQL 2012 Management Studio DB based upon a trigger event. The only problem I'm having is with writing String Datatypes to my SQL DB. For example, I have a "Serial Number" that is a string variable in my Allen Bradley ControlLogix PLC. In turn, I have the "SerialNumber" field configured in a SQL table as varchar(length 14). The Transaction Manager connector only shows SerialNumber PLC tag as Data[0] thru Data[13] under Data Points. In Transaction Manager I entered 14 in the "Elements" column for Serial Number. I assumed that would be Data[0]..Data[13] But when I trigger my transaction, the SQL Database field for SerialNumber is a value of "11"...which is the string.LEN property, (current string length of Serial Number is 11). How do I configure Transaction Manager to write the actual ascii value for the SerialNumber string to my SQL database instead of the string length? thanks Jay

Hello All This is my first Transaction Manager project. I have a working configuration in Transaction Manager 10.20 that successfully writes PLC Data to an SQL 2012 Management Studio DB based upon a trigger event. The only problem I'm having is with writing String Datatypes to my SQL DB. For example, I have a "Serial Number" that is a string variable in my Allen Bradley ControlLogix PLC. In turn, I have the "SerialNumber" field configured in a SQL table as varchar(length 14). The Transaction Manager connector only shows SerialNumber PLC tag as Data[0] thru Data[13] under Data Points. In Transaction Manager I entered 14 in the "Elements" column for Serial Number. I assumed that would be Data[0]..Data[13] But when I trigger my transaction, the SQL Database field for SerialNumber is a value of "11"...which is the string.LEN property, (current string length of Serial Number is 11). How do I configure Transaction Manager to write the actual ascii value for the SerialNumber string to my SQL database instead of the string length? thanks Jay