web stats
Write HL7 v2 to Excel? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2011, 03:42 PM
DimitriA DimitriA is offline
Mirth Newb
 
Join Date: Jul 2011
Posts: 17
DimitriA is on a distinguished road
Default Write HL7 v2 to Excel?

Hi, I'm very new to Mirth and I would really appreciate some help.

Is there anyway I can generate Excel files from the HL7 v2.* messages I receive?

I am currently converting them into XML and then opening the XML files in Excel, I was just wondering if there was a more direct method. Could I use the built in JavaScript or db functionality to do it?

Thank you all in advance!
Reply With Quote
  #2  
Old 07-14-2011, 10:16 PM
asulis asulis is offline
Mirth Guru
 
Join Date: Dec 2006
Location: Cagliari, Sardinia, Italy
Posts: 210
asulis is an unknown quantity at this point
Default

Hi Dimitri,
one solution could be to use a transformer with the "Delimited Text" as output data type, in order to map your message information inside a CSV file for example.
I 've never had the need to map HL7 message information to Excel, so I don't know if there is a better way to do this.
Regards
Alessandro
Reply With Quote
  #3  
Old 07-15-2011, 06:07 AM
Bostad Bostad is offline
Level 85 Channel Wizard
 
Join Date: Mar 2009
Location: Stratford Ontario
Posts: 712
Bostad is an unknown quantity at this point
Default

I prefer to do this programmatically in javascript using File.Util, but alot of people don't like to do things in javascript.

After setting your outbound datatype to Delimited Text and setting the properties appropriately, set up your destination.

If you set an outbound template in your transformer, you can use message builder transformers by clicking and dragging the node from your outbound template to the corresponding node in your inbound template.

Mirth will automatically map them for you.
Reply With Quote
  #4  
Old 07-15-2011, 08:58 AM
marmanold marmanold is offline
Mirth Newb
 
Join Date: Feb 2011
Location: Franklin, TN
Posts: 9
marmanold is on a distinguished road
Default Use JExcel API via Javascript

I would use the JExcel API via Javascript to write proper Excel 2003 files. This forum thread explains how to use Excel as a data source. The same methods for loading the library, etc. would be used for writing a file.
__________________
Michael Arnold| Electronic Data Interchange Specialist

PlayMaker CRM
Sales Innovation for Home Care
A Division of The ADAM Group
115 Southeast Parkway Court | Franklin, TN 37064
866.930.6847 | F: 866.232.6470 | PlayMakerCRM.com
Reply With Quote
  #5  
Old 07-15-2011, 09:02 AM
duggram duggram is offline
OBX.1 Kenobi
 
Join Date: Nov 2010
Location: ABQ, NM
Posts: 29
duggram is on a distinguished road
Default

If you read through this thread Excel As Data Source you will see where writing to Excel files is also covered.

Marmanold, you just beat me! BTW I work in Franklin also.

Last edited by duggram; 07-15-2011 at 09:04 AM. Reason: Comment on the dual post.
Reply With Quote
  #6  
Old 07-18-2011, 10:23 AM
DimitriA DimitriA is offline
Mirth Newb
 
Join Date: Jul 2011
Posts: 17
DimitriA is on a distinguished road
Default

Quote:
Originally Posted by Bostad View Post
I prefer to do this programmatically in javascript using File.Util, but alot of people don't like to do things in javascript.

After setting your outbound datatype to Delimited Text and setting the properties appropriately, set up your destination.

If you set an outbound template in your transformer, you can use message builder transformers by clicking and dragging the node from your outbound template to the corresponding node in your inbound template.

Mirth will automatically map them for you.
Thank you for the reply Bostad, but there's a lot I don't understand here. Like I said, I'm just getting started with Mirth. Could you explain or point me to an explanation about inbound/outbound templates and nodes? Thanks!
Reply With Quote
  #7  
Old 07-18-2011, 10:24 AM
DimitriA DimitriA is offline
Mirth Newb
 
Join Date: Jul 2011
Posts: 17
DimitriA is on a distinguished road
Default

Thank you marmanold and duggram! I'll check out that thread
Reply With Quote
Reply

Tags
database writer, hl7, hl7 to xml, write

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 10:20 PM.


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