McKesson Horizon Patient Folder XML question

[Jodi Agosta2]

Hi All,

Our hospital is implimenting Horizon Patient Folder. We have one software package that puts a PDF file in a folder and sends a ORU for the indexing. They are asking that the ORU be turned into a XML to send to their Batch Compiler (ORU to XML). They sent me an example .xml but it wouldn’t compile. The error message said that it was missing it’s DTD. It was.  I was wondering if any of you have done a similar interface and have an example of their .xsd or a properly formatted .xml? Needless to say I am a total rookie when it comes to XML so trying to build this has been a challenge.

Thanks in advance.

Jodi

Topic

[Levy Lazarre]

Hi Jodi,

Here are an example of a properly formatted xml file for the Batch compiler (SampleFile.xml) and its corresponding xsd file (CrossRefSchema.xsd). The beginning of the xml file makes reference to the xsd.

I cleaned the sample xml provided by McKesson, then built the xsd file using a popular XML editor.

Note that in Cloverleaf, you compile the xsd file (not the xml file). You can then use the Testing tool and the sample xml file to verify that the compiled xsd is working properly. The .xsd I give you compiled fine with CL version 5.4.

Using an Xlate (HL7 ORU to XML) is not necessarily the best way to generate the XML for HPF. The Xlate iterations can be tricky when you have a repeating element in the XML schema (like the Index in our case).

A simpler solution is to write a TCL script that processes the inbound ORU message, extracts the necessary indexing elements from the HL7 (like account number, medical record number, document type, etc.), and dynamically creates the xml file, using a template similar to the sample I give you. I recently built an interface to send a PDF to HPF; my situation was different from yours because no HL7 ORU was available. However, I was able to use a TCL script as described to create the xml index for HPF.

I hope this helps.

[Jodi Agosta2]

Hi Levy,

You are a life saver. My poor attempts were not even close. I still have to finish off the build but this will make it so much easier. I like your TCL idea. Thank you for helping me out of a tight spot.

Jodi

[Author]

Replies