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 <[email protected]> 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, <[email protected]> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Cheers, Knut Staring -- Cheers, Knut Staring
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
