[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19828: bugfixes for DateTimeUnit.toJodaDateTime when using different chronology than ISO, also allows fo...

[noreply]

revno: 19828
committer: Morten Olav Hansen 
branch nick: dhis2
timestamp: Mon 2015-08-24 14:03:59 +0700
message:
  bugfixes for DateTimeUnit.toJodaDateTime when using different chronology than 
ISO, also allows for used chronology to be specified
modified:
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/calendar/DateTimeUnit.java
  
dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.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/calendar/DateTimeUnit.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/calendar/DateTimeUnit.java	2015-01-17 07:41:26 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/calendar/DateTimeUnit.java	2015-08-24 07:03:59 +
@@ -28,11 +28,7 @@
  * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  */
 
-import java.util.Date;
-import java.util.TimeZone;
-
-import javax.validation.constraints.NotNull;
-
+import com.google.common.base.MoreObjects;
 import org.joda.time.Chronology;
 import org.joda.time.DateTime;
 import org.joda.time.DateTimeZone;
@@ -40,7 +36,9 @@
 import org.joda.time.LocalDateTime;
 import org.joda.time.chrono.ISOChronology;
 
-import com.google.common.base.MoreObjects;
+import javax.validation.constraints.NotNull;
+import java.util.Date;
+import java.util.TimeZone;
 
 /**
  * Class representing a specific calendar date.
@@ -281,35 +279,34 @@
 }
 
 /**
- * Converts dateUnit to Joda-Time DateTime
+ * Converts dateUnit to Joda-Time DateTime using ISO chronology
  *
  * @return Populated DateTime object
  */
 public DateTime toJodaDateTime()
 {
+return toJodaDateTime( ISOChronology.getInstance() );
+}
+
+/**
+ * Converts dateUnit to Joda-Time DateTime with a specific chronology.
+ *
+ * @param chronology Chronology to use
+ * @return Populated DateTime object
+ */
+public DateTime toJodaDateTime( Chronology chronology )
+{
 try
 {
-return new DateTime( year, month, day, hour, minute, second, millis, ISOChronology.getInstance( DateTimeZone.forTimeZone( timeZone ) ) );
+return new DateTime( year, month, day, hour, minute, second, millis, chronology.withZone( DateTimeZone.forTimeZone( timeZone ) ) );
 }
 catch ( IllegalInstantException ex )
 {
 LocalDateTime localDateTime = new LocalDateTime( year, month, day, hour, minute, second, millis,
-ISOChronology.getInstance( DateTimeZone.forTimeZone( timeZone ) ) );
+chronology.withZone( DateTimeZone.forTimeZone( timeZone ) ) );
 
 return localDateTime.toLocalDate().toDateTimeAtStartOfDay();
 }
-
-}
-
-/**
- * Converts dateUnit to Joda-Time DateTime with a specific chronology.
- *
- * @param chronology Chronology to use
- * @return Populated DateTime object
- */
-public DateTime toJodaDateTime( Chronology chronology )
-{
-return toJodaDateTime().withChronology( chronology );
 }
 
 /**

=== modified file 'dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java'
--- dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java	2015-08-24 03:56:46 +
+++ dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java	2015-08-24 07:03:59 +
@@ -30,9 +30,15 @@
 
 import org.hisp.dhis.calendar.Calendar;
 import org.hisp.dhis.calendar.DateTimeUnit;
+import org.hisp.dhis.period.Cal;
+import org.hisp.dhis.period.DailyPeriodType;
+import org.hisp.dhis.period.Period;
 import org.junit.Before;
 import org.junit.Test;
 
+import java.util.Date;
+import java.util.List;
+
 import static org.junit.Assert.assertEquals;
 
 /**
@@ -73,4 +79,14 @@
 assertEquals( 35, month12 );
 assertEquals( 35, month13 );
 }
+
+@Test
+public void testGenerateDailyPeriods()
+{
+Date startDate = new Cal( 1975, 1, 1, true ).time();
+Date endDate = new Cal( 2025, 1, 2, true ).time();
+
+List days = new DailyPeriodType().generatePeriods( calendar, startDate, endDate );
+assertEquals( 18264, days.size() );
+}
 }

___
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 19829: minor fixes, make sure to use local chronology as basis for PeriodType.toIsoPeriod => getIsoDate

[noreply]

revno: 19829
committer: Morten Olav Hansen 
branch nick: dhis2
timestamp: Mon 2015-08-24 14:46:44 +0700
message:
  minor fixes, make sure to use local chronology as basis for 
PeriodType.toIsoPeriod => getIsoDate
modified:
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/PeriodType.java
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java
  
dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.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/period/PeriodType.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/PeriodType.java	2015-07-15 09:45:45 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/PeriodType.java	2015-08-24 07:46:44 +
@@ -62,7 +62,7 @@
 implements Serializable
 {
 // Cache for period lookup, uses calendar.name() + periodType.getName() + date.getTime() as key
-
+
 private static Cache periodCache = CacheBuilder.newBuilder()
 .expireAfterAccess( 5, TimeUnit.MINUTES )
 .initialCapacity( 1 )
@@ -310,14 +310,14 @@
 DateTimeUnit from = calendar.toIso( start );
 DateTimeUnit to = calendar.toIso( end );
 
-return new Period( this, from.toJdkDate(), to.toJdkDate(), getIsoDate( from ) );
+return new Period( this, from.toJdkDate(), to.toJdkDate(), getIsoDate( start ) );
 }
 
 public Period toIsoPeriod( DateTimeUnit dateTimeUnit )
 {
 return toIsoPeriod( dateTimeUnit, dateTimeUnit );
 }
-
+
 public abstract String getIso8601Duration();
 
 public abstract Period createPeriod( DateTimeUnit dateTimeUnit, org.hisp.dhis.calendar.Calendar calendar );
@@ -456,17 +456,17 @@
 public static List getPeriodsFromIsoStrings( List isoPeriods )
 {
 List periods = new ArrayList<>();
-
+
 for ( String isoPeriod : isoPeriods )
 {
 Period period = getPeriodFromIsoString( isoPeriod );
-
+
 if ( period != null )
 {
 periods.add( period );
 }
 }
-
+
 return periods;
 }
 

=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java	2015-06-11 21:37:27 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java	2015-08-24 07:46:44 +
@@ -52,7 +52,7 @@
 private static final long serialVersionUID = -5973809094923012052L;
 
 private static final String ISO_FORMAT = "Qn";
-
+
 private static final String ISO8601_DURATION = "P1Q";
 
 /**
@@ -77,7 +77,7 @@
 {
 DateTimeUnit start = new DateTimeUnit( dateTimeUnit );
 
-start.setMonth( ( ( dateTimeUnit.getMonth() - 1 ) - ( ( dateTimeUnit.getMonth() - 1 ) % 3 ) ) + 1 );
+start.setMonth( ((dateTimeUnit.getMonth() - 1) - ((dateTimeUnit.getMonth() - 1) % 3)) + 1 );
 start.setDay( 1 );
 
 DateTimeUnit end = new DateTimeUnit( start );
@@ -147,7 +147,7 @@
 public List generateRollingPeriods( Date date )
 {
 date = createPeriod( date ).getStartDate();
-
+
 return generateRollingPeriods( createLocalDateUnitInstance( date ) );
 }
 
@@ -185,7 +185,7 @@
 case 10:
 return dateTimeUnit.getYear() + "Q4";
 default:
-throw new IllegalArgumentException( "Month not valid [1,4,7,10]" );
+throw new IllegalArgumentException( "Month not valid [1,4,7,10], was given " + dateTimeUnit.getMonth() );
 }
 }
 
@@ -197,11 +197,11 @@
 {
 return ISO_FORMAT;
 }
-
+
 @Override
-public String getIso8601Duration() 
+public String getIso8601Duration()
 {
-return ISO8601_DURATION; 
+return ISO8601_DURATION;
 }
 
 

=== modified file 'dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java'
--- dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java	2015-08-24 07:03:59 +
+++ dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java	2015-08-24 07:46:44 +
@@ -33,7 +33,9 @@
 import org.hisp.dhis.period.Cal;
 import org.hisp.dhis.period.DailyPeriodType;
 import org.hisp.dhis.period.Period;
+import org.hisp.dhis.period.QuarterlyPeriodType;
 import org.junit.Before;
+import org.junit.Ignore;
 import org.junit.Test;
 
 import java.util.Date;
@@ -89,4 +91,15 @@
 List days = new DailyPeriodType().generatePeriods( calendar, startDate, endDate );
 assertEquals( 18264, days.size() );
 }
+
+@Test
+

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19830: bugfixes for chronology based quarterly period types

[noreply]

revno: 19830
committer: Morten Olav Hansen 
branch nick: dhis2
timestamp: Mon 2015-08-24 15:48:49 +0700
message:
  bugfixes for chronology based quarterly period types
modified:
  
dhis-2/dhis-api/src/main/java/org/hisp/dhis/calendar/impl/EthiopianCalendar.java
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/MonthlyPeriodType.java
  dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java
  
dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.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/calendar/impl/EthiopianCalendar.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/calendar/impl/EthiopianCalendar.java	2015-08-24 03:47:48 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/calendar/impl/EthiopianCalendar.java	2015-08-24 08:48:49 +
@@ -30,10 +30,13 @@
 
 import org.hisp.dhis.calendar.Calendar;
 import org.hisp.dhis.calendar.ChronologyBasedCalendar;
+import org.hisp.dhis.calendar.DateTimeUnit;
 import org.joda.time.DateTimeZone;
 import org.joda.time.chrono.EthiopicChronology;
 import org.springframework.stereotype.Component;
 
+import java.util.Date;
+
 /**
  * @author Morten Olav Hansen 
  */
@@ -59,6 +62,25 @@
 }
 
 @Override
+public DateTimeUnit toIso( DateTimeUnit dateTimeUnit )
+{
+dateTimeUnit = normalize( dateTimeUnit );
+return super.toIso( dateTimeUnit );
+}
+
+@Override
+public DateTimeUnit fromIso( Date date )
+{
+return super.fromIso( date );
+}
+
+@Override
+public DateTimeUnit fromIso( DateTimeUnit dateTimeUnit )
+{
+return super.fromIso( dateTimeUnit );
+}
+
+@Override
 public int daysInMonth( int year, int month )
 {
 if ( month < 12 )
@@ -68,4 +90,18 @@
 
 return 30 + super.daysInMonth( year, 13 );
 }
