Dear Alex, Thank you for your suggestion! While trying to run the SQL script I get the following error message: "SQL query contains illegal keywords" when bringing the "zeroissignificant" field name in the script, even closing it between brackets. Here it is:
update dataelement set [zeroissignificant] = true where lastupdated::date ='2017-05-25'; Thanks, Tantely. On Thu, May 25, 2017 at 9:57 PM, Alex Tumwesigye <atumwesi...@gmail.com> wrote: > 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 > ='2017-05-25' > > Note that the created helps not to update all dataelements, you can choose > any other filter e.g a starting string. > > Alex > > > On Thursday, May 25, 2017, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> 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 > Kampala > 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 " > > -- *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.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
