← Back to team overview

dhis2-users team mailing list archive

Re: 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 programsfeatures  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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>
>
> 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

Follow ups

References