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
Hello,
Could you specify a manufacturer and model name of this equipment?
its "ARCHITECT" manufacturer ,I forgot the model number :(..
It looks like HL7 data. Do you use the corresponding parser module?
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 :(
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.
Do you mean this way
Select "HL7" as the parser module too.
I found new ops in exporting , I will try it , thank you so mush :)
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
Currently, the logger does not process that record.
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
You should disable acknowledgements in the machine settings.