← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] WHO DQA tool and Zeros not storing in DHIS2


Hi Gerald,
No, they will not appear unless people re-enter the data. When this setting
is used, what happens on the client side, is that even if people enter a
zero, it will never get transmitted to the server. In most cases, having
zeros simply leads to massive numbers of zeros stored in the database,
which are not important when things get aggregated. Users are often not
consistent about entering zeros, and trying to divine what the user's
intent was, can be exceedingly difficult. This is the reason that the
"Complete" button was implemented. With proper training and messaging, this
can be used to indicate that the report it complete, and that everything
which is blank, should be able to be assumed to be zero. Often people want
to try and use a zero to indicate that a particular service is offered, but
that there were simply no clients for that reporting period. The problem of
course is whether the data entry staff understand this. I am not sure what
the need for zeroes actually is in your case, but you may want to consider
to use the completion information instead, if possible. We have seen
numerous cases were more than 60% of the values stored in a DHIS2 database
are zeros. This leads to slower performance of analytics, as well as
inflation of backup sizes, so I hope if you do change this, to think
carefully about whether you really, really need all those zeros!

Best regards,

On Thu, Nov 22, 2018 at 5:03 AM gerald thomas <gerald17006@xxxxxxxxx> wrote:

> Dear Barnabas,
> Thanks for your help.
> The issue now is that we had been ignoring it all this time. Now, we want
> to consider it again which means we will have to enable them as a batch by
> API method but I am inquiring if the previous missing zeros will appear.
> On Thu, Nov 22, 2018 at 9:50 AM Barnabas Akumba <akumbabarns@xxxxxxxxx>
> wrote:
>> Hello Gerald,
>> Storing of zeros in the DHIS2 is configured during the Data Element
>> Creation stage. There is an option where you need to enable the Data
>> Element to store zero values (see attached screen shot).
>> [image: image.png]
>> Once that is done for all the Data Elements, then the Form will be able
>> to store Zero values.
>> Regards
>> On Thu, Nov 22, 2018 at 10:42 AM gerald thomas <gerald17006@xxxxxxxxx>
>> wrote:
>>> Dear all,
>>> We are looking at the WHO tool and there was a concern about the zeros
>>> which are not storing in the PostgreSQL database.
>>> Please is there any solution for these zeros not storing?
>>> Is there another way for the WHO tool to differentiate between an actual
>>> blank space and Zeros?
>>> Thanks in advance for your contribution.
>>> --
>>> Regards,
>>> Gerald
>>> _______________________________________________
>>> 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
>> --
>> Barnabas AKUMBA
>> *Mobile:* +2348036195778
>> *Skype:* barnabas.akumba
> --
> Regards,
> Gerald
> _______________________________________________
> 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

PNG image

Follow ups