Aim to create message auto from sequential database then send
Caution , UNDEPLOY the channel after run. else 1) restart mirth will redepoly 2) keep creating file in high speed in your local harddrive. 3) eat up all your harddisk space 4) hang the mirth and no way to delete
ALTER TABLE [PWHOT].[dbo].[sheet1]
ALTER COLUMN patient_key nvarchar(50)
ALTER TABLE dbo.YourTable
ALTER COLUMN YourColumnName BIT
How to change column datatype in SQL database without losing data
Hints: on DB Quere you can remove "[]"
How to use the Mirth Transformer
Hints :
https://www.youtube.com/watch?v=nTAmnfLMO0A
SELECT a.userID, b.usersFirstName, b.usersLastName FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b ON a.userID=b.userID
PHHOT.dbo.sheet1 = [PHHOT].[dbo].[sheet1]
Hints: java.lang.Thread.sleep(5000) on Mirth -> Destinations -> Step
How to create a table from select query result in SQL Server 2008 [duplicate]
Hints : SELECT * INTO NewTable FROM OldTable
Convert XML to HL7 messages using Mirth Connect
Hints :
http://irwinj.blogspot.hk/2008/12/getting-started-with-mirth-part-1.html
HINTS: Trace: • Mirth Connect Introduction and Tutorial
http://wiki.patesco.ca/doku.php?id=hl7:mirth:tutorial
HINTS : https://amarnathks.wordpress.com/tag/mirth-beginner-tutorial/
Enable Run On Update Statement if you wish to update something after reading data from table. Here i have updated the status flag to 1 such that those details will not be read again. You can now see the selected data values in the right side of On Update SQL.
question : Is it possible to configure the File Writer to create a file name based on the PID.2 segment (chart ID) so each patient account would have it's own file for ADT messages?
HINTS:
http://www.mirthproject.org/community/forums/showthread.php?t=11120
Yes, definitely. Extract the PID.2 out into a map variable, and then in the destination settings just drag your map variable into the Filename field
Transformer -> New Step -> Mapper -> change this step to "Channel Global Map"" -> set variable as filenamePatKey , and Mapping as msg['pmhgoodresult_patient_key'].toString()
then
Destination -> file writer -> on right side " Destination Mapping " you can find filenamePatKey you just create
question : mirth database reader endless loop
HINTS : isdone flag on DB for notice