web stats
Database reader - XML to HL7 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 03-26-2008, 10:09 AM
afterdark23 afterdark23 is offline
OBX.2 Kenobi
Join Date: Oct 2007
Posts: 66
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
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

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

What was your resolution?

Reply With Quote
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

Which variable are you using to output the encoded message in the File Writer?
Gerald Bortis | Chief Information Officer | Mirth Corporation
Reply With Quote
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

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|.......

Reply With Quote

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