← Back to team overview

dhis2-users team mailing list archive

Re : Dear Dhis2 users how can i delete?

 




________________________________
Tanks Knut for update.i think we shall adapt it in our country as soon as possible, since it working in others countries.  











De : Knut Staring <knutst@xxxxxxxxx>
À : Muhire Andrew <muhireandrew@xxxxxxxxx>
Cc : "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>; Ola Hodne Titlestad <olati@xxxxxxxxxx>; "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Envoyé le : Mercredi 14 Septembre 2011 20h16
Objet : Re: [Dhis2-users] Dear Dhis2 users how can i delete?


On Wed, Sep 14, 2011 at 7:02 PM, Muhire Andrew <muhireandrew@xxxxxxxxx> wrote:

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?
>


Hi Andrew,

The existing mobile solutions are based on J2ME clients, and are already
 quite useful. The field introduction has so far mostly been SMS based, 
but we feel that mobile internet (GPRS, 3G) will be a better option in 
most cases. It is still early days, and I am involved in the planning of
 future solutions. We hope to have a first version of a WAP or Opera 
Mini type solution for simple facility reporting (aggregate date) as 
part of the 2.5 release in October. Quite a bit more development is 
planned for the next 6 months, which will also touch on name based 
solutions (DHIS Tracker).

You should probably await these new developments, becasue they will 
hopefully be both more stable and flexible than the current solution. 
Also, before introducing any mobile solutions, it is quite important to 
implement a solid DHIS2 back bone, and make sure the roll out works 
well. So I think this should wait until after the switch to DHIS2 as the
 new HMIS.

Knut

 
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
>>
>>
>
>
>
>_______________________________________________
>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
>
>


-- 

Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522

_______________________________________________
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

References