Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

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

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

Dumping HL7 --> Database ( postgresql ) Channell??

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dumping HL7 --> Database ( postgresql ) Channell??

    Hi All,
    I search in the forum but I can't find what I am looking for :-(

    What I would like is that :
    Once we receive the file, we want to dump the raw data inside our database.
    We would like to keep everything we receive...

    I can manually create a table (That match the spec) and I can also create all the variables to insert everything inside.)

    But there is some segment with 50-60 values.
    It's a LONG process.

    Is there a way to "automatically" dump the HL7 file in postgresql with having to declar all the variable inside a channel ?
    thanks!!
    Anthony

  • #2
    Originally posted by tonylaq View Post
    Hi All,
    I search in the forum but I can't find what I am looking for :-(

    What I would like is that :
    Once we receive the file, we want to dump the raw data inside our database.
    We would like to keep everything we receive...

    I can manually create a table (That match the spec) and I can also create all the variables to insert everything inside.)

    But there is some segment with 50-60 values.
    It's a LONG process.

    Is there a way to "automatically" dump the HL7 file in postgresql with having to declar all the variable inside a channel ?
    thanks!!
    Anthony
    Hey Anthony,

    I am having the similar situation here.
    I want to insert HL7 content into the MySql database on Ubuntu.
    If you found answer could you please provide steps to troubleshoot it ?

    Thanks in advance
    Prashant

    Comment


    • #3
      The values you're after are message.rawData and messsage.encodedData . Raw data is the incoming data, before any transformations. Encoded data is the outgoing data after transformations have been applied.
      Jon Bartels

      Zen is hiring!!!!
      http://consultzen.com/careers/
      Talented healthcare IT professionals wanted. Engineers to sales to management.
      Good benefits, great working environment, genuinely interesting work.

      Comment


      • #4
        Hi Jon

        As you mention about messageRaw data, I tired to insert into my table ' TEST' having two columns ' MID & RAW' and the insert query

        insert into test (MID, RAW) values (${MID},${RAWDATA})


        It still generates errors.
        Am I doing correct procedure ?

        Thanks,

        Comment


        • #5
          Copied from a working channel that does what you're asking for:

          INSERT IGNORE INTO hl7results (acn, recline) VALUES (${Accession}, ${message.rawData});

          ($Accession is defined in a transformer step.)

          Comment


          • #6
            Thanks for your help.

            I got success to send the entire message into database.
            It fulfill my initial goal, my next target is break down the whole message and send it to different tables into the database.
            Is there any generic database exist which will allow the single HL7 message insert into relational tables?

            Thanks,
            Prashant

            Comment

            Working...
            X