Tweet
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?
<?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?
Comment