> > Strategically (or at least tactically) the earlier interest is
> > identifying how we might get the Excelleris XML-wrapped HL7 lab data
> > into the GNUmed backend. It sounded like Richard might assist us
> > with that in a couple of weeks.
> OK, I can do this now. What I need help with is where to put the data.
> Is it possible for you to provide me with pseudo code which takes the
> Excelleris HL7 data and inserts it into the correct table?
>
> So for the pseudo code assume you have the HL7 parsed and make up
> variables with HL7 ish names.
>
> ie
>
> insert into foo (firstName .....) values (PID.patientFirstName....)
I have no more than passing knowledge of what HL7 actually contains. Give
me a list of the HL7 fields you deliver and what they mean. Then I can
tell you where to put them. It needn't be complete. Just something to
work with for now.
The above would sort of go like this:
insert into dem.names (
firstnames, ...
) values (
PID.patientFirstName, ...
)
where
fk_identity = ...
;
fk_identity is a foreign key into dem.identity.
The schema is here for your reference:
http://wiki.gnumed.de/bin/view/Gnumed/DatabaseSchema
Preferably access the devel schema (v8).
Karsten
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
