web stats
is there a way to generate a source /destination report?? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2014, 07:57 AM
satishs satishs is offline
OBX.2 Kenobi
 
Join Date: Jun 2012
Location: Mumbai,India
Posts: 59
satishs is on a distinguished road
Post is there a way to generate a source /destination report??

Hi,

I have a requirement to export socket server details to an excel file with Channel Name, Source (What kind of source it is ip and port incase of a llp listener),Destination (What kind of destination it is ip and port incase of a llp listener or ftp).
I went to the DB but the properties are in a xml file format.

Any help in regards to this would be great.

Regards,
Satish Singh
Reply With Quote
  #2  
Old 03-05-2014, 09:34 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,235
cory_cole is on a distinguished road
Default

You can create a channel that will pull the XML from the database and parse through it to generate the report.
Reply With Quote
  #3  
Old 03-05-2014, 01:55 PM
glenn71 glenn71 is offline
OBX.3 Kenobi
 
Join Date: Nov 2010
Location: Sydney Australia
Posts: 129
glenn71 is on a distinguished road
Default

See attached channel.. that is written for v3. It produces two report files:
1. channelreport - summary of each channel and the destinations (type of destination and connection details).
2. portlist - summary of listening ports on mirth itself.

To deploy..
1. configure the smb paths & user accounts (you need a input directory and archive & report directories).
2. export all channels in mirth to the input directory (the channel reads in these xml files).

If you want a csv form you will just need to adjust the output variable (msgtxt).
Attached Files
File Type: xml _MIRTH_CHANNEL_RPT.xml (28.5 KB, 211 views)

Last edited by glenn71; 03-05-2014 at 02:18 PM.
Reply With Quote
  #4  
Old 09-26-2016, 12:15 PM
jg12345 jg12345 is offline
OBX.3 Kenobi
 
Join Date: Oct 2012
Posts: 105
jg12345 is on a distinguished road
Default

This report is great. How would I include the Channel Description found under the Summary tab?

Thanks
Reply With Quote
  #5  
Old 10-14-2016, 12:07 PM
jg12345 jg12345 is offline
OBX.3 Kenobi
 
Join Date: Oct 2012
Posts: 105
jg12345 is on a distinguished road
Default

I pulled channel description from here:
msg['description'].toString();

Is there a list of all Mirth embedded names? This is extremely helpful when pulling data for reports.

Example:
Channel Name: msg['name']
Destination Name: msg['destinationConnectors']['connector']['name']
etc...
Reply With Quote
Reply

Tags
channel export, channel report

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:25 PM.


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