laboratory equipment via TCP/IP

[All3ssaf]

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

[Arthur Grasin]

Hello,

Could you specify a manufacturer and model name of this equipment?

[All3ssaf]

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

[Arthur Grasin]

It looks like HL7 data. Do you use the corresponding parser module?

[All3ssaf]

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

[Arthur Grasin]

Please, install the following plugin:
https://www.aggsoft.com/download/binparsers.exe

It adds the "HL7" parser. Please, select it. It does not require configuration.

[All3ssaf]

Do you mean this way

[Arthur Grasin]

Select "HL7" as the parser module too.

[All3ssaf]

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

[All3ssaf]

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

[Arthur Grasin]

Currently, the logger does not process that record.

[All3ssaf]

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

[Arthur Grasin]

You should disable acknowledgements in the machine settings.