Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
7
Erster Beitrag:
vor 4 Jahren, 8 Monaten
Letzter Beitrag:
vor 4 Jahren, 8 Monaten
Beteiligte Autoren:
Steven Sitas, Nick Martin, Hartyshow, Ken Lossman.pcs.crosspost

WinDEV 17 - connecting to analyzers (ROCHE)

Startbeitrag von Steven Sitas am 02.05.2013 17:40

I have an accounting system that is specially designed for small diagnostic centres.
One of my clients is expanding in other medical/laboratory fields and he is purchasing the following equipment from Roche:
sysmex XS-1000i
cobas interga 400
cobas e411
cobas u411
sysmex XS-1000i

So he asked if I could connect my accounting system - with the above analyzers - so he wouldn't have to use another software (LIMS?) and enter the data twice.

Roche sent me a couple of emulators, but before going on an studying the HL7 standard and (probably) reinventing the wheel, does anybody have in mind any product or code that I could use with my WinDEV17 apps?

Ideas welcomed

Antworten:

Hey Steven, I've been writing laboratory instrument interfaces most of my life. Are you wanting to interface via serial port or are you going to use a lantronix device. These instruments you have listed don't natively communicate via hl7. Each one has it's own proprietary protocol. Do you have the specs on each one?

Message forwarded from pcsoft.us.windev

von Ken Lossman.pcs.crosspost - am 03.05.2013 15:08
Hi Ken,
You are right - they have there own protocols called ASTM and COBAS.
I was playing around with an emulation application Roche sent me - it is called Host Interface Test Tools - and since it also had a HL7 mode, I thought that the analyzers also worked with HL7.

Now for the questions.
1) I was thinking of communicating via the Serial port.
Ofcourse since I am no expert here, I would appreciate any advise ..

2) Yes I have the specs for all the analyzers.
I am attaching one of them.
I can send you all the files Roche sent me, since they NEVER said I can't redistribute them :)
[attachment 328 HostInterfaceManualcobasu411.pdf]

von Steven Sitas - am 03.05.2013 15:43
Hi,

We have a solution that connects to laboratory analysers (and have interfaced to several hundred of them). It is a C++ application and we then use WinDev to view the data via a series of forms.

The LabComm software will give you data in one of 4 formats:

a. HL7 files
b. HL7 TCP/IP sockets
c. ODBC via a Postgresql DB
d. Postgresql Foreign data wrapper to write data into another DB (eg My SQL).

HL7 is great if you are familiar with it and have a parser. However, we have found that a lot of people don`t know HL7 and in this case the ODBC access etc offers an easier path. Here is the data from an XT-2000i analyser - similar to one of the ones you listed above.

MSH|^~\&|LabComm^XT-2000i^00-19^13911^^^^01325318^E1394-97|XT20001|||20101028131152||ORU^R01|855|P|2.3|||ER|NE|
PID|1||||||||
OBR|1|||^^^^WBC\^^^^RBC\^^^^HGB\^^^^HCT\^^^^MCV\^^^^MCH\^^^^MCHC\^^^^PLT\^^^^NEUT%\^^^^LYMPH%\^^^^MONO%\^^^^EO%\^^^^BASO%\^^^^NEUT#\^^^^LYMPH#\^^^^MONO#\^^^^EO#\^^^^BASO#\^^^^RDW-SD\^^^^RDW-CV\^^^^PDW\^^^^MPV\^^^^P-LCR\^^^^PCT\^^^^RET%\^^^^RET#\^^^^IRF\^^^^LFR\^^^^MFR\^^^^HFR|||||||||||||||||||||F|
OBX|1|NM|^~WBC|1|6.76|10*3/uL||N||||||20101027112217|||
OBX|2|NM|^~RBC|1|4.33|10*6/uL||N||||||20101027112217|||
OBX|3|NM|^~HGB|1|12.2|g/dL||N||||||20101027112217|||
OBX|4|NM|^~HCT|1|36.6|%||N||||||20101027112217|||
OBX|5|NM|^~MCV|1|84.5|fL||N||||||20101027112217|||
OBX|6|NM|^~MCH|1|28.2|pg||N||||||20101027112217|||
OBX|7|NM|^~MCHC|1|33.3|g/dL||N||||||20101027112217|||
OBX|8|NM|^~PLT|1|212|10*3/uL||N||||||20101027112217|||
OBX|9|NM|^~NEUT%|1|48.4|%||N||||||20101027112217|||
OBX|10|NM|^~LYMPH%|1|31.2|%||N||||||20101027112217|||
OBX|11|NM|^~MONO%|1|10.9|%||N||||||20101027112217|||
OBX|12|NM|^~EO%|1|9.5|%||N||||||20101027112217|||
OBX|13|NM|^~BASO%|1|65.8|%||N||||||20101027112217|||
OBX|14|NM|^~NEUT#|1|3.27|10*3/uL||N||||||20101027112217|||
OBX|15|NM|^~LYMPH#|1|2.11|10*3/uL||N||||||20101027112217|||
OBX|16|NM|^~MONO#|1|0.74|10*3/uL||N||||||20101027112217|||
OBX|17|NM|^~EO#|1|0.64|10*3/uL||N||||||20101027112217|||
OBX|18|NM|^~BASO#|1|4.45|10*3/uL||N||||||20101027112217|||
OBX|19|NM|^~RDW-SD|1|44.6|fL||N||||||20101027112217|||
OBX|20|NM|^~RDW-CV|1|15.0|%||N||||||20101027112217|||
OBX|21|NM|^~PDW|1|8.2|fL||N||||||20101027112217|||
OBX|22|NM|^~MPV|1|9.4|fL||N||||||20101027112217|||
OBX|23|NM|^~P-LCR|1|13.9|%||N||||||20101027112217|||
OBX|24|NM|^~PCT|1|0.20|%||N||||||20101027112217|||
OBX|25|NM|^~RET%|1|2.58|%||N||||||20101027112217|||
OBX|26|NM|^~RET#|1|0.1117|10*6/uL||N||||||20101027112217|||
OBX|27|NM|^~IRF|1|47.1|%||N||||||20101027112217|||
OBX|28|NM|^~LFR|1|52.9|%||N||||||20101027112217|||
OBX|29|NM|^~MFR|1|39.5|%||N||||||20101027112217|||
OBX|30|NM|^~HFR|1|7.6|%||N||||||20101027112217|||
OBX|31|ST|^~SCAT_DIFF|1|PNG&R&20101028&R&2010_10_27_11_22_QC-02410811_DIFF.PNG|||N||||||20101027112217|||
OBX|32|ST|^~SCAT_WBC/BASO|1|PNG&R&20101028&R&2010_10_27_11_22_QC-02410811_WBC_BASO.PNG|||N||||||20101027112217|||
OBX|33|ST|^~SCAT_RET|1|PNG&R&20101028&R&2010_10_27_11_22_QC-02410811_RET.PNG|||N||||||20101027112217|||
OBX|34|ST|^~SCAT_PLT-O|1|PNG&R&20101028&R&2010_10_27_11_22_QC-02410811_PLT_O.PNG|||N||||||20101027112217|||
OBX|35|ST|^~DIST_RBC|1|PNG&R&20101028&R&2010_10_27_11_22_QC-02410811_RBC.PNG|||N||||||20101027112217|||
OBX|36|ST|^~DIST_PLT|1|PNG&R&20101028&R&2010_10_27_11_22_QC-02410811_PLT.PNG|||N||||||20101027112217|||


I`ve attached an HL7 file to this message (which I had to do in RTF format - as one of the file formats that the forum supports) - so you can look at it further

