Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

rookie question on mssql source to xml

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

  • rookie question on mssql source to xml

    Hello,

    I'm new to Mirth. I'd like to know if any one has had experience transforming a simple sql select statement from mssql into a clean xml file without the <?xml version="1.0" encoding="utf-8"?> before each row of data in the output to a text file using filewriter?

    Thanks,

    Joe

  • #2
    Re:rookie question on mssql source to xml

    joeluisdlg wrote:
    Hello,

    I'm new to Mirth. I'd like to know if any one has had experience transforming a simple sql select statement from mssql into a clean xml file without the <?xml version="1.0" encoding="utf-8"?> before each row of data in the output to a text file using filewriter?

    Thanks,

    Joe
    Before each row??

    Can you post a sample of the data?
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment


    • #3
      Re:rookie question on mssql source to xml

      my output was looking like the example below, but I have figure out how to remove the <?xml version="1.0" encoding="utf-8"?> tag line.

      Does any one know how to make the output file have a beginning and ending tag like <data></data> or <record></record> so an xhtml file can read the output into a table?

      <?xml version="1.0" encoding="utf-8"?>
      <result>
      <num></num>
      <nickname></nickname>
      <title1></title1>
      <longdescription></longdescription>
      <constituent_id></constituent_id>
      <suffix2></suffix2>
      <middle_name></middle_name>
      <last_name></last_name>
      <suffix1></suffix1>
      <title2></title2>
      <first_name></first_name>
      <id></id>
      </result>
      <?xml version="1.0" encoding="utf-8"?>
      <result>
      <num></num>
      <nickname></nickname>
      <title1></title1>
      <longdescription></longdescription>
      <constituent_id></constituent_id>
      <suffix2></suffix2>
      <middle_name></middle_name>
      <last_name></last_name>
      <suffix1></suffix1>
      <title2></title2>
      <first_name></first_name>
      <id></id>
      </result>

      Comment

      Working...
      X