date:20140911


revno: 16692
committer: Morten Olav Hansen morte...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-09-11 13:03:17 +0700
message:
  in typeSummary add new property lastImported, will always contain uid of last 
object created/updated. In posts in abstract crud controller use this to set 
location header if imported count is 1.
modified:
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/ImportTypeSummary.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/importers/DefaultIdentifiableObjectImporter.java
  
dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/webapi/controller/AbstractCrudController.java


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/ImportTypeSummary.java'
--- dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/ImportTypeSummary.java	2014-08-15 07:40:20 +
+++ dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/ImportTypeSummary.java	2014-09-11 06:03:17 +
@@ -43,7 +43,7 @@
 /**
  * @author Morten Olav Hansen morte...@gmail.com
  */
-@JacksonXmlRootElement(localName = typeSummary, namespace = DxfNamespaces.DXF_2_0)
+@JacksonXmlRootElement( localName = typeSummary, namespace = DxfNamespaces.DXF_2_0 )
 public class ImportTypeSummary
 extends ImportSummary
 {
@@ -53,13 +53,20 @@
 
 private ListImportConflict importConflicts = new ArrayList();
 
+/**
+ * This will always have the UID of the latest imported object. This is used for cases where you are only importing a single
+ * object, and want to return the Location header etc to the user. We might extend this in the future, so that we can get all
+ * UIDs of imported objects.
+ */
+private String lastImported;
+
 public ImportTypeSummary( String type )
 {
 this.type = type;
 }
 
 @JsonProperty
-@JacksonXmlProperty(isAttribute = true)
+@JacksonXmlProperty( isAttribute = true )
 public String getType()
 {
 return type;
@@ -71,7 +78,7 @@
 }
 
 @JsonProperty
-@JacksonXmlProperty(namespace = DxfNamespaces.DXF_2_0)
+@JacksonXmlProperty( namespace = DxfNamespaces.DXF_2_0 )
 public ImportCount getImportCount()
 {
 return importCount;
@@ -83,8 +90,8 @@
 }
 
 @JsonProperty
-@JacksonXmlElementWrapper(localName = conflicts, namespace = DxfNamespaces.DXF_2_0)
-@JacksonXmlProperty(localName = conflict, namespace = DxfNamespaces.DXF_2_0)
+@JacksonXmlElementWrapper( localName = conflicts, namespace = DxfNamespaces.DXF_2_0 )
+@JacksonXmlProperty( localName = conflict, namespace = DxfNamespaces.DXF_2_0 )
 public ListImportConflict getImportConflicts()
 {
 return importConflicts;
@@ -95,6 +102,18 @@
 this.importConflicts = importConflicts;
 }
 
+@JsonProperty
+@JacksonXmlProperty( namespace = DxfNamespaces.DXF_2_0 )
+public String getLastImported()
+{
+return lastImported;
+}
+
+public void setLastImported( String lastImported )
+{
+this.lastImported = lastImported;
+}
+
 //-
 // Helpers
 //-

=== modified file 'dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/importers/DefaultIdentifiableObjectImporter.java'
--- dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/importers/DefaultIdentifiableObjectImporter.java	2014-08-21 10:12:43 +
+++ dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/metadata/importers/DefaultIdentifiableObjectImporter.java	2014-09-11 06:03:17 +
@@ -649,6 +649,8 @@
 nonIdentifiableObjects.save( object );
 }
 
+summaryType.setLastImported( object.getUid() );
+
 log.debug( Save successful. );
 
 return true;
@@ -730,6 +732,8 @@
 nonIdentifiableObjects.save( persistedObject );
 }
 
+summaryType.setLastImported( object.getUid() );
+
 log.debug( Update successful. );
 
 return true;

=== modified file 'dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/webapi/controller/AbstractCrudController.java'
--- dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/webapi/controller/AbstractCrudController.java	2014-09-11 05:40:24 +
+++ dhis-2/dhis-web/dhis-web-api/src/main/java/org/hisp/dhis/webapi/controller/AbstractCrudController.java	2014-09-11 06:03:17 +
@@ -335,6 +335,12 @@
 if (

[Dhis2-devs] XML ou CSV Importation de métadonnées

2014-09-11 Thread Assetta BARA

Salut chers tous,
l'importation des métadonnées n'est pas stable j'ai installé dhis2 en local 
(2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi) avec succès. 
Mais à chaque fois, que je me déconnecte de ma base en local et me reconnecte, 
pas de métadonnées!!! Existe t-il une méthode de conserver ses variables 
importées? Merci de votre aide.
Assetta
DHIS2-Burkina___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Data elements, categories, category options not getting translated on Data Visualizer

2014-09-11 Thread Mansi Singhal

Thanks Lars

On Wed, Sep 10, 2014 at 6:25 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Hi Mansi,

 apologies but we have not yet implemented internationalization in the web
 api. Blueprint here:

 https://blueprints.launchpad.net/dhis2/+spec/i18n-in-web-api

 regards,

 Lars


 On Wed, Sep 10, 2014 at 5:14 AM, Mansi Singhal msing...@thoughtworks.com
 wrote:

 Hello,

 We logged in as french user and went to data visualizer page. It seems
 that Data elements, categories, category options are always coming in
 English even if we have translations for all of them.

 It should rather show the translated version.

 Is this a bug?

 --
 Regards,
 Mansi Singhal





-- 
Regards,
Mansi Singhal
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 16693: remove getByUser for dashboard / chart services (not in use), also remove from generic stores. Up...


revno: 16693
committer: Morten Olav Hansen morte...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-09-11 13:39:30 +0700
message:
  remove getByUser for dashboard / chart services (not in use), also remove 
from generic stores. Update getByDataDimension to use sharing criteria.
modified:
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/chart/ChartService.java
  
dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/GenericIdentifiableObjectStore.java
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/dashboard/DashboardService.java
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntity.java
  
dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/common/hibernate/HibernateIdentifiableObjectStore.java
  
dhis-2/dhis-services/dhis-service-reporting/src/main/java/org/hisp/dhis/chart/impl/DefaultChartService.java
  
dhis-2/dhis-services/dhis-service-reporting/src/main/java/org/hisp/dhis/dashboard/impl/DefaultDashboardService.java


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/chart/ChartService.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/chart/ChartService.java	2014-07-12 14:18:34 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/chart/ChartService.java	2014-09-11 06:39:30 +
@@ -112,8 +112,6 @@
 
 int getChartCountByName( String name );
 
-CollectionChart getChartsByUser( User user );
-
 int countDataSetCharts( DataSet dataSet );
 
 int countIndicatorCharts( Indicator indicator );

=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/GenericIdentifiableObjectStore.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/GenericIdentifiableObjectStore.java	2014-09-09 07:32:11 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/GenericIdentifiableObjectStore.java	2014-09-11 06:39:30 +
@@ -28,8 +28,6 @@
  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  */
 
-import org.hisp.dhis.user.User;
-
 import java.util.Collection;
 import java.util.Date;
 import java.util.List;
@@ -215,8 +213,6 @@
  */
 ListT getByUidNoAcl( CollectionString uids );
 
-int getCountGeCreated( Date created );
-
 /**
  * Returns all objects that are equal to or newer than given date.
  *
@@ -237,7 +233,7 @@
  * Returns all objects that are equal to or newer than given date.
  * (ordered by name)
  *
- * @param lastUpdated Date to compare to.
+ * @param created Date to compare to.
  * @return All objects equal or newer than given date.
  */
 ListT getAllGeCreatedOrderedName( Date created );
@@ -252,7 +248,7 @@
 ListT getAllGeLastUpdatedOrderedName( Date lastUpdated );
 
 /**
- * Returns the number of objects that are equal to or newer than given date.
+ * Returns the number of objects that are equal to or newer than given last updated date.
  *
  * @param lastUpdated Date to compare to.
  * @return the number of objects equal or newer than given date.
@@ -260,10 +256,10 @@
 int getCountGeLastUpdated( Date lastUpdated );
 
 /**
- * Retrieves objects associated with the given user.
+ * Returns the number of objects that are equal to or newer than given created date.
  *
- * @param user the user.
- * @return list of objects.
+ * @param created Date to compare to.
+ * @return the number of objects equal or newer than given date.
  */
-ListT getByUser( User user );
+int getCountGeCreated( Date created );
 }

=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/dashboard/DashboardService.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/dashboard/DashboardService.java	2014-03-18 08:10:10 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/dashboard/DashboardService.java	2014-09-11 06:39:30 +
@@ -65,8 +65,6 @@
 
 Dashboard getDashboard( String uid );
 
-ListDashboard getByUser( User user );
-
 int countMapDashboardItems( Map map );
 
 int countChartDashboardItems( Chart chart );

