web stats
Adding Header into CSV file - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-10-2018, 12:47 PM
luis.lay luis.lay is offline
What's HL7?
 
Join Date: Apr 2012
Posts: 2
luis.lay is on a distinguished road
Default Adding Header into CSV file

Hello,

I have a channel in v3.6.1 that creates a CSV file from database reader query. I need the CSV to show the query headers. If I add it the template destination (file writer), it adds the header per row. Is there a way to just add it once?
Reply With Quote
  #2  
Old 10-10-2018, 08:47 PM
siddharth siddharth is offline
Mirth Guru
 
Join Date: Feb 2013
Posts: 822
siddharth is on a distinguished road
Default

There is. It is inside the data type properties on the inbound/outbound message templates.
__________________
HL7v2.7 Certified Control Specialist!
Reply With Quote
  #3  
Old 10-12-2018, 08:30 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 476
agermano is on a distinguished road
Default

It's easy if you are using mirth 3.5+ and your result set is small enough that you can aggregate results. It's a little more difficult if you are processing one row at a time and appending to the file. What kind of database are you querying from?
Reply With Quote
Reply

Tags
csv headers

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 01:24 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Mirth Corporation