Clovertech

XML to HL7

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › XML to HL7

  • Creator
    Topic
  • March 19, 2007 at 8:00 pm #49148
    Femina Jaffer
    Participant

      Hello,

      Can anyone assist me on how I load or import the xml file into CL.  I am very new to XML, I have an *.xml file, but I have no clue of how to bring it in and compile it.  Can anyone guide me with the first steps?  I tried the XML package, created a folder – and that was all I could do.  

      The version of CL wer are on is 3.8.x.

      Thank you for your assistance.

      Femina

    • Creator
      Topic
    Viewing 10 reply threads
    • Author
      Replies
      • March 20, 2007 at 12:41 pm #60895
        Kevan Riley
        Participant

          The first step is that you will need to create a DTD or Schema that defines you XML document.  It is unfortunately not uncommon for a vendor to supply sample XML documents but not supply a DTD or schema.  If they cannot provide you one, you will have to create it.  There are some tools out there available that are helpful, try googling XML editor.

          Once you have a DTD or schema, that is what you will use with the package tool in Cloverleaf.

        • March 21, 2007 at 3:42 pm #60896
          Femina Jaffer
          Participant

            Thank you so much Kevin, for your prompt response.  However, I am still have trouble with this, even after doing what you suggested.  The compile option is also greyed out in the XML Package Manager.  I have attached the screen shot of this, and also the XML file for anyones review.  

            Please advise.  Thank you.

            FJ

            XML Package Manager Screenshot:

             

            XML FILE:

             

             

            –

            –

             2007-03-15T09:30:25

             188

             

            –

            –

             SMITH

             

             2007-02-28

             2328

             3075

             

             020478398

             4

             1

             

             4

            –

            +

             PRESBYTERIAN HOSPITAL

             ATTN: TRICORE LAB

             1001 WOODWARD PLACE NE

             

             ALBUQUERQUE

             NM

             87102

             

             

             

            –

            –

             JOCHEMS, GREG MD

             RIO RANCHO MED CNTR

             4500 HIGH RESORT BLVD SE

             

             RIO RANCHO

             NM

             87124

             

             

             

            –

             SMITH

             ELIZABETH

             34

             1973-01-02

             NM

             87121

             

             

            –

             067705647

             1

             1

             2007-03-02

             0550

             30

             H

             4

             0

             

             0

             0

             

             

            –

             2007-03-13

             2007-03-08

             1345

             

            –

            –

             T4

            –

             NOR

             17.08 ug/dL

             Normal

             ** Age Adjusted **

             

             17.08

             

            –

             Phenylalanine

            –

             NOR

             < 200 uM

             Normal

             Normal < 200 uM

             

             0

             

            –

             Biotinidase

            –

             NOR

             Has Color

             Normal

             Normal Has Color

             

             

             

            –

             Hemoglobin

            –

             NOR

             FA

             Abn Hb not found

             Normal = FA

             

             

             

            –

             CAH(17-OHP)

            –

             NOR

             20.48 ng/mL

             Normal

             ** Age Adjusted **

             

             20.48

             

            –

             GALT

            –

             NOR

             Fluorescence

             Normal

             Normal=Fluorescence

             

             

             

            –

             Amino Acids

            –

             NOR

             Normal

             Normal

             Normal

             

             

             

            –

             Acylcarnitines

            –

             NOR

             Normal

             Normal

             Normal

             

             

             

             

             

             2007-03-14

             

          • March 21, 2007 at 3:51 pm #60897
            Kevan Riley
            Participant

              it is the Schema or DTD that you must compile.  Can you send the Schema or DTD you are trying to use?

            • March 21, 2007 at 4:12 pm #60898
              Jim Kosloskey
              Participant

                Femina,

                You might want to check to see if the XML facility on 3.8.1 is fully functional. I suppose support can give you that information – unless someone else on this forum knows definitively

                I seem to recall that version’s XML was not.

                Jim Kosloskey

                email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

              • March 21, 2007 at 4:40 pm #60899
                Femina Jaffer
                Participant

                  Hi Kevin,

                  Here is the DTD and schema, attached.  I figured out what I was doing incorrectly, which was I needed to place these file in a New Package Directory.  After doing this I was able to compile, except I get an error.  I get an out of memory error if I click the .xml file, and root node error when I click on the *dtd file.

                  I have attached the error message and the files for your review.

                  Thank you both for your responses.  It is much appreciated.

                  Femina

                  [/img]

                • March 21, 2007 at 7:05 pm #60900
                  Femina Jaffer
                  Participant

                    I was able to successfully compile.  I figured out the error, we needed to modify the xml schema to match another label/element.  Once we did that – bingo!  

                    So, now I guess the next bit is map the fields in a translate.  Any idea or examples ?

                    Thanks again to all of you.

                    fj

                  • March 21, 2007 at 7:21 pm #60901
                    Kevan Riley
                    Participant

                      Here is a sample Xlate that is a CSV to XML interface.

                    • March 21, 2007 at 7:23 pm #60902
                      Femina Jaffer
                      Participant

                        Hello Kevin,

                        The attachment wasn’t in the post.  Please re-send.

                        fj

                      • March 21, 2007 at 7:27 pm #60903
                        Kevan Riley
                        Participant

                          Let me try the attachment again.

                        • March 21, 2007 at 7:28 pm #60904
                          Kevan Riley
                          Participant

                            The file I attached is an Xlate file.  You’ll have to rename it from “.txt” to “.xlt” to view it in the GUI.

                          • March 21, 2007 at 7:33 pm #60905
                            Femina Jaffer
                            Participant

                              Thanks Kevin, you have been a great help.

                              fj

                          • Author
                            Replies
                          Viewing 10 reply threads
                          • The forum ‘Cloverleaf’ is closed to new topics and replies.