Mirth (was Re: Lab importing Re: [Gnumed-devel] Bootstrap of (test) lab data)

[James Busser]

On 18-Jan-08, at 3:42 PM, Karsten Hilbert wrote:

> > Have a look at Mirth - http://www.mirthproject.org/ - which can be
> > scripted in Java or Python and which can interface directly to  
> > database
> > back-ends or via various APIs or Web service interfaces. Might be  
> > easier
> > than re-inventing all this within GNUmed
> I fully agree. For importing of lab data we should be using Mirth  
> to parse sources into our database. That would be another helpful  
> thing the Java person could do for us - setup Mirth to parse your  
> HL7 input which will show us where the GNUmed backend lacks fields  
> to support the incoming data. I would see to it that the necessary  
> fields are added. We would then write a fairly simple grid-based  
> viewer as a first iteration.

Well, this is promising :-)

My lab test data broker provided a sample XML file and after I  
removed the XML wrapper lines and (fortunately by comparison to  
Mirth's sample message) identified that the backslash in the first  
few characters of the message (my broker uses one before the "&" as  
in "^~\&") I was able to paste  into the Mirth "test drive" the  
following message... the test drive sends an email message  
(unencrypted in this demo but that is ok for test purposes) ... text  
of that email is appended and includes a link to a PDF generated by  
Mirth:

MSH|^~&|PATHL7|MDS|HTTPCLIENT|vendor1|20050628135752||ORU^R01| 
MDC20050628135752051|P|2.3|||ER|AL
PID|||||EXCELLERIS^APATIENT||19770726|M|||260-4400 DOMI AVENUE\.br 
\COQUITLAM\.br\BC\.br\||(604)999-9999
ORC|RE||05-994065004-RBS-1|||||||||90909^MDCARE^BOB
OBR|1||05-994065004-RBS-1|RBS^Glucose Random||20050506135300| 
20050506135300|||||||20050506135300||90909^MDCARE^BOB|||||| 
20050512094510||CHEM|F|||90909^MDCARE^BOB
NTE|||ATE 1330 LAB 1350
OBX|1|ST|14749-6^Glucose Random||4.5|mmol/L|3.3-11.0|N|||F||| 
20050512094510
ORC|RE||05-994065004-RBS-2|||||||||90909^MDCARE^BOB
OBR|2||05-994065004-RBS-2|RBS^Glucose Random||20050506135300| 
20050506135300|||||||20050506135300||90909^MDCARE^BOB|||||| 
20050512094510||CHEM|F|||90909^MDCARE^BOB
NTE|||ATE 0800 LAB 1000
OBX|1|ST|14749-6^Glucose Random||7.5|mmol/L|3.3-11.0|N|||F||| 
20050512094510
ORC|RE||05-994065004-LYTE-1|||||||||90909^MDCARE^BOB
OBR|3||05-994065004-LYTE-1|LYTE^Electrolytes||20050506135300| 
20050506135300|||||||20050506135300||90909^MDCARE^BOB|||||| 
20050512094510||CHEM|F|||90909^MDCARE^BOB
OBX|1|ST|2951-2^Sodium||145|mmol/L|134-145|N|||F|||20050512094510
OBX|2|ST|2823-3^Potassium||4.5|mmol/L|3.5-5.0|N|||F|||20050512094510
ORC|RE||05-994065004-ENA-1|||||||||90909^MDCARE^BOB
OBR|4||05-994065004-ENA-1|ENA^ENA Antibodies||20050506135300| 
20050506135300|||||||20050506135300||90909^MDCARE^BOB|||||| 
20050512094510||CHEM|F|||90909^MDCARE^BOB
OBX|1|FT|5356-1^Sm||WEAK POSITIVE\.br\||||||F|||20050512094510
OBX|2|ST|5301-7^RNP||NEG||||||F|||20050512094510
OBX|3|ST|5351-2^SSA||NEG||||||F|||20050512094510

=============================================
Here's the email text:
=============================================

The HL7 message you submitted to the WebReach website has been  
processed by Mirth.  This is just a simple example of what you can do  
with Mirth.  For more information visit http://www.mirthproject.org  
or e-mail address@hidden to contact the WebReach Mirth Team.

PID SEGMENT INFORMATION
Patient ID:
First Name: APATIENT
Last Name: EXCELLERIS
Gender: M
Address: 260-4400 DOMI AVENUE\.br\COQUITLAM\.br\BC\.br\
City:
State:
Zip Code:
Social Security Number:
Phone Number: (604)999-9999
Birth Date: 19770726

PV1 SEGMENT INFORMATION
Patient Class:
Admission Type:
Attending Doctor:
Admit Source ID:
Hospital Service:
Referring Doctor:
Servicing Facility:
Time of Visit:

The following is a link to the PDF that was generated: http:// 
www.webreachinc.com/mirth_outbox/demo-20080118190534-655.pdf