Re: [Dhis2-users] Has metadata import stopped working?

[Olav Poppe]

Thanks for the clarification, Morten.

Regarding the last question, no, there was no feedback when it failed, only the 
hibernate-exception in the tomcat log. In the GUI, it was just stuck 
indefinitely on "importing X objects…"

This was 2.27 btw.

Olav


12. apr. 2018 kl. 11:09 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:


On Thu, Apr 12, 2018 at 1:54 PM, Olav Poppe 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
Hi,  I managed to solve the problem in the end. It was indeed caused by one 
single object being shared with a group I had not included in export…

Good

I’m still left with some questions though:
- even with skipValidation=true the import failed until I identified the extra 
user group - is that a bug, or are validation of user group sharing never 
skipped?

No, it simply bypasses the expensive validation phase... it does not ignore any 
errors (so they end up throwing hibernate issues), as it says in the docs, it 
should really only be used for cases where your metadata is pre approved to 
work... if not, it makes it very hard to find issues

- is "skipValidation=true" the same as "Reference mode" in the GUI? And why 
does neither actually skip/allow invalid references as it sound like they do?

No, its very different. In 2.28 and later we now have skipSharing=true/false 
for this exact use-case, in 2.30 we will also have skipSharing for exports.

- could we have a proper error message when this happens?

It does not give you a message for normal cases? (i.e. no skip validation)

--
Morten


Olav





12. apr. 2018 kl. 07:40 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:

Hi Olav

I see that you include sharing in these payloads, are you sure all user groups 
and users are included? did you try with skipSharing=true ? skipValidation is 
not really recommended, as it will not validate anything.. but still requires 
things to be correct (if its not, it will result in lots of hibernate 
exceptions..)


--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Wed, Apr 11, 2018 at 7:52 PM, Olav Poppe 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
Thanks, JM. This is an event progrmame, so it’s not the TE.

BUT I just managed to identify the culprit: One optionset was shared with a 
group not included in the export…

Morten, is valudation of sharing not skipped even with skipValidation=true? 
Would be nice with some feedback on what fails..

Olav


11. apr. 2018 kl. 13:42 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Olav
I didn’t check the dates on the thread, I thought Knut was still waiting for an 
answer.
Have you been able to determine which dependencies are affecting the import? 
Also, if this is a tracker program did you check if the UID of the TE is the 
same you have in the system?
Best regards,
JM


El 07/04/2018, a las 11:00, Olav Poppe 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> escribió:

Hi, I might be creating some confusion by reviving Knut’s old thread.

I heared from Knut that he resolved it by importing via the API, using the 
skipValidation=true option to get around dependency issues.

I’m getting the same error, but in this case importing a tracker programme. And 
in my case, skipValidation=true does not help. I initially tried with a 
metadata file which I had manually put together based on a couple of different 
exports, but even with a "vanilla" programme dependency export file I get this 
error, even with skipValidation=true.

Isaiah, thanks for the suggestion of doing this object by object - that might 
work, but I need to share this metadata file with different people and asking 
each one to import 10-15 files in order is not a good solutiom.

Any other suggestions?

Regards






7. apr. 2018 kl. 10:47 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Knut
Try splitting your import by org unit levels and do the import in order, 
starting with the lowest level (1, 2, 3...)
The problem happens because the import creates the objects out of order in 
regards to dependencies, in your case an org unit before its parent.
Best regards,
JM

On Fri, 6 Apr 2018, 15:57 Olav Poppe, 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
I’m having the same issue and error importing into an empty 2.27 database. 
Though in this case a slightly modified dependency export of a tracker 
programme, not orgunits.

Knut, did you find a solution?

Sending you the payload, Morten.

Olav


12. jan. 2018 kl. 08:39 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:

That sounds weird Knut, would you mind sharing the org unit payload?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org

Re: [Dhis2-users] Has metadata import stopped working?

[Olav Poppe]

Hi,  I managed to solve the problem in the end. It was indeed caused by one 
single object being shared with a group I had not included in export…

I’m still left with some questions though:
- even with skipValidation=true the import failed until I identified the extra 
user group - is that a bug, or are validation of user group sharing never 
skipped?
- is "skipValidation=true" the same as "Reference mode" in the GUI? And why 
does neither actually skip/allow invalid references as it sound like they do?
- could we have a proper error message when this happens?

Olav





12. apr. 2018 kl. 07:40 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:

Hi Olav

I see that you include sharing in these payloads, are you sure all user groups 
and users are included? did you try with skipSharing=true ? skipValidation is 
not really recommended, as it will not validate anything.. but still requires 
things to be correct (if its not, it will result in lots of hibernate 
exceptions..)


--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Wed, Apr 11, 2018 at 7:52 PM, Olav Poppe 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
Thanks, JM. This is an event progrmame, so it’s not the TE.

BUT I just managed to identify the culprit: One optionset was shared with a 
group not included in the export…

Morten, is valudation of sharing not skipped even with skipValidation=true? 
Would be nice with some feedback on what fails..

Olav


11. apr. 2018 kl. 13:42 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Olav
I didn’t check the dates on the thread, I thought Knut was still waiting for an 
answer.
Have you been able to determine which dependencies are affecting the import? 
Also, if this is a tracker program did you check if the UID of the TE is the 
same you have in the system?
Best regards,
JM


El 07/04/2018, a las 11:00, Olav Poppe 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> escribió:

Hi, I might be creating some confusion by reviving Knut’s old thread.

I heared from Knut that he resolved it by importing via the API, using the 
skipValidation=true option to get around dependency issues.

I’m getting the same error, but in this case importing a tracker programme. And 
in my case, skipValidation=true does not help. I initially tried with a 
metadata file which I had manually put together based on a couple of different 
exports, but even with a "vanilla" programme dependency export file I get this 
error, even with skipValidation=true.

Isaiah, thanks for the suggestion of doing this object by object - that might 
work, but I need to share this metadata file with different people and asking 
each one to import 10-15 files in order is not a good solutiom.

Any other suggestions?

Regards






7. apr. 2018 kl. 10:47 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Knut
Try splitting your import by org unit levels and do the import in order, 
starting with the lowest level (1, 2, 3...)
The problem happens because the import creates the objects out of order in 
regards to dependencies, in your case an org unit before its parent.
Best regards,
JM

On Fri, 6 Apr 2018, 15:57 Olav Poppe, 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
I’m having the same issue and error importing into an empty 2.27 database. 
Though in this case a slightly modified dependency export of a tracker 
programme, not orgunits.

Knut, did you find a solution?

Sending you the payload, Morten.

Olav


12. jan. 2018 kl. 08:39 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:

That sounds weird Knut, would you mind sharing the org unit payload?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Fri, Jan 12, 2018 at 2:19 AM, Knut Staring 
<knu...@gmail.com<mailto:knu...@gmail.com>> wrote:
I have tried doing metadata export without sharing from 2.27 and importing into 
2.27, just the OU hierarchy and levels.

Importing into a clean instance gives this:

 INFO  2018-01-11 20:16:06,750 [Level: INFO, category: METADATA_IMPORT, time: 
Thu Jan 11 20:16:06 CET 2018, message: (admin) Creating 8 object(s) of type 
OrganisationUnitLevel] (InMemoryNotifier.java [taskScheduler-4])
* ERROR 2018-01-11 20:16:07,764 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-4])
org.hibernate.TransientObjectException: object references an unsaved transient 
instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit
at 
org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:279)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:462)
at o

Re: [Dhis2-users] Has metadata import stopped working?

[Olav Poppe]

Thanks, JM. This is an event progrmame, so it’s not the TE.

BUT I just managed to identify the culprit: One optionset was shared with a 
group not included in the export…

Morten, is valudation of sharing not skipped even with skipValidation=true? 
Would be nice with some feedback on what fails..

Olav


11. apr. 2018 kl. 13:42 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Olav
I didn’t check the dates on the thread, I thought Knut was still waiting for an 
answer.
Have you been able to determine which dependencies are affecting the import? 
Also, if this is a tracker program did you check if the UID of the TE is the 
same you have in the system?
Best regards,
JM


El 07/04/2018, a las 11:00, Olav Poppe 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> escribió:

Hi, I might be creating some confusion by reviving Knut’s old thread.

I heared from Knut that he resolved it by importing via the API, using the 
skipValidation=true option to get around dependency issues.

I’m getting the same error, but in this case importing a tracker programme. And 
in my case, skipValidation=true does not help. I initially tried with a 
metadata file which I had manually put together based on a couple of different 
exports, but even with a "vanilla" programme dependency export file I get this 
error, even with skipValidation=true.

Isaiah, thanks for the suggestion of doing this object by object - that might 
work, but I need to share this metadata file with different people and asking 
each one to import 10-15 files in order is not a good solutiom.

Any other suggestions?

Regards






7. apr. 2018 kl. 10:47 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Knut
Try splitting your import by org unit levels and do the import in order, 
starting with the lowest level (1, 2, 3...)
The problem happens because the import creates the objects out of order in 
regards to dependencies, in your case an org unit before its parent.
Best regards,
JM

On Fri, 6 Apr 2018, 15:57 Olav Poppe, 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
I’m having the same issue and error importing into an empty 2.27 database. 
Though in this case a slightly modified dependency export of a tracker 
programme, not orgunits.

Knut, did you find a solution?

Sending you the payload, Morten.

Olav


12. jan. 2018 kl. 08:39 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:

That sounds weird Knut, would you mind sharing the org unit payload?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Fri, Jan 12, 2018 at 2:19 AM, Knut Staring 
<knu...@gmail.com<mailto:knu...@gmail.com>> wrote:
I have tried doing metadata export without sharing from 2.27 and importing into 
2.27, just the OU hierarchy and levels.

Importing into a clean instance gives this:

 INFO  2018-01-11 20:16:06,750 [Level: INFO, category: METADATA_IMPORT, time: 
Thu Jan 11 20:16:06 CET 2018, message: (admin) Creating 8 object(s) of type 
OrganisationUnitLevel] (InMemoryNotifier.java [taskScheduler-4])
* ERROR 2018-01-11 20:16:07,764 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-4])
org.hibernate.TransientObjectException: object references an unsaved transient 
instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit
at 
org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:279)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:462)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:281)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:291)
at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:322)
at 
org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:4204)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:528)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:215)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:142)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:216)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:85)
at 
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
at 
org.hisp.dhis.dbms.HibernateDbmsManager.clearSession(HibernateDbmsManager.java:339)
at 
org.hisp.dhis.dxf2.met

Re: [Dhis2-users] Has metadata import stopped working?

[Olav Poppe]

Hi, I might be creating some confusion by reviving Knut’s old thread.

I heared from Knut that he resolved it by importing via the API, using the 
skipValidation=true option to get around dependency issues.

I’m getting the same error, but in this case importing a tracker programme. And 
in my case, skipValidation=true does not help. I initially tried with a 
metadata file which I had manually put together based on a couple of different 
exports, but even with a "vanilla" programme dependency export file I get this 
error, even with skipValidation=true.

Isaiah, thanks for the suggestion of doing this object by object - that might 
work, but I need to share this metadata file with different people and asking 
each one to import 10-15 files in order is not a good solutiom.

Any other suggestions?

Regards






7. apr. 2018 kl. 10:47 skrev JM Alcantara 
<jmalcanta...@gmail.com<mailto:jmalcanta...@gmail.com>>:

Hi Knut
Try splitting your import by org unit levels and do the import in order, 
starting with the lowest level (1, 2, 3...)
The problem happens because the import creates the objects out of order in 
regards to dependencies, in your case an org unit before its parent.
Best regards,
JM

On Fri, 6 Apr 2018, 15:57 Olav Poppe, 
<ola...@ifi.uio.no<mailto:ola...@ifi.uio.no>> wrote:
I’m having the same issue and error importing into an empty 2.27 database. 
Though in this case a slightly modified dependency export of a tracker 
programme, not orgunits.

Knut, did you find a solution?

Sending you the payload, Morten.

Olav


12. jan. 2018 kl. 08:39 skrev Morten Olav Hansen 
<mor...@dhis2.org<mailto:mor...@dhis2.org>>:

That sounds weird Knut, would you mind sharing the org unit payload?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org<http://www.dhis2.org/>

On Fri, Jan 12, 2018 at 2:19 AM, Knut Staring 
<knu...@gmail.com<mailto:knu...@gmail.com>> wrote:
I have tried doing metadata export without sharing from 2.27 and importing into 
2.27, just the OU hierarchy and levels.

Importing into a clean instance gives this:

 INFO  2018-01-11 20:16:06,750 [Level: INFO, category: METADATA_IMPORT, time: 
Thu Jan 11 20:16:06 CET 2018, message: (admin) Creating 8 object(s) of type 
OrganisationUnitLevel] (InMemoryNotifier.java [taskScheduler-4])
* ERROR 2018-01-11 20:16:07,764 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-4])
org.hibernate.TransientObjectException: object references an unsaved transient 
instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit
at 
org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:279)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:462)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:281)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:291)
at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:322)
at 
org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:4204)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:528)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:215)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:142)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:216)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:85)
at 
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
at 
org.hisp.dhis.dbms.HibernateDbmsManager.clearSession(HibernateDbmsManager.java:339)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 
org.springframework.transaction.interceptor.TransactionIn

Re: [Dhis2-users] Has metadata import stopped working?

[Olav Poppe]

I’m having the same issue and error importing into an empty 2.27 database. 
Though in this case a slightly modified dependency export of a tracker 
programme, not orgunits.

Knut, did you find a solution?

Sending you the payload, Morten.

Olav


12. jan. 2018 kl. 08:39 skrev Morten Olav Hansen 
>:

That sounds weird Knut, would you mind sharing the org unit payload?

--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Fri, Jan 12, 2018 at 2:19 AM, Knut Staring 
> wrote:
I have tried doing metadata export without sharing from 2.27 and importing into 
2.27, just the OU hierarchy and levels.

Importing into a clean instance gives this:

 INFO  2018-01-11 20:16:06,750 [Level: INFO, category: METADATA_IMPORT, time: 
Thu Jan 11 20:16:06 CET 2018, message: (admin) Creating 8 object(s) of type 
OrganisationUnitLevel] (InMemoryNotifier.java [taskScheduler-4])
* ERROR 2018-01-11 20:16:07,764 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-4])
org.hibernate.TransientObjectException: object references an unsaved transient 
instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit
at 
org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:279)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:462)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:281)
at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:291)
at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:322)
at 
org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:4204)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:528)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:215)
at 
org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:142)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:216)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:85)
at 
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
at 
org.hisp.dhis.dbms.HibernateDbmsManager.clearSession(HibernateDbmsManager.java:339)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy189.commit(Unknown Source)
at 
org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:127)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 

[Dhis2-users] dataElementOperand API - java.lang.ArrayIndexOutOfBoundsException

[Olav Poppe]

Hi all, 
we’re having some issues with the dataElementOperands endpoint (DHIS 2.26). 
Specifically, 500 Internal server error from /api/dataElementOperands, with 
seemingly no relevant errors in the tomcat log. Has anyone experienced this 
and/or have any suggestions on how to fix it?

Regards
Olav






___
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] what's mean of period type today?

[Olav Poppe]

Hi easy, 
you won’t see your data on the same day ("today") unless you update analytics 
first. Normally this happens only every night, but it could be triggered more 
frequently.

Olav



> 6. okt. 2017 kl. 16:45 skrev 林晓东 :
> 
> hi,all.
> 
>   I found in the develop version of dhis2, there is period type of days like 
> today, latest 3 days ,what's mean of today? 
>   that's to say, we can view DE data value in pivot table as soon as the DE 
> value just   inputted in data entry form?
>   I do some test , but can't view .
> Thanks.
> 
> 
> 
> --
> 此致
> easy
> 
> 莫愁前路无知己，天下谁人不识君。
> 
> 
> 【网易自营】好吃到爆！鲜香弹滑加热即食，经典13香/麻辣小龙虾仅75元3斤>>    
>    
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : 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] Bug in option set while cloning

[Olav Poppe]

I can add that we similarly discovered this morning that cloning a program rule 
will remove the program rule actions from the original program rule - will add 
a jira issue for that as well.

> 6. okt. 2017 kl. 09:46 skrev Lars Helge Øverland :
> 
> Hi Seid,
> 
> okay that is not good. Can you please report in Jira and share the link.
> 
> regards,
> 
> Lars
> 
> 
> On Fri, Oct 6, 2017 at 10:01 AM, Seid Hussein  > wrote:
> Hi all,
> 
> We were cloning option sets and it appears that while the new option set will 
> get all the options in the original one, the options are removed from the old 
> option set.
> 
> I have recreated the issue on the demo site as well.
> 
> Regards,
> 
> 
> Seid,
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> 
> Post to : dhis2-d...@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
> 
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org 
> http://www.dhis2.org 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : 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] Dataelementoperands issue (?)

[Olav Poppe]

Hi all, 
I’m trying to sort out a strange error, with a data set that cannot be saved 
(updated) in Maintenance. When trying to save, we get a "Can not save data set" 
message, and in the log we get this:
* ERROR 2017-09-21 11:42:03,836 ERROR: update or delete on table 
"dataelementoperand" violates foreign key constraint 
"fk_datadimensionitem_dataelementoperandid" on table "datadimensionitem"
  Detail: Key (dataelementoperandid)=(1624162) is still referenced from table 
"datadimensionitem". (SqlExceptionHelper.java [tomcat-http-26])
org.hibernate.exception.ConstraintViolationException: could not execute 
statement
(full log below)

I’m not able to figure out what sort of changes to dataelementoperand are 
supposed to happen. What we’re trying to change is simply the dataset 
assignment, so nothing to do with the data elements at all. AFAIK (and can see 
from the lastupdated properties), there haven’t been any changes to the data 
elements, categorycombos etc that are part of the dataset.

Any ideas on what the problem might be?

Regards
Olav


* INFO  2017-09-21 11:42:03,688 (olavpo) Updating 1 object(s) of type DataSet 
(DefaultObjectBundleService.java [tomcat-http-26])
* WARN  2017-09-21 11:42:03,835 SQL Error: 0, SQLState: 23503 
(SqlExceptionHelper.java [tomcat-http-26])
* ERROR 2017-09-21 11:42:03,836 ERROR: update or delete on table 
"dataelementoperand" violates foreign key constraint 
"fk_datadimensionitem_dataelementoperandid" on table "datadimensionitem"
  Detail: Key (dataelementoperandid)=(1624162) is still referenced from table 
"datadimensionitem". (SqlExceptionHelper.java [tomcat-http-26])
org.hibernate.exception.ConstraintViolationException: could not execute 
statement
at 
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
at 
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at 
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
at 
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at 
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3259)
at 
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3496)
at 
org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:98)
at 
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582)
at 
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at 
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.hooks.DataSetObjectBundleHook.preUpdate(DataSetObjectBundleHook.java:143)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$null$7(DefaultObjectBundleService.java:257)
at java.util.ArrayList.forEach(ArrayList.java:1249)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$handleUpdates$8(DefaultObjectBundleService.java:257)
at java.util.ArrayList.forEach(ArrayList.java:1249)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.handleUpdates(DefaultObjectBundleService.java:254)
at 
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at 

Re: [Dhis2-users] Avoid double registration of Tracked entities

[Olav Poppe]

Hi, 
haven’t tested if this is even possible with attributes, but with the program 
rule ASSIGN functionality, you could potentially have a program rule that 
concatenates your different attributes into one, and you have a unique 
constrain on that. For example if you have first name, last name, date of birth 
as variables, you make a "unique id" attribute which is "John-Doe-20170843".

Just a thought.

Regards
Olav


> 12. sep. 2017 kl. 09.38 skrev Georgi Chakarov :
> 
> Thank you both!
>  
> I will implement the unique ID for the time being, although the client does 
> not always have an ID for its clients, especially for babies. The other thing 
> is that they want ID’s to be automatically generated by DHIS2, which excludes 
> the option of anchoring around the ID. Anyhow…
>  
> Thanks again!
>  
> Georgi
>  
> From: Adebusoye Anifalaje [mailto:bus...@baosystems.com 
> ] 
> Sent: Tuesday, September 12, 2017 10:34 AM
> To: Georgi Chakarov  >
> Cc: Abyot Asalefew Gizaw >; Stanley 
> Kalyati >; 
> dhis2-users@lists.launchpad.net ; 
> DHIS 2 developers  >
> Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities
>  
> Hi Georgi,
>  
> Great to connect again. 
>  
> Abyot is right: unless you implement a unique identifier scheme for each 
> record, there is currently no way to achieve what you want. If you can wait, 
> the feature will eventually make it into the core s/w. 
>  
> Alternatively, if you can’t wait, what I was proposing was not for end users 
> to run a query. Rather, the query would already be created with a standard 
> report template (HTML?) to go with it. The end user would only be required to 
> click on generate report. You can add parameters to the report like org unit 
> (e.g. looking for duplicates within a specific org unit). 
>  
> Not sure you have many options at this stage.
>  
> Cheers.
> 
> - -
>  
> 
> 
> 
> Busoye Anifalaje (PhD)
> Director of Services (Principal), BAO Systems
> UK: +44 7901-740-757 | US: +1 682-307-0986|
>  bus...@baosystems.com  | 
> http://www.baosystems.com  |
> Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007
>  
> On 12 Sep 2017, at 08:27, Georgi Chakarov  > wrote:
>  
> Hello Adebusoye!
> 
> 
> Nice to hear from you again, since our meeting in London at the WW Summit!
>  
> Thank you for your thoughts! The thing is, I can’t really tell data entry 
> people, working on the field to run a query. They simply can’t. This needs to 
> be a user interface solution. Do you have other ideas in mind?
>  
> Georgi
>  
> From: Adebusoye Anifalaje [mailto:bus...@baosystems.com 
> ] 
> Sent: Tuesday, September 12, 2017 10:23 AM
> To: Georgi Chakarov  >
> Cc: Abyot Asalefew Gizaw >; Stanley 
> Kalyati >; 
> dhis2-users@lists.launchpad.net ; 
> DHIS 2 developers  >
> Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities
>  
> Hi Georgi,
>  
> You can always create a query that identifies duplicates based on any number 
> or combination of parameters. The query could then be wrapped in a report 
> that end users can run ad hoc.
>  
> Best
>  
> - -
>  
> 
> 
> 
> 
> Busoye Anifalaje (PhD)
> Director of Services (Principal), BAO Systems
> UK: +44 7901-740-757 | US: +1 682-307-0986|
>  bus...@baosystems.com  | 
> http://www.baosystems.com  |
> Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007
>  
> On 12 Sep 2017, at 08:18, Georgi Chakarov  > wrote:
>  
> Hi,
>  
> This will not work, because each of this attributes can have a duplicate. 
> E.g. you might have two persons by the name of “John”. It is the combination 
> of those attributes that needs to be unique, as it is less likely to have two 
> people with the same First Name and Surname, born on the same date.
>  
> There should be another solution. Our clients are very surprised how a system 
> is unable to lookup in the existing records and identify duplicates. Anyone?
>  
> Georgi
>  
> From: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org ] 
> Sent: Tuesday, September 12, 2017 10:13 AM
> To: Stanley Kalyati >
> Cc: Georgi 

Re: [Dhis2-users] Data elements not showing in data set creation view

[Olav Poppe]

Hi Jesus, 
could it be that you set the "Domain type" property of the data elements to 
"Tracker" rather than "Aggregate"? Data sets are for aggregate data, and you 
can therefore only add data elements with domain type aggregate.

Regards
Olav




> 29. jun. 2017 kl. 20.16 skrev Jesus Solano-Roman :
> 
> Hello.
> 
> Hopefully someone can help me understand this behavior. I've attached 
> pictures showing I've created a series of data elements, but when I try to 
> create a dataset, they are not listed under the available datasets. I've made 
> sure this user has power user clearance and the orgunit assigned to him.
> 
> Is this behavior expected? How can I fix this?
> 
> 
> Thanks for the help.
>  elements.png>___
> 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


___
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] Predictors for "carry forward" and cohorts

[Olav Poppe]

Thanks Nick, I think you describe a potentially «generic» approach to copying 
data N months forward which I didn’t think of! Essentially setting the 
sequential sample count to N and the skip count to N-1 (or N+1 and N - will 
have to test). If there aren’t any limits in how many months back you could go, 
this could take care of any cohort period, e.g. 12, 24, 36 etc.

Regards
Olav





> 29. jun. 2017 kl. 13.33 skrev Shurajit Dutta <shurajitdu...@gmail.com>:
> 
> Sorry!
> 
> I thought about this for a second again. For 6 months I think it's more like 
> this
> 
> Period type = Monthly
> Annual sample count = 0
> Sequential sample count = 5
> Sequential skip count = 4
> 
> This would eg. take data only from January 2017 to fill in the June 2017 
> cohort. 
> 
> On Jun 29, 2017 10:23 PM, "Shurajit Dutta" <shurajitdu...@gmail.com 
> <mailto:shurajitdu...@gmail.com>> wrote:
> Hi Olav
> 
> I am not sure about all cohort types, would have to look a bit more. I 
> believe for 6 months cohort it might work like this (remember I haven't 
> tested). 
> 
> Period type = Monthly
> Annual sample count = 0
> Sequential sample count = 6
> Sequential skip = 5
> 
> Then it would exclude the first 5 months of data in relation to the sample 
> selected while also going 6 months back.
> 
> I guess you could potentially do the same for the other cohorts as long as 
> your skip identified how far back you went?
> 
> Perhaps I need to test this myself
> 
> Nick
> 
> 
> On Jun 27, 2017 8:44 PM, "Olav Poppe" <olav.po...@me.com 
> <mailto:olav.po...@me.com>> wrote:
> Hi all,
> I wanted to check if anyone had any experience using predictors for 1) «carry 
> forward» of values from one period to the following, or 2) copying cohort 
> data forward?
> 
> As far as I can tell from some limited testing, 1) should work as it is now 
> by setting sequential sample count to 1 and annual sample count to 0. You 
> could then for example copy ending balance for May 2017 to starting balance 
> June 2017 etc. (note: I don’t mean to start a discussion how to collect data 
> on stock).
> 
> Moving forward cohorts would similarly work today, but only for 12 month 
> cohorts as far as I can figure out. From what I understand, even 12-month 
> cohorts are sometimes in reality reported after e.g. 14 months, and there are 
> of course others (6 months, 24 months, 36 months). At least on the surface, 
> it would seem adding support for specifying the sample period as X months 
> back would be a relatively straightforward thing, and it would be very 
> helpful for this purpose. I know people are using custom script for this type 
> of thing today.
> 
> Regards
> Olav
> 
> 
> 
> 
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-users@lists.launchpad.net 
> <mailto:dhis2-users@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <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] Predictors for "carry forward" and cohorts

[Olav Poppe]

Hi all,
I wanted to check if anyone had any experience using predictors for 1) «carry 
forward» of values from one period to the following, or 2) copying cohort data 
forward?

As far as I can tell from some limited testing, 1) should work as it is now by 
setting sequential sample count to 1 and annual sample count to 0. You could 
then for example copy ending balance for May 2017 to starting balance June 2017 
etc. (note: I don’t mean to start a discussion how to collect data on stock).

Moving forward cohorts would similarly work today, but only for 12 month 
cohorts as far as I can figure out. From what I understand, even 12-month 
cohorts are sometimes in reality reported after e.g. 14 months, and there are 
of course others (6 months, 24 months, 36 months). At least on the surface, it 
would seem adding support for specifying the sample period as X months back 
would be a relatively straightforward thing, and it would be very helpful for 
this purpose. I know people are using custom script for this type of thing 
today.

Regards
Olav






___
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] Translation

[Olav Poppe]

And cleared browser cache, if you log in on from the same computer?

Olav




> 30. nov. 2016 kl. 07.54 skrev GROUT, Lise :
> 
> Yes I did. The interface is correctly translated but not our dataelements. 
> 
> Lise
> 
> Sent from my iPhone
> 
> On 30 Nov 2016, at 03:44, Knut Staring  > wrote:
> 
>> Hi Lise,
>> 
>> I assume you have checked both language settings, i.e. both user interface 
>> and database language?
>> 
>> Knut
>> 
>> On Wed, Nov 30, 2016 at 8:03 AM, GROUT, Lise > > wrote:
>> Dear all,
>> 
>>  
>> 
>> We need to display the programmes and datasets we have developed in several 
>> languages. We have translated several data elements (initially created in 
>> English) in French. When I click on them in the maintenance App, I can see 
>> the translation in French locale.
>> 
>>  
>> 
>> We have created users with French as default language. But still when we 
>> open event and tracker capture, all the data elements are displayed in 
>> English… Are we missing a step to activate the translations?
>> 
>>  
>> 
>> We are using Version 2.25, Build: 8feec9a
>> 
>>  
>> 
>> Best
>> 
>>  
>> 
>> Lise.
>> 
>>  
>> 
>> 
>> ___
>> 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 
>> 
>> 
>> 
>> 
>> 
>> -- 
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org 
>> ___
> 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

___
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] Detailed Meta-Data Export in 2.25

[Olav Poppe]

I think there are cases where you want to include data elements/indicators, and 
cases where you would not want to include it - so for me, the ideal would be 
that there was a choice. 

A challenge at least as of 2.24 (was unable to test in 2.25, import failed) is 
that if you import a favourite into a database where the data items are 
missing, you can’t manually modify/add those in DV/PT/GIS favorite because the 
favorite won’t open. So for now, you really need the data element/indicators to 
be included if importing these in a database where the data items are 
different. If it had been possible to edit imported favorites with missing data 
dimension, not including the data items would have been good solution in many 
cases. With 2.25, you could even have used the "favorite description" to guide 
people in configuring the imported favorites to their database. So an 
additional feature request would be the ability modify "ill-defined" favorites.

Olav


> 29. okt. 2016 kl. 23.40 skrev Lars Helge Øverland :
> 
> How far should the dependencies go? Stop at favorites (pivot tables, maps 
> etc), or include data elements/categories/indicators etc?

___
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] Program Rules

[Olav Poppe]

Hi, if you are using version 2.24 there is a program rule action called "Show 
error preventing completing". This let’s you make a program rule to make the 
pregnancy age mandatory only for pregnant women (with a condition line 
"pregnancy" = true && pregnancyAge == ''), instead of setting the field to 
mandatory in the program stage configuration.

Olav


> 7. okt. 2016 kl. 16.43 skrev Amone Junior. Felimone 
> :
> 
> Dear all,
> 
> I have a tracker program and i set a field as mandatory, however this field 
> is not applicable to every case. The field is pregnancy age which is 
> mandatory to every pregnant women but not applicable to non pregnant and to 
> male participants.
> i am able to hide the field through a program rule but it always fails 
> validation for non pregnant. 
> How can i keep the field mandatory only for pregnant women?
> Thanks
> -- 
> Felimone Amone Junior
> Data Manager
> Centro de Investigação em Saúde de Manhiça (CISM)
> Tel./Fax: (+258) 21 81 00 02/181
> CP 1929 Maputo - Moçambique
> Página Web: www.manhica.org 
> E-mail: amone.felim...@manhica.net 
> 
> DISCLAIMER:
> Esta mensagem pode conter dados confidenciais e/ou privados. Se recebeu a 
> mensagem por erro, queira informar-nos respondendo a este e-mail e elimina-lo 
> de seguida do seu sistema. Muito obrigado pela sua cooperação.
> CISM - Centro de Investigação em Saúde de Manhiça
> 
> This message may contain confidential and/or privileged information. If you 
> have recived this message in error, please notify us immediatly by respondig 
> to this e-mail and then delete it from your system. Thank for your 
> cooperation.
> By CISM - Centro de Investigação em Saúde de Manhiça
> 
> ___
> 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

___
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] Browser not working

[Olav Poppe]

The two servers I’m currently experiencing this with is using dhis2-tools, and 
I assume the one Tony wrote about earlier is using the same. 

As for logs, catalina.out shows the following:
* WARN  2016-07-19 21:18:41,983 Authentication event 
AuthenticationSuccessEvent: olavpo; details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: 
RemoteIpAddress: 127.0.0.1; SessionId: 2FD09C6C6D9D1DEE16E8E38A8F7A38DE 
(LoggerListener.java [tomcat-http-9])
* WARN  2016-07-19 21:18:41,984 Authentication event 
SessionFixationProtectionEvent: olavpo; details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: 
RemoteIpAddress: 127.0.0.1; SessionId: 2FD09C6C6D9D1DEE16E8E38A8F7A38DE 
(LoggerListener.java [tomcat-http-9])
* WARN  2016-07-19 21:18:41,984 Authentication event 
InteractiveAuthenticationSuccessEvent: olavpo; details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@380f4: 
RemoteIpAddress: 127.0.0.1; SessionId: 2FD09C6C6D9D1DEE16E8E38A8F7A38DE 
(LoggerListener.java [tomcat-http-9])
* INFO  2016-07-19 21:18:41,987 'olavpo' update 
org.hisp.dhis.user.UserCredentials, name: Olav Poppe, uid: R8ZvjXptEW2 
(AuditLogUtil.java [tomcat-http-9])

And nginx access.log the following (nothing in error.log):
1.76.8.51 - - [19/Jul/2016:21:28:02 +] "GET 
/dhis/dhis-web-commons-stream/ping.action?_=1468963693718 HTTP/1.1" 200 34 
"https://XXX/dhis/dhis-web-dataentry/index.action; "Mozilla/5.0 (Windows NT 
6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.8 
Safari/537.36"
212.60.79.122 - - [19/Jul/2016:21:28:26 +] "POST 
/staging/dhis-web-commons-security/login.action HTTP/1.1" 302 0 
"https://XXX/staging/dhis-web-commons/security/login.action; "Mozilla/5.0 
(Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, like Gecko) 
Chrome/51.0.2704.106 Safari/537.36"
212.60.79.122 - - [19/Jul/2016:21:28:26 +] "GET /staging HTTP/1.1" 301 193 
"-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, 
like Gecko) Chrome/51.0.2704.106 Safari/537.36"
212.60.79.122 - - [19/Jul/2016:21:28:26 +] "GET /staging HTTP/1.1" 302 0 
"-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, 
like Gecko) Chrome/51.0.2704.106 Safari/537.36"
212.60.79.122 - - [19/Jul/2016:21:28:26 +] "GET 
/staging/dhis-web-commons/security/login.action HTTP/1.1" 301 193 "-" 
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, 
like Gecko) Chrome/51.0.2704.106 Safari/537.36"
212.60.79.122 - - [19/Jul/2016:21:28:26 +] "GET 
/staging/dhis-web-commons/security/login.action HTTP/1.1" 200 1439 "-" 
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, 
like Gecko) Chrome/51.0.2704.106 Safari/537.36"
212.60.79.122 - - [19/Jul/2016:21:28:26 +] "GET 
/staging/api/staticContent/logo_front HTTP/1.1" 302 0 
"https://XXX/staging/dhis-web-commons/security/login.action; "Mozilla/5.0 
(Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, like Gecko) 
Chrome/51.0.2704.106 Safari/537.36"
41.76.8.51 - - [19/Jul/2016:21:28:33 +] "GET 
/dhis/dhis-web-commons-stream/ping.action?_=1468963724720 HTTP/1.1" 200 34 
"https://XXX/dhis/dhis-web-dataentry/index.action; "Mozilla/5.0 (Windows NT 
6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.8 
Safari/537.36"

And I can also add that I have the same issue with Chrome Canary.

Olav




> 19. jul. 2016 kl. 20.27 skrev Steven Uggowitzer <whoto...@gmail.com>:
> 
> Jason, what aspects of the Nginx config?
> I have at least a dozen sites running with same parameters (using include 
> blocks) and only the ones with 2.24 seem to be having this issue.  
> 
> Would it help to post those parameters?   What did you conclude was causing 
> the problem when you last encountered it?
> 
> S
> 
> 
> --
> Steven Uggowitzer
> eSHIfT Partner Network,  Entuura Ventures Ltd
> Tel: +41 22 366 1920 <>
> Mob: +41 79 719 4180 <>
> Skype: fendant123
> LinkedIn: http://ch.linkedin.com/in/stevenuggowitzer 
> <http://ch.linkedin.com/in/stevenuggowitzer>
> On 19 July 2016 at 19:17, Jason Pickering <jason.p.picker...@gmail.com 
> <mailto:jason.p.picker...@gmail.com>> wrote:
> I have seen this before as well, but never like it has been described here. 
> In my case, it was related to an incorrect nginx config. 
> 
> Is there something common here? Are all of you using dhis-tools, or homebaked 
> nginx configurations? 
> 
> Does the browser/Tomcat/nginx log provide any useful information?
> 
> Do you observe the same thing if you attempt 

Re: [Dhis2-users] Browser not working

[Olav Poppe]

I can confirm that I now see the same issue in non-2.22 as well. Very strange 
behavior - I can at times log in, but is then logged off when navigation 
between different modules.



> 19. jul. 2016 kl. 15.28 skrev Olav Poppe <olav.po...@me.com>:
> 
> Forwarding to user list. Not 2.24 issue then it seems.
> 
> Olav
> 
> 
> 
>> Videresendt melding:
>> 
>> Fra: ifeanyiok...@yahoo.com <mailto:ifeanyiok...@yahoo.com>
>> Emne: Re: [Dhis2-users] Browser not working
>> Dato: 19. juli 2016 kl. 15.19.34 GMT
>> Til: Olav Poppe <olav.po...@me.com <mailto:olav.po...@me.com>>
>> 
>> Just to add that I'm using version 2.22 build 22086
>> 
>> 
>> From: Olav Poppe
>> Sent: Tuesday, 19 July 2016 16:08
>> To: ifeanyiok...@yahoo.com <mailto:ifeanyiok...@yahoo.com>
>> Cc: Bob Jolliffe; Ntawuyirusha Emmanuel; DHIS Users
>> Subject: Re: [Dhis2-users] Browser not working
>> 
>> Hi, I can add that I have the same problem on two different servers: logging 
>> in with Chrome (or Safari) does not work, Firefox works fine. Instances are 
>> both 2.24 build. Nginx 1.4.6 are running on both servers. Both servers have 
>> other non-2.24 instances that does not have the same problem.
>> 
>> To add to the problem, the DHIS 2 top menu does not work in Firefox, e.g. 
>> nothing works…Not sure if that’s a general problem or not. Again, menu works 
>> in non-24 instances.
>> 
>> Regards
>> Olav
>> 
>> 
>> 
>> 
>>> 19. jul. 2016 kl. 14.41 skrev ifeanyiok...@yahoo.com 
>>> <mailto:ifeanyiok...@yahoo.com>:
>>> 
>>> Dear Bob,
>>> I am having this same issue to with Chrome. After entering the log in 
>>> credentials, it opens a page with API data and does not log in. If I am 
>>> lucky and have a data entry page open, then I can log in at the prompt and 
>>> that works. 
>>> Our instance is set to load the dashboard as the opening page.
>>> 
>>> Have to keep struggling with it till it eventually logs in. 
>>> 
>>> Thanks
>>>   Original Message  
>>> From: Bob Jolliffe
>>> Sent: Tuesday, 19 July 2016 14:58
>>> To: Ntawuyirusha Emmanuel
>>> Cc: dhis2-users
>>> Subject: Re: [Dhis2-users] Browser not working
>>> 
>>> Hi Emmanuel
>>> 
>>> I am following up on a separate thread. I'll copy you into that.
>>> 
>>> I see it is a problem, seemingly related to chrome mishandling the
>>> JSESSIONID cookie so even though the credentials are tested and dhis2
>>> logs a successful authentication, the browser cookie doesn't match the
>>> session id in dhis and so you don't get in. I am really not sure why
>>> What I also don't know is what might have changed to cause this to
>>> happen. I am assuming you didn't just wake up one morning and this
>>> started to happen. There has been some change to nginx configuration
>>> or dhis2 upgrade or something similar.
>>> 
>>> On 19 July 2016 at 14:40, Ntawuyirusha Emmanuel <ntawe...@gmail.com 
>>> <mailto:ntawe...@gmail.com>> wrote:
>>>> i tried to uninstall and reinstall it again but the issue is still
>>>> remaining, Note that this is happening to all users using Goggle Chrome as
>>>> most of them are familiar with it.
>>>> 
>>>> Regards
>>>> 
>>>> On Mon, Jul 18, 2016 at 7:49 PM, Knut Staring <knu...@gmail.com 
>>>> <mailto:knu...@gmail.com>> wrote:
>>>>> 
>>>>> Maybe try to reinstall Chrome.
>>>>> 
>>>>> Knut
>>>>> 
>>>>> 
>>>>> On Tuesday, July 19, 2016, Ntawuyirusha Emmanuel <ntawe...@gmail.com 
>>>>> <mailto:ntawe...@gmail.com>>
>>>>> wrote:
>>>>>> 
>>>>>> Thank you Bob,
>>>>>> 
>>>>>> I tried to use New Incognito windows and Clear browsing data but the
>>>>>> issue is remaining for Google Chrome , actually when we restart the 
>>>>>> server
>>>>>> the username and password work only once and then after the problem 
>>>>>> persist.
>>>>>> we are still waiting for your support.
>>>>>> 
>>>>>> Regards
>>>>>> 
>>>>>> On Mon, Jul 18, 2016 at 12:42 PM, Bob Jolliffe <bobjolli...@gmail.com 
>>>>>> <mailto:bobjolli...@gmail.com>>
>>>>>&

[Dhis2-users] Fwd: Browser not working

[Olav Poppe]

Forwarding to user list. Not 2.24 issue then it seems.

Olav



> Videresendt melding:
> 
> Fra: ifeanyiok...@yahoo.com
> Emne: Re: [Dhis2-users] Browser not working
> Dato: 19. juli 2016 kl. 15.19.34 GMT
> Til: Olav Poppe <olav.po...@me.com>
> 
> Just to add that I'm using version 2.22 build 22086
> 
> 
> From: Olav Poppe
> Sent: Tuesday, 19 July 2016 16:08
> To: ifeanyiok...@yahoo.com
> Cc: Bob Jolliffe; Ntawuyirusha Emmanuel; DHIS Users
> Subject: Re: [Dhis2-users] Browser not working
> 
> Hi, I can add that I have the same problem on two different servers: logging 
> in with Chrome (or Safari) does not work, Firefox works fine. Instances are 
> both 2.24 build. Nginx 1.4.6 are running on both servers. Both servers have 
> other non-2.24 instances that does not have the same problem.
> 
> To add to the problem, the DHIS 2 top menu does not work in Firefox, e.g. 
> nothing works…Not sure if that’s a general problem or not. Again, menu works 
> in non-24 instances.
> 
> Regards
> Olav
> 
> 
> 
> 
>> 19. jul. 2016 kl. 14.41 skrev ifeanyiok...@yahoo.com 
>> <mailto:ifeanyiok...@yahoo.com>:
>> 
>> Dear Bob,
>> I am having this same issue to with Chrome. After entering the log in 
>> credentials, it opens a page with API data and does not log in. If I am 
>> lucky and have a data entry page open, then I can log in at the prompt and 
>> that works. 
>> Our instance is set to load the dashboard as the opening page.
>> 
>> Have to keep struggling with it till it eventually logs in. 
>> 
>> Thanks
>>   Original Message  
>> From: Bob Jolliffe
>> Sent: Tuesday, 19 July 2016 14:58
>> To: Ntawuyirusha Emmanuel
>> Cc: dhis2-users
>> Subject: Re: [Dhis2-users] Browser not working
>> 
>> Hi Emmanuel
>> 
>> I am following up on a separate thread. I'll copy you into that.
>> 
>> I see it is a problem, seemingly related to chrome mishandling the
>> JSESSIONID cookie so even though the credentials are tested and dhis2
>> logs a successful authentication, the browser cookie doesn't match the
>> session id in dhis and so you don't get in. I am really not sure why
>> What I also don't know is what might have changed to cause this to
>> happen. I am assuming you didn't just wake up one morning and this
>> started to happen. There has been some change to nginx configuration
>> or dhis2 upgrade or something similar.
>> 
>> On 19 July 2016 at 14:40, Ntawuyirusha Emmanuel <ntawe...@gmail.com 
>> <mailto:ntawe...@gmail.com>> wrote:
>>> i tried to uninstall and reinstall it again but the issue is still
>>> remaining, Note that this is happening to all users using Goggle Chrome as
>>> most of them are familiar with it.
>>> 
>>> Regards
>>> 
>>> On Mon, Jul 18, 2016 at 7:49 PM, Knut Staring <knu...@gmail.com 
>>> <mailto:knu...@gmail.com>> wrote:
>>>> 
>>>> Maybe try to reinstall Chrome.
>>>> 
>>>> Knut
>>>> 
>>>> 
>>>> On Tuesday, July 19, 2016, Ntawuyirusha Emmanuel <ntawe...@gmail.com 
>>>> <mailto:ntawe...@gmail.com>>
>>>> wrote:
>>>>> 
>>>>> Thank you Bob,
>>>>> 
>>>>> I tried to use New Incognito windows and Clear browsing data but the
>>>>> issue is remaining for Google Chrome , actually when we restart the server
>>>>> the username and password work only once and then after the problem 
>>>>> persist.
>>>>> we are still waiting for your support.
>>>>> 
>>>>> Regards
>>>>> 
>>>>> On Mon, Jul 18, 2016 at 12:42 PM, Bob Jolliffe <bobjolli...@gmail.com 
>>>>> <mailto:bobjolli...@gmail.com>>
>>>>> wrote:
>>>>>> 
>>>>>> oops, forgot users ...
>>>>>> 
>>>>>> -- Forwarded message --
>>>>>> From: Bob Jolliffe <bobjolli...@gmail.com <mailto:bobjolli...@gmail.com>>
>>>>>> Date: 18 July 2016 at 11:40
>>>>>> Subject: Re: [Dhis2-users] Browser not working
>>>>>> To: Emmanuel Ntawuyirusha <ntawe...@gmail.com 
>>>>>> <mailto:ntawe...@gmail.com>>
>>>>>> 
>>>>>> 
>>>>>> Hi Emmanuel
>>>>>> 
>>>>>> If it works with firefox then it is really likely to be a chrome cache
>>>>>>

Re: [Dhis2-users] Browser not working

[Olav Poppe]

Hi, I can add that I have the same problem on two different servers: logging in 
with Chrome (or Safari) does not work, Firefox works fine. Instances are both 
2.24 build. Nginx 1.4.6 are running on both servers. Both servers have other 
non-2.24 instances that does not have the same problem.

To add to the problem, the DHIS 2 top menu does not work in Firefox, e.g. 
nothing works…Not sure if that’s a general problem or not. Again, menu works in 
non-24 instances.

Regards
Olav




> 19. jul. 2016 kl. 14.41 skrev ifeanyiok...@yahoo.com:
> 
> Dear Bob,
> I am having this same issue to with Chrome. After entering the log in 
> credentials, it opens a page with API data and does not log in. If I am lucky 
> and have a data entry page open, then I can log in at the prompt and that 
> works. 
> Our instance is set to load the dashboard as the opening page.
> 
> Have to keep struggling with it till it eventually logs in. 
> 
> Thanks
>   Original Message  
> From: Bob Jolliffe
> Sent: Tuesday, 19 July 2016 14:58
> To: Ntawuyirusha Emmanuel
> Cc: dhis2-users
> Subject: Re: [Dhis2-users] Browser not working
> 
> Hi Emmanuel
> 
> I am following up on a separate thread. I'll copy you into that.
> 
> I see it is a problem, seemingly related to chrome mishandling the
> JSESSIONID cookie so even though the credentials are tested and dhis2
> logs a successful authentication, the browser cookie doesn't match the
> session id in dhis and so you don't get in. I am really not sure why
> What I also don't know is what might have changed to cause this to
> happen. I am assuming you didn't just wake up one morning and this
> started to happen. There has been some change to nginx configuration
> or dhis2 upgrade or something similar.
> 
> On 19 July 2016 at 14:40, Ntawuyirusha Emmanuel  wrote:
>> i tried to uninstall and reinstall it again but the issue is still
>> remaining, Note that this is happening to all users using Goggle Chrome as
>> most of them are familiar with it.
>> 
>> Regards
>> 
>> On Mon, Jul 18, 2016 at 7:49 PM, Knut Staring  wrote:
>>> 
>>> Maybe try to reinstall Chrome.
>>> 
>>> Knut
>>> 
>>> 
>>> On Tuesday, July 19, 2016, Ntawuyirusha Emmanuel 
>>> wrote:
 
 Thank you Bob,
 
 I tried to use New Incognito windows and Clear browsing data but the
 issue is remaining for Google Chrome , actually when we restart the server
 the username and password work only once and then after the problem 
 persist.
 we are still waiting for your support.
 
 Regards
 
 On Mon, Jul 18, 2016 at 12:42 PM, Bob Jolliffe 
 wrote:
> 
> oops, forgot users ...
> 
> -- Forwarded message --
> From: Bob Jolliffe 
> Date: 18 July 2016 at 11:40
> Subject: Re: [Dhis2-users] Browser not working
> To: Emmanuel Ntawuyirusha 
> 
> 
> Hi Emmanuel
> 
> If it works with firefox then it is really likely to be a chrome cache
> issue. Try and login with chrome incognito mode. If that works then
> you can be reasonably sure.
> 
> If so, then try ...
> 
> https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache
> 
> Bob
> 
> On 18 July 2016 at 11:08, Emmanuel Ntawuyirusha 
> wrote:
>> Deal all, we are facing the issue of using Google Chrome, when using
>> username and password there is a message saying wrong username and
>> password.
>> But it is working well with Mozilla Firefox. We tried to clean cash
>> but
>> nothing improved
>> Does any one know what to do to fix this problem.
>> 
>> 
>> ___
>> 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
>> 
> 
> ___
> 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
 
 
 
 
 --
 *Mr. Emmanuel NTAWUYIRUSHA*
 HMIS/MOH
 Telephone: *+250 788408772*
 Email: ntawe...@gmail.com
 "Do Good. Do It Well."
 
>>> 
>>> 
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>> 
>> 
>> 
>> 
>> --
>> *Mr. Emmanuel NTAWUYIRUSHA*
>> HMIS/MOH
>> Telephone: *+250 788408772*
>> Email: ntawe...@gmail.com
>> "Do Good. Do It Well."
>> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help 

Re: [Dhis2-users] adding a new event status

[Olav Poppe]

Hi Lars/devs,
a question related to this: I’ve done something similar to what you suggest 
Lars (i.e. programatically updating a data element in an event), but as far as 
I could tell from the documentation and testing there is no way to add/update a 
single data value for an event without also downloading and then re-sending all 
other data values? In other words, if you send a single data value to and 
existing event (/api/events/uid), it will delete other data values not part of 
the payload. Have I missed something, or is that the case? If so, it would be 
nice with support for that over the API for these types of scenarios.

Olav



> 23. mai 2016 kl. 15.47 skrev Lars Helge Øverland :
> 
> Hi Eric,
> 
> I understand your question. We do not plan to add additional enum options 
> though which are not used by DHIS 2 internally as it will cause confusion for 
> developers.
> 
> For app development purposes I would recommend that you instead create a data 
> element which could be called "Validated", have a particular code (e.g. 
> "VALIDATION_STATUS") and be of value type Yes/No (boolean). You can then in 
> your app set a corresponding data value through the regular events resource 
> of true or false, and then use this to keep the validation state. This of 
> course creates a dependency on the configuration which should be documented.
> 
> regards,
> 
> Lars
> 
> 
> 
> 
> 
> 
> 
> On Fri, May 20, 2016 at 12:25 PM, eric mourin  > wrote:
> Hi everyone,
> 
> We are developing an application that needs to know if some events (captured 
> via event capture) were validated by an authorized user or not. I've seen 
> that events have an "status" field  which can have the values "ACTIVE, 
> COMPLETED, VISITED, OVERDUE, SKIPPED" but I couldn't get much information 
> about what meant each field from the documentation so I was wondering if its 
> possible to create a "VALIDATED" status for the events and then make a put 
> with the status changed. If this is not possible (not accepted via Update by 
> the web api) or can bring future problems with newer versions, would it be 
> possible to reuse one of the status already listed there? I've seen the 
> ACTIVE and COMPLETED status but I've never seen the rest used.
> 
> Thanks for your time
> Eric
> 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org 
> http://www.dhis2.org 
> 
> ___
> 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

___
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] Displaying images (resources) in the dashboard

[Olav Poppe]

Let me chip in here:
- finding a way around the "Indicators cannot be specified as filter." issue.

Then a few things which I understand is difficult with the current chart 
framework, but that would still be nice to have some day…:
- more flexibility in the "layout", e.g. two axis with different scale 
(indicator vs raw data in same chart etc)
- combining chart types, e.g. line + bar
- scatterplots, though only if there is more flexibility in the layout so that 
you can have data on X and Y axis

Olav


> 5. mai 2016 kl. 13.27 skrev Knut Staring :
> 
> Yes, I have asked the focal person to share some example charts.
> 
> On 5 May 2016 15:48, "Lars Helge Øverland"  > wrote:
> 
> 
> On Thu, May 5, 2016 at 9:38 AM, Knut Staring  > wrote:
> Hello team,
> 
> Given the limits of the current charting solution (no selection of (the 
> rather dull) colors), few types of charts etc, I have a request to be able to 
> import charts made externally (with Excel or other tools) for display in the 
> dashboard.
> 
> Hi Knut,
> 
> when you say limited chart types - which chart types do you need? Can you 
> post a mockup of a chart / type you would like to see?
> 
> Lars
>  
> 
> 2.23 can already display youtube videos, so would it be easy to also display 
> Resources of type image? Or do we have to make a wrapper app (for each such 
> image)?
> 
> -- 
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522 
> Skype: knutstar
> http://dhis2.org 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org 
> http://www.dhis2.org 
> 
> ___
> 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

___
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] Metadata export (tracker)

[Olav Poppe]

Hi all,
I'm looking at ways to export specific metadata with "dependencies" from DHIS, 
initially a tracker program. The goal is to export the program with all 
dependencies (program stage(s), data elements, option sets, data entry form, 
program validation etc) as easily as possible. Before I try to script something 
myself I thought I'd check if anyone else has already done something similar 
and have tools or experiences to share, OR if there are some clever ways to do 
this already through GUI/API that I haven't been able to identify?

Regards
Olav
___
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] Custom form translation

[Olav Poppe]

Thanks, Lars - blueprint here: 
https://blueprints.launchpad.net/dhis2/+spec/translatable-de-names-custom-forms

My initial thinking was to see if the translated names were stored/cached 
somewhere and avoid API-calls for the sake of offline support (e.g. it would 
work even if the user went offline before a specific form was opened), but in 
most cases it should not be a problem.

Regards
Olav


> 17. feb. 2016 kl. 13.20 skrev Lars Helge Øverland <l...@dhis2.org>:
> 
> Hi Olav,
> 
> 
> 
>> On Mon, Feb 15, 2016 at 4:57 AM, Olav Poppe <olav.po...@me.com> wrote:
>> Hi all,
>> I’m looking at ways to support translation in a custom form (aggregate). I 
>> would like to be able to use the "built in" translation of data elements if 
>> possible, using IDs when designing the form and having a javascript function 
>> triggered by "dhis2.de.event.formReady" to put in the correct translations. 
>> I was thinking the formName, displayName or similar would be available in 
>> the dhis2 object, but I’m having difficult figuring out where.
>> 
>> Can any of the dev advice on where to read the translated names/formNames, 
>> if possible?
>> 
>> Does anyone else have any experience with something like this?
>> 
>> Thinking of it now, this might even be an idea for a general feature: just 
>> like you can add the data entry fields, totals and indicators when designing 
>> custom forms, there could be an option to add "name" label that would 
>> display the name/form name of an element, with translation when applicable.
> 
> that sounds like a great idea. Something like a variable, e.g. ${.name} 
> , which can be substituted based on the selected locale of the current user.
> 
> Feel free to write a blueprint.
> 
> You can load this from the API, which in 2.22 lets you use the "displayName" 
> property of objects which are translated to the appropriate language.
> 
> So something like this:
> 
> https://play.dhis2.org/demo/api/dataSets/BfMAe6Itzgt.json?fields=dataElements[id,displayName]
> 
> will give you the translated name of all data elements in a data set.
> 
> You could potentially load this once when data entry page is loaded from 
> within a custom form, and then substitute labels yourself.
> 
> Overview of callback events:
> 
> http://dhis2.github.io/dhis2-docs/master/en/user/html/ch06s02.html#d5e1369
> 
> 
> regards,
> 
> Lars
> 
> 
>> 
>> Regards
>> Olav
>> 
>> 
>> 
>> 
>> ___
>> 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
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org