Regards
Nick
[attachment 338 XT20001_RH__000000_2010102847512_00000855.rtf]

von Nick Martin - am 15.05.2013 09:52
Hi Nick,
How much does your product cost ?

von Steven Sitas - am 16.05.2013 09:26
It is not too difficult. This is just a telemetry and decommutation messages.

von Hartyshow - am 16.05.2013 14:07
Steve,

With analyser interface projects there are several things that affect the scope and cost of the project.

a. You can either interface via serial cables or serial to IP converters (which are also called Lantronix or Moxa boxes). The advantage of the serial to IP converters is that the analysers and server don`t need to be close together (indeed we have just interfaced an analyser in Germany to a lab in the UK). If you use serial cables the analysers can`t be more than 10 metres from the server / workstation. The serial to IP converters will add approx $200 - $250 per analyser but also allows the lab to move analysers around

b. Do you know HL7? If you do I can give you data in HL7 files or HL7 sockets.
However, if you don`t, then I would recommend that you get data via ODBC.

c. What database are you using?

d. How are you going to translate the test codes, flags and perhaps the units that the analyser sends?

e. Are you planning bi-directional or mono-directional interfaces? Mono-directional is where you receive data only from the analyser (ie the results and QC data). Bi-directional is where you send the details to the analyser.

If you don`t know HL7 use ODBC. We would setup an ODBC connection between your DB and our Postgresql database.

Also if you go the ODBC route we can translate test codes at the same time. What does this mean? I`ve attached a small pdf file which include some testcodes from the Abbott Architect. The code that the analyser sends is in the parameter column EG ^531~CMV IgG

The other columns are mapped from a table we have created such as CMV IgG (Cytomegalovirus) CMV IgG 6

You would then use the TestID (in this case 6 - an integer you would supply) to map the test back to your LIMS. The Architect codes are fairly easy to view / translate. The Roche/Hitachi cobas e 411 analyser are mainly numbers eg the code for TSH is 10.

Estimated costs are £1800 UK pounds or £1950 UK pounds for each analyser if we use the remote Lantronix connection device. These prices are less than 1/3 of the current costs many labs in the US and UK pay.

As you have several analysers we would include a Windows 2008 R2 or Windows 2012 server in this price... hardware and license. But it sounds like you have a lot of sites and we can negotiate further.

We have spent the best part of 10 years perfecting this solution - it is far from straight forward. Most of the analysers you have listed are bi-directional - so you can send patient demographics and test codes to the analysers as well. In this case we could give you another table to write the data to, if you went the ODBC route. Writing bi-directional interfaces via HL7 is fairly complex, since you would have to do all the test code and unitage translations yourself and even analysers that supposedly use the same protocol often need data in a slightly different format.

Where are the analysers located? If the project were to go ahead would it be possible to have remote access or could we go on site and set everything up (our preferred option)

Nick
[attachment 359 Sampletestcodes.pdf]

von Nick Martin - am 21.05.2013 20:50
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.