← Back to team overview

dhis2-users team mailing list archive

Re : Dear Dhis2 users how can i delete?

 

Dear team,
i have try to remove data element in the system,because it contain some data,it just refused.i have also used  a command  to delete those data,but no result.
this is the commad i used.  delete from datavalue where dataelementid=1906
when i run this command no problem,but when i back in interface on data entry see the error i get;Data element with id : 1906 does not exist because i removed it.of cause i don't wont it.but after using command delete it also asked to delete this code in dataelement.i did it.after do it, i also get the same error.and then on dataset when i open form.i get this error:

Sorry! The system failed to execute the operation. Usually, no data 
is lost and you can continue working by going back to the previous page. If you wish to report the incident, please save this page by choosing 
"File -> Save (page as)" in your browser and include the saved page 
in the report. The problem details are listed below. 
[+] Exception (java.lang.NullPointerException): null: but i have done a backup no problem. i want your help may be i m making error while using this code.








________________________________
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

Follow ups

References