Tweet
Hello, I am currently testing the interface. The incoming message is in xml format, something like:
<?xml version="1.0" encoding="UTF-8" ?>
<HL7Messages MessageFormat="ORUR01" MessageCount="7" Version="2.3">
<Message MsgID="1">
<![CDATA[ MSH|^~\&|PATHL7|BCB|HTTPCLIENT|acham1|200702200953 24||ORU^R01|MED20070220095324400|P|2.3|||ER|AL
PID||AB-12345678|||||xxxxxxx|M|||xxxxxx||xx
ORC|RE||T04-105448-HP-0|||||||||22333^MEDIC^IAN^TEST
OBR|1||T04-105448-HP-0|HP^Hematology Panel||20040315104300|20040315104300|||||||2004031 5104300||22333^MEDIC^IAN^TEST||T04105448||T04-105448|T04105448|20040315104300||HAEM|F|||22333^ME DIC^IAN^TEST
NTE|||Reviewed by Omega Haem Path, MD, FRCP.
OBX|1|NM|12227-5^WBC||12.0|10*9/L|4.0 - 11.0|H|||F|||20040315104300
OBX|2|NM|789-8^RBC||4.50|10*12/L|4.30 - 5.90|N|||F|||20041025075000
OBX|3|NM|718-7^Hemoglobin||135|g/L|135 - 180|N|||F|||20041025075000
OBX|4|NM|4544-3^Hematocrit||0.42|L/L|0.41 - 0.52|N|||F|||20041025075000
OBX|5|NM|787-2^MCV||80|fL|80 - 100|N|||F|||20041025075000
OBX|6|NM|777-3^Platelet Count||110|10*9/L|150 - 400|L|||F|||20041025075000
OBX|7|NM|751-8^Neutrophils||4.2|10*9/L|2.0 - 8.0|N|||F|||20040315104300
OBX|8|NM|731-0^Lymphocytes||7.0|10*9/L|1.0 - 4.0|H|||F|||20040315104300
OBX|9|FT|729-4^Other Cells||Hairy Cells H 0.7\.br\Plasma Cells H 0.1\.br\|||N|||F|||20040315104300
OBX|10|TX|9317-9^Platelet Estimate||DECREASED|||N|||F|||20040315104300
OBX|11|FT|682-5^Test Comments||RBC Morphology normal.|||N|||F|||20040315100200
OBX|12|FT|14869-2^Pathologist Comments (Hematology)||Most probably consistent with a developing Hairy Cell Leukemia. Lymphocytosis and absence of Monocytes support this finding. Suggest bone marrow biopsy in light of current peripheral findings.|||N|||F|||20040315101500
]]> </Message>
</HL7Messages>
could anyone tell me how to set up the channel to parse that xml file, then store it into the database? thx a lot
<?xml version="1.0" encoding="UTF-8" ?>
<HL7Messages MessageFormat="ORUR01" MessageCount="7" Version="2.3">
<Message MsgID="1">
<![CDATA[ MSH|^~\&|PATHL7|BCB|HTTPCLIENT|acham1|200702200953 24||ORU^R01|MED20070220095324400|P|2.3|||ER|AL
PID||AB-12345678|||||xxxxxxx|M|||xxxxxx||xx
ORC|RE||T04-105448-HP-0|||||||||22333^MEDIC^IAN^TEST
OBR|1||T04-105448-HP-0|HP^Hematology Panel||20040315104300|20040315104300|||||||2004031 5104300||22333^MEDIC^IAN^TEST||T04105448||T04-105448|T04105448|20040315104300||HAEM|F|||22333^ME DIC^IAN^TEST
NTE|||Reviewed by Omega Haem Path, MD, FRCP.
OBX|1|NM|12227-5^WBC||12.0|10*9/L|4.0 - 11.0|H|||F|||20040315104300
OBX|2|NM|789-8^RBC||4.50|10*12/L|4.30 - 5.90|N|||F|||20041025075000
OBX|3|NM|718-7^Hemoglobin||135|g/L|135 - 180|N|||F|||20041025075000
OBX|4|NM|4544-3^Hematocrit||0.42|L/L|0.41 - 0.52|N|||F|||20041025075000
OBX|5|NM|787-2^MCV||80|fL|80 - 100|N|||F|||20041025075000
OBX|6|NM|777-3^Platelet Count||110|10*9/L|150 - 400|L|||F|||20041025075000
OBX|7|NM|751-8^Neutrophils||4.2|10*9/L|2.0 - 8.0|N|||F|||20040315104300
OBX|8|NM|731-0^Lymphocytes||7.0|10*9/L|1.0 - 4.0|H|||F|||20040315104300
OBX|9|FT|729-4^Other Cells||Hairy Cells H 0.7\.br\Plasma Cells H 0.1\.br\|||N|||F|||20040315104300
OBX|10|TX|9317-9^Platelet Estimate||DECREASED|||N|||F|||20040315104300
OBX|11|FT|682-5^Test Comments||RBC Morphology normal.|||N|||F|||20040315100200
OBX|12|FT|14869-2^Pathologist Comments (Hematology)||Most probably consistent with a developing Hairy Cell Leukemia. Lymphocytosis and absence of Monocytes support this finding. Suggest bone marrow biopsy in light of current peripheral findings.|||N|||F|||20040315101500
]]> </Message>
</HL7Messages>
could anyone tell me how to set up the channel to parse that xml file, then store it into the database? thx a lot