web stats
Adding Header into CSV file - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
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


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
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

There is. It is inside the data type properties on the inbound/outbound message templates.
HL7v2.7 Certified Control Specialist!
Reply With Quote
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

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

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