← Back to team overview

dhis2-devs team mailing list archive

Re: Restriction of the analytics process to certain time periods

 

Fixed now in trunk, year 1800 > 2100 set as limits.

Lars




On Thu, Jun 12, 2014 at 3:43 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Yeah, this is really sort of an issue with the submission of mobile data
> from phones who have not set their clocks correctly, and the fact that
> DHIS2 does not really barf at recording things for periods from the ancient
> past. Although we try to instruct people this is necessary, just one
> submission at Jan 1, 0000, will increase the time which it takes to do the
> analytics. I think some reasonable, as you say, limits would be good. Those
> who want to use DHIS2 for archeaological purposes, could always change
> these hard-coded limits.
>
> I would suggest 1900-2100, which should be more than generous enough for
> the vast majority of use cases. We are looking really just to restrict
> these extreme cases.
>
> Regards,
> Jason
>
>
>
> On Thu, Jun 12, 2014 at 2:40 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>
> wrote:
>
>> Hi Jason,
>>
>> I see the problem. Analytics after 2.14 should remove all empty analytics
>> tables though so you should not have all those empty tables between 0 and
>> now.
>>
>> Unless someone plans to use DHIS for archaeological research / studies of
>> the ancient Greeks we could maybe hard code some sensible limits to protect
>> from those extreme cases.
>>
>> Lars
>>
>>
>>
>> On Thu, Jun 12, 2014 at 1:45 PM, Jason Pickering <
>> jason.p.pickering@xxxxxxxxx> wrote:
>>
>>> This may have been brought up before, but we get some data sometimes,
>>> submitted in faraway time periods (like 1-1-0001). No clue really how this
>>> gets in there, but it exposes a weakness in the analytics, in that if data
>>> exists from these ancient (or far in the future time periods), many
>>> thousands of tables will be created (since a table will be created for each
>>> year, based on the minimum and maximum period).
>>>
>>> I would like to suggest that we implement a mechanism (perhaps a system
>>> setting)  to restrict the analytics to certain time ranges, namely
>>>
>>> 1) Ignore data for the analytics before...
>>> 2) Igonore data for the analytics after....
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>

References