___
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] Custom form translation

[Olav Poppe]

Hi all, 
I’m looking at ways to support translation in a custom form (aggregate). I 
would like to be able to use the "built in" translation of data elements if 
possible, using IDs when designing the form and having a javascript function 
triggered by "dhis2.de.event.formReady" to put in the correct translations. I 
was thinking the formName, displayName or similar would be available in the 
dhis2 object, but I’m having difficult figuring out where.

Can any of the dev advice on where to read the translated names/formNames, if 
possible?

Does anyone else have any experience with something like this?

Thinking of it now, this might even be an idea for a general feature: just like 
you can add the data entry fields, totals and indicators when designing custom 
forms, there could be an option to add "name" label that would display the 
name/form name of an element, with translation when applicable.

Regards
Olav




___
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] User Activity Report

[Olav Poppe]

Hi Lars,
this looks good. Just a question, I wasn’t able to see from the blueprint if 
this statistics was for the number of report items that exist, or if it would 
somehow also include statistics on how often favourites are opened?

Olav


> 2. feb. 2016 kl. 15.49 skrev Lars Helge Øverland :
> 
> Hi Pamod,
> 
> we do not plan to have support a full view of all activity. However we aim 
> for a "data usage statistics" feature for 2.23, where you can see which types 
> of data analysis a user is doing:
> 
> https://blueprints.launchpad.net/dhis2/+spec/system-usage-analytics
> 
> This might be expanded to more type of activity later, but not confirmed at 
> this point.
> 
> regards,
> 
> Lars
> 
> 
>> On Fri, Jan 15, 2016 at 9:39 AM, Pamod Amarakoon  wrote:
>> Dear All,
>> 
>> Is it possible to obtain a report on activities/interaction of individual 
>> users with the DHIS2 instance at the moment. If not, is there any plans of 
>> including this feature in future releases.
>> 
>> Thanx
>> 
>> -- 
>> Regards,
>> Pamod Amarakoon
>> 
>> Confidentiality Notice: the information contained in this email and any 
>> attachments may be legally privileged and confidential. If you are not an 
>> intended recipient, you are hereby notified that any dissemination, 
>> distribution, or copying of this e-mail is strictly prohibited. If you have 
>> received this e-mail in error, please notify the sender and permanently 
>> delete the e-mail and any attachments immediately. You should not retain, 
>> copy or use this e-mail or any attachments for any purpose, nor disclose all 
>> or any part of the contents to any other person.
>> 
>> 
>> 
>> 
>> ___
>> 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
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : 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] 2.21 event capture program rule issues

[Olav Poppe]

Hi, I just upgraded an instance from 2.20 to 2.21 (latest build), and I’m now 
having some difficulties with event capture program rules. I’m using a custom 
form, and in 2.20 fields were disabled according to the program rules as 
expected. After upgrading to 2.21, fields are not disabled, though the message 
pop-up appears if I try to enter something in the fields that are supposed to 
be disabled. I.e. it seems that the rules are "interpreted" correctly, but 
fields are not correctly disabled.

Does anyone have any experience with this issue? Are the fields still supposed 
to be disabled in custom forms in 2.21?

I also experience another strange issue in 2.21: The "comments" section + the 
Save and Back buttons appear twice.

Regards
Olav___
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] Cannot load OrgUnits or DataSet in Data Entry

[Olav Poppe]

Hi, I’ve seen this a couple of times before, and if memory serves me right it 
was caused by invalid indicator formulas in those instances. 

I guess the thread you refer to is the one copied below.

Regards Olav

> I got this 
> 
> [Error: Parse error on line 11:
> ...Z79clX7y1","v":1} , ,"f1R88WLGXvs-USfPOP
> ---^
> Expecting 'STRING', got ',']
> 
> On Fri, Sep 25, 2015 at 11:53 AM, Morten Olav Hansen  > wrote:
> Try to manually run the getMedaData.action in data-entry, and then take that 
> output to jsonlint.com 
> 
> Unexpected token u, means something was undefined..
> 
> --
> Morten
> 
> On Fri, Sep 25, 2015 at 4:49 PM, Jason Pickering  > wrote:
> We are seeing an error in data entry, which is preventing all data entry,so 
> it is pretty critical. 
> 
> Uncaught SyntaxError: Unexpected token u
> 
> 
> Unknown revision of 2.18. I suspect it is a meta-data problem, but not really 
> sure how to pinpoint it?
> 
> Any ideas?
> 
> Regards,
> Jason
> 
> ​
> 
> -- 
> Jason P. Pickering
> email: jason.p.picker...@gmail.com 
> tel:+46764147049 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> 
> Post to : dhis2-d...@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
> 
> 


> 14. jan. 2016 kl. 18.02 skrev Lars Helge Øverland :
> 
> Okay. Could you simply try to delete cache properly, close the browser, log 
> in and try again?
> 
> https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache 
> 
> 
> It is a bit unfortunate but I have seen it happen before.
> 
> regards,
> 
> Lars
> 
> 
> 
> 
> On Thu, Jan 14, 2016 at 6:01 PM, Laura E. Lincks 
> > 
> wrote:
> I was just doing that after finding the same problem in a thread from last 
> year.
> 
>  
> Here’s what I see  :
> 
> Uncaught SyntaxError: Unexpected token u
> 
> 
> 
> screen shot attached
> 
> 
> 
> 
> 
> 
> Laura E. Lincks <>
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
> 
> 
> On Thu, Jan 14, 2016 at 11:53 AM, Lars Helge Øverland  > wrote:
> Hi Laura,
> 
> could you please open the Chrome developer tools and look in the "Console" 
> for errors in red?
> 
> regards,
> 
> Lars
> 
> 
> On Thu, Jan 14, 2016 at 5:52 PM, Laura E. Lincks 
> > 
> wrote:
> Version: 2.20
> Build revision: 20001
> 
> We are suddenly having difficulty in using the Data Entry screen (it was 
> working prior to yesterday, more than likely.)
> 
> The OrgUnit tree appears on the left hand side and the search functionality 
> works there. But when selecting any OrgUnit in the tree it does not populate 
> the Organisation Unit field in the snapshot below. Furthermore, the Loading 
> bar next to Data Set continues to run but the Data Set list is never 
> populated because no Org Unit ever gets loaded into the field.
> 
> 
> 
> The log does not show us anything obvious. Analytics ran automatically 
> overnight without a problem.
> 
> We are looking at Datasets which changed over the past day... there are 12 
> which were updated, but I am not sure if there were true changes or if 
> someone just edited them and clicked Save instead of Cancel, because there 
> was no reason to modify datasets as far as I know.
> 
> 3 of the 12 modified datasets are designed with a dimension type of Aggregate 
> with a specific category combo of POS. But these are not new datasets and 
> have been in existence and have functioned properly for many months. We've 
> set up a test environment -- modifying that aggregate dimension dataset did 
> not resolve the issue of not being able to load an Org Unit and its available 
> Datasets on the Data Entry screen.
> 
> Does anyone have an idea of what we should be looking for? Thanks.
> 
> 
> Laura E. Lincks <>
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> 
> Post to : dhis2-users@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-users 
> 

Re: [Dhis2-users] Aggregation query builder details

[Olav Poppe]

Hi, 
just wanted to add my voice in support for improving (e.g. making it faster and 
more reliable, supporting cohort analysis etc), rather than removing the 
aggregation query builder. While I think the program indicators are great, I 
think there are many cases where you would rather want to store the aggregate 
data. 

One case I think is highly relevant (in the sense that countries are doing it 
now) is where you have some facilities reporting via tracker and other on 
paper/aggregate, and you would want the data to end up in the same data 
elements/data sets.

Olav




> 26. nov. 2015 kl. 23.01 skrev Knut Staring :
> 
> Thanks for the clarifications, Elmarie and Dipali
> 
> I think these are good inputs to our dev team, and hope some of them will 
> also chip into this conversation.
> 
> Cheers,
> Knut
> 
>> On Fri, Nov 27, 2015 at 4:11 AM, Elmarie Claasen  wrote:
>> Hi Knut,
>> 
>>  
>> 
>> Although I can see that program indicators can be helpful it has limited use 
>> in the context of interoperability between DHIS2 instances. In South Africa 
>> we feel that Survey type instances should be kept separate from Routine 
>> Health data collection and as such collect event or tracker data for surveys 
>> and would want to set up aggregated data elements in the system which 
>> populates with a stored aggregated data value which we export/synchronise 
>> with the routine HMIS system e.g. 
>> 
>> Patient satisfaction survey rate = No of surveys conducted/No of facilities
>> 
>> Patient satisfaction rate = No of satisfied responses/All responses
>> 
>>  
>> 
>> It is true that these aggregated elements can be populated with a function 
>> called via a sql view or cron job but not the most ideal. 
>> 
>> Up to now I have not figured out how to set up an indicator which counts if 
>> there was any surveys done in a specific period by adding a program 
>> indicator due to the limited amount of mathematical calculation formulae 
>> allowed in the Program Indicator engine. 
>> 
>>  
>> 
>> This said I must say that we don’t have much confidence in the accuracy of 
>> the Aggregation Query Builder as it is at the moment because there seems to 
>> be a ceiling limit on how many values can actually be inserted by running a 
>> scheduled or manual aggregation process and the simultaneous initiation of 
>> scheduled Aggregation Query builder and Analytics are problematic. For this 
>> reason we are checking the output of the Aggregation Query builder at this 
>> stage and when not entirely confident that it produces reliable results we 
>> are using functions instead.
>> 
>>  
>> 
>> Regards,
>> 
>>  
>> 
>> Elmarie Claasen
>> 
>> 
>> 
>> Project Manager
>> 
>> Health Information Systems Program
>> 
>> Tel:  041-367 1027
>> 
>> Cell: 082 374 2209
>> 
>> E-mail: elma...@hisp.org
>> 
>> Skype:  elmarie.claasen52 
>> 
>>  
>> 
>>  
>> 
>> This message and any attachments are subject to a disclaimer published at 
>> http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
>> disclaimer before opening any attachment or taking any other action in terms 
>> of this electronic transmission. 
>> If you cannot access the disclaimer, kindly send an email to 
>> disclai...@hisp.org and a copy will be provided to you. By replying to this 
>> e-mail or opening any attachment you agree to be bound by the provisions of 
>> the disclaimer. 
>> 
>>  
>> 
>> From: Dhis2-users 
>> [mailto:dhis2-users-bounces+elmarie=hisp@lists.launchpad.net] On Behalf 
>> Of Dipali Sahu
>> Sent: 26 November 2015 12:49 PM
>> To: Knut Staring
>> Cc: DHIS 2 Users list
>> Subject: Re: [Dhis2-users] Aggregation query builder details
>> 
>>  
>> 
>> Hi Knut
>> 
>>  
>> 
>> We actually use Aggregation query builder to a large extent to get 
>> aggregated data. Exclusively, all our data is captured through Event 
>> capture, and we aggregate it through Aggregation query builder, so that the 
>> aggregated values can be shown in datasets as well as Pivot tables.
>> 
>> Also, using Pivot tables with data elements is easier for the end users 
>> since they there is flexibility to can slice and dice the data with 
>> categories under Pivot tables. 
>> 
>>  
>> 
>> Don't you think aggregation with only program indicators will limit the use 
>> of categories and therefore easy visualization under pivot tables.
>> 
>>  
>> 
>> Thank you
>> 
>> Deepali
>> 
>> International Medical Corps
>> 
>>  
>> 
>>  
>> 
>> On Wed, Nov 25, 2015 at 11:34 AM, Knut Staring  wrote:
>> 
>> Hi Nami,
>> 
>>  
>> 
>> Which version of DHIS2 are you working on? We are phasing out the 
>> aggregation query builder in favor of program indicators.
>> 
>>  
>> 
>> Knut
>> 
>>  
>> 
>> On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri  wrote:
>> 
>> Hello,
>> 
>>  
>> 
>> I want to create an Aggregation query builder details as sum of data element 
>> value I put everything but it comes to 

[Dhis2-users] MySQL error loading existing data

[Olav Poppe]

Hi, 
I’m trying to upgrade a MySQL database to 2.18. However, something goes wrong. 
When I inspect the response from getDataValues.action… it is an exception 
occured, and in the tomcat log there is an error (copied below). 

The problem seems to be this specifically:
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near 
'cocco.categoryoptioncomboid = 1 ) as a'

Does anyone have an advise on what could be the problem? I’m finding it 
difficult to decipher the SQL.. 

Olav


* ERROR 2015-04-22 11:11:08,274 Error while executing action 
(ExceptionInterceptor.java [http-bio--exec-9])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL 
grammar [select a.categoryoptioncomboid, a.organisationunitid, (select 
min(coalesce(dal.level, 0)) from period p left join dataapproval da on 
da.datasetid in (1) and da.periodid = p.periodid and da.attributeoptioncomboid 
= a.categoryoptioncomboid and da.organisationunitid = a.organisationunitid left 
join dataapprovallevel dal on dal.dataapprovallevelid = da.dataapprovallevelid 
where p.periodid in (25) ) as highest_approved_level, (select 
substring(min(concat(10 + coalesce(dal.level, 0), coalesce(da.accepted, 
FALSE))) from 7) from period p left join dataapproval da on da.datasetid in (1) 
and da.periodid = p.periodid and da.attributeoptioncomboid = 
a.categoryoptioncomboid and da.organisationunitid = a.organisationunitid left 
join dataapprovallevel dal on dal.dataapprovallevelid = da.dataapprovallevelid 
where p.periodid in (25) ) as accepted_at_highest_level, true as ready_below, 
false as approved_above from ( select distinct cocco.categoryoptioncomboid, 
ccoc.categorycomboid, coalesce(coo.organisationunitid, o.organisationunitid) as 
organisationunitid from categoryoptioncombos_categoryoptions cocco join 
categorycombos_optioncombos ccoc on ccoc.categoryoptioncomboid = 
cocco.categoryoptioncomboid and ccoc.categorycomboid in (1) join 
dataelementcategoryoption co on co.categoryoptionid = cocco.categoryoptionid 
and (co.startdate is null or co.startdate = '2014-12-31') and (co.enddate is 
null or co.enddate = '2014-01-01') join _orgunitstructure o on 
o.organisationunitid = 117 left join categoryoption_organisationunits coo on 
coo.categoryoptionid = co.categoryoptionid left join _orgunitstructure ous on 
ous.idlevel3 = o.organisationunitid and ous.organisationunitid = 
coo.organisationunitid left join _orgunitstructure o1 on o1.organisationunitid 
= o.organisationunitid and o1.idlevel1 = coo.organisationunitid left join 
_orgunitstructure o2 on o2.organisationunitid = o.organisationunitid and 
o2.idlevel2 = coo.organisationunitid left join 
dataelementcategoryoptionusergroupaccesses couga on couga.categoryoptionid = 
cocco.categoryoptionid left join usergroupaccess uga on uga.usergroupaccessid = 
couga.usergroupaccessid left join usergroupmembers ugm on ugm.usergroupid = 
uga.usergroupid where ( coo.categoryoptionid is null or ous.organisationunitid 
is not null or o1.organisationunitid is not null or o2.organisationunitid is 
not null )  and cocco.categoryoptioncomboid = 1and cocco.categoryoptioncomboid 
= 1 ) as a]; nested exception is 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in 
your SQL syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near 'cocco.categoryoptioncomboid = 1 ) as a' at 
line 1
at 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
at 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)
at 
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)
at 
org.hisp.dhis.dataapproval.hibernate.HibernateDataApprovalStore.getDataApprovals(HibernateDataApprovalStore.java:385)
at 
org.hisp.dhis.dataapproval.DefaultDataApprovalService.getDataApprovalStatus(DefaultDataApprovalService.java:356)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at 

[Dhis2-users] Filter data elements by domain type

[Olav Poppe]

Hi, 
I’m trying to filter data elements by domain type (through the API), but it 
does not seem to work. I’m using 2.17.

I try this, but the result is empty:
/api/dataElements.json?filter=domainType:eq:TRACKER
/api/dataElements.json?filter=domainType:eq:AGGREGATE

Any suggestions for what the problem might be?

Olav
___
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] Metadata export and category option combos

[Olav Poppe]

Hi, 
I’m in a situation where I want to transfer data and metadata for one dataset 
from one DHIS instance to another. My initial idea was to use the «Meta-Data 
Detailed Export» from the source database, select the relevant dataset, and 
check «include dependencies». This creates an XML-file with the dataset, data 
element, cateories, categorycombos etc as expected. However, after importing 
this metadata into the target database, I realised that it did not include the 
categoryoptioncombos (with IDs). In other words, even though I have the same 
data elements, categories, categorycombos etc in both databases, I’m not able 
to transfer data between the two since the data export relies on the 
categoryoptioncombo.

One work-around is of course to use the «regular» meta-data export and 
selecting category option combos, but then it includes the metadata for ALL 
categorycombos, not just the three I’m interested in - so I will either have to 
edit the XML or delete the ones I don’t need later.

Am I missing a more obvious/simpler way of doing this? Is it by design or by 
oversight that the categoryoptioncombos are not included in the detailed 
export? (I realise the categoryoptioncombos are a bit «special» since they can 
be regenerated later etc)

Olav




___
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] Metadata export and category option combos

[Olav Poppe]

Thanks for the replies.

Updated to 2.17 rev 17684, but I still don’t get the category option combos 
when exporting category combos with dependencies - it gives me categories, 
categoryOptions and categoryCombos only.

Olav


 6. jan. 2015 kl. 13.39 skrev Bob Jolliffe bobjolli...@gmail.com:
 
 Excellent.  If its a small fix I wonder would it be easy to backport to 2.16? 
  I can check.  Then I can throw those xslt transforms away ...
 
 On 6 January 2015 at 12:37, Lars Helge Øverland larshe...@gmail.com 
 mailto:larshe...@gmail.com wrote:
 Hi Olav,
 
 this was actually fixed in trunk and 2.17 two days ago. You can now use the 
 meta-data detailed export and make an export of the category combos that you 
 need to transfer (those used for the data elements in your data sets). You 
 then import that file first. It will contain all the relevant category option 
 combos for those category combos.
 
 regards,
 
 Lars
 
 On Tue, Jan 6, 2015 at 1:11 PM, Olav Poppe olav.po...@me.com 
 mailto:olav.po...@me.com wrote:
 Hi,
 I’m in a situation where I want to transfer data and metadata for one dataset 
 from one DHIS instance to another. My initial idea was to use the «Meta-Data 
 Detailed Export» from the source database, select the relevant dataset, and 
 check «include dependencies». This creates an XML-file with the dataset, data 
 element, cateories, categorycombos etc as expected. However, after importing 
 this metadata into the target database, I realised that it did not include 
 the categoryoptioncombos (with IDs). In other words, even though I have the 
 same data elements, categories, categorycombos etc in both databases, I’m not 
 able to transfer data between the two since the data export relies on the 
 categoryoptioncombo.
 
 One work-around is of course to use the «regular» meta-data export and 
 selecting category option combos, but then it includes the metadata for ALL 
 categorycombos, not just the three I’m interested in - so I will either have 
 to edit the XML or delete the ones I don’t need later.
 
 Am I missing a more obvious/simpler way of doing this? Is it by design or by 
 oversight that the categoryoptioncombos are not included in the detailed 
 export? (I realise the categoryoptioncombos are a bit «special» since they 
 can be regenerated later etc)
 
 Olav
 
 
 
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net 
 mailto:dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp 
 https://help.launchpad.net/ListHelp
 
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net 
 mailto:dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users 
 https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp 
 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] Web API: Organizatonal unit level property could not be query

