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
[email protected]
God is my provider.
________________________________
From: Ola Hodne Titlestad <[email protected]>
To: Muhire Andrew <[email protected]>
Cc: Lars Helge Øverland <[email protected]>;
"[email protected]" <[email protected]>;
"[email protected]" <[email protected]>
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 <[email protected]>
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
>[email protected]
>God is my provider.
>
>
>
>
>
>________________________________
>From: Lars Helge Øverland <[email protected]>
>To: Muhire Andrew <[email protected]>
>Cc: [email protected]; [email protected]
>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 : [email protected]
>Unsubscribe : https://launchpad.net/~dhis2-users
>More help : https://help.launchpad.net/ListHelp
>
>
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
