I am using DatabaseReader to read from my MySQL database and passing the data through a Transformer for transforming the SQL data into HL7 A28 message. For the transformation, I use Message Builder and do the following (for example):
Name: familyname
Message Segment: tmp['PID']['PID.5']['PID.5.1']
Mapping: msg['lastname'].toString()
Where 'lastname' is the SQL field which brings in the familyname. This used to work fine for sometime. But after adding and removing few other fields, the mapping entirely stopped working, even though i revereted to the earlier working version. I don't see any errors during transformation and messages are successfully sent to the FileWriter. When I look at the file written, the familyname field is blank, though my database has data.
I looked at the Mirth Dashboard and I see that the value for familyname is present in the xml data generated out of the source data. But during the transformation it is lost. Any pointers?
Name: familyname
Message Segment: tmp['PID']['PID.5']['PID.5.1']
Mapping: msg['lastname'].toString()
Where 'lastname' is the SQL field which brings in the familyname. This used to work fine for sometime. But after adding and removing few other fields, the mapping entirely stopped working, even though i revereted to the earlier working version. I don't see any errors during transformation and messages are successfully sent to the FileWriter. When I look at the file written, the familyname field is blank, though my database has data.
I looked at the Mirth Dashboard and I see that the value for familyname is present in the xml data generated out of the source data. But during the transformation it is lost. Any pointers?
Comment