[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] Country zones and i18n
From: |
Busser, Jim |
Subject: |
[Gnumed-devel] Country zones and i18n |
Date: |
Mon, 14 Nov 2011 22:36:10 +0000 |
I messed up on a large org import and as a result created numerous addresses
whose newly created cities (urbs) got mapped to a state abbreviation which did
not, in all cases, represent the state from the correct country (on account of
state abbreviations being not distinct across countries).
Anyhow, in my database, I deleted all
addresses
streets
urbs
states
except for those that were foreign-key referenced by
patients (persons)
clin.test_orgs
I then located
~/git/gnumed/gnumed/gnumed/server/sql/country.specific/ca/gmDemographics-Data.ca.sql
~/git/gnumed/gnumed/gnumed/server/sql/gmCountryZones.sql
and via psql recreated
Canadian provinces (which in the .ca file include an i18n french
translation)
American states (from GmCountryZones.sql)
Questions:
1) when issuing an sql command like
insert into dem.state (code, country, name) values ('AB', 'CA',
i18n.i18n('Alberta'));
--> does the i18n.i18n establish an original
'able-to-be-translated-term' despite that
no actual translation might be offered until some later time?
2) following the recreation of Canadian provinces I issued
select dem.gm_upd_default_states();
but when I tried to issue
-- do simple revision tracking
delete from gm_schema_revision where filename = '$RCSfile:
gmDemographics-Data.ca.sql,v $';
INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile:
gmDemographics-Data.ca.sql,v $', '$Revision: 1.5 $');
I got
ERROR: relation "gm_schema_revision" does not exist
?? is that obsolete (the Canadian sql was from 2006)
-- Jim
- [Gnumed-devel] Country zones and i18n,
Busser, Jim <=
- Re: [Gnumed-devel] Country zones and i18n, Busser, Jim, 2011/11/14
- Re: [Gnumed-devel] Country zones and i18n, Karsten Hilbert, 2011/11/15
- Re: [Gnumed-devel] Country zones and i18n, Busser, Jim, 2011/11/16
- Re: [Gnumed-devel] Country zones and i18n, Karsten Hilbert, 2011/11/16
- Re: [Gnumed-devel] Country zones and i18n, Busser, Jim, 2011/11/16
- Re: [Gnumed-devel] Country zones and i18n, Karsten Hilbert, 2011/11/16
- Re: [Gnumed-devel] Country zones and i18n, Busser, Jim, 2011/11/16
- Re: [Gnumed-devel] Country zones and i18n, Karsten Hilbert, 2011/11/16
- Re: [Gnumed-devel] Country zones and i18n, Busser, Jim, 2011/11/16