Re: [Dhis2-devs] Weird cache issue

So, coming back to Lars's point. 1) Did you check the "dataset" table to confirm that your intended changes were persisted? 2) Did you alter the dataset "shortname" and is that the same which you are seeing in your integrity checks? 3) You indicated you cleared the DHIS 2 server cache. Can you c

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19929: Upgraded all plugin versions

revno: 19929 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 09:23:59 +0200 message: Upgraded all plugin versions modified: dhis-2/pom.xml -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/tr

Re: [Dhis2-devs] Pivot tables or event reports

Hi Moses, you can download pivot tables as Excel from the Download top menu item. [image: Inline image 1] regards, Lars On Tue, Sep 1, 2015 at 1:14 PM, moses mwale wrote: > Hello, is it possible that fact sheets (Pivot tables or event reports) can > be converted into word or excel? > >

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19930: Fix to TaskCategory / analytics

revno: 19930 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 10:15:17 +0200 message: Fix to TaskCategory / analytics modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/scheduling/TaskCategory.java dh

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19931: Removed unused task category

revno: 19931 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 10:33:48 +0200 message: Removed unused task category modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/scheduling/TaskCategory.java -- lp:

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19932: Reverted r 19929 for now, CI not happy

revno: 19932 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 10:35:29 +0200 message: Reverted r 19929 for now, CI not happy modified: dhis-2/pom.xml -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-cor

Re: [Dhis2-devs] Weird cache issue

Jason, 1. Yes 2. Yes, I changed both name and shortname (identical) - but I do not know if the Data Integrity checks display name or short name (settings = short name for that instance). 3. We are not using any caching proxy We did restart Tomcat - which should clear the server cache (?) - and I

Re: [Dhis2-devs] [Dhis2-users] Value saving out of option set

Hi Nayeem, in later versions of DHIS 2 (2.18 +) it should not be possible to enter values outside of option sets. However I know we are not validating this on import so it could have come in that way (we could fix this). It could also be that the option set was changed at some point in time, meani

Re: [Dhis2-devs] Weird cache issue

Could you go to /api/dataSets and confirm that the names, shortNames and displayNames are correct? The names displayed should be the displayNames; which reminds me: do you have translations for the given dataSets/current locale? If you do they will be displayed, and they will not have been updated.

Re: [Dhis2-devs] Weird cache issue

Jason, We have another strange Data Integrity check result - this one is not related to any known change in the database. This one relates to the "Data Elements in data set but not in form or sections" - we are seeing that check returning one data element that definitely exist in both the single s

Re: [Dhis2-devs] Weird cache issue

Halvdan, We do not use translations for any South African instance - all English (i.e. the translation table has 0 rows) We are using either 2.19 or 2.20 (mostly 2.19) - actually a slightly modified version of 2.19 in most cases. That version contains additional code related to DHIS 1.4->DHIS2 co

Re: [Dhis2-devs] Weird cache issue

Sorry forgot the result from the api call (the changes I made to the names and short names were mostly to add "(Monthly)" to the end of a number of data sets): http://dhis2.org/schema/dxf/2.0";> 1 1 31 http://fs.dhis.dhmis.org/staging/api/dataSets/iv02Urztm60"/> http://fs.dhis.dhmis.org/staging

Re: [Dhis2-devs] Weird cache issue

Hi So just to re-iterate the key question here: api calls, the UI Data Set list and similar were all showing the correct (updated) data set names. Whereas "violations" resulting from running Data Integrity was showing the incorrect (old) data set names. If it's possible to get a list of those hib

Re: [Dhis2-devs] Weird cache issue

Try and add this to your hibernate.properties file hibernate.show_sql = true hibernate.format_sql = true -- Morten On Wed, Sep 2, 2015 at 5:26 PM, Calle Hedberg wrote: > Hi > > So just to re-iterate the key question here: api calls, the UI Data Set > list and similar were all showing the corre

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19933: Data import. Enforcing future periods constraints of data element through data set

revno: 19933 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 12:26:26 +0200 message: Data import. Enforcing future periods constraints of data element through data set modified: dhis-2/dhis-api/src/main/j

Re: [Dhis2-devs] Weird cache issue

Morten, Those two properties will result in the queries being listed in the tomcat log? If yes, that's perfect... Regards Calle On 2 September 2015 at 13:27, Morten Olav Hansen wrote: > Try and add this to your hibernate.properties file > > hibernate.show_sql = true > hibernate.format_sql = tr

[Dhis2-devs] Problem loading event capture in CHROME

Dear Experts We just upgrade our One server (the biggest one) to version 19 (Build 19273). When we select event capture and find that 'Orgunit' are loading OK, but 'Loading Meta data..' message are dis playing for ever. This happens in CHROME browser (I am using 45.0.2454.78 beta-m (64-bit)). But

Re: [Dhis2-devs] Weird cache issue

Yes, it just spits out all the queries hibernate is doing -- Morten On Wed, Sep 2, 2015 at 5:29 PM, Calle Hedberg wrote: > Morten, > > Those two properties will result in the queries being listed in the tomcat > log? If yes, that's perfect... > > Regards > Calle > > On 2 September 2015 at 13:27

[Dhis2-devs] Amazon EC2 memory configuration

Hi I registered for a free tier EC2 instance (t2.micro) on Amazon with Ubuntu 14.04 AMD64 http://aws.amazon.com/ec2/instance-types/ I have set it up according to the DHIS2 implementation manual. I'm aware that this low hardware specifications are not ready for national use, I'd like to use it

Re: [Dhis2-devs] Weird cache issue

Ok. I'm sorry the api query was lacking a parameter (should be api/dataSet.json&fields=name,shortName,displayName) to show all the fields. DisplayNames are generated (i.e. they're either the translation if one exists or they're simply the name). If you're not using translations that's obviously a d

Re: [Dhis2-devs] Problem loading event capture in CHROME

