Clovertech

Convert a flat file into HL7 messages

› Clovertech Forums › Read Only Archives › Cloverleaf › General › Convert a flat file into HL7 messages

  • Creator
    Topic
  • November 18, 2005 at 6:45 pm #48157
    Wilson Wat
    Participant

      Does anyone have any experience on creating an Excel with few fields e.g. Patient name, SSN and birthday into HL7 messages?

      Thanks,  

      Wilson

    • Creator
      Topic
    Viewing 3 reply threads
    • Author
      Replies
      • November 18, 2005 at 7:20 pm #57860
        Ryan Spires
        Participant

          Generally speaking,

          I would export the excel file into a comma delimited file (.csv)

        • April 17, 2009 at 3:39 pm #57861
          Bala Pisupati
          Participant

            Ryan,

            I have a .csv file which has some fields defined with their lengths. Now how do I convert it into VRL from GUI.

          • April 17, 2009 at 3:46 pm #57862
            Ryan Spires
            Participant

              To my knowledge there is no way to convert a csv or xlt  to a vrl via the gui.  if so I have missed out on that functionality.   Though that would be a pretty cool enhancment 🙂

            • April 17, 2009 at 4:05 pm #57863
              Jim Kosloskey
              Participant

                Bala,

                I just use the GUI to define the VRL structure.

                You could write a Tcl proc to build the VRL definition file from your file (I am assuming the file you have is essentially the definition of the VRL not the data for the VRL) if you are so inclined.

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

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