+
+private DateTimeUnit normalize( DateTimeUnit dateTimeUnit )
+{
+if ( dateTimeUnit.getMonth() < 12 || dateTimeUnit.getDay() <= 30 )
+{
+return dateTimeUnit;
+}
+
+dateTimeUnit = new DateTimeUnit( dateTimeUnit );
+dateTimeUnit.setDay( dateTimeUnit.getDay() - 30 );
+dateTimeUnit.setMonth( 13 );
+
+return dateTimeUnit;
+}
 }

=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/MonthlyPeriodType.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/MonthlyPeriodType.java	2015-06-11 21:37:27 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/MonthlyPeriodType.java	2015-08-24 08:48:49 +
@@ -52,7 +52,7 @@
 private static final long serialVersionUID = -6920058214699654387L;
 
 private static final String ISO_FORMAT = "MM";
-
+
 private static final String ISO8601_DURATION = "P1M";
 
 /**
@@ -78,6 +78,12 @@
 DateTimeUnit start = new DateTimeUnit( dateTimeUnit );
 start.setDay( 1 );
 
+if ( start.getMonth() > 12 )
+{
+start.setYear( start.getYear() + 1 );
+start.setMonth( 1 );
+}
+
 DateTimeUnit end = new DateTimeUnit( dateTimeUnit );
 end.setDay( calendar.daysInMonth( end.getYear(), end.getMonth() ) );
 
@@ -173,9 +179,9 @@
 }
 
 @Override
-public String getIso8601Duration() 
+public String getIso8601Duration()
 {
-return ISO8601_DURATION; 
+return ISO8601_DURATION;
 }
 
 

=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java	2015-08-24 07:46:44 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/period/QuarterlyPeriodType.java	2015-08-24 08:48:49 +
@@ -80,6 +80,12 @@
 start.setMonth( ((dateTimeUnit.getMonth() - 1) - ((dateTimeUnit.getMonth() - 1) % 3)) + 1 );
 start.setDay( 1 );
 
+if ( start.getMonth() > 12 )
+{
+start.setYear( start.getYear() + 1 );
+start.setMonth( 1 );
+}
+
 DateTimeUnit end = new DateTimeUnit( start );
 end = calendar.plusMonths( end, 2 );
 end.setDay( calendar.daysInMonth( end.getYear(), end.getMonth() ) );

=== modified file 'dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java'
--- dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java	2015-08-24 07:46:44 +
+++ dhis-2/dhis-api/src/test/java/org/hisp/dhis/calendar/impl/EthiopianCalendarTest.java	2015-08-24 08:48:49 +
@@ -32,6 +32,7 @@
 import org.hisp.dhis.calendar.DateTimeUnit;
 import org.hisp.dhis.period.Cal;
 import org.hisp.dhis.period.DailyPeriodType;
+import org.hisp.dhis.period.

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19831: tracker-capture: program validation criteria

[noreply]

revno: 19831
committer: Abyot Asalefew Gizaw 
branch nick: dhis2
timestamp: Mon 2015-08-24 11:55:12 +0200
message:
  tracker-capture: program validation criteria
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/registration/validation-message.html
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/i18n/i18n_app.properties
  
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/scripts/tracker-capture.js
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/dhis2/dhis2.angular.services.js


--
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/registration/validation-message.html'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/registration/validation-message.html	2015-08-19 20:13:21 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/registration/validation-message.html	2015-08-24 09:55:12 +
@@ -5,7 +5,7 @@
   
 
 
-{{message.name}} {{'is_expected' | translate}} {{message.expected}} {{'but_found' | translate}} {{message.found}}
+{{message.name}} {{'is_expected_to_be' | translate}} {{message.operator}} {{message.expected}} {{'but_found' | translate}} {{message.found}}
 
 
 

=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/i18n/i18n_app.properties'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/i18n/i18n_app.properties	2015-08-19 20:13:21 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/i18n/i18n_app.properties	2015-08-24 09:55:12 +
@@ -345,5 +345,8 @@
 dec=December
 week=Week
 save_layout_as_default=Save dashboard layout as default
-is_expected=is expected
-but_found=but found
\ No newline at end of file
+is_expected_to_be=is expected to be
+but_found=but found
+equals_to=equals to
+less_than=less than
+greater_than=greater than
\ No newline at end of file

=== modified file '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/scripts/services.js	2015-08-19 20:13:21 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/scripts/services.js	2015-08-24 09:55:12 +
@@ -538,19 +538,27 @@
 if(program && program.validationCriterias){
 for(var key in program.validationCriterias){
 angular.forEach(program.validationCriterias[key], function(vc){
-if(vc.property && vc.value){
+var att = attributesById[key];
+var operator = '';
+if(vc.property && vc.value && att && att.valueType){
+if(att.valueType === 'number' && dhis2.validation.isNumber(vc.value)){
+vc.value = parseInt(vc.value);
+}
 if(vc.operator === 0){
-enrollmentValidation.valid = vc.value === formTei[key];
+enrollmentValidation.valid = formTei[key] === vc.value;
+operator = $translate.instant('equals_to');
 }
 else if(vc.operator === 1){
-enrollmentValidation.valid = vc.value > formTei[key];
+enrollmentValidation.valid = formTei[key] > vc.value;
+operator = $translate.instant('greater_than');
 }
 else{
-enrollmentValidation.valid = vc.value < formTei[key];
+enrollmentValidation.valid = formTei[key] < vc.value;
+operator = $translate.instant('less_than');
 }
 
 if(!enrollmentValidation.valid){
-enrollmentValidation.messages.push({name: attributesById[key].name, expected: vc.value, found: formTei[key] ? formTei[key] : $translate.instant('empty')});
+enrollmentValidation.messages.push

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19832: bug fix in drop-down input fields

[noreply]

revno: 19832
committer: Abyot Asalefew Gizaw 
branch nick: dhis2
timestamp: Mon 2015-08-24 12:22:35 +0200
message:
  bug fix in drop-down input fields
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/dataentry/default-form.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/dataentry/default-form.html'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/dataentry/default-form.html	2015-08-21 09:37:44 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/dataentry/default-form.html	2015-08-24 10:22:35 +
@@ -209,7 +209,7 @@
 ng-required={{prStDes[de.dataElement.id].compulsory}} 
 ng-disabled="selectedEnrollment.status !== 'ACTIVE' || currentEvent.editingNotAllowed" 
 name="foo" 
-on-select="saveDatavalue(prStDes[de.dataElement.id], innerForm.foo)}}"  
+on-select="saveDatavalue(prStDes[de.dataElement.id], innerForm.foo)"  
 style="width:100%;">
 {{$select.selected.name  || $select.selected}}
 

___
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 19833: event-capture: missing tag

[noreply]

revno: 19833
committer: Abyot Asalefew Gizaw 
branch nick: dhis2
timestamp: Mon 2015-08-24 12:27:24 +0200
message:
  event-capture: missing tag
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-capture/views/defaultForm.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-event-capture/views/defaultForm.html'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-capture/views/defaultForm.html	2015-08-18 12:01:26 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-capture/views/defaultForm.html	2015-08-24 10:27:24 +
@@ -42,6 +42,7 @@
 
 
 {{'latitude'| translate}}
+
 
 ___
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 1297793] Re: Unable to load the data entry page for a user

[Jan Henrik Øverland]

** Changed in: dhis2
Milestone: None => 2.21

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

Title:
  Unable to load the data entry page for a user

Status in DHIS:
  New

Bug description:
  Environment details: Trunk build of DHIS 2.

  Steps to reproduce:

  1. Create a category option, category and category combo called "Number of 
cases". 
  2. Create a data element called "Shock" with category combination as "Number 
of cases" and of type aggregate and numeric. 
  3. Create a data set called "Cause", assign the data element "Shock" and 
select Weekly as the frequency.
  4. Create a role called "Data entry person" and assign access to the "Cause" 
dataset and authorities "See data entry module", "Delete data value, Add/Update 
data value", "See dashboard integration module".
  5. Create an org unit called "District 1"
  6. Assign the "Cause" data set to the org unit "District 1"
  7. Create a user called "entry1" with role "Data entry person" and assign 
access to the org unit "District 1"
  8. Login as entry1 and go to data entry screen.

  The following error is reported in the log - "* INFO  2014-03-26
  16:21:34,331 'entry1' read denied
  org.hisp.dhis.dataelement.DataElementCategoryCombo_$$_javassist_82,
  name: default, uid: hpgMJ5bmcBq (AuditLogUtil.java
  [1691071275@qtp-1792399744-20])"

  9. Select the "Cause" data set and a week. Enter a number for the Shock data 
element and hit "Complete".
  10.  Gives the message that data is saved offline although I am online.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1297793/+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

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19834: CSS, minor

[noreply]

revno: 19834
committer: Lars Helge Overland 
branch nick: dhis2
timestamp: Mon 2015-08-24 13:19:37 +0200
message:
  CSS, minor
modified:
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/login.css


--
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/css/login.css'
--- dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/login.css	2015-04-07 09:42:13 +
+++ dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/css/login.css	2015-08-24 11:19:37 +
@@ -114,7 +114,7 @@
 
 #notificationArea
 {
-  background-color: #D0E6FD;
+  background-color: #DAEAFA;
   color: #333;
   margin-top: 15px;
   padding: 15px;

___
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] Data Loss

[gerald thomas]

Dear Juan,
Under Maintenance column i am seeing the following:

Clear analytics tables

Clear data mart

Rebuild data mart index

Clear zero values

Clear data set completeness

Prune periods

Remove expired invitations

Drop SQL views

Create SQL views

Update category option combinations

What should I check for the performance maintenance before doing the
query again?

On 8/24/15, gerald thomas  wrote:
> Dear Juan,
> No!!! This is the holistic data from that query. Previously i only had
> the first part of the result. Do you want me to rebuild tables and run
> query again?
>
> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
>> Hello Gerald
>> This looks much different than the fist one you sent me and it's still
>> missing a lot of names, did you rebuild resource tables?
>> JM
>>
>> El 24/08/2015, a las 05:44, gerald thomas 
>> escribió:
>>
>>> Dear Juan,
>>> Thanks for your responses.
>>> Sorry i am only responding now but please find the attached category
>>> combo query.
>>>
>>> On 8/23/15, Juan Manuel Alcantara Acosta  wrote:
 Sorry, I got distracted and hit send before completing the message.

 You should limit the query to show the values of the specific data
 elements
 that are giving you trouble, you'll need the uid of each of the data
 element., In case you don't know how to get that information, you can
 use
 the api (your_server_URL/api/dataElements?paging=false) or look at the
 information if each data element in data element management selecting
 "show
 details" from the contextual menu that appears when clocking on the
 name
 of
 each data element. Then add to the query the list of UIDs just before
 the
 semicolon.

 WHERE de.uid IN
 ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')

 Please excuse me if you already know all of these things, since I don't
 have
 a way to know how much you know about the system and postgres queries I
 rather be detailed on what you have to do than leave you guessing.

 In addition to running maintenance to update category option
 combinations
 you should re-generate resource tables, you'll find that in "Data
 Administration" too.


 Regards,
 JM



 El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
  escribió:

> Hi Gerald
> I see you are missing a few category option combo names, you should
> run
> the maintenance to "Update category option combinations", you'll find
> this
> in "Data Administration" -> "maintenance"
> I also don't see the option combinations of the data elements you
> highlighted in the excel you sent to the list. Which category
> combination
> are you using with those data elements? Run the query again after
> doing
> the maintenance.
>
> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs
>
> About the out of memory error, I recommend that you use pgAdmin3 and
> try
> to run the query again. You should limit the query to show you the
> data
>
> El 23/08/2015, a las 15:39, gerald thomas 
> escribió:
>
>> Dear Juan,
>> For the datavalues query; i am getting "Out of memory" as result.
>> Please find the attached result for the combo query.
>>
>> On 8/23/15, Juan Manuel Alcantara Acosta 
>> wrote:
>>> Hello Gerald
>>> Does data disappear only from data elements that use the default
>>> category
>>> combination?
>>> Since you are querying your database directly, I'm sending you here
>>> a
>>> couple
>>> of queries you can use to verify the existing values of the database
>>> and
>>> the
>>> category combinations. Check if you have more than one default
>>> option
>>> combination.
>>>
>>> Regards,
>>> JM
>>>
>>>
>>>
>>>
>>>
>>>
>>> El 23/08/2015, a las 11:36, gerald thomas 
>>> escribió:
>>>
 Juan,
 Thanks for your response but we are not using custom forms for data
 entry.

 Regards,
 Gerald

 On Aug 23, 2015 4:29 PM, "Juan Manuel Alcantara Acosta"
  wrote:
 Hello Gerald
 Are you using custom forms for data entry?
 JM
 El 22/08/2015, a las 15:37, gerald thomas 
 escribió:

> Dear dhis2-users,
> If someone cannot help me; can anyone explain why am i having data
> for
> October, November, December 2015 on my database?
>
> dhis=# select * from period where startdate > '2015-01-01';
> periodid | periodtypeid | startdate  |  enddate
> --+--++
> 1121694 |6 | 2016-01-01 | 2016-12-31
> 2058605 |3 | 2015-11-01 | 2015-11-30
> 2058606 |3 | 2015-12-01 | 2015-12-31
>>>

Re: [Dhis2-devs] [Dhis2-users] Data Loss

[Juan Manuel Alcantara Acosta]

El 24/08/2015, a las 08:00, gerald thomas  escribió:

> Dear Juan,
> Under Maintenance column i am seeing the following:
> 
> Clear analytics tables
> 
> Clear data mart
> 
> Rebuild data mart index
> 
> Clear zero values
> 
> Clear data set completeness
> 
> Prune periods
> 
> Remove expired invitations
> 
> Drop SQL views
> 
> Create SQL views
> 
> Update category option combinations
> 
> What should I check for the performance maintenance before doing the
> query again?
> 
> On 8/24/15, gerald thomas  wrote:
>> Dear Juan,
>> No!!! This is the holistic data from that query. Previously i only had
>> the first part of the result. Do you want me to rebuild tables and run
>> query again?
>> 
>> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
>>> Hello Gerald
>>> This looks much different than the fist one you sent me and it's still
>>> missing a lot of names, did you rebuild resource tables?
>>> JM
>>> 
>>> El 24/08/2015, a las 05:44, gerald thomas 
>>> escribió:
>>> 
 Dear Juan,
 Thanks for your responses.
 Sorry i am only responding now but please find the attached category
 combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta  wrote:
> Sorry, I got distracted and hit send before completing the message.
> 
> You should limit the query to show the values of the specific data
> elements
> that are giving you trouble, you'll need the uid of each of the data
> element., In case you don't know how to get that information, you can
> use
> the api (your_server_URL/api/dataElements?paging=false) or look at the
> information if each data element in data element management selecting
> "show
> details" from the contextual menu that appears when clocking on the
> name
> of
> each data element. Then add to the query the list of UIDs just before
> the
> semicolon.
> 
> WHERE de.uid IN
> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
> 
> Please excuse me if you already know all of these things, since I don't
> have
> a way to know how much you know about the system and postgres queries I
> rather be detailed on what you have to do than leave you guessing.
> 
> In addition to running maintenance to update category option
> combinations
> you should re-generate resource tables, you'll find that in "Data
> Administration" too.
> 
> 
> Regards,
> JM
> 
> 
> 
> El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
>  escribió:
> 
>> Hi Gerald
>> I see you are missing a few category option combo names, you should
>> run
>> the maintenance to "Update category option combinations", you'll find
>> this
>> in "Data Administration" -> "maintenance"
>> I also don't see the option combinations of the data elements you
>> highlighted in the excel you sent to the list. Which category
>> combination
>> are you using with those data elements? Run the query again after
>> doing
>> the maintenance.
>> 
>> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs
>> 
>> About the out of memory error, I recommend that you use pgAdmin3 and
>> try
>> to run the query again. You should limit the query to show you the
>> data
>> 
>> El 23/08/2015, a las 15:39, gerald thomas 
>> escribió:
>> 
>>> Dear Juan,
>>> For the datavalues query; i am getting "Out of memory" as result.
>>> Please find the attached result for the combo query.
>>> 
>>> On 8/23/15, Juan Manuel Alcantara Acosta 
>>> wrote:
 Hello Gerald
 Does data disappear only from data elements that use the default
 category
 combination?
 Since you are querying your database directly, I'm sending you here
 a
 couple
 of queries you can use to verify the existing values of the database
 and
 the
 category combinations. Check if you have more than one default
 option
 combination.
 
 Regards,
 JM
 
 
 
 
 
 
 El 23/08/2015, a las 11:36, gerald thomas 
 escribió:
 
> Juan,
> Thanks for your response but we are not using custom forms for data
> entry.
> 
> Regards,
> Gerald
> 
> On Aug 23, 2015 4:29 PM, "Juan Manuel Alcantara Acosta"
>  wrote:
> Hello Gerald
> Are you using custom forms for data entry?
> JM
> El 22/08/2015, a las 15:37, gerald thomas 
> escribió:
> 
>> Dear dhis2-users,
>> If someone cannot help me; can anyone explain why am i having data
>> for
>> October, November, December 2015 on my database?
>> 
>> dhis=# select * from period where startdate > '2015-01-01';
>> periodid | periodty

[Dhis2-devs] java 8 now required for dhis snapshot version

[Lars Helge Øverland]

Hi,

we have now set the compiler target version to 1.8 in the source code,
meaning you will need Java 8 installed in order to build and deploy DHIS 2
trunk.

If you are on Ubuntu 14.04 LTS you may want to use Oracle Java 8,
instructions for installing through webup8 here
.
OpenJDK 8 should be available for most other OS, on linux you can install
with package name "openjdk-8-jdk".

If necessary, make sure you update env variables (JAVA_HOME) and make sure
maven builds with Java 8.

If using Eclipse you need to add the JDK/JRE from window - preferences -
installed JREs.

Note that the "perm gen" space has been removed in favor of metaspace
, meaning the
"XX:PermSize" and "XX:MaxPermSize" java opts no longer have any impact.


regards,

Lars


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-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 19835: Set compiler target version to 1.8. Java 8 is now required to build and deploy trunk.

[noreply]

revno: 19835
committer: Lars Helge Overland 
branch nick: dhis2
timestamp: Mon 2015-08-24 15:04:55 +0200
message:
  Set compiler target version to 1.8. Java 8 is now required to build and 
deploy trunk.
modified:
  dhis-2/pom.xml


--
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/pom.xml'
--- dhis-2/pom.xml	2015-08-24 04:55:24 +
+++ dhis-2/pom.xml	2015-08-24 13:04:55 +
@@ -183,8 +183,8 @@
   maven-compiler-plugin
   2.3.2
   
-1.7
-1.7
+1.8
+1.8
 ${project.build.sourceEncoding}
   
 

___
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] Data Loss

[Juan Manuel Alcantara Acosta]

Select "Update category option combinations" and click on  "perform 
maintenance". After that finished select from the menu of the left "Resource 
Table" and click on "Generate tables".
Regards,
JM

El 24/08/2015, a las 08:00, gerald thomas  escribió:

> Dear Juan,
> Under Maintenance column i am seeing the following:
> 
> Clear analytics tables
> 
> Clear data mart
> 
> Rebuild data mart index
> 
> Clear zero values
> 
> Clear data set completeness
> 
> Prune periods
> 
> Remove expired invitations
> 
> Drop SQL views
> 
> Create SQL views
> 
> Update category option combinations
> 
> What should I check for the performance maintenance before doing the
> query again?
> 
> On 8/24/15, gerald thomas  wrote:
>> Dear Juan,
>> No!!! This is the holistic data from that query. Previously i only had
>> the first part of the result. Do you want me to rebuild tables and run
>> query again?
>> 
>> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
>>> Hello Gerald
>>> This looks much different than the fist one you sent me and it's still
>>> missing a lot of names, did you rebuild resource tables?
>>> JM
>>> 
>>> El 24/08/2015, a las 05:44, gerald thomas 
>>> escribió:
>>> 
 Dear Juan,
 Thanks for your responses.
 Sorry i am only responding now but please find the attached category
 combo query.
 
 On 8/23/15, Juan Manuel Alcantara Acosta  wrote:
> Sorry, I got distracted and hit send before completing the message.
> 
> You should limit the query to show the values of the specific data
> elements
> that are giving you trouble, you'll need the uid of each of the data
> element., In case you don't know how to get that information, you can
> use
> the api (your_server_URL/api/dataElements?paging=false) or look at the
> information if each data element in data element management selecting
> "show
> details" from the contextual menu that appears when clocking on the
> name
> of
> each data element. Then add to the query the list of UIDs just before
> the
> semicolon.
> 
> WHERE de.uid IN
> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
> 
> Please excuse me if you already know all of these things, since I don't
> have
> a way to know how much you know about the system and postgres queries I
> rather be detailed on what you have to do than leave you guessing.
> 
> In addition to running maintenance to update category option
> combinations
> you should re-generate resource tables, you'll find that in "Data
> Administration" too.
> 
> 
> Regards,
> JM
> 
> 
> 
> El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
>  escribió:
> 
>> Hi Gerald
>> I see you are missing a few category option combo names, you should
>> run
>> the maintenance to "Update category option combinations", you'll find
>> this
>> in "Data Administration" -> "maintenance"
>> I also don't see the option combinations of the data elements you
>> highlighted in the excel you sent to the list. Which category
>> combination
>> are you using with those data elements? Run the query again after
>> doing
>> the maintenance.
>> 
>> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs
>> 
>> About the out of memory error, I recommend that you use pgAdmin3 and
>> try
>> to run the query again. You should limit the query to show you the
>> data
>> 
>> El 23/08/2015, a las 15:39, gerald thomas 
>> escribió:
>> 
>>> Dear Juan,
>>> For the datavalues query; i am getting "Out of memory" as result.
>>> Please find the attached result for the combo query.
>>> 
>>> On 8/23/15, Juan Manuel Alcantara Acosta 
>>> wrote:
 Hello Gerald
 Does data disappear only from data elements that use the default
 category
 combination?
 Since you are querying your database directly, I'm sending you here
 a
 couple
 of queries you can use to verify the existing values of the database
 and
 the
 category combinations. Check if you have more than one default
 option
 combination.
 
 Regards,
 JM
 
 
 
 
 
 
 El 23/08/2015, a las 11:36, gerald thomas 
 escribió:
 
> Juan,
> Thanks for your response but we are not using custom forms for data
> entry.
> 
> Regards,
> Gerald
> 
> On Aug 23, 2015 4:29 PM, "Juan Manuel Alcantara Acosta"
>  wrote:
> Hello Gerald
> Are you using custom forms for data entry?
> JM
> El 22/08/2015, a las 15:37, gerald thomas 
> escribió:
> 
>> Dear dhis2-users,
>> If someone cannot help me; can anyone explain why am i ha

[Dhis2-devs] [Bug 1297793] Re: Unable to load the data entry page for a user

[Lars Helge Øverland]

Hi, can you check that the relevant category combo (with uid hpgMJ5bmcBq
) has public read sharing?

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

Title:
  Unable to load the data entry page for a user

Status in DHIS:
  New

Bug description:
  Environment details: Trunk build of DHIS 2.

  Steps to reproduce:

  1. Create a category option, category and category combo called "Number of 
cases". 
  2. Create a data element called "Shock" with category combination as "Number 
of cases" and of type aggregate and numeric. 
  3. Create a data set called "Cause", assign the data element "Shock" and 
select Weekly as the frequency.
  4. Create a role called "Data entry person" and assign access to the "Cause" 
dataset and authorities "See data entry module", "Delete data value, Add/Update 
data value", "See dashboard integration module".
  5. Create an org unit called "District 1"
  6. Assign the "Cause" data set to the org unit "District 1"
  7. Create a user called "entry1" with role "Data entry person" and assign 
access to the org unit "District 1"
  8. Login as entry1 and go to data entry screen.

  The following error is reported in the log - "* INFO  2014-03-26
  16:21:34,331 'entry1' read denied
  org.hisp.dhis.dataelement.DataElementCategoryCombo_$$_javassist_82,
  name: default, uid: hpgMJ5bmcBq (AuditLogUtil.java
  [1691071275@qtp-1792399744-20])"

  9. Select the "Cause" data set and a week. Enter a number for the Shock data 
element and hit "Complete".
  10.  Gives the message that data is saved offline although I am online.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1297793/+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] Data Loss

[gerald thomas]

Dear Juan,
Noted!!! It is now generating resource table and i will keep you
posted once it had been completed

On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
> Select "Update category option combinations" and click on  "perform
> maintenance". After that finished select from the menu of the left "Resource
> Table" and click on "Generate tables".
> Regards,
> JM
>
> El 24/08/2015, a las 08:00, gerald thomas  escribió:
>
>> Dear Juan,
>> Under Maintenance column i am seeing the following:
>>
>> Clear analytics tables
>>
>> Clear data mart
>>
>> Rebuild data mart index
>>
>> Clear zero values
>>
>> Clear data set completeness
>>
>> Prune periods
>>
>> Remove expired invitations
>>
>> Drop SQL views
>>
>> Create SQL views
>>
>> Update category option combinations
>>
>> What should I check for the performance maintenance before doing the
>> query again?
>>
>> On 8/24/15, gerald thomas  wrote:
>>> Dear Juan,
>>> No!!! This is the holistic data from that query. Previously i only had
>>> the first part of the result. Do you want me to rebuild tables and run
>>> query again?
>>>
>>> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
 Hello Gerald
 This looks much different than the fist one you sent me and it's still
 missing a lot of names, did you rebuild resource tables?
 JM

 El 24/08/2015, a las 05:44, gerald thomas 
 escribió:

> Dear Juan,
> Thanks for your responses.
> Sorry i am only responding now but please find the attached category
> combo query.
>
> On 8/23/15, Juan Manuel Alcantara Acosta 
> wrote:
>> Sorry, I got distracted and hit send before completing the message.
>>
>> You should limit the query to show the values of the specific data
>> elements
>> that are giving you trouble, you'll need the uid of each of the data
>> element., In case you don't know how to get that information, you can
>> use
>> the api (your_server_URL/api/dataElements?paging=false) or look at
>> the
>> information if each data element in data element management selecting
>> "show
>> details" from the contextual menu that appears when clocking on the
>> name
>> of
>> each data element. Then add to the query the list of UIDs just before
>> the
>> semicolon.
>>
>> WHERE de.uid IN
>> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
>>
>> Please excuse me if you already know all of these things, since I
>> don't
>> have
>> a way to know how much you know about the system and postgres queries
>> I
>> rather be detailed on what you have to do than leave you guessing.
>>
>> In addition to running maintenance to update category option
>> combinations
>> you should re-generate resource tables, you'll find that in "Data
>> Administration" too.
>>
>>
>> Regards,
>> JM
>>
>>
>>
>> El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
>>  escribió:
>>
>>> Hi Gerald
>>> I see you are missing a few category option combo names, you should
>>> run
>>> the maintenance to "Update category option combinations", you'll
>>> find
>>> this
>>> in "Data Administration" -> "maintenance"
>>> I also don't see the option combinations of the data elements you
>>> highlighted in the excel you sent to the list. Which category
>>> combination
>>> are you using with those data elements? Run the query again after
>>> doing
>>> the maintenance.
>>>
>>> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs
>>>
>>> About the out of memory error, I recommend that you use pgAdmin3 and
>>> try
>>> to run the query again. You should limit the query to show you the
>>> data
>>>
>>> El 23/08/2015, a las 15:39, gerald thomas 
>>> escribió:
>>>
 Dear Juan,
 For the datavalues query; i am getting "Out of memory" as result.
 Please find the attached result for the combo query.

 On 8/23/15, Juan Manuel Alcantara Acosta 
 wrote:
> Hello Gerald
> Does data disappear only from data elements that use the default
> category
> combination?
> Since you are querying your database directly, I'm sending you
> here
> a
> couple
> of queries you can use to verify the existing values of the
> database
> and
> the
> category combinations. Check if you have more than one default
> option
> combination.
>
> Regards,
> JM
>
>
>
>
>
>
> El 23/08/2015, a las 11:36, gerald thomas 
> escribió:
>
>> Juan,
>> Thanks for your response but we are not using custom forms for
>> data
>> entry.
>>
>> Regards,
>> Gerald
>>
>>

Re: [Dhis2-devs] [Dhis2-users] Data Loss

[gerald thomas]

Dear Juan,
Please find the attached updated combo query.

On 8/24/15, gerald thomas  wrote:
> Dear Juan,
> Noted!!! It is now generating resource table and i will keep you
> posted once it had been completed
>
> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
>> Select "Update category option combinations" and click on  "perform
>> maintenance". After that finished select from the menu of the left
>> "Resource
>> Table" and click on "Generate tables".
>> Regards,
>> JM
>>
>> El 24/08/2015, a las 08:00, gerald thomas 
>> escribió:
>>
>>> Dear Juan,
>>> Under Maintenance column i am seeing the following:
>>>
>>> Clear analytics tables
>>>
>>> Clear data mart
>>>
>>> Rebuild data mart index
>>>
>>> Clear zero values
>>>
>>> Clear data set completeness
>>>
>>> Prune periods
>>>
>>> Remove expired invitations
>>>
>>> Drop SQL views
>>>
>>> Create SQL views
>>>
>>> Update category option combinations
>>>
>>> What should I check for the performance maintenance before doing the
>>> query again?
>>>
>>> On 8/24/15, gerald thomas  wrote:
 Dear Juan,
 No!!! This is the holistic data from that query. Previously i only had
 the first part of the result. Do you want me to rebuild tables and run
 query again?

 On 8/24/15, Juan Manuel Alcantara Acosta 
 wrote:
> Hello Gerald
> This looks much different than the fist one you sent me and it's still
> missing a lot of names, did you rebuild resource tables?
> JM
>
> El 24/08/2015, a las 05:44, gerald thomas 
> escribió:
>
>> Dear Juan,
>> Thanks for your responses.
>> Sorry i am only responding now but please find the attached category
>> combo query.
>>
>> On 8/23/15, Juan Manuel Alcantara Acosta 
>> wrote:
>>> Sorry, I got distracted and hit send before completing the message.
>>>
>>> You should limit the query to show the values of the specific data
>>> elements
>>> that are giving you trouble, you'll need the uid of each of the data
>>> element., In case you don't know how to get that information, you
>>> can
>>> use
>>> the api (your_server_URL/api/dataElements?paging=false) or look at
>>> the
>>> information if each data element in data element management
>>> selecting
>>> "show
>>> details" from the contextual menu that appears when clocking on the
>>> name
>>> of
>>> each data element. Then add to the query the list of UIDs just
>>> before
>>> the
>>> semicolon.
>>>
>>> WHERE de.uid IN
>>> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
>>>
>>> Please excuse me if you already know all of these things, since I
>>> don't
>>> have
>>> a way to know how much you know about the system and postgres
>>> queries
>>> I
>>> rather be detailed on what you have to do than leave you guessing.
>>>
>>> In addition to running maintenance to update category option
>>> combinations
>>> you should re-generate resource tables, you'll find that in "Data
>>> Administration" too.
>>>
>>>
>>> Regards,
>>> JM
>>>
>>>
>>>
>>> El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
>>>  escribió:
>>>
 Hi Gerald
 I see you are missing a few category option combo names, you should
 run
 the maintenance to "Update category option combinations", you'll
 find
 this
 in "Data Administration" -> "maintenance"
 I also don't see the option combinations of the data elements you
 highlighted in the excel you sent to the list. Which category
 combination
 are you using with those data elements? Run the query again after
 doing
 the maintenance.

 <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs

 About the out of memory error, I recommend that you use pgAdmin3
 and
 try
 to run the query again. You should limit the query to show you the
 data

 El 23/08/2015, a las 15:39, gerald thomas 
 escribió:

> Dear Juan,
> For the datavalues query; i am getting "Out of memory" as result.
> Please find the attached result for the combo query.
>
> On 8/23/15, Juan Manuel Alcantara Acosta 
> wrote:
>> Hello Gerald
>> Does data disappear only from data elements that use the default
>> category
>> combination?
>> Since you are querying your database directly, I'm sending you
>> here
>> a
>> couple
>> of queries you can use to verify the existing values of the
>> database
>> and
>> the
>> category combinations. Check if you have more than one default
>> option
>> combination.
>>
>> Regards,
>> JM
>>
>>
>>
>>

Re: [Dhis2-devs] [Dhis2-users] Data Loss

[Juan Manuel Alcantara Acosta]

Hello Gerald
What was the result of the datavalue query?
You should also check the sharing settings of the data elements that are giving 
you trouble.
JM
El 24/08/2015, a las 08:43, gerald thomas  escribió:

> Dear Juan,
> Please find the attached updated combo query.
> 
> On 8/24/15, gerald thomas  wrote:
>> Dear Juan,
>> Noted!!! It is now generating resource table and i will keep you
>> posted once it had been completed
>> 
>> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
>>> Select "Update category option combinations" and click on  "perform
>>> maintenance". After that finished select from the menu of the left
>>> "Resource
>>> Table" and click on "Generate tables".
>>> Regards,
>>> JM
>>> 
>>> El 24/08/2015, a las 08:00, gerald thomas 
>>> escribió:
>>> 
 Dear Juan,
 Under Maintenance column i am seeing the following:
 
 Clear analytics tables
 
 Clear data mart
 
 Rebuild data mart index
 
 Clear zero values
 
 Clear data set completeness
 
 Prune periods
 
 Remove expired invitations
 
 Drop SQL views
 
 Create SQL views
 
 Update category option combinations
 
 What should I check for the performance maintenance before doing the
 query again?
 
 On 8/24/15, gerald thomas  wrote:
> Dear Juan,
> No!!! This is the holistic data from that query. Previously i only had
> the first part of the result. Do you want me to rebuild tables and run
> query again?
> 
> On 8/24/15, Juan Manuel Alcantara Acosta 
> wrote:
>> Hello Gerald
>> This looks much different than the fist one you sent me and it's still
>> missing a lot of names, did you rebuild resource tables?
>> JM
>> 
>> El 24/08/2015, a las 05:44, gerald thomas 
>> escribió:
>> 
>>> Dear Juan,
>>> Thanks for your responses.
>>> Sorry i am only responding now but please find the attached category
>>> combo query.
>>> 
>>> On 8/23/15, Juan Manuel Alcantara Acosta 
>>> wrote:
 Sorry, I got distracted and hit send before completing the message.
 
 You should limit the query to show the values of the specific data
 elements
 that are giving you trouble, you'll need the uid of each of the data
 element., In case you don't know how to get that information, you
 can
 use
 the api (your_server_URL/api/dataElements?paging=false) or look at
 the
 information if each data element in data element management
 selecting
 "show
 details" from the contextual menu that appears when clocking on the
 name
 of
 each data element. Then add to the query the list of UIDs just
 before
 the
 semicolon.
 
 WHERE de.uid IN
 ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
 
 Please excuse me if you already know all of these things, since I
 don't
 have
 a way to know how much you know about the system and postgres
 queries
 I
 rather be detailed on what you have to do than leave you guessing.
 
 In addition to running maintenance to update category option
 combinations
 you should re-generate resource tables, you'll find that in "Data
 Administration" too.
 
 
 Regards,
 JM
 
 
 
 El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
  escribió:
 
> Hi Gerald
> I see you are missing a few category option combo names, you should
> run
> the maintenance to "Update category option combinations", you'll
> find
> this
> in "Data Administration" -> "maintenance"
> I also don't see the option combinations of the data elements you
> highlighted in the excel you sent to the list. Which category
> combination
> are you using with those data elements? Run the query again after
> doing
> the maintenance.
> 
> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs
> 
> About the out of memory error, I recommend that you use pgAdmin3
> and
> try
> to run the query again. You should limit the query to show you the
> data
> 
> El 23/08/2015, a las 15:39, gerald thomas 
> escribió:
> 
>> Dear Juan,
>> For the datavalues query; i am getting "Out of memory" as result.
>> Please find the attached result for the combo query.
>> 
>> On 8/23/15, Juan Manuel Alcantara Acosta 
>> wrote:
>>> Hello Gerald
>>> Does data disappear only from data elements that use the default
>>> category
>>> combination?
>>> Since you are querying your databas

Re: [Dhis2-devs] Problems in generating Resource Tables

[Victor Garcia]

Hi,

we have experienced the same problem in our dhis instances (using
version 2.18), and also about 10th August. We have no idea about the
reason, but it would be good to find it out so we can know if it is
going to happen again in the future.

To solve the issue, try with:

1. In Data Administration -> Maintenance, execute Prune Periods.
2. In Data Administration -> Cache Statistics, execute Clear Cache.
3. Try to generate resource tables again.

Hope this helps.

On 23 August 2015 at 02:59, Juma Lungo  wrote:
> Hi
>
> DHIS2 v2.18 is failing to generate Resource Tables. The instance has been
> working fine for a year - since August 2014. However, It has stopped
> generating these tables on the 10th August 2015. As a result, all newly
> entered data can not be seen in the reports.
>
> Please help. Should I just delete the duplicating records in the
> "_periodstructure" table?
>
>
> Here is the error message.
> 2015-08-23 06:59:49Process failed: PreparedStatementCallback; SQL
> [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
> duplicate key value violates unique constraint "in_periodstructure_iso"
> Detail: Key (iso)=(2014Q3) already exists.; nested exception is
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> unique constraint "in_periodstructure_iso" Detail: Key (iso)=(2014Q3)
> already exists.
> 2015-08-23 06:59:44Generating resource tables
>
> ___
> 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
>

___
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] Problems in generating Resource Tables

[Lars Helge Øverland]

Hi Victor,

we believe this error is related to the calendar solution and the server
timezone settings.

We have made a fix for this in 2.19 so you should be good by upgrading your
instance.

regards,

Lars


On Mon, Aug 24, 2015 at 4:03 PM, Victor Garcia  wrote:

> Hi,
>
> we have experienced the same problem in our dhis instances (using
> version 2.18), and also about 10th August. We have no idea about the
> reason, but it would be good to find it out so we can know if it is
> going to happen again in the future.
>
> To solve the issue, try with:
>
> 1. In Data Administration -> Maintenance, execute Prune Periods.
> 2. In Data Administration -> Cache Statistics, execute Clear Cache.
> 3. Try to generate resource tables again.
>
> Hope this helps.
>
> On 23 August 2015 at 02:59, Juma Lungo  wrote:
> > Hi
> >
> > DHIS2 v2.18 is failing to generate Resource Tables. The instance has been
> > working fine for a year - since August 2014. However, It has stopped
> > generating these tables on the 10th August 2015. As a result, all newly
> > entered data can not be seen in the reports.
> >
> > Please help. Should I just delete the duplicating records in the
> > "_periodstructure" table?
> >
> >
> > Here is the error message.
> > 2015-08-23 06:59:49Process failed: PreparedStatementCallback; SQL
> > [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)];
> ERROR:
> > duplicate key value violates unique constraint "in_periodstructure_iso"
> > Detail: Key (iso)=(2014Q3) already exists.; nested exception is
> > org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> > unique constraint "in_periodstructure_iso" Detail: Key (iso)=(2014Q3)
> > already exists.
> > 2015-08-23 06:59:44Generating resource tables
> >
> > ___
> > 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
> >
>
> ___
> 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
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Node.js Question for Updating Sharing Settings

[Timothy Harding]

Hello DHIS2 Devs,

I've got a script that works pretty well for updating a bunch of sharing
settings for various objects using node.js. The only problem is, I am
getting timeouts when the object update counts get too high (500+).

I am a bit new to the asynchronous nature of node.js, and I like that I can
bundle a lot of updates into one without needing to worry that I need a
response for one before sending the request for the next. The downside is,
I have no idea where to put the sleep timer to slow down the volume of
requests. Everywhere I've put it so far increases the timeouts, rather than
decreases them. I know there are some node.js experts out there on the
DHIS2 dev list so, perhaps someone has run into something similar:

var serverConfigPOST = serverConfig;
serverConfigPOST.dhis2server.method = "POST";
var i=0;
for(i=0; i < dataElementsToUpdate.length; i++){

Tried here
var postData = JSON.stringify(dataElementsToUpdate[i]);
serverConfigPOST.dhis2server.path =
"/dhis/api/sharing?type=dataElement&id=" + dataElementsToUpdate[i].object.id
;
serverConfigPOST.dhis2server.headers = {
'Content-Type': 'application/json',
'Content-Length': postData.length
};
console.log(serverConfigPOST);
var req = https.request(serverConfigPOST.dhis2server, function(res) {
console.log('STATUS: ' + res.statusCode);
console.log('HEADERS: ' + JSON.stringify(res.headers));
res.setEncoding('utf8');
res.on('data', function (chunk) {
console.log('BODY: ' + chunk);
});
});
req.on('error', function(e) {
//console.log('problem with request: ' + e.message);
});
// write data to request body
req.write(postData);
req.end();

Tried here
// if(i==20){
// break;
// }
}

Not quite sure how to slow this one down, I may just have to run/rerun it
with different starting and stopping i values in the mean time.

Timothy Harding
RPCV Vanuatu
Skype: hardi...@gmail.com
+1 (541) 632-6623
___
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 19836: GIS layer order + plugin.

[noreply]

revno: 19836
committer: Jan Henrik Overland 
branch nick: dhis2
timestamp: Mon 2015-08-24 16:51:10 +0200
message:
  GIS layer order + plugin.
modified:
  dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/app.js
  dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/core.js
  dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/map.js
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/plugin/map.js
  
dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/webapp/dhis-web-dashboard-integration/plugin/map.js
The size of the diff (12655 lines) is larger than your specified limit of 5000 
lines

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

___
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] Data Loss

[gerald thomas]

Dear Juan,
I am still having issues with datavalue query. Please can you help me
by checking the query again.
It is still giving

On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
> Hello Gerald
> What was the result of the datavalue query?
> You should also check the sharing settings of the data elements that are
> giving you trouble.
> JM
> El 24/08/2015, a las 08:43, gerald thomas  escribió:
>
>> Dear Juan,
>> Please find the attached updated combo query.
>>
>> On 8/24/15, gerald thomas  wrote:
>>> Dear Juan,
>>> Noted!!! It is now generating resource table and i will keep you
>>> posted once it had been completed
>>>
>>> On 8/24/15, Juan Manuel Alcantara Acosta  wrote:
 Select "Update category option combinations" and click on  "perform
 maintenance". After that finished select from the menu of the left
 "Resource
 Table" and click on "Generate tables".
 Regards,
 JM

 El 24/08/2015, a las 08:00, gerald thomas 
 escribió:

> Dear Juan,
> Under Maintenance column i am seeing the following:
>
> Clear analytics tables
>
> Clear data mart
>
> Rebuild data mart index
>
> Clear zero values
>
> Clear data set completeness
>
> Prune periods
>
> Remove expired invitations
>
> Drop SQL views
>
> Create SQL views
>
> Update category option combinations
>
> What should I check for the performance maintenance before doing the
> query again?
>
> On 8/24/15, gerald thomas  wrote:
>> Dear Juan,
>> No!!! This is the holistic data from that query. Previously i only
>> had
>> the first part of the result. Do you want me to rebuild tables and
>> run
>> query again?
>>
>> On 8/24/15, Juan Manuel Alcantara Acosta 
>> wrote:
>>> Hello Gerald
>>> This looks much different than the fist one you sent me and it's
>>> still
>>> missing a lot of names, did you rebuild resource tables?
>>> JM
>>>
>>> El 24/08/2015, a las 05:44, gerald thomas 
>>> escribió:
>>>
 Dear Juan,
 Thanks for your responses.
 Sorry i am only responding now but please find the attached
 category
 combo query.

 On 8/23/15, Juan Manuel Alcantara Acosta 
 wrote:
> Sorry, I got distracted and hit send before completing the
> message.
>
> You should limit the query to show the values of the specific data
> elements
> that are giving you trouble, you'll need the uid of each of the
> data
> element., In case you don't know how to get that information, you
> can
> use
> the api (your_server_URL/api/dataElements?paging=false) or look at
> the
> information if each data element in data element management
> selecting
> "show
> details" from the contextual menu that appears when clocking on
> the
> name
> of
> each data element. Then add to the query the list of UIDs just
> before
> the
> semicolon.
>
> WHERE de.uid IN
> ('UID1','UID2','UID3','UID4','UID5','UID6','UID7','UID8','UID9','UID10')
>
> Please excuse me if you already know all of these things, since I
> don't
> have
> a way to know how much you know about the system and postgres
> queries
> I
> rather be detailed on what you have to do than leave you guessing.
>
> In addition to running maintenance to update category option
> combinations
> you should re-generate resource tables, you'll find that in "Data
> Administration" too.
>
>
> Regards,
> JM
>
>
>
> El 23/08/2015, a las 16:18, Juan Manuel Alcantara Acosta
>  escribió:
>
>> Hi Gerald
>> I see you are missing a few category option combo names, you
>> should
>> run
>> the maintenance to "Update category option combinations", you'll
>> find
>> this
>> in "Data Administration" -> "maintenance"
>> I also don't see the option combinations of the data elements you
>> highlighted in the excel you sent to the list. Which category
>> combination
>> are you using with those data elements? Run the query again after
>> doing
>> the maintenance.
>>
>> <15 yrs, 15-24yrs, 25-34yrs, 35-44yrs, 45-49yrs, >49yrs
>>
>> About the out of memory error, I recommend that you use pgAdmin3
>> and
>> try
>> to run the query again. You should limit the query to show you
>> the
>> data
>>
>> El 23/08/2015, a las 15:39, gerald thomas 
>> escribió:
>>
>>> Dear Juan,
>>> For the datavalues query; i

Re: [Dhis2-devs] Problems in generating Resource Tables

[Victor Garcia]

Thanks Lars. So this could be a good reason to think about moving to 2.19.

regards,

Víctor

On 24 August 2015 at 09:10, Lars Helge Øverland  wrote:
> Hi Victor,
>
> we believe this error is related to the calendar solution and the server
> timezone settings.
>
> We have made a fix for this in 2.19 so you should be good by upgrading your
> instance.
>
> regards,
>
> Lars
>
>
> On Mon, Aug 24, 2015 at 4:03 PM, Victor Garcia  wrote:
>>
>> Hi,
>>
>> we have experienced the same problem in our dhis instances (using
>> version 2.18), and also about 10th August. We have no idea about the
>> reason, but it would be good to find it out so we can know if it is
>> going to happen again in the future.
>>
>> To solve the issue, try with:
>>
>> 1. In Data Administration -> Maintenance, execute Prune Periods.
>> 2. In Data Administration -> Cache Statistics, execute Clear Cache.
>> 3. Try to generate resource tables again.
>>
>> Hope this helps.
>>
>> On 23 August 2015 at 02:59, Juma Lungo  wrote:
>> > Hi
>> >
>> > DHIS2 v2.18 is failing to generate Resource Tables. The instance has
>> > been
>> > working fine for a year - since August 2014. However, It has stopped
>> > generating these tables on the 10th August 2015. As a result, all newly
>> > entered data can not be seen in the reports.
>> >
>> > Please help. Should I just delete the duplicating records in the
>> > "_periodstructure" table?
>> >
>> >
>> > Here is the error message.
>> > 2015-08-23 06:59:49Process failed: PreparedStatementCallback; SQL
>> > [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)];
>> > ERROR:
>> > duplicate key value violates unique constraint "in_periodstructure_iso"
>> > Detail: Key (iso)=(2014Q3) already exists.; nested exception is
>> > org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> > unique constraint "in_periodstructure_iso" Detail: Key (iso)=(2014Q3)
>> > already exists.
>> > 2015-08-23 06:59:44Generating resource tables
>> >
>> > ___
>> > 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
>> >
>>
>> ___
>> 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
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org
>

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

Re: [Dhis2-devs] Problems in generating Resource Tables

[Lars Helge Øverland]

Yes, at least you could set it up on a test server and see if it fixes the
problem.
On Aug 24, 2015 5:21 PM, "Victor Garcia"  wrote:

> Thanks Lars. So this could be a good reason to think about moving to 2.19.
>
> regards,
>
> Víctor
>
> On 24 August 2015 at 09:10, Lars Helge Øverland 
> wrote:
> > Hi Victor,
> >
> > we believe this error is related to the calendar solution and the server
> > timezone settings.
> >
> > We have made a fix for this in 2.19 so you should be good by upgrading
> your
> > instance.
> >
> > regards,
> >
> > Lars
> >
> >
> > On Mon, Aug 24, 2015 at 4:03 PM, Victor Garcia 
> wrote:
> >>
> >> Hi,
> >>
> >> we have experienced the same problem in our dhis instances (using
> >> version 2.18), and also about 10th August. We have no idea about the
> >> reason, but it would be good to find it out so we can know if it is
> >> going to happen again in the future.
> >>
> >> To solve the issue, try with:
> >>
> >> 1. In Data Administration -> Maintenance, execute Prune Periods.
> >> 2. In Data Administration -> Cache Statistics, execute Clear Cache.
> >> 3. Try to generate resource tables again.
> >>
> >> Hope this helps.
> >>
> >> On 23 August 2015 at 02:59, Juma Lungo  wrote:
> >> > Hi
> >> >
> >> > DHIS2 v2.18 is failing to generate Resource Tables. The instance has
> >> > been
> >> > working fine for a year - since August 2014. However, It has stopped
> >> > generating these tables on the 10th August 2015. As a result, all
> newly
> >> > entered data can not be seen in the reports.
> >> >
> >> > Please help. Should I just delete the duplicating records in the
> >> > "_periodstructure" table?
> >> >
> >> >
> >> > Here is the error message.
> >> > 2015-08-23 06:59:49Process failed: PreparedStatementCallback; SQL
> >> > [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)];
> >> > ERROR:
> >> > duplicate key value violates unique constraint
> "in_periodstructure_iso"
> >> > Detail: Key (iso)=(2014Q3) already exists.; nested exception is
> >> > org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> >> > unique constraint "in_periodstructure_iso" Detail: Key (iso)=(2014Q3)
> >> > already exists.
> >> > 2015-08-23 06:59:44Generating resource tables
> >> >
> >> > ___
> >> > 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
> >> >
> >>
> >> ___
> >> 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
> >
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > http://www.dhis2.org
> >
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-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 19837: GIS minor select handler bug fixes.

[noreply]

revno: 19837
committer: Jan Henrik Overland 
branch nick: dhis2
timestamp: Mon 2015-08-24 18:07:14 +0200
message:
  GIS minor select handler bug fixes.
modified:
  dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/plugin.html
  dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/core.js
  dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/map.js
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/plugin/map.js
  
dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/webapp/dhis-web-dashboard-integration/plugin/map.js


--
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-mapping/plugin.html'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/plugin.html	2015-08-05 15:16:32 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/plugin.html	2015-08-24 16:07:14 +
@@ -34,6 +34,7 @@
 el: "map1",
 id: "jzxTpTUdISq",
 crossDomain: false,
+dashboard: true,
 mapViews: [{
 userOrgUnit: ['fdc6uOvgoji']
 }]

=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/core.js'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/core.js	2015-08-24 14:51:10 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/core.js	2015-08-24 16:07:14 +
@@ -265,13 +265,13 @@
 			});
 
 			defaultHoverWindow.show();
-
-			var eastX = gis.viewport.eastRegion.getPosition()[0],
-centerX = gis.viewport.centerRegion.getPosition()[0],
-centerRegionCenterX = centerX + ((eastX - centerX) / 2),
-centerRegionY = gis.viewport.centerRegion.getPosition()[1] + (GIS.app ? 32 : 0);
-
-			defaultHoverWindow.setPosition(centerRegionCenterX - (defaultHoverWindow.getWidth() / 2), centerRegionY);
+
+var cr = gis.viewport.centerRegion,
+crp = cr.getPosition(),
+x = crp[0] + (cr.getWidth() / 2) - (defaultHoverWindow.getWidth() / 2),
+y = crp[1] + (GIS.app ? 32 : 0);
+
+			defaultHoverWindow.setPosition(x, y);
 
 layer.registerMouseDownEvent();
 		};

=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/map.js'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/map.js	2015-08-24 14:51:10 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-mapping/scripts/map.js	2015-08-24 16:07:14 +
@@ -1722,13 +1722,13 @@
 			});
 
 			defaultHoverWindow.show();
-
-			var eastX = gis.viewport.eastRegion.getPosition()[0],
-centerX = gis.viewport.centerRegion.getPosition()[0],
-centerRegionCenterX = centerX + ((eastX - centerX) / 2),
-centerRegionY = gis.viewport.centerRegion.getPosition()[1] + (GIS.app ? 32 : 0);
-
-			defaultHoverWindow.setPosition(centerRegionCenterX - (defaultHoverWindow.getWidth() / 2), centerRegionY);
+
+var cr = gis.viewport.centerRegion,
+crp = cr.getPosition(),
+x = crp[0] + (cr.getWidth() / 2) - (defaultHoverWindow.getWidth() / 2),
+y = crp[1] + (GIS.app ? 32 : 0);
+
+			defaultHoverWindow.setPosition(x, y);
 
 layer.registerMouseDownEvent();
 		};

=== modified file 'dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/plugin/map.js'
--- dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/plugin/map.js	2015-08-24 14:51:10 +
+++ dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/plugin/map.js	2015-08-24 16:07:14 +
@@ -1722,13 +1722,13 @@
 			});
 
 			defaultHoverWindow.show();
-
-			var eastX = gis.viewport.eastRegion.getPosition()[0],
-centerX = gis.viewport.centerRegion.getPosition()[0],
-centerRegionCenterX = centerX + ((eastX - centerX) / 2),
-centerRegionY = gis.viewport.centerRegion.getPosition()[1] + (GIS.app ? 32 : 0);
-
-			defaultHoverWindow.setPosition(centerRegionCenterX - (defaultHoverWindow.getWidth() / 2), centerRegionY);
+
+var cr = gis.viewport.centerRegion,
+crp = cr.getPosition(),
+x = crp[0] + (cr.getWidth() / 2) - (defaultHoverWindow.getWidth() / 2),
+y = crp[1] + (GIS.app ? 32 : 0);
+
+			defaultHoverWindow.setPosition(x, y);
 
 layer.registerMouseDownEvent();
 		};

=== modified file 'dhis-2/dhis-web/dhis-web-dashboard-integration/src/main/webapp/dhis-web-dashboard-integration/plugin/map.js'
--- dhis-2/dhis-web/dhis-web-

Re: [Dhis2-devs] Node.js Question for Updating Sharing Settings

[Pierre Dane]

might be best to try a recursive loop using setInterval or setTimeout with
a configurable value (I.e. a method calling itself) .  or you could look at
the async library to make things synchronous .

On Monday, August 24, 2015, Timothy Harding  wrote:

> Hello DHIS2 Devs,
>
> I've got a script that works pretty well for updating a bunch of sharing
> settings for various objects using node.js. The only problem is, I am
> getting timeouts when the object update counts get too high (500+).
>
> I am a bit new to the asynchronous nature of node.js, and I like that I
> can bundle a lot of updates into one without needing to worry that I need a
> response for one before sending the request for the next. The downside is,
> I have no idea where to put the sleep timer to slow down the volume of
> requests. Everywhere I've put it so far increases the timeouts, rather than
> decreases them. I know there are some node.js experts out there on the
> DHIS2 dev list so, perhaps someone has run into something similar:
>
> var serverConfigPOST = serverConfig;
> serverConfigPOST.dhis2server.method = "POST";
> var i=0;
> for(i=0; i < dataElementsToUpdate.length; i++){
>
> Tried here
> var postData = JSON.stringify(dataElementsToUpdate[i]);
> serverConfigPOST.dhis2server.path =
> "/dhis/api/sharing?type=dataElement&id=" + dataElementsToUpdate[i].
> object.id;
> serverConfigPOST.dhis2server.headers = {
> 'Content-Type': 'application/json',
> 'Content-Length': postData.length
> };
> console.log(serverConfigPOST);
> var req = https.request(serverConfigPOST.dhis2server, function(res) {
> console.log('STATUS: ' + res.statusCode);
> console.log('HEADERS: ' + JSON.stringify(res.headers));
> res.setEncoding('utf8');
> res.on('data', function (chunk) {
> console.log('BODY: ' + chunk);
> });
> });
> req.on('error', function(e) {
> //console.log('problem with request: ' + e.message);
> });
> // write data to request body
> req.write(postData);
> req.end();
>
> Tried here
> // if(i==20){
> // break;
> // }
> }
>
> Not quite sure how to slow this one down, I may just have to run/rerun it
> with different starting and stopping i values in the mean time.
>
> Timothy Harding
> RPCV Vanuatu
> Skype: hardi...@gmail.com
> 
> +1 (541) 632-6623
>


-- 
Pierre Dane

Development Manager
Jembi Health Systems
___
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] Node.js Question for Updating Sharing Settings

[Timothy Harding]

Thanks Pierre,

Not sure how I would set up the recursive loop in javascript, I had heard
about async from stack overflow as well, I was thinking of trying that, but
I kind of like how quickly this works, not needing to wait for the response
from one request before sending the next. The DHIS2 hardware I am working
with just doesn't seem to keep up after a certain number of requests
however, hence my attempt to slow them down.

Timothy Harding
RPCV Vanuatu
Skype: hardi...@gmail.com
+1 (541) 632-6623

On Mon, Aug 24, 2015 at 9:39 AM, Pierre Dane  wrote:

> might be best to try a recursive loop using setInterval or setTimeout with
> a configurable value (I.e. a method calling itself) .  or you could look at
> the async library to make things synchronous .
>
>
> On Monday, August 24, 2015, Timothy Harding  wrote:
>
>> Hello DHIS2 Devs,
>>
>> I've got a script that works pretty well for updating a bunch of sharing
>> settings for various objects using node.js. The only problem is, I am
>> getting timeouts when the object update counts get too high (500+).
>>
>> I am a bit new to the asynchronous nature of node.js, and I like that I
>> can bundle a lot of updates into one without needing to worry that I need a
>> response for one before sending the request for the next. The downside is,
>> I have no idea where to put the sleep timer to slow down the volume of
>> requests. Everywhere I've put it so far increases the timeouts, rather than
>> decreases them. I know there are some node.js experts out there on the
>> DHIS2 dev list so, perhaps someone has run into something similar:
>>
>> var serverConfigPOST = serverConfig;
>> serverConfigPOST.dhis2server.method = "POST";
>> var i=0;
>> for(i=0; i < dataElementsToUpdate.length; i++){
>>
>> Tried here
>> var postData = JSON.stringify(dataElementsToUpdate[i]);
>> serverConfigPOST.dhis2server.path =
>> "/dhis/api/sharing?type=dataElement&id=" + dataElementsToUpdate[i].
>> object.id;
>> serverConfigPOST.dhis2server.headers = {
>> 'Content-Type': 'application/json',
>> 'Content-Length': postData.length
>> };
>> console.log(serverConfigPOST);
>> var req = https.request(serverConfigPOST.dhis2server, function(res) {
>> console.log('STATUS: ' + res.statusCode);
>> console.log('HEADERS: ' + JSON.stringify(res.headers));
>> res.setEncoding('utf8');
>> res.on('data', function (chunk) {
>> console.log('BODY: ' + chunk);
>> });
>> });
>> req.on('error', function(e) {
>> //console.log('problem with request: ' + e.message);
>> });
>> // write data to request body
>> req.write(postData);
>> req.end();
>>
>> Tried here
>> // if(i==20){
>> // break;
>> // }
>> }
>>
>> Not quite sure how to slow this one down, I may just have to run/rerun it
>> with different starting and stopping i values in the mean time.
>>
>> Timothy Harding
>> RPCV Vanuatu
>> Skype: hardi...@gmail.com
>> +1 (541) 632-6623
>>
>
>
> --
> Pierre Dane
>
> Development Manager
> Jembi Health Systems
>
>
___
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 1487121] Re: tomcat is not displaying dhis on web browser

[Mohamed Bangura]

can someone please help me with this issue?.It's really frustrating
because i think that i have done the right thing yet still i am not
receiving the desired result.

Waiting for your response please,it's urgent.Thanks in advance for your
help.

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

Title:
  tomcat is not displaying dhis on web browser

Status in DHIS:
  New

Bug description:
  Hello all,

  I am trying to install Dhis on ubuntu desktop 14.04.I av installed
  tomcat,java and copied the war file to webapps.The tomcat starts well
  and deploys the war file.

  But when i try to access the dhis from my webbrowser,it gives the
  error below

  HTTP Status 404 - /dhis

  type Status report

  message /dhis

  description The requested resource is not available.

  Apache Tomcat/7.0.42

  I have tried it on several browsers,its the same thing.Can someone
  please help me ?

  This is a snap shot of the catalina.out result of the tomcat

  Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
  INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
  Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
  INFO: Initialization processed in 375 ms
  Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService startInternal
  INFO: Starting service Catalina
  Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine startInternal
  INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
  Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig deployWAR
  INFO: Deploying web application archive 
/usr/share/apache-tomcat-7.0.42/webapps/dhis.war
  * INFO  2015-08-20 16:21:11,055 System property dhis2.home not set 
(DefaultLocationManager.java [localhost-startStop-1])
  * INFO  2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points to 
/home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java 
[localhost-startStop-1])
  * INFO  2015-08-20 16:21:12,083 Hibernate configuration loaded, using 
dialect: org.hibernate.dialect.PostgreSQLDialect 
(DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table 
completedatasetregistration add column attributeoptioncomboid int4 not null 
(SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,181 ERROR: column "attributeoptioncomboid" 
contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table 
datavalue add column attributeoptioncomboid int4 not null (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,187 ERROR: column "attributeoptioncomboid" 
contains null values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table 
minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,191 ERROR: column "minimumvalue" contains null 
values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table 
minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,195 ERROR: column "maximumvalue" contains null 
values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table 
translation add column translationid int4 not null (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,199 ERROR: column "translationid" contains null 
values (SchemaUpdate.java [localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table 
completedatasetregistration add constraint 
fk_completedatasetregistration_attributeoptioncomboid foreign key 
(attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,203 ERROR: column "attributeoptioncomboid" 
referenced in foreign key constraint does not exist (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table 
datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key 
(attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,208 ERROR: column "attributeoptioncomboid" 
referenced in foreign key constraint does not exist (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,210 HHH000388: Unsuccessful: alter table 
programstage add constraint fk_programstage_dataentryform foreign key 
(dataentryformid) references dataentryform (SchemaUpdate.java 
[localhost-startStop-1])
  * ERROR 2015-08-20 16:21:22,211 ERROR: constraint 
"fk_programstage_dataentryform" for relation "programstage" already exists 
(SchemaUpdate.java [localhost-

Re: [Dhis2-devs] [Bug 1487121] Re: tomcat is not displaying dhis on web browser

[Lars Helge Øverland]

Hi Mohamed,

there is a column which maps to a java boolean field which has a null value
for en existing row. Try this SQL:

update dataelementcategory set datadimension = false where datadimension is
null;

Then restart the server.


Lars



On Tue, Aug 25, 2015 at 4:17 AM, Mohamed Bangura  wrote:

> can someone please help me with this issue?.It's really frustrating
> because i think that i have done the right thing yet still i am not
> receiving the desired result.
>
> Waiting for your response please,it's urgent.Thanks in advance for your
> help.
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1487121
>
> Title:
>   tomcat is not displaying dhis on web browser
>
> Status in DHIS:
>   New
>
> Bug description:
>   Hello all,
>
>   I am trying to install Dhis on ubuntu desktop 14.04.I av installed
>   tomcat,java and copied the war file to webapps.The tomcat starts well
>   and deploys the war file.
>
>   But when i try to access the dhis from my webbrowser,it gives the
>   error below
>
>   HTTP Status 404 - /dhis
>
>   type Status report
>
>   message /dhis
>
>   description The requested resource is not available.
>
>   Apache Tomcat/7.0.42
>
>   I have tried it on several browsers,its the same thing.Can someone
>   please help me ?
>
>   This is a snap shot of the catalina.out result of the tomcat
>
>   Aug 20, 2015 4:21:00 PM org.apache.coyote.AbstractProtocol init
>   INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
>   Aug 20, 2015 4:21:00 PM org.apache.catalina.startup.Catalina load
>   INFO: Initialization processed in 375 ms
>   Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardService
> startInternal
>   INFO: Starting service Catalina
>   Aug 20, 2015 4:21:01 PM org.apache.catalina.core.StandardEngine
> startInternal
>   INFO: Starting Servlet Engine: Apache Tomcat/7.0.42
>   Aug 20, 2015 4:21:01 PM org.apache.catalina.startup.HostConfig deployWAR
>   INFO: Deploying web application archive
> /usr/share/apache-tomcat-7.0.42/webapps/dhis.war
>   * INFO  2015-08-20 16:21:11,055 System property dhis2.home not set
> (DefaultLocationManager.java [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:11,057 Environment variable DHIS2_HOME points
> to /home/inveneo/DHIS2_HOME/dhis (DefaultLocationManager.java
> [localhost-startStop-1])
>   * INFO  2015-08-20 16:21:12,083 Hibernate configuration loaded, using
> dialect: org.hibernate.dialect.PostgreSQLDialect
> (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,179 HHH000388: Unsuccessful: alter table
> completedatasetregistration add column attributeoptioncomboid int4 not null
> (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,181 ERROR: column "attributeoptioncomboid"
> contains null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,185 HHH000388: Unsuccessful: alter table
> datavalue add column attributeoptioncomboid int4 not null
> (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,187 ERROR: column "attributeoptioncomboid"
> contains null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,190 HHH000388: Unsuccessful: alter table
> minmaxdataelement add column minimumvalue int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,191 ERROR: column "minimumvalue" contains
> null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,194 HHH000388: Unsuccessful: alter table
> minmaxdataelement add column maximumvalue int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,195 ERROR: column "maximumvalue" contains
> null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,199 HHH000388: Unsuccessful: alter table
> translation add column translationid int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,199 ERROR: column "translationid" contains
> null values (SchemaUpdate.java [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,202 HHH000388: Unsuccessful: alter table
> completedatasetregistration add constraint
> fk_completedatasetregistration_attributeoptioncomboid foreign key
> (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,203 ERROR: column "attributeoptioncomboid"
> referenced in foreign key constraint does not exist (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,206 HHH000388: Unsuccessful: alter table
> datavalue add constraint fk_datavalue_attributeoptioncomboid foreign key
> (attributeoptioncomboid) references categoryoptioncombo (SchemaUpdate.java
> [localhost-startStop-1])
>   * ERROR 2015-08-20 16:21:22,208 ERROR: column "attributeoptioncomboid"
> referenced in foreign key c

Re: [Dhis2-devs] Extending Complete DataSet Registration

[Lars Helge Øverland]

Hi Bharath,

agree with what Calle says above about simply doing values / fields for
completeness - might not be very meaningful.

Also, the approach of storing the value count I don't think will be robust
since in many implementations the forms are not locked after completion,
meaning the count will be off if additional data is entered or removed.

To me, the ideal solution here is to implement this in analytics and base
it on compulsory data elements. We already have reporting rates based on
completeness registrations in analytics. We could extend this with
completeness based on captured values vs compulsory fields (like we do for
the "reporting rate summary" under reports).

That way, you can now take advantage of the flexibility of analytics in
terms of dimensions (rows, columns, filters), relative periods, org units
etc, without having to re-implement all that. You could then build your app
on top of the analytics api.

Let me know what you think.

best regards,

Lars








On Mon, Aug 24, 2015 at 4:52 AM, Bharath  wrote:

>
> Hi Calle & Adedapo,
>
> Thanks for your views.
>
> @Calle, currently in India we are following the first option entering
> Zeros for the services that are not applicable though personally I wont
> recommend it as it tremendously increases database size. I can see 70% of
> data is zeros in many of the state applications. The second option can
> workout for instances where we have some legacy but not for newly started
> ones.
>
> I agree with Adedapo to start with calculating coverage for compulsory
> dataelements.
>
>
>
> On Mon, Aug 24, 2015 at 4:50 AM, Adedapo Adejumo 
> wrote:
>
>> Hi
>> Thanks Calle for bringing in the data management dimension.
>> Definitely a tricky issue with no easy solution.
>> As a start, it will be a great idea to actually get the current
>> functionality of tagging "compulsory data elements" for datasets and
>> assessing completeness based on that selection to work and then work on
>> making this smarter - the ability to define compulsory data elements for
>> organisation unit groups .
>> The customization of data entry forms along the lines of service
>> availability/provision will be the gold standard but implementation may be
>> tricky in some circumstances and environments.
>>
>> On Sat, Aug 22, 2015 at 11:06 AM, Calle Hedberg 
>> wrote:
>>
>>> Bharath,
>>>
>>> The exact method for calculating this aside - it seems to me that a
>>> fundamental limitation in your coverage definition is that it does not
>>> consider whether the data set is an accurate representation of the services
>>> each facility provide. Or in other words, you might have a data set of 100
>>> data elements used for let us day 200 facilities - in many/most countries,
>>> it would be uncommon for all 200 facilities to provide ALL the services
>>> represented in those 100 data elements.
>>>
>>> The net result is that you data entry coverage status will most likely
>>> always be well under 100% - even if every single facility report fully for
>>> every data element covering services that they DO provide.
>>>
>>> There are at least two options for dealing with this:
>>>
>>> 1. You can enforce the capture of a zero for all services a facility do
>>> not provide.
>>> 2. You generate the data entry coverage rate based on Filled data items
>>> divided by "Actual" data items - the latter derived from a longer term
>>> (12-18 months) pattern analysis, where you can set a threshold for when a
>>> data item is regarded as "active" (meaning that service is actually
>>> regularly provided) for a specific facility.
>>>
>>> The main disadvantage of the first method is that managers will not know
>>> whether a 0 means that service is not provided at all, or whether it IS
>>> available but that there were no cases for that month.
>>>
>>> We (South Africa) are currently discussing a related method for the
>>> customisation of the data entry form itself. SA is using relatively
>>> standardised data sets across a large variety of facilities (e.g. a
>>> "Clinic" might vary from a single-nurse facility doing basic preventative
>>> care only to a large one-stop facility with 10-20 nurses and a few doctors
>>> providing a nearly full range of PHC services). Users would like to have a
>>> way of automatically reducing the size of the data entry form to only show
>>> data elements relevant for each facility - and one suggestion has been to
>>> only display data elements that have actual data stored for the previous
>>> 12-18 months (with a "More" button to display additional data elements when
>>> required).
>>>
>>> We should work towards a more uniform model for handling these data
>>> entry and coverage aspects - a model that BOTH provide feedback on data
>>> entry completeness AND feedback to managers on what services are actually
>>> provided at which facilities. The first aspect is primarily an HMIS issue -
>>> the second aspect is the more fundamental service delivery issue.
>>>
>>> Regards
>>>

Re: [Dhis2-devs] Issue in Data visualizer/event visualizer app

[Akash Jindal]

Hi Jan,

Do we have any update on this?

On Wed, May 27, 2015 at 10:40 PM, Jan Henrik Øverland <
janhenrik.overl...@gmail.com> wrote:

> Hi Akash,
>
> We are aware of this weird behavior and will try to get it fixed, but
> unfortunately I cannot give you an accurate estimate of how long it will
> take.
>
> Jan
>
> On Wed, May 27, 2015 at 2:11 PM, Akash Jindal 
> wrote:
>
>> Dear Dev team,
>>
>> We have encountered an issue with the Data visualizer/event visualizer
>> app. The step by step presentation of the issue has been put in form of a
>> video which can be accessed from the given link :-
>>
>>
>> https://drive.google.com/file/d/0B0xNkdP7U_ZzN0lVYzI5NkxBT1E/view?usp=sharing
>>
>> When we are trying to select/un-select the data items there seems to be
>> an issue with the values shown on the y-axis of the graph, the axis values
>> don't seem to change with the selection of the particular data item.
>>
>> Requesting you to please look into this and let us know how long it may
>> take for issue to be resolved or if it will be resolved in future
>> iterations of DHIS2.
>>
>> --
>> *Regards*
>> Akash Jindal
>>
>>
>> ___
>> 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
>>
>>
>


-- 
*Regards*
Akash Jindal
___
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