[Olav Poppe]

Hi, 
you can specify which fields you need, including the levels: 
/api/organisationUnitLevels.json?fields=name,id,level etc…

Olav


 25. sep. 2014 kl. 11.46 skrev Octavio GLORIO 
 octavio.glo...@barcelona.msf.org:
 
 Hi all there,
 I have an automatic  process that create all the configuration of the DHIS by 
 using the Web API and Pentaho data integration. However, I think that there 
 is some changes in the API (since 2.16) that i do not understand well.  
 Basically, in certain point of the process, we query organisationUnitLevels 
 and the level property. Specifically, we query in json format: 
 http://localhost:8080/dhis/api/organisationUnitLevels.json. However, in new 
 API this property do not come in the response. Furthermore, if you export 
 level metadata you can notice that this property still exist in the system. 
 Is this correct, it will be reimplemented or theres is no way to query this 
 property of levels by using the API?. I have some workaround in mind, 
 however, I will wait for some feedback in order to implemement.
 Thanks in advance for the response,
 Regards,
 Octavio.
 
 PD: Following some examples obtained through quering Web API:
 
 DHIS2 2.15
 {organisationUnitLevels:[{name:Health 
 service,created:2014-09-25T08:48:26.657+,lastUpdated:2014-09-25T08:48:26.658+,level:5,href:http://localhost:8080/dhis/api/organisationUnitLevels/GnFFYU3kK2F,id:GnFFYU3kK2F}
  ...
 
 DHIS2.16
 {organisationUnitLevels:[{id:uO5PNJYm21A,created:2014-09-15T13:16:58.456+,name:Health
  
 service,lastUpdated:2014-09-15T13:16:58.456+,href:http://localhost:8080/dhis216/api/organisationUnitLevels/uO5PNJYm21A}
  ..
 ___
 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

___
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] Limit characters in Comment

[Olav Poppe]

Hi,
I’m trying to apply the below patch to allow comments longer than 360 
characters. Changing the .js and .vm file works fine and the text field allows 
long comments, BUT the system still refuses to store the data values with long 
comments - 409 conflict is returned from the server. The comment column has 
type «longtext». Any ideas of what could be the problem?

Searching through the source code, I found two additional files where the lengt 
of the comments are mentioned:
- validationUtils.java, function commentIsValid() checks for comment length
- DataValue.hbm.xml has property name=«comment» length=360 /

Do these also need to be changed? If so, I guess a custom .war file will be 
needed (as opposed to just changing the .vm and .js files)?

Olav



9. apr. 2014 kl. 11:48 skrev channara rin rin.chann...@gmail.com:

 Oh!, i am using MySQL. where i can find this sql expression?
 
 
 On Wed, Apr 9, 2014 at 4:46 PM, Jason Pickering jason.p.picker...@gmail.com 
 wrote:
 Could be. On postgres, the datavalue table (at least on my system) looks like 
 this
 
 CREATE TABLE datavalue
 (
   dataelementid integer NOT NULL,
   periodid integer NOT NULL,
   sourceid integer NOT NULL,
   categoryoptioncomboid integer NOT NULL,
   value character varying(255),
   storedby character varying(100),
   lastupdated timestamp without time zone,
   comment character varying(360),
   followup boolean,
 
 
 In that case, not sure then. :-/
 
 Regards,
 Jason
 
 
 
 On Wed, Apr 9, 2014 at 11:42 AM, channara rin rin.chann...@gmail.com wrote:
 The default, comment field in datavalue table is longtext type.
 
 Best Regards,
 CHANNARA
 
 
 On Wed, Apr 9, 2014 at 4:40 PM, Jason Pickering jason.p.picker...@gmail.com 
 wrote:
 Did you change the database field type from varchar to text?
 
 Regards,
 Jason
 
 
 
 On Wed, Apr 9, 2014 at 11:31 AM, channara rin rin.chann...@gmail.com wrote:
 Dear Lars,
 I tried to change in history.js
 but when i enter longer than 360 in comment, and press Save Comment. It 
 always jump:
 CONSOLE
 -
 ReferenceError: i18n_saving_comment_failed_error_code is not defined  
 history.js:64
 -
 
 history.js
 --
 function handleError( xhr, textStatus, errorThrown )
 {
 markComment( COLOR_RED );
 window.alert( i18n_saving_comment_failed_error_code + '\n\n' + 
 xhr.responseText );
 }
 
 
 On Wed, Apr 9, 2014 at 3:29 PM, Lars Helge Øverland larshe...@gmail.com 
 wrote:
 The cell border will be green for fields which have comments (next time you 
 open that form).
 
 
 
 
 On Wed, Apr 9, 2014 at 10:27 AM, channara rin rin.chann...@gmail.com wrote:
 Great, Thank you.
 SO i need to modify the 360 in history.js file?
 
 AND another problem is. when has comment, can show highlight data value in 
 dataset that has text in that comment? SO it is easy for us(ME staff) to 
 view if that data value has comment..
 
 Thank you
 CHANNARA
 
 
 
 
 
 On Wed, Apr 9, 2014 at 3:02 PM, Lars Helge Øverland larshe...@gmail.com 
 wrote:
 Hi Channara,
 
 the max is actually 255 characters, backed by a varchar column in the 
 database. I'm sorry but we don't plan to change it to a text type column 
 anytime soon - reason is just that most comments are pretty short and text 
 requires more storage space on disk.
 
 Now that said you are of course free to change the column type to text 
 directly in your database, and then apply the patch copied below this email 
 to remove the validation.
 
 regards,
 
 Lars
 
 -
 
 
 === modified file 
 'dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js'
 --- 
 dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js
2014-02-27 04:15:35 +
 +++ 
 dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/history.js
2014-04-09 08:01:57 +
 @@ -5,14 +5,6 @@
   
  var commentValue = $( '#commentTextArea' ).val();
  
 -if ( commentValue.length  360 )
 -{
 -markComment( COLOR_YELLOW );
 -window.alert(i18n_value_too_long +  for comment field);
 -
 -return;
 -}
 -
  var commentSaver = new CommentSaver( currentDataElementId, 
 currentOptionComboId, commentValue );
  
  commentSaver.save();
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 On Wed, Apr 9, 2014 at 6:55 AM, channara rin rin.chann...@gmail.com wrote:
 Dear All,
 I found that, in the Comment in data value in dataset is limit character 
 around 360characters. 
 Can we extend to unlimited characters for comments?
 
 
 Thank you
 CHANNARA
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-d...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp
 
 
 
 
 
 
 

Re: [Dhis2-users] [Dhis2-devs] Limit characters in Comment

[Olav Poppe]

Hi, 
in MySQL and 2.15 the type seems to be longtext (see below).

In any case, the patch suggested below is to 1) manually change the column type 
2) change the history.vm and history.js. Is that supposed to enough, or are 
further changes required?

Olav



++--+--+-+-+---+
| Field  | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| dataelementid  | int(11)  | NO   | PRI | NULL|   |
| periodid   | int(11)  | NO   | PRI | NULL|   |
| sourceid   | int(11)  | NO   | PRI | NULL|   |
| categoryoptioncomboid  | int(11)  | NO   | PRI | NULL|   |
| attributeoptioncomboid | int(11)  | NO   | PRI | NULL|   |
| value  | varchar(255) | YES  | | NULL|   |
| storedby   | varchar(100) | YES  | | NULL|   |
| lastupdated| datetime | YES  | | NULL|   |
| comment| longtext | YES  | | NULL|   |
| followup   | tinyint(1)   | YES  | | NULL|   |
++--+--+-+-+---+




10. sep. 2014 kl. 15:19 skrev Lars Helge Øverland larshe...@gmail.com:

 Hi Olav,
 
 the datavalue.value column is of type varchar and not text. This might be 
 unfortunate but there is an overhead in using text vs varchar. The long text 
 vs text is more a UI setting to indicate whether to display an input field or 
 text area. 
 
 I am not sure how huge the difference is between text and varchar these days 
 so it could be looked into whether changing is feasible. I have seen the 
 requirement for storing narratives as data a few places.
 
 regards,
 
 Lars
 
 
 On Wed, Sep 10, 2014 at 8:52 AM, Olav Poppe olav.po...@me.com wrote:
 Hi,
 I’m trying to apply the below patch to allow comments longer than 360 
 characters. Changing the .js and .vm file works fine and the text field 
 allows long comments, BUT the system still refuses to store the data values 
 with long comments - 409 conflict is returned from the server. The comment 
 column has type «longtext». Any ideas of what could be the problem?
 
 Searching through the source code, I found two additional files where the 
 lengt of the comments are mentioned:
 - validationUtils.java, function commentIsValid() checks for comment length
 - DataValue.hbm.xml has property name=«comment» length=360 /
 
 Do these also need to be changed? If so, I guess a custom .war file will be 
 needed (as opposed to just changing the .vm and .js files)?
 
 Olav
 
 
 
 9. apr. 2014 kl. 11:48 skrev channara rin rin.chann...@gmail.com:
 
 Oh!, i am using MySQL. where i can find this sql expression?
 
 
 On Wed, Apr 9, 2014 at 4:46 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:
 Could be. On postgres, the datavalue table (at least on my system) looks 
 like this
 
 CREATE TABLE datavalue
 (
   dataelementid integer NOT NULL,
   periodid integer NOT NULL,
   sourceid integer NOT NULL,
   categoryoptioncomboid integer NOT NULL,
   value character varying(255),
   storedby character varying(100),
   lastupdated timestamp without time zone,
   comment character varying(360),
   followup boolean,
 
 
 In that case, not sure then. :-/
 
 Regards,
 Jason
 
 
 
 On Wed, Apr 9, 2014 at 11:42 AM, channara rin rin.chann...@gmail.com wrote:
 The default, comment field in datavalue table is longtext type.
 
 Best Regards,
 CHANNARA
 
 
 On Wed, Apr 9, 2014 at 4:40 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:
 Did you change the database field type from varchar to text?
 
 Regards,
 Jason
 
 
 
 On Wed, Apr 9, 2014 at 11:31 AM, channara rin rin.chann...@gmail.com wrote:
 Dear Lars,
 I tried to change in history.js
 but when i enter longer than 360 in comment, and press Save Comment. It 
 always jump:
 CONSOLE
 -
 ReferenceError: i18n_saving_comment_failed_error_code is not defined 
  history.js:64
 -
 
 history.js
 --
 function handleError( xhr, textStatus, errorThrown )
 {
 markComment( COLOR_RED );
 window.alert( i18n_saving_comment_failed_error_code + '\n\n' + 
 xhr.responseText );
 }
 
 
 On Wed, Apr 9, 2014 at 3:29 PM, Lars Helge Øverland larshe...@gmail.com 
 wrote:
 The cell border will be green for fields which have comments (next time you 
 open that form).
 
 
 
 
 On Wed, Apr 9, 2014 at 10:27 AM, channara rin rin.chann...@gmail.com wrote:
 Great, Thank you.
 SO i need to modify the 360 in history.js file?
 
 AND another problem is. when has comment, can show highlight data value in 
 dataset that has text in that comment? SO it is easy for us(ME staff) to 
 view if that data value has comment..
 
 Thank you
 CHANNARA
 
 
 
 
 
 On Wed

Re: [Dhis2-users] Sample of autorities given to user roles

[Olav Poppe]

Are you sure it is not just that the default page is the Dashboard, and the 
user does not have the authority to view the dashboard?

Olav

20. mai 2014 kl. 16:34 skrev Kader Irchad Barry kaderb...@gmail.com:

 Thank you Rodolfo. 
 
 Is there a minimal set of authorities to give to a role for enabling access 
 to DHIS 2? I've set these authorities to a role name data entry and create 
 a user with this role,  but the user isn't authorized to enter the site:
 
 Add/update data value
 Approve data
 Archive data
 Delete data value
 Export data
 Import data
 See data entry value
 See data visualizer module
 See GIS module
 See report module
 
 
 I checked in the database (userrolemembers table) if the userid of my data 
 entry user were associated to the correct userroleid of data entry role. 
 Everything is correct there. When setting ALL for authorities of this role, 
 the user is granted access...
 
 Also in update user page, elements belonging to the list Data capture and 
 maintenance organisation units are bold by default; when selecting 1 
 organization unit, this action removes the bold formatting. In Data output 
 and analysis organisation units, however, selecting 1 organization unit 
 changes its color to orange - which indicates, as for many other modules of 
 DHIS 2, that this organization unit is being selected.
 
 Is there something to understand with this Data capture and maintenance 
 organisation units list ? This is not detailed in the documentation. Does it 
 explain why my user can't get access to DHIS 2 ?
 
 Thanks.
 
 
 2014-05-20 11:47 GMT+03:00 Rodolfo Melia rme...@knowming.com:
 Hi Kader - at PSI, an international NGO, we have created generic roles that 
 group some authorities. You can look into our roles here
 
 http://support.psi-mis.org/hc/en-us/articles/201135056-PSI-DHIS-Security-User-Management-Access-Roles-
 
 Rodolfo
 
 On 19 May 2014, at 15:35, Kader Irchad Barry kaderb...@gmail.com wrote:
 
 Hello,
 
 Would it be possible to share samples of authorities you give to your 
 different user roles ? Fo example for a Data entry clerk, a Facility health 
 records and information officer, a District health records and information 
 officer, a Province health manager, a National health information system 
 division officer, and a National health manager (which are list of the 
 commonly found positions described in the guide).
 
 Best regards,
 Kader
 ___
 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
 
 ___
 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

___
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] Javascript for data entry totals

[Olav Poppe]

Hi, 
we’re working on some custom data entry forms with lots of totals and 
sub-totals. We’d like to avoid making lots of «meaningless» indicators that 
will only be needed in data entry, so I’ve been thinking of writing something 
in javascript to calculate the totals in data entry - but before doing with 
that, I thought I’d check on the list if anyone has done anything similar 
already they’d be willing to share?

Olav


___
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] Userroles Problem

[Olav Poppe]

Hi, 
if you are using DHIS in French, it could it be the same as this bug reported 
some time back: https://bugs.launchpad.net/dhis2/+bug/1293815 ?

Olav



9. apr. 2014 kl. 09:57 skrev riddy ndoma riddynd...@gmail.com:

 I have a problem. I created UserRoles but when I want to create a
 user. I do not see the roles appear on the form for adding users. some
 one help me??
 
 -- 
 Riddy NDOMA
 Software Developer
 *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
 *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
 *Blog:* http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : 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] Enhancements for 'Data capture for DHIS2' android app

[Olav Poppe]

Hi Araz, 
good work! 

Another comment: it seems that for single event programmes where capture of 
longitude/latitude is enable, it seems I have to enter there values to be 
allowed to do data entry? I don’t think having coordinates should be required 
for data entry. Also, I looked for a way to use the phone’s GPS to get 
coordinates, is that supported? If not, it would be a great addition. Also 
possibly picking the coordinates from a map.

Olav




15. mars 2014 kl. 14:44 skrev Araz Abishov araz.abishov.g...@gmail.com:

 Hi Prosper,
 
 Thank you for your input.
 
 As you have mentioned, there are some problems with entering server address. 
 This issue will be fixed very soon.
 Regarding navigation: I've decided to stick with current implementation of 
 data entry screen, because solutions are hacky or just make it even worth. 
 Nevertheless, I'm looking forward for better solution.
 
 Best Regards,
 Araz
 
 
 On Sat, Mar 15, 2014 at 6:37 PM, Araz Abishov araz.abishov.g...@gmail.com 
 wrote:
 Hi Lars,
 
 Thank you for advice :) I just wanted to get more details on where and how 
 application is being used, in order to get better understanding in which way 
 it should be developed.
 
 Best regards,
 Araz
 
 
 On Fri, Mar 14, 2014 at 11:48 AM, Lars Helge Øverland larshe...@gmail.com 
 wrote:
 Hi Araz, thanks for the good work, and its great that you are getting 
 feedback from the field! Just remember that you don't have to implement 
 everything people ask for - what i like about your app is that its so simple 
 and clean - make your own judgements and its okay to say no;-)
 
 best regards,
 
 Lars
 
 On Mar 13, 2014 8:23 PM, Prosper BT ptb3...@gmail.com wrote:
 Thanks Araz
 
 This is a nice app. We havent deployed it here but I have been playing around 
 with it and I have noticed
 
 1. While entering the url and password, the typing is messy you type one 
 character and it duplicates them then you delete and it deletes all. Has 
 anyone else experienced this behaviour?
 
 2. For section data, the different section are hiden up and not easy to 
 identify can we have prev next buttons insteady and at the end have save ans 
 upload.
 
 Will continue exploring
 
 Regards
 
 On Mar 13, 2014 8:23 PM, Araz Abishov araz.abishov.g...@gmail.com wrote:
 Hi dhis2 users,
 
 I'm developer of Data capture for DHIS2 android app. Currently, I'm 
 preparing a plan for future development of application. It would be great if 
 you could share with your experience of work with dhis2 and suggest which 
 features do you want to see in android client in first order.
 
 For those who unfamiliar with current android app, you can take a llok at it 
 here: https://play.google.com/store/apps/details?id=org.dhis2.mobile
 
 Best Regards,
 Araz
 
 ___
 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
 
 
 ___
 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
 
 
 
 ___
 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

___
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] Problems with Data Aggregation in DHIS 2.13

[Olav Poppe]

Hi, 
the pivot table uses the analytics tables as its data source, not the data 
mart. So make sure you have updates the analytics table. Also make sure you 
have not enabled aggregation levels for the data element.

Regards,
Olav

 Den 26. nov. 2013 kl. 07:00 skrev Felix Obareh foba...@softcall.co.ke:
 
 Hi,
 
 Our organizational unit hierarchy:-
 Ministry--County---Sub-County--Divisions---Locations---Sub-Locations---Villages
 Data is collected at the village level and is supposed to be aggregated 
 upwards. 
 I have created a data element population and gave it domain type , aggregate 
 of type (sum).
 I run enter data at the village level and run the datamart and go to pivot 
 table. I expect the the villages data (5 of them) should aggregate at the 
 Sub-location level.
 The higher level orgunits dont register any aggregate values. What might be 
 the problem.
 Regards
 
 
 ___
 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
___
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] Option set aggregation problem

[Olav Poppe]

Hi, 
everything looks fine with your setup as far as I can see, it looks like a bug 
with the aggregation. Could you register a bug report on 
https://launchpad.net/dhis2 ?

Olav



20. nov. 2013 kl. 10:29 skrev Seid Hussein seid.h...@gmail.com:

 Hi,
 
 I have recreated the issues on the demo application as well. I have created 
 one program with all the dataelements added some data (See Single Event 
 Without Registration for Ngelehun CHC under Bo -- Badjia).
 
 I have created aggregation operations for most of the patient data elements 
 (you can check the formula if it is because of mistakes I made), but still 
 only the number type data elements are getting aggregated and the occurrences 
 of each option set are not counted.
 
 Regards,
 
 
 Seid,
 
 
 On Wed, Nov 20, 2013 at 11:42 AM, Seid Hussein seid.h...@gmail.com wrote:
 Hi,
 
 Thanks for the reply. Regarding assigning the program to the user role, I 
 didn't do that so I think that's the problem.
 
 But for the aggregation issue, here's what happened. With a sample of what I 
 did.
 
 I have a program called -- BEmONC Obstetric complications at hospital with 
 only one program stage and it is created as a Single Event Without 
 Registration since we want anonymous data.
 
 The program stage has about eight data elements of which three are recorded 
 as texts selected from option sets and three are number data elements:
 
 Data Elements with Option Sets
 
 Period of pregnancy while coming to hospital --  Antepartum, Intrapartum and 
 postpartum
 Standard diagnosis --  Abortion complications, APH, PPH, Obstructed labor 
 and 4 others
 Mode of Delivery --  SVD, Assisted delivery and Cesarean section
 
 Number data elements
 
 Number of live births at hospital
 Number of still births at hospital
 Number of neonatal deaths at hospital
 
 At aggregation query builder, for the number data elements, the operator is 
 'Sum of data element values' and for the option sets, we want to count the 
 number of occurrences of a specific option from the option set so we used 
 'Number of visit'. Hence for a data element with eight options, we have eight 
 aggregation formulas and eight corresponding Number type data elements with 
 Aggregation domain. And for the number data elements we have one 
 corresponding data element with Aggregation domain.
 
 
 Examples of aggregated data elements:
 
 BEmONC Number of abortion complications at hospital --  aggregated from 
 Abortion complications option in Standard diagnosis 
 BEmONC Number of SVD deliveries at hospital --  aggregated from SVD from 
 Mode of Delivery
 BEmONC Total Number of live births at hospital --  aggregated from Number of 
 live births at hospital
 
 Now the problem is, though the aggregation from the Number data elements is 
 aggregating fine, the option sets (number of occurrences) are not.
 
 Anyways, I'll try to recreate it on the demo and report more information.
 
 
 Regards,
 
 
 Seid,
 
 
 
 On Wed, Nov 20, 2013 at 11:25 AM, Olav Poppe olav.po...@me.com wrote:
 Hi, 
 regarding not seeing the program on the demo server, have you made sure to 
 assign the program to your user role?
 
 Regarding the aggregation queries in 2.13, what exactly do you mean by not 
 aggregating Individual records with option sets (counting the number of 
 visits).» You want the number of visits where one of the options in the 
 option set was selected? For example, if the option set is Discharged, 
 Transfer, Died you want the number of visits where each of the three options 
 were selected? Could you share the aggregation query formula you are using?
 
 Olav
 
 20. nov. 2013 kl. 09:00 skrev Seid Hussein seid.h...@gmail.com:
 
 Hi all,
 
 Sorry for writing this again, but I thought may be my description of the 
 problem was not good.
 
 We have currently switched to DHIS 2.13 after facing problems with version 
 2.12 in aggregating Number data types in patient domain (sum of data values) 
 for Single Event Without Registration.
 
 However, it seems that although DHIS 2.13 has fixed the problem of not 
 aggregating Number data types with patient domain, is not aggregating 
 Individual records with option sets (counting the number of visits).
 
 When I try to recreate the problem on the demo application, I cannot enter 
 records on the program stage because for some reason, the program I assigned 
 to the organisation units is not available in program list (in Individual 
 records).
 
 I have tr cleied aring caches, using incognito mode in chrome and private 
 browsing in Firefox.
 
 Is it working for anybody else? Can you point to some solutions? 
 
 ___
 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
 
 
 

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2

Re: [Dhis2-users] [Dhis2-devs] DataIntegrity

[Olav Poppe]

Hi,
it means you have data elements with different category combinations in the 
same section. All data elements in a section must have the same (or no) 
category combination.

Olav


18. nov. 2013 kl. 08:52 skrev riddy ndoma riddynd...@gmail.com:

 Hi all,
 I did DataIntegrity, I get the message as shown in the image attached. I fail 
 to understand this problem. I did not even find in the manual. which may have 
 an idea about this message?
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 integrity.png___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : 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 Data Capture android app at Google Play

[Olav Poppe]

Hi Riddy,
the app uses APIs that are only available in 2.13.

Olav



22. okt. 2013 kl. 11:19 skrev riddy ndoma riddynd...@gmail.com:

 @Jason,
 Why should only communicate with version 2.13. We will then migrate to 
 version 2.13 and see what it will give.
 
 
 2013/10/22 Jason Pickering jason.p.picker...@gmail.com
 Hi Riddy,
 
 What I mean, is that you must be using DHIS2, version 2.13. The latest 
 release that is, not version 2.12 of DHIS2. 
 
 Regards,
 Jason
 
 
 
 On Tue, Oct 22, 2013 at 1:07 PM, riddy ndoma riddynd...@gmail.com wrote:
 @Jason, i use Jellybean(4.1.1)
 
 
 2013/10/22 Jason Pickering jason.p.picker...@gmail.com
 Like I said, for the Android client, you need 2.13. 
 
 Regards,
 Jason
 
 
 
 On Tue, Oct 22, 2013 at 1:02 PM, riddy ndoma riddynd...@gmail.com wrote:
 @Jason,
 version 2.12 was used
 
 
 2013/10/22 Jason Pickering jason.p.picker...@gmail.com
 Am pretty sure you must be using 2.13. Otherwise, you will get this error 
 message. 
 
 
 Regards,
 Jason
 
 
 
 On Tue, Oct 22, 2013 at 12:50 PM, riddy ndoma riddynd...@gmail.com wrote:
 Hi @Azar...
 I just installed the app on my phone. I took the address of our server and 
 the account. When I click on the Aggregate Report button displays ca me the 
 message incorrect server address
 
 
 2013/10/22 riddy ndoma riddynd...@gmail.com
 Hi @Azar...Ouf ! ...there 4 hours since I just download this application ... 
 I was wondering how to go ... I'm fine and you will explore questions if 
 possible!
 
 
 2013/10/22 Araz Abishov araz.abishov.g...@gmail.com
 Hi all,
 
 Dhis2 Android application is mobile client for Dhis2 server instances. In 
 general, client is an interface for some of the core Dhis2 functionality. 
 Application automatically downloads forms from Dhis2 server and stores them 
 on device. Client supports an offline workflow, where app and its data entry 
 can work even outside network coverage, and the data is submitted when there 
 is network coverage available again. 
 
 Currently app supports next Dhis2 functionality: 
 - Aggregate data entry 
 - Tracking events and programs (Currently only single event without 
 registration is supported) 
 - Users can modify their personal information and then submit it to dhis2 
 instance 
 - Application supports five languages: English, Spanish, French, Portuguese 
 and Indonesian.
 
 Requirements: 
 - At least Android  2.3 (Gingerbread)
 - Dhis2 (ver. 2.13)
 
 https://play.google.com/store/apps/details?id=org.dhis2.mobile
 
 If you have any questions regarding application, don't hesitate to ask. Also 
 any feedback is appreciated.
 
 ___
 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
 
 
 
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 
 
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 
 ___
 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
 
 
 
 
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 
 
 
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 
 
 
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 ___
 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

___
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_HOME in ubuntu

[Olav Poppe]

Not an export on this, but I would guess that if you are running tomcat as user 
seid, the Directory /home/dhis/config might not be writable as it belongs 
to the dhis user. So you could either try to start tomcat with user dhis 
instead, or make sure that the /home/dhis/config is writable by the seid 
user. And, like Jason says, make sure the hibernate.properties files is in the 
right folder.

Olav



2. okt. 2013 kl. 05:35 skrev Jason Pickering jason.p.picker...@gmail.com:

 Here is your error it looks like
 
 * INFO  2013-10-02 00:13:31,396 Directory /home/dhis/config is not writeable 
 (DefaultLocationManager.java [pool-2-thread-1])
 * INFO  2013-10-02 00:13:33,710 Could not read external configuration from 
 file system
 
 Are you sure there is a hibernate.properties file in that location and the 
 directory is writable?
 
 Regards,
 Jason
 
 
 
 
 
 On Tue, Oct 1, 2013 at 11:39 PM, Seid Hussein seid.h...@gmail.com wrote:
 I'm using the main user which is seid. Do I need to start using the user dhis?
 
 -- Forwarded message --
 From: Seid Hussein seid.h...@gmail.com
 Date: Wed, Oct 2, 2013 at 12:38 AM
 Subject: Re: [Dhis2-users] DHIS2_HOME in ubuntu
 To: Olav Poppe olav.po...@me.com
 
 
 I'm using the main user which is seid. Do I need to start using the user dhis?
 
 
 On Wed, Oct 2, 2013 at 12:32 AM, Olav Poppe olav.po...@me.com wrote:
 Hi,
 which Ubuntu user are you logged in with when you're starting tomcat?
 
 Olav
 
  Den 1. okt. 2013 kl. 23:24 skrev Seid Hussein seid.h...@gmail.com:
 
  Hi all,
 
  After setting setenv.sh and pointing both JAVA_HOME and DHIS2_HOME to their 
  appropriate places, and setting appropriate JAVA_OPTS, but still I cannot 
  still get DHIS to use the postgresql database rather than H2 database.
 
  When I check catalina.out, it says that DHIS2_HOME points to the correct 
  place but in the next line it says Directory /home/dhis/config is not 
  writeable
 
 
  to give you an idea,
 
  hibernate.properties file is located in /home/dhis/config
 
  and here's the content of setenv.sh which is located in 
  /usr/share/tomcat7/bin
 
  export JAVA_HOME='/usr/lib/jvm/java-7-oracle'
  export JAVA_OPTS='-Xmx2048m -Xms1024m -XX:MaxPermSize=500m 
  -XX:PermSize=300m'
  export DHIS2_HOME='/home/dhis/config'
 
  does anyone have any idea what i'm doing wrong?
 
  For reference I've attached catalina.out
  catalina.out
  ___
  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
 
 
 
 ___
 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
 
 
 ___
 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

___
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 live

[Olav Poppe]

Hi,
wanted to try dhis2-live on a mac for the first time today, but it fails to 
start. I've seem to remember that other people have reported that they have had 
problem getting dhis2-live to run lately (on windows), so I though I'de check 
if the problem was the same. In my case, the startup routine fails with the 
following error - any ideas on what the problem can be?

2013-09-26 15:45:40.216:WARN::Failed startup of context 
org.mortbay.jetty.webapp.WebAppContext@47c6f49{/,/Users/Olav/Downloads/dhis-live/webapps/dhis}
java.lang.RuntimeException: Failed to run startup routines: StatementCallback; 
uncategorized SQLException for SQL [ALTER TABLE chart ADD CONSTRAINT 
chart_uid_key UNIQUE(uid)]; SQL state [90045]; error code [90045]; Constraint 
CHART_UID_KEY already exists; SQL statement:|ALTER TABLE chart ADD CONSTRAINT 
chart_uid_key UNIQUE(uid) [90045-166]; nested exception is 
org.h2.jdbc.JdbcSQLException: Constraint CHART_UID_KEY already exists; SQL 
statement:|ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid) 
[90045-166]
at 
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:70)
at 
org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
at org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
at 
org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1272)
at 
org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
at 
org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:489)
at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
at 
org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
at org.mortbay.jetty.Server.doStart(Server.java:224)
at 
org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
at org.hisp.dhis.WebAppServer.run(WebAppServer.java:110)
___
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 live

[Olav Poppe]

Hi, 
downloaded from dhis2.org yesterday, so I assume it's 2.12. Also tried to use a 
recent trunk version of DHIS2, and it fails at the exact same place (after 
startup routine 3) with the same error.

However, I see now that it works when I point hibernate.properties to an 
existing psql database, so perhaps it could be related to starting up dhis2 
with an empty H2 (or whatever dhis2-live uses) database?

Olav



27. sep. 2013 kl. 09:32 skrev Lars Helge Øverland larshe...@gmail.com:

 Which DHIS 2 version and build is this?
 
 Lars
 
 
 On Thu, Sep 26, 2013 at 4:12 PM, Olav Poppe olav.po...@me.com wrote:
 Hi,
 wanted to try dhis2-live on a mac for the first time today, but it fails to 
 start. I've seem to remember that other people have reported that they have 
 had problem getting dhis2-live to run lately (on windows), so I though I'de 
 check if the problem was the same. In my case, the startup routine fails with 
 the following error - any ideas on what the problem can be?
 
 2013-09-26 15:45:40.216:WARN::Failed startup of context 
 org.mortbay.jetty.webapp.WebAppContext@47c6f49{/,/Users/Olav/Downloads/dhis-live/webapps/dhis}
 java.lang.RuntimeException: Failed to run startup routines: 
 StatementCallback; uncategorized SQLException for SQL [ALTER TABLE chart ADD 
 CONSTRAINT chart_uid_key UNIQUE(uid)]; SQL state [90045]; error code [90045]; 
 Constraint CHART_UID_KEY already exists; SQL statement:|ALTER TABLE chart 
 ADD CONSTRAINT chart_uid_key UNIQUE(uid) [90045-166]; nested exception is 
 org.h2.jdbc.JdbcSQLException: Constraint CHART_UID_KEY already exists; SQL 
 statement:|ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid) 
 [90045-166]
 at 
 org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:70)
 at 
 org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
 at org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
 at 
 org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1272)
 at 
 org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
 at 
 org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:489)
 at 
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at 
 org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
 at org.mortbay.jetty.Server.doStart(Server.java:224)
 at 
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at org.hisp.dhis.WebAppServer.run(WebAppServer.java:110)
 ___
 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
 

___
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 - Users] Problems with reports and data import and data entry at district level

[Olav Poppe]

Hi,
welcome to the list.

First of all, which version of DHIS2 are you running? Is it the same in the 
district and at the national level? 
Depending on the version of DHIS2 you are using, you will either have to run 
the Datamart or the Analytics tables to aggregate data before it is available 
in reports.

For the data entry issue, the first thing you can try is to ask the data entry 
clerk to clear his browser cache.

Olav


30. aug. 2013 kl. 14:26 skrev Zara Kamara zee21...@gmail.com:

 Hi All
 
 I am Zara Kamara HMIS Specialist  in Sierra Leone using this forum for
 the first time.
 I have 3 issues.
 1)  I cant seem to be able to import any data coming in
 from the districts  into the national server (We are on a distributed
 server system with hope of being online soon )
 
 2)  I  cant get reports. I usually use the Dataset reports
 and the Pivot tables. When I request one especially the dataset report
 it returns the form but with no aggregated data attached to it.
 
 3) Just this morning a data entry clerk in one of the districts
 reported being unable to do data entry. He enters a value and gets the
 following message -- Saving value failed with status code
 
 
 Kindly help.
 
 Best
 Zara Kamara .
 
 ___
 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


___
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] Layout of non-custom datasets

[Olav Poppe]

Hi, 
I actually meant  that the NON-custom forms should be more responsive. Will 
write blueprint.

Thanks
Olav


25. juli 2013 kl. 18:10 skrev Lars Helge Øverland larshe...@gmail.com:

 Hi,
 
 yes we can make the custom form layout a bit more responsive (should happen 
 automatically, no need for a setting). Could you please write a short 
 blueprint?
 
 Lars
 
 
 On Wed, Jul 24, 2013 at 4:22 PM, Olav Poppe olav.po...@me.com wrote:
 Hi,
 is there a way to choose how compact  tables in section/default dataset 
 should be displayed, similar to what is possible with tables in custom forms? 
 If not, I think it would be great if that feature could be added - some 
 tables with many categories seems to become wider than what is actually 
 necessary, forcing horizontal scrolling.
 
 Olav
 ___
 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
 

___
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] Layout of non-custom datasets

[Olav Poppe]

Hi,
is there a way to choose how compact  tables in section/default dataset 
should be displayed, similar to what is possible with tables in custom forms? 
If not, I think it would be great if that feature could be added - some tables 
with many categories seems to become wider than what is actually necessary, 
forcing horizontal scrolling.

Olav
___
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.11 Saving Value Failed with Status Code 1

[Olav Poppe]

Hi
did this start occurring after updating from 2.10 to 2.11? Does the same thing 
happen if using Chrome in Incognito mode?

Olav 


10. juni 2013 kl. 11:27 skrev Dayo Adeyomoye deemo...@yahoo.com:

 Hi all,
 
 DHIS 2.11 Data Entry page gives this error whenever a value is entered into 
 the boxes. It says Saving Value Failed with Status Code 1. Instead of also 
 turning green, it first turns yellow and then RED.
 
 Anyone with a solution?
 
 Thanks
 
 Dayo
 ___
 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

___
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] Downloading DHIS2 war fails. - Now day 2

[Olav Poppe]

Hi,
if the problem is that the connection is interrupted, you could try to use some 
sort of download manager that allows you to resume downloads (at least on 
windows there are many alternatives for that).

Olav



23. mai 2013 kl. 10:22 skrev Sovello Hildebrand Mgani 
sovellohpmg...@gmail.com:

 Merci Dav.
 Je vais essayer avec sourceforge maintenant.
 Dayo, I have tried all those and it ends up somewhere in the process of ca. 
 80% of the dowloaded stuff.
 
 Thanks you'll for the quick prompt and concern to assist.
 
 Cheerio
 
 
 2013/5/23 Dayo Adeyomoye deemo...@yahoo.com
 Bonjour,
 
 The war file is not so big for a broadband though just 82 MB. How are you 
 trying to download it? Are you downloading from terminal on a Linux 
 production environment or you are trying to download directly from the 
 browser? which ever way, this may help if you haven't tried it yet.
 
 1. Using terminal
 sudo wget stable.dhis2.org
 2. Using Web Browser direct
  download
 http://dhis2.org/download/releases/2.11/dhis.war
 
 Hope this helps.
 Adedayo
  
 BlackBerry: 3114F90C
 Phone: 08028851441, 08035560463
 emails: deemo...@yahoo.com, addyr...@yahoo.com
 Yahoo IM: deemoyes
 Facebook: pharael
 twitter:pharaell
 From: Sovello Hildebrand Mgani sovellohpmg...@gmail.com
 To: dhis2-users@lists.launchpad.net 
 Cc: Carlos Nyembwe nyem...@gmail.com 
 Sent: Thursday, May 23, 2013 8:54 AM
 
 Subject: [Dhis2-users] Downloading DHIS2 war fails. - Now day 2
 
 Dear Colleagues!
 Bonjour from Kinshasa [RDC].
 We are a in a kickstart to implementing DHIS2 here. We have been struggling 
 to download the dhis2.war v2.11 file now a second day without any success. 
 I wonder what the problem would be! We first though proxies and other 
 securities could be the reason and went onto a mobile broadband connection, 
 From all sorts of browsers to wget, and no avail.
 If someone has this file, may them share via any means or compress it to an 
 uploadable email file size please? 
 
 We would be more than grateful.
 
 Cheerio!
 
 -- 
 :: Sovello Hildebrand Mgani ::
 
 
 
 --If you teach man to fish, you'll feed him a lifetime--
 
 ___
 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
 
 
 
 
 
 -- 
 :: Sovello Hildebrand Mgani ::
 
 
 
 --If you teach man to fish, you'll feed him a lifetime--
 ___
 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

