Announcement

**arumpke** · 11-20-2006, 03:47 AM

Re: Building an HL7 message from fields of a database

Anna,
In the File Repository there are several example channels that you can import to see how the mappings can be done. It is really quite simple. Two steps.
1. Use the Tranformer to create steps to map each HL7 field to a variable.
2. In the destination section, insert into your database the variables that were mapped.

Check out the example channels. They really helped me get started.
Good luck!

**anna** · 11-21-2006, 01:42 AM

Re: Building an HL7 message from fields of a database - critical error

managed to create the hl7 message for a bit, but then the channel does not seem to be deployable. I get the following critical error while trying to:

com.webreach.mirth.client.core.ClientException: method failed: HTTP/1.1 500 java%2Ermi%2EUnmarshalException%3A+Error+unmarshal ing+return%3B+nested+exception+is%3A+%0A%09java%2E net%2EMalformedURLException%3A+no+protocol%3A+File s%2FMirth%2F%2E%2Fmirth%2Dserver%2Ejar
com.webreach.mirth.client.core.ServerConnection.ex ecutePostMethod(ServerConnection.java:59)
com.webreach.mirth.client.core.Client.startChannel (Client.java:247)
com.webreach.mirth.client.ui.Frame.doStartAll(Fram e.java:1415)
com.webreach.mirth.client.ui.Frame$24.actionPerfor med(Frame.java:677)
javax.swing.AbstractButton.fireActionPerformed(Unk nown Source)
javax.swing.AbstractButton$Handler.actionPerformed (Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed (Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unk nown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mou seReleased(Unknown Source)
java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent( Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(U nknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unkno wn Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEvent(Unknown Source)
java.awt.EventDispatchThread.pumpOneEventForHierar chy(Unknown Source)
java.awt.EventDispatchThread.pumpEventsForHierarch y(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)

The channel I created seems to be having this problem. Other channels when deployed don't seem to have any problems! any suggestions?

**chrisl** · 11-21-2006, 07:48 PM

Re: Building an HL7 message from fields of a database - Critical Error

Are you using Mirth version 1.2?

**anna** · 11-21-2006, 08:23 PM

Re: Building an HL7 message from fields of a database - Critical Error

Thank you Chris & Arumpke for your response,

About Mirth Version I'm using Version 1.1.0 , Built on August 28, 2006. Do I have to update my mirth version to get the problem sorted out?

**brendanh** · 11-22-2006, 10:41 AM

Re: Building an HL7 message from fields of a database - Critical Error

anna,

Try updating to Mirth 1.2. It will most likely fix this problem.

-Brendan

**anna** · 11-23-2006, 09:05 PM

Re: Building an HL7 message from fields of a database - Critical Error

Chris & Brendan,

Thank you for your response.
I have updated mirth to 1.2. There still seems to be a problem. The error i get is:

org.mozilla.javascript.EcmaError: ReferenceError: "hl7_xml" is not defined. (a23850ac-6ea1-4d5c-8457-581add4d3af6#1)
at org.mozilla.javascript.ScriptRuntime.constructErro r(ScriptRuntime.java:3226)
at org.mozilla.javascript.ScriptRuntime.constructErro r(ScriptRuntime.java:3216)
at org.mozilla.javascript.ScriptRuntime.notFoundError (ScriptRuntime.java:3289)
at org.mozilla.javascript.ScriptRuntime.nameOrFunctio n(ScriptRuntime.java:1633)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRu ntime.java:1572)
at org.mozilla.javascript.gen.c3._c1(a23850ac-6ea1-4d5c-8457-581add4d3af6:1)
at org.mozilla.javascript.gen.c3.call(a23850ac-6ea1-4d5c-8457-581add4d3af6)
at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(OptRuntime.java:106)
at org.mozilla.javascript.gen.c3._c0(a23850ac-6ea1-4d5c-8457-581add4d3af6:1)
at org.mozilla.javascript.gen.c3.call(a23850ac-6ea1-4d5c-8457-581add4d3af6)
at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:337)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:2755)
at org.mozilla.javascript.gen.c3.call(a23850ac-6ea1-4d5c-8457-581add4d3af6)
at org.mozilla.javascript.gen.c3.exec(a23850ac-6ea1-4d5c-8457-581add4d3af6)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.evaluateOutboundTransformerScript( JavaScriptTransformer.java:343)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.doTransform(JavaScriptTransformer. java:178)
at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
at org.mule.providers.file.FileMessageDispatcher.doDi spatch(FileMessageDispatcher.java:68)
at org.mule.providers.AbstractMessageDispatcher$Worke r.run(AbstractMessageDispatcher.java:257)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Thread.java:595)

Any suggesstions?
Anna

**albertosaez** · 11-27-2006, 01:39 PM

Re: Building an HL7 message from fields of a database - Critical Error

This is a different error.

There is a problem with the update from 1.x to 1.2 You need to re-edit all your javascript, because the carriage return are lost.

**anna** · 11-27-2006, 08:40 PM

Re: Building an HL7 message from fields of a database - Critical Error

I uninstalled (UninstallMirth-NT.bat) and reinstalled (InstallMirth-NT.bat) the Mirth setup. Ive been successfully able to deploy inbound channel that picks up HL7 message from a text file and sends it to an external dummy system. When I try to deploy the outbound channel that picks data from a MySQL database and creates a text HL7 message, I get the following error:

Running Java 1.5.0_06 on Windows 2000 (5.0, x86)
ERROR 2006-11-28 10:19:14,046 [Thread-0] org.apache.commons.digester.Digester: E
nd event threw exception
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.commons.beanutils.MethodUtils.invokeMet hod(MethodUtils.jav
a:216)
at org.apache.commons.digester.SetRootRule.end(SetRoo tRule.java:209)
at org.apache.commons.digester.Rule.end(Rule.java:230 )
at org.apache.commons.digester.Digester.endElement(Di gester.java:1130)
at org.apache.xerces.parsers.AbstractSAXParser.endEle ment(Unknown Source
)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanEndElement(
Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl$FragmentContent
Dispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanDocument(Un
known Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse( Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser .parse(Unknown Sour
ce)
at org.apache.commons.digester.Digester.parse(Digeste r.java:1685)
at org.mule.config.builders.AbstractDigesterConfigura tion.process(Abstra
ctDigesterConfiguration.java:119)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXm
lConfigurationBuilder.java:202)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXm
lConfigurationBuilder.java:194)
at com.webreach.mirth.server.Mirth.startMule(Mirth.ja va:131)
at com.webreach.mirth.server.Mirth.restartMule(Mirth. java:117)
at com.webreach.mirth.server.Mirth.run(Mirth.java:98)
Caused by: org.mule.umo.lifecycle.InitialisationException: Initialisation Failur
e: syntax error (26d22426-0eaa-4118-ba2b-a58aa88328be#1)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.ini
tialise(JavaScriptTransformer.java:162)
at org.mule.MuleManager.registerTransformer(MuleManag er.java:564)
... 24 more
Caused by: org.mozilla.javascript.EvaluatorException: syntax error (26d22426-0ea
a-4118-ba2b-a58aa88328be#1)
at org.mozilla.javascript.DefaultErrorReporter.runtim eError(DefaultError
Reporter.java:95)
at org.mozilla.javascript.DefaultErrorReporter.error( DefaultErrorReporte
r.java:82)
at org.mozilla.javascript.Parser.addError(Parser.java :122)
at org.mozilla.javascript.Parser.reportError(Parser.j ava:128)
at org.mozilla.javascript.Parser.primaryExpr(Parser.j ava:2013)
at org.mozilla.javascript.Parser.memberExpr(Parser.ja va:1640)
at org.mozilla.javascript.Parser.unaryExpr(Parser.jav a:1503)
at org.mozilla.javascript.Parser.mulExpr(Parser.java: 1432)
at org.mozilla.javascript.Parser.addExpr(Parser.java: 1413)
at org.mozilla.javascript.Parser.shiftExpr(Parser.jav a:1393)
at org.mozilla.javascript.Parser.relExpr(Parser.java: 1367)
at org.mozilla.javascript.Parser.eqExpr(Parser.java:1 323)
at org.mozilla.javascript.Parser.bitAndExpr(Parser.ja va:1312)
at org.mozilla.javascript.Parser.bitXorExpr(Parser.ja va:1301)
at org.mozilla.javascript.Parser.bitOrExpr(Parser.jav a:1290)
at org.mozilla.javascript.Parser.andExpr(Parser.java: 1278)
at org.mozilla.javascript.Parser.orExpr(Parser.java:1 266)
at org.mozilla.javascript.Parser.condExpr(Parser.java :1249)
at org.mozilla.javascript.Parser.assignExpr(Parser.ja va:1231)
at org.mozilla.javascript.Parser.assignExpr(Parser.ja va:1237)
at org.mozilla.javascript.Parser.expr(Parser.java:122 0)
at org.mozilla.javascript.Parser.statementHelper(Pars er.java:1107)
at org.mozilla.javascript.Parser.statement(Parser.jav a:619)
at org.mozilla.javascript.Parser.parseFunctionBody(Pa rser.java:413)
at org.mozilla.javascript.Parser.function(Parser.java :519)
at org.mozilla.javascript.Parser.parse(Parser.java:34 4)
at org.mozilla.javascript.Parser.parse(Parser.java:28 9)
at org.mozilla.javascript.Context.compileImpl(Context .java:2190)
at org.mozilla.javascript.Context.compileString(Conte xt.java:1284)
at org.mozilla.javascript.Context.compileString(Conte xt.java:1273)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.ini
tialise(JavaScriptTransformer.java:158)
... 25 more
WARN 2006-11-28 10:19:14,093 [Thread-0] com.webreach.mirth.server.Mirth: Error
deploying channels.
org.mule.config.ConfigurationException: Failed to parse configuration resource "
C:\Program Files\Mirth\conf\mule-config.xml" (org.mule.config.ConfigurationExcep
tion)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXm
lConfigurationBuilder.java:196)
at com.webreach.mirth.server.Mirth.startMule(Mirth.ja va:131)
at com.webreach.mirth.server.Mirth.restartMule(Mirth. java:117)
at com.webreach.mirth.server.Mirth.run(Mirth.java:98)
Caused by: org.mule.config.ConfigurationException: Failed to parse configuration
resource "C:\Program Files\Mirth\conf\mule-config.xml"
at org.mule.config.builders.AbstractDigesterConfigura tion.process(Abstra
ctDigesterConfiguration.java:121)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXm
lConfigurationBuilder.java:202)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXm
lConfigurationBuilder.java:194)
... 3 more
Caused by: org.mule.umo.lifecycle.InitialisationException: Initialisation Failur
e: syntax error (26d22426-0eaa-4118-ba2b-a58aa88328be#1)
at org.apache.commons.digester.Digester.createSAXExce ption(Digester.java
:2919)
at org.apache.commons.digester.Digester.createSAXExce ption(Digester.java
:2945)
at org.apache.commons.digester.Digester.endElement(Di gester.java:1133)
at org.apache.xerces.parsers.AbstractSAXParser.endEle ment(Unknown Source
)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanEndElement(
Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl$FragmentContent
Dispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanDocument(Un
known Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse( Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser .parse(Unknown Sour
ce)
at org.apache.commons.digester.Digester.parse(Digeste r.java:1685)
at org.mule.config.builders.AbstractDigesterConfigura tion.process(Abstra
ctDigesterConfiguration.java:119)
... 5 more

I think that it's got to do with the outbound channel's configuration. Any suggestions?

**chrisl** · 11-28-2006, 09:21 AM

Re: Building an HL7 message from fields of a database - Critical Error

It appears that you have a syntax error in your transformer Javascript. Can you post your transformer here?

Thanks,
-Chris

**anna** · 11-28-2006, 08:17 PM

Re: Building an HL7 message from fields of a database - Critical Error

Chris,

I'm posting the contents of the Mirth\conf\mule-config.xml file.. I hope this is what is needed:

- <com.webreach.mirth.model.Transformer>
- <steps>
- <com.webreach.mirth.model.Step>
<sequenceNumber>0</sequenceNumber>
<name>tmp['MSH']['MSH.10']</name>
<script>tmp['MSH']['MSH.10'] = var uuid = UUIDGenerator.getUUID();;</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>var uuid = UUIDGenerator.getUUID();</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['MSH']['MSH.10']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>1</sequenceNumber>
<name>tmp['PID']['PID.2']['CX.1']</name>
<script>tmp['PID']['PID.2']['CX.1'] = msg['pid'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['pid'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.2']['CX.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>2</sequenceNumber>
<name>tmp['PID']['PID.5']['XPN.2']</name>
<script>tmp['PID']['PID.5']['XPN.2'] = msg['name_first'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['name_first'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.5']['XPN.2']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>3</sequenceNumber>
<name>tmp['PID']['PID.5']['XPN.1']</name>
<script>tmp['PID']['PID.5']['XPN.1'] = msg['name_last'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['name_last'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.5']['XPN.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>4</sequenceNumber>
<name>tmp['PID']['PID.7']['TS.1']</name>
<script>tmp['PID']['PID.7']['TS.1'] = msg['date_birth'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['date_birth'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.7']['TS.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>5</sequenceNumber>
<name>tmp['PID']['PID.8']</name>
<script>tmp['PID']['PID.8'] = msg['sex'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['sex'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.8']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>6</sequenceNumber>
<name>tmp['PID']['PID.11']['XAD.1']</name>
<script>tmp['PID']['PID.11']['XAD.1'] = msg['addr_str'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['addr_str'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.11']['XAD.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>7</sequenceNumber>
<name>tmp['PID']['PID.13']['XTN.1']</name>
<script>tmp['PID']['PID.13']['XTN.1'] = msg['phone_1_nr'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['phone_1_nr'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.13']['XTN.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>8</sequenceNumber>
<name>tmp['PID']['PID.14']['XTN.1']</name>
<script>tmp['PID']['PID.14']['XTN.1'] = msg['phone_2_nr'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['phone_2_nr'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.14']['XTN.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>9</sequenceNumber>
<name>tmp['PID']['PID.16']</name>
<script>tmp['PID']['PID.16'] = msg['civil_status'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['civil_status'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.16']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
- <com.webreach.mirth.model.Step>
<sequenceNumber>10</sequenceNumber>
<name>tmp['PID']['PID.19']</name>
<script>tmp['PID']['PID.19'] = msg['pid'].toString();</script>
<type>HL7 Message Builder</type>
- <data class="map">
- <entry>
<string>Mapping</string>
<string>msg['pid'].toString()</string>
</entry>
- <entry>
<string>Variable</string>
<string>tmp['PID']['PID.19']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
</steps>
<template>MSH^~|\&^X-L^Easy B^Vista^Ml^20060602000000+0000^^ADT~A08^1199885497 8^T^2.3^ EVN^A08^20060602163030+0000^ PID^1^645749582^^^SINGH~REETA^^19700606000000+0000 ^F^^^E-18, NPL COLONY, NEW RR NAGAR^^015656549621^789456123258^^NEVER MARRIED^^^741852933^ PV1^1^^DR^^^^~JO~ANNA^~P M~SINGH^ DG1^1^</template>
</com.webreach.mirth.model.Transformer>

Is there anything else I need to post?

Thank you
Anna

**chrisl** · 11-28-2006, 10:55 PM

Re: Building an HL7 message from fields of a database - Critical Error

In your first transformer step you have:

Code:

var uuid = UUIDGenerator.getUUID();

For the mapping. The mapping value can only be a expression that returns a value. Replace that with:

Code:

UUIDGenerator.getUUID()

(Make sure you remove the trailing semi colon)

If you need to use the UUID elsewhere, create a Javascript step that has:

Code:

var uuid = UUIDGenerator.getUUID();

Then elsewhere in the mappings you can simply put

Code:

uuid

**anna** · 11-29-2006, 12:14 AM

Re: Building an HL7 message from fields of a database - Critical Error

Chris, Albertosaez, Arumpke and Brendanh,

Thank you for your timely response and help. Have successfully created the text file with the HL7 message.

Thank you
Anna

**kgk_007** · 03-09-2007, 03:00 AM

Re: Building an HL7 message from fields of a database - Critical Error

Hi,

I am also trying the same task. I find your details very useful. I request you to send your outbound and inbound channel for more clear understanding as I have a problem

1. I am not able to create HL7 message from the mysql datasource.

Here I am attaching my xml file for your reference. Pls help me to move further

<com.webreach.mirth.model.Channel>
<id>934cce1e-7494-46a2-81e3-22b2013f42ae</id>
<name>Test Outbound</name>
<description>line1
line2
line3
</description>
<enabled>true</enabled>
<version>1.3.2</version>
<revision>34</revision>
<direction>OUTBOUND</direction>
<protocol>HL7</protocol>
<mode>ROUTER</mode>
<sourceConnector>
<name>sourceConnector</name>
<properties>
<property name="pollingFrequency">5000</property>
<property name="username">root</property>
<property name="DataType">Database Reader</property>
<property name="useAck">0</property>
<property name="URL">jdbc:mysql://localhost:3306/care2x</property>
<property name="query">select `pid`,`name_first`, `name_last`, `date_birth`,`sex`,`addr_str`,`phone_1_nr`,`phone_ 2_nr`,`civil_status`,`sss_nr` from mirth_person</property>
<property name="password">pixen</property>
<property name="host">query</property>
<property name="driver">com.mysql.jdbc.Driver</property>
<property name="ack"></property>
</properties>
<transformer>
<steps/>
</transformer>
<filter>
<rules/>
</filter>
<transportName>Database Reader</transportName>
</sourceConnector>
<destinationConnectors>
<com.webreach.mirth.model.Connector>
<name>Destination 1</name>
<properties>
<property name="charsetEncoding">DEFAULT_ENCODING</property>
<property name="outputAppend">1</property>
<property name="DataType">File Writer</property>
<property name="outputPattern">OUT${UUID}.txt</property>
<property name="template">ER7: ${HL7 ER7} 
XML: ${HL7 XML}</property>
<property name="host">C:/temp/hl7_output</property>
</properties>
<transformer>
<steps>
<com.webreach.mirth.model.Step>
<sequenceNumber>0</sequenceNumber>
<name>tmp['MSH']['MSH.10']</name>
<script>tmp['MSH']['MSH.10'] = UUIDGenerator.getUUID();;</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>UUIDGenerator.getUUID();</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['MSH']['MSH.10']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>1</sequenceNumber>
<name>tmp['PID']['PID.2']['CX.1']</name>
<script>tmp['PID']['PID.2']['CX.1'] = msg['pid'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['pid'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.2']['CX.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>2</sequenceNumber>
<name>tmp['PID']['PID.5']['XPN.2']</name>
<script>tmp['PID']['PID.5']['XPN.2'] = msg['name_first'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['name_first'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.5']['XPN.2']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>3</sequenceNumber>
<name>tmp['PID']['PID.5']['XPN.1']</name>
<script>tmp['PID']['PID.5']['XPN.1'] = msg['name_last'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['name_last'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.5']['XPN.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>4</sequenceNumber>
<name>tmp['PID']['PID.7']['TS.1']</name>
<script>tmp['PID']['PID.7']['TS.1'] = msg['date_birth'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['date_birth'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.7']['TS.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>5</sequenceNumber>
<name>tmp['PID']['PID.8']</name>
<script>tmp['PID']['PID.8'] = msg['sex'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['sex'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.8']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>6</sequenceNumber>
<name>tmp['PID']['PID.11']['XAD.1']</name>
<script>tmp['PID']['PID.11']['XAD.1'] = msg['addr_str'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['addr_str'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.11']['XAD.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>7</sequenceNumber>
<name>tmp['PID']['PID.13']['XTN.1']</name>
<script>tmp['PID']['PID.13']['XTN.1'] = msg['phone_1_nr'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['phone_1_nr'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.13']['XTN.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>8</sequenceNumber>
<name>tmp['PID']['PID.14']['XTN.1']</name>
<script>tmp['PID']['PID.14']['XTN.1'] = msg['phone_2_nr'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['phone_2_nr'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.14']['XTN.1']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>9</sequenceNumber>
<name>tmp['PID']['PID.16']</name>
<script>tmp['PID']['PID.16'] = msg['civil_status'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['civil_status'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.16']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
<com.webreach.mirth.model.Step>
<sequenceNumber>10</sequenceNumber>
<name>tmp['PID']['PID.19']</name>
<script>tmp['PID']['PID.19'] = msg['sss_nr'].toString();</script>
<type>HL7 Message Builder</type>
<data class="map">
<entry>
<string>Mapping</string>
<string>msg['sss_nr'].toString()</string>
</entry>
<entry>
<string>Variable</string>
<string>tmp['PID']['PID.19']</string>
</entry>
</data>
</com.webreach.mirth.model.Step>
</steps>
<template>MSH|^~\&|Mirth|1|||2006044535||ADT^A 04|603340|D|2.3.1EVN|A04|20060404090742&#x0D ;PID|1|800888^^^Mirth^PN|999945682^^^AccMgr^MR^1|| TEST^PATIENT MF||19570414|M||W|21 PALM MANOR^^EAST SYRACUSE^NY^130570000^^M|31|||E|M||6635130^^^Mirth ^VN^1|000987655|||2|||||NOT A VETERAN|||NPD1||||1335^ALCOTT^KAREN^^^^^^Acc Mgr^^^^CI|||INK1|1|TEST^MARGARET|W|21 PALM MANOR^^EAST SYRACUSE^NY^130570000|||YPV1|1|E|ED^^^1|1||| 1281^MARKHAM^JOSEPH^^^^^^AccMgr^^^^CI|1281^LANG^JO E^^^^^^Mirth^^^^CI||ED||||7|S|||62|6635130^^^AccMg r^VN^1|865^SP KOPP|||||||||||||||||||1||A|||20060404090500 PV2||^NO||||||20060404090500|||||||||||||||||||||| ||||||||SDG1|1||^HEADACHE|HEADACHE||A||||||| ||0GT1|1|382582|TEST^PATIENT MF||21 PALM MANOR^^EAST SYRACUSE^NY^130570000|||19570414|M|||000987655|||| ||||11IN1|1|SELF PAY NYS|734|SELF PAY NYS|||||||||||5|TEST^PATIENT MF|1|19570414|21 PALM MANOR^^EAST SYRACUSE^NY^130570000|||||||||||||||||||||||11|M|| ||||382582IN1|2|SELF PAY|705|SELFPAY|||||||||||5||1IN2|1||0009876 55</template>
</transformer>
<filter>
<rules/>
<template>MSH|^~\&|AccMgr|1|||20060404090746|| ADT^A04|6035910|D|2.3.1EVN|A04|2006040409074 2PID|1|800888^^^AccMgr^PN|999945682^^^AccMgr ^MR^1||TEST^PATIENT MF||19570414|M||W|21 PALM MANOR^^EAST SYRACUSE^NY^130570000^^M|31|||E|M||6635130^^^AccMg r^VN^1|000987655|||2|||||NOT A VETERAN|||NPD1||||1335^ALCOTT^KAREN^^^^^^Acc Mgr^^^^CI|||INK1|1|TEST^MARGARET|W|21 PALM MANOR^^EAST SYRACUSE^NY^130570000|||YPV1|1|E|ED^^^1|1||| 1281^MARKHAM^JOSEPH^^^^^^AccMgr^^^^CI|1281^MARKHAM ^JOSEPH^^^^^^AccMgr^^^^CI||ED||||7|S|||62|6635130^ ^^AccMgr^VN^1|865^SP KOPP|||||||||||||||||||1||A|||20060404090500 PV2||^NO||||||20060404090500|||||||||||||||||||||| ||||||||SDG1|1||^HEADACHE|HEADACHE||A||||||| ||0GT1|1|382582|TEST^PATIENT MF||21 PALM MANOR^^EAST SYRACUSE^NY^130570000|||19570414|M|||000987655|||| ||||11IN1|1|SELF PAY NYS|734|SELF PAY NYS|||||||||||5|TEST^PATIENT MF|1|19570414|21 PALM MANOR^^EAST SYRACUSE^NY^130570000|||||||||||||||||||||||11|M|| ||||382582IN1|2|SELF PAY|705|SELFPAY|||||||||||5||1IN2|1||0009876 55</template>
</filter>
<transportName>File Writer</transportName>
</com.webreach.mirth.model.Connector>
</destinationConnectors>
<properties>
<property name="initialState">stopped</property>
<property name="synchronous">true</property>
<property name="store_messages">true</property>
<property name="recv_xml_encoded">false</property>
<property name="encryptData">false</property>
<property name="transactional">false</property>
<property name="max_message_age">-1</property>
<property name="error_messages_only">false</property>
</properties>
<preprocessingScript>// Modify the message variable below to pre process data
return message;</preprocessingScript>
</com.webreach.mirth.model.Channel>

Pls give me a solution.

From
kgk_007

Announcement

Building an HL7 message from fields of a database - Critical Error

Building an HL7 message from fields of a database - Critical Error

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment