[Top][All Lists]
[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
- [Gnumed-devel] Mirth setup, versions etc was Lab importing ...., Dave Cramer, 2008/01/22
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...., Karsten Hilbert, 2008/01/22
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...., Dave Cramer, 2008/01/22
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...., richard terry, 2008/01/22
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...., Dave Cramer, 2008/01/23
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., richard terry, 2008/01/23
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...,
Karsten Hilbert <=
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., Dave Cramer, 2008/01/23
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., Karsten Hilbert, 2008/01/23
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., richard terry, 2008/01/23
- [Gnumed-devel] Re: Mirth setup, versions etc was Lab importing ..., Andreas Tille, 2008/01/24
- Re: [Gnumed-devel] Re: Mirth setup, versions etc was Lab importing ..., richard terry, 2008/01/24
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., J Busser, 2008/01/24
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., James Busser, 2008/01/31
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., Dave Cramer, 2008/01/31
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ..., richard terry, 2008/01/31
- Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...., James Busser, 2008/01/22