dhis2-devs team mailing list archive

[Muhire Andrew <muhireandrew@xxxxxxxxx>]

Dear team,
                  In Dar es salaam workshop some of the countries were doing pilot on using Mobile  reporting and Benificiary and programs features  in dhis2 [how is it running in the countries that has started using it] ? Tanzania how is it? I think  this will be our next step in Rwanda!
How can i link with the team that is working on mobile part?
thanks





________________________________



Muhire Andrew

HMIS/Ministry of Health
andrew.muhire@xxxxxxxxxx
God is my provider.



________________________________
From: Ola Hodne Titlestad <olati@xxxxxxxxxx>
To: Muhire Andrew <muhireandrew@xxxxxxxxx>
Cc: Lars Helge Øverland <larshelge@xxxxxxxxx>; "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>; "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Sent: Monday, September 12, 2011 9:58 PM
Subject: Re: [Dhis2-users] Dear Dhis2 users how can i delete?


Hi,

The only two commands you should run on your database are the two delete statements;
delete from datavalue_audit where dataelementid=<id>;
delete from datavalue where dataelementid=<id>;

"Replace" is not a command, just Lars telling you to change the <id> in the two commands above with the real IDs of your data elements.

Seems all is fine then. You can now try deleting the data elements from the DHIS 2 user interface.

Ola
------

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University
 of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 
0685 Oslo, Norway. Googlemaps link



2011/9/12 Muhire Andrew <muhireandrew@xxxxxxxxx>

Thanks for the quick help,
>i have successfully used the select and delete steps(in datavalues and datavalue_audit) but using replace <id> is not working on my side may be am not using it well? please update me again (only replace syntax). i have deleted data from my data element x and next step was to use replace but am getting syntax error!
>waiting for your help dear team!
> 
>
>
>
>
>________________________________
> 
>
>
>Muhire Andrew
>
>HMIS/Ministry of Health
>andrew.muhire@xxxxxxxxxx
>God is my provider.
>
>
>
>
>
>________________________________
>From: Lars Helge Øverland <larshelge@xxxxxxxxx>
>To: Muhire Andrew <muhireandrew@xxxxxxxxx>
>Cc: dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
>Sent: Monday, September 12, 2011 3:51 PM
>Subject: Re: Dear Dhis2 users how can i delete?
>
>
>Hi Andrew,
>
>you need to remove the data with SQL in the database. Run:
>
>delete from datavalue_audit where dataelementid=<id>;
>delete from datavalue where dataelementid=<id>;
>
>and replace <id> with the dataelementid of the one you want to remove.
>
>You can then go ahead and delete the data element in the user interface.
>
>
>
>Lars
>
>
>
>_______________________________________________
>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
>
>