Moving data from one period to another

Support - Assistance technique
1

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

2

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@gmail.com> 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: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help