___
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] How do reports get registered as not on time?

[Olav Poppe]

If I remember correctly, all timeliness is based on the system setting for 
reporting timeliness, not on the Expiry dates.

If I remember correctly (again), different timeliness dates for different 
datasets is on the roadmap for a future release.

 
19. apr. 2013 kl. 10:37 skrev Knut Staring knu...@gmail.com:

 
 Data Sets have a property called Expiry Days, which determines when reporting 
 is locked after the end of the period.
 This can be overridden by a supervisor who creates a lock exception to 
 allow later reporting.
 
 Is it only in these cases that a report becomes registered as being not on 
 time?
 
 Knut
 
 
 -- 
 Knut Staring
 Dept. of Informatics, University of Oslo
 +4791880522
 http://dhis2.org
 
 ___
 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

___
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] [Help-Data validate]

[Olav Poppe]

Hi,
you can choose whether all data elements in the expression is required to have 
a value or not for the validation rule to be effective, using the skip for 
missing values property in the expression editor. If skip is true, then it 
requires all data elements to have values. If false, only one data element must 
have a value.

Olav

19. apr. 2013 kl. 12:41 skrev riddy ndoma riddynd...@gmail.com:

 Hi all,
 I have a problem a problem in terms of rule validation. 
 I defined the validation rule, but I noticed that she is well respected when 
 introducing 0 or another value in various input fields. But when the input 
 fields are empty, the execution of the validation is done with success, 
 whatever the rule defined
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 ___
 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

___
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] Displaying general stats on Dashboard

[Olav Poppe]

Hi,
which version of DHIS2 are you running - it does not look like one of the 
latest versions? I don't think the jasper report with jdbc data source option 
is there in 2.9 and older.

Olav


7. apr. 2013 kl. 14:16 skrev Alvin Marcelo alvin.marc...@gmail.com:

 Screenshot is attached..
 
 
 On Sun, Apr 7, 2013 at 8:16 PM, Alvin Marcelo alvin.marc...@gmail.com wrote:
 Thanks Lars.
 
 I only got to: - create a new standard report and call it statistics on 
 usage or similar.
 
 I cant find jasper report with jdbc data source
 
 
 
 
 On Sun, Apr 7, 2013 at 7:31 PM, Lars Helge Øverland larshe...@gmail.com 
 wrote:
 Hi Alvin,
 
 another approach is to create a standard report based on SQL where you query 
 for these things. I have attached a useful starting point.
 
 - create a new standard report and call it statistics on usage or similar.
 - select jasper report with jdbc data source.
 - select and upload the attached jrxml and save.
 - search for the report and add to dashboard by clicking on the pie-like 
 button.
 - in dashboard, select reports for one of the link areas to the left, the 
 report will now be available from the dashboard.
 
 
 
 Lars
 
 
 
 
 2013-04-07 08.26.36 pm.png___
 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

___
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] OptionSet and Yes-only Data Elements on Aggregated

[Olav Poppe]

That's a lot of clicks…. Agree that it would be a good idea to support 
check-boxes, I'm not sure why it isn't currently. 

Olav


27. mars 2013 kl. 12:03 skrev Rodolfo Melia rme...@knowming.com:

 Hi Olav. I'm assuming that you don't allow an 'Option Set' on the Aggregated 
 forms because there isn't any aggregation (sum, avg) that you can do we that 
 sort of values (well, you can do count..). Still I think it will be useful, 
 because there are calculation (indicators) or validations that you will be 
 able to do with that info. But that's for another day.
 
 For the 'Yes only', which is very similar to Yes/No/False, you can do sum, 
 average or count. What I plan to do is to calculate a performance index based 
 on the number of yes for the bi-annual questionnaire that needs to be run in 
 all facilities. The reason that I will prefer a tick box, rather than the 
 current drop down of Yes/No/False, is to improve user experience by having a 
 single click/ finger action. If you think that these forms will have 150+ 
 questions, run every 6 months, in 300 facilities... that's about 90,000 mouse 
 clicks (or finger clicks) that I can save to the 15 facility coordinators 
 that are responsible for this process in Kenya. We have similar 
 questionnaires that we want to implement using DHIS in other 45 countries: so 
 we can improve PSI facility supervisors' work by eliminating up to 4m clicks 
 (mouse or finger) every year !
 
 Rodolfo
 
 On Wed, Mar 27, 2013 at 10:35 AM, Olav Poppe olav.po...@me.com wrote:
 Hi,
 I have not really tried to use the yes only in aggregate, but I can see 
 that it renders as a text box instead of a tick mark like you say. Someone 
 else will have to respond to whether there is any reason for this, like if 
 the yes only is not supported in aggregate like the option sets.
 
 Olav
 
 
 26. mars 2013 kl. 16:05 skrev Rodolfo Melia rme...@knowming.com:
 
 Hi Olav - just to finish the conversation above. It is clear that Option 
 Sets are not supported by a DataSet on the aggregated side.
 
 What it is not clear to me is if the 'Yes Only', which renders as a 'tick 
 box' on Tracker, should render or not on the DataSets for the aggregated 
 side. It will great if it does, as it will improve significantly the use of 
 DHIS on a tablet - I'm trying to do a long questionnaire that needs to be 
 run every 6 months, and the people running the survey will complete it using 
 a tablet. Most of the questions are True/False. At the moment a Yes/No/Null 
 means two interaction: one to open the drop-down, one to select; a Tick-box 
 will be a single interaction, and when completing over 100+ questions, it 
 will make a significant difference to the users.
 
 
 R
 
 On Tue, Mar 26, 2013 at 11:55 AM, Rodolfo Melia rme...@knowming.com wrote:
 ok. What about 'Yes-Only' ?
 
 
 On Tue, Mar 26, 2013 at 11:54 AM, Olav Poppe olav.po...@me.com wrote:
 Hi,
 OpionSets are only supported in the tracker, assigning an optionset to an 
 aggregate type data element will not have any effect.
 
 Olav
 
 
 Den 26. mars 2013 kl. 12:36 skrev Rodolfo Melia rme...@knowming.com:
 
 Hi everyone - I have a question about the rendering on Option Sets and 
 Yes-Only on DataSets (Aggregated). On Tracker (DataElement.Domain = 
 Patient), OptionSet and Yes-only data elements successfully render as 
 either a dynamic drop-down or a tick box. But on Aggregated they render as 
 a simple text box. On the other hand, Yes/No does render as a drop-down. Is 
 this a bug or is this on purpose? I'm using multiple versions of DHIS, 
 including the latest release of 2.11.
 
 Below a screenshot in Tracker, which works as expected
 image.png
 
 Below, rendering as a DataSet: no dropdown option or tick box get 
 redenred...
 image.png
 
 
 
 R
 
 -- 
 Rodolfo Meliá
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 ___
 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
 
 
 
 -- 
 Rodolfo Meliá
 Principal
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 
 Note: Please note my new email address, which I will be using for PSI 
 related work: rme...@knowming.com
 
 
 
 -- 
 Rodolfo Meliá
 Principal
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 
 Note: Please note my new email address, which I will be using for PSI 
 related work: rme...@knowming.com
 
 
 
 
 -- 
 Rodolfo Meliá
 Principal
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 
 Note: Please note my new email address, which I will be using for PSI related 
 work: rme...@knowming.com

Re: [Dhis2-users] OptionSet and Yes-only Data Elements on Aggregated

[Olav Poppe]

Hi,
OpionSets are only supported in the tracker, assigning an optionset to an 
aggregate type data element will not have any effect.

Olav


Den 26. mars 2013 kl. 12:36 skrev Rodolfo Melia rme...@knowming.com:

 Hi everyone - I have a question about the rendering on Option Sets and 
 Yes-Only on DataSets (Aggregated). On Tracker (DataElement.Domain = Patient), 
 OptionSet and Yes-only data elements successfully render as either a dynamic 
 drop-down or a tick box. But on Aggregated they render as a simple text box. 
 On the other hand, Yes/No does render as a drop-down. Is this a bug or is 
 this on purpose? I'm using multiple versions of DHIS, including the latest 
 release of 2.11.
 
 Below a screenshot in Tracker, which works as expected
 image.png
 
 Below, rendering as a DataSet: no dropdown option or tick box get redenred...
 image.png
 
 
 
 R
 
 -- 
 Rodolfo Meliá
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia
 ___
 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
___
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] Adding New Top Level Organization Units

[Olav Poppe]

Hi,
I'm not actually sure whether or not that will work, or if some functionality 
depend on having a single root - copying the developer list.

At least, as Morten mentioned, you will need to assign you user to all the root 
orgunits to see them.

Olav


3. mars 2013 kl. 07:45 skrev James Chang jamesbjch...@hotmail.com:

 Yes, we are trying to have 5 root organization units on the unit 
 tree/hierarchy.
 Is it not a proper setting to have?  Is there the downside of doing so?
  
 Thanks.
  
  
 From: Olav Poppe
 Sent: Saturday, March 02, 2013 8:24 PM
 To: ChangJames
 Cc: dhis2-users@lists.launchpad.net
 Subject: Re: [Dhis2-users] Adding New Top Level Organization Units
  
 Hi,
 are you saying you want to have more than one root in the organisation unit 
 tree/hierarchy?
  
 Olav
  
 2. mars 2013 kl. 12:07 skrev ChangJames jamesbjch...@hotmail.com:
 
 Hi,
  
 I have added a new sets of top level organization units (5 new top level org 
 units) on our DHIS2 app and having issue seeing these added top level org 
 units on the org tree list.  They were added straight to Database and 
 restarted the DHIS afterwards for uid generation.  There already were some 
 existing org units in the DHIS. 
 Tried clearing cache, adding org units via UI, but still I can not see it.
 I have also tried adding via UI and clearing out the parentid field in DB to 
 make them top level.  But nothing seems to be working – for displaying them.
  
 Is there some steps I need to take to have them displayed?
 Has the DHIS2 recently been changed on how it deals (displays) the added top 
 level organization units?
  
 In previous versions, even through it wasn’t straight forward process, I was 
 able to see the DB added new top level organization units by restarting  
 adding new org units in UI.
  
 Any info relating to this issue will be helpful.
  
 Thank you.
 ___
 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
 
  

___
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] Adding New Top Level Organization Units

[Olav Poppe]

Hi,
are you saying you want to have more than one root in the organisation unit 
tree/hierarchy?

Olav

2. mars 2013 kl. 12:07 skrev ChangJames jamesbjch...@hotmail.com:

 Hi,
  
 I have added a new sets of top level organization units (5 new top level org 
 units) on our DHIS2 app and having issue seeing these added top level org 
 units on the org tree list.  They were added straight to Database and 
 restarted the DHIS afterwards for uid generation.  There already were some 
 existing org units in the DHIS. 
 Tried clearing cache, adding org units via UI, but still I can not see it.
 I have also tried adding via UI and clearing out the parentid field in DB to 
 make them top level.  But nothing seems to be working – for displaying them.
  
 Is there some steps I need to take to have them displayed?
 Has the DHIS2 recently been changed on how it deals (displays) the added top 
 level organization units?
  
 In previous versions, even through it wasn’t straight forward process, I was 
 able to see the DB added new top level organization units by restarting  
 adding new org units in UI.
  
 Any info relating to this issue will be helpful.
  
 Thank you.
 ___
 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

___
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 Mobile

[Olav Poppe]

Hi John,
there are quite a few options for reporting to DHIS2 using mobile phones, can 
you give us a bit more information about your case:
- is this aggregate data or case-based data?
- what type of phones will be used: do the phones support java? If it is 
smartphones, do they use a browser that supports offline storage?
- do you require support for offline data entry?
- how much data are they supposed to enter? If it is only a few data elements, 
the new SMS reporting might be an option.

Regards
Olav

26. feb. 2013 kl. 17:51 skrev John Ojo jn...@yahoo.com:

 Dear All,
 
 I need to enable field workers in a country to be able to report into a DHIS2 
  (version 2.10) database using mobile phones.
 Please, I need a step-by-step instructions on how to go about achieving this.
 
 I will appreciate your kind assistance in this direction.
 
 Thank you.
 John.
  
 John Ojo MD, FMCPH
 Accra, Ghana.
 Mobile: +233 234691626
 Skype:  Johnojo
 Email: jn...@yahoo.com
 ___
 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

___
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] Example of iReport based on custom query on DHIS-2 demo site?

[Olav Poppe]

Hi,
sorry for the delay. Below is a query that will take the org unit parameter and 
list all the children of that orgunit.

Olav


18. feb. 2013 kl. 14:14 skrev Wilson,Randy rwil...@msh.org:

 Hi Olav,
  
 Thanks for sending this, I’ve replaced the query with one that is applicable 
 for one of my custom iReports, but still can’t seem to get the report to 
 work.  Do you think you could make a generic ireport jrxml file – perhaps 
 listing all orgunits at level 3 sorted by level 1 and level 2.
  
 Then I could run it with fewer modifications in my local instance. 
  
 Our issue may be partly due to the fact that we’re using SSL and we need a 
 special connection string;  
 jdbc:postgresql://lion:5432/healthfinance?ssl=truesslfactory=org.postgresql.ssl.NonValidatingFactory
  
 Thanks,
  
 Randy
  
 From: Olav Poppe [mailto:olav.po...@me.com] 
 Sent: Friday, February 15, 2013 9:49 AM
 To: Wilson,Randy
 Cc: DHIS Users
 Subject: Re: [Dhis2-users] Example of iReport based on custom query on DHIS-2 
 demo site?
  
 Hi,
 below is an example of an ireport using custom SQL, with report parameters 
 (period and orgunit). I assume you start out with the empty report template 
 you get in DHIS?
  
 Olav
  
 (not sure if attachments work on the user list, so I've put the content of 
 the file at the end of the mail)
  
  
  
  
  
  
  
 15. feb. 2013 kl. 08:40 skrev Wilson,Randy rwil...@msh.org:
 
 
 We’ve been trying to publish iReports in our DHIS-2 instance using custom 
 queries and parameters, but continue to receive errors.  I was hoping to see 
 some examples on the demo site, but they are all based on report tables. 
 Could someone put some examples of iReports based on custom postgres queries 
 so that we can see how to configure connection strings.
  
 The documentation in the user guide is not adequate.
  
 Randy Wilson
  
 ___
 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
  
 


?xml version=1.0 encoding=UTF-8?
jasperReport xmlns=http://jasperreports.sourceforge.net/jasperreports; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; 
xsi:schemaLocation=http://jasperreports.sourceforge.net/jasperreports 
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd; name=report1 
pageWidth=612 pageHeight=792 whenNoDataType=AllSectionsNoDetail 
columnWidth=572 leftMargin=20 rightMargin=20 topMargin=20 
bottomMargin=20 uuid=df48aa2c-3795-40ea-8bb4-7e8988796c80
property name=ireport.zoom value=1.3314/
property name=ireport.x value=0/
property name=ireport.y value=0/
parameter name=periods class=java.lang.String/
parameter name=period_name class=java.lang.String/
parameter name=organisationunits class=java.lang.String/
parameter name=organisationunit_name class=java.lang.String
defaultValueExpression![CDATA[Sierra 
Leone]]/defaultValueExpression
/parameter
parameter name=organisationunit_level class=java.lang.Integer/
parameter name=organisationunit_level_column 
class=java.lang.String/
queryString
![CDATA[select name from organisationunit where parentid in 
(select organisationunitid from organisationunit where name like 
$P{organisationunit_name}) order by name asc;]]
/queryString
field name=name class=java.lang.String/
background
band splitType=Stretch/
/background
title
band height=248 splitType=Stretch
staticText
reportElement 
uuid=4746abd3-c65d-4a1a-be4d-0be0885a7c59 x=219 y=112 width=122 
height=20/
textElement/
text![CDATA[List of children 
orgunits]]/text
/staticText
/band
/title
pageHeader
band height=13 splitType=Stretch/
/pageHeader
columnHeader
band height=22 splitType=Stretch
staticText
reportElement 
uuid=517ac85f-8df4-4474-9654-bc5323fa9448 x=219 y=0 width=149 
height=20/
textElement verticalAlignment=Middle
font isBold=true/
/textElement
text![CDATA[name]]/text
/staticText
/band
/columnHeader
detail
band height=21 splitType=Stretch
textField
reportElement 
uuid=7c6e200f-f2ac-47e6-bac1-19bddded4115 x=219 y=0 width=149 
height=20/
textElement verticalAlignment=Middle/

