dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Stephen, at the moment the only fast way to do that is to use a SQL
script, otherwise you must do it manually. Sorry for that.

E.g. for the period issue, something like:

update datavalue set periodid=A where periodid=B and sourceid=C and
dataelementid in ( select dataelementid from datasetmembers where
datasetid=D);

where
A=new periodid
B=old periodid
C=org unit id
D=data set id



Lars


On Mon, Oct 22, 2012 at 12:59 PM, Stephen Gbanyan <mambu9@xxxxxxxxx> wrote:
> Hi All,
>
> Can I get the command on how to move facility data that is entered in
> the wrong month to the correct month or moving the wrong facility that
> was entered to the right facilities.
>
> Thanks
> --
> __________________________________
> Stephen M. Gbanyan, Jr.
> Assistant Director
> Health Management Information System
> Ministry of Health and Social Welfare
> Republic of Liberia
> +231-886-847-915
> skype: mambu9
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp