oracle - How to get HL7 templates for Mirth Connect? -


I'm new to this HL7 standard, but first I worked on the NCPDP standard. I am now trying to find a Mirth Connect open source tool. When I am trying to configure according to the document (user guide) that is provided in the URL, but this document mentions using this HL7 template where I do not find these templates. Can you please help me.

I searched in the Internet and some such platforms whose examples I found under the template

MSH | ^ ~ \ & | MIRTH_1.7 | DOMAIN | LABTEST || $ {Date.get ('yyyyMMddHHmm')} || ADT ^ A08 | $ {UUID} | P | 1.7 ||| AL | NE | EVN | A08 | $ {Date.get ('yyyyMMddHHmm')} |||| PID ||| $ {Patno} || $ {FAMILY_NAME} ^ $ {first_name} ^ $ {middle_name} ^^^^ || $ {D_o_b} | $ {Sex} ||| $ {Address1} ^ $ {address2} ^ $ {address3} ^^^^ || $ {Phone} | $ {Emp_phone} || $ {Marital_status} | $ {Religion} |||||||||||| PV1 |||||||||||||||||||||||||||||||||||||||||||||||

-00911: invalid character query: select as the PATIENTINFO.PATIENTID PATIENTINFO_PATIENTID, PATIENTINFO.FIRSTNAME PATIENTINFO_FIRSTNAME, the PATIENTINFO.LASTNAME PATIENTINFO as PATIENTINFO_LASTNAME; Parameter: [] org.apache.commons.dbutils.QueryRunner.rethrow (queryRunner.java359) at org.apache.commons.dbutils.queryRunner.query (QueryRunner.java), at com.webreach.mirth.connectors .jdbc.JdbcMessageReceiver.getMessages (JdbcMessageReceiver.javaŠ¶5555) at org.mule.providers.TransactedPollingMessageReceiver $ 1.doInTransaction (TransactedPollingMessageReceiver.java:91) at org.mule.transaction.TransactionTemplate.execute (TransactionTemplate.java:72) In Organization Mule.providers.TransactedPollingMessageReceiver.poll (TransactedPollingMessageReceiver.java:104) at org.mule.providers Polingmsej Risivrkrun (PollingMessageReceiver.java:90) on org.mule.impl.work.WorkerContext.run (worker contact. Java 990)) edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor $ Worker.run on edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor $ Worker.runTask (ThreadPoolExecutor.java:650) .java on (ThreadPoolExecutor: 675) at java.lang.Thread.run (see unknown's source) { }

and in the server log

  [2010-07-28 19: 02: 52,515] fatal (org.mule.impl.DefaultComponentExceptionStrategy: 83) : The default component exception strategy has been implemented but there is no current event on the reference [2010-07-28 19: 02: 52,515] Fatal (org.mule.impl.Defaul) TComponentExceptionStrategy: 84): Error: ORA-00911: Invalid character query: Selection PATIENTINFO.PATIENTID as PATIENTINFO_PATIENTID, PATIENTINFO.FIRSTNAME as PATIENTINFO_FIRSTNAME, from PATIENTINFO.LASTNAME PATIENTINFO as PATIENTINFO_LASTNAME; Parameter: [] java.sql.SQLException: ORA-00911: Invalid character query: Selection PATIENTINFO.PATIENTID as PATIENTINFO_PATIENTID, as PATIENTINFO.FIRSTNAME PATIENTINFO_FIRSTNAME, as PATIENTINFO.LASTNAME PATIENTINFO as PATIENTINFO_LASTNAME; Parameter: [] org.apache.commons.dbutils.QueryRunner.rethrow (queryRunner.java359) at org.apache.commons.dbutils.queryRunner.query (QueryRunner.java), at com.webreach.mirth.connectors .jdbc.JdbcMessageReceiver.getMessages (JdbcMessageReceiver.javaŠ¶5555) at $ 1.doInTransaction (TransactedPollingMessageReceiver.java:91) on org.mule.transaction org.mule.providers.TransactedPollingMessageReceiver. TransactionTemplate.execute (TransactionTemplate.java:72) In Organization Mule.providers.TransactedPollingMessageReceiver.poll (TransactedPollingMessageReceiver.java:104) at org.mule.providers Polingmsej Risivrkrun (PollingMessageReceiver.java:90) on org.mule.impl.work.WorkerContext.run (worker contact. Java 990)) edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor $ Worker.run on edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor $ Worker.runTask (ThreadPoolExecutor.java:650) (.java on ThreadPoolExecutor: 675) at java.lang.Thread.run (unknown S Ource)  

Please help me solve this problem.

Thanks Student

I want to ask my partner company for some samples , Or find a Martha Forum for finding something.

Your sample can be cleaned. Change coded elements with "real" data For example, {date.get ('yyyyMMddHHmm')} should be replaced with a real date string, '2010-08-20'.

Besides, I found that when pasting the samples in the template box, I had to segregate each segment (add CRLF's inbetween) so MSH. Instead ... ... ADT | ... pid | ..., you get:
MSH | ... ADT | ...
PID | ...

Hope that helps.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -