web stats
Sql xml to delimited text without Java? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 05-01-2019, 03:00 PM
ezpeezy ezpeezy is offline
What's HL7?
Join Date: Apr 2019
Posts: 1
ezpeezy is on a distinguished road
Default Sql xml to delimited text without Java?

I'm playing around with a simple channel which I want to read sql and exports all rows as 1 csv file with all the results each time it runs.

I have it setup as such:
source datatype in=xml, out=Delimited text
Destination in=Delimited text, out=Delimited text.

Source is basic select from table
with trasformer mapping from each xml segment to the delimited text segment.

I am running into two issues.

1. It treats each row processed as a new message in the channel. I would rather it process all rows as 1 message. (note if I select Aggregate Results then nothing passes through when transformed and all I get are commas)

2. It exports only the last row if I have ovewrite selected. Or more accurately it overwrites the rows till the last row is reached and that's all that is left in the csv file.

If I have append selected then it just keeps addidng rows each time the process started.

Anyway to accpmplish what I want with the built in functions using the latest 3.7 release?
Reply With Quote

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 12:02 AM.

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