Re: [Dhis2-users] inport meta data to option set

2015-05-07 Thread Robin Martens
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

2015-05-07 Thread Robin Martens
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

2015-05-07 Thread Robin Martens
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

2015-04-29 Thread Robin Martens
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

2015-04-28 Thread Robin Martens
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

2015-03-28 Thread Robin Martens
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

2015-03-16 Thread Robin Martens
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

2015-03-16 Thread Robin Martens
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

2015-02-09 Thread Robin Martens
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?

2015-01-25 Thread Robin Martens
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?

2015-01-25 Thread Robin Martens
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

2015-01-23 Thread Robin Martens
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

2015-01-22 Thread Robin Martens
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

2015-01-21 Thread Robin Martens
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

2015-01-19 Thread Robin Martens
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

2015-01-19 Thread Robin Martens
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

2015-01-19 Thread Robin Martens
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

2014-09-17 Thread Robin Martens
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

2014-09-17 Thread Robin Martens
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

2014-09-17 Thread Robin Martens
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

2014-09-16 Thread Robin Martens
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?

2014-09-15 Thread Robin Martens
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?

2014-09-15 Thread Robin Martens
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

2014-09-12 Thread Robin Martens
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

2014-09-11 Thread Robin Martens
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

2014-09-11 Thread Robin Martens
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

2014-09-11 Thread Robin Martens
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

2014-09-10 Thread Robin Martens
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

2014-09-08 Thread Robin Martens
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

2014-09-04 Thread Robin Martens
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

2014-09-02 Thread Robin Martens
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

2014-09-02 Thread Robin Martens
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

2014-09-01 Thread Robin Martens
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

2014-09-01 Thread Robin Martens
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

2014-09-01 Thread Robin Martens
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

2014-08-07 Thread Robin Martens
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

2014-08-06 Thread Robin Martens
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

2014-08-05 Thread Robin Martens
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

2014-08-05 Thread Robin Martens
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

2014-08-01 Thread Robin Martens
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

2014-07-31 Thread Robin Martens
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

2014-07-30 Thread Robin Martens
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

2014-07-24 Thread Robin Martens
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

2014-07-16 Thread Robin Martens
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

2014-06-19 Thread Robin Martens
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

2014-06-18 Thread Robin Martens
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