web stats
Write inbound ACK to DB - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2017, 09:11 AM
tramos28 tramos28 is offline
What's HL7?
 
Join Date: Jan 2017
Location: Portugal
Posts: 2
tramos28 is on a distinguished road
Default Write inbound ACK to DB

I've started working with Mirth Connect (version 3.4.2.8129) very recently and I have a question. I'm using a TCP sender (MLLP) and I'd like to save the HL7 ACKs this sender gets into a SQL Server database. Is it possible?

Thanks.
Reply With Quote
  #2  
Old 01-03-2017, 09:23 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,123
narupley is on a distinguished road
Default

The ACKs you receive are already saved. Look at the "Response" content radio button in the message browser. If you want to take those and save them into a separate database yes that's possible too. If your destination is not queuing, you could just use a subsequent Database Writer destination that uses the response from the previous destination (e.g. "${d1.message}"). You could also use a response transformer, and either do the database work manually in JavaScript, or forward the response to a separate channel to do the work.
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
  #3  
Old 01-03-2017, 09:24 AM
clarksss clarksss is offline
OBX.2 Kenobi
 
Join Date: Jul 2013
Posts: 75
clarksss is on a distinguished road
Default

Yes it is possible, capture the repsonse/ACK data and pass that data via Stored Proc into your desired database/table
Reply With Quote
  #4  
Old 01-04-2017, 03:15 AM
tramos28 tramos28 is offline
What's HL7?
 
Join Date: Jan 2017
Location: Portugal
Posts: 2
tramos28 is on a distinguished road
Default

Thanks for the replies, I managed to get the result I was hoping for.
Reply With Quote
Reply

Tags
ack, database, response, save

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 08:34 AM.


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