ORU to database sample

[sarcophyton]

Does anyone have an ORU message to database writer channel that they wouldn't mind sharing? Just looking for a head start.

[mdehoog]

I've got a SIU to database (MSSQL) for you.

it does some other things also.

[upstart33]

I would recommend checking out this:

http://www.mirthcorp.com/webinars/mi...ect-screencast

It will give you a good basis and how to do it, amongst other things.

[sarcophyton]

Thanks for the quick replies! I am just being lazy, hoping for an some sample code which already slogs through the possible multiple OBR, OBX, NTE segments.

[Bostad]

for each (seg in msg..OBR)  {

//code here

}  

//repeat "for each" for each segment type you need

[glenn71]

Hey Sarco,

Did you get what you need? Can you supply the sql that you need to use?

In my case I had multiple stored procs that I had to build (e.g. one for each OBX & slightly different sproc for 'FT' OBX results)

In summary:
1. Build a dest transformer - iterated through the segments and built an array of SQL statements.
2. In the "DB Writer" connector - loop through the SQL array and execute each SQL statement.

The approach will differ depending on the SQL statements that you need to create.

[sarcophyton]

Yes, I have the code that I need. We are just trying to figure out how much we can flatten the database without losing anything essential.