Re: [Dhis2-users] inport meta data to option set
Hi Lars, The changed format also doesn’t work, have the following error in Catalina. I wanted to see if I could recreate the error on the demo server but can’t access the import/export module. Is this temporarily (reset at midnight) or permanently? * INFO 2015-05-07 14:34:41,316 User 'admin' started import at Thu May 07 14:34:41 CAT 2015 (DefaultImportService.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 [Level: INFO, category: METADATA_IMPORT, time: Thu May 07 14:34:41 CAT 2015, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-7]) * WARN 2015-05-07 14:34:41,381 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [taskScheduler-7]) * ERROR 2015-05-07 14:34:41,382 ERROR: column this_.query does not exist Position: 275 (SqlExceptionHelper.java [taskScheduler-7]) My import settings were: ·CSV ·Dry run YES ·Option set Attached the file I tried to import (just a single option for a single optionset). Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 29 April 2015 22:36 To: Robin Martens Cc: Simon Muyambo; Knut Staring; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi there, the CSV option set import format changed in 2.18. The option code is now required. Have a look at the docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s09.html best regards, Lars On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, Did anyone encounter the same issue as the one described below? I.e. import conflicts when importing option sets (via CSV)? Thanks in advance, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 28 April 2015 16:35 To: Simon Muyambo; 'Knut Staring' Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi Simon and Knut, I’m currently facing the same issue. Did you manage to solve it at the time and if so, how? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Dear Knut I have created option set and exported it in JSON. I then deleted the optionset and tried to import it. Below are the same errors I am getting with csv file. Never seems to be able to import members of the option set Current user: admin Version: 2.17 Build revision: 17561 Build date: 2014-11-21 12:21 {created:2014-12-20T23:44:06.855+,optionSets:[{id:etvtSKUhoSZ,name:prog,created:2014-12- 20T23:42:20.447+,lastUpdated:2014-12-20T23:43:21.551+,options: [{id:v0DNS4VKf40,code:g1,name:George,created:2014-12-20T23:43:07.726+,lastUpdated:2014-12- 20T23:43:07.726+},{id:Ghi9DN5UYfu,code:t1,name:Tom,created:2014-12-20T23:43:21.550+,lastUpdated:2014- 12-20T23:43:21.550+}],version:1}]} Import summary Import count 1 Imported 0 Updated 0 Ignored Type Summary Type Imported Updated Ignored OptionSet 1 0 0 Conflicts Type Element Description OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='v0DNS4VKf40', code='g1', name='George', created=Sun Dec 21 01:43:07 CAT 2014, lastUpdated=Sun Dec 21 01:43:07 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='Ghi9DN5UYfu', code='t1', name='Tom', created=Sun Dec 21 01:43:21 CAT 2014, lastUpdated=Sun Dec 21 01:43:21 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). Regards Simon Muyambo From: Knut Staring [mailto:knu...@gmail.commailto:knu...@gmail.com] Sent: 19 December 2014 21:49 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set I think you need to have quotes aroudn any text strings, including the codes On Fri, Dec 19, 2014 at 8:40 PM, Simon Muyambo smmuya...@gmail.commailto:smmuya...@gmail.com wrote: Dear Knut and Jason Thanks for the advice. I have run some tests
Re: [Dhis2-users] inport meta data to option set
Thanks Knut. However, I tried both with and without quotation marks. No difference. I also tried both adding an option to an existing option set and creating a new option set, also no difference… From: Knut Staring [mailto:knu...@gmail.com] Sent: 07 May 2015 15:14 To: Robin Martens Cc: Lars Helge Øverland; Simon Muyambo; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set I think all the headers have to be lower case, as in the manual? And everything else has to have quotation marks, including the optionsetname (Sector) On Thu, May 7, 2015 at 2:57 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Lars, The changed format also doesn’t work, have the following error in Catalina. I wanted to see if I could recreate the error on the demo server but can’t access the import/export module. Is this temporarily (reset at midnight) or permanently? * INFO 2015-05-07 14:34:41,316 User 'admin' started import at Thu May 07 14:34:41 CAT 2015 (DefaultImportService.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 [Level: INFO, category: METADATA_IMPORT, time: Thu May 07 14:34:41 CAT 2015, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-7]) * WARN 2015-05-07 14:34:41,381 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [taskScheduler-7]) * ERROR 2015-05-07 14:34:41,382 ERROR: column this_.query does not exist Position: 275 (SqlExceptionHelper.java [taskScheduler-7]) My import settings were: •CSV •Dry run YES •Option set Attached the file I tried to import (just a single option for a single optionset). Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.commailto:larshe...@gmail.com] Sent: 29 April 2015 22:36 To: Robin Martens Cc: Simon Muyambo; Knut Staring; dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi there, the CSV option set import format changed in 2.18. The option code is now required. Have a look at the docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s09.html best regards, Lars On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, Did anyone encounter the same issue as the one described below? I.e. import conflicts when importing option sets (via CSV)? Thanks in advance, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 28 April 2015 16:35 To: Simon Muyambo; 'Knut Staring' Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi Simon and Knut, I’m currently facing the same issue. Did you manage to solve it at the time and if so, how? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Dear Knut I have created option set and exported it in JSON. I then deleted the optionset and tried to import it. Below are the same errors I am getting with csv file. Never seems to be able to import members of the option set Current user: admin Version: 2.17 Build revision: 17561 Build date: 2014-11-21 12:21 {created:2014-12-20T23:44:06.855+,optionSets:[{id:etvtSKUhoSZ,name:prog,created:2014-12- 20T23:42:20.447+,lastUpdated:2014-12-20T23:43:21.551+,options: [{id:v0DNS4VKf40,code:g1,name:George,created:2014-12-20T23:43:07.726+,lastUpdated:2014-12- 20T23:43:07.726+},{id:Ghi9DN5UYfu,code:t1,name:Tom,created:2014-12-20T23:43:21.550+,lastUpdated:2014- 12-20T23:43:21.550+}],version:1}]} Import summary Import count 1 Imported 0 Updated 0 Ignored Type Summary Type Imported Updated Ignored OptionSet 1 0 0 Conflicts Type Element Description OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='v0DNS4VKf40', code='g1', name='George', created=Sun Dec 21 01:43:07 CAT 2014, lastUpdated=Sun Dec 21 01:43:07 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='Ghi9DN5UYfu', code='t1', name='Tom', created=Sun Dec 21 01:43:21 CAT 2014, lastUpdated=Sun Dec 21 01:43:21 CAT
Re: [Dhis2-users] inport meta data to option set
A small update. I noticed the analytics module is also not working anymore so it’s probably not linked specifically to the import module. Here’s the catalina.out log from the analytics: * INFO 2015-05-07 15:07:18,046 [Level: INFO, category: DATAMART, time: Thu May 07 15:07:18 CAT 2015, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-3]) * INFO 2015-05-07 15:07:18,047 [Level: INFO, category: DATAMART, time: Thu May 07 15:07:18 CAT 2015, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-3]) * WARN 2015-05-07 15:07:18,050 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [taskScheduler-3]) * ERROR 2015-05-07 15:07:18,050 ERROR: column this_.query does not exist Position: 275 (SqlExceptionHelper.java [taskScheduler-3]) * INFO 2015-05-07 15:07:18,051 [Level: ERROR, category: DATAMART, time: Thu May 07 15:07:18 CAT 2015, message: Process failed: could not extract ResultSet] (InMemoryNotifier.java [taskScheduler-3]) I read in a previous post (see attached) this could be linked to the incorrect cleaning of the webapps folder when upgrading to 2.18 (which we recently did). Can this indeed be the issue and how to ensure it is properly cleaned when upgrading? Regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 07 May 2015 17:50 To: Knut Staring Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Thanks Knut. However, I tried both with and without quotation marks. No difference. I also tried both adding an option to an existing option set and creating a new option set, also no difference… From: Knut Staring [mailto:knu...@gmail.com] Sent: 07 May 2015 15:14 To: Robin Martens Cc: Lars Helge Øverland; Simon Muyambo; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set I think all the headers have to be lower case, as in the manual? And everything else has to have quotation marks, including the optionsetname (Sector) On Thu, May 7, 2015 at 2:57 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Lars, The changed format also doesn’t work, have the following error in Catalina. I wanted to see if I could recreate the error on the demo server but can’t access the import/export module. Is this temporarily (reset at midnight) or permanently? * INFO 2015-05-07 14:34:41,316 User 'admin' started import at Thu May 07 14:34:41 CAT 2015 (DefaultImportService.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 [Level: INFO, category: METADATA_IMPORT, time: Thu May 07 14:34:41 CAT 2015, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-7]) * INFO 2015-05-07 14:34:41,316 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-7]) * WARN 2015-05-07 14:34:41,381 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java [taskScheduler-7]) * ERROR 2015-05-07 14:34:41,382 ERROR: column this_.query does not exist Position: 275 (SqlExceptionHelper.java [taskScheduler-7]) My import settings were: •CSV •Dry run YES •Option set Attached the file I tried to import (just a single option for a single optionset). Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.commailto:larshe...@gmail.com] Sent: 29 April 2015 22:36 To: Robin Martens Cc: Simon Muyambo; Knut Staring; dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi there, the CSV option set import format changed in 2.18. The option code is now required. Have a look at the docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s09.html best regards, Lars On Wed, Apr 29, 2015 at 7:22 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, Did anyone encounter the same issue as the one described below? I.e. import conflicts when importing option sets (via CSV)? Thanks in advance, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 28 April 2015 16:35 To: Simon Muyambo; 'Knut Staring' Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi Simon and Knut, I’m currently facing the same issue. Did you manage to solve it at the time and if so, how? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Dear Knut I have created
Re: [Dhis2-users] inport meta data to option set
Hi all, Did anyone encounter the same issue as the one described below? I.e. import conflicts when importing option sets (via CSV)? Thanks in advance, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 28 April 2015 16:35 To: Simon Muyambo; 'Knut Staring' Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Hi Simon and Knut, I’m currently facing the same issue. Did you manage to solve it at the time and if so, how? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Dear Knut I have created option set and exported it in JSON. I then deleted the optionset and tried to import it. Below are the same errors I am getting with csv file. Never seems to be able to import members of the option set Current user: admin Version: 2.17 Build revision: 17561 Build date: 2014-11-21 12:21 {created:2014-12-20T23:44:06.855+,optionSets:[{id:etvtSKUhoSZ,name:prog,created:2014-12- 20T23:42:20.447+,lastUpdated:2014-12-20T23:43:21.551+,options: [{id:v0DNS4VKf40,code:g1,name:George,created:2014-12-20T23:43:07.726+,lastUpdated:2014-12- 20T23:43:07.726+},{id:Ghi9DN5UYfu,code:t1,name:Tom,created:2014-12-20T23:43:21.550+,lastUpdated:2014- 12-20T23:43:21.550+}],version:1}]} Import summary Import count 1 Imported 0 Updated 0 Ignored Type Summary Type Imported Updated Ignored OptionSet 1 0 0 Conflicts Type Element Description OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='v0DNS4VKf40', code='g1', name='George', created=Sun Dec 21 01:43:07 CAT 2014, lastUpdated=Sun Dec 21 01:43:07 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='Ghi9DN5UYfu', code='t1', name='Tom', created=Sun Dec 21 01:43:21 CAT 2014, lastUpdated=Sun Dec 21 01:43:21 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). Regards Simon Muyambo From: Knut Staring [mailto:knu...@gmail.com] Sent: 19 December 2014 21:49 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set I think you need to have quotes aroudn any text strings, including the codes On Fri, Dec 19, 2014 at 8:40 PM, Simon Muyambo smmuya...@gmail.commailto:smmuya...@gmail.com wrote: Dear Knut and Jason Thanks for the advice. I have run some tests with unique codes but not sure what the error means name,uid,code,option Colorsm,,1b,Blue1 Colorsm,,2g,Green1 Gendersm,,3f,Female1 Gendersm,,4m,Male1 Import summary Import count 2 Imported 2 Updated 0 Ignored Type Summary Type Imported Updated Ignored OptionSet 2 2 0 Conflicts Type Element Description OptionSet Gendersm Unknown reference to IdentifiableObject{id=0, uid='Ja0hb0d1XGK', code='Female1', name='Female1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='qvy5Iof8De3', code='3f', name='Gendersm', created=null, lastUpdated=null} (OptionSet). OptionSet Colorsm Unknown reference to IdentifiableObject{id=0, uid='jPyLUhETxWH', code='Green1', name='Green1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='JGfUphTsLuk', code='2g', name='Colorsm', created=null, lastUpdated=null} (OptionSet). OptionSet Gendersm Unknown reference to IdentifiableObject{id=0, uid='mJsHyly4UoH', code='Male1', name='Male1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='IxdnSBPyo9y', code='4m', name='Gendersm', created=null, lastUpdated=null} (OptionSet). OptionSet Colorsm Unknown reference to IdentifiableObject{id=0, uid='pSmhTjz0yIS', code='Blue1', name='Blue1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='MVHPvOLojgd', code='1b', name='Colorsm', created=null, lastUpdated=null} (OptionSet). Regards Simon Muyambo From: Knut Staring [mailto:knu...@gmail.commailto:knu...@gmail.com] Sent: 19 December 2014 07:03 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data
Re: [Dhis2-users] inport meta data to option set
Hi Simon and Knut, I’m currently facing the same issue. Did you manage to solve it at the time and if so, how? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Simon Muyambo Sent: 21 December 2014 02:17 To: 'Knut Staring'; 'Simon Muyambo' Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set Dear Knut I have created option set and exported it in JSON. I then deleted the optionset and tried to import it. Below are the same errors I am getting with csv file. Never seems to be able to import members of the option set Current user: admin Version: 2.17 Build revision: 17561 Build date: 2014-11-21 12:21 {created:2014-12-20T23:44:06.855+,optionSets:[{id:etvtSKUhoSZ,name:prog,created:2014-12- 20T23:42:20.447+,lastUpdated:2014-12-20T23:43:21.551+,options: [{id:v0DNS4VKf40,code:g1,name:George,created:2014-12-20T23:43:07.726+,lastUpdated:2014-12- 20T23:43:07.726+},{id:Ghi9DN5UYfu,code:t1,name:Tom,created:2014-12-20T23:43:21.550+,lastUpdated:2014- 12-20T23:43:21.550+}],version:1}]} Import summary Import count 1 Imported 0 Updated 0 Ignored Type Summary Type Imported Updated Ignored OptionSet 1 0 0 Conflicts Type Element Description OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='v0DNS4VKf40', code='g1', name='George', created=Sun Dec 21 01:43:07 CAT 2014, lastUpdated=Sun Dec 21 01:43:07 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). OptionSet prog Unknown reference to IdentifiableObject{id=0, uid='Ghi9DN5UYfu', code='t1', name='Tom', created=Sun Dec 21 01:43:21 CAT 2014, lastUpdated=Sun Dec 21 01:43:21 CAT 2014} (Option) on object IdentifiableObject{id=3, uid='etvtSKUhoSZ', code='null', name='prog', created=Sun Dec 21 01:42:20 CAT 2014, lastUpdated=Sun Dec 21 02:09:50 CAT 2014} (OptionSet). Regards Simon Muyambo From: Knut Staring [mailto:knu...@gmail.com] Sent: 19 December 2014 21:49 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set I think you need to have quotes aroudn any text strings, including the codes On Fri, Dec 19, 2014 at 8:40 PM, Simon Muyambo smmuya...@gmail.commailto:smmuya...@gmail.com wrote: Dear Knut and Jason Thanks for the advice. I have run some tests with unique codes but not sure what the error means name,uid,code,option Colorsm,,1b,Blue1 Colorsm,,2g,Green1 Gendersm,,3f,Female1 Gendersm,,4m,Male1 Import summary Import count 2 Imported 2 Updated 0 Ignored Type Summary Type Imported Updated Ignored OptionSet 2 2 0 Conflicts Type Element Description OptionSet Gendersm Unknown reference to IdentifiableObject{id=0, uid='Ja0hb0d1XGK', code='Female1', name='Female1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='qvy5Iof8De3', code='3f', name='Gendersm', created=null, lastUpdated=null} (OptionSet). OptionSet Colorsm Unknown reference to IdentifiableObject{id=0, uid='jPyLUhETxWH', code='Green1', name='Green1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='JGfUphTsLuk', code='2g', name='Colorsm', created=null, lastUpdated=null} (OptionSet). OptionSet Gendersm Unknown reference to IdentifiableObject{id=0, uid='mJsHyly4UoH', code='Male1', name='Male1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='IxdnSBPyo9y', code='4m', name='Gendersm', created=null, lastUpdated=null} (OptionSet). OptionSet Colorsm Unknown reference to IdentifiableObject{id=0, uid='pSmhTjz0yIS', code='Blue1', name='Blue1', created=Fri Dec 19 21:34:19 CAT 2014, lastUpdated=Fri Dec 19 21:34:19 CAT 2014} (Option) on object IdentifiableObject{id=0, uid='MVHPvOLojgd', code='1b', name='Colorsm', created=null, lastUpdated=null} (OptionSet). Regards Simon Muyambo From: Knut Staring [mailto:knu...@gmail.commailto:knu...@gmail.com] Sent: 19 December 2014 07:03 To: Simon Muyambo Cc: Jason Pickering; dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] inport meta data to option set I think maybe you have to have something in the code field On 19 Dec 2014 02:54, Simon Muyambo smmuya...@gmail.commailto:smmuya...@gmail.com wrote: Dear Jason Please advise on the import of option set. I find option set is important but the members are not when I use CSV import. Any ideas? See example below name,uid,code,option Color,,,Blue Color,,,Green Gender,,,Female Gender,,,Male Regards Simon Muyambo
[Dhis2-users] DHIS2 - Program still appearing for certain user roles
Hi all, I have some programs that should only be visible to certain users. When I unselect the other users from the “Assign to user roles” menu via the “Program” module, the program continues to appear for these users in the Event Capture module. The same issue seems to persist on the demo server. When checking the PSQL tables, the program/user role combination is no longer in the program_userrole table which is as it should be. Is this a known bug or am I overlooking something? Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Validations on GPS coordinates
Hi Jason, Thanks for the detailed reply. It might a useful feature for later if other users see a need. For the moment, we will have a look at the general validation. Regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 16 March 2015 11:53 To: Robin Martens Cc: Abyot Gizaw; DHIS 2 Users list; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Validations on GPS coordinates Hi Robin, I think what Abyot means is that general validation would be something like saying that you could setup a bounding box for the area which you know you are going to receive coordinates. For instance, if the countries latitude is between -18 and -25 degrees, you could setup a rule to ensure that the coordinates are between these values. However, what you suggest is much more sophisticated, i.e. spatial validation based on the position within the orgunit hierarchy. This is not supported and would certainly need some development or a custom app to support this. You may need to look here https://apps.dhis2.org/dev/ which is the latest version of trunk while the normal demo site is the latest version of the current stable release. Best regards, Jason On Mon, Mar 16, 2015 at 10:48 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Abyot, What do you mean with the “general validation of latitude and longitude”? Using google maps would be great. However, I didn’t find it on the Event Capture app on the demo server. How do you access it? Regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.commailto:aby...@gmail.com] Sent: 16 March 2015 11:38 To: Robin Martens Cc: DHIS 2 Users list; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Validations on GPS coordinates Hi Robin, No, it is not possible to define specific validation on coordinates except the general validation of latitude and longitude. However, if you look at the latest Event Capture app, it is possible to capture coordinates from Google map. The app also allows to zoom-in/out based on polygons and points defined for orgunits. --- Thank you, Abyot. On Mon, Mar 16, 2015 at 10:22 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, Does anyone know if it is possible to set validation rules on GPS coordinates in the event capture module? Ideally, coordinates would be within the polygon of the organization unit the event is linked to (a country or district in this case). Else, just min-max values could already work to limit the possibility of errors. Thanks, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martensmailto:dhis2-users-bounces%2Bmartens=sher...@lists.launchpad.netmailto:sher...@lists.launchpad.net] On Behalf Of Ngoc Thanh Nguyen Sent: 15 March 2015 20:29 To: DHIS 2 Users list; dhis2-devs Subject: [Dhis2-users] Morbidity and mortality program in demo dhis2 site Hi all, I would like to buid a system for Morbidity and mortality in Vietnam. I think the one deployed on the demo site is similar to what we plan to have though it may go a bit further, i.e. multiple events with registration (tracking a patient throughout their admission history) rather than single event without registration. Could anyone who were involved in this implementation share some lessons? Thanks Thanh ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Validations on GPS coordinates
Hi all, Does anyone know if it is possible to set validation rules on GPS coordinates in the event capture module? Ideally, coordinates would be within the polygon of the organization unit the event is linked to (a country or district in this case). Else, just min-max values could already work to limit the possibility of errors. Thanks, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Ngoc Thanh Nguyen Sent: 15 March 2015 20:29 To: DHIS 2 Users list; dhis2-devs Subject: [Dhis2-users] Morbidity and mortality program in demo dhis2 site Hi all, I would like to buid a system for Morbidity and mortality in Vietnam. I think the one deployed on the demo site is similar to what we plan to have though it may go a bit further, i.e. multiple events with registration (tracking a patient throughout their admission history) rather than single event without registration. Could anyone who were involved in this implementation share some lessons? Thanks Thanh ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Error message when saving event report as favorite
Dear all, We're getting the following error message when trying to save an event report as a favorite (see image below). This is only happening for event reports, all other functionalities (download, generating on screen, etc.) don't have any problems. [cid:f4b2f27a-cb81-4285-9694-e69aa6bbebb3] We're using DHIS 2.17 (and preferably not planning an upgrade to 2.18 soon). Can anyone give some feedback if this is a DHIS issue or linked to our database? Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Validation rules for event capture - Bug?
Additional detail: when clicking on a validation rule and Show details, the Right side expression always copies the Left side expression. It might just be a small bug without further consequences but I add it here anyway. De : Dhis2-users [dhis2-users-bounces+martens=sher...@lists.launchpad.net] de la part de Robin Martens [mart...@sher.be] Envoyé : dimanche 25 janvier 2015 15:44 À : DHIS 2 Developers list; DHIS 2 Users list Objet : [Dhis2-users] DHIS2 - Validation rules for event capture - Bug? Hi all, Here's a question (potential bug) on the validation rules for event capture. When setting a validation rule for a program it doesn't seem to do anything when violated. There is no pop-up blocking saving the data when filling in the form and no problem detected the data quality app. I tried the demo server, using the Impatient morbidity and mortality program, and the Discharge must be later than admission rule. Same result, meaning violation doesn't return any problem. Is the validation rule functionality for events broken? Btw, this problem is limited to events, for aggregate data entry the validation rules work fine. Thanks, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Validation rules for event capture - Bug?
Hi all, Here's a question (potential bug) on the validation rules for event capture. When setting a validation rule for a program it doesn't seem to do anything when violated. There is no pop-up blocking saving the data when filling in the form and no problem detected the data quality app. I tried the demo server, using the Impatient morbidity and mortality program, and the Discharge must be later than admission rule. Same result, meaning violation doesn't return any problem. Is the validation rule functionality for events broken? Btw, this problem is limited to events, for aggregate data entry the validation rules work fine. Thanks, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] Date category combination
Hi all, I want to delete my analytics tables and start all over. The (only?) way to do this is through the Data Admin - Maintenance app but when clearing the tables nothing happens. All tables still exist in Postgresql and the data remains available in the Pivot tables. We're still in 2.17. Is this a known issue or is there a workaround? Sorry, couldn't test on the demo server as it seems to take forever to try to delete the analytics tables there. Regards, Robin De : Dhis2-users [dhis2-users-bounces+martens=sher...@lists.launchpad.net] de la part de Guy Ekani [constyek...@yahoo.fr] Envoyé : vendredi 23 janvier 2015 13:10 À : Lars Helge Øverland; Enmanuel Toribio Cc : dhis2-users@lists.launchpad.net; dhis2-d...@lists.launchpad.net Objet : Re: [Dhis2-users] Date category combination Thank you Lars, I will try it ! But for next features, I think it will be useful to assign a Value Type (number, date, Text, Yes/no, etc...) to a category . Sincerely, = EKANI Guy Le Jeudi 22 janvier 2015 22h47, Lars Helge Øverland larshe...@gmail.com a écrit : Hi Guy, currently the way it works is that a data element can only have one category combination. This means that all fields in the form for that data elements will have the same data type. The best way to achieve the form layout above is to have 2 data elements: - One with numeric value type, and a category with three age groups. - One with date type and default category. Then put these fields into a custom data entry form. regards, Lars ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Aggreration query for single event without registration
Hi Ola, Thanks a lot, that works great! Regards, Robin De : olati...@gmail.com [olati...@gmail.com] de la part de Ola Hodne Titlestad [ol...@ifi.uio.no] Envoyé : jeudi 22 janvier 2015 12:41 À : Robin Martens Cc : dhis2-users@lists.launchpad.net; dhis2-devs Objet : Re: [Dhis2-devs] Aggreration query for single event without registration Robin, We have a feature to get number of events for a given program stage. Two options need to be set: 1) Operator, at the top of the page, need to be 'Number of visits' 2) Under the Program tab, select 'Visited selected program stage' The formula will then be on this format : [PS:391] With 391 being the internal id of the program stage. That should give you the total number of events for your single event without registration program. Ola -- 21. jan. 2015 10:37 skrev Robin Martens mart...@sher.bemailto:mart...@sher.be følgende: Hi all, Is it possible in the Aggregation Query Builder to use the Number of tracked entities operator to calculate a number of events, especially when it concerns Single events without registration? I tried it and although it finds the events based on the conditions, it always returns 0 as a value. Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Aggreration query for single event without registration
Hi all, Is it possible in the Aggregation Query Builder to use the Number of tracked entities operator to calculate a number of events, especially when it concerns Single events without registration? I tried it and although it finds the events based on the conditions, it always returns 0 as a value. Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Financial year (July) in pivot tables
Hi all, It seems that although you can set the data set collection frequency to Financial Year (July), there's no way to report the data in the Pivot table module in this way. When selecting the Financial Year option in the Pivot table, it uses the Financial Year (Oct) option. Will this be fixed soon? In the meantime, is there anyone else using alternative Financial Year calendars, and how do you use them in indicators and reporting? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Financial year (July) in pivot tables
Ok, thanks Lars for the quick reply (as always)! De : Lars Helge Øverland [larshe...@gmail.com] Envoyé : lundi 19 janvier 2015 09:54 À : Robin Martens Cc : dhis2-users; dhis2-devs Objet : Re: [Dhis2-devs] DHIS2 - Financial year (July) in pivot tables Hi Robin, you are right regarding the relative periods. We are workinghttps://blueprints.launchpad.net/dhis2/+spec/configurable-financial-year-relative-period on a system setting to define the financial year variant to use as relative period. The work-around is to use fixed periods. In pivot/visualizer, go to the period section, click the period drop-down and select from Financial October, Financial April, Financial July. best regards, Lars [Inline image 1] On Mon, Jan 19, 2015 at 9:36 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, It seems that although you can set the data set collection frequency to Financial Year (July), there's no way to report the data in the Pivot table module in this way. When selecting the Financial Year option in the Pivot table, it uses the Financial Year (Oct) option. Will this be fixed soon? In the meantime, is there anyone else using alternative Financial Year calendars, and how do you use them in indicators and reporting? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Custom conditions on the aggregation period when using Aggregation Queries
Hi all, An additional question about the Aggregation Query Builder. Currently, the period of aggregation between tracked data elements (TDE) and aggregated data elements (ADE) always has to correspond. E.g. for monthly ADEs, TDE data will be aggregated per month based on the event instance report or enrollment date. The following example illustrates this: * ADE (July 2014) = Sum (TDE for which the event report date lies in July 2014). The thing is that his seems to be an inherent condition for each aggregation query you build, so the system automatically applies this logic whenever executing an aggregation query, even if the user doesn't specify any conditions on the period. Now is my question: is it instead possible to drop this condition and do the aggregation over custom-defined periods? * An example: ADE (2014) = Sum (TDE for which Status=Ongoing). In this example, whatever the event enrollment date, all event instances are taken into account. The only applicable condition is the Status. * Another example: ADE (2014) = Sum (TDE for which Report Date=between 2009 and 2014). In this example, the aggregated value will be the sum over all event instances created in the last 5 years. Is this currently possible? If not, has this been foreseen on the roadmap and are there workarounds in the meantime? Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Caching testing
Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Caching testing
This works great. Thanks, Lars! If it's not yet in there, might be useful to add it to the implementation or user manuals. Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 17 September 2014 11:19 To: Robin Martens Cc: dhis2-users@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching testing Hi Robin, with caching, are you referring to data entry forms? If so, those are stored in indexdb / localstorage to support offline capture, which is not cleared by default when clearing cache in most browsers. For development this chrome extension can be recommended: https://chrome.google.com/webstore/detail/clear-cache/cppjkneekbjaeellbfkmgnhonkkjfpdn Go to options and select everything from beginning of time. Lars On Wed, Sep 17, 2014 at 10:25 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Caching testing
Hi Lars, I'm not sure what you mean, but in my custom data forms for events (which I modify and test through a browser, no database hacking involved), I had this issue of caching. Is this what you meant that shouldn't be happening? Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 17 September 2014 11:38 To: Robin Martens Cc: dhis2-users@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching testing Actually in production, when you do a change to a data set or sections, the form should automatically be re-downloaded to the browser. So the end user should be unaware of this. During development when you hack away in the db etc it's useful to clear everything from the browser. On Wed, Sep 17, 2014 at 11:34 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: This works great. Thanks, Lars! If it's not yet in there, might be useful to add it to the implementation or user manuals. Robin From: Lars Helge Øverland [mailto:larshe...@gmail.commailto:larshe...@gmail.com] Sent: 17 September 2014 11:19 To: Robin Martens Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net; DHIS 2 Developers list Subject: Re: [Dhis2-devs] DHIS2 - Caching testing Hi Robin, with caching, are you referring to data entry forms? If so, those are stored in indexdb / localstorage to support offline capture, which is not cleared by default when clearing cache in most browsers. For development this chrome extension can be recommended: https://chrome.google.com/webstore/detail/clear-cache/cppjkneekbjaeellbfkmgnhonkkjfpdn Go to options and select everything from beginning of time. Lars On Wed, Sep 17, 2014 at 10:25 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi all, I'm currently testing some final adjustments, however there's somewhere a caching preventing me from seeing the last updates right away in my browser. I tried deleting both browser caching and DHIS2 caching (via Maintenance module) and that for Google Chrome, Mozilla, and IE. Generally, this is what I noticed (especially with respect to modifications in data entry templates): 1. Google Chrome (incognito mode): a few hours of delay before updates are visible in the browser. 2. Mozilla: I don't manage to see any updates at all. The browser is still working on the form of 2 weeks ago. 3. IE: Idem as Mozilla. From where my question: which browser caching methods do you use for development? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Delete data values
Hi all, I did some testing storing data values and modifying data element categories. Now I'd like to delete the data values in the system, clear my analytics tables, and start over with fresh values. Is the best way to do this to delete the data values entries in the datavalue table via Postgresql and clearing the analytics tables via Data Admin - Maintenance? Thanks in advance, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Elegant indicator reporting?
Hi there, Does anyone know if there's an elegant way to display indicator baselines, targets, and progress values in a single pivot table? I don't seem to get my values organized per individual indicator (always per group of indicators or data elements). I was thinking about a structure as follows (for a single period): Indicator 1 Indicator 2 ... Baseline Target Progress For the moment I'm using Indicators for progress values and Data elements for baselines and targets, but I can change the latter if needed for a better presentation. Thanks for any input. Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Elegant indicator reporting?
Wanted to add to this question: it does seem obvious but apparently it's not possible to group indicators for reporting in pivot tables (according to indicator groups). Can anyone confirm? From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 15 September 2014 15:37 To: dhis2-users@lists.launchpad.net Subject: [Dhis2-users] DHIS2 - Elegant indicator reporting? Hi there, Does anyone know if there's an elegant way to display indicator baselines, targets, and progress values in a single pivot table? I don't seem to get my values organized per individual indicator (always per group of indicators or data elements). I was thinking about a structure as follows (for a single period): Indicator 1 Indicator 2 ... Baseline Target Progress For the moment I'm using Indicators for progress values and Data elements for baselines and targets, but I can change the latter if needed for a better presentation. Thanks for any input. Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
Hi Jason, Thanks for taking the time to read through my email. I'll have a look at the different possibilities you proposed, and we'll be looking forward to any future upgrade of the calculation method (for now or later). I guess it's just that some sectors need more complex indicators than others (our project is in forest management). Have a nice day, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 11 September 2014 19:00 To: Robin Martens Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, Your mail is dense and will need some digestion. :) You give a very good level of detail however of you problem in this mail and will be very useful as this type of functionality is attempted to be implemented. To respond immediately to how you might be able to solve the issue, you should possibly consider using the WebAPI to extract your data, process it as you need, and then inject it back into DHIS2. The WebAPI is described in detail herehttps://www.dhis2.org/doc/snapshot/en/user/html/ch32.html. I have also written a chapter on the use of the R programming language with DHIS2, which is particularly well suited to do the type of custom calculations you are describing here. It is available herehttps://www.dhis2.org/doc/snapshot/en/user/html/apc.html. Of course, other language/methods may also be more suited to your situation, such as Python. Lastly, you can have a look at the DHIS2 Ad-hoc toolhttp://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/files/head:/tools/dhis-adhoc/ which would allow interaction with the service layer of DHIS2. Another approach could be SQL which interacts directly with the database. I am sure there are many other means as well. So short answer is, right now there is no in-built way to achieve what you need I think, and it will take some coding on your side. We have run into similar issues in the water and sanitation sector, where we need to work with the latest reported data, which DHIS2 does not handle really. We pull out the data via the WebAPI, do the aggregation externally, and then inject everything back into the system to get the figures we need. It would be nice if the system did it automatically, but given the nature of the project, there are many feature requests and limited resources. Contributions of course are welcome. The current aggregation engine handles the easy cases of sums and averages pretty well, but for more complex stuff, external routes may be the only solution for now. We should certainly try and distill some of your ideas into a concrete blueprint. Best regards, Jason On Thu, Sep 11, 2014 at 6:15 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Jason, I appreciate your help as this is very important for our project, thanks. Some of our indicators are indeed quite complex and might need some custom coding if not too complicated. However, can you give some basic steps on how to achieve this (and on how hard this is in terms of programming as we're not experts here)? --- The rest of this mail is about the specific issue I'm having here, it's basically related to three things: 1. The absence of cross-product calculations in DHIS2 (I think it's what you call compulsory pairs of data). 2. The fact that when no data exists on a disaggregated level, the value is taken to be zero instead of the aggregated (for custom dimensions only I think). 3. The average function only exists over the time dimension (as discussed by Lars previously this week). A simple example: Population Conso pp Total District 1 10 2 20 District 2 5 3 15 Total 15 5 35 When calculating the total national consumption, DHIS2 will do: aggregated population (=15) times aggregated consumption per person (=5) makes 75, which is wrong. In reality, the two mistakes are: 1. The calculation should happen on district level before aggregating to the national value (20 for district1 plus 15 for district2 makes 35, which is the correct answer). - Cross product 2. DHIS2 always sums over orgunits (to be corrected soon according to Lars so I won't go further in detail here) The cross-product issue can actually be solved by a workaround: obliging the user to explicitly show the disaggregation level (i.e. the level at which the cross product happens) in the report tables. Interestingly enough, when calculating the total in a report without showing districts, DHIS2 will return 75, while when showing the districts 35. Imagine now that the consumption has three products (a custom category), ABC. The table would look like this: Population Conso pp A Conso pp B Conso pp C Total A Total B Total C Total District 1 10 2 1 1 20 10 10 40 District 2 5 3 1 0 15 5 0 20 Total 15 5 2 1 35 15 10 60 The same principle, but aggregated
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
Thanks a lot, Jason. I'll consider filing a blueprint for this. Regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 10 September 2014 17:55 To: Robin Martens Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, It has been a discussed, and certainly not a bug. See a related thread here (https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion on validation rules. It is essentially the same as indicators. What you will have to do is to create seperate indicator for each and every combination which you need. It can be painful, but the only way really which I know at the moment. Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2 Regards, Jason On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, I've been testing the indicator calculation algorithm and noticed something particular of which I'm not sure if it's a bug or a deliberate development choice. Indicators are not explicitly defined per category such as data elements but the reporting tools allow a disaggregated indicator calculation, which is definitely very useful. In a specific example, I want to know how many people were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I have two data elements: the total population and the national vaccination levels (in %), with a custom category vaccination type which can be A, B, or C. My indicator would be total population x national vaccination level (total). That works fine when put in a pivot table. However, when trying to disaggregate the indicator calculation by adding my custom category to the pivot table, I don't have any values anymore. It seems the reason is that the total population data element does not have the vaccination type category (which seems logical) and therefore isn't found by the calculation algorithm. As a result, my table is empty. It seems useful that the algorithm would take the aggregated value (for population) available in such cases. Another example is over the period dimension: my population is a yearly value, so when calculating an indicator on a monthly basis, instead of taking the available yearly value, he takes zero. So my question: is this a deliberate choice in the development, a bug, or an idea for a future system improvement? Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
Hi Jason, To pick up the point again, there's an additional question I've been looking at. Even if disaggregated indicator reporting is burdensome (as you explain below), it is sometimes necessary for correct aggregated indicator calculations (the most obvious one the use of weighted averages) to have intermediary calculations according to dimensions in the indicator calculation, which can then be aggregated over the whole table to obtain the total aggregated indicator value. Even in these intermediary calculations, however, the data is not available for calculation, returning zero as a result. The conclusion is that the current way of indicator calculation not only complicates (if not makes impossible in many cases) calculation of indicators per custom dimension, but also making impossible the correct calculation of indicators over period and orgunit dimension when any intermediary calculation over custom dimensions is necessary. Can you confirm this? If true, is it hard to modify the calculation method to simply pick the one-level-higher value of a data element whenever no disaggregated value exists? With existing I don't mean NULL or zero, but rather not defined (the dimension does not exist). Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 10 September 2014 17:55 To: Robin Martens Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, It has been a discussed, and certainly not a bug. See a related thread here (https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion on validation rules. It is essentially the same as indicators. What you will have to do is to create seperate indicator for each and every combination which you need. It can be painful, but the only way really which I know at the moment. Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2 Regards, Jason On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, I've been testing the indicator calculation algorithm and noticed something particular of which I'm not sure if it's a bug or a deliberate development choice. Indicators are not explicitly defined per category such as data elements but the reporting tools allow a disaggregated indicator calculation, which is definitely very useful. In a specific example, I want to know how many people were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I have two data elements: the total population and the national vaccination levels (in %), with a custom category vaccination type which can be A, B, or C. My indicator would be total population x national vaccination level (total). That works fine when put in a pivot table. However, when trying to disaggregate the indicator calculation by adding my custom category to the pivot table, I don't have any values anymore. It seems the reason is that the total population data element does not have the vaccination type category (which seems logical) and therefore isn't found by the calculation algorithm. As a result, my table is empty. It seems useful that the algorithm would take the aggregated value (for population) available in such cases. Another example is over the period dimension: my population is a yearly value, so when calculating an indicator on a monthly basis, instead of taking the available yearly value, he takes zero. So my question: is this a deliberate choice in the development, a bug, or an idea for a future system improvement? Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
Hi Jason, I appreciate your help as this is very important for our project, thanks. Some of our indicators are indeed quite complex and might need some custom coding if not too complicated. However, can you give some basic steps on how to achieve this (and on how hard this is in terms of programming as we're not experts here)? --- The rest of this mail is about the specific issue I'm having here, it's basically related to three things: 1. The absence of cross-product calculations in DHIS2 (I think it's what you call compulsory pairs of data). 2. The fact that when no data exists on a disaggregated level, the value is taken to be zero instead of the aggregated (for custom dimensions only I think). 3. The average function only exists over the time dimension (as discussed by Lars previously this week). A simple example: Population Conso pp Total District 1 10 2 20 District 2 5 3 15 Total 15 5 35 When calculating the total national consumption, DHIS2 will do: aggregated population (=15) times aggregated consumption per person (=5) makes 75, which is wrong. In reality, the two mistakes are: 1. The calculation should happen on district level before aggregating to the national value (20 for district1 plus 15 for district2 makes 35, which is the correct answer). - Cross product 2. DHIS2 always sums over orgunits (to be corrected soon according to Lars so I won't go further in detail here) The cross-product issue can actually be solved by a workaround: obliging the user to explicitly show the disaggregation level (i.e. the level at which the cross product happens) in the report tables. Interestingly enough, when calculating the total in a report without showing districts, DHIS2 will return 75, while when showing the districts 35. Imagine now that the consumption has three products (a custom category), ABC. The table would look like this: Population Conso pp A Conso pp B Conso pp C Total A Total B Total C Total District 1 10 2 1 1 20 10 10 40 District 2 5 3 1 0 15 5 0 20 Total 15 5 2 1 35 15 10 60 The same principle, but aggregated over the Product category and orgunit dimension gives the correct result of 60. This is how DHIS2 would calculate: 1. When not showing the Product category in the table: total population (15) x total aggregated consumption (=5+2+1=8) is 120. 2. When showing the Product category in the table: total population (0, it will not find a value and return zero) x consumption is 0 !!! Indeed, the workaround does work for orgunits but not for custom dimensions when not all data (in this case the population) has the same custom dimensions. I guess these are things that won't be solved quickly so I might need to do some coding myself. As a conclusion, to increase calculation power in DHIS2 I'd say: 1. Use aggregated value when no disaggregated value exists (such as for population in the previous example). 2. Aggregation operators (sum, average,...) should be defined per custom category and per data element. In other words, when creating a data element and adding categories, you have to add the operator for each category. 3. Indicators should be available for re-use in other indicators. It enables you building complex indicators piece by piece and gives more flexibility on intermediate calculation (on disaggregated level). I hope this is somewhat more clear. Kind regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 11 September 2014 16:30 To: Robin Martens Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, You lost me. Could you maybe give a somewhat simpler example by what you mean by an intermediary calculation? I am not sure exactly what you are trying to acheive, but what I can say is that in certain cases, I have had to write my own calculation methods for certain indicators which are basically impossible to calculate with the current implementation in DHIS2. It works fine for simple sums, averages, and other types of statistical things (standard deviation, etc), but for instance, if you want to calculate other statistical properties (skewness, kurtosis) of a given set of values, there is not a way to do it directly with DHIS2. Also, certain indicators depend on component parts, and cannot be calculated the way DHIS2 does it, by first summing up the numerator and denominator and then dividing it, as opposed to calculating a non-weighted average of compulsory pairs of data. What I am getting at, is that you may have to write your own calculation methods, depending on how complex they are. Regards, Jason On Thu, Sep 11, 2014 at 4:20 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Jason, To pick up the point again, there's an additional question I've been looking
[Dhis2-users] DHIS2 - Indicator calculation over dimensions
Dear all, I've been testing the indicator calculation algorithm and noticed something particular of which I'm not sure if it's a bug or a deliberate development choice. Indicators are not explicitly defined per category such as data elements but the reporting tools allow a disaggregated indicator calculation, which is definitely very useful. In a specific example, I want to know how many people were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I have two data elements: the total population and the national vaccination levels (in %), with a custom category vaccination type which can be A, B, or C. My indicator would be total population x national vaccination level (total). That works fine when put in a pivot table. However, when trying to disaggregate the indicator calculation by adding my custom category to the pivot table, I don't have any values anymore. It seems the reason is that the total population data element does not have the vaccination type category (which seems logical) and therefore isn't found by the calculation algorithm. As a result, my table is empty. It seems useful that the algorithm would take the aggregated value (for population) available in such cases. Another example is over the period dimension: my population is a yearly value, so when calculating an indicator on a monthly basis, instead of taking the available yearly value, he takes zero. So my question: is this a deliberate choice in the development, a bug, or an idea for a future system improvement? Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Averaging over orgunits
Hi Lars, In my case it is definitely the averaging over both periods and orgunits which is most critical, the other ones are more nice to have. A backporting to 2.16 would be highly appreciated if possible. Kind regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 07 September 2014 16:24 To: Rodolfo Melia Cc: Robin Martens; dhis2-users; dhis2-d...@lists.launchpad.net Subject: Re: [Dhis2-devs] DHIS2 - Averaging over orgunits Hi there, we will try to get it in for 2.17. One question around the design: We currently have 7 aggregation operators: sum | average | count | std dev | variance | min | max Re individual aggregation operators for the time and org unit dimension, from a technical perspective we are not first aggregating in time, then in org unit dimension, rather aggregating it all in a single query to achieve good performance. Allowing for 7 x 7 = 49 possible combinations of aggregation operators will be complex to implement and some combinations might not be meaningful. I am sensing that it is doing average across both time and org unit which is the most useful combination we currently lack. Implementing this will be straight-forward and could even be back-ported to 2.16. So the question is: Will it be sufficient to come up with the most useful pre-defined combinations of time and org unit aggregation operators, or do we need to have full flexibility and allow all aggregation operators in both dimensions? If the former then please suggest which combinations are most useful. Already on the list: Sum Average Org unit: Average - Time: Sum Org unit: Sum - Time: Average Count Std dev Variance Min Max regards, Lars On Sun, Sep 7, 2014 at 2:10 AM, Rodolfo Melia rme...@knowming.commailto:rme...@knowming.com wrote: Hi - i just want to add support to the importance of splitting the aggregator operator across time and org units. I'm planning around its availability for 2.17 Rodolfo Meliá On 5 Sep 2014, at 17:26, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Lars, Thank you. I thought so but couldn't find the reference. In the blueprint it is assigned to release 2.17, is this still being maintained? Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 05 September 2014 18:24 To: Robin Martens Cc: dhis2-users; dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Subject: Re: DHIS2 - Averaging over orgunits Hi Robin, I get your point. This has actually been raised before and we plan to support individual aggregation operators for the org unit and time dimensions. Blueprint here: https://blueprints.launchpad.net/dhis2/+spec/orgunit-hierarchy-aggregation-operator regards, Lars On Thu, Sep 4, 2014 at 12:49 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi there, As per the manual, the average option when defining data elements aggregates by average over periods but sum over orgunits. This limits severely the reporting possibilities, for instance when calculating the average person age over multiple districts but I can think of many other examples (prices, age, education grades,...). Is there any way to configure DHIS2 to average over orgunits? Thank you, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Averaging over orgunits
Hi there, As per the manual, the average option when defining data elements aggregates by average over periods but sum over orgunits. This limits severely the reporting possibilities, for instance when calculating the average person age over multiple districts but I can think of many other examples (prices, age, education grades,...). Is there any way to configure DHIS2 to average over orgunits? Thank you, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Auto-calculated data in entry forms
Thanks for the input. I'll have a look at jQuery then! Regards, Robin From: Pamod Amarakoon [mailto:pam...@gmail.com] Sent: 02 September 2014 10:54 To: Ngoc Thanh Nguyen Cc: dhis2-devs; Robin Martens; Jason Pickering; DHIS 2 Users list Subject: Re: [Dhis2-devs] Auto-calculated data in entry forms Ook. Thanx :) On Tue, Sep 2, 2014 at 2:02 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: Hi it is already inside dhis2 (for every dhis2 page). no need for external import Thanh On Tue, Sep 2, 2014 at 2:17 PM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: Hi, Thanx. Is jquery available inside data entry form on the fly or has to link it separately to outside library. On Tue, Sep 2, 2014 at 12:31 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: great. surprised that a medical doctor can write that code. if you turn it to jquery it is much easier. anyway, its fine for now On Sep 2, 2014 11:54 AM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: Hi, Thanks a lot. In fact I'm a medical doctor and have limited knowledhe in Javascript. I managed to get it done with following javascript I created. height enterd in cm and weight in kg. script type=text/javascript function updateBMI() { var ht = document.getElementById(HeightID-val).value; var wt = document.getElementById(WeightID-val).value; if(ht!= wt!=){ var bmi = wt/(ht*ht/1); bmi = +bmi.toFixed(2); }else{ var bmi =Enter Height and Weight; } var inputbmi= document.getElementById(BMI-ID-val); inputbmi.value = bmi; } updateBMI(); /script It serves the purpose it seems. Pls suggest any modifications On Mon, Sep 1, 2014 at 11:52 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: yes you can use custom data entry form and add some js script like onchange event on weight and height. the event handler should then calculate the bmi and update the text field bmi. do you have any technical person to do this? if not give me your account i can help On Sep 2, 2014 12:26 AM, Pamod Amarakoon pam...@gmail.commailto:pam...@gmail.com wrote: I'd like to add something to this. For example, if we have a data entry form (BMI) for a program stage if we have height and weight input boxes/data elements is there a way to calculate BMI? is it only possible by using javascript/webapp On Mon, Sep 1, 2014 at 10:21 PM, Ngoc Thanh Nguyen thanh.hispviet...@gmail.commailto:thanh.hispviet...@gmail.com wrote: Hi I believe the calculated data value (now as indicator) can only be seen after an aggregation is run. In addition, in some forms in some countries like VN, auto-calculated data elements some time can be input by users. In VN, we use Javascript to achieve this. However, it is quite complicated. Imagine that you have to rebuild a spreadsheet engine. Important lesson learnt was if a dataelement is auto-calculated, make sure no one can change it manually. Otherwise, you end up with very low data quality. Thanh On Mon, Sep 1, 2014 at 11:15 PM, Jason Pickering jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com wrote: Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More
[Dhis2-users] DHIS2 - Clone event
Hi devs, Would it be possible to include a Clone event button in the Event Capture module? As some events might be very similar in overhead data, it might be useful to avoid duplication of work by cloning a previous entry and simply modifying the fields that vary. In my case, this duplication always happens on the same day (i.e. multiple events with the same report date, so no need to modify the report date). If this would be possible shortly, that would be great! Kind regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] road map
Hi Lars, Thanks for the transparency in the future development of DHIS2. About the seamless integration of event and routine data, does it mean the aggregation query module will be obsolete and replaced by a new system? If so, what level of complexity will be available for the new query system (multiple event data elements in one query, categories in queries,...)? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Lars Helge Øverland Sent: 08 August 2014 17:31 To: DHIS 2 Developers list; DHIS 2 Users list Subject: [Dhis2-users] road map Hi, we have made a road map which outlines the broad lines of the development plan of the DHIS 2 software for the next 9 months: https://www.dhis2.org/roadmap The individual features are subject to change. regards, Lars ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Auto-calculated data in entry forms
Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Auto-calculated data in entry forms
Hi Jason, I'm not sure if indicators can do the trick as: 1. They're not usable in data entry forms for tracked data; 2. They're not usable for further indicator calculation when used in data entry forms for aggregated data. (It is not possible to use indicators in the calculation of other indicators.) Can you confirm? Kind regards, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 01 September 2014 18:15 To: Robin Martens Cc: Lars Helge Øverland; DHIS 2 Developers list; DHIS 2 Users list Subject: Re: [Dhis2-devs] Auto-calculated data in entry forms Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, not contained in the data entry form, IF it exists for the same orgunit and period. Best regards, Jason On Mon, Sep 1, 2014 at 5:48 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, Does anyone know if there's a way to have auto-calculated fields in data entry forms? This auto-calculated field would then be available for further reporting and indicator calculation (i.e. it is a data element calculated based on other data elements in the same entry form). Actually, if it would be possible to calculate data elements based on other data elements outside of a data form, that would be great too (but if I remember well this is currently not possible). Thanks for any ideas, Robin ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.netmailto:dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Event list empty
Hi Abyot, I can register a new event, and it's there in the trackedentitydatavalue table, but when refreshing the page, the list is again empty with the same message ('there are no events'). Again no error logs, and only for this orgunit/program combination (yes, they were selected). Regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 07 August 2014 10:31 To: Robin Martens Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] DHIS2 - Event list empty Hi, The event report showing all your data answers my question. The analytic table does not affect your data. The label - There are no events - comes visible only when both orgunit and program are selected, but no event is found. There is also a scenario for the same label to appear when all available events are found empty. In the earlier system it was possible to create blank event inadvertently. Since you have seen your data in the reports module, we can rule out the case of blank events. You also said clearing the cache has no effect and there are no error logs. Can you confirm me if both orgunit and program are selected? Also do you see the button Register event? If so, are you able to add a new event? Thank you, Abyot. On Wed, Aug 6, 2014 at 11:51 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi, I'm not sure if I understand your question, but the event report shows all the data for each of the events. I'd like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data? Kind regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.commailto:aby...@gmail.com] Sent: 05 August 2014 21:50 To: Robin Martens Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] DHIS2 - Event list empty Hi, One possibility could be blank events... have you seen details of these events in the module they have come visible? Thank you, Abyot. On Aug 5, 2014 6:31 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi, I've got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine. There's no error log and clearing the cache didn't work. DHIS2.16/16253. Any ideas? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Event list empty
Hi, I'm not sure if I understand your question, but the event report shows all the data for each of the events. I'd like to check manually in the database to verify the entries. In which table does DHIS2 store its event data? Also, I understand that the data is moved to the analytics tables when running the analytics module, but is this a copy-paste or cut-paste of the data? Kind regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 05 August 2014 21:50 To: Robin Martens Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] DHIS2 - Event list empty Hi, One possibility could be blank events... have you seen details of these events in the module they have come visible? Thank you, Abyot. On Aug 5, 2014 6:31 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi, I've got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine. There's no error log and clearing the cache didn't work. DHIS2.16/16253. Any ideas? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Event capture forms printing approving
Thanks Lars, I'm looking forward to DHIS 2.17 then. Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 05 August 2014 16:06 To: Abyot Gizaw Cc: Robin Martens; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS2 - Event capture forms printing approving Abyot: Thanks for the quick reaction, well done. Robin: Your suggestions make sense and is something we have considered for a while. We have blueprints for image / document type data elements here: https://blueprints.launchpad.net/dhis2/+spec/document-dataelement-attribute-type https://blueprints.launchpad.net/dhis2/+spec/image-data-element-type regards, Lars On Fri, Aug 1, 2014 at 11:14 AM, Abyot Gizaw aby...@gmail.commailto:aby...@gmail.com wrote: Hi Robin, Yes, the printing feature is now implemented - both in trunk and 2.16. Thank you, Abyot. On Fri, Aug 1, 2014 at 10:58 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Hi Abyot, Thanks for your reply. If it wouldn't be too much of an effort, it would be great to have the printing option included somewhere soon (as it's important for reducing workload for data collectors). The other ones are nice-to-have at the moment. Regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.commailto:aby...@gmail.com] Sent: 01 August 2014 10:34 To: Robin Martens Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS2 - Event capture forms printing approving Hi Robin, Thank you for the feedback. As we pointed sometime back, we are in the process of overhauling the tracker module. In the process some features might be missing or not yet considered - the printing and approval you mentioned are two examples. I can quickly implement the printing feature and back-port it to 2.16. For approval and attachment, we need to take sometime to digest the requirement and come with a generic solution. Thank you, Abyot. On Wed, Jul 30, 2014 at 10:14 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, I didn't find so far any possibility for form printing (blank and filled) and event data approval procedures, as they are available for entries for aggregated data through data sets. Are these functionalities that are soon planned to be implemented? It would be very useful as it would avoid double work (e.g. filling in paper forms and electronic forms) and allow data approval for decentralized data collection. Thanks for the feedback, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Event list empty
Hi, I've got a small issue here: for a certain program and a certain orgunit, it displays the message 'There are no events through the Event Capture module, even if I know there are as the events are still visible in the Event Reports and Manual Aggregation modules. This is only the case for this single orgunit/program combination, all others work fine. There's no error log and clearing the cache didn't work. DHIS2.16/16253. Any ideas? Regards, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Event capture forms printing approving
Hi Abyot, Thanks for your reply. If it wouldn't be too much of an effort, it would be great to have the printing option included somewhere soon (as it's important for reducing workload for data collectors). The other ones are nice-to-have at the moment. Regards, Robin From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 01 August 2014 10:34 To: Robin Martens Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS2 - Event capture forms printing approving Hi Robin, Thank you for the feedback. As we pointed sometime back, we are in the process of overhauling the tracker module. In the process some features might be missing or not yet considered - the printing and approval you mentioned are two examples. I can quickly implement the printing feature and back-port it to 2.16. For approval and attachment, we need to take sometime to digest the requirement and come with a generic solution. Thank you, Abyot. On Wed, Jul 30, 2014 at 10:14 AM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, I didn't find so far any possibility for form printing (blank and filled) and event data approval procedures, as they are available for entries for aggregated data through data sets. Are these functionalities that are soon planned to be implemented? It would be very useful as it would avoid double work (e.g. filling in paper forms and electronic forms) and allow data approval for decentralized data collection. Thanks for the feedback, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Event capture forms printing approving
Hi all, Following my post of yesterday, here's some ideas for future functionalities for the event capture and data entry modules: 1. Data entry approval for events 2. Data entry form print-out (blank and filled) for events 3. Adding attachments to events and data sets (e.g. pictures or documents) What do you think of these? Are they somewhere on the to be implemented list or could we put them in a blueprint? Kind regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of Robin Martens Sent: 30 July 2014 10:14 To: dhis2-users@lists.launchpad.net Subject: [Dhis2-users] DHIS2 - Event capture forms printing approving Dear all, I didn't find so far any possibility for form printing (blank and filled) and event data approval procedures, as they are available for entries for aggregated data through data sets. Are these functionalities that are soon planned to be implemented? It would be very useful as it would avoid double work (e.g. filling in paper forms and electronic forms) and allow data approval for decentralized data collection. Thanks for the feedback, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Event capture forms printing approving
Dear all, I didn't find so far any possibility for form printing (blank and filled) and event data approval procedures, as they are available for entries for aggregated data through data sets. Are these functionalities that are soon planned to be implemented? It would be very useful as it would avoid double work (e.g. filling in paper forms and electronic forms) and allow data approval for decentralized data collection. Thanks for the feedback, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - Tracker data aggregation
Hi Sumudu, Great solution, and I was actually looking in the same direction as well. It's good to hear that it's indeed possible. Thanks a lot! Regards, Robin From: Dhis2-users [mailto:dhis2-users-bounces+martens=sher...@lists.launchpad.net] On Behalf Of sumudu weerasinghe Sent: 24 July 2014 02:43 To: Lars Helge Øverland Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS2 - Tracker data aggregation Hi Robin, I had the same issue as you said . I did it following way , but it may not be the correct way * build one aggregate query and save * go to database and find caseaggregationcondition table * identify how it identify DE * you can populate all query builders just in a excel sheet ( i will attach my sample excel sheet it contain 364 A.Q. Builders) * upload into database table caseaggregationcondition, as CSV file , It works for me well some time this may help you. @Lars answer i have some problem 1. is it able to use attributes in event reports ? 2. is it possible to save this values into a form in aggregate side (eg.Monthly return form) ? Best Regards Sumudu On Wed, Jul 23, 2014 at 11:58 AM, Lars Helge Øverland larshe...@gmail.commailto:larshe...@gmail.com wrote: Hi Robin, in fact the organisation unit dimension should not be part of the aggregation queries - you can set one aggregation query to run for any number of org units. You could create the gender and disease type as categories + category options. However you are right that to populate all variations of this data element you would need 2 x 5 aggregation queries. That said, in version 2.15 and 2.16 you have better support for doing aggregated analysis without using aggregation queries. The event reports app lets you create pivot tables and specify queries directly for aggregated data, and you can similarly create charts through the event visualizer app, which can then be included directly in the dashboard together with the routine data charts. Have a look at those apps on the /devhttps://apps.dhis2.org/dev instance - the queries can be specified on the left side panel e.g. under the data tab. These apps are backed by the event analytics web api resource (docshttps://www.dhis2.org/doc/snapshot/en/user/html/ch32s22.html). Our medium-term plan is to phase out the current aggregation queries function by instead linking routine elements with such event analytics queries. Now conceptually you would still have to define a query per such data element + category option combination - it isn't really trivial to convert events into aggregated data elements auto-magically. best regards, Lars ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - Versioning of data
Hi all, Just wondering if there's any way to implement a kind of versioning in DHIS2? With versioning, I mean having for instance a population census in 2010 of which the results are used in all indicator calculations between 2010 and 2012, i.e. until a new census is published. It's then the same for the new census. So basically a way to store data with validity dates used for reporting and indicator calculation. A possible solution might be to use data sets with a certain periodicity (e.g. 1 month) and copy-paste the previous value manually until an update takes place, but that's not a very elegant solution. A simple most recent value filter for reporting and indicator calculation for instance would already do for me (although it wouldn't give correct results for queries run on data from the past). Thanks for any input, Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] DHIS2 - No available data elements in program stage
Hi Lars, Thank you for the quick reply, that did the trick. However, does this mean there is currently no way to track aggregated data? I have been looking to use the Option Set functionality instead, but I'm not sure about its use for comments. Where precisely is it used and is it possible to use multiple Option Set for comment fields for 1 dataset, simulating a combined category as for aggregated data? Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 18 June 2014 17:04 To: Robin Martens Cc: dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] DHIS2 - No available data elements in program stage Hi Robin, when creating/editing the data element, make sure you set domain type to patient. This is not completely logical and has been changed to tracker in the upcoming version. regards, Lars On Wed, Jun 18, 2014 at 4:53 PM, Robin Martens mart...@sher.bemailto:mart...@sher.be wrote: Dear all, We're developing a Forestry ME System and currently analyzing the possibility of using DHIS2 for this purpose. During our first try-outs of the functionalities of DHIS 2.15, it seems there's no available data elements when creating a program stage. The program user has been set to Superuser (covering Admin role) and program OrgUnits are all available OrgUnits. Can anyone give a hint as to how to add data elements to a program stage and what we missed? Thanks in advance! Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.netmailto:dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] DHIS2 - No available data elements in program stage
Dear all, We're developing a Forestry ME System and currently analyzing the possibility of using DHIS2 for this purpose. During our first try-outs of the functionalities of DHIS 2.15, it seems there's no available data elements when creating a program stage. The program user has been set to Superuser (covering Admin role) and program OrgUnits are all available OrgUnits. Can anyone give a hint as to how to add data elements to a program stage and what we missed? Thanks in advance! Robin ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp