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

Hi

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.

Regards

hi

Is this course are you talking about?

https://learning.intersystems.com/course/view.php?name=Building%20and%20Managing%20HL7%20Productions

I don't have any programming tool installed on my machine and not much experience with coding... I am business analyst who has been given the file to extract the data and put it into the sql server so that people can understand the data easily..

regards

hi

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:-

MSH|^~\&|||||20000211120000||ADT^A28|012345678|P|2.4
EVN||20000211120000
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..

Hi

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.

regards

Hi

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

regards