Hi Hannan, Is this problem pervasive across different laptops? Just to make sure it is not only one particular Chrome installation that has the issue. Knut On Wed, Sep 2, 2015 at 12:31 PM, Hannan Khan wrote: > Dear Experts > > We just upgrade our One server (the biggest one) to version 19 (Bui

Re: [Dhis2-devs] Problem loading event capture in CHROME

Hi Hannan, The objectStore error is related to browser caching. Clear your browser cache and try one more time. --- Thank you, Abyot. On Wed, Sep 2, 2015 at 12:36 PM, Knut Staring wrote: > Hi Hannan, > > Is this problem pervasive across different laptops? Just to make sure it > is not only on

Re: [Dhis2-devs] Problem loading event capture in CHROME

Yes it is. We have lot of complain from field on this issue. On Wednesday, September 2, 2015, Knut Staring wrote: > Hi Hannan, > > Is this problem pervasive across different laptops? Just to make sure it > is not only one particular Chrome installation that has the issue. > > Knut > > On Wed, Se

Re: [Dhis2-devs] Weird cache issue

Halvdan, Noted, thanks for clarification - and yes, this issue is not related to that (I'm still 98% sure it's somehow related to caching, I just don't know how - my reason for pursuing this is obviously that since we are regularly updating databases directly or via the web api, we want to be sure

Re: [Dhis2-devs] [Dhis2-users] Amazon EC2 memory configuration

Hi David, 1 GB is probably pushing it a bit, AFAIK. Possible, but not too easy2 GB should be fine. Knut On Wed, Sep 2, 2015 at 12:11 PM, David Huser wrote: > Hi > > I registered for a free tier EC2 instance (t2.micro) on Amazon with Ubuntu > 14.04 AMD64 http://aws.amazon.com/ec2/instance-t

Re: [Dhis2-devs] Weird cache issue

Probably a stupid question, but did you try incognito mode or another browser? On Wed, Sep 2, 2015 at 12:44 PM, Calle Hedberg wrote: > Halvdan, > > Noted, thanks for clarification - and yes, this issue is not related to > that (I'm still 98% sure it's somehow related to caching, I just don't kno

Re: [Dhis2-devs] Problem loading event capture in CHROME

Probably a stupid question, but did you try incognito mode? On Wed, Sep 2, 2015 at 12:41 PM, Hannan Khan wrote: > Yes it is. We have lot of complain from field on this issue. > > > On Wednesday, September 2, 2015, Knut Staring wrote: > >> Hi Hannan, >> >> Is this problem pervasive across differ

Re: [Dhis2-devs] Weird cache issue

Knut, No, I didn't try another browser - we are trying to standardise on chrome for DHIS2. Remember that this is not some kind of "crisis" issue where we are stuck with something per se - I'm just trying to track down the root cause of (several) seemingly cache-related issues we have encountered.

Re: [Dhis2-devs] [Dhis2-users] Amazon EC2 memory configuration

Are you sure that Tomcat actually shut down ? Be sure Tomcat is dead by invoking ps -ef | grep tomcat and killing any processes(es) which may be running, and then start it again. If you get that memory leak error again, then something else is not right. Having said that, I agree with Knut. 1GB wi

Re: [Dhis2-devs] Pivot tables or event reports

How about to word? How about those charts in data visualizer, can they also be downloaded to word or as excel? Thank you for the help On 2 Sep 2015 09:25, "Lars Helge Øverland" wrote: > Hi Moses, > > you can download pivot tables as Excel from the Download top menu item. > > > [image: Inline imag

Re: [Dhis2-devs] Pivot tables or event reports

Hello Moses, The charts can be downloaded as PDF or images; the latter can be pasted into a word document quite easily. The source data of these, however, can still be downloaded to excel with the process Lars described earlier on this email thread. Thanks, Ali On Wed, Sep 2, 2015 at 2:36 PM, m

Re: [Dhis2-devs] Pivot tables or event reports

Another trick is to download the HTML and the copy and paste into Word for the tables. You can also save the HTML file and open this file with word and make further edits. Regards, Jason On Wed, Sep 2, 2015 at 2:14 PM, Ali Karisa wrote: > Hello Moses, > > The charts can be downloaded as PDF or

Re: [Dhis2-devs] Problem loading event capture in CHROME

Hi Hannan, You will need to inform all of your users (likely a lot) they will all need to clear their browser caches. Regards, Jason On Wed, Sep 2, 2015 at 12:58 PM, Knut Staring wrote: > Probably a stupid question, but did you try incognito mode? > > On Wed, Sep 2, 2015 at 12:41 PM, Hannan K

Re: [Dhis2-devs] Problem loading event capture in CHROME

Thank you Knut and Jason. Browser caches are the culprit. Thanks a lot. On Wed, Sep 2, 2015 at 6:26 PM, Jason Pickering wrote: > Hi Hannan, > > You will need to inform all of your users (likely a lot) they will all > need to clear their browser caches. > > Regards, > Jason > > > On Wed, Sep 2,

Re: [Dhis2-devs] Problem loading event capture in CHROME

The incognito mode will work, but won't recommend it for proper use. By the way, it is not necessary to clear cache everytime the app is run. Cache clearing is required only if meta-data is changed after the app is run. --- Thank you, Abyot. On Wed, Sep 2, 2015 at 2:26 PM, Jason Pickering wrot

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19934: Data import, cache

revno: 19934 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 15:01:24 +0200 message: Data import, cache modified: dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/datavalueset/Defau

Re: [Dhis2-devs] Weird cache issue

Hi Calle, I meant "Private mode", https://www.google.no/search?q=chrome+incognito+mode Or Chrome on another machine. Or Firefox. Just to ascertain whether it is indeed related to browser caching. Knut On Wed, Sep 2, 2015 at 1:02 PM, Calle Hedberg wrote: > Knut, > > No, I didn't try another bro

Re: [Dhis2-devs] [Dhis2-users] Amazon EC2 memory configuration

At BAO we've found we could only reliably support DHIS 2 with a minimum of 2GB. Dan Cocos BAO Systems www.baosystems.com T: +1 202-569-8751 | gchat: dco...@baosystems.com > On Sep 2, 2015, at 7:33 AM, Jason Pickering > wrote: > > > Are you sure that Tomcat actua

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19936: introducing category and option combo to program / stage / instance - WIP

revno: 19936 committer: Abyot Asalefew Gizaw branch nick: dhis2 timestamp: Wed 2015-09-02 15:48:58 +0200 message: introducing category and option combo to program / stage / instance - WIP modified: dhis-2/dhis-services/dhis-service-

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19937: DataValueController, enforcing optional constraints for data values

revno: 19937 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 16:05:25 +0200 message: DataValueController, enforcing optional constraints for data values modified: dhis-2/dhis-web/dhis-web-api/src/main/jav

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19935: introduced attribte type categoryoptioncombo for programStageInstance

revno: 19935 committer: Abyot Asalefew Gizaw branch nick: dhis2 timestamp: Wed 2015-09-02 15:40:16 +0200 message: introduced attribte type categoryoptioncombo for programStageInstance modified: dhis-2/dhis-api/src/main/java/org/hisp/

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19938: Fixed hibernate mapping issue for PSI, key-many-to-one to many-to-one

revno: 19938 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 16:18:36 +0200 message: Fixed hibernate mapping issue for PSI, key-many-to-one to many-to-one modified: dhis-2/dhis-api/src/main/java/org/hisp/d

[Dhis2-devs] Raw data exporting based on facilities through web api

Hi Experts, I want to exports all the raw data that I am entering by facilities by month. I have 175 data elements and 25 indicators in my data entry form. How can i export all the data by month from external script? Waiting for your valuable opinion. Thanks Julhas Dhaka, Bangladesh

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19939: Removing data mart tables

revno: 19939 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 16:22:03 +0200 message: Removing data mart tables modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlt

Re: [Dhis2-devs] Raw data exporting based on facilities through web api

Hi Julhas, have a look at the web api docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s11.html#d5e1433 Lars On Wed, Sep 2, 2015 at 4:24 PM, Julhas Sujan wrote: > Hi Experts, > > I want to exports all the raw data that I am entering by facilities by > month. I have 175 data e

Re: [Dhis2-devs] Raw data exporting based on facilities through web api

Hi Lars, Thank you very much. I have followed this link. I am getting values in a single facility by month according to this link. But i want to get multiple facilities data like: https://apps.dhis2.org/demo/api/dataValueSets.csv? dataSet=pBOMPrpg1QX&period=201401&orgUnit=org1,org2,org3,org10

Re: [Dhis2-devs] Raw data exporting based on facilities through web api

childrenWhether to include the children in the hierarchy of the organisation units. On Wed, Sep 2, 2015 at 4:56 PM, Julhas Sujan wrote: > Hi Lars, > > Thank you very much. I have followed this link. I am getting values in a > single facility by month according to this link. But i want to get mul

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19940: Removed property DataSet.skipAggregation

revno: 19940 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 18:15:15 +0200 message: Removed property DataSet.skipAggregation removed: dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/s

Re: [Dhis2-devs] [Dhis2-users] Amazon EC2 memory configuration

Hi David, INFO: Pausing ProtocolHandler ["http-bio-8080"] you are running on port 8080, this might be related to firewalls on aws. Try running on port 80 (conf/server.xml). Alternatively check if firewalls are active and blocks 8080. regards, Lars On Wed, Sep 2, 2015 at 3:47 PM, Dan Cocos

Re: [Dhis2-devs] Pivot tables or event reports

If you are using Google Chrome you can even just select the html of the table in the browser by pressing Ctrl + a, then copy it (Ctrl + c) and paste it directly in Word. This works in e.g. Gmail as well. On Wed, Sep 2, 2015 at 2:20 PM, Jason Pickering wrote: > Another trick is to download the HT

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19941: Analysis, relative period date param implemented.

revno: 19941 committer: Jan Henrik Overland branch nick: dhis2 timestamp: Wed 2015-09-02 20:25:31 +0200 message: Analysis, relative period date param implemented. modified: dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-even

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

Thanks everyone, I very much appreciate the help. I will give both of these a shot! Node.js can be damn confusing at times. Timothy Harding RPCV Vanuatu Skype: hardi...@gmail.com +1 (541) 632-6623 On Tue, Aug 25, 2015 at 1:57 AM, Lars Helge Øverland wrote: > Hi Tim, > > you can use promises to

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19942: Analytics, fixed bug, display name not set in headers for dynamic dimensions

revno: 19942 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 21:49:48 +0200 message: Analytics, fixed bug, display name not set in headers for dynamic dimensions modified: dhis-2/dhis-services/dhis-servic

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19943: Startup, removed logging

revno: 19943 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 23:01:22 +0200 message: Startup, removed logging modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataelement/DataE

Re: [Dhis2-devs] [Dhis2-users] Amazon EC2 memory configuration

Hi David The log file does seem to indicate that the startup was successful. It does look like an orderly shutdown rather than any sign of out-of-memory exceptions. Which happens about 1 minute after the successful startup. Did you shut it down yourself or it just collapsed without you doing any

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19944: Fixed bug with add/edit program/program type

revno: 19944 committer: Lars Helge Overland branch nick: dhis2 timestamp: Wed 2015-09-02 23:39:01 +0200 message: Fixed bug with add/edit program/program type modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-progra

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19945: remove unused fields valueType in dataElementOperand

revno: 19945 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 09:35:05 +0700 message: remove unused fields valueType in dataElementOperand modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/dataelement/D

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19946: add utility method to ValueType for getting ValueType from type/numberType/textType

revno: 19946 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 09:58:03 +0700 message: add utility method to ValueType for getting ValueType from type/numberType/textType modified: dhis-2/dhis-api/src/main/j

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19947: minor fixes for ValueType, also converted to using <> as type parameters where applicable

revno: 19947 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 10:11:47 +0700 message: minor fixes for ValueType, also converted to using <> as type parameters where applicable modified: dhis-2/dhis-api/src/

Re: [Dhis2-devs] Raw data exporting based on facilities through web api

Thank you very much. I have written the same thing in JS as for web api: var base = 'http://103.247.238.67:8080/mishealth'; Ext.onReady( function() { Ext.Ajax.request({ url: base + "dhis-web-commons-security/login.action?auth

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19948: add service methods to get DE by valueType(s)

revno: 19948 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 11:03:56 +0700 message: add service methods to get DE by valueType(s) modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/dataelement/DataElem

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19949: minor fix

revno: 19949 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 11:17:21 +0700 message: minor fix modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/ValueType.java dhis-2/dhis-support/dhis-support

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19950: remove debug log

revno: 19950 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 11:17:55 +0700 message: remove debug log modified: dhis-2/dhis-support/dhis-support-system/src/main/java/org/hisp/dhis/system/util/ValidationUti

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19951: use field name and not colum name for DE get by valueType services

revno: 19951 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 11:20:56 +0700 message: use field name and not colum name for DE get by valueType services modified: dhis-2/dhis-services/dhis-service-core/src/

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19952: remove get data elements by type, not in use anywhere except for tests

revno: 19952 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 11:31:39 +0700 message: remove get data elements by type, not in use anywhere except for tests modified: dhis-2/dhis-api/src/main/java/org/hisp/

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19953: add tests for get de by value type(s)

revno: 19953 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Thu 2015-09-03 11:42:52 +0700 message: add tests for get de by value type(s) modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/common/ValueType.java dhis