gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...
Date: Wed, 23 Jan 2008 22:43:26 +0100
User-agent: Mutt/1.5.17 (2007-11-01)

On Thu, Jan 24, 2008 at 08:06:19AM +1100, Richard wrote:

> Then return to the transformer sql window. The connect string for postgres is 
> 
> jdbc:postgresql://localhost:5432/hl7testing

That would eventually be "gnumed_vX" where X is the current
schema version.

> and the sql which you can either construct and verify in postgres looks 
> something like this:
> 
> INSERT INTO haps_patients (firstname,surname) values (
>       ${patientIdentification_patientName_familyName},
>       ${patientIdentification_patientName_givenName}
> );

In GNUmed would this be:

insert into dem.names (firstnames, lastnames) values (
        ${patientIdentification_patientName_familyName},
        ${patientIdentification_patientName_givenName}
);

but it still lacks the value for the foreign key to the
identity table.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346




reply via email to

[Prev in Thread] Current Thread [Next in Thread]