web stats
Database reader - XML to HL7 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2008, 10:09 AM
afterdark23 afterdark23 is offline
OBX.2 Kenobi
 
Join Date: Oct 2007
Posts: 66
afterdark23
Default Database reader - XML to HL7

I have a database table that stores HL7 format transaction. I would like to query that database and send those transactions to a file writer connection.

I can read the database fine, however when I try to write the result to a file, the encoded message contains "message" before the MSH segment in each record.
IE: messageMSH

Is there a reason that message appears at the beginning of each record? How can I fix this?
__________________
Reid Hospital and Healthcare
Reply With Quote
  #2  
Old 01-27-2012, 07:06 AM
robbinsc robbinsc is offline
Mirth Newb
 
Join Date: Dec 2011
Posts: 8
robbinsc is on a distinguished road
Default

I am currently have this same situation. I have tried a few mapper steps without success.

What was your resolution?

Thanks
Reply With Quote
  #3  
Old 01-27-2012, 09:06 AM
geraldb geraldb is offline
Mirth Employee
 
Join Date: Aug 2006
Location: Irvine, CA
Posts: 314
geraldb is an unknown quantity at this point
Default

Which variable are you using to output the encoded message in the File Writer?
__________________
Gerald Bortis | Chief Information Officer | Mirth Corporation
Reply With Quote
  #4  
Old 01-30-2012, 08:41 AM
robbinsc robbinsc is offline
Mirth Newb
 
Join Date: Dec 2011
Posts: 8
robbinsc is on a distinguished road
Default

Gerald - Thanks for the response. Here is my current workflow (I have removed all mappings and transformations for step three - DB Reader to File Writer).

1. HL7 messages are written to DB via destination DB Writer.
2. SQL logic to update and correlate order numbers, etc.
3. Based upon criteria, HL7 messages are selected from DB and sent to a file writer. This is where I see the extra data in the message. The files that are written (encoded data template) have the 'tablename_columnname' prefixed to the message:

resultaccession_export_filler_documentMSH|^~\&|OAD D|116|DADD|.......

Thanks
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
Database Writer / Database Reader problem tadigiri Support 3 03-26-2012 12:26 PM
Database reader and database writer Vgupta Development 0 12-03-2007 11:41 AM
Channel as Database reader and Database writer Alexander Development 0 10-24-2007 08:24 PM
Problem with Database Reader (SQL) jhon Support 5 09-06-2007 08:04 AM
Database Reader to LLP Sender extrarice Support 0 07-16-2007 03:20 AM


All times are GMT -8. The time now is 10:48 PM.


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