Announcement

Collapse
No announcement yet.

SQL Variables not showing under Available Variables in 1.4

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Variables not showing under Available Variables in 1.4

    I just upgraded to 1.4 and was going to create a new Outbound message. So my source is a sql server connection. My Destination is a text file. When I go to add a Transformer to the Destination under Available Variables my columns that I select in my sql statement do not show. They did in the older version of Mirth that I was using. Am I doing something wrong?

    Thanks,
    Bobbie

  • #2
    Re: SQL Variables not showing under Available Variables in 1.4

    No,

    You will get the database row as XML. If you go to the source->transformer and look at the incoming data tab, you will see the sample XML. You can either perform mappings here (use channel map) or just copy this XML to your destination incoming data tab. You can do your mappings on the destination and then use in your file writer.

    -Chris
    Chris Lang

    Comment


    • #3
      Re: SQL Variables not showing under Available Variables in 1.4

      So do I have to create the xml mapping myself or is Mirth suppose to do it for me. Because nothing is showing in the incoming data tab.

      Thank you for your help,
      Bobbie

      Comment


      • #4
        Re: SQL Variables not showing under Available Variables in 1.4

        ChrisL, Bobbie

        This seems to be another problem with 1.4. Bobbie and I are experiencing a lot of the same issues. On my first channel my source was a sql source and the sample did show up on the inbound tab. For subsequent sql source channels it will not show up. Now I'm having blank channel edit screens as well.

        Comment


        • #5
          Re: SQL Variables not showing under Available Variables in 1.4

          Yes,

          You both are having similar issues with the client - I'm beginning to think this is an issue with an old client cache. When upgrading, you should delete your cache.

          On Windows, go to Control Panel -> Java and choose delete temporary files. Then try to re-launch the client. Let me know if the issues persist.
          Chris Lang

          Comment

          Working...
          X