web stats
Questions about new implementation - Mirth Community

Go Back   Mirth Community > Mirth Connect > General Discussion

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2007, 09:50 AM
hsingh00 hsingh00 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 31
hsingh00
Default Questions about new implementation

Hey guys. I have a couple of questions dealing with a new implementation that I'm going to try. I'm pretty new to the HL7 world so please forgive me if I use the wrong jargon.

Step 1

I have a server that is running a application (lets call it XYZ) that collects Patient Demographics and converts them into H7L messages and vise versa. I will install Mirth and MS SQL express on to this same server. I'm going to setup a Listener to a ADT feed and save it into a database.

Step 2

I need to take a HL7 query from XYZ and search the database for that patient. If the patient is found then I want to send XYZ a "update demographics" HL7 message. If its not found, I want to sent XYZ a "patient not found" message.

Question is how do I implement Step 2? I have to receive and transmit the HL7 messages to XYZ via LLP. Is it possible to send a reply using one connection using Java script? or do I need to save results to a file and then set up another connection to send results from that file? or can I send it from socket to socket?

Thanks in advance!!
Reply With Quote
  #2  
Old 05-27-2007, 05:30 PM
albertosaez albertosaez is offline
 
Join Date: Sep 2006
Location: Valladolid, Spain
Posts: 842
albertosaez is an unknown quantity at this point
Default Re:Questions about new implementation

Yes, you can:

http://www.mirthproject.org/index.ph...d=2399&catid=2
Reply With Quote
  #3  
Old 05-31-2007, 01:03 PM
hsingh00 hsingh00 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 31
hsingh00
Default Re:Questions about new implementation

I finally started on this project. I got the database up and running with Mirth. I've got this javascript code in a filter right now:

Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:«»sqlserver://127.0.0.1:1433/ADT_DB','sa','password');
var PatID = msg['PID']['PID.3']['PID.3.1'].toString();
var expression = "INSERT INTO [ADT_DB].[dbo].[patient_data]([PatientID],[HL7String]) VALUES(('"+PatID+"'),('"+PatID+"'))";
var result = dbConn.executeUpdate(expression);
dbConn.close();
return true;
I need to map the Raw Data to the HL7 column. Right now I just have PatID going to both and that works. How do I map the Raw data to HL7Message? I tried the following but it did not work.

Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:«»sqlserver://127.0.0.1:1433/ADT_DB','sa','laurabeth');
var PatID = msg['PID']['PID.3']['PID.3.1'].toString();
var HL7Message = ${message.rawData};
var expression = "INSERT INTO [ADT_DB].[dbo].[patient_data]([PatientID],[HL7String]) VALUES(('"+PatID+"'),('"+HL7Message+"'))";
var result = dbConn.executeUpdate(expression);
dbConn.close();
return true;
Thanks guys.
Reply With Quote
  #4  
Old 05-31-2007, 02:35 PM
hsingh00 hsingh00 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 31
hsingh00
Default Re:Questions about new implementation

Never mind guys...this works well for now:

Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:«»sqlserver://127.0.0.1:1433/ADT_DB','sa','password');
var PatID = msg['PID']['PID.3']['PID.3.1'].toString();
var HL7Message = messageObject.getRawData();
var expression = "INSERT INTO [ADT_DB].[dbo].[patient_data]([PatientID],[HL7String]) VALUES(('"+PatID+"'),('"+HL7Message+"'))";
var result = dbConn.executeUpdate(expression);
dbConn.close();
return true;
Post edited by: hsingh00, at: 05/31/2007 15:38
Reply With Quote
  #5  
Old 06-05-2007, 02:50 PM
hsingh00 hsingh00 is offline
OBX.1 Kenobi
 
Join Date: Mar 2007
Posts: 31
hsingh00
Default Re:Questions about new implementation

Ok guys I have new questions. I going to receive a QRY^A19 HL7 messages from a LLP connection like the one shown below.