=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntity.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntity.java	2014-05-23 14:58:07 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/trackedentity/TrackedEntity.java	2014-09-11 06:39:30 +
@@ -35,7 +35,7 @@
 /**
  * @author Chau Thu Tran
  */
-@JacksonXmlRootElement(localName = trackedEntity, namespace = DxfNamespaces.DXF_2_0)
+@JacksonXmlRootElement( localName = trackedEntity, namespace = DxfNamespaces.DXF_2_0 )
 public class TrackedEntity
 extends BaseNameableObject
 {

=== modified file

Re: [Dhis2-devs] [Dhis2-users] Dataset report not showing proper breakdown.

2014-09-11 Thread Kiran Prakash

Hello,

I did a little debugging and figure that this might be because the
analytics query is failing with following error.

StatementCallback; bad SQL grammar [select
de,weekly,uidlevel3,a99ecb2c5c3, sum(value) as value from
analytics_2014 where de in ('a0ea1b1d113') and weekly in ('2014W2') and
uidlevel3 in ('a42405657c4') and a99ecb2c5c3 in ('abacfb5842a',
'a5dd89a503f') and ( (uidlevel1 = 'a2cf79e8f13' and approvallevel = 999) )
group by de,weekly,uidlevel3,a99ecb2c5c3]; nested exception is
org.postgresql.util.PSQLException: ERROR: column a99ecb2c5c3 does not
exist
  Position: 34
at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
at
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:366)
at
org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:140)
at sun.reflect.GeneratedMethodAccessor876.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: column a99ecb2c5c3
does not exist
  Position: 34
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
... 13 more
* INFO  2014-09-11 12:05:20,742 Query failed, likely because the requested
analytics table does not exist (JdbcAnalyticsManager.java
[SimpleAsyncTaskExecutor-921])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [select de,weekly,uidlevel3,a99ecb2c5c3, sum(value) as
value from analytics_2014 where de in ('aee83d48c4c') and weekly in
('2014W2') and uidlevel3 in ('a42405657c4') and a99ecb2c5c3 in
('abacfb5842a', 'a5dd89a503f') and ( (uidlevel1 = 'a2cf79e8f13' and
approvallevel = 999) ) group by de,weekly,uidlevel3,a99ecb2c5c3];
nested exception is org.postgresql.util.PSQLException: ERROR: column
a99ecb2c5c3 does not exist
  Position: 34


I have checked the database, and the table analytics_2014 exists.

I think this is because the generate sql seems wrong.

uidlevel3 in ('a42405657c4') and a99ecb2c5c3

should this be uidlevel3 in ('a42405657c4', a99ecb2c5c3)? or something
else?

Are you guys aware of this issue and if it's fixed in trunk, what revision?

We're very close to release, so cannot afford to merge with trunk. Any help
pointing out the fix/ revision number will be of great help

Thanks in advance

Kiran.

On Wed, Sep 10, 2014 at 1:23 PM, Mahendra Kariya 
mahendra.kar...@thoughtworks.com wrote:

 Hi Lars/Morten,

 It would be really helpful if you guys could point us to where we can look
 for if something is going wrong.

 On Tue, Sep 9, 2014 at 10:59 AM, Kiran Prakash kprak...@thoughtworks.com
 wrote:

 Hello Lars,

 any insight into this? this is holding up one of our stories. really
 appreciate if you can have a look in

 thanks

 Kiran

 On Mon, Sep 8, 2014 at 10:30 PM, Mahendra Kariya

Re: [Dhis2-devs] [Dhis2-users] dhis 2.16 upgrade notes

Thanks Jason and Ngoc Thanh!

I followed you instruction

   - remove old war file and its contents from  webapps directory
   - upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log file
does not show any error massage  . Here is my log screen shot is same as
previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Hi Sumudu,

 I looked through your log, and it looks like you are using an older build
 of 2.16 which is subject to a potentially very serious security flaw. This
 issue was disclosed on the DHIS2 developer  and user list last week out
 last week and a fix has been committed by the developers. You would be well
 advised to upgrade to the latest version of 2.16, available here (
 https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
 ).

 It is a bit hard to say from the logs what might be going on, because it
 is only a quite short snippet. I suggest you shutdown Tomcat, remove the
 old dhis.war file and all the contents of the /dhis directory (or whatever
 you might be calling it), download the updated 2.16 war file as mentioned
 above, restart Tomcat, and then post the logs of where things go wrong.

 Best regards,
 Jason




 On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe sumudu...@gmail.com
 wrote:

 Hi Lars and all,
 I used dhis 2.15 for our mental health information system, which contain
 both tracker and aggregate parts. I try to upgrade my instance to 2.16 from
 2.15. Above mention things has been automatically happened , but there is a
 error

1.  2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

 Can anyone advise regarding upgrading in to 2.16 ?
 Detail of log file and screen shot attach here.
 I am using
 *Version: 2.16**Build revision:16410**Database type:MySQL*
 *Java version:1.7.0_04**OS name:Windows 7*
 Regards
 Sumudu


 On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland larshe...@gmail.com
  wrote:

 Hi,

 a note on how to upgrade to dhis version 2.16:

 The following changes *require* *action* on the implementer's side.

- From data administration  scheduling, scheduling should be
deactivated, set according to your needs and finally activated.
- A property encryption.password should be added to
hibernate.properties file if you plan to use the data synchronization
feature, see the docs

 https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
.

 The following database changes require *no action* and will happen
 automatically when running the new WAR file the first time.

- Column completed of table programstageinstance has been
removed and is replaced by the existing status column.
- The values in column domaintype of table dataelement have been
migrated from aggregate to AGGREGATE and from patient to TRACKER.
- A column lastupdated will be added to table datavalue, this
might take some time when starting up the system for the first time.

 This information can also be found here:

 https://www.dhis2.org/2.16-upgrade

 We encourage people to upgrade their instances, test the new features
 and provide feedback.

 best regards,

 Lars


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp



 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-devs@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp




 --
 Jason P. Pickering
 email: jason.p.picker...@gmail.com
 tel:+46764147049

Sep 11, 2014 11:41:14 AM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version 1.4
.8.
Sep 11, 2014 11:41:14 AM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], ra
ndom [true].
Sep 11, 2014 11:41:16 AM org.apache.catalina.core.AprLifecycleListener initializ
eSSL
INFO: OpenSSL successfully initialized (OpenSSL 1.0.1e 11 Feb 2013)
Sep 11, 2014 11:41:17 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [http-apr-8084]
Sep 11, 2014 11:41:17 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [ajp-apr-8009]
Sep 11, 2014 11:41:17 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3706 ms
Sep 11, 2014 11:41:17 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Sep 11, 2014 11:41:17 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.50
Sep 11, 2014

Re: [Dhis2-devs] [Dhis2-users] dhis 2.16 upgrade notes

2014-09-11 Thread Morten Olav Hansen

Can you open the web inspector with F12, and give use any output there?

--
Morten

On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Thanks Jason and Ngoc Thanh!

I followed you instruction

- remove old war file and its contents from webapps directory
- upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log file
does not show any error massage . Here is my log screen shot is same as
previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering
jason.p.picker...@gmail.com wrote:

Hi Sumudu,

I looked through your log, and it looks like you are using an older build
of 2.16 which is subject to a potentially very serious security flaw. This
issue was disclosed on the DHIS2 developer and user list last week out
last week and a fix has been committed by the developers. You would be well
advised to upgrade to the latest version of 2.16, available here (
https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
).

It is a bit hard to say from the logs what might be going on, because it
is only a quite short snippet. I suggest you shutdown Tomcat, remove the
old dhis.war file and all the contents of the /dhis directory (or whatever
you might be calling it), download the updated 2.16 war file as mentioned
above, restart Tomcat, and then post the logs of where things go wrong.

Best regards,
Jason

On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Hi Lars and all,
I used dhis 2.15 for our mental health information system, which contain
both tracker and aggregate parts. I try to upgrade my instance to 2.16 from
2.15. Above mention things has been automatically happened , but there is a
error

1. 2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

Can anyone advise regarding upgrading in to 2.16 ?
Detail of log file and screen shot attach here.
I am using
*Version: 2.16**Build revision:16410**Database type:MySQL*
*Java version:1.7.0_04**OS name:Windows 7*
Regards
Sumudu

On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland
larshe...@gmail.com wrote:

Hi,

a note on how to upgrade to dhis version 2.16:

The following changes *require* *action* on the implementer's side.

- From data administration scheduling, scheduling should be
deactivated, set according to your needs and finally activated.
- A property encryption.password should be added to
hibernate.properties file if you plan to use the data synchronization
feature, see the docs

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
.

The following database changes require *no action* and will happen
automatically when running the new WAR file the first time.

- Column completed of table programstageinstance has been
removed and is replaced by the existing status column.
- The values in column domaintype of table dataelement have
been migrated from aggregate to AGGREGATE and from patient to
TRACKER.
- A column lastupdated will be added to table datavalue, this
might take some time when starting up the system for the first time.

This information can also be found here:

https://www.dhis2.org/2.16-upgrade

We encourage people to upgrade their instances, test the new features
and provide feedback.

best regards,

Lars

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] dhis 2.16 upgrade notes

2014-09-11 Thread Morten Olav Hansen

This looks like caching related issues, please try to either clear out
everything or run it in a incognito window.

--
Morten

On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Screenshots are attached here. I am not sure whether your are expecting
this or some thing else.

Sumudu

On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen morte...@gmail.com
wrote:

Can you open the web inspector with F12, and give use any output there?

--
Morten

On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Thanks Jason and Ngoc Thanh!

I followed you instruction

- remove old war file and its contents from webapps directory
- upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log file
does not show any error massage . Here is my log screen shot is same as
previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering
jason.p.picker...@gmail.com wrote:

Hi Sumudu,

I looked through your log, and it looks like you are using an older
build of 2.16 which is subject to a potentially very serious security flaw.
This issue was disclosed on the DHIS2 developer and user list last week
out last week and a fix has been committed by the developers. You would be
well advised to upgrade to the latest version of 2.16, available here (
https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
).

It is a bit hard to say from the logs what might be going on, because
it is only a quite short snippet. I suggest you shutdown Tomcat, remove the
old dhis.war file and all the contents of the /dhis directory (or whatever
you might be calling it), download the updated 2.16 war file as mentioned
above, restart Tomcat, and then post the logs of where things go wrong.

Best regards,
Jason

On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe
sumudu...@gmail.com wrote:

Hi Lars and all,
I used dhis 2.15 for our mental health information system, which
contain both tracker and aggregate parts. I try to upgrade my instance to
2.16 from 2.15. Above mention things has been automatically happened , but
there is a error

1. 2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland
larshe...@gmail.com wrote:

Hi,

a note on how to upgrade to dhis version 2.16:

The following changes *require* *action* on the implementer's side.

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
.

The following database changes require *no action* and will happen
automatically when running the new WAR file the first time.

This information can also be found here:

https://www.dhis2.org/2.16-upgrade

We encourage people to upgrade their instances, test the new features
and provide feedback.

best regards,

Lars

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens

Thanks a lot, Jason. I'll consider filing a blueprint for this.

Regards,

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 10 September 2014 17:55
To: Robin Martens
Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net; dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
It has been a discussed, and certainly not a bug. See a related thread here 
(https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion 
on validation rules. It is essentially the same as indicators. What you will 
have to do is to create seperate indicator for each and every combination which 
you need. It can be painful, but the only way really which I know at the moment.

Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2

Regards,
Jason

On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens 
mart...@sher.bemailto:mart...@sher.be wrote:
Dear all,

I've been testing the indicator calculation algorithm and noticed something 
particular of which I'm not sure if it's a bug or a deliberate development 
choice.

Indicators are not explicitly defined per category such as data elements but 
the reporting tools allow a disaggregated indicator calculation, which is 
definitely very useful. In a specific example, I want to know how many people 
were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I 
have two data elements: the total population and the national vaccination 
levels (in %), with a custom category vaccination type which can be A, B, or 
C.

My indicator would be total population x national vaccination level 
(total). That works fine when put in a pivot table.

However, when trying to disaggregate the indicator calculation by adding my 
custom category to the pivot table, I don't have any values anymore. It seems 
the reason is that the total population data element does not have the 
vaccination type category (which seems logical) and therefore isn't found by 
the calculation algorithm. As a result, my table is empty. It seems useful that 
the algorithm would take the aggregated value (for population) available in 
such cases.

Another example is over the period dimension: my population is a yearly value, 
so when calculating an indicator on a monthly basis, instead of taking the 
available yearly value, he takes zero.

So my question: is this a deliberate choice in the development, a bug, or an 
idea for a future system improvement?

Kind regards,

Robin

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

--
Jason P. Pickering
email: jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] dhis 2.16 upgrade notes

Thanks Morten,
I clear all in my chrome browser but is not working. I try it with Firefox
and it *works well*, thanks, i think it may be problem with my browser.

Sumudu

On Thu, Sep 11, 2014 at 1:37 PM, Morten Olav Hansen morte...@gmail.com
wrote:

This looks like caching related issues, please try to either clear out
everything or run it in a incognito window.

--
Morten

On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Screenshots are attached here. I am not sure whether your are expecting
this or some thing else.

Sumudu

On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen morte...@gmail.com
wrote:

Can you open the web inspector with F12, and give use any output there?

--
Morten

On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Thanks Jason and Ngoc Thanh!

I followed you instruction

- remove old war file and its contents from webapps directory
- upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log file
does not show any error massage . Here is my log screen shot is same as
previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering
jason.p.picker...@gmail.com wrote:

Hi Sumudu,

I looked through your log, and it looks like you are using an older
build of 2.16 which is subject to a potentially very serious security
flaw.
This issue was disclosed on the DHIS2 developer and user list last week
out last week and a fix has been committed by the developers. You would be
well advised to upgrade to the latest version of 2.16, available here (
https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
).

It is a bit hard to say from the logs what might be going on, because
it is only a quite short snippet. I suggest you shutdown Tomcat, remove
the
old dhis.war file and all the contents of the /dhis directory (or whatever
you might be calling it), download the updated 2.16 war file as mentioned
above, restart Tomcat, and then post the logs of where things go wrong.

Best regards,
Jason

On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe
sumudu...@gmail.com wrote:

Hi Lars and all,
I used dhis 2.15 for our mental health information system, which
contain both tracker and aggregate parts. I try to upgrade my instance to
2.16 from 2.15. Above mention things has been automatically happened ,
but
there is a error

1. 2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland
larshe...@gmail.com wrote:

Hi,

a note on how to upgrade to dhis version 2.16:

The following changes *require* *action* on the implementer's side.

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
.

The following database changes require *no action* and will happen
automatically when running the new WAR file the first time.

- Column completed of table programstageinstance has been
removed and is replaced by the existing status column.
- The values in column domaintype of table dataelement have
been migrated from aggregate to AGGREGATE and from patient to
TRACKER.
- A column lastupdated will be added to table datavalue,
this might take some time when starting up the system for the first
time.

This information can also be found here:

https://www.dhis2.org/2.16-upgrade

We encourage people to upgrade their instances, test the new
features and provide feedback.

best regards,

Lars

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help :

[Dhis2-devs] Migration of the documentation to GitHub

Hi Everyone,

The documentation for DHIS2 has been moved to GitHub from Launchpad. The
major reason for this was to allow for more modularity of the
documentation, as well as to take advantages of the features of git as a
version control system. Everything is available here

https://github.com/dhis2/dhis2docs

If you are interested in continuing to contribute to the documents, please
let me know, and I can add you to the list of contributors for the
documents. For the developers, please take note to commit your
documentation changes to GitHub instead of Launchpad! We will keep the
Launchpad branch up a while longer in case there are some more commits
there, but eventually it will be abandoned.

Let me know if you have any questions or problems regarding the change.

Best regards,
Jason


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-documenters] Migration of the documentation to GitHub

2014-09-11 Thread riddy ndoma

Good idea.
I'm glad to see DHIS2 migrated to Github! better versioning system in my
opinion!

2014-09-11 11:20 GMT+01:00 Jason Pickering jason.p.picker...@gmail.com:

 Hi Everyone,

 The documentation for DHIS2 has been moved to GitHub from Launchpad. The
 major reason for this was to allow for more modularity of the
 documentation, as well as to take advantages of the features of git as a
 version control system. Everything is available here

 https://github.com/dhis2/dhis2docs

 If you are interested in continuing to contribute to the documents, please
 let me know, and I can add you to the list of contributors for the
 documents. For the developers, please take note to commit your
 documentation changes to GitHub instead of Launchpad! We will keep the
 Launchpad branch up a while longer in case there are some more commits
 there, but eventually it will be abandoned.

 Let me know if you have any questions or problems regarding the change.

 Best regards,
 Jason


 --
 Jason P. Pickering
 email: jason.p.picker...@gmail.com


 ___
 Mailing list: https://launchpad.net/~dhis2-documenters
 Post to : dhis2-document...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-documenters
 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)
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-documenters] Migration of the documentation to GitHub

Hi Riddy,
Just to be clear, we have not yet migrated dhis2 to github, *only the
documentation* at this point, but it is being considered.

Best regards,
Jason




On Thu, Sep 11, 2014 at 12:22 PM, riddy ndoma riddynd...@gmail.com wrote:

 Good idea.
 I'm glad to see DHIS2 migrated to Github! better versioning system in my
 opinion!

 2014-09-11 11:20 GMT+01:00 Jason Pickering jason.p.picker...@gmail.com:

 Hi Everyone,

 The documentation for DHIS2 has been moved to GitHub from Launchpad. The
 major reason for this was to allow for more modularity of the
 documentation, as well as to take advantages of the features of git as a
 version control system. Everything is available here

 https://github.com/dhis2/dhis2docs

 If you are interested in continuing to contribute to the documents,
 please let me know, and I can add you to the list of contributors for the
 documents. For the developers, please take note to commit your
 documentation changes to GitHub instead of Launchpad! We will keep the
 Launchpad branch up a while longer in case there are some more commits
 there, but eventually it will be abandoned.

 Let me know if you have any questions or problems regarding the change.

 Best regards,
 Jason


 --
 Jason P. Pickering
 email: jason.p.picker...@gmail.com


 ___
 Mailing list: https://launchpad.net/~dhis2-documenters
 Post to : dhis2-document...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-documenters
 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)




-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-documenters] Migration of the documentation to GitHub

2014-09-11 Thread riddy ndoma

Yes Jason,I read !!

2014-09-11 11:24 GMT+01:00 Jason Pickering jason.p.picker...@gmail.com:

 Hi Riddy,
 Just to be clear, we have not yet migrated dhis2 to github, *only the
 documentation* at this point, but it is being considered.

 Best regards,
 Jason




 On Thu, Sep 11, 2014 at 12:22 PM, riddy ndoma riddynd...@gmail.com
 wrote:

 Good idea.
 I'm glad to see DHIS2 migrated to Github! better versioning system in my
 opinion!

 2014-09-11 11:20 GMT+01:00 Jason Pickering jason.p.picker...@gmail.com:

 Hi Everyone,

 The documentation for DHIS2 has been moved to GitHub from Launchpad. The
 major reason for this was to allow for more modularity of the
 documentation, as well as to take advantages of the features of git as a
 version control system. Everything is available here

 https://github.com/dhis2/dhis2docs

 If you are interested in continuing to contribute to the documents,
 please let me know, and I can add you to the list of contributors for the
 documents. For the developers, please take note to commit your
 documentation changes to GitHub instead of Launchpad! We will keep the
 Launchpad branch up a while longer in case there are some more commits
 there, but eventually it will be abandoned.

 Let me know if you have any questions or problems regarding the change.

 Best regards,
 Jason


 --
 Jason P. Pickering
 email: jason.p.picker...@gmail.com


 ___
 Mailing list: https://launchpad.net/~dhis2-documenters
 Post to : dhis2-document...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-documenters
 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)




 --
 Jason P. Pickering
 email: jason.p.picker...@gmail.com
 tel:+46764147049




-- 
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-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] dhis 2.16 upgrade notes

2014-09-11 Thread Knut Staring

What if you try an Incognito window in Chrome (Ctrl+Shift+N)?

Knut

On Thu, Sep 11, 2014 at 12:08 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Thanks Morten,
I clear all in my chrome browser but is not working. I try it with
Firefox and it *works well*, thanks, i think it may be problem with my
browser.

Sumudu

On Thu, Sep 11, 2014 at 1:37 PM, Morten Olav Hansen morte...@gmail.com
wrote:

This looks like caching related issues, please try to either clear out
everything or run it in a incognito window.

--
Morten

On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Screenshots are attached here. I am not sure whether your are expecting
this or some thing else.

Sumudu

On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen morte...@gmail.com
wrote:

Can you open the web inspector with F12, and give use any output there?

--
Morten

On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe
sumudu...@gmail.com wrote:

Thanks Jason and Ngoc Thanh!

I followed you instruction

- remove old war file and its contents from webapps directory
- upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log
file does not show any error massage . Here is my log screen shot is same
as previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering
jason.p.picker...@gmail.com wrote:

Hi Sumudu,

I looked through your log, and it looks like you are using an older
build of 2.16 which is subject to a potentially very serious security
flaw.
This issue was disclosed on the DHIS2 developer and user list last week
out last week and a fix has been committed by the developers. You would
be
well advised to upgrade to the latest version of 2.16, available here (
https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
).

It is a bit hard to say from the logs what might be going on, because
it is only a quite short snippet. I suggest you shutdown Tomcat, remove
the
old dhis.war file and all the contents of the /dhis directory (or
whatever
you might be calling it), download the updated 2.16 war file as mentioned
above, restart Tomcat, and then post the logs of where things go wrong.

Best regards,
Jason

On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe
sumudu...@gmail.com wrote:

Hi Lars and all,
I used dhis 2.15 for our mental health information system, which
contain both tracker and aggregate parts. I try to upgrade my instance
to
2.16 from 2.15. Above mention things has been automatically happened ,
but
there is a error

1. 2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland
larshe...@gmail.com wrote:

Hi,

a note on how to upgrade to dhis version 2.16:

The following changes *require* *action* on the implementer's side.

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
.

The following database changes require *no action* and will happen
automatically when running the new WAR file the first time.

- Column completed of table programstageinstance has been
removed and is replaced by the existing status column.
- The values in column domaintype of table dataelement have
been migrated from aggregate to AGGREGATE and from patient to
TRACKER.
- A column lastupdated will be added to table datavalue,
this might take some time when starting up the system for the first
time.

This information can also be found here:

https://www.dhis2.org/2.16-upgrade

We encourage people to upgrade their instances, test the new
features and provide feedback.

best regards,

Lars

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049

___
Mailing list:

Re: [Dhis2-devs] [Dhis2-users] dhis 2.16 upgrade notes

Thanks!. yes it is working in new incognito window .

Sumudu

On Thu, Sep 11, 2014 at 4:05 PM, Knut Staring knu...@gmail.com wrote:

What if you try an Incognito window in Chrome (Ctrl+Shift+N)?

Knut

On Thu, Sep 11, 2014 at 12:08 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Thanks Morten,
I clear all in my chrome browser but is not working. I try it with
Firefox and it *works well*, thanks, i think it may be problem with my
browser.

Sumudu

On Thu, Sep 11, 2014 at 1:37 PM, Morten Olav Hansen morte...@gmail.com
wrote:

This looks like caching related issues, please try to either clear out
everything or run it in a incognito window.

--
Morten

On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe sumudu...@gmail.com
wrote:

Screenshots are attached here. I am not sure whether your are
expecting this or some thing else.

Sumudu

On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen
morte...@gmail.com wrote:

Can you open the web inspector with F12, and give use any output there?

--
Morten

On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe
sumudu...@gmail.com wrote:

Thanks Jason and Ngoc Thanh!

I followed you instruction

- remove old war file and its contents from webapps directory
- upgrade with new war file (build revision 16414)

But it is still unable to open a data entry form, in this time log
file does not show any error massage . Here is my log screen shot is
same
as previous.

Sumudu

On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering
jason.p.picker...@gmail.com wrote:

Hi Sumudu,

I looked through your log, and it looks like you are using an older
build of 2.16 which is subject to a potentially very serious security
flaw.
This issue was disclosed on the DHIS2 developer and user list last week
out last week and a fix has been committed by the developers. You would
be
well advised to upgrade to the latest version of 2.16, available here (
https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
).

It is a bit hard to say from the logs what might be going on,
because it is only a quite short snippet. I suggest you shutdown Tomcat,
remove the old dhis.war file and all the contents of the /dhis directory
(or whatever you might be calling it), download the updated 2.16 war
file
as mentioned above, restart Tomcat, and then post the logs of where
things
go wrong.

Best regards,
Jason

On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe
sumudu...@gmail.com wrote:

Hi Lars and all,
I used dhis 2.15 for our mental health information system, which
contain both tracker and aggregate parts. I try to upgrade my instance
to
2.16 from 2.15. Above mention things has been automatically happened ,
but
there is a error

1. 2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland
larshe...@gmail.com wrote:

Hi,

a note on how to upgrade to dhis version 2.16:

The following changes *require* *action* on the implementer's
side.

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
.

The following database changes require *no action* and will
happen automatically when running the new WAR file the first time.

- Column completed of table programstageinstance has been
removed and is replaced by the existing status column.
- The values in column domaintype of table dataelement
have been migrated from aggregate to AGGREGATE and from
patient to
TRACKER.
- A column lastupdated will be added to table datavalue,
this might take some time when starting up the system for the
first time.

This information can also be found here:

https://www.dhis2.org/2.16-upgrade

We encourage people to upgrade their instances, test the new
features and provide feedback.

best regards,

Lars

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1368191] [NEW] Attributes and Data Entry form not loading in Tracker Capture

2014-09-11 Thread Adebusoye Anifalaje

Public bug reported:

Hi Devs,

I am having issues loading attributes for a defined program. The program
assigned to the org unit shows but when I select Register only the
Report Date comes up. There are no errors in the log but the Console
output is below:

