Announcement

Collapse
No announcement yet.

Mirth Read XML File and Insert into database Microsoft SQL.

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

  • Mirth Read XML File and Insert into database Microsoft SQL.

    Good afternoon, I have an XML file that is generated by my system and I need to read this XML file to include it in my database. Below is an example of the generated XML file. I need to throw this information into my microsoft sql database.

    <?xml version='1.0' encoding='ISO-8859-1' standalone='no'?>
    <MWL_ITEM>
    <SITE>HNSC</SITE>
    <PATIENT_ID>45993998</PATIENT_ID>
    <PATIENT_NAME>MARIA CATHARINA DE ALMEIDA SANTOS</PATIENT_NAME>
    <PATIENT_BIRTHDATE>19391204</PATIENT_BIRTHDATE>
    <PATIENT_SEX>MARIA CATHARINA DE ALMEIDA SANTOS</PATIENT_SEX>
    <PATIENT_WEIGHT>67.8</PATIENT_WEIGHT>
    <ACCESSION_NUMBER>22127077</ACCESSION_NUMBER>
    <REQUESTING_PHYSICIAN>ERIDA THAYNA RIBEIRO</REQUESTING_PHYSICIAN>
    <REQUESTING_PHYSICIAN_IDENTIFICATION>48002</REQUESTING_PHYSICIAN_IDENTIFICATION>
    <REQUESTING_SERVICE>RADIOLOGY</REQUESTING_SERVICE>
    <MODALITY>CR</MODALITY>
    <REQUESTED_PROCEDURE_DESCRIPTION>RADIOGRAPHY OF THE CHEST (PA + SIDE + OBLIQUA)</REQUESTED_PROCEDURE_DESCRIPTION>
    <DATE>20220513</DATE>
    <TIME>113200</TIME>
    </MWL_ITEM>


    My database is structured like this

    SELECT top 10 [na_accessionnumber]
    ,[co_patientid]
    ,[na_patientname]
    ,[na_patientsex]
    ,[na_patientbirthday]
    ,[na_patientweight]
    ,[na_patientheight]
    ,[co_performingid]
    ,[na_performingname]
    ,[na_performingcrm]
    ,[na_performinguf]
    ,[na_performingemail]
    ,[co_requesterid]
    ,[na_requestername]
    ,[na_requestercrm]
    ,[na_requesteruf]
    ,[na_requesteremail]
    ,[na_description]
    ,[na_bodypart]
    ,[na_studydate]
    ,[na_studytime]
    ,[na_modalityris]
    ,[na_password]
    ,[na_requireunit]
    ,[na_datetimerelease]
    ,[na_studyid]
    ,[on_machine]
    ,[na_unit]
    ,[na_customsearchfield]
    ,[na_datetimeintegrated]
    ,[co_worklistintegration]
    ,[na_requestingservice]
    ,[na_stepstatus]
    ,[na_operatorsname]
    ,[na_insuranceplan]
    ,[na_requestingdepartment]
    ,[na_requestedproceduredesc]
    ,[na_reqprocedurecodevalue]
    ,[na_reqprocedurecodschemedes]
    ,[na_patientrg]
    ,[na_patientcpf]
    ,[na_patientphone]
    ,[na_patientemail]
    ,[na_requesterphone]
    ,[na_clickvitawebprotocol]
    ,[na_clickvitawebpassword]
    ,[co_orderid]
    FROM worklistintegration

    How could I do that in Mirth?

  • #2
    Up

    Comment


    • #3
      Please read my response to your github post with the same question at https://github.com/nextgenhealthcare...scussions/5163

      If you cross post, please reference that.
      Diridium Technologies, Inc.
      https://diridium.com

      Comment

      Working...
      X