← Back to team overview

dhis2-users team mailing list archive

Re: can't delete data element

 

Thanks Knut....very important.

On 18 November 2016 at 09:35, Knut Staring <knutst@xxxxxxxxx> wrote:

> This should be obvious, but better to remind people one time too much:
> If you decide to run DELETE queries, please always remember to first do a
> backup (pg_dump).
>
> On Nov 18, 2016 8:27 AM, "channara rin" <rin.channara@xxxxxxxxx> wrote:
>
>> Note thank you....
>>
>> On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman <ant@xxxxxxxx> wrote:
>>
>>> Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS -
>>> data administration) but you cannot update or delete using SQLVIEW, so in
>>> this case you would have to do it in the "back-end". What you could do to
>>> make sure is use SQLVIEW to see if that dataelementid exists in the
>>> datavalueaudit table. Something like "select * from datavalueaudit where
>>> dataelementid = .......... ".
>>>
>>> Regards
>>>
>>> Ant Snyman
>>>
>>> On 18 November 2016 at 09:10, channara rin <rin.channara@xxxxxxxxx>
>>> wrote:
>>>
>>>> ohh,i see...
>>>> but sql script can only run on server? cannot from client side?
>>>>
>>>> On Fri, Nov 18, 2016 at 2:08 PM, Ant Snyman <ant@xxxxxxxx> wrote:
>>>>
>>>>> Hi Channara,
>>>>> There is also a table called datavalueaudit which also contains a
>>>>> reference to the dataelementid. The record should also be deleted from this
>>>>> table, I normally do it through sql script, not sure if deleting a
>>>>> datavalue from the UI will also remove the datavalueaudit record.
>>>>> Regards
>>>>> Ant Snyman
>>>>>
>>>>>
>>>>> On 18 November 2016 at 06:38, channara rin <rin.channara@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> yes,
>>>>>> my DE use cate-combo and group.
>>>>>> so after remove group, i can delete?
>>>>>>
>>>>>>
>>>>>> On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT <ptb3000@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Channara,
>>>>>>>
>>>>>>> Did you assign it an option set or cat-comb or grouped it in a group
>>>>>>> or even assigned it to a dataset or program,
>>>>>>>
>>>>>>> You have to check all these before deleting it.
>>>>>>>
>>>>>>> Regards
>>>>>>>
>>>>>>> Prosper Behumbiize, MPH
>>>>>>> DHIS2 Implementation| HISP Uganda/University Of Oslo
>>>>>>> +256 752 751 776 | +256 776 139 139
>>>>>>> prosper@xxxxxxxxxxxxxx <ptb3000@xxxxxxxxx> | prosper@xxxxxxxxx | Skype:
>>>>>>> prospertb
>>>>>>>
>>>>>>> On Fri, Nov 18, 2016 at 5:04 AM, channara rin <
>>>>>>> rin.channara@xxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> dear friend,
>>>>>>>> i created new dataset and put only data element want to delete and
>>>>>>>> then go through to delete data value already.
>>>>>>>> but i still see the message like below:
>>>>>>>> [image: Inline image 1]
>>>>>>>>
>>>>>>>> On Fri, Nov 18, 2016 at 9:02 AM, Shurajit Dutta <
>>>>>>>> shurajitdutta@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Hi Channara,
>>>>>>>>>
>>>>>>>>> You would have to delete all the values associated with that DE
>>>>>>>>> first.
>>>>>>>>>
>>>>>>>>> On Fri, Nov 18, 2016 at 9:43 AM, channara rin <
>>>>>>>>> rin.channara@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> dear all,
>>>>>>>>>> do you know how to delete data element that we already used input
>>>>>>>>>> data value?
>>>>>>>>>>
>>>>>>>>>> regards,
>>>>>>>>>> channara
>>>>>>>>>>
>>>>>>>>>> _______________________________________________
>>>>>>>>>> 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
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Shurajit Dutta
>>>>>>>>> Health Information Consultant
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> *Ant Snyman*
>>>>>
>>>>> *Cell: 0824910449*
>>>>>
>>>>> *Landline: 028 2713242*
>>>>>
>>>>>
>>>>> Health Information Systems Program - SA
>>>>>
>>>>> *This message and any attachments are subject to a disclaimer
>>>>> published at http://www.hisp.org/policies.html#comms_disclaimer
>>>>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>>>>> disclaimer before opening any attachment or taking any other action in
>>>>> terms of this electronic transmission.  If you cannot access the
>>>>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>>>>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>>>>> this e-mail or opening any attachment you agree to be bound by the
>>>>> provisions of the disclaimer.*
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> *Ant Snyman*
>>>
>>> *Cell: 0824910449*
>>>
>>> *Landline: 028 2713242*
>>>
>>>
>>> Health Information Systems Program - SA
>>>
>>> *This message and any attachments are subject to a disclaimer published
>>> at http://www.hisp.org/policies.html#comms_disclaimer
>>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>>> disclaimer before opening any attachment or taking any other action in
>>> terms of this electronic transmission.  If you cannot access the
>>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>>> this e-mail or opening any attachment you agree to be bound by the
>>> provisions of the disclaimer.*
>>>
>>
>>
>> _______________________________________________
>> 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
>>
>>


-- 

*Ant Snyman*

*Cell: 0824910449*

*Landline: 028 2713242*


Health Information Systems Program - SA

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
<http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclaimer@xxxxxxxx 
<disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*

PNG image


References