TypeError: Cannot read property 'id' of undefined
at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:437:62
at Array.forEach (native)
at Object.forEach 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:322:11)
at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:436:25
at wrappedCallback 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11046:81)
at 
https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11132:26
at Scope.$eval 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12075:28)
at Scope.$digest 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11903:31)
at Scope.$apply 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12179:24)
at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:417:36 
angular.js:9509(anonymous function) angular.js:9509(anonymous function) 
angular.js:6950wrappedCallback angular.js:11049(anonymous function) 
angular.js:11132Scope.$eval angular.js:12075Scope.$digest 
angular.js:11903Scope.$apply angular.js:12179(anonymous function) 
services.js:417forEach angular.js:322(anonymous function) services.js:411k 
jquery.min.js:2l.fireWith jquery.min.js:2request.onsuccess 
dhis2.storage.idb.js:264

The problem seems to be here:

angular.forEach(program.programTrackedEntityAttributes, function(pAttribute){
var att = attributes[pAttribute.attribute.id];
att.mandatory = pAttribute.mandatory;
if(pAttribute.displayInList){
att.displayInListNoProgram = true; 

I am using Version:
2.16
Build revision:
16410

Many thanks.

Kind regards,
Busoye

** Affects: dhis2
 Importance: Undecided
 Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1368191

Title:
  Attributes and Data Entry form not loading in Tracker Capture

Status in DHIS 2:
  New

Bug description:
  Hi Devs,

  I am having issues loading attributes for a defined program. The
  program assigned to the org unit shows but when I select Register only
  the Report Date comes up. There are no errors in the log but the
  Console output is below:

  TypeError: Cannot read property 'id' of undefined
  at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:437:62
  at Array.forEach (native)
  at Object.forEach 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:322:11)
  at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:436:25
  at wrappedCallback 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11046:81)
  at 
https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11132:26
  at Scope.$eval 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12075:28)
  at Scope.$digest 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11903:31)
  at Scope.$apply 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12179:24)
  at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:417:36 
