← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25


Dear Raminosoa,

U can update the dataelement table directly and set the zeroissignificant
to true for all after update for dataelement created that day. Then go to
data administration->maintenance and the clear application cache.
That works too.
Sql script looks like

Update dataelement set zeroissignificant = true where created::date

Note that the created helps not to update all dataelements, you can choose
any other filter e.g a starting string.


On Thursday, May 25, 2017, Raminosoa Rabemanantsoa, Tantely <
traminosoa@xxxxxxxxxx> wrote:

> Dear DHIS2 community,
> When doing data elements upload from csv file (both add new or edit
> existing) we are using the following csv file structure:
> *Name, uid, code, shortname, description, formname, domaintype, valuetype,
> aggregationtype, **zeroissignificant*
> The last field is set to *true* for numeric data element as we would like
> to store zero data values. As shown in the image below, the checkbox still
> has to be checked manually.
> Is there some step that I am missing, or should I use another syntax for
> this last column. I have to update hundreds of data elements.
> Your suggestions are welcome!
> Regards,
> Tantely.
> ​
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant

"I don't want to be anything other than what I have been - one tree hill "

JPEG image

Follow ups