dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi again, I'm assuming the orgunit and dataelement IDs are the same as in
our SL demo (http://208.76.222.114/dhis_sl). This is a big assumption, but
anyway your db will suffer no harm if it's not the fully the case.

Right click on the following link and save the file, then unzip it somwhere
and make a note of the path.

http://208.76.222.114/files/MIN_MAX.7z

Open PgAdmin III, select the SL database and click on the SQL icon in the
top row. Then paste in the below command, but substitute your own filepath.
Note that the slashes go forward and not backwards as usually on Windows:

COPY minmaxdataelement FROM 'F:/HISP/SL/MIN_MAX.csv' USING DELIMITERS ','

Knut


On Tue, May 19, 2009 at 5:33 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

Basically, you need to add rows to the minmaxdataelement tabls, which means
a bunch of INSERT statements. I can try to generate it.

Knut



On Tue, May 19, 2009 at 5:06 PM, <johansa@xxxxxxxxxx> wrote:

Hi,

In Sierra Leone, none of the orgunits have defined min-max ranges yet, and
the historical data is too poor to be used for calculation of such ranges
yet. Still, there have been some instances of really bad typos, such as
775 instead of 75. Most entries (maybe around 98%) are below 100, so as a
temporary shield we would like to set default ranges as 0-99 (to catch all
three-digit entries). Any clue on how to do this? Would running a query
directly on the database solve it, and what would that query look like?
(sorry, but not good at SQL)

Johan


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp





-- 
Cheers,
Knut Staring





-- 
Cheers,
Knut Staring