Code:
MSH|^~\\&|^^DSCP Gateway|^^Hospital1|^^HIS System|^^Hospital2|20070322091718+0000||QRY^A19|4|D|2.3|4.000000|
QRD|20070322091718+0000|D|D|S303852X|||1.000000^&RD|300487|^DEM|^DSCP Gateway|
I then need to Grab the Patient ID from this QRY^A19, in this case 300487, and find the associated ADT HL7 message in a database that I have created. The database has two columns, 1st being "PatientID" and the 2nd being "HL7Message". After extracting the HL7Message for patient ID 300487 I would have...

Code:
MSH|^~\\&||.|||200511281435||ADT^A08|ADT-GE.1.1265623|P|2.1|
EVN|A08|200511180759|
PID|||300487||PARRISH^WALTER^MARK||19460327|M|||^^^^|||||||||||||||||||
NK1|1|^||^^^^||
PV1|1||ASU||||^^^||||||||||||||||||||||||||||||||||||||||||
DG1|1|||||||||||||
I then want to convert this message into a ADR^A19 to look something like this....

Code:
MSH|^~\\&||IOH|||200611021046||ADR^A19|MONITOR-DS.1.925|D|2.3| 
MSA|AA|1| 
QRD|20061102110928+0000|D|D|S10019BX|||1.000000^&RD|V00000000062^SOMEBODY^PATIENT|APA^DEM|^DSCP Gateway| 
PID|||V00000000062||SOMEBODY^PATIENT||19550612|M|||^^LEBANON^IN^46052^^^^IN011||||||||||||||||||| 
PV1||I|2W^227^A|EL|||RIIJO^Riina^Joseph^^^^MD|||SUR||||PHY|||RIIJO^Riina^Joseph^^^^MD|||BC|||||||||||||||||||||ADM IN|||200610310935|
and sent it via a LLP connection.

Can somebody please explain to me in the most details possible how to implement this? I've been working on this for like 5 days straight now and It's all going over my head unfortunately. Maybe one day I'll become a Mirth Guru too
Reply With Quote
  #6  
Old 12-16-2009, 01:13 AM
praveen222 praveen222 is offline
What's HL7?
 
Join Date: Dec 2009
Posts: 3
praveen222 is on a distinguished road
Default converting in to HL7 messages

hi hsingh00,

I have a similar question like you but we are in starting stage.
I have a server that is running a application that collects Patient Demographics and problem while converting them into HL7 messages. I installed Mirth and MySQL on to this same server.

Questions:

1. How you are converted that information (patient Demographics) in to HL7 messages.
2. please provide us that code or referral documents for converting in to HL7 messages (we used java).
3. Are can we contact any third party for converting (list of third parties for converting this).
4. How can i use mirth or any other to send test order to LIS using LOINC and HL7?
5. We referred neotools and other sites. Please provide us your valuable information.

Thanks in Advance. Answering this questions is really appreciated.

Regards,

Praveen.
Reply With Quote
  #7  
Old 06-25-2012, 06:54 AM
Dushi Dushi is offline
OBX.1 Kenobi
 
Join Date: Feb 2012
Posts: 26
Dushi is on a distinguished road
Default

I guess you guys have implemented this successfully? I am doing exact one. Please guide me on how you did this?

Thank you much.
Reply With Quote
  #8  
Old 02-23-2015, 07:58 PM
totalsyapa totalsyapa is offline
What's HL7?
 
Join Date: Feb 2015
Posts: 1
totalsyapa is on a distinguished road
Default

Hello.

Could somebody tell me where I can find a sample HL7 v2.6 report segment?
_____________________
We are the pioneers in providing Testking security plus certification cost toefl and with 100% exam pass Download ccna 200-101 certification exam our latest passguidegmat and pittstate.edu ccna or pass real exam

Last edited by totalsyapa; 03-06-2015 at 12:38 AM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
A few quick questions gilbe006 General Discussion 2 09-03-2008 09:34 AM
General Questions plummers General Discussion 2 08-14-2008 11:25 AM
What's an "implementation guide"? justinwi General Discussion 5 04-26-2007 12:06 PM
Channel Questions marchias Support 1 04-23-2007 05:33 PM
Implementation Ideas arunpriya Development 2 11-06-2006 10:15 AM


All times are GMT -8. The time now is 06:35 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation