Announcement

**mrslatezb** · 10-12-2006, 07:24 PM

My issue resolved!

Okay.... So i spent a little more time and realized that the transformer is the incorrect place to be doing all of those. So, moving my code to the filter got me to a whole bunch of errors. Anyway, after resolving those i figured I would post the code to help anybody else out who would like to do the same.

Basically, it takes all the ADT^A08 messages and places them into their own table & symptoms table.

Code:

if(msg[&#039;MSH&#039;][&#039;MSH.9&#039;][&#039;CM_MSG.1&#039;] == "ADT" && msg[&#039;MSH&#039;][&#039;MSH.9&#039;][&#039;CM_MSG.2&#039;] == "A08") {
var driver = "com.mysql.jdbc.Driver";
var address = "jdbc:mysql://localhost/rawhl7";
var username = "username"; 
var password = "password"; 
var i = 0;
var patientID = msg[&#039;PID&#039;][&#039;PID.3&#039;][&#039;CX.1&#039;];
var dbConn = DatabaseConnectionFactory.createDatabaseConnection(driver,address,username,password);

while(msg[&#039;DG1&#039;][&#039;DG1.4&#039;][i] != null) {
var complaintNumber = msg[&#039;DG1&#039;][&#039;DG1.1&#039;][i];
var complaint = msg[&#039;DG1&#039;][&#039;DG1.4&#039;][i];
var expression = "INSERT IGNORE INTO a08_complaints values (DEFAULT, &#039;" + patientID + "&#039;, &#039;" + complaintNumber + "&#039;, &#039;" + complaint + "&#039;);";  
var result = dbConn.executeUpdate(expression);
i = i + 1;
}
dbConn.close();
}

return msg[&#039;MSH&#039;][&#039;MSH.9&#039;][&#039;CM_MSG.1&#039;] == "ADT" && msg[&#039;MSH&#039;][&#039;MSH.9&#039;][&#039;CM_MSG.2&#039;] == "A08";

**chrisl** · 10-13-2006, 10:55 AM

Re: Multiple DG1 Segments into a database

Thank you for your in-dept analysis and the code! Glad you got it working.

A few tips:
* Your first design was correct (database call in the transformer)

Ideally you would include a simple filter that checks the message type:

Code:

if(msg[&#039;MSH&#039;][&#039;MSH.9&#039;][&#039;CM_MSG.1&#039;] == "ADT" && msg[&#039;MSH&#039;][&#039;MSH.9&#039;][&#039;CM_MSG.2&#039;] == "A08") {
return true;
}else{
return false;
}

Then your transformer would include a Javascript step that has the rest of your code.

* We are hoping to include the ability to use more complex templating in the JDBC sql statement on the destination endpoint, such that you would not have to perform your JDBC logic inside of the actual Javascript, but rather use the mapping steps to build your loop. This is scheduled for our 1.3 release.

**peter_hyc** · 02-24-2016, 05:14 PM

Hi Chris,
I try to code in Mirth wiki lib mapping multiple seg to a database,
http://www.mirthcorp.com/community/w...+to+a+Database
however, i been getting error when processing the multiple segment messages.
it says msg not defined.

[I]

[2016-02-25 10:13:02,921] ERROR (com.mirth.connect.connectors.jdbc.DatabaseDispatc herScript:152): Error evaluating Database Writer (Database Writer "RepeatSegments" on channel adba08a9-ca51-4aa3-921a-29013d7f4ae5).
com.mirth.connect.server.MirthJavascriptTransforme rException: CHANNEL:
LIS OrdersCONNECTOR:
RepeatSegmentsSOURCE CODE:
48: var VisitNo = $('VisitNo');49: var UID = $('UID');50: 51: var i = 0;52: 53: while(msg['OBR']['OBR.4']['OBR.4.2'][i] != null) {54: var Orders= msg['OBR']['OBR.4']['OBR.4.2'];55: var expression = "INSERT IGNORE INTO LIS_Orders values (DEFAULT, '" + NRIC + "', '" + VisitNo + "', '" + UID + "', '" + Orders + "');";56: var result = dbConn.executeUpdate(expression);57: LINE NUMBER:
53DETAILS:
ReferenceError: "msg" is not defined.
at b3845d44-e2e8-416a-ad90-44566ee2112c:53 (doScript)
at b3845d44-e2e8-416a-ad90-44566ee2112c:69
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:527)
at com.mirth.connect.connectors.jdbc.DatabaseDispatch erScript$DatabaseDispatcherTask.call(DatabaseDispa tcherScript.java:120)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker( Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

how do i resole this?

Announcement

Multiple DG1 Segments into a database

Multiple DG1 Segments into a database

Comment

Comment

Comment