textFieldExpression![CDATA[$F{name

Re: [Dhis2-users] Example of iReport based on custom query on DHIS-2 demo site?

[Olav Poppe]

Hi,
below is an example of an ireport using custom SQL, with report parameters 
(period and orgunit). I assume you start out with the empty report template you 
get in DHIS?

Olav

(not sure if attachments work on the user list, so I've put the content of the 
file at the end of the mail)







15. feb. 2013 kl. 08:40 skrev Wilson,Randy rwil...@msh.org:

 We’ve been trying to publish iReports in our DHIS-2 instance using custom 
 queries and parameters, but continue to receive errors.  I was hoping to see 
 some examples on the demo site, but they are all based on report tables. 
 Could someone put some examples of iReports based on custom postgres queries 
 so that we can see how to configure connection strings.
  
 The documentation in the user guide is not adequate.
  
 Randy Wilson
  
 ___
 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





?xml version=1.0 encoding=UTF-8?
jasperReport xmlns=http://jasperreports.sourceforge.net/jasperreports; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; 
xsi:schemaLocation=http://jasperreports.sourceforge.net/jasperreports 
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd; name=report1 
pageWidth=595 pageHeight=842 whenNoDataType=AllSectionsNoDetail 
columnWidth=555 leftMargin=20 rightMargin=20 topMargin=20 
bottomMargin=20 uuid=df48aa2c-3795-40ea-8bb4-7e8988796c80
property name=ireport.zoom value=1.0/
property name=ireport.x value=17/
property name=ireport.y value=0/
parameter name=periods class=java.lang.String

defaultValueExpression![CDATA[46424]]/defaultValueExpression
/parameter
parameter name=period_name class=java.lang.String/
parameter name=organisationunits class=java.lang.String/
parameter name=organisationunit_name class=java.lang.String

defaultValueExpression![CDATA[orgunitname]]/defaultValueExpression
/parameter
parameter name=organisationunit_level class=java.lang.Integer/
parameter name=organisationunit_level_column 
class=java.lang.String

defaultValueExpression![CDATA[idlevel2]]/defaultValueExpression
/parameter
queryString
![CDATA[SELECT
  patientdatavalue.value,
  count(patientdatavalue.value)
FROM
  public.patientdatavalue,
  public.programstageinstance
WHERE
  programstageinstance.programstageinstanceid = 
patientdatavalue.programstageinstanceid AND
  patientdatavalue.dataelementid = 46570 AND
  programstageinstance.programinstanceid = 46222 AND
  programstageinstance.executiondate = (select startdate from period where 
periodid in (select cast(($P{periods}) as int))) and
  programstageinstance.executiondate = (select enddate from period where 
periodid in (select cast(($P{periods}) as int))) and
  programstageinstance.completed = true and
  programstageinstance.organisationunitid in (select organisationunitid from 
_orgunitstructure
where
  idlevel5 is not NULL and
  ($P!{organisationunit_level_column}) = (select organisationunitid from 
organisationunit where name like $P{organisationunit_name}))
group by
  patientdatavalue.value
order by
  count(patientdatavalue.value) desc
limit 50;]]
/queryString
field name=value class=java.lang.String/
field name=count class=java.lang.Long/
background
band splitType=Stretch/
/background
title
band height=84 splitType=Stretch
staticText
reportElement 
uuid=9a842c2e-cf40-4e12-8582-dde35583b4e9 x=11 y=0 width=532 
height=41 forecolor=#184F73/
textElement textAlignment=Center
font size=24/
/textElement
text![CDATA[Top 50 Inpatient 
Morbidity]]/text
/staticText
staticText
reportElement 
uuid=a29131ef-514a-408d-8d71-c600deb16c3f x=261 y=52 width=24 
height=20/
textElement textAlignment=Center
font size=14/
/textElement
text![CDATA[-]]/text
/staticText
textField
reportElement 
uuid=be4d738d-f34a-448b-9365-fe5b1ca2b735 x=96 y=52 width=165 
height=20/
textElement textAlignment=Right
font size=14/
/textElement

textFieldExpression![CDATA[$P{period_name}]]/textFieldExpression
/textField

Re: [Dhis2-users] Suggestion on event list on Single Event Without Registration

[Olav Poppe]

Hi,
when you go to data entry and choose a program, you will automatically get a 
list/table of the latest events that have been entered. You can specify for 
each programme which columns/data elements to display in this list, which 
should make it easier both the find errors and correct them.

Olav


25. jan. 2013 kl. 11:52 skrev Muhire Andrew muhireand...@yahoo.com:

 Hi all,
 
 In Patient record when someone uses Single Event Without Registration after 
 entering data, you can have a list of all events entered but if a user wants 
 to make any correction it’s difficult to know which is which because no 
 identifier, I would suggest to have one optional field to put identifier eg 
 like Audit number, etc. this will help user to quickly know from 20 forms 
 entered a day which is the one I want to make correction instead of randomly 
 checking each form. Again in this Event list, In the first column we have 
 incremental numbers that keeps changing, so its not helping users to identify 
 the form.
 
 Did anyone came across this issue from the Users?
 
 Thanks!
 
  
 
 
 
 
 
  Muhire Andrew
  Ministry of Health / HMIS
 The goal is to transform data into information, and information into insight
 
 
  Phone:0788436150Twitter 
 :andrewmuhire
 
 
 
 ___
 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

___
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] Orgunit group reports and population-based indicators

[Olav Poppe]

Hi,
came over and issue today regarding the calculation of indicators based on
organisation unit groups. Not sure if there are any easy ways to solve it,
but though it was worth discussing.

The problem is ownership reports with indicators using population.
Population data is often entered for districts (of similar). These have
government ownership, thus when comparing performance based on
ownership/population, figures will be wrong.

One way to solve this would be to have catchement population for all
facilities, giving a population figure that acutally have an ownership. But
in cases with several aggregation levels for population (facility +
district), the same problem would probably occur in a district or regional
reports?

Another option would be to avoid the ownership of population data, either
by (somehow) not having an ownership for non-facilities, or by computing
such indicators cumulatively for org unit groups. This is probably best
explained through an example:
A district has a population of children  1 years of 100. 60 children are
given BCG at government facilities, 30 at private facilities. An indicator
showing BCG coverage for that district would currently (from how I
understand it) show a coverage of 60/100 = 60% for government and 30/0
= 0% for private. Maybe it would make more sense to show this as 60/100 =
60% for government and 30/100 = 30 % for private, giving the the total
(correct) coverage of 90%? Without knowing the actual catchment population
for the private and government facilities, it's impossible to calculate the
real coverages, but as a whole I believe this method could be better on
average?

Olav
___
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] NonUniqueResultException for Anonymous Event Reports

[Olav Poppe]

Hi, 
having problems with Anonymous Events Reports for one dataset - get an 
exception that the query did not return a unique result. 

See log below. Any ideas? 

Olav

Exception (org.hibernate.NonUniqueResultException): query did not return a 
unique result: 2
org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899)
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
org.hisp.dhis.patientdatavalue.hibernate.HibernatePatientDataValueStore.get(HibernatePatientDataValueStore.java:183)
org.hisp.dhis.patientdatavalue.DefaultPatientDataValueService.getPatientDataValue(DefaultPatientDataValueService.java:180)
sun.reflect.GeneratedMethodAccessor1402.invoke(Unknown source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
$Proxy56.getPatientDataValue(Unknown source)
org.hisp.dhis.program.DefaultProgramStageInstanceService.getSingleEventReport(DefaultProgramStageInstanceService.java:247)
sun.reflect.GeneratedMethodAccessor1760.invoke(Unknown source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
$Proxy59.getSingleEventReport(Unknown source)
org.hisp.dhis.caseentry.action.report.GenerateSingleEventReportAction.execute(GenerateSingleEventReportAction.java:146)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:89)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:88)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

Re: [Dhis2-users] [Dhis2-devs] DHIS 2 Live

[Olav Poppe]

Yes, sounds like disabling some modules might be something to consider. We're 
waiting for a document detailing the connectivity at various offices at the 
moment, hopefully that will give a better overview of how big issue this will 
be.

As for the HW, the only thing I know at the moment is that the machines 
(windows) running the current system will be used for DHIS 2 as well. So it 
will probably vary quite a bit from location to location.

Olav

Den 18. aug. 2011 kl. 15:34 skrev Bob Jolliffe:

 On 18 August 2011 16:14, Knut Staring knu...@gmail.com wrote:
 On Thu, Aug 18, 2011 at 4:25 PM, Bob Jolliffe bobjolli...@gmail.com wrote:
 
 On 18 August 2011 14:40, Olav Poppe olav.po...@gmail.com wrote:
 I wonder about the merits of a stripping out the metadata maintenance
 modules in a such a lite-lite install?  Not sure how crippling this
 would be.  Metadata import being the only way to update metadata.
 Maybe that's too draconian but it could work for ultra-offline data
 entry.
 
 I would recommend being quite draconian and pretty much disable the whole
 Maintenance menu and quite a bit of the services menu as well. And then
 train them really well on the remaining parts, and creating a targeted,
 short and simple manual (ideally accompanied by some video clips) so that
 support can be kept to a minimum (or at worst done over the phone).
 
 And I thought I was the draconian one :-)  Still if its only a matter
 of removing some modules from a custom pom it could be worth looking
 at.  Olav maybe you want to try and see how it looks.
 
 The emphasis on eliminating moving parts and sources of error of course also
 harks back to you DHIS appliance idea, Bob. One could even think of
 running DHIS Live with H2 off USB sticks (though they are flimsy), which
 could even be made to boot up something like DamnedSmallLinux.
 
 I'm not too convinced by the usb stick idea.  Not that its not doable.
 And I think its probably great for demos (WHO-on-a-stick) but in
 real-life I don't think these sticks are well suited for database
 read-writes.
 
 One of the issues people do tend to have with h2 is a lack of
 supporting tools to diagnose when things go wrong.  And I'd hate to be
 on the phone to someone stepping through openoffice+jdbc setup or the
 like.  If I were to ship h2 into the darkness of many remote districts
 I think I would write a couple of really simple and small diagnostic
 tools to test the integrity and health of the database and ship that
 too.  Just the where there is no doctor common sorts of faults.
 Then when I get the call help!  my dhis2-ultra-lite doesn't work,
 I'd ask them to run the diagnostic tool and read out the diagnosis
 over the phone to quickly figure out if the h2 file is corrupted, or
 metadata is misconfigured or what have you.  Planning for 170 offline
 installs (or some reasonable proportion of that number) is no picnic.
 The more work up front to make those calls easier the better.
 
 Cheers
 Bob
 
 Knut
 
 
 Bob
 
 Olav
 
 Den 18. aug. 2011 kl. 13:32 skrev Jason Pickering:
 
 I agree with both Bob and Ola.
 We have tried not quite yet succeeded in getting DHIS2 installed with
 Tomcat/Postgres on Windows with a one-click installer, this my caveat
 about
 a supervised install. There are a lot of things which can happen on
 users
 machines and maintenance becomes a huge issue. DHIS is still under
 intense
 development, and a lot of things change quickly. Upgrading a single
 server
 is a piece of cake. Upgrading dozens or hundreds of off-line machines is
 a
 true nightmare and a serious risk and resource drain to any deployment.
 I agree with Ola. Totally exclude an on-line server as an option first.
 If
 you have already done that, all I can say is, be prepared for a LOT of
 tech
 support.
 Regards,
 Jason
 
 On Thu, Aug 18, 2011 at 3:15 PM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:
 
 Olav,
 How offline are these districts? Can they not get connected through
 mobile
 usb modems/dongles? There is so much to gain from online deployment
 that I
 would check out every alternative of connectivity before deciding to go
 completely offline. The mobile Internet solution is working very well
 in
 Kenya. With the offline data entry capabilities in the upcoming 2.4,
 the
 districts do not have to be online during the data entry process, which
 is a
 major advantage in areas with poor/unstable connectivity.
 
 Further recommendations on deployment can be found in the
 implementation
 guide here:
 http://dhis2.org/doc/snapshot/en/implementer/html/ch04.html
 And a presentation on the same topic in the zip file with
 implementation
 guide slides here:
 http://dhis2.org/download/presentations/presentations.zip
 Ola
 ---
 
 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo
 
 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
 
 
 On 18 August 2011 15:02, Jason Pickering jason.p.picker

Re: [Dhis2-users] [Dhis2-devs] DHIS 2 Live

[Olav Poppe]

What would be the main benefits of this versus just using the H2 database in 
DHIS live, except the documentation?
 
Den 18. aug. 2011 kl. 14:12 skrev Jason Pickering:

 We have also created an H2 installer, which is considerably easier than the 
 Postgres installer. This would allow you to install this on a users machine, 
 with the documentation and a pre-populated H2 database, which may be 
 something to consider. Let me know if this would fit your deployment plans, 
 and we can discuss more details. 
 
 Regards,
 Jason
 
 
 On Thu, Aug 18, 2011 at 4:10 PM, Olav Poppe olav.po...@gmail.com wrote:
 Thanks, I will at least try to see how the default H2 performs.
 
 Olav
 
 Den 18. aug. 2011 kl. 13:50 skrev Knut Staring:
 
 I agree with Bob that it is worth trying going with H2, as it does simplify 
 things considerably. It also provides a possibility for db backup (and 
 transmission) through the copying (and sending) of the whole db file (though 
 a monthly zipped incremental DXF export should be smaller).
 
 Knut
 
 On Thu, Aug 18, 2011 at 3:40 PM, Olav Poppe olav.po...@gmail.com wrote:
 Thanks
 It seems the barrier for going offline should be quite high... Will have to 
 look more into exactly how bad the connections are in the worse areas, and 
 also into the offline data entry in 2.4.
 
 As for those districts that are in fact offline, is the live package with H2 
 sufficient? Keeping postgres out of the picture would likely reduce the 
 amount of support required quite a lot.
 
 Olav 
 
 
 Den 18. aug. 2011 kl. 13:32 skrev Jason Pickering:
 
 I agree with both Bob and Ola. 
 
 We have tried not quite yet succeeded in getting DHIS2 installed with 
 Tomcat/Postgres on Windows with a one-click installer, this my caveat about 
 a supervised install. There are a lot of things which can happen on users 
 machines and maintenance becomes a huge issue. DHIS is still under intense 
 development, and a lot of things change quickly. Upgrading a single server 
 is a piece of cake. Upgrading dozens or hundreds of off-line machines is a 
 true nightmare and a serious risk and resource drain to any deployment. 
 
 I agree with Ola. Totally exclude an on-line server as an option first. If 
 you have already done that, all I can say is, be prepared for a LOT of tech 
 support. 
 
 Regards,
 Jason
 
 
 On Thu, Aug 18, 2011 at 3:15 PM, Ola Hodne Titlestad ol...@ifi.uio.no 
 wrote:
 Olav,
 
 How offline are these districts? Can they not get connected through mobile 
 usb modems/dongles? There is so much to gain from online deployment that I 
 would check out every alternative of connectivity before deciding to go 
 completely offline. The mobile Internet solution is working very well in 
 Kenya. With the offline data entry capabilities in the upcoming 2.4, the 
 districts do not have to be online during the data entry process, which is 
 a major advantage in areas with poor/unstable connectivity.
  
 Further recommendations on deployment can be found in the implementation 
 guide here:
 http://dhis2.org/doc/snapshot/en/implementer/html/ch04.html
 
 And a presentation on the same topic in the zip file with implementation 
 guide slides here:
 http://dhis2.org/download/presentations/presentations.zip
 
 Ola
 ---
 
 
 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo
 
 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
 
 
 
 On 18 August 2011 15:02, Jason Pickering jason.p.picker...@gmail.com 
 wrote:
 One strong reason not to use it is the relative lack of testing. In theory, 
 it should work, but just as with MySQL, much more testing has occurred with 
 Postgres than with the other database systems. 
 
 We have some beta-level Windows installers, which might be of interest to 
 you, which work pretty well under supervised circumstances. It might be 
 something to consider if you want a relatively automated install of the 
 DHISLive/Postgresql stack, with automated restore of the database. 
 
 Regards,
 Jason
 
 
 On Thu, Aug 18, 2011 at 2:48 PM, Olav Poppe olav.po...@gmail.com wrote:
 Hello,
 we're looking at what do to with offline installations for the 
 implementation here in Ghana. Are there any reasons not to use DHIS Live? 
 Can H2 be used (importing the metadata into an empty database), or should 
 postgres be set up as well?
 
 There are 170 districts here, and about half of them might have to be 
 offline installs so an easy-to-use solutions would be good.
 
 Thanks,
 Olav
 
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : 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.net
 Unsubscribe : https://launchpad.net/~dhis2

Re: [Dhis2-users] [Dhis2-devs] DHIS 2 Live

[Olav Poppe]

I guess this can be an interesting experiment then! Will do some testing with 
the live package to see how it performs with the current (meta)data at least.

Den 18. aug. 2011 kl. 14:25 skrev Bob Jolliffe:

 On 18 August 2011 14:40, Olav Poppe olav.po...@gmail.com wrote:
 Thanks
 It seems the barrier for going offline should be quite high... Will have to
 look more into exactly how bad the connections are in the worse areas, and
 also into the offline data entry in 2.4.
 As for those districts that are in fact offline, is the live package with H2
 sufficient? Keeping postgres out of the picture would likely reduce the
 amount of support required quite a lot.
 
 Simple answer is no one has tried it yet in such a production setting.
 And as Ola points out, you really want to avoid offline as much as
 possible as it creates an exponential maintenance headache - both in
 terms of keeping hardware and software running, but also keeping
 metadata in synch.
 
 Where you must be offline because you are indeed seriously offline
 then the less software you have to maintain the better.
 
 BUT, metadata maintenance will still be a human/policy/HR problem
 regardless of the underlying db stack and is likely to be your biggest
 headache.  The most draconian approach would be to to provide
 districts with metadata (or even a metadata populated starter db file)
 and require that they don't alter anything other than add data.  We
 don't currently have a way to enforce this metadata ownership concern
 through the software and in fact it becomes less of a concern as
 things become more centralized.
 
 Slightly less draconian being that they can add metadata but not alter
 or remove state provided metadata.  When this happens, then the
 exports to state level will be troubled as many districts will be
 expected to be using the same dataelements, categories, datasets etc.
 
 I wonder about the merits of a stripping out the metadata maintenance
 modules in a such a lite-lite install?  Not sure how crippling this
 would be.  Metadata import being the only way to update metadata.
 Maybe that's too draconian but it could work for ultra-offline data
 entry.
 
 Bob
 
 Olav
 
 Den 18. aug. 2011 kl. 13:32 skrev Jason Pickering:
 
 I agree with both Bob and Ola.
 We have tried not quite yet succeeded in getting DHIS2 installed with
 Tomcat/Postgres on Windows with a one-click installer, this my caveat about
 a supervised install. There are a lot of things which can happen on users
 machines and maintenance becomes a huge issue. DHIS is still under intense
 development, and a lot of things change quickly. Upgrading a single server
 is a piece of cake. Upgrading dozens or hundreds of off-line machines is a
 true nightmare and a serious risk and resource drain to any deployment.
 I agree with Ola. Totally exclude an on-line server as an option first. If
 you have already done that, all I can say is, be prepared for a LOT of tech
 support.
 Regards,
 Jason
 
 On Thu, Aug 18, 2011 at 3:15 PM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:
 
 Olav,
 How offline are these districts? Can they not get connected through mobile
 usb modems/dongles? There is so much to gain from online deployment that I
 would check out every alternative of connectivity before deciding to go
 completely offline. The mobile Internet solution is working very well in
 Kenya. With the offline data entry capabilities in the upcoming 2.4, the
 districts do not have to be online during the data entry process, which is a
 major advantage in areas with poor/unstable connectivity.
 
 Further recommendations on deployment can be found in the implementation
 guide here:
 http://dhis2.org/doc/snapshot/en/implementer/html/ch04.html
 And a presentation on the same topic in the zip file with implementation
 guide slides here:
 http://dhis2.org/download/presentations/presentations.zip
 Ola
 ---
 
 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo
 
 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link
 
 
 On 18 August 2011 15:02, Jason Pickering jason.p.picker...@gmail.com
 wrote:
 
 One strong reason not to use it is the relative lack of testing. In
 theory, it should work, but just as with MySQL, much more testing has
 occurred with Postgres than with the other database systems.
 We have some beta-level Windows installers, which might be of interest to
 you, which work pretty well under supervised circumstances. It might be
 something to consider if you want a relatively automated install of the
 DHISLive/Postgresql stack, with automated restore of the database.
 Regards,
 Jason
 
 On Thu, Aug 18, 2011 at 2:48 PM, Olav Poppe olav.po...@gmail.com wrote:
 
 Hello,
 we're looking at what do to with offline installations for the
 implementation here in Ghana. Are there any reasons not to use DHIS Live?
 Can H2 be used (importing the metadata into an empty database), or should