← Back to team overview

dhis2-users team mailing list archive

Re: Dear Dhis2 users how can i delete?

 

Great! thanks Knut for the updates.

 




________________________________



Muhire Andrew

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



________________________________
From: Knut Staring <knutst@xxxxxxxxx>
To: Muhire Andrew <muhireandrew@xxxxxxxxx>
Cc: Ola Hodne Titlestad <olati@xxxxxxxxxx>; "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>; "dhis2-devs@xxxxxxxxxxxxxxxxxxx" <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Sent: Wednesday, September 14, 2011 8:16 PM
Subject: 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

References