for me email is the best as all social sites are blocked at my campus.


could you please give me direct online link from where I can start... whatever I could find is that how to build new HL7 message rather than retrieving data from HL7 message file and putting in columns in SQL Server.



I am using Ensemble where I can see the HL7 message (2.4) definition but as I am not familiar with libraries or C# programming... needs to use data services or sql server to extract the data into columns in sql table.

hope this helps..

sorry dear... I can't understand.

could you please point me to the steps require to put data in columns..

see below test HL7 message:-

PID|||0123994567^^^^^NH||TEST^PINK^""^^""||12345678|M|||QUEEN STREET^BLK FLAT1 KIRTI ST^ENGLAND^^A110BP^^P|||||2|||||||||||||""|N
PD1|||^12345/1^12345/1|1234567/123456^A BLUE^PURPLE

like after PID 01234567 show go as ID and test go as forename, pink go as surname..


Thanks will go through the guidelines... but does HL7 messages comes as single file in the column or data will be separated in each column.



thanks for replying... sorry I am not familiar with cache much... sorry If I misunderstood are you saying that HL7  message file is in the form of sql table which means that each column data in HL7 message file is in the separate column in sql table?

If my understanding is wrong then is there any HL7 Schema definition file same what we have when we render the data from XML files.?

Please help