angular.js:9509(anonymous function) angular.js:9509(anonymous function) 
angular.js:6950wrappedCallback angular.js:11049(anonymous function) 
angular.js:11132Scope.$eval angular.js:12075Scope.$digest 
angular.js:11903Scope.$apply angular.js:12179(anonymous function) 
services.js:417forEach angular.js:322(anonymous function) services.js:411k 
jquery.min.js:2l.fireWith jquery.min.js:2request.onsuccess 
dhis2.storage.idb.js:264

  The problem seems to be here:

  angular.forEach(program.programTrackedEntityAttributes, function(pAttribute){
  var att = attributes[pAttribute.attribute.id];
  att.mandatory = pAttribute.mandatory;
  if(pAttribute.displayInList){
  att.displayInListNoProgram = true; 

  I am using Version:
  2.16
  Build revision:
  16410

  Many thanks.

  Kind regards,
  Busoye

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1368191/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] XML ou CSV Importation de métadonnées

2014-09-11 Thread Jørn Braa

Bonjour Assetta, en franglish:

what exactly do you mean by (c'est quoi exactement)  'déconnecte de ma
base en local et me reconnecte', c'est redémarrage? /are you
restarting the DHIS?

Also make sure you have (il faut avoir) hibernate.hbm2ddl.auto =
update in your hibernate.properties file.

Et il faut avoir hibernate.properties file - sinon, les  métadonnées
importées ne marche que en 'runtime' et rien est conservée,

Do you have hibernate.properties file? Please see
https://www.dhis2.org/development for some guides

jørn

2014-09-11 8:20 GMT+02:00 Assetta BARA assetta.b...@ymail.com:
 Salut chers tous,
 l'importation des métadonnées n'est pas stable j'ai installé dhis2 en
 local (2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi)
 avec succès. Mais à chaque fois, que je me déconnecte de ma base en local et
 me reconnecte, pas de métadonnées!!! Existe t-il une méthode de conserver
 ses variables importées? Merci de votre aide.
 Assetta
 DHIS2-Burkina

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] XML ou CSV Importation de métadonnées

2014-09-11 Thread Olav Poppe

Bonjour Asetta, 
comme Jørn a suggère, c’est peut-être une problème avec le 
hibernate.properties.Veuillez vérifier «Nom de la base de données» sous «À 
propos DHIS 2» dans ton base de données locale. 

Olav



11. sep. 2014 kl. 14:20 skrev Jørn Braa jornb...@gmail.com:

 Bonjour Assetta, en franglish:
 
 what exactly do you mean by (c'est quoi exactement)  'déconnecte de ma
 base en local et me reconnecte', c'est redémarrage? /are you
 restarting the DHIS?
 
 Also make sure you have (il faut avoir) hibernate.hbm2ddl.auto =
 update in your hibernate.properties file.
 
 Et il faut avoir hibernate.properties file - sinon, les  métadonnées
 importées ne marche que en 'runtime' et rien est conservée,
 
 Do you have hibernate.properties file? Please see
 https://www.dhis2.org/development for some guides
 
 jørn
 
 2014-09-11 8:20 GMT+02:00 Assetta BARA assetta.b...@ymail.com:
 Salut chers tous,
 l'importation des métadonnées n'est pas stable j'ai installé dhis2 en
 local (2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi)
 avec succès. Mais à chaque fois, que je me déconnecte de ma base en local et
 me reconnecte, pas de métadonnées!!! Existe t-il une méthode de conserver
 ses variables importées? Merci de votre aide.
 Assetta
 DHIS2-Burkina
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@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-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 16695: sync calls to addorgunit for ouwt, save old ouwt selected on update user load


revno: 16695
committer: Morten Olav Hansen morte...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-09-11 19:33:22 +0700
message:
  sync calls to addorgunit for ouwt, save old ouwt selected on update user load
modified:
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/ouwt/ouwt.js
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-user/src/main/java/org/hisp/dhis/user/action/UpdateUserAction.java
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-user/src/main/webapp/dhis-web-maintenance-user/updateUserForm.vm


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/ouwt/ouwt.js'
--- dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/ouwt/ouwt.js	2014-07-01 08:23:39 +
+++ dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/ouwt/ouwt.js	2014-09-11 12:33:22 +
@@ -415,11 +415,19 @@
 var selected = selection.getSelected();
 
 if( multipleSelectionAllowed ) {
+var def = $.Deferred();
+var p = def.promise();
+
 $.each( selected, function( i, item ) {
-$.post( organisationUnitTreePath + addorgunit.action, {
-id: item
-} ).complete( fn );
+p = p.then(function() {
+return $.post(organisationUnitTreePath + addorgunit.action, {
+id: item
+});
+});
 } );
+
+p.done(fn);
+def.resolve();
 } else {
 selected = $.isArray( selected ) ? selected[0] : selected;
 

=== modified file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-user/src/main/java/org/hisp/dhis/user/action/UpdateUserAction.java'
--- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-user/src/main/java/org/hisp/dhis/user/action/UpdateUserAction.java	2014-08-15 07:40:20 +
+++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-user/src/main/java/org/hisp/dhis/user/action/UpdateUserAction.java	2014-09-11 12:33:22 +
@@ -28,14 +28,10 @@
  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  */
 
-import static org.hisp.dhis.setting.SystemSettingManager.KEY_ONLY_MANAGE_WITHIN_USER_GROUPS;
-
-import java.util.ArrayList;
-import java.util.HashSet;
-import java.util.List;
-import java.util.Set;
-
+import com.google.common.collect.Lists;
+import com.opensymphony.xwork2.Action;
 import org.hisp.dhis.attribute.AttributeService;
+import org.hisp.dhis.common.IdentifiableObjectManager;
 import org.hisp.dhis.dataelement.CategoryOptionGroupSet;
 import org.hisp.dhis.dataelement.DataElementCategory;
 import org.hisp.dhis.dataelement.DataElementCategoryService;
@@ -60,7 +56,12 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.util.StringUtils;
 
-import com.opensymphony.xwork2.Action;
+import java.util.ArrayList;
+import java.util.HashSet;
+import java.util.List;
+import java.util.Set;
+
+import static org.hisp.dhis.setting.SystemSettingManager.KEY_ONLY_MANAGE_WITHIN_USER_GROUPS;
 
 /**
  * @author Torgeir Lorange Ostby
@@ -121,6 +122,9 @@
 this.attributeService = attributeService;
 }
 
+@Autowired
+private IdentifiableObjectManager manager;
+
 private I18n i18n;
 
 public void setI18n( I18n i18n )
@@ -239,6 +243,13 @@
 return message;
 }
 
+private String ouwtSelected;
+
+public void setOuwtSelected( String ouwtSelected )
+{
+this.ouwtSelected = ouwtSelected;
+}
+
 // -
 // Action implementation
 // -
@@ -263,7 +274,7 @@
 // -
 
 Boolean canManageGroups = (Boolean) systemSettingManager.getSystemSetting( KEY_ONLY_MANAGE_WITHIN_USER_GROUPS, false );
-
+
 if ( canManageGroups  !currentUser.getUserCredentials().getAllAuthorities().contains( ALL ) )
 {
 boolean groupFound = false;
@@ -382,7 +393,7 @@
 // -
 // Update User
 // -
-
+
 userService.updateUserCredentials( userCredentials );
 userService.updateUser( user );
 
@@ -390,13 +401,26 @@

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 16696: tracker capture - overdue and upcoming reports now allow for pdf printing and export to CSV, exce...


revno: 16696
committer: Abyot Asalefew Gizaw aby...@gmail.com
branch nick: dhis2
timestamp: Thu 2014-09-11 14:35:41 +0200
message:
  tracker capture - overdue and upcoming reports now allow for pdf printing and 
export to CSV, excel is WIP
added:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/scripts/ng-csv.js
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/angular/angular-sanitize.js
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/overdue-events-controller.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/overdue-events.html
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/upcoming-events-controller.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/upcoming-events.html
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/i18n/en.json
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/index.html
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/scripts/app.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/scripts/directives.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/scripts/services.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/styles/style.css
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/views/column-modal.html


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/overdue-events-controller.js'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/overdue-events-controller.js	2014-09-10 07:13:29 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/overdue-events-controller.js	2014-09-11 12:35:41 +
@@ -2,9 +2,9 @@
  function($scope,
 $modal,
 $location,
+$translate,
 orderByFilter,
 DateUtils,
-EventUtils,
 TEIService,
 TEIGridService,
 TranslationService,
@@ -17,7 +17,6 @@
 
 $scope.today = DateUtils.format(moment());
 
-$scope.ouModes = [{name: 'SELECTED'}, {name: 'CHILDREN'}, {name: 'DESCENDANTS'}, {name: 'ACCESSIBLE'}]; 
 $scope.selectedOuMode = 'SELECTED';
 $scope.report = {};
 $scope.displayMode = {};
@@ -79,7 +78,7 @@
 if (angular.isObject($scope.selectedProgram)){
 $scope.generateReport();
 }
-});
+});
 
 $scope.generateReport = function(){
 
@@ -98,12 +97,11 @@
 AttributesFactory.getByProgram($scope.selectedProgram).then(function(atts){
 $scope.gridColumns = TEIGridService.generateGridColumns(atts, $scope.selectedOuMode);
 
-$scope.gridColumns.push({name: 'event_name', id: 'event_name', type: 'string', displayInListNoProgram: false, showFilter: false, show: true});
-$scope.filterTypes['event_name'] = 'string';
-
-$scope.gridColumns.push({name: 'due_date', id: 'due_date', type: 'date', displayInListNoProgram: false, showFilter: false, show: true});
-$scope.filterTypes['due_date'] = 'date';
-$scope.filterText['due_date']= {};
+$scope.gridColumns.push({name: $translate('event_name'), id: 'eventName', type: 'string', displayInListNoProgram: false, showFilter: false, show: true});
+$scope.filterTypes['eventName'] = 'string';
+$scope.gridColumns.push({name: $translate('due_date'), id: 'dueDate', type: 'date', displayInListNoProgram: false, showFilter: false, show: true});
+$scope.filterTypes['dueDate'] = 'date';
+$scope.filterText['dueDate']= {};
 });  
 
 //fetch TEIs for the selected program and orgunit/mode
@@ -116,61 +114,36 @@
 false).then(function(data){ 
 
 //process tei grid
-var teis = TEIGridService.format(data,true); 
-$scope.teiList = [];
+var teis = TEIGridService.format(data,true);
+$scope.overdueEvents = [];
 DHIS2EventFactory.getByOrgUnitAndProgram($scope.selectedOrgUnit.id, $scope.selectedOuMode, $scope.selectedProgram.id, null,

Re: [Dhis2-devs] [Dhis2-users] XML ou CSV Importation de métadonnées

2014-09-11 Thread Assetta BARA

Salut Braa et olav,
Oui j'ai le fichier  Hibernate.properties
Ah oui c'est effectivement le problème d'incompatibilité de nom de la base dans 
le fichier Hibernate.properties. j'ai simplement changer le nom de ma base 
locale  ( dans le Postgresql) et redémarrer l'ordinateur et ça marche bien. 
Merci bien
cordialement!!
Assetta


Le Jeudi 11 septembre 2014 14h20, Jørn Braa jornb...@gmail.com a écrit :
 


Bonjour Assetta, en franglish:

what exactly do you mean by (c'est quoi exactement)  'déconnecte de ma
base en local et me reconnecte', c'est redémarrage? /are you
restarting the DHIS?

Also make sure you have (il faut avoir) hibernate.hbm2ddl.auto =
update in your hibernate.properties file.

Et il faut avoir hibernate.properties file - sinon, les  métadonnées
importées ne marche que en 'runtime' et rien est conservée,

Do you have hibernate.properties file? Please see
https://www.dhis2.org/development for some guides

jørn


2014-09-11 8:20 GMT+02:00 Assetta BARA assetta.b...@ymail.com:
 Salut chers tous,
 l'importation des métadonnées n'est pas stable j'ai installé dhis2 en
 local (2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi)
 avec succès. Mais à chaque fois, que je me déconnecte de ma base en local et
 me reconnecte, pas de métadonnées!!! Existe t-il une méthode de conserver
 ses variables importées? Merci de votre aide.
 Assetta
 DHIS2-Burkina

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens

Hi Jason,

To pick up the point again, there's an additional question I've been looking at.

Even if disaggregated indicator reporting is burdensome (as you explain below), 
it is sometimes necessary for correct aggregated indicator calculations (the 
most obvious one the use of weighted averages) to have intermediary 
calculations according to dimensions in the indicator calculation, which can 
then be aggregated over the whole table to obtain the total aggregated 
indicator value. Even in these intermediary calculations, however, the data is 
not available for calculation, returning zero as a result.

The conclusion is that the current way of indicator calculation not only 
complicates (if not makes impossible in many cases) calculation of indicators 
per custom dimension, but also making impossible the correct calculation of 
indicators over period and orgunit dimension when any intermediary calculation 
over custom dimensions is necessary.

Can you confirm this?

If true, is it hard to modify the calculation method to simply pick the 
one-level-higher value of a data element whenever no disaggregated value 
exists? With existing I don't mean NULL or zero, but rather not defined (the 
dimension does not exist).

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 10 September 2014 17:55
To: Robin Martens
Cc: Lars Helge Øverland; 
dhis2-us...@lists.launchpad.netmailto:dhis2-us...@lists.launchpad.net; 
dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
It has been a discussed, and certainly not a bug. See a related thread here 
(https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion 
on validation rules. It is essentially the same as indicators. What you will 
have to do is to create seperate indicator for each and every combination which 
you need. It can be painful, but the only way really which I know at the moment.

Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2

Regards,
Jason


On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens 
mart...@sher.bemailto:mart...@sher.be wrote:
Dear all,

I've been testing the indicator calculation algorithm and noticed something 
particular of which I'm not sure if it's a bug or a deliberate development 
choice.

Indicators are not explicitly defined per category such as data elements but 
the reporting tools allow a disaggregated indicator calculation, which is 
definitely very useful. In a specific example, I want to know how many people 
were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I 
have two data elements: the total population and the national vaccination 
levels (in %), with a custom category vaccination type which can be A, B, or 
C.

My indicator would be total population x national vaccination level 
(total). That works fine when put in a pivot table.

However, when trying to disaggregate the indicator calculation by adding my 
custom category to the pivot table, I don't have any values anymore. It seems 
the reason is that the total population data element does not have the 
vaccination type category (which seems logical) and therefore isn't found by 
the calculation algorithm. As a result, my table is empty. It seems useful that 
the algorithm would take the aggregated value (for population) available in 
such cases.

Another example is over the period dimension: my population is a yearly value, 
so when calculating an indicator on a monthly basis, instead of taking the 
available yearly value, he takes zero.

So my question: is this a deliberate choice in the development, a bug, or an 
idea for a future system improvement?

Kind regards,

Robin



___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : 
dhis2-devs@lists.launchpad.netmailto:dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Jason P. Pickering
email: jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
You lost me. Could you maybe give a somewhat simpler example by what you
mean by an intermediary calculation?

I am not sure exactly what you are trying to acheive, but what I can say is
that in certain cases, I have had to write my own calculation methods for
certain indicators which are basically impossible to calculate with the
current implementation in DHIS2. It works fine for simple sums, averages,
and other types of statistical things (standard deviation, etc), but for
instance, if you want to calculate other statistical properties (skewness,
kurtosis) of a given set of values, there is not a way to do it directly
with DHIS2. Also, certain indicators depend on component parts, and cannot
be calculated the way DHIS2 does it, by first summing up the numerator and
denominator and then dividing it, as opposed to calculating a non-weighted
average of compulsory pairs of data. What I am getting at, is that you may
have to write your own calculation methods, depending on how complex they
are.

Regards,
Jason


On Thu, Sep 11, 2014 at 4:20 PM, Robin Martens mart...@sher.be wrote:

  Hi Jason,



 To pick up the point again, there's an additional question I've been
 looking at.



 Even if disaggregated indicator reporting is burdensome (as you explain
 below), it is sometimes necessary for correct aggregated indicator
 calculations (the most obvious one the use of weighted averages) to have
 intermediary calculations according to dimensions in the indicator
 calculation, which can then be aggregated over the whole table to obtain
 the total aggregated indicator value. Even in these intermediary
 calculations, however, the data is not available for calculation, returning
 zero as a result.



 The conclusion is that the current way of indicator calculation not only
 complicates (if not makes impossible in many cases) calculation of
 indicators per custom dimension, but also making impossible the correct
 calculation of indicators over period and orgunit dimension when any
 intermediary calculation over custom dimensions is necessary.



 Can you confirm this?



 If true, is it hard to modify the calculation method to simply pick the
 one-level-higher value of a data element whenever no disaggregated value
 exists? With existing I don't mean NULL or zero, but rather not defined
 (the dimension does not exist).



 Robin



 *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com
 jason.p.picker...@gmail.com]
 *Sent:* 10 September 2014 17:55
 *To:* Robin Martens
 *Cc:* Lars Helge Øverland; dhis2-us...@lists.launchpad.net; dhis2-devs
 *Subject:* Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions



 Hi Robin,

 It has been a discussed, and certainly not a bug. See a related thread
 here (https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar
 discussion on validation rules. It is essentially the same as indicators.
 What you will have to do is to create seperate indicator for each and every
 combination which you need. It can be painful, but the only way really
 which I know at the moment.



 Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2



 Regards,

 Jason





 On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens mart...@sher.be wrote:

 Dear all,



 I've been testing the indicator calculation algorithm and noticed
 something particular of which I'm not sure if it's a bug or a deliberate
 development choice.



 Indicators are not explicitly defined per category such as data elements
 but the reporting tools allow a disaggregated indicator calculation, which
 is definitely very useful. In a specific example, I want to know how many
 people were vaccinated this year and I have 3 kinds of vaccinations: A, B,
 and C. I have two data elements: the total population and the national
 vaccination levels (in %), with a custom category vaccination type which
 can be A, B, or C.



 My indicator would be total population x national vaccination level
 (total). That works fine when put in a pivot table.



 However, when trying to disaggregate the indicator calculation by adding
 my custom category to the pivot table, I don't have any values anymore. It
 seems the reason is that the total population data element does not have
 the vaccination type category (which seems logical) and therefore isn't
 found by the calculation algorithm. As a result, my table is empty. It
 seems useful that the algorithm would take the aggregated value (for
 population) available in such cases.



 Another example is over the period dimension: my population is a yearly
 value, so when calculating an indicator on a monthly basis, instead of
 taking the available yearly value, he takes zero.



 So my question: is this a deliberate choice in the development, a bug, or
 an idea for a future system improvement?



 Kind regards,



 Robin






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

Re: [Dhis2-devs] [Bug 1368191] [NEW] Attributes and Data Entry form not loading in Tracker Capture

2014-09-11 Thread Abyot Gizaw

Hi Busoye,

A fix is now committed - r16418.

---
Thank you,
Abyot.

On Thu, Sep 11, 2014 at 1:59 PM, Adebusoye Anifalaje bus...@hisp.org
wrote:

 Public bug reported:

 Hi Devs,

 I am having issues loading attributes for a defined program. The program
 assigned to the org unit shows but when I select Register only the
 Report Date comes up. There are no errors in the log but the Console
 output is below:

 TypeError: Cannot read property 'id' of undefined
 at
 https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:437:62
 at Array.forEach (native)
 at Object.forEach (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:322:11
 )
 at
 https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:436:25
 at wrappedCallback (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11046:81
 )
 at
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11132:26
 at Scope.$eval (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12075:28
 )
 at Scope.$digest (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11903:31
 )
 at Scope.$apply (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12179:24
 )
 at
 https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:417:36
 angular.js:9509(anonymous function) angular.js:9509(anonymous function)
 angular.js:6950wrappedCallback angular.js:11049(anonymous function)
 angular.js:11132Scope.$eval angular.js:12075Scope.$digest
 angular.js:11903Scope.$apply angular.js:12179(anonymous function)
 services.js:417forEach angular.js:322(anonymous function) services.js:411k
 jquery.min.js:2l.fireWith jquery.min.js:2request.onsuccess
 dhis2.storage.idb.js:264

 The problem seems to be here:

 angular.forEach(program.programTrackedEntityAttributes,
 function(pAttribute){
 var att = attributes[pAttribute.attribute.id];
 att.mandatory = pAttribute.mandatory;
 if(pAttribute.displayInList){
 att.displayInListNoProgram = true;

 I am using Version:
 2.16
 Build revision:
 16410

 Many thanks.

 Kind regards,
 Busoye

 ** Affects: dhis2
  Importance: Undecided
  Status: New

 --
 You received this bug notification because you are a member of DHIS 2
 developers, which is subscribed to DHIS.
 https://bugs.launchpad.net/bugs/1368191

 Title:
   Attributes and Data Entry form not loading in Tracker Capture

 Status in DHIS 2:
   New

 Bug description:
   Hi Devs,

   I am having issues loading attributes for a defined program. The
   program assigned to the org unit shows but when I select Register only
   the Report Date comes up. There are no errors in the log but the
   Console output is below:

   TypeError: Cannot read property 'id' of undefined
   at
 https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:437:62
   at Array.forEach (native)
   at Object.forEach (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:322:11
 )
   at
 https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:436:25
   at wrappedCallback (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11046:81
 )
   at
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11132:26
   at Scope.$eval (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12075:28
 )
   at Scope.$digest (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11903:31
 )
   at Scope.$apply (
 https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12179:24
 )
   at
 https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:417:36
 angular.js:9509(anonymous function) angular.js:9509(anonymous function)
 angular.js:6950wrappedCallback angular.js:11049(anonymous function)
 angular.js:11132Scope.$eval angular.js:12075Scope.$digest
 angular.js:11903Scope.$apply angular.js:12179(anonymous function)
 services.js:417forEach angular.js:322(anonymous function) services.js:411k
 jquery.min.js:2l.fireWith jquery.min.js:2request.onsuccess
 dhis2.storage.idb.js:264

   The problem seems to be here:

   angular.forEach(program.programTrackedEntityAttributes,
 function(pAttribute){
   var att = attributes[pAttribute.attribute.id];
   att.mandatory = pAttribute.mandatory;
   if(pAttribute.displayInList){
   att.displayInListNoProgram = true;

   I am using Version:
   2.16
   Build revision:
   16410

   Many thanks.

   Kind regards,
   Busoye

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/dhis2/+bug/1368191/+subscriptions

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

[Dhis2-devs] [Bug 1368191] Re: Attributes and Data Entry form not loading in Tracker Capture

2014-09-11 Thread Abyot Asalefew Gizaw

** Changed in: dhis2
 Assignee: (unassigned) = Abyot Asalefew Gizaw (abyot)

** Changed in: dhis2
   Status: New = Fix Committed

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1368191

Title:
  Attributes and Data Entry form not loading in Tracker Capture

Status in DHIS 2:
  Fix Committed

Bug description:
  Hi Devs,

  I am having issues loading attributes for a defined program. The
  program assigned to the org unit shows but when I select Register only
  the Report Date comes up. There are no errors in the log but the
  Console output is below:

  TypeError: Cannot read property 'id' of undefined
  at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:437:62
  at Array.forEach (native)
  at Object.forEach 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:322:11)
  at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:436:25
  at wrappedCallback 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11046:81)
  at 
https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11132:26
  at Scope.$eval 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12075:28)
  at Scope.$digest 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:11903:31)
  at Scope.$apply 
(https://dhis.leprosy.org/dhis-web-commons/javascripts/angular/angular.js:12179:24)
  at 
https://dhis.leprosy.org/dhis-web-tracker-capture/scripts/services.js:417:36 
angular.js:9509(anonymous function) angular.js:9509(anonymous function) 
angular.js:6950wrappedCallback angular.js:11049(anonymous function) 
angular.js:11132Scope.$eval angular.js:12075Scope.$digest 
angular.js:11903Scope.$apply angular.js:12179(anonymous function) 
services.js:417forEach angular.js:322(anonymous function) services.js:411k 
jquery.min.js:2l.fireWith jquery.min.js:2request.onsuccess 
dhis2.storage.idb.js:264

  The problem seems to be here:

  angular.forEach(program.programTrackedEntityAttributes, function(pAttribute){
  var att = attributes[pAttribute.attribute.id];
  att.mandatory = pAttribute.mandatory;
  if(pAttribute.displayInList){
  att.displayInListNoProgram = true; 

  I am using Version:
  2.16
  Build revision:
  16410

  Many thanks.

  Kind regards,
  Busoye

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1368191/+subscriptions

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Robin Martens

Hi Jason,

I appreciate your help as this is very important for our project, thanks.

Some of our indicators are indeed quite complex and might need some custom 
coding if not too complicated. However, can you give some basic steps on how to 
achieve this (and on how hard this is in terms of programming as we're not 
experts here)?

---

The rest of this mail is about the specific issue I'm having here, it's 
basically related to three things:


1.   The absence of cross-product calculations in DHIS2 (I think it's 
what you call compulsory pairs of data).

2.   The fact that when no data exists on a disaggregated level, the value 
is taken to be zero instead of the aggregated (for custom dimensions only I 
think).

3.   The average function only exists over the time dimension (as discussed 
by Lars previously this week).

A simple example:



Population

Conso pp

Total

District 1

10

2

20

District 2

5

3

15

Total

15

5

35


When calculating the total national consumption, DHIS2 will do: aggregated 
population (=15) times aggregated consumption per person (=5) makes 75, which 
is wrong. In reality, the two mistakes are:


1.   The calculation should happen on district level before aggregating to 
the national value (20 for district1 plus 15 for district2 makes 35, which is 
the correct answer). - Cross product

2.   DHIS2 always sums over orgunits (to be corrected soon according to 
Lars so I won't go further in detail here)

The cross-product issue can actually be solved by a workaround: obliging the 
user to explicitly show the disaggregation level (i.e. the level at which the 
cross product happens) in the report tables. Interestingly enough, when 
calculating the total in a report without showing districts, DHIS2 will return 
75, while when showing the districts 35.

Imagine now that the consumption has three products (a custom category), ABC. 
The table would look like this:



Population

Conso pp A

Conso pp B

Conso pp C

Total A

Total B

Total C

Total

District 1

10

2

1

1

20

10

10

40

District 2

5

3

1

0

15

5

0

20

Total

15

5

2

1

35

15

10

60


The same principle, but aggregated over the Product category and orgunit 
dimension gives the correct result of 60. This is how DHIS2 would calculate:


1.   When not showing the Product category in the table: total population 
(15) x total aggregated consumption (=5+2+1=8) is 120.

2.   When showing the Product category in the table: total population (0, 
it will not find a value and return zero) x consumption is 0 !!!

Indeed, the workaround does work for orgunits but not for custom dimensions 
when not all data (in this case the population) has the same custom dimensions.

I guess these are things that won't be solved quickly so I might need to do 
some coding myself. As a conclusion, to increase calculation power in DHIS2 I'd 
say:


1.   Use aggregated value when no disaggregated value exists (such as for 
population in the previous example).

2.   Aggregation operators (sum, average,...) should be defined per custom 
category and per data element. In other words, when creating a data element and 
adding categories, you have to add the operator for each category.

3.   Indicators should be available for re-use in other indicators. It 
enables you building complex indicators piece by piece and gives more 
flexibility on intermediate calculation (on disaggregated level).

I hope this is somewhat more clear.

Kind regards,

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 11 September 2014 16:30
To: Robin Martens
Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net; dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
You lost me. Could you maybe give a somewhat simpler example by what you mean 
by an intermediary calculation?

I am not sure exactly what you are trying to acheive, but what I can say is 
that in certain cases, I have had to write my own calculation methods for 
certain indicators which are basically impossible to calculate with the current 
implementation in DHIS2. It works fine for simple sums, averages, and other 
types of statistical things (standard deviation, etc), but for instance, if you 
want to calculate other statistical properties (skewness, kurtosis) of a given 
set of values, there is not a way to do it directly with DHIS2. Also, certain 
indicators depend on component parts, and cannot be calculated the way DHIS2 
does it, by first summing up the numerator and denominator and then dividing 
it, as opposed to calculating a non-weighted average of compulsory pairs of 
data. What I am getting at, is that you may have to write your own calculation 
methods, depending on how complex they are.

Regards,
Jason


On Thu, Sep 11, 2014 at 4:20 PM, Robin Martens 
mart...@sher.bemailto:mart...@sher.be wrote:
Hi Jason,

To pick up the point again, there's an additional question I've been looking at.

Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,

Your mail is dense and will need some digestion. :)

 You give a very good level of detail however of you problem in this mail
and will be very useful as this type of functionality is attempted to be
implemented.

To respond immediately to how you might be able to solve the issue, you
should possibly consider using the WebAPI to extract your data, process it
as you need, and then inject it back into DHIS2. The WebAPI is described in
detail here https://www.dhis2.org/doc/snapshot/en/user/html/ch32.html. I
have also written a chapter on the use of the R programming language with
DHIS2, which is particularly well suited to do the type of custom
calculations you are describing here. It is available here
https://www.dhis2.org/doc/snapshot/en/user/html/apc.html. Of course,
other language/methods may also be more suited to your situation, such as
Python. Lastly, you can have a look at the DHIS2 Ad-hoc tool
http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/files/head:/tools/dhis-adhoc/
which
would allow interaction with the service layer of DHIS2. Another approach
could be SQL which interacts directly with the database. I am sure there
are many other means as well. So short answer is, right now there is no
in-built way to achieve what you need I think, and it will take some coding
on your side.

We have run into similar issues in the water and sanitation sector, where
we need to work with the latest reported data, which DHIS2 does not
handle really. We pull out the data via the WebAPI, do the aggregation
externally, and then inject everything back into the system to get the
figures we need. It would be nice if the system did it automatically, but
given the nature of the project, there are many feature requests and
limited resources. Contributions of course are welcome.

The current aggregation engine handles the easy cases of sums and
averages pretty well, but for more complex stuff, external routes may be
the only solution for now.

We should certainly try and distill some of your ideas into a concrete
blueprint.

Best regards,
Jason


On Thu, Sep 11, 2014 at 6:15 PM, Robin Martens mart...@sher.be wrote:

  Hi Jason,



 I appreciate your help as this is very important for our project, thanks.



 Some of our indicators are indeed quite complex and might need some custom
 coding if not too complicated. However, can you give some basic steps on
 how to achieve this (and on how hard this is in terms of programming as
 we're not experts here)?



 ---



 The rest of this mail is about the specific issue I'm having here, it's
 basically related to three things:



 1.   The absence of cross-product calculations in DHIS2 (I think
 it's what you call compulsory pairs of data).

 2.   The fact that when no data exists on a disaggregated level, the
 value is taken to be zero instead of the aggregated (for custom dimensions
 only I think).

 3.   The average function only exists over the time dimension (as
 discussed by Lars previously this week).



 A simple example:





 Population

 Conso pp

 Total

 District 1

 10

 2

 20

 District 2

 5

 3

 15

 Total

 15

 5

 35



 When calculating the total national consumption, DHIS2 will do: aggregated
 population (=15) times aggregated consumption per person (=5) makes 75,
 which is wrong. In reality, the two mistakes are:



 1.   The calculation should happen on district level before
 aggregating to the national value (20 for district1 plus 15 for district2
 makes 35, which is the correct answer). - Cross product

 2.   DHIS2 always sums over orgunits (to be corrected soon according
 to Lars so I won't go further in detail here)



 The cross-product issue can actually be solved by a workaround: obliging
 the user to explicitly show the disaggregation level (i.e. the level at
 which the cross product happens) in the report tables. Interestingly
 enough, when calculating the total in a report without showing districts,
 DHIS2 will return 75, while when showing the districts 35.



 Imagine now that the consumption has three products (a custom category),
 ABC. The table would look like this:





 Population

 Conso pp A

 Conso pp B

 Conso pp C

 Total A

 Total B

 Total C

 *Total*

 District 1

 10

 2

 1

 1

 20

 10

 10

 *40*

 District 2

 5

 3

 1

 0

 15

 5

 0

 *20*

 Total

 15

 5

 2

 1

 35

 15

 10

 60



 The same principle, but aggregated over the Product category and orgunit
 dimension gives the correct result of 60. This is how DHIS2 would calculate:



 1.   When not showing the Product category in the table: total
 population (15) x total aggregated consumption (=5+2+1=8) is 120.

 2.   When showing the Product category in the table: total population
 (0, it will not find a value and return zero) x consumption is 0 !!!



 Indeed, the workaround does work for orgunits but not for custom
 dimensions when not all data (in this case the population) has the same
 custom dimensions.



 I

[Dhis2-devs] Event Capture - Program not selected