Clovertech

SQLServer – SQL Table to HL7 File

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › SQLServer – SQL Table to HL7 File

  • Creator
    Topic
  • May 29, 2015 at 9:55 pm #54702
    Femina Jaffer
    Participant

      Friends,

      I am having a lot of trouble with this today.  I have a jdbc connection already to a sql server and database.  I have created the schema via database configurator.  All I need to do is read data from a sql server (inbound) thread and write the output to a file and using and xlate (input database schema) output ORU_R01 HL7.

      I am not able to get the data to write out to a file using the translation.  I do get a java core heap file after a few minutes.

      Thanks,

      Femina

    • Creator
      Topic
    Viewing 3 reply threads
    • Author
      Replies
      • June 3, 2015 at 3:14 pm #82628
        Femina Jaffer
        Participant

          Okay, I got this working when I write a query for the top 10; but when it writes out the entire contents of the query, it errors out.

        • June 5, 2015 at 3:28 pm #82629
          Femina Jaffer
          Participant

            I have added a query in the READ SUCCESS tab to set a flag at a column.  I am hoping that will do the trick.  It does for a smaller file.

            Anyway, I have another problem and would really be most grateful if someone can shed some light.  This one I have been struggling with for quite some time.  Anyway, I am just doing a select on one column in my  query, yet the out put file is placing commas before each segment. For example, here is the output:

            ,,,,,MSH|^~&|Sunquest|TriCore|X|X|20150602151840||ORU^R01|20150602000001|T|2.3|||AL,

            ,,,,,PID|||||SCOTT^LARAINE^||19431025|F||||YIJ804001800|||||000000230510|585075960,

            Any idea why this is happening?  Could this have anything to do with encoding?

          • June 9, 2015 at 6:38 pm #82630
            Harpreet Khakh
            Participant

              Hi Femina,

              In database configuration scenario, columns are returned based on table mapping, if select returns only one column, all others will be blank.

              If you really want only one column returned, disable (uncheck) all other columns in database configuration.

              Hope that helps.

              Thanks,

              Harpreet

            • June 9, 2015 at 9:29 pm #82631
              Femina Jaffer
              Participant

                Thanks Harpreet,  I did do that in the db configurator; it is checked but greyed out.

                Thanks,

                FJ

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