I have managed to get Mirth to populate an HL7 file into my SQL Server database. The problem however is that, it's not inserting the proper values. The mapping seems to be correct, coz, when I view the message under "source" it seems to have picked up the right data but while inserting the data, instead of inserting the acutal values, it seems to be inserting values like ${PID},${L_Name},${F_Name},${MI}. It's not inserting the actual PID, Last Name, First Name etc. Below is my SQL statement. Also, in the destination tab, I don't see PID, L_Name, F_Name and MI under Destination Mappings.
INSERT IGNORE INTO PatDemo(PID, L_Name, F_Name, MI) VALUES (${PID},${L_Name},${F_Name},${MI});
Also, when I open up the database, instead of seeing one record, I see like 300 records! I should be seeing only 1 record since, I am only inputing data from one HL7 file.
I would appreciate your help very much. Thanks.
INSERT IGNORE INTO PatDemo(PID, L_Name, F_Name, MI) VALUES (${PID},${L_Name},${F_Name},${MI});
Also, when I open up the database, instead of seeing one record, I see like 300 records! I should be seeing only 1 record since, I am only inputing data from one HL7 file.
I would appreciate your help very much. Thanks.
Comment