Hi everyone, please check out our new discussion forum located in our GitHub site: https://github.com/nextgenhealthcare/connect/discussions. Let us know your feedback as we try out this new part of GitHub! Don't worry, the content in these forums won't be going away and will at a minimum be preserved for historical reference.
Announcement
Collapse
Mirth Connect 4.3.0 Released!
Mirth Connect 4.3.0 is now available as an appliance update and on our GitHub page.
This is a major release containing new features like adding new functionality to the Mirth Connect Setup Wizard, adding the ability for resource and channel-specific classloaders to load child-first or parent-first, and added a default implementation of the getObjectsForSwaggerExamples() method in the ServicePlugin class. This release also contains enhancements for the Mirth Connect Administrator Launcher, the Mirth Connect Docker images, and several bug fixes and security improvements.
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?
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.
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.
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.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Comment