dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Calle,
You should probably be very careful about the removal of the favorites. As
Lars pointed out to me some time ago, the "sort_order" column in certain
database tables (like chart_datadimensionitems) form a set. When one of
these is deleted by hand, it will result in a null pointer exception when
the favorite is loaded again. The fundamental problem is that the deletion
handler is not able to resolve this situation. I wrote some SQL to deal
with the removal of organisatoin units (
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql)
and I think this could be pretty easily adapted to your use case, and may
be better than trying to delete things by hand. Ultimately though I think,
the deletion handler should be able to deal with this (or at the very
least, inform you which favorites are causing the deletion to fail), but
its something which is potentially very destructive, and should not be done
that frequently, so maybe an SQL script is a better option just to be sure
that major chaos does not ensue when a data element is deleted by mistake.

Best regards,
Jason


On Fri, Dec 4, 2015 at 9:41 AM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
wrote:

> Hi,
>
> OK, I just found out that the "Prevent this page from creating additional
> dialogs" came back when re-starting Chrome. What I still do not understand
> is that ticking that option actually disabled the REMOVE option completely
> (as in no longer working).
>
> I got no problem with blocking the removal of data elements with DATA, by
> the way, but removals are also blocked if a data element is used in any
> kind of report or chart. And the system does not tell you WHICH report (it
> just refers to object ReportTable), so I end up having to track it through
> datadimensionitems etc in the database itself to identify which reports or
> charts are affected (there are a few hundred favourites in the instance),
> then modify those, then go back, try to delete again, now being told it
> cannot because it's linked to to objects of type Chart, etc.
>
> Is there a simpler way in UI to determine WHICH reports and charts that
> contain a specific data element or indicator? Or even better, a simpler way
> to remove a specific data element or indicator from all charts and reports
> using them?
>
> Regards
> Calle
>
>
>
>
>
> On 4 December 2015 at 09:41, Lars Helge Øverland <larshelge@xxxxxxxxx>
> wrote:
>
>> Hi Calle,
>>
>> assuming your are using Chrome. This is a browser feature. The option is
>> "Prevent this page from creating additional dialogs" to prevent misbehaving
>> web sites. It it enough to close the browser and open it again.
>>
>> Lars
>>
>>
>> On Fri, Dec 4, 2015 at 8:00 AM, Olav Poppe <olav.poppe@xxxxxx> wrote:
>>
>>> Hi,
>>> regarding the popup, I think that is a browser (Chrome and possibly
>>> others) feature - if there are multiple similar(?) popups, it will ask you
>>> if you want to ignore all. I though this was only a one-time thing and that
>>> they would not disappear permanently, but not sure about this.
>>>
>>> Olav
>>>
>>>
>>> 4. des. 2015 kl. 06.21 skrev Jason Pickering <
>>> jason.p.pickering@xxxxxxxxx>:
>>>
>>> Hi Calle,
>>>
>>> This is the important part "the data element cannot be deleted because
>>> it's linked to this or that object."
>>>
>>> The deletion handler cannot delete data elements if the data element is
>>> linked to certain objects which is cannot handle deleting, like if the data
>>> element is linked to data. The data would need to be deleted, followed by
>>> the data element.
>>>
>>> Also, I am not really sure about the popup. There is nothing which I can
>>> see which can turn this off. Are you sure this is not some sort of popup
>>> blocker on your browser?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Thu, Dec 3, 2015 at 8:30 PM, Calle Hedberg <calle.hedberg@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi
>>>>
>>>> I've been deleting a number of data elements using the normal user
>>>> interface - since the confirmation popup every time was a bit annoying, I
>>>> clicked the "do not show this again" (or whatever the popup tick-box was
>>>> called).
>>>>
>>>> The confirmation popup has disappeared - and I cannot see any reference
>>>> in the user manual to how to get it back - but more importantly the
>>>> deleting no longer works. No messages, no "deleting....", not even any
>>>> error messages that the data element cannot be deleted because it's linked
>>>> to this or that object.
>>>>
>>>> Is this a bug?
>>>>
>>>> How do I turn the confirmation popup back on, since it's seems to be
>>>> compulsory for it to work?
>>>>
>>>> Regards
>>>> Calle
>>>>
>>>> *******************************************
>>>>
>>>> Calle Hedberg
>>>>
>>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>>
>>>> Tel/fax (home): +27-21-685-6472
>>>>
>>>> Cell: +27-82-853-5352
>>>>
>>>> Iridium SatPhone: +8816-315-19119
>>>>
>>>> Email: calle.hedberg@xxxxxxxxx
>>>>
>>>> Skype: calle_hedberg
>>>>
>>>> *******************************************
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> tel:+46764147049 <+46764147049>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> http://www.dhis2.org <https://www.dhis2.org>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049