Mirth Connect 4.3.0 Released!

Mirth Connect 4.3.0 is now available as an appliance update and on our GitHub page.

This is a major release containing new features like adding new functionality to the Mirth Connect Setup Wizard, adding the ability for resource and channel-specific classloaders to load child-first or parent-first, and added a default implementation of the getObjectsForSwaggerExamples() method in the ServicePlugin class. This release also contains enhancements for the Mirth Connect Administrator Launcher, the Mirth Connect Docker images, and several bug fixes and security improvements.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

database reader xml to hl7 transformation issue

  • Filter
  • Time
  • Show
Clear All
new posts

  • database reader xml to hl7 transformation issue


    I cant seem to map my incoming XML from a dbreader on 1.6.1 (I believe in the past I was successful reading directly from file but never got a db read to work).

    Here is my channel xml
    I have a database reader with SQL

    select interface_message_id as id, message from interface_messages where...

    The message field is an XML, (sample found here) which I pasted into the destination transformer incoming data.

    I am not sure if I paste and replace everything, or paste and replace the 'message' value.

    Trying either of those doesnt help with my mapping actual data - I tried a couple of ways:

    ////////////////////         PID         //////////////////////////////////
    tmp['PID']['PID.5']['XPN.1']['FN.1'] = msg['message']['InterfaceMessage']['PatientModel']['lastName'].toString();
    tmp['PID']['PID.5']['XPN.2'] = msg['InterfaceMessage']['PatientModel']['firstName'].toString();
    tmp['PID']['PID.5']['XPN.3'] = msg['message']['InterfaceMessage'].toString();
    tmp['PID']['PID.5']['XPN.5'] = "mr";
    tmp['PID']['PID.5']['XPN.4'] = msg['message']['InterfaceMessage']['PatientModel'].toString();
    hl7_xml = tmp;
    but the output as no xml fields - just my hardcoded mr

    Am I missing something obvious?

    Post edited by: caultonpos, at: 10/08/2007 20:47

  • #2
    Re:database reader xml to hl7 transformation issue

    Never mind I need:

    msg = new XML(msg['message'].toString());