Handling acknowledgment after sending data

Hi all.
I am currently learning IGUANA. i have a senario but do not know how to start.
Suppose i have a channel with database as source and LLP as destination
The channel workflow is
1- Polling database every 1 min
2- Check if there are a new data in a table (say patient table).
3- Loop over new data and send it to the LLP
4- Update the sent record if i received ok ACK e.g update flag to indicate that the record was send.

My question is about 2 and 4,
how to loop and send data rows one by on?
how to handle the returned ACK from LLP for every row?

Regards

The only option currently available is to handle the LLP connection inside the translator. You can do this in your “From Translator” source, a filter, or a “To Translator” destination, depending on how synchronous your database/ACK handling needs to be. iNTERFACEWARE has created a module to do just that; you can find more information at this link.

Specifically regarding questions 2 and 4: A result set returned from a database query is an ordered list and you can iterate over the rows with a simple for loop. inside the loop, you’d populate the HL7 message from each row, send the populated message to the external application, receive and parse the returned ACK message, then update the database record to indicate that the message transmission was successful or not.

A little bit of coding involved, but that’s what makes Iguana fun 🙂

Jeff Drumm ◊ VP and COO ◊ HICG, LLC. ◊ http://www.hicgrp.com

Thank you Jeff, thats help me 🙂