Re: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer

[ifeanyiokoye]

  Hello Elmarie,The thing is, I'm not sure exactly where that setting is made for the analytics. If you could provide a clue, I can go and check to see if we have the wrong setting. You have been quite helpful. Thank you. Ifeanyi From: Elmarie ClaasenSent: Tuesday, 16 August 2016 21:25To: 'Ifeanyi Okoye'; 'Derek Kahongo Mukenge'Cc: dhis2-us...@lists.launchpad.net; 'Lars Helge Øverland'; 'DHIS 2 Developers list'Subject: RE: [Dhis2-devs] [Dhis2-users]  About filter in Data visualizerHi Ifeanyi, You should not set an aggregation start level then analytics will aggregate from the lowest level up. Only if you have set a start level to e.g. OU4 then it will only use values captured from OU4 and above to higher levels so that now does not seem like your problem.  I am sorry other than the allocation of orgunitgroups and whether you are filtering on groups or not I cant think of anything else that can cause it. Maybe someone else has some ideas.  Regards, Elmarie ClaasenProject ManagerHealth Information Systems ProgramTel:  041-367 1027Cell: 082 374 2209E-mail: elma...@hisp.orgSkype:  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: Ifeanyi Okoye [mailto:ifeanyiok...@yahoo.com] Sent: 16 August 2016 01:30 PMTo: Elmarie Claasen; 'Derek Kahongo Mukenge'Cc: dhis2-us...@lists.launchpad.net; 'Lars Helge Øverland'; 'DHIS 2 Developers list'Subject: Re: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer Hello Elmarie,Forgive me, but I am not sure where to set the aggregation start level. For the reports, what we have started to do is to select org units at levels (Comprehensive, Satellite, and Outreach) when we noted this issue. I do not know if this is a wrong method. But this is a big concern as we would not like to misrepresent the data. Thank you.  Warm Regards, IfeanyiRead DrMaestro's Blogwww.ifeanyiokoye.com From: Elmarie Claasen To: 'Ifeanyi Okoye' ; 'Derek Kahongo Mukenge'  Cc: dhis2-us...@lists.launchpad.net; 'Lars Helge Øverland' ; 'DHIS 2 Developers list' Sent: Monday, August 15, 2016 2:46 PMSubject: RE: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer Hi Ifeanyi, Did you perhaps define the aggregation start level for your data elements as OU4 or are you also filtering on orgunitgroups in the report which can cause the inconsistency in reports at different levels?   Regards, Elmarie ClaasenProject ManagerHealth Information Systems ProgramTel:  041-367 1027Cell: 082 374 2209E-mail: elma...@hisp.orgSkype:  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: Ifeanyi Okoye [mailto:ifeanyiok...@yahoo.com] Sent: 15 August 2016 02:38 PMTo: Derek Kahongo Mukenge; Elmarie ClaasenCc: dhis2-us...@lists.launchpad.net; Lars Helge Øverland; DHIS 2 Developers listSubject: Re: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer Hello Everyone,I had reported this a few weeks ago and did not get any response. We have data entered at OU4 (comprehensive sites), OU5 (satellite sites), and OU6 (outreach sites). When we do tables or charts and select the parent OU (OU1), the data displayed is for OU4 (comprehensive sites) alone. When I select the different levels, I get a different output. I have taken the time to compare the outputs from the tables and the data entry forms and I see that for some reason, DHIS isn't aggregating data below OU4 into the parent OU. Not 

Re: [Dhis2-devs] [Bug 1538443] Re: Metadata import of users fails

[ifeanyiokoye]

‎Hello Morten,

Would the upgrade to 2.23 allow me to do the import from the metadata import 
app or I would have to do it from the API?
If I had to do it from the API, is there step-by-step guidance on how to do 
this? I have to import 59 users and would I have to do that one after the other 
or as a batch?

Thank you. 

Regards,


Ifeanyi

  Original Message  
From: Morten Olav Hansen
Sent: Thursday, 23 June 2016 17:56
To: dhis2-devs@lists.launchpad.net
Reply To: Bug 1538443
Subject: Re: [Dhis2-devs] [Bug 1538443] Re: Metadata import of users fails

Hi

Are you able to update to 2.23? in 2.23 we have a new importer at the
/api/23/metadata endpoint which has much better support for (among other
types) users

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

On Thu, Jun 23, 2016 at 6:13 PM, Ifeanyi Okoye <1538...@bugs.launchpad.net>
wrote:

> Hello,
> I am trying to move data from one instance of DHIS2 (2.22) to another
> using metadata export and import. So far everything else has worked except
> for importing users. It just goes on indefinitely.
>
> Please see the logs below:
>
> * ERROR 2016-06-23 01:31:31,479 Unexpected error occurred in scheduled
> task. (TaskUtils.java [taskScheduler-2])
> org.hibernate.TransientObjectException: object references an unsaved
> transient instance - save the transient instance before flushing:
> org.hisp.dhis.user.User
> at
> org.hibernate.engine.internal.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:249)
> at org.hibernate.type.EntityType.getIdentifier(EntityType.java:536)
> at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:311)
> at org.hibernate.type.ManyToOneType.isDirty(ManyToOneType.java:321)
> at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:294)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:4049)
> at
> org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:537)
> at
> org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:235)
> at
> org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:164)
> at
> org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:230)
> at
> org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:100)
> at
> org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:61)
> at
> org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1166)
> at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1223)
> at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
> at
> org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909)
> at
> org.hisp.dhis.user.hibernate.HibernateUserCredentialsStore.getUserCredentialsByUsername(HibernateUserCredentialsStore.java:48)
> at
> org.hisp.dhis.user.DefaultUserService.getUserCredentialsByUsername(DefaultUserService.java:567)
> at sun.reflect.GeneratedMethodAccessor204.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:317)
> 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:281)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> at com.sun.proxy.$Proxy35.getUserCredentialsByUsername(Unknown
> Source)
> at
> org.hisp.dhis.user.DefaultCurrentUserService.getCurrentUser(DefaultCurrentUserService.java:92)
> at sun.reflect.GeneratedMethodAccessor161.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:317)
> at
> org.