Hello:
I am attempting to take Data from a SQL Server 2005 database (source) and insert it into a HL7 message that is sent to a FileWriter connector (destination). I am having a problem getting the data from the database into the message. I have sample message which I have pasted into a transformer in several places. I believe that I have tried every combination and cannot get this to work. I followed the advice someone gave on a previous post and used a "message builder" to map the values from the database. However, this only appends the value. Here is an example of what should happen:
This is my select statement:
Select patientLastName FROM tbl_patients
WHERE updateDateTime > (GETDATE()-5)
This is the raw data output:
<?xml version="1.0" encoding="UTF-8"?>
<result>
<patientlastname>PatientName</patientlastname>
</result>
I should have this in one of my HL7 message "segments":
PID|1||2^||PatientName^CHRISTINE^^||19400110|F||4|234 RT 2 BOX 270^APT#292^MARKS^MS^28643^^^^||5893165873|8471259 148|||||698593453||||||||||||
Instead, I am just getting the original value where PatientName is. Is there a way to insert the database value into the HL7 message using a transformer? Can someone tell me how?
Thanks
Larry
I am attempting to take Data from a SQL Server 2005 database (source) and insert it into a HL7 message that is sent to a FileWriter connector (destination). I am having a problem getting the data from the database into the message. I have sample message which I have pasted into a transformer in several places. I believe that I have tried every combination and cannot get this to work. I followed the advice someone gave on a previous post and used a "message builder" to map the values from the database. However, this only appends the value. Here is an example of what should happen:
This is my select statement:
Select patientLastName FROM tbl_patients
WHERE updateDateTime > (GETDATE()-5)
This is the raw data output:
<?xml version="1.0" encoding="UTF-8"?>
<result>
<patientlastname>PatientName</patientlastname>
</result>
I should have this in one of my HL7 message "segments":
PID|1||2^||PatientName^CHRISTINE^^||19400110|F||4|234 RT 2 BOX 270^APT#292^MARKS^MS^28643^^^^||5893165873|8471259 148|||||698593453||||||||||||
Instead, I am just getting the original value where PatientName is. Is there a way to insert the database value into the HL7 message using a transformer? Can someone tell me how?
Thanks
Larry
Comment