how to feed already HL7 encoded msgs from database onto listener or flat file

[gazetaj]

I have been trying to get already encoded msgs that are on a database (mySQL) and send them to a listener. I can't manage to find a way to send them for some reason.

if anyone has done this or know how to please help!

I've tried the message.rawData and also message.encryptedData

with scripts like this one or variants of the same:

var tmsg = er7util.ConvertToXML(msg['MSG']);
hl7_xml = tmsg;
message.encodedData = tmsg;
return true;

also tried to use ${message.encodedData} and HL7 builder to pass the "msg['MSG']" but to no use.

What I find interesting is that after starting the channel there are no packages on the statistics, no errors on the logs and no errors on the console screen.

- we use linux here.

if anyone can help, please reply.

Best regards to all.

[chrisl]

Re: how to feed already HL7 encoded msgs from database onto listener or flat file

What is your channel setup? What do you have for your source connector?

-Chris

[is980491]

Re: how to feed already HL7 encoded msgs from database onto listener or flat file

Do we solve this problem?

I also need to feed a HL7 string retrieved from DB and send out to outbound as it is.

Thanks,
Charles

[is980491]

Re: how to feed already HL7 encoded msgs from database onto listener or flat file

Previously, I used the following code.

var inxml = serializer.toXML(msg['hl7msg'].toString());
tmp = inxml;

It works well except the the following A17 message. Looks like the XML to HL7 encoding transformation get some problems.



MSH|^~\&|REG|HH|BizTalk|HH|date||ADT^A17|100028|P| 2.2
EVN|A17|20061106184824|||SSN
PID|....
PV1|....
PV2||SRM|PREGNANCY
PID|.....
PV1|....
PV2||ASSESS|PREGNANCY
ZIB|1|M|||||||||||||||||||||BCHP
ZIB|2|SP|||||||||||||||||||||SELF
Z01||WAL||||||||1||8:17 AM|PREGNANCY||50|000000||||N
ZTM||1||N|||||YES|||||YES|N||NO|D|D|NO|NO

It turns out as following which is wrong. I got extra PID22, PV122 and PV222 segments which of course causes some problems.

MSH|^~\&|REG|HH|BizTalk|HH|20061106184824||ADT^A17 |100027|P|2.2
EVN|A17|20061106184824|||SSN
PID|....
PV1|....
PV2||SRM|PREGNANCY
PID|.....
PV1|.....
PV2||SRM|PREGNANCY
PID|||.....
PV1|.....
PV2||ASSESS|PREGNANCY
PID22|||.....
PV122||.....
PV222||ASSESS|PREGNANCY
ZIB|1|M|||||||||||||||||||||BCHP
ZIB|2|SP|||||||||||||||||||||SELF
Z01||WAL||||||||1||8:17 AM|PREGNANCY||50|000000||||N
ZTM||1||N|||||YES|||||YES|N|

[is980491]

Re: how to feed already HL7 encoded msgs from database onto listener or flat file

Hi,
I did another test today. I sent in the message from a MLLP sender program with the same A17 message in to a inbound channel which does nothing but forward the message to another MLLP receiver. I defined no transformers and filters.

The result is the same. The extra PID22, PV122 and PV222 show up.

Please advise how to get rid of those unexpected segments.

Thanks,

Charles

[chrisl]

Re: how to feed already HL7 encoded msgs from database onto listener or flat file

This is fixed in the next release - you will be able to define the output data on the LLP sender.

-Chris