So far so good
Everything work fine now , One last question then I will activate it in all my machines

So every time I send the data to the host server it all came out there is erorr detect even if the data is Successful fully received and transferred to MySQL , then the machine stop transferred other data
I attach the error message

Everything is perfectly but there is a problem  I could not find the "SID"

I chose all the options available in the list

This number is very important, determines the sample number

I found new ops in exporting , I will try it , thank you so mush

Do you mean this way

I use "ASCII data duery and parser" module ,
The problem is every time the device sends 3 different messages, I could only pull the "Test Name" , but for the "result" and "ID" every time I fail to extract it

its "ARCHITECT" manufacturer ,I forgot the model number ..

I have a laboratory equipment  that I connected via “TCP/IP” , write data  to a MYSQL database via “SQL Database Pro”
I have a problem extracting the “result” and “test name” of the analysis
Information extracted form equipment like :


SFT|ADD|9.00|ARCHITECT|""
PID|1|||||||U
SPM|1|138_2008B1|||||||||P
SAC||||||||||F231|2
OBR|1|||380&UNDILUTED^SyphilisTP^ARCHITECT|||||||||||||||||||||F
TQ1|1||||||||R
OBX|1|ST|380&UNDILUTED&F^SyphilisTP^ARCHITECT||0.07|S/CO^^ARCHITECT|||||F|||||ADMIN~ADMIN||i1SR54945&1~57613|20200817180535
SID|380&1&SR|10028BE00|08831
ZCL|380^SyphilisTP^ARCHITECT|10028BE00|20200603193056
OBX|2|NM|380&UNDILUTED&P^SyphilisTP^ARCHITECT||1320|RLU^^ARCHITECT|||||F|||||ADMIN~ADMIN||i1SR54945&1~57613|20200817180535
OBX|3|ST|380&UNDILUTED&I^SyphilisTP^ARCHITECT||Nonreactive||||||F|||||ADMIN~ADMIN||i1SR54945&1~57613|20200817180535