Re: [Dhis2-devs] Data Set Report is not Downloading to Excel
Hi Gerald, Unfortunately custom forms are not properly handled in dataset reports. A work around will be to “print" the dataset report output to pdf using Chrome. …. Dapo Adejumo > On 24 Mar 2017, at 14:46, Mohamed Bangura wrote: > > Dear Gerald, > Use mozilla firefox to extract the data. > Do Ctrl A,Ctrl C > Open your blank excel and do ctrl V. > Hope this helps. > On 3/24/17, gerald thomas wrote: >> Dear all, >> Please i need your your help it is urgent. >> >> On 3/23/17, gerald thomas wrote: >>> Dear All, >>> I am having problems downloading Data Set report to excel or pdf. I am >>> using version 2.25. It is working on demo but not on my instance. >>> Please can someone help me with a fix. >>> >>> -- >>> Regards, >>> >>> Gerald >>> >> >> >> -- >> Regards, >> >> Gerald >> >> ___ >> 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 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Data Set Report is not Downloading to Excel
Hi Gerald, Does this dataset use a custom form? …. Dapo Adejumo > On 24 Mar 2017, at 13:57, gerald thomas wrote: > > Dear all, > Please i need your your help it is urgent. > > On 3/23/17, gerald thomas wrote: >> Dear All, >> I am having problems downloading Data Set report to excel or pdf. I am >> using version 2.25. It is working on demo but not on my instance. >> Please can someone help me with a fix. >> >> -- >> Regards, >> >> Gerald >> > > > -- > Regards, > > Gerald > > ___ > 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
[Dhis2-devs] [Bug 1618312] [NEW] Pivot table app not showing selected data dimensions in 2.22
Public bug reported: Hi Devs, The pivot table app is not showing translated data dimensions in the select lists (Data Elements and Indicators) in 2.22 . The translations however show correctly in the pivot once updated. This works as expected in 2.24. Screenshot highlighting this is attached. Tested on Version 2.22 (revs 22092 and 22095) Thanks. ** Affects: dhis2 Importance: Undecided Status: New ** Attachment added: "Translation Bug.jpg" https://bugs.launchpad.net/bugs/1618312/+attachment/4730499/+files/Translation%20Bug.jpg -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1618312 Title: Pivot table app not showing selected data dimensions in 2.22 Status in DHIS: New Bug description: Hi Devs, The pivot table app is not showing translated data dimensions in the select lists (Data Elements and Indicators) in 2.22 . The translations however show correctly in the pivot once updated. This works as expected in 2.24. Screenshot highlighting this is attached. Tested on Version 2.22 (revs 22092 and 22095) Thanks. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1618312/+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] [Bug 1607293] Re: Cant update Data element attribute using PATCH Web Api command in 2.22
Thanks Morten, Worked quite well in 2.21 , will just have to rely on the full functionality in 2.24/25 then. …. Dapo Adejumo DHIS2 Senior Analyst, BAO Systems +1 202-536-1543 | <>d...@baosystems.com <mailto:d...@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> | Skype: dapojorge | 2900 K Street, Suite 404, Washington D.C. 20007 > On 29 Jul 2016, at 10:11, Morten Olav Hansen <1607...@bugs.launchpad.net> > wrote: > > Hi Dapo > > Patching was never really properly implemented in versions earlier than > 2.24, the reason you are seeing differences in 2.21 and 2.22 might be > because you have attribute values there? usually they are the cause of > most issues. > > It should work a lot better in 2.24, but hopefully we will make it even > more robust in 2.25 (it requires modifications to the importer) > > ** Changed in: dhis2 > Status: New => Invalid > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/1607293 > > Title: > Cant update Data element attribute using PATCH Web Api command in 2.22 > > Status in DHIS: > Invalid > > Bug description: > Hi Devs, > I am trying to update one Data element attribute (name) using a patch update > command , example below > "curl -X PATCH -d "{\"name\":\"New Data Element Name\"}" -H "Content-Type: > application/json" -u xx:xx > http://localhost:8080/api/dataElements/uidxxx/name” > > The command fails with the main error below > > "Request processing failed; nested exception is > org.hibernate.HibernateException: A collection with cascade="all- > delete-orphan" was no longer referenced by the owning entity > instance: org.hisp.dhis.dataelement.DataElement.attributeValues” > > > This command works in 2.21 and also tested OK in 2.24 but not in 2.22 > (several builds tested) , did something change in 2.22 making this fail? > > Thanks! > > To manage notifications about this bug go to: > https://bugs.launchpad.net/dhis2/+bug/1607293/+subscriptions ** Attachment added: "uc.png" https://bugs.launchpad.net/bugs/1607293/+attachment/4709352/+files/uc.png -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1607293 Title: Cant update Data element attribute using PATCH Web Api command in 2.22 Status in DHIS: Invalid Bug description: Hi Devs, I am trying to update one Data element attribute (name) using a patch update command , example below "curl -X PATCH -d "{\"name\":\"New Data Element Name\"}" -H "Content-Type: application/json" -u xx:xx http://localhost:8080/api/dataElements/uidxxx/name” The command fails with the main error below "Request processing failed; nested exception is org.hibernate.HibernateException: A collection with cascade="all- delete-orphan" was no longer referenced by the owning entity instance: org.hisp.dhis.dataelement.DataElement.attributeValues” This command works in 2.21 and also tested OK in 2.24 but not in 2.22 (several builds tested) , did something change in 2.22 making this fail? Thanks! To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1607293/+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] [Bug 1607293] [NEW] Cant update Data element attribute using PATCH Web Api command in 2.22
Public bug reported: Hi Devs, I am trying to update one Data element attribute (name) using a patch update command , example below "curl -X PATCH -d "{\"name\":\"New Data Element Name\"}" -H "Content-Type: application/json" -u xx:xx http://localhost:8080/api/dataElements/uidxxx/name” The command fails with the main error below "Request processing failed; nested exception is org.hibernate.HibernateException: A collection with cascade="all- delete-orphan" was no longer referenced by the owning entity instance: org.hisp.dhis.dataelement.DataElement.attributeValues” This command works in 2.21 and also tested OK in 2.24 but not in 2.22 (several builds tested) , did something change in 2.22 making this fail? Thanks! ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1607293 Title: Cant update Data element attribute using PATCH Web Api command in 2.22 Status in DHIS: New Bug description: Hi Devs, I am trying to update one Data element attribute (name) using a patch update command , example below "curl -X PATCH -d "{\"name\":\"New Data Element Name\"}" -H "Content-Type: application/json" -u xx:xx http://localhost:8080/api/dataElements/uidxxx/name” The command fails with the main error below "Request processing failed; nested exception is org.hibernate.HibernateException: A collection with cascade="all- delete-orphan" was no longer referenced by the owning entity instance: org.hisp.dhis.dataelement.DataElement.attributeValues” This command works in 2.21 and also tested OK in 2.24 but not in 2.22 (several builds tested) , did something change in 2.22 making this fail? Thanks! To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1607293/+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] [Bug 1577772] Re: Translation of form name isn't display
Hi Lars, This issue is also in 2.22 , can you kindly backport this fix to 2.22 as well? Thanks. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/152 Title: Translation of form name isn't display Status in DHIS: Fix Committed Bug description: In default aggregate data entry form, when user select their database language, the translation of data element's form name isn't displayed but instead it display data element name's translation To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/152/+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] [Bug 1580784] Re: Users with authority to "Add/Remove Members in Read only groups" cannot Edit "Read only groups"
Hi Devs, Checking up on this report for feedback - any update on this? Thanks! -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1580784 Title: Users with authority to "Add/Remove Members in Read only groups" cannot Edit "Read only groups" Status in DHIS: New Bug description: Hi Devs, Users with the Roles that have the authority "Add/Remove Members in Read only groups" are expected to be able to edit members of groups that have been set to View only. This is however not happening , users can see the user group in the list but can only view details.This should not be expected behaviour (or is this expected?) Tested in latest builds of 2.22 (22016) and 2.23 (22935). Thanks. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1580784/+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] [Bug 1580784] [NEW] Users with authority to "Add/Remove Members in Read only groups" cannot Edit "Read only groups"
Public bug reported: Hi Devs, Users with the Roles that have the authority "Add/Remove Members in Read only groups" are expected to be able to edit members of groups that have been set to View only. This is however not happening , users can see the user group in the list but can only view details.This should not be expected behaviour (or is this expected?) Tested in latest builds of 2.22 (22016) and 2.23 (22935). Thanks. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1580784 Title: Users with authority to "Add/Remove Members in Read only groups" cannot Edit "Read only groups" Status in DHIS: New Bug description: Hi Devs, Users with the Roles that have the authority "Add/Remove Members in Read only groups" are expected to be able to edit members of groups that have been set to View only. This is however not happening , users can see the user group in the list but can only view details.This should not be expected behaviour (or is this expected?) Tested in latest builds of 2.22 (22016) and 2.23 (22935). Thanks. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1580784/+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] [Bug 1545438] [NEW] GIS maps are not updated using "User Organisation Unit Filter" dashboard function
Public bug reported: Dashboard Items can be changed to show data for selected organisation units using the "User Organisation Unit Filter" function on the dashboard. This works (as expected) for Charts and Tables saved as "User OU" favourites but not for GIS maps. Replicated on demo server. Affects 2.20 rev 20015 , 2.22 rev 21826. Thanks. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1545438 Title: GIS maps are not updated using "User Organisation Unit Filter" dashboard function Status in DHIS: New Bug description: Dashboard Items can be changed to show data for selected organisation units using the "User Organisation Unit Filter" function on the dashboard. This works (as expected) for Charts and Tables saved as "User OU" favourites but not for GIS maps. Replicated on demo server. Affects 2.20 rev 20015 , 2.22 rev 21826. Thanks. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1545438/+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] Classification tag on Indicators - 2.22
Thanks Lars, I understand the complexity of implementing this as explained. Using DE group sets is an option but not very neat - the ideal will be to use a form of Indicator groupsets or tag the indicators with custom attributes as an option set and be able to pull that into analytics. Interestingly , there is a similar discussion on a thread talking about analysis along the lines of M&E Logical Frameworks (for agriculture) - that is precisely the use case here! I think it will be very useful for analysis and data use if this indicator groups or attributes can be used as data dimension analytics rather than possibly resulting to complex scripting in custom reports. Hopefully that will be possible in the near future! …. Dapo Adejumo DHIS2 Senior Analyst, BAO Systems +1 202-536-1543 | <>d...@baosystems.com <mailto:d...@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> | Skype: dapojorge | 2900 K Street, Suite 404, Washington D.C. 20007 > On 31 Jan 2016, at 20:19, Lars Helge Øverland wrote: > > Hi Dapo, > > unfortunately we do not have this on the immediate roadmap. It is a bit more > complicated than it sounds. Indicator values are calculated on the fly based > on data (element) values. So if an indicator is classified, and its > expression several data elements which are not classified in any group sets, > how do you make a meaningful aggregated indicator value? > > What you can to currently (altough not ideal) is to classify the data > elements which are part of the indicators in group sets, and use those group > set dimensions in combination with the indicators. > > Perhaps if you could provide some detail about your use-case we could start > thinking around it. > > regards, > > Lars > > > On Wed, Jan 27, 2016 at 10:27 PM, Adedapo Adejumo <mailto:dapsyjo...@gmail.com>> wrote: > Hi Devs, > Looks like use of indicator group sets as data dimensions in analytics is > still not supported - How and where can the new classification tag > (Input,Activity,Output,Impact) on indicators in 2.22 be accessed in the > analysis apps?. > Thanks > Regards, > Dapo Adejumo > +2348033683677 . > > > ___ > Mailing list: https://launchpad.net/~dhis2-devs > <https://launchpad.net/~dhis2-devs> > Post to : dhis2-devs@lists.launchpad.net > <mailto:dhis2-devs@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~dhis2-devs > <https://launchpad.net/~dhis2-devs> > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp> > > > > -- > Lars Helge Øverland > Lead developer, DHIS 2 > University of Oslo > Skype: larshelgeoverland > http://www.dhis2.org <https://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] demo and continuous integration: play.dhis2.org
Thanks Dancan also see the site, getting the errors on ubuntu terminal (wget). ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "Dan Cocos" To: "Dapo Adejumo" Cc: "Lars Helge Øverland" , "DHIS 2 Users list" , "DHIS 2 Developers list" Sent: Saturday, November 14, 2015 4:05:44 PM Subject: Re: [Dhis2-devs] demo and continuous integration: play.dhis2.org I can see the site. Dan Cocos Principal, BAO Systems +1 202-352-2671 | dco...@baosystems.com | http://www.baosystems.com | Skype: dancocos | 2900 K Street, Suite 404, Washington D.C. 20007 On Nov 14, 2015, at 10:00 AM, Dapo Adejumo < dapsyjo...@gmail.com > wrote: Hi Lars, I was trying to grab a war file from the new CI server but got the errors below "no address associated with host name - unable to resolve host address ' ci.dhis2.org '" Is this an issue with the new server or on my side? ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "Lars Helge Øverland" < larshe...@gmail.com > To: "DHIS 2 Users list" < dhis2-us...@lists.launchpad.net >, "DHIS 2 Developers list" < dhis2-devs@lists.launchpad.net > Sent: Thursday, November 12, 2015 5:35:12 PM Subject: [Dhis2-devs] demo and continuous integration: play.dhis2.org Hi there, we have moved our internal infrastructure to AWS for better scalability and access to useful cloud services. Previously it was hosted at UiO. You can now find the demo applications at: https://play.dhis2.org/ The continuous integration server (jenkins) can be found at: http://ci.dhis2.org/ The apps.dhis2.org domain will point to play.dhis2.org for a while. Please update your bookmarks. 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 ___ 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] demo and continuous integration: play.dhis2.org
Hi Lars, I was trying to grab a war file from the new CI server but got the errors below "no address associated with host name - unable to resolve host address 'ci.dhis2.org'" Is this an issue with the new server or on my side? ………………… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "Lars Helge Øverland" To: "DHIS 2 Users list" , "DHIS 2 Developers list" Sent: Thursday, November 12, 2015 5:35:12 PM Subject: [Dhis2-devs] demo and continuous integration: play.dhis2.org Hi there, we have moved our internal infrastructure to AWS for better scalability and access to useful cloud services. Previously it was hosted at UiO. You can now find the demo applications at: https://play.dhis2.org/ The continuous integration server (jenkins) can be found at: http://ci.dhis2.org/ The apps.dhis2.org domain will point to play.dhis2.org for a while. Please update your bookmarks. 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 ___ 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] problem on the reporting rate
Hi Papa, Do you have an orgunit level between the District and Facility? If yes , can you check if this dataset has been assigned to any of member of this level or the district itself. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "papa alioune Sokhna" To: "DHIS 2 Developers list" , dhis2-us...@lists.launchpad.net Sent: Tuesday, October 27, 2015 11:34:48 AM Subject: [Dhis2-devs] problem on the reporting rate Hello I am using DHIS 2 version 2.18. There is an issue regarding the completeness rate on the DHIS2. When DHIS2 is calculating the completeness rate for a district, sometime the total number of expected health facilities exceeds the total number of health facilities in the district. The same situation happens to others district. For a reference, see below a screenshot for the district of SAINT-LOUIS. Regards -- Papa Alioune SOKHNA Informaticien Spécialité: développement d'application web, mobile et logiciels surs Tel: +221 77 442 16 22 ___ 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
[Dhis2-devs] [Bug 1509560] [NEW] Gauge Chart Returns Bar Chart Type in Data Visualizer
Public bug reported: Selecting a gauge chart type returns a bar chart type in Data Visualizer. Replicated on Demo Server. Version 2.21 Rev 20840. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1509560 Title: Gauge Chart Returns Bar Chart Type in Data Visualizer Status in DHIS: New Bug description: Selecting a gauge chart type returns a bar chart type in Data Visualizer. Replicated on Demo Server. Version 2.21 Rev 20840. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1509560/+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] dhis version 2.21 is released
Great work Team! Pretty excited about the pivot data dump!!! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "Guy Ekani" To: "Lars Helge Øverland" , "DHIS 2 Users list" , "DHIS 2 Developers list" Sent: Wednesday, October 21, 2015 10:39:10 PM Subject: Re: [Dhis2-devs] [Dhis2-users] dhis version 2.21 is released Congratulations to the DHIS2 development team for this great job ! = EKANI Guy Cameroon Le Mercredi 21 octobre 2015 21h03, Lars Helge Øverland a écrit : Hi all, DHIS version 2.21 is out with a lot of great new features and improvements. Log in with admin/district on the demo system. File cloud storage: You can now upload and store large files directly from data entry forms. Data elements can have a file value type and render as file upload widgets in forms. Files can be stored either on the Web server or sent directly to AWS S3 cloud storage, which in practice provides unlimited storage capacity. This capability allows you to use DHIS 2 as a general document repository which can be utilized for project management, documentation, CMS and many other purposes. File storage currently works for aggregate data entry forms - tracker coming up. Have a look at the “Project management” data set in data entry on the demo: Demo | Docs | Screenshot Settings app: The settings front-end has been re-written as a true app. It features real-time saving, search for settings and a fresh new look. Demo | Docs | Screenshot Data import constraints: Several optional constraints for data import can be enabled to provide stricter control of the data being imported. These include require period to be of same type as data set, data element to be assigned to data set through org units, and more. The import constraints can be enabled in settings app under “data import”. Docs ANALYTICS FEATURES --- Functions and variables in program indicators: Program indicators support a range of functions and variables. Functions allows for conditional statements, calculation of number of days between dates and more. Variables allows you to insert e.g. event date, enrollment date and value count into expressions. This is useful for example to calculate “inpatient bed days” and complex scores. Docs | Demo 1 | 2 | Screenshot 1 | 2 | 3 | 4 | Custom aggregation types: A program indicator now has an aggregation type property with the standard options such as sum, avg, count, std dev min, max. When set to custom , the indicator expression can contain inline aggregation types, allowing for greater control over aggregation. Docs | Screenshot Program indicators and data elements in GIS: The GIS app lets you analyse program indicators, attributes and data elements on maps. Demo | Screenshot 1 | 2 Program indicators in event reports: The individual event overview supports program indicators, which allows you to display calculations per event directly in the overview. Demo | Screenshot Download data dump: Pivot table lets you download data in CSV format directly without first rendering the data in the Web browser (which might lead to the browser freezing for large data volumes). This allows you to download much larger batches of data which is useful for later offline analysis. Screenshot Complete events only option: All analysis apps provides an option for only including completed events in the aggregation process. This is useful e.g. to exclude partial events in indicator calculations. Screenshot Full precision option: Pivot table has an option for “skip rounding” of values, i.e. full precision of values. This is useful for certain data types such as financial data, and when doing calculations in external systems. Screenshot Aggregation type for attributes: Tracked entity attributes have an aggregation type property which lets you control how attributes are aggregated in pivot tables, charts and analytics. Screenshot TRACKER FEATURES --- Attribute categories in event capture: Data set categories can be enabled for programs without registration and be used in the event capture app. This means that events can be attributed to projects and partners just like it can be for aggregate data sets. You can enable it by setting a category combination for the program. Check it out on the demo for the Demo | Screenshot Sticky right side widgets: In tracker capture, the right-side widgets can be made “sticky”, meaning that they remain at the top of the screen when scrolling down the page. You can enable this by clicking the “sticky” icon in the top-right corner of the dashboard screen. This is useful for example to display key patient information while entering data. Screenshot Program rule warnings and errors: The program rules let you define warning and error messages as a
Re: [Dhis2-devs] Removing Organization Units
Hi Gerald, You can run this command in the db - DELETE FROM datavalue WHERE sourceid = 'X'; Replace X with the orgunit id. Hope that helps. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "gerald thomas" To: "Dapo Adejumo" Cc: "dhis2-devs" , "dhis2-users" Sent: Thursday, October 1, 2015 5:39:25 PM Subject: Re: [Dhis2-devs] Removing Organization Units Dear Dapo, What is the command to remove those data from the database as per organisation unit? Please help me. Regards, Gerald On Oct 1, 2015 16:16, "Dapo Adejumo" < dapsyjo...@gmail.com > wrote: Hi Gerald, What error are you getting? If you have data associated with these org units, you will not be able to remove them until you delete the data in the database (even if you have removed the datasets). ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "gerald thomas" < gerald17...@gmail.com > To: "dhis2-users" < dhis2-us...@lists.launchpad.net >, "dhis2-devs" < dhis2-devs@lists.launchpad.net > Sent: Thursday, October 1, 2015 5:10:25 PM Subject: [Dhis2-devs] Removing Organization Units Dear All, I am trying to remove Organisation Units from DHIS2 versions 2.18 and 2.20 but i am getting error. But i had already removed the datasets associated with these Organisation Units but i still can't remove them. Please can someone help. -- Regards, Gerald ___ 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] Removing Organization Units
Hi Gerald, What error are you getting? If you have data associated with these org units, you will not be able to remove them until you delete the data in the database (even if you have removed the datasets). ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge - Original Message - From: "gerald thomas" To: "dhis2-users" , "dhis2-devs" Sent: Thursday, October 1, 2015 5:10:25 PM Subject: [Dhis2-devs] Removing Organization Units Dear All, I am trying to remove Organisation Units from DHIS2 versions 2.18 and 2.20 but i am getting error. But i had already removed the datasets associated with these Organisation Units but i still can't remove them. Please can someone help. -- Regards, Gerald ___ 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
[Dhis2-devs] [Bug 1495007] [NEW] Detailed Data Elements downloaded as uids rather than names for "plain data source with hierarchy download" type
Public bug reported: Data Element names (detailed) are been substituted with uids in csv file when downloaded from the DHIS. To replicate 1. Select a a few detailed data elements 2. Include orgunits in pivot view and choose option to show hierarchy 3. download output as csv with hierarchy Data element names are randomly substituted with DE uids. Replicated on Demo server. Affects 2.20 Rev 19881. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1495007 Title: Detailed Data Elements downloaded as uids rather than names for "plain data source with hierarchy download" type Status in DHIS: New Bug description: Data Element names (detailed) are been substituted with uids in csv file when downloaded from the DHIS. To replicate 1. Select a a few detailed data elements 2. Include orgunits in pivot view and choose option to show hierarchy 3. download output as csv with hierarchy Data element names are randomly substituted with DE uids. Replicated on Demo server. Affects 2.20 Rev 19881. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1495007/+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] Recieving DHIS2 Messages In email client of choice
Hi Farai, For users to receive Dhis2 messages via mail or SMS, individual profiles have to be enabled for messaging. That can be done under profile settings. .Sent from a mobile phone -Original Message- From: "Farai Mutero" Sent: 9/4/2015 5:40 To: "DHIS 2 developers" Subject: [Dhis2-devs] Recieving DHIS2 Messages In email client of choice Hi All I'm working on sending and receiving DHIS2 messages via the Web API based on the documentation here: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s20.html and I would like the message recipients to be able to view received messages in an email client of their choice e.g Microsoft Outlook. The following has already been done: - Email Settings have already been setup on the DHIS2 instance in question and is working correctly. - All DHIS2 Users have a valid email address associated with them, How do I go about doing this as the documentation does not specify? Thanks -- Farai Mutero___ 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 1490758] [NEW] Gauge Chart not using Legend Set Colour Scheme in 2.20
Public bug reported: Guage charts are supposed to use the colour coding for legend sets assigned to indicators, This is however not working in 2.20 (Build Revision 19811). Replicated on the SL Demo server. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1490758 Title: Gauge Chart not using Legend Set Colour Scheme in 2.20 Status in DHIS: New Bug description: Guage charts are supposed to use the colour coding for legend sets assigned to indicators, This is however not working in 2.20 (Build Revision 19811). Replicated on the SL Demo server. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1490758/+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] Complete Button But Not Working (Data Entry Forms)
Hi Brent, That tomcat message is not an "error" but a warning when approvals have not been set - I don't think it is related to your issue. You can check your browser console (F12) and debug to check any errors... Btw what version and build revision are you using? ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail@lists.launchpad.net] On Behalf Of Brent Williams Sent: 28 July, 2015 8:33 AM To: dhis2-devs@lists.launchpad.net Cc: dhis2-us...@lists.launchpad.net; Brendon Lines Subject: [Dhis2-devs] Complete Button But Not Working (Data Entry Forms) Dear Developers Data capturer wants to register a data entry form as complete after capturing data, after clicking the complete button the its not being greyed out with the name and date stamped at the bottom. Previously this button was working and then stopped allowing registration. Error found in the tomcat logs states: "No valid data sets specified for getting approvals, period 20150709 user username (HibernateDataApprovalStore.java [http-nio-8080-exec-12])". What could be the issue? Email and cc. Brent Williams Project Implementation Health Information Systems Program (HISP) - SA --- e-mail:br...@hisp.org <mailto:br...@hisp.org> Mobile: 071 542 9140 Skype:brent.williams267 Web:<http://www.hisp.org/> http://www.hisp.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] Using OrgUnit short names in charts, pivots, maps
That is correct…… A note however – this only became possible a little recently ( 2.17 ) , so may not work with older versions. https://lists.launchpad.net/dhis2-users/msg05765.html ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail@lists.launchpad.net] On Behalf Of Bharath Sent: 22 July, 2015 5:39 AM To: Calle Hedberg Cc: dhis2-devs Subject: Re: [Dhis2-devs] Using OrgUnit short names in charts, pivots, maps In user settings we have option to set "Property to display in analysis modules", may be this is what you are looking? https://apps.dhis2.org/demo/dhis-web-commons-about/userSettings.action On Wed, Jul 22, 2015 at 4:45 AM, Calle Hedberg mailto:calle.hedb...@gmail.com> > wrote: Hi I've got a bit of a dumb question - WHERE in the menu system can I specify that short names are to be used for OrgUnits, data elements, or indicators in charts, pivots, maps, etc? It has to be there somewhere, but as is typically the case when you are looking for a really basic/simple function it's elusive. I've searched the various manuals but not found anything - short names are mainly just referenced as fields in the resource tables and not how/when to use them. Regards Calle *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19274 Email: calle.hedb...@gmail.com <mailto:calle.hedb...@gmail.com> Skype: calle_hedberg *** ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Regards, Bharath Kumar. Ch ___ 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 1453569] Re: Sharing Feature not working for Dashboards
Hi Morten, Thanks for the fix.we are almost there now. Like you said, restricted users are still able to move items but new positions are not saved - that is correct. However, restricted users are still able to resize items, can also be quite troublesome, please take a look. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1453569 Title: Sharing Feature not working for Dashboards Status in DHIS: Fix Committed Bug description: Dashboards do not respect sharing settings when configured . For instance users who have not been given the authority to edit a dashboard can do so . Replicated on the demo server ( To do this , create a dashboard and assign only read permissions to "public" , then create a new user and login - new user can edit contents of dashboard ) Affects 2.18 Rev 18411 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1453569/+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] [Bug 1453569] Re: Sharing Feature not working for Dashboards
Great! Thanks Morten, will test and give feedback. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1453569 Title: Sharing Feature not working for Dashboards Status in DHIS: Fix Committed Bug description: Dashboards do not respect sharing settings when configured . For instance users who have not been given the authority to edit a dashboard can do so . Replicated on the demo server ( To do this , create a dashboard and assign only read permissions to "public" , then create a new user and login - new user can edit contents of dashboard ) Affects 2.18 Rev 18411 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1453569/+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] [Bug 1474060] [NEW] Users able to delete dashboard items without authorization
Hi Harding, That is right, this unusual behavior started in 2.18 A bug was reported on this a while back. See bug and progress here https://bugs.launchpad.net/dhis2/+bug/1453569 Regards, Dapo Adejumo +2348033683677 Skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail@lists.launchpad.net] On Behalf Of hardingt Sent: 13 July, 2015 6:00 PM To: dhis2-devs@lists.launchpad.net Subject: [Dhis2-devs] [Bug 1474060] [NEW] Users able to delete dashboard items without authorization Public bug reported: Hello Devs, Saw this occur on a production 2.18 machine by reading the logs, Confirmed this on 2.19 using the SL demo site Steps to recreate: 1. Create dashboard with administrator account 2. Set public as 'can view' 3. Add dashboard item, in my case it was a pivot table 4. Log in with user with the following rights: - Add/Update Data Value - Run validation - See Browser Cache Cleaner module - See Dashboard integration module - See Data Entry module - See Data Visualizer module - See Event Visualizer module - See GIS module - See Pivot Table module - See Report module - See Validation Rule module 5. Navigate to dashboard created in Step 1, click remove on any dashboard item - Note, it usually takes a page reload to reflect the results of this action, making it look like nothing happened until the refresh You should find that the dashboard item(s) is no longer there. Here is the relevant section of the log from the production 2.18 system: * INFO 2015-07-10 18:59:16,625 '[redacted]' delete org.hisp.dhis.dashboard.DashboardItem, uid: ov1BR9Hxj0z (AuditLogUtil.java [http-bio-8080-exec-276]) * INFO 2015-07-10 18:59:16,638 '[redacted]' update denied org.hisp.dhis.dashboard.Dashboard, name: Principaux, uid: NYmDyNmCqG6 (AuditLogUtil.java [http-bio-8080-exec-276]) You'll notice the dashboard item was removed, but the subsequent step to update the dashboard was denied. As user with proper authority will cause the following entries: * INFO 2015-07-12 17:18:28,794 'timharding' delete org.hisp.dhis.dashboard.DashboardItem, uid: P1XHv9Dxfsn (AuditLogUtil.java [http-bio-8080-exec-11]) * INFO 2015-07-12 17:18:28,803 'timharding' update org.hisp.dhis.dashboard.Dashboard, name: Baiap Health Centre, uid: T7WL4dirz1D (AuditLogUtil.java [http-bio-8080-exec-11]) We'd like it so that the users can see the dashboard but are unable to edit the contents. Please let me know if you need any additional info to sort this one out. Thanks! ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1474060 Title: Users able to delete dashboard items without authorization Status in DHIS: New Bug description: Hello Devs, Saw this occur on a production 2.18 machine by reading the logs, Confirmed this on 2.19 using the SL demo site Steps to recreate: 1. Create dashboard with administrator account 2. Set public as 'can view' 3. Add dashboard item, in my case it was a pivot table 4. Log in with user with the following rights: - Add/Update Data Value - Run validation - See Browser Cache Cleaner module - See Dashboard integration module - See Data Entry module - See Data Visualizer module - See Event Visualizer module - See GIS module - See Pivot Table module - See Report module - See Validation Rule module 5. Navigate to dashboard created in Step 1, click remove on any dashboard item - Note, it usually takes a page reload to reflect the results of this action, making it look like nothing happened until the refresh You should find that the dashboard item(s) is no longer there. Here is the relevant section of the log from the production 2.18 system: * INFO 2015-07-10 18:59:16,625 '[redacted]' delete org.hisp.dhis.dashboard.DashboardItem, uid: ov1BR9Hxj0z (AuditLogUtil.java [http-bio-8080-exec-276]) * INFO 2015-07-10 18:59:16,638 '[redacted]' update denied org.hisp.dhis.dashboard.Dashboard, name: Principaux, uid: NYmDyNmCqG6 (AuditLogUtil.java [http-bio-8080-exec-276]) You'll notice the dashboard item was removed, but the subsequent step to update the dashboard was denied. As user with proper authority will cause the following entries: * INFO 2015-07-12 17:18:28,794 'timharding' delete org.hisp.dhis.dashboard.DashboardItem, uid: P1XHv9Dxfsn (AuditLogUtil.java [http-bio-8080-exec-11]) * INFO 2015-07-12 17:18:28,803 'timharding' update org.hisp.dhis.dashboard.Dashboard, name: Baiap Health Centre, uid: T7WL4dirz1D (AuditLogUtil.java [http-bio-8080-exec-11]) We'd like it so that the users can see the dashboard but are unable to edit the contents. Please let me know if you need any additional info to sort this one
[Dhis2-devs] Problems using Chrome with GIS - 2.19
Hi Devs, Got this problem with a 2.19(rev 19251) database GIS module refuses to load on Chrome , gets stuck on initializing . Console shows the error below; Uncaught SyntaxError: Unexpected end of input custom.js:376 Uncaught ReferenceError: OpenLayers is not defined GIS opens fine using Firefox or IE on the same database. Any ideas? Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Reporting Rates using compulsory data elements
Hi Devs, Looks like generating reporting rates using compulsory data elements is not working at all ( tried on the demo instance too) - has anyone been able to use this successfully? Thanks. ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Batch lock exceptions
One more supporter of the blueprint! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail@lists.launchpad.net] On Behalf Of Jason Pickering Sent: 1 July, 2015 8:53 AM To: Morten Olav Hansen Cc: dhis2-devs Subject: Re: [Dhis2-devs] Batch lock exceptions Thanks Morten. Have created the blueprint here https://blueprints.launchpad.net/dhis2/+spec/lock-exceptions-api Regards, Jason On Wed, Jul 1, 2015 at 9:29 AM, Morten Olav Hansen mailto:morte...@gmail.com> > wrote: Jason Create a blueprint for lock exception API, and I will have a look at it.. can't promise it for 2.20 though. I agree it might be better to have it as a composite key, but these have a tendency to create havoc with our generic importer, so lets convert it to a idObject and keep it as it is for now. -- Morten On Wed, Jul 1, 2015 at 1:39 PM, Jason Pickering mailto:jason.p.picker...@gmail.com> > wrote: Also, while I am at it, I wonder why we need the "lockexceptionid" at all on the lockexception table? Isn't organisationunitid/periodid/datasetid enough as a primary key? What is the need for this integer primary key? Regards, Jason On Wed, Jul 1, 2015 at 8:30 AM, Jason Pickering mailto:jason.p.picker...@gmail.com> > wrote: Managed to find this rather old message and had a question. I need to generate a large number of lock exceptions, and using the UI has a couple of issues. 1) I need to select certain children of a given parent, which actually are assigned to the data set. However, when I select the top level node, I can filter on OU group, but cannot filter on the actual data set assignment itself. I only see data sets which belong to the top level node, rather than ALL possible datasets which I may need to generate lock exceptions for. 2) I looked in the docs, but did not see any way to use the API to generate these lock exceptions in bulk. Is there a way to do this? Seems that I could in theory use the dhis-web-maintenance-dataadmin/addLockException.action to do this, but with several tens of thousand lock exceptions which needs to be generated, this does not seem particular efficient. I suppose the alternative is to use inject the SQL into "lockexception", but maybe there is an easier way? Regards, Jason On Thu, Jun 28, 2012 at 9:13 PM, Abhijeet . mailto:abhijeet.7...@gmail.com> > wrote: hi selecting multiple period at a time is a good idea.. On Thu, Jun 28, 2012 at 6:21 PM, Olav mailto:op.registrer...@me.com> > wrote: Hi, just a thought on improving the lock exception: it would be good if it was possible to make exceptions for several datasets for several months at the same time. Liberia want to use the locking to increase the focus on timeliness, but it turns out even allowing one facility to enter a few months backlog is a lot of work. What if you first select period type, then one or more datasets, and finally one or more periods? Olav ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Regards, Abhijeet ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.com <mailto:jason.p.picker...@gmail.com> tel:+46764147049 -- Jason P. Pickering email: jason.p.picker...@gmail.com <mailto:jason.p.picker...@gmail.com> tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Bug 1469565] [NEW] Existing Relative Periods replaced by "New" Relative Periods in 2.19
Public bug reported: In 2.19, new relative periods have been introduced to the analysis modules - "This month" , "This week" , "This quarter" etc Before now for all relative periods except year, the latest relative period has been Last X... On upgrade to 2.19, all favorite objects (maps,tables or charts) created using last X e.g Last month as period have been converted to This month automatically. This give users an unpleasant surprise as their objects return a "no value found " response not because of no data values but because the upgrade had reset the periods. Kindly fix Affects 2.19 rev 19247 ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1469565 Title: Existing Relative Periods replaced by "New" Relative Periods in 2.19 Status in DHIS 2: New Bug description: In 2.19, new relative periods have been introduced to the analysis modules - "This month" , "This week" , "This quarter" etc Before now for all relative periods except year, the latest relative period has been Last X... On upgrade to 2.19, all favorite objects (maps,tables or charts) created using last X e.g Last month as period have been converted to This month automatically. This give users an unpleasant surprise as their objects return a "no value found " response not because of no data values but because the upgrade had reset the periods. Kindly fix Affects 2.19 rev 19247 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1469565/+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] List of permission in DHIS2
Hi Elmarie, There is a table in postgres called "userroleauthorities" - contains your available authorities. ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-users [mailto:dhis2-users-bounces+dapsyjorge=gmail@lists.launchpad.net] On Behalf Of Elmarie Claasen Sent: 9 June, 2015 7:19 PM To: dhis2-devs@lists.launchpad.net; dhis2-us...@lists.launchpad.net Subject: [Dhis2-users] List of permission in DHIS2 Hi all, Can anyone provide me with a complete list of available userrole authorities which appears on the left side when you create a user role? I don't see any table with that information in dhis2. Much appreciated - thanks Regards, Elmarie Claasen Project Manager Health Information Systems Program Tel: 041-367 1027 Cell: 082 374 2209 E-mail: <mailto:elma...@hisp.org> elma...@hisp.org Skype: elmarie.claasen52 This message and any attachments are subject to a disclaimer published at <http://www.hisp.org/policies.html#comms_disclaimer> http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to <mailto:disclai...@hisp.org> disclai...@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer. ___ 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] logging (for server administrators)
I think this is a good idea – it can be quite problematic managing log files on large servers. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapsyjorge=gmail@lists.launchpad.net] On Behalf Of Lars Helge Øverland Sent: 7 June, 2015 12:33 PM To: DHIS 2 Developers list; DHIS 2 Users list Subject: [Dhis2-devs] logging (for server administrators) Hi there, the way application logging (e.g. tomcat logging) in DHIS 2 worked up to now has not been ideal. Basically all log output has been sent to std out. For the tomcat container this means all logging has ended up in catalina.out under tomcat install dir > logs. This is not great since there is no simple way (beside using logrotate or other tools) to control the size of the log file or to specify custom locations for DHIS 2-related log content. This could cause a server to uncontrollably run out of disk space. In DHIS 2.19 this has changed so that DHIS 2-related log output is sent to the DHIS2_HOME location /logs (this is where you e.g. keep the hibernate.properties file, set by an env variable). The system also separates log output for the main background processes such as analytics table generation and import-export into separate files, so that you can easily look up errors/output for these without having to skim through lots of other content. So we now have 4 log files: /logs/dhis.log /logs/dhis-analytics-table.log /logs/dhis-data-exchange.log /logs/dhis-data-sync.log You can read more in the docs here: https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s07.html The system currently still logs to std out, as we wanted to introduce this gradually and not cause confusion. In 2.20 we plan to stop logging to std out (catalina.out) completely, and only use the log files under DHIS2_HOME. I am interested to hear if people are comfortable with this and if it sounds like a good solution. regards, Lars ___ 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 1453569] Re: Sharing Feature not working for Dashboards
Hi Morten, This bug is still there. Let me explain a bit more. The dashboard itself respects the sharing settings - i.e a user without edit rights cannot manage the dashboard (delete or share it) . This however does not follow with the dashboard items, a user without write permissions can move,resize or delete dashboard items . Easy to replicate on demo - Change any of the existing dashboard sharing settings to allow public only view authority, create a guest user and login. You will see that you can manipulate the dashboard items (not the dashboard itself though). -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1453569 Title: Sharing Feature not working for Dashboards Status in DHIS 2: New Bug description: Dashboards do not respect sharing settings when configured . For instance users who have not been given the authority to edit a dashboard can do so . Replicated on the demo server ( To do this , create a dashboard and assign only read permissions to "public" , then create a new user and login - new user can edit contents of dashboard ) Affects 2.18 Rev 18411 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1453569/+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] [Bug 1453569] Re: Sharing Feature not working for Dashboards
Thanks. Will test and give feedback. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1453569 Title: Sharing Feature not working for Dashboards Status in DHIS 2: Fix Committed Bug description: Dashboards do not respect sharing settings when configured . For instance users who have not been given the authority to edit a dashboard can do so . Replicated on the demo server ( To do this , create a dashboard and assign only read permissions to "public" , then create a new user and login - new user can edit contents of dashboard ) Affects 2.18 Rev 18411 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1453569/+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] [Bug 1455035] Re: Sharing settings changes itself to none thus making the items restricted to Systems Administrators
That is correct - Just reported an issue related to this. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1455035 Title: Sharing settings changes itself to none thus making the items restricted to Systems Administrators Status in DHIS 2: New Bug description: In DHIS2 2.18 of build date 2015-04-11 02:04, Sharing settings changes itself to none thus making the items restricted to Systems Administrators.This affects almost everything [datasets, categories, etc]. All of a sudden, datasets, categories created as new dimension were not visible by other users without the user role of systems administrators [ALL]. Changing the sharing settings to none and then back to "Can View and Edit" clears the issue. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1455035/+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] Issues with Datasets after revision upgrage
Some more details on the error, Affected form does not appear in data entry when selected for all users except superusers. Data set also does not appear in the list for datasets in report modules - reporting rate summaries, dataset reports or pivot tables. Only Superusers can see this dataset. Nginx and Browser caches have been cleared with resolution . Any ideas on this? Thank you. ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dapo Adejumo [mailto:dapo_adej...@yahoo.com] Sent: 14 May, 2015 10:21 AM To: dhis2-devs@lists.launchpad.net Subject: Issues with Datasets after revision upgrage Hi Devs, We are getting this error after upgrading 2.18 to revision 18442. * WARN 2015-05-14 10:11:28,620 Illegal input, org unit: [IdentifiableObject: id ='179333', uid='lADXKVZQuRy', code='null', name='la Eboa Medical Centre', create d='2012-09-19 17:46:09.913', lastUpdated='2014-05-17 00:02:36.523', class='class org.hisp.dhis.organisationunit.OrganisationUnit"'], period: [Monthly: Wed Apr 0 1 00:00:00 WAT 2015 - Thu Apr 30 00:00:00 WAT 2015], data set: null (GetDataValu esForDataSetAction.java [tomcat-http-9]) Any ideas why this is happening? ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Issues with Datasets after revision upgrage
Hi Devs, We are getting this error after upgrading 2.18 to revision 18442. * WARN 2015-05-14 10:11:28,620 Illegal input, org unit: [IdentifiableObject: id ='179333', uid='lADXKVZQuRy', code='null', name='la Eboa Medical Centre', create d='2012-09-19 17:46:09.913', lastUpdated='2014-05-17 00:02:36.523', class='class org.hisp.dhis.organisationunit.OrganisationUnit"'], period: [Monthly: Wed Apr 0 1 00:00:00 WAT 2015 - Thu Apr 30 00:00:00 WAT 2015], data set: null (GetDataValu esForDataSetAction.java [tomcat-http-9]) Any ideas why this is happening? ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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 1453569] [NEW] Sharing Feature not working for Dashboards
Public bug reported: Dashboards do not respect sharing settings when configured . For instance users who have not been given the authority to edit a dashboard can do so . Replicated on the demo server ( To do this , create a dashboard and assign only read permissions to "public" , then create a new user and login - new user can edit contents of dashboard ) Affects 2.18 Rev 18411 ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1453569 Title: Sharing Feature not working for Dashboards Status in DHIS 2: New Bug description: Dashboards do not respect sharing settings when configured . For instance users who have not been given the authority to edit a dashboard can do so . Replicated on the demo server ( To do this , create a dashboard and assign only read permissions to "public" , then create a new user and login - new user can edit contents of dashboard ) Affects 2.18 Rev 18411 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1453569/+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] Added Orgunits/added datasets distorting old reporting rates
Thanks Prosper for resuscitating this perennial issue. The problem is real especially where you have a high turnover of health facilities ( mostly private health facilities) – and to complicated the problem, its is not only limited to “opening” and “closing” but also when health facilities move from one parent to another. Calle, the idea of using a “null activity report” may work but the challenge is that most reporting rate calculations are based on complete dataset registrations which are removed from actual data value count. Using the option of “compulsory data elements” basis of completeness . However there are been many field challenges in defining these compulsory data elements. Any great ideas to navigate this challenge will be great! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Calle Hedberg Sent: 1 April, 2015 10:57 AM To: Jason Pickering Cc: Prosper BT; DHIS developers Subject: Re: [Dhis2-devs] Added Orgunits/added datasets distorting old reporting rates Hi, The system should ONLY consider absolute (real) opening and closing dates, and should not accept any report for a reporting unit outside of this (what we generally call its "validity period"). reporting units with irregular activities must be handled "manually" - there are basically two options: 1. You exclude certain types of typically irregular operations from your completeness analysis. Typical cases would be irregular mobile units. 2. You capture a null activity report for irregular ops when they are inactive (e.g. enter a zero for the headcount data element or similar). That null report will thus be part of your completeness rate. Regards Calle On 1 April 2015 at 11:34, Jason Pickering mailto:jason.p.picker...@gmail.com> > wrote: Yeah, I do not know really how complicated it would be to implement in DHIS2, but I do know we have performed this type of analysis in other places outside of DHIS2 with SQL and scripts. Basically, it would involve getting all of the opening and closed dates of the facilities, and then the completed data set registrations and performing a period by period type of analysis on the reporting rates, to provide a dynamic denominator (i.e. number of facilities which are supposed to report). However, in practice, what we saw was that the opening/closed dates were often not really that accurate, often leading to percentages over 100%, since the facility was supposedly closed, but still submitted a report. I think if it is that big of a problem (sounds bad), you should to consider to implement a custom report which would take this into account, but maybe the developers could comment on how difficult this would be to implement. Perhaps the bigger problem however is the focus on reporting compelteness, as opposed to what is actually in the data? :-/ Regards, Jason On Wed, Apr 1, 2015 at 11:25 AM, Prosper BT mailto:ptb3...@gmail.com> > wrote: Thanks Jason, I know its complicated and very difficult to implement but in traditional national system focusing on reporting rates, it has come to point where districts would rather not add an Orgunit and if closed would want it deleted out of the systems or dataset removed. May be Analytics should consider Opening data and closing date, so that new Orgunit are given a current opening date Regards On Wed, Apr 1, 2015 at 12:12 PM, Jason Pickering mailto:jason.p.picker...@gmail.com> > wrote: This is really a quite intricate problem, if it is going to be done right. The easy "fix" would be to ignore whether a facility contrinbutes to completeness rates if the opening and closed dates are not valid. In practice however, it is more complicated than that, because a facility may only report a data set for a few months, or be open only parts of the year (I have seen this in two countries now, where certain facilities are always closed during certain months, i.e. the Himalayan winter and tropical rainy season). So, how would we account for this? The opening and closed dates really have no meaning in this case, because it is only open sometimes, and thus, is not expected to submit a repo So, although it might fix the problem of adding new facilities and closing existing ones, I am not really so sure it would really solve the actual problem. Regards, Jason On Wed, Apr 1, 2015 at 11:02 AM, Calle Hedberg mailto:calle.hedb...@gmail.com> > wrote: Prosper, HISP-SA is working on a few related issues: - Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators. - Validity periods for indicators - Validity
[Dhis2-devs] [Bug 1437521] [NEW] Sorting Charts by size in data visualizer does not recognize zero values
Public bug reported: Charts in the data visualizer can be sorted from either high to low or vice versa. It is assumed that chart category members with zero values should be included in this sorting but this does not happen giving rise to distorted charts when zeros are involved. Affects 2.18 rev 18721. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1437521 Title: Sorting Charts by size in data visualizer does not recognize zero values Status in DHIS 2: New Bug description: Charts in the data visualizer can be sorted from either high to low or vice versa. It is assumed that chart category members with zero values should be included in this sorting but this does not happen giving rise to distorted charts when zeros are involved. Affects 2.18 rev 18721. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1437521/+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] Google Street Layer - Dashboard
Great. Thanks ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Jan Henrik Øverland [mailto:janhenrik.overl...@gmail.com] Sent: 22 March, 2015 8:22 PM To: Dapo Adejumo Cc: DHIS 2 Developers list Subject: Re: Google Street Layer - Dashboard Hi Dapo, it is currently fixed, but should definitely follow what is saved in the favorite. Will fix this. Jan On Sun, Mar 22, 2015 at 8:11 PM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, Is there a way to use the google street background optionally or is this fixed for all maps on the dashboard? Thanks ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Google Street Layer - Dashboard
Hi Devs, Is there a way to use the google street background optionally or is this fixed for all maps on the dashboard? Thanks ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Android app error "Bad server response"
Hi Seid, Just got out of troubleshooting the J2ME client for some errors. You may want to check Nginx logs for any errors ( or any other proxy server you may be using) for useful information on the cause of your error. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Seid Hussein Sent: 24 February, 2015 1:24 PM To: dhis2-devs@lists.launchpad.net Subject: [Dhis2-devs] Android app error "Bad server response" Hi all, We have been planning to deploy the DHIS2 data capture app on Android devices here in Ethiopia. However, even though we have been successful in logging in the app, it doesn't load any of the forms and gives an error "Bad server response". The same is true for the DHIS2 global demo. Any thoughts? Seid, ___ 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] Completeness in Reporting Rate Summary and Analytics based tools
Hi Devs, The reporting rate summary currently pulls data from tables different from the analytics which often gives a variance to what is pulled off the analytics based tools like the pivot table and GIS . I remember that dropping the tables used by the reporting rate summary and replacing with the analytics had been discussed before and was going to be implemented? Any idea when this will be done? - didn't find in any of the near future milestones . Hopefully this will also make it possible to query timeliness via the analytics tables. Thanks. ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Clear Cache App
Thanks Abyot. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: 28 January, 2015 10:09 AM To: Dapo Adejumo Cc: dhis2-devs Subject: Re: Clear Cache App Hi Dapo, No it is not in the app repository. Released as part of the core apps in DHIS 2 (from 2.18 on) --- Thank you, Abyot. On Wed, Jan 28, 2015 at 9:48 AM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Abyot and Devs, Got wind of an app dedicated to cache clearing for users – is this app available publicly , its not on the app repository . Is there a download link to get this? Thanks ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] Clear Cache App
Hi Abyot and Devs, Got wind of an app dedicated to cache clearing for users - is this app available publicly , its not on the app repository . Is there a download link to get this? Thanks ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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 1407056] [NEW] Data Visualizer and Pivot Tables showing wrong Relative Yearly Periods
Public bug reported: Relative yearly periods not working properly in Data Visualizer and Pivot Table Apps. Selection rewinds the desired period by one year. To replicate on demo, create a table/chart and select "This year" , chart/table shows data for 2014. Affects 2.17 rev 17793. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1407056 Title: Data Visualizer and Pivot Tables showing wrong Relative Yearly Periods Status in DHIS 2: New Bug description: Relative yearly periods not working properly in Data Visualizer and Pivot Table Apps. Selection rewinds the desired period by one year. To replicate on demo, create a table/chart and select "This year" , chart/table shows data for 2014. Affects 2.17 rev 17793. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1407056/+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] [Bug 1404691] [NEW] Organisation Unit Merge Fails due to bad SQL Syntax
Public bug reported: Trying to merge 2 organisation units via data administration - interface reports "merging done" but the process actually fails with the critical error occuring in the last sql statement.."DELETE FROM datavalue_audit WHERE sourceid=." giving this error "ERROR: relation "datavalue_audit" does not exist" , the audit table that exists is named "datavalueaudit" . Affects 2.16 rev 17618and 2.17 rev 17663 ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1404691 Title: Organisation Unit Merge Fails due to bad SQL Syntax Status in DHIS 2: New Bug description: Trying to merge 2 organisation units via data administration - interface reports "merging done" but the process actually fails with the critical error occuring in the last sql statement.."DELETE FROM datavalue_audit WHERE sourceid=." giving this error "ERROR: relation "datavalue_audit" does not exist" , the audit table that exists is named "datavalueaudit" . Affects 2.16 rev 17618and 2.17 rev 17663 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1404691/+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] Metadata Import - Domaintype conflict
Hi Devs, The domaintype “aggregate” has been changed to “AGGREGATE” in the dataelement table for 2.17….any particular reason for this change? This change is not one of the specified changes in the upgrade notes for 2.17 While the change occurs with the upgrade – it causes problems with back compatibility in metadata imports involving dataelements since the legacy builds will have the “aggregate” domaintype . I suspect this will also affect tracker dataelements. Should be worth taking a look at….. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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 1399528] [NEW] Analytics Table Update fails in 2.17 (17612)
Public bug reported: Analytics tables update fails in current versions of 2.17 ( 17612) . Process runs fine with earlier builds ( 2.17 Snapshot - 17141). Temp tables are not built with reports of problems with the "ou" column (" nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "ou" violates not-null constraint"). ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1399528 Title: Analytics Table Update fails in 2.17 (17612) Status in DHIS 2: New Bug description: Analytics tables update fails in current versions of 2.17 ( 17612) . Process runs fine with earlier builds ( 2.17 Snapshot - 17141). Temp tables are not built with reports of problems with the "ou" column (" nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "ou" violates not-null constraint"). To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1399528/+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] Analytics error - "ou" 2.17
Hi Devs, I am not sure if this is a bug - but analytics are failing using 2.17 (17612) . Logs are attached, any idea why this may be happening? Thanks ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge Analytics table process failed, please check the logs. Message: Exception during execution Cause: java.util.concurrent.ExecutionException: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [insert into analytics_temp_2011 ("WvnXLJQg6vR","Xb8MVrtez6o","UnOmEE9l51L","RR8jNDrhGKL","bVXoPNpgXAi","dAOtelbj68d","KAnPRETzLNh","GvScnquL6Se","PUrZmTIlCyV","zKUIte9NQVI","WLQLDowcGDZ","zhOEXizCfpv","FNy77BoJMs9","gvouMf8sojT","Ryd8YxcKWcz","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","sixmonthlyapril","yearly","financialapril","financialjuly","financialoct","de","co","ou","level",daysxvalue, daysno, value, textvalue) select degs."WvnXLJQg6vR",degs."Xb8MVrtez6o",degs."UnOmEE9l51L",ougs."RR8jNDrhGKL",ougs."bVXoPNpgXAi",ougs."dAOtelbj68d",ougs."KAnPRETzLNh",ougs."GvScnquL6Se",ougs."PUrZmTIlCyV",ougs."zKUIte9NQVI",ougs."WLQLDowcGDZ",ougs."zhOEXizCfpv",ougs."FNy77BoJMs9",dcs."gvouMf8sojT",acs."Ryd8YxcKWcz",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ps."daily",ps."weekly",ps."monthly",ps."bimonthly",ps."quarterly",ps."sixmonthly",ps."sixmonthlyapril",ps."yearly",ps."financialapril",ps."financialjuly",ps."financialoct",de.uid,co.uid,ous.organisationunituid,ous.level,cast(dv.value as double precision) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as double precision) as value, null as textvalue from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.organisationunitid left join _periodstructure ps on dv.periodid=ps.periodid left join dataelement de on dv.dataelementid=de.dataelementid left join _dataelementstructure des on de.dataelementid = des.dataelementid left join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid left join period pe on dv.periodid=pe.periodid where de.valuetype = 'int' and de.domaintype = 'AGGREGATE' and pe.startdate >= '2011-01-01' and pe.startdate <= '2011-12-31' and dv.value is not null and dv.value ~* '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; ERROR: null value in column "ou" violates not-null constraint Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null).; nested exception is org.postgresql.util.PSQLException: ERROR: null value in column "ou" violates not-null constraint Detail: Failing row contains (d46FIWZqIhI, null, null, null, null, null, null, rtZY2mEY1Sp, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 201103, 201102B, 2011Q1, 2011S1, 2011AprilS2, 2011, 2010April, 2010July, 2010Oct, o4NSxSAlNu1, Y2SrnZVI87k, null, null, 62, 31, 2, null). at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:188) at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:216) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:123) at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:136) at org.hisp.dh
Re: [Dhis2-devs] dhis version 2.17 is released
Nice work! Happy to see that shortname option in analysis modules made it ! A question, what is the default setting for this? shortname or name ? Congratulations ! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Lars Helge Øverland Sent: 21 November, 2014 2:25 PM To: DHIS 2 Users list; DHIS 2 Developers list; Vincent Shaw; Calle Hedberg; Ayub Manya; Martin Osumba; Schaefer, Petra; Paul Bouey; Gehron, Michael M; Tyler R Smith; Jorge Queipo; Bale, Jeffrey M. (CDC/CGH/DGHA) (CTR); Denis Adaletey; Austen Peter Davis; Lene Jeanette Lothe; Egwuma Efo; Lakshmi Balachandran; Gaurav Bhattacharya; Kiran Prakash; Megan McGuire; Carme BARALDES; Carl Leitner; Jaco Venter; Chris Seebregts; Chris Moyo; sundeep; Jørn Braa; Pascal Brandt; Carl Fourie; Amuha, Monica; Linda Fogarty; Ellen Brazier; Paul Amendola; Ernest Ostro; Benjamin Winters; Ransom, Ray (CDC/CGH/DGHA); Thomas, Vilma; Buehler, Jacob H. (GH/OHA/SPER:CAMRIS); Cooper, Hannah J; DeZalia, Mark (CDC/CGH/DGHA) (CTR) (m...@cdc.gov); Joshua Volle; Jamie Clearfield; David Giron; Matthew Saaks; Scott Merritt; Parisa Kharazi; Timothy Harding; Shekhar, Navendu Subject: [Dhis2-devs] dhis version 2.17 is released Hi all, DHIS 2 version 2.17 is out. We have a wide range of features and improvements for you. The main focus of this release has been performance, analytics, data exchange and interoperability. Better performance and scalability: Several parts of the system work faster and smoother, including loading of the organisation unit tree, loading of meta-data in data entry, import and export of data and generation of resource tables. Data entry meta-data now respects the offline hierarchy level setting, making it possible to handle very large org unit trees and number of data sets. Demo <https://apps.dhis2.org/demo/dhis-web-dataentry/index.action> Option codes: Options in option sets now have codes as well as names, where the code cannot be changed. This implies that options are more robust, since the name of the option can be changed and translated into multiple languages without affecting existing data or attribute values. All apps will display the option name in the user interface and use the option code for fetching data from the system. In the list of option sets, click "option management" to view options: Demo <https://apps.dhis2.org/demo/dhis-web-maintenance-dataadmin/optionSet.action> | Demo <https://apps.dhis2.org/demo/dhis-web-event-reports/index.html?id=fA9MsWSqfc7> Average aggregation operator: Analytics now support an average aggregation operator where data will averaged in both the time period and organisation unit dimensions. The current average operator has been renamed to "Average (sum in org unit hierarchy)" to better reflect what it is actually doing. Screenshot <http://folk.uio.no/larshelg/images/217/average-operator.png> Long text: The system support long text data values and comments. A data value can now store up to 60'000 characters, which is the equivalent of 12 pages of text. This makes the system suitable as a text repository. This is useful e.g. for using to system to store narratives linked to data elements and organisation units. See form "Mortality < 5 Narratives" on demo: Demo <https://apps.dhis2.org/demo/dhis-web-dataentry/index.action> | Screenshot <http://folk.uio.no/larshelg/images/217/text-data-entry.png> Text in analytics: The analytics engine now support text. This means that you can produce pivot tables and standard reports with textual content. This is useful e.g. to present narratives next to data element values in the same report. Demo <https://apps.dhis2.org/demo/dhis-web-pivot/index.html?id=u17G7LxWEK6> Browser support notification: The front page now shows a notification for people using a browser which is not supported by DHIS 2. From version 2.17, Internet Explorer versions 6, 7 and 8 are no longer supported. Screenshot <http://folk.uio.no/larshelg/images/217/browser-support-notification.png> Apps as start page: External apps can now be set as start page from settings > appearance > start page. Demo <https://apps.dhis2.org/demo/dhis-web-maintenance-settings/systemAppearanceSettings.action> Display name in analysis apps: A new user setting lets you define whether to use the name or the short name of meta-data items in all analysis apps, both aggregate and event-based. As an example, it lets you define whether to display the full name or short name of data elements in the pivot table app. You can access user settings from Profile > Settings: Demo <https://apps.dhis2.org/demo/dhis-web-commons-about/userSettings.action> Simpl
Re: [Dhis2-devs] [Dhis2-users] Eivind Eriksen joins as developer
Welcome! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Greg Rowles Sent: 12 November, 2014 10:59 PM To: Wilfred Senyoni Cc: Nicola Hobby; DHIS 2 Users list; DHIS developers Subject: Re: [Dhis2-devs] [Dhis2-users] Eivind Eriksen joins as developer Welcome Eivind! If you're attending our South Africa conference next year - I hope to meet you there! On Wed, Nov 12, 2014 at 10:47 PM, Wilfred Senyoni mailto:seny...@gmail.com> > wrote: Welcome to the team Eivind. Wilfred On 12 Nov 2014 18:41, "Jim Grace" mailto:jimgr...@gmail.com> > wrote: Welcome Eivind! Cheers, Jim On Wed, Nov 12, 2014 at 7:46 AM, Nicola Hobby mailto:nho...@psi.org> > wrote: Welcome Eivind, from the PSI team! -- Nicola Hobby MIS Program Manager Office: +1 (202) 469-6685 Skype: nicolahobby Connect with PSI <http://www.psi.org/> Website | <http://blog.psiimpact.com/> Blog | <https://twitter.com/PSIimpact> Twitter | <https://www.facebook.com/PSIHealthyLives> Facebook | <http://www.youtube.com/user/healthybehaviors> YouTube <http://www.psi.org/> <http://blog.psiimpact.com/> <https://twitter.com/PSIimpact> <https://www.facebook.com/PSIHealthyLives> <http://www.youtube.com/user/healthybehaviors> Donate to PSI <http://www.psi.org/> www.psi.org. 94.5 cents of every dollar raised directly supports PSI programs. From: Morten Olav Hansen mailto:morte...@gmail.com> > Date: Wednesday, November 12, 2014 at 8:40 AM To: Jan Henrik Øverland mailto:janhenrik.overl...@gmail.com> > Cc: dhis2-users mailto:dhis2-us...@lists.launchpad.net> >, DHIS list mailto:dhis2-devs@lists.launchpad.net> > Subject: Re: [Dhis2-users] [Dhis2-devs] Eivind Eriksen joins as developer Welcome to the team! -- Morten On Wed, Nov 12, 2014 at 6:12 PM, Jan Henrik Øverland mailto:janhenrik.overl...@gmail.com> > wrote: Welcome! On Wed, Nov 12, 2014 at 12:58 PM, Abyot Gizaw mailto:aby...@gmail.com> > wrote: Welcome Eivind ! --- Thank you, Abyot. On Wed, Nov 12, 2014 at 12:51 PM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: Hi all, I have the pleasure to announce that Eivind Eriksen has joined the team as software developer. Eivind will work 40% this year, then full time from January. Eivind has 6 years of experience as Java software developer at Eniro, Visma, 3Media and has been working on search, monitoring and web portals. Eivind is 29 and originally from the northern city of Tromsø, Norway. We are excited to you get on the team. Welcome! regards, Lars ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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 <mailto: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 <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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 <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- <http://hispsa.org/timesheets/images/HISP-logo.png> Business Intelligence Planner Health Information Systems Programme - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Mobile :073 246 2992 Landline: 021 554 3130 Fax: 086 733 8432 Skype: gregory_rowles ___ 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 tracker for logistics
Hi Hannan, The UNCOLSC is using the DHIS2 sms system to track commodity stock outs at health facilities. Health Facility staff send stockouts of life saving commodities to a central DHIS2 System. You are talking about tracking "assets" - the CCEM ( https://launchpad.net/dhis2-ccei ) although designed for Cold Chain equipment may well serve your purpose. ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Hannan Khan Sent: 30 October, 2014 9:07 AM To: dhis2-us...@lists.launchpad.net; DHIS 2 developers Subject: [Dhis2-devs] DHIS2 tracker for logistics Dear Experts We all know that DHIS2 tracker can be used for tracking any entities, so it can be used as asset tracker. We already implemented DHIS2 in Bangladesh at the national level and scaled down to the community level and still expanding. Our Health sector now wants to track asset of all facilities. SO far I learn that UNCOLSC are using DHIS2 for logistics; can any body please share with me the detail of that implementation. Any one have a demo of 'asset tracking' using DHIS2? Please response as soon as possible. Hannan Khan ___ 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] [Dhis2-users] Data import - with completeness
Hi, There is no straightforward way to do this at the moment but an improvement in 2.17 takes care of importing complete dataset registrations via the API – details here https://blueprints.launchpad.net/dhis2/+spec/complete-registrations-exchange Alternatively, you could use an update script to populate the completedatasetregistration table based on the datavalue table – the draw back here is that you lose some data related to registerin user and dates. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-users [mailto:dhis2-users-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of sumudu weerasinghe Sent: 22 October, 2014 2:45 PM To: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list; Roshan Hewapathirana Subject: [Dhis2-users] Data import - with completeness Dear All, I need to import my data from one instance to another instance . Data was export from first instance as CSV format and then import to second instance through CSV data import. In my first instance data set was completed , but after importing to new instance it shows as incomplete. So reporting rate summary give wrong impression. Is there way of export and import data with completeness? Best regards, Sumudu ___ 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] Weird Reporting Rates
Hi Devs, I know this has been reported a few times earlier on the list but I didn't find any conclusive solutions in the archives. We are getting rates above 100% in the reporting rate modules (Pivot , Visualizer and GIS) that depend on the analytics tables . Rates are normal using the Reporting rate summary which doesn't use the analytics . For instance a facility has a reporting rate of 100% but the parent has 200% - checked to see if analytics_orgunittarget table had duplicates..but No. Any experience or suggestions on this? ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] dhis2 system administration list
Absolutely great idea! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of J. Paul Mutali Sent: 9 October, 2014 8:35 AM To: gerald thomas Cc: dhis2-users; Steven Uggowitzer; dhis2-devs Subject: Re: [Dhis2-devs] [Dhis2-users] dhis2 system administration list The idea is great, this domain is growing especially with security bugs being discovered here and there and which needs attention of system admins, also the could is expanding, a group dedicated to that will be helpful in the implementation of DHIS-2 regards, JPaul On Wed, Oct 8, 2014 at 11:54 PM, gerald thomas mailto:gerald17...@gmail.com> > wrote: Bob, I think the vision is good especially for backend users who are not too interested on the java stuff. I welcome the idea boss. On 10/8/14, Bob Jolliffe mailto:bobjolli...@gmail.com> > wrote: > Hi all > > Steven Uggowitzer recently raised the idea with me to create a system > administrators list. Aimed at backend sort of things relating to the > operating system, security, database tuning, dhis2-tools, virtual machine > images etc. > > Those geeky sort of things which are not about java development or about > users as such, but all the stuff that needs to happen in between. > > I said I'd run it by our extended community and try and gauge interest. > Please reply in this thread if you think its a good idea (or not). If > there is sufficient interest we can look at setting up. > > Cheers > Bob > -- Regards, Gerald ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
Thanks Jason – Was shying away from a report solution to a more permanent one. Extra operators or tools to extend the functionality of indicator calculations will improve what we currently have – A blueprint will probably be in order. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: 5 October, 2014 2:27 PM To: Dapo Adejumo Cc: Robin Martens; dhis2-us...@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Dapo, I think it is related in that it shows how we cannot calculate more "complicated" indicators. In this case, it is really a case of having some operator like "IF" in spreadhseet programs. E.g... IF(logical_test ,true_value,false_value) In your case, it would be something like IF (BCG coverage < 50%, 1, 0 ) This need for this operator has come up a few times, and it would be good to see how this could be improved. Even better would be the ability to support a standard scripting language/syntax which could be used to support different types of indicators which we may not have thought of yet. I think the only solution would be some type of report which would pull all of the BCG values at the desired OU level, apply the formula above, and return the result (or of course, some sort of database script which could automatically calculate the value ). Regards, Jason On Sun, Oct 5, 2014 at 11:55 AM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Jason and Robin ( and Devs) , I decided to raise this question here since it is remotely related to the discussions below. I want an indicator that has inputs beyond what is currently available for indicator definitions – for example -Percentage of Health facilities with BCG coverage below 50% Number of Health facilities can be pulled in using the orgunit count but the challenge is the numerator (number of health facilities with coverage less than 50%) The BCG Coverage is calculated as a separate indicator but can technically be recalculated in the numerator definition – how can the 50% logic be introduced in the numerator formula?. The only work around I have thought of is the creation of a dataelement like “ BCG Coverage less than 50%” that is populated by a script with a value 1 when coverage is less than 50% for the facility and then used as the numerator in the indicator calculation. Jason and Robin have talked below on the possibility of extending the current configuration possibilities of indicators probably including some Logic functions similar to what is in the Validation rules. Has anybody dealt with similar scenarios like the example above or any ideas on possible solutions. Thanks! ………………… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo <mailto:dhis2-devs-bounces%2Bdapo_adejumo> =yahoo@lists.launchpad.net <mailto:yahoo@lists.launchpad.net> ] On Behalf Of Jason Pickering Sent: 16 September, 2014 9:06 AM To: Robin Martens Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> ; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, I think that is the real issue, namely that you are applying DHIS2 in a domain which is slightly different than it's typical domain, namely health. I have been involved in some other projects with DHIS2 on the fringes of what it can do out of the box in food security, water and sanitation, even using it for recording golf handicap scores. What I have seen in each of these domains is that there are some challenges with the way that the data is aggregated. Lots of things work out of the box, like data collection, user management and security, etc. But sometimes, the analysis needs to be done externally through other means. Of course, it would be great if DHIS2 could do all of this for all domains, but since its primary focus is on collection and management of health data, that is where things work most often (although there are some challenges there as well, particular on data which needs to be averaged or handled different in time or across orgunits, such as ART current count). Contributions from the community are of course welcome! :) Regards, Jason On Fri, Sep 12, 2014 at 8:55 AM, Robin Martens mailto:mart...@sher.be> > wrote: Hi Jason, Thanks for taking the time to read through my email. I'll have a look at the different possibilities you proposed, and we'll be looking forward to any future upgrade of the calculation method (for now or later). I guess it's just that some sectors need more complex indicators than others (our project is in forest management). Have a nice day, Robin From: Ja
Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
Hi Jason and Robin ( and Devs) , I decided to raise this question here since it is remotely related to the discussions below. I want an indicator that has inputs beyond what is currently available for indicator definitions – for example -Percentage of Health facilities with BCG coverage below 50% Number of Health facilities can be pulled in using the orgunit count but the challenge is the numerator (number of health facilities with coverage less than 50%) The BCG Coverage is calculated as a separate indicator but can technically be recalculated in the numerator definition – how can the 50% logic be introduced in the numerator formula?. The only work around I have thought of is the creation of a dataelement like “ BCG Coverage less than 50%” that is populated by a script with a value 1 when coverage is less than 50% for the facility and then used as the numerator in the indicator calculation. Jason and Robin have talked below on the possibility of extending the current configuration possibilities of indicators probably including some Logic functions similar to what is in the Validation rules. Has anybody dealt with similar scenarios like the example above or any ideas on possible solutions. Thanks! ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Jason Pickering Sent: 16 September, 2014 9:06 AM To: Robin Martens Cc: dhis2-us...@lists.launchpad.net; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, I think that is the real issue, namely that you are applying DHIS2 in a domain which is slightly different than it's typical domain, namely health. I have been involved in some other projects with DHIS2 on the fringes of what it can do out of the box in food security, water and sanitation, even using it for recording golf handicap scores. What I have seen in each of these domains is that there are some challenges with the way that the data is aggregated. Lots of things work out of the box, like data collection, user management and security, etc. But sometimes, the analysis needs to be done externally through other means. Of course, it would be great if DHIS2 could do all of this for all domains, but since its primary focus is on collection and management of health data, that is where things work most often (although there are some challenges there as well, particular on data which needs to be averaged or handled different in time or across orgunits, such as ART current count). Contributions from the community are of course welcome! :) Regards, Jason On Fri, Sep 12, 2014 at 8:55 AM, Robin Martens mailto:mart...@sher.be> > wrote: Hi Jason, Thanks for taking the time to read through my email. I'll have a look at the different possibilities you proposed, and we'll be looking forward to any future upgrade of the calculation method (for now or later). I guess it's just that some sectors need more complex indicators than others (our project is in forest management). Have a nice day, Robin From: Jason Pickering [mailto:jason.p.picker...@gmail.com <mailto:jason.p.picker...@gmail.com> ] Sent: 11 September 2014 19:00 To: Robin Martens Cc: Lars Helge Øverland; dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net> ; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions Hi Robin, Your mail is dense and will need some digestion. :) You give a very good level of detail however of you problem in this mail and will be very useful as this type of functionality is attempted to be implemented. To respond immediately to how you might be able to solve the issue, you should possibly consider using the WebAPI to extract your data, process it as you need, and then inject it back into DHIS2. The WebAPI is described in detail here <https://www.dhis2.org/doc/snapshot/en/user/html/ch32.html> . I have also written a chapter on the use of the R programming language with DHIS2, which is particularly well suited to do the type of custom calculations you are describing here. It is available here <https://www.dhis2.org/doc/snapshot/en/user/html/apc.html> . Of course, other language/methods may also be more suited to your situation, such as Python. Lastly, you can have a look at the DHIS2 Ad-hoc tool <http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/files/head:/tools/dhis-adhoc/> which would allow interaction with the service layer of DHIS2. Another approach could be SQL which interacts directly with the database. I am sure there are many other means as well. So short answer is, right now there is no in-built way to achieve what you need I think, and it will take some coding on your side. We have run into similar issues in
[Dhis2-devs] [Bug 1373147] Re: Pivot Table: data elements panel doesn't populate when details is selected
Juan is right - This only happens when DE groups are selected. The error can be duplicated on the Sierra Leone demo so it is most likely a bug. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1373147 Title: Pivot Table: data elements panel doesn't populate when details is selected Status in DHIS 2: New Bug description: See attached image To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1373147/+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] Problems with 2.16 upgrade
Hi Devs, Got this error relating to dataelements while trying to upgrade a database from 2.15 to 2.16. Any ideas what may be causing this? More logs in attachment. ERROR 2014-09-12 20:09:01,663 java.lang.IllegalArgumentException: No enum cons tant org.hisp.dhis.dataelement.DataElementDomain.t at java.lang.Enum.valueOf(Unknown Source) at org.hisp.dhis.hibernate.EnumUserType.nullSafeGet(EnumUserType.java:74 ) at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:127) at org.hibernate.type.AbstractType.hydrate(AbstractType.java:106) at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(Abstra ctEntityPersister.java:2903) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1668) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1600) at org.hibernate.loader.Loader.getRow(Loader.java:1500) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:712) at org.hibernate.loader.Loader.processResultSet(Loader.java:940) at org.hibernate.loader.Loader.doQuery(Loader.java:910) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge 12-Sep-2014 20:06:36.913 INFO [main] org.apache.catalina.core.AprLifecycleListen er.init Loaded APR based Apache Tomcat Native library 1.1.30 using APR version 1 .4.8. 12-Sep-2014 20:06:36.915 INFO [main] org.apache.catalina.core.AprLifecycleListen er.init APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 12-Sep-2014 20:06:37.739 INFO [main] org.apache.catalina.core.AprLifecycleListen er.initializeSSL OpenSSL successfully initialized (OpenSSL 1.0.1g 7 Apr 2014) 12-Sep-2014 20:06:37.893 INFO [main] org.apache.coyote.AbstractProtocol.init Ini tializing ProtocolHandler ["http-apr-8080"] 12-Sep-2014 20:06:37.905 INFO [main] org.apache.coyote.AbstractProtocol.init Ini tializing ProtocolHandler ["ajp-apr-8009"] 12-Sep-2014 20:06:37.907 INFO [main] org.apache.catalina.startup.Catalina.load I nitialization processed in 1302 ms 12-Sep-2014 20:06:37.929 INFO [main] org.apache.catalina.core.StandardService.st artInternal Starting service Catalina 12-Sep-2014 20:06:37.930 INFO [main] org.apache.catalina.core.StandardEngine.sta rtInternal Starting Servlet Engine: Apache Tomcat/8.0.8 12-Sep-2014 20:06:37.975 INFO [localhost-startStop-1] org.apache.catalina.startu p.HostConfig.deployWAR Deploying web application archive C:\apache-tomcat-8.0.8\ webapps\ROOT.war * INFO 2014-09-12 20:08:06,368 System property dhis2.home not set (DefaultLocat ionManager.java [localhost-startStop-1]) * INFO 2014-09-12 20:08:06,375 Environment variable DHIS2_HOME points to D:\dhi s2 (DefaultLocationManager.java [localhost-startStop-1]) * INFO 2014-09-12 20:08:07,938 Hibernate configuration loaded, using dialect: o rg.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.ja va [localhost-startStop-1]) 12-Sep-2014 20:08:14.536 INFO [localhost-startStop-1] com.hazelcast.hibernate.Ha zelcastLocalCacheRegionFactory.null Starting up HazelcastLocalCacheRegionFactory 12-Sep-2014 20:08:14.559 INFO [localhost-startStop-1] com.hazelcast.config.XmlCo nfigBuilder.null Looking for hazelcast.xml config file in classpath. 12-Sep-2014 20:08:14.563 INFO [localhost-startStop-1] com.hazelcast.config.XmlCo nfigBuilder.null Using configuration file file:/C:/apache-tomcat-8.0.8/webapps/R OOT/WEB-INF/lib/dhis-support-hibernate-2.16.jar!/hazelcast.xml in the classpath. 12-Sep-2014 20:08:15.760 INFO [localhost-startStop-1] com.hazelcast.instance.Def aultAddressPicker.null null [dev] [3.2.1] Interfaces is enabled, trying to pick one address matching to one of: [127.0.0.1] 12-Sep-2014 20:08:15.791 INFO [localhost-startStop-1] com.hazelcast.instance.Def aultAddressPicker.null null [dev] [3.2.1] Picked Address[127.0.0.1]:5701, using socket ServerSocket[addr=/127.0.0.1,localport=5701], bind any local is false 12-Sep-2014 20:08:16.119 INFO [localhost-startStop-1] com.hazelcast.system.null [127.0.0.1]:5701 [dev] [3.2.1] Hazelcast Community Edition 3.2.1 (20140428) star ting at Address[127.0.0.1]:5701 12-Sep-2014 20:08:16.120 INFO [localhost-startStop-1] com.hazelcast.system.null [127.0.0.1]:5701 [dev] [3.2.1] Copyright (C) 2008-2014 Hazelcast.com 12-Sep-2014 20:08:16.135 INFO [localhost-startStop-1] com.hazelcast.core.Lifecyc leService.null [127.0.0.1]:5701 [dev] [3.2.1] Address[127.0.0.1]:5701 is STARTIN G 12-Sep-2014 20:08:16.442 WARNING [localhost-startStop-1] com.hazelcast.instance. Node.null [127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled! Starting sta ndalone. 12-Sep-2014 20:08:16.576 INFO [localhost-startStop-1] com.hazelcast.core.Lifecyc leService.null [127.0.0.1]:5701 [dev] [3.2.1] Address[127.0.0.1]:5701 is STARTED * ERROR 2014-09-12 20:08:30,453 HHH000388: Unsuccessful: alter table completedat
Re: [Dhis2-devs] IMPORTANT: Vulnerability discovered in DHIS2 version 2.16 and some versions of trunk.
Thanks Jason for the critical info – had a funny feeling seeing hazelcast opening port 5701 in the 2.16 logs . Look forward to the green light on upgrade to 2.16. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Jason Pickering Sent: Monday, September 1, 2014 4:46 PM To: dhis2-devs; dhis2-us...@lists.launchpad.net Subject: [Dhis2-devs] IMPORTANT: Vulnerability discovered in DHIS2 version 2.16 and some versions of trunk. A potentially serious vulnerability of DHIS2 has been discovered by members of the core development team this afternoon (2014-09-01). The development team is working on a permanent solution for this, but in the meantime, all users of DHIS2 are advised to review their system for potential vulnerabilities. Potentially affected versions: All version of DHIS2 2.16 and any version of trunk, from revision 15124 and up. Vulnerability Details: Hazelcast is a component of DHIS2 used to provide caching. By default, Hazelcast will open a port (5701) on the machine which is running DHIS2. The Hazelcast cluster may be vulnerable to attack. The Hazelcast cluster API may expose critical information about the system, including network information and other runtime data. It is not currently known to what extent the information contained inside of DHIS2 might be exposed through this vulnerability. Risk: When running DHIS2 on a network that's directly attached to the Internet or other unsecured network, an attacker may access and inject critical information into the Hazelcast component. The exposed API could be used to influence systems availability by injecting arbitrary into the DHIS2 caching system. Steps to confirm if your server is vulnerable: Replace "server" with your IP address or the name of your server and attempt to access the resulting address through your web browser http://server:5701/hazelcast/rest/cluster/ Affected versions of DHIS2 will show something like the response below. Members [1] { Member [XXX.XXX.XXX.XX]:5701 this } ConnectionCount: 4 AllConnectionCount: 5 If you see any response, even different from this one, your DHIS2 server is vulnerable, and should be upgraded immediately. Mitigation: If you are running DHIS 2.15 or lower, do not upgrade at this point, until advised otherwise. Further testing of the solution will need to be confirmed. If you are running DHIS2 version 2.16 or higher, or any version of trunk past revision 15124, or any branch of trunk including revision 15124 and up, you should immediately use a software based firewall to block all non-localhost traffic on port 5701. The package UFW is a simple firewall, which can be easily installed and enable as below sudo apt-get install ufw (only if you have not installed this package previously) sudo ufw allow 22 (change this if need be to whatever port your ssh is listening on) sudo ufw allow 80 sudo ufw allow 443 sudo ufw enable Additionally, you should immediately upgrade your DHIS2 server software version to at least the following revisions. Trunk: Revision 16603 2.16: 16386 The core development team will communicate further on this issues, once we have had time to determine the extent of the problem, as well as to confirm a final fix. If you have any questions about this mail, please do not hesitate to ask! Best regards, Jason Pickering ___ 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] Problem downloading Orgunit metadata
Hi Knut, No errors are logged – actually shows “export done”. ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge From: Knut Staring [mailto:knu...@gmail.com] Sent: Monday, August 4, 2014 8:32 AM To: Dapo Adejumo Cc: dhis2-us...@lists.launchpad.net; DHIS 2 developers Subject: Re: [Dhis2-devs] Problem downloading Orgunit metadata Hi Dapo, Usually when things seem to take hours there is an error message in the logs. Have you checked? On 3 Aug 2014 17:03, "Dapo Adejumo" mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, Hit a strange issue with orgunit metadata export, logs report that the export is done but the download never gets completed – just goes on for hours. I do not know if this is related to OU size (more than 30,000 units). Any experience or suggestion on this? ……… Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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
[Dhis2-devs] Problem downloading Orgunit metadata
Hi Devs, Hit a strange issue with orgunit metadata export, logs report that the export is done but the download never gets completed - just goes on for hours. I do not know if this is related to OU size (more than 30,000 units). Any experience or suggestion on this? ... Regards, Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] [Bug 1344010] [NEW] GIS download products does not show full map when few children are selected
Dear Salihu, I dont think this is a bug - you will need to include boundaries in your map to get what you want. Regards, Adedapo Adejumo. Mobile : +2348033683677 Skype : dapojorge On Friday, 18 July 2014 1:31 PM, Salihu Muhammad <1344...@bugs.launchpad.net> wrote: Public bug reported: I created a GIS thematic analysis product by selecting 9 out 36 children of the root organisation unit, the result shows the 9 organisation units in the map of the world as expected. but on downloading it, only the selected organisation units are displayed. I expected that it would display the 9 org units in a map of my root org unit. I am using Version: 2.15, Build revision: 15185 Attached is snapshot Thank you ** Affects: dhis2 Importance: Undecided Status: New ** Tags: gis maps org units ** Attachment added: "bug.png" https://bugs.launchpad.net/bugs/1344010/+attachment/4155617/+files/bug.png -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1344010 Title: GIS download products does not show full map when few children are selected Status in DHIS 2: New Bug description: I created a GIS thematic analysis product by selecting 9 out 36 children of the root organisation unit, the result shows the 9 organisation units in the map of the world as expected. but on downloading it, only the selected organisation units are displayed. I expected that it would display the 9 org units in a map of my root org unit. I am using Version: 2.15, Build revision: 15185 Attached is snapshot Thank you To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1344010/+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___ 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] short name in analysis modules
Thanks Lars, is it still on the cards? Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 29 May 2014 15:32 To: Dapo Adejumo Cc: Knut Staring; DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules Hi Dapo, sorry but no it didn't make it into 2.15. cheers Lars On Tue, May 27, 2014 at 12:56 AM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Lars, Just to find out if some progress has been made regarding this issue – I don’t think it made it to 2.15? or am I wrong. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto:larshe...@gmail.com <mailto:larshe...@gmail.com> ] Sent: 02 February 2014 11:28 To: Dapo Adejumo Cc: Knut Staring; DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules Hi Dapo, thanks for pointing this out. Aware of the need - we are working on some underlying changes in our web api to get this in place now. regards, Lars On Sat, Feb 1, 2014 at 12:26 AM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Lars, Thought I should resuscitate this as it seems the fix did not make it to 2.14 ( at least as at now) . I think this feature is quite important especially for use of information in the DHIS . As Knut suggested it will be better to actually have the option set in each analysis module per user but implementing that will be quite a task I imagine. The original `implementation that allows a user to define use of shortname vs longnames as a global `setting will at least provide some shorterm solution while we look for more lasting answers. .... Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Knut Staring [mailto:knu...@gmail.com <mailto:knu...@gmail.com> ] Sent: 13 December 2013 09:04 To: Lars Helge Øverland Cc: Dapo Adejumo; DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules This should have a high priority, since many charts look quite stupid and often actually misleading/wrong with long names. Orgunit names present a particular challenge, as in many countries there is a need to have "double names" such as Lao+English, since Orgunit names are currently not translatable. But I'm not sure I would want it to be a universal user choice, would perhaps feels more natural to have it as an option for each chart or map? Or maybe as a universal choice which could be overridden for particular resources. On Tue, Dec 10, 2013 at 11:02 AM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: Hi Dapo, this feature did not completely make it into 2.13 and was unfortunately half-done. The setting was removed from 2.13 last week. Will implement as soon as we get time. Lars On Dec 8, 2013 10:28 PM, "Dapo Adejumo" mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, Just to make sure I wasn’t doing anything wrong before reporting this as a bug. Users should be able to choose whether to use ‘name’ or ‘short name’ for metadata in analysis modules. This should be set by each user under their profiles……this doesn’t seem to be working – Any similar experiences or how should this work? .... Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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 <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Knut Staring Dept. of Informatics, University of Oslo +4791880522 http://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] short name in analysis modules
Hi Lars, Just to find out if some progress has been made regarding this issue I dont think it made it to 2.15? or am I wrong. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 02 February 2014 11:28 To: Dapo Adejumo Cc: Knut Staring; DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules Hi Dapo, thanks for pointing this out. Aware of the need - we are working on some underlying changes in our web api to get this in place now. regards, Lars On Sat, Feb 1, 2014 at 12:26 AM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Lars, Thought I should resuscitate this as it seems the fix did not make it to 2.14 ( at least as at now) . I think this feature is quite important especially for use of information in the DHIS . As Knut suggested it will be better to actually have the option set in each analysis module per user but implementing that will be quite a task I imagine. The original `implementation that allows a user to define use of shortname vs longnames as a global `setting will at least provide some shorterm solution while we look for more lasting answers. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Knut Staring [mailto:knu...@gmail.com <mailto:knu...@gmail.com> ] Sent: 13 December 2013 09:04 To: Lars Helge Øverland Cc: Dapo Adejumo; DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules This should have a high priority, since many charts look quite stupid and often actually misleading/wrong with long names. Orgunit names present a particular challenge, as in many countries there is a need to have "double names" such as Lao+English, since Orgunit names are currently not translatable. But I'm not sure I would want it to be a universal user choice, would perhaps feels more natural to have it as an option for each chart or map? Or maybe as a universal choice which could be overridden for particular resources. On Tue, Dec 10, 2013 at 11:02 AM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: Hi Dapo, this feature did not completely make it into 2.13 and was unfortunately half-done. The setting was removed from 2.13 last week. Will implement as soon as we get time. Lars On Dec 8, 2013 10:28 PM, "Dapo Adejumo" mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, Just to make sure I wasnt doing anything wrong before reporting this as a bug. Users should be able to choose whether to use name or short name for metadata in analysis modules. This should be set by each user under their profiles this doesnt seem to be working Any similar experiences or how should this work? ........ Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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 <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Knut Staring Dept. of Informatics, University of Oslo +4791880522 http://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] [Bug 1323339] [NEW] Group Sharing - search doesn't return any matches
Thanks - same with bug 1321039 reported on the 19th. Regards, Dapo Adejumo +2348033683677 skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Morten Olav Hansen Sent: 26 May 2014 22:40 To: dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] [Bug 1323339] [NEW] Group Sharing - search doesn't return any matches This have now been fixed in latest trunk, and backportet into 2.15 -- Morten On Mon, May 26, 2014 at 5:37 PM, Morten Olav Hansen wrote: > Hm, I see the same issue on our demo server. We will look into it. > > -- > Morten > > > On Mon, May 26, 2014 at 5:34 PM, Morten Olav Hansen wrote: > >> Have you tried with the latest 2.15? There was a bug related to >> upgraded jquery ui.. Which have been fixed On May 26, 2014 5:30 PM, >> "Rodolfo Melia" wrote: >> >>> Public bug reported: >>> >>> When doing Sharing Mangement from any object, no group is returned. >>> Even if you write the full name, you are not allowed to add the >>> group. This is happening on all 2.15 servers, including DHIS demo - >>> see attachment >>> >>> ** Affects: dhis2 >>> Importance: Undecided >>> Status: New >>> >>> ** Attachment added: "Bug Groups.png" >>> >>> https://bugs.launchpad.net/bugs/1323339/+attachment/4119908/+files/B >>> ug%20Groups.png >>> >>> -- >>> You received this bug notification because you are subscribed to DHIS. >>> https://bugs.launchpad.net/bugs/1323339 >>> >>> Title: >>> Group Sharing - search doesn't return any matches >>> >>> Status in DHIS 2: >>> New >>> >>> Bug description: >>> When doing Sharing Mangement from any object, no group is returned. >>> Even if you write the full name, you are not allowed to add the group. >>> This is happening on all 2.15 servers, including DHIS demo - see >>> attachment >>> >>> To manage notifications about this bug go to: >>> https://bugs.launchpad.net/dhis2/+bug/1323339/+subscriptions >>> >> > -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1323339 Title: Group Sharing - search doesn't return any matches Status in DHIS 2: New Bug description: When doing Sharing Mangement from any object, no group is returned. Even if you write the full name, you are not allowed to add the group. This is happening on all 2.15 servers, including DHIS demo - see attachment To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1323339/+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 ___ 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 1321039] [NEW] Cannot share dashboard with usergroups - groups fail to be listed after search
Public bug reported: When searching for user groups after clicking share button for dashboards, relevant user groups fail to be listed and thus dashboard cannot be shared. Affects 2.15 build revision 15052. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1321039 Title: Cannot share dashboard with usergroups - groups fail to be listed after search Status in DHIS 2: New Bug description: When searching for user groups after clicking share button for dashboards, relevant user groups fail to be listed and thus dashboard cannot be shared. Affects 2.15 build revision 15052. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1321039/+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] Compiling a data dictionary from DHIS2
Hi Devs, I have tried to pull out full indicator definitions from the DHIS2(in form of a data dictionary) – The API doesn’t give numerators and denominators like an ideal data dictionary should. The indicator table in postgres represents the numerators and denominators as Dataelement uids and categoryoptioncombo uids. I could eventually get something out using multiple find and replace macros in excel but the process was not very linear and has to be done each time a change is done to the metadata outside the DHIS. Does anyone have any ideas on a simpler way to do this? The old data dictionary functionality could do this…. Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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] Reporting rates over 100%
Hi, Has this issue been resolved? Its really weird having different reporting rates calculated in the reporting rate summary and the pivot tables . An example we are seeing is a reporting rate of 101% on the pivot table but the reporting rate summary reports as 96.1% . The analytics seem not be handling completeness reports well . Since one of the milestones for the release of 2.16 is to pull reporting rate summary from the analytics tables , it will be great if this is sorted out Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Prosper BT Sent: 23 March 2014 08:12 To: Lars Helge Øverland Cc: DHIS developers Subject: Re: [Dhis2-devs] Reporting rates over 100% Monthly foe HMIS 105: 1. I have also seen it with the quarterly report hmis 106a when you for all districts you will see. For HMIS 105 I drilled down to subcounty and it's Kagadi Town Council with high percentages. Regards On Mar 22, 2014 9:53 PM, "Lars Helge Øverland" mailto:larshe...@gmail.com> > wrote: Hi Prosper, thanks for reporting. What frequency/period type is this for? Will have a look. Lars On Mar 22, 2014 5:41 PM, "Prosper BT" mailto:ptb3...@gmail.com> > wrote: Dear Team, One thing i have failed to understand is why we have reporting rates over 100%. This displays in Pivot tables, Visualizer but not when you run reporting rate summaries under reports. Lars you can check on Uganda systems Kibaale district in Western Uganda -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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] Apps Buttons to Line lists on the menu
Hi, I also cringed at the change and can imagine the change management that will happen with end users. Like Prosper said….its really cool on touchscreens but not really on non-touch screens – can a global setting allow interface to be selected for touch screens or desktop? Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Prosper BT Sent: 09 May 2014 18:06 To: Lars Helge Øverland Cc: DHIS developers Subject: Re: [Dhis2-devs] Apps Buttons to Line lists on the menu Thanks Lars, This is very good addition but we have tested the interface with the local desktop users and it was very inconveniencing, they are used to pointing and picking from the list. This will be very difficult to upgrade without retraining end users. Its a suggestion that you can consider, the button are not cools when using desktops but cool on smart phone and majority of the users are desktops. Regards On Fri, May 9, 2014 at 7:03 PM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: Hi Prosper, in latest 2.15 build we included a search field at the top of the menu which allows you to type in the app you are looking for, then hit enter. You can also click "more apps" and arrange the order of the apps according to your preferences. See it here <http://apps.dhis2.org/demo/dhis-web-commons/security/login.action> . Do you think that works? Lars On Fri, May 9, 2014 at 5:43 PM, Prosper BT mailto:ptb3...@gmail.com> > wrote: Hi Team, Great work with 2.15, was just wondering is there is possibility of switching the Apps buttons to Lists. Works well with touch screen but not desktop. Regards -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 ___ 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] Min-Max Value Generation
Hi Devs, Looks like Min-Max Values can only be generated for a single orgunit at a time - any reason for this or am I missing something? If that is true it will be impracticable to do that for large numbers of orgunits routinely . Can we have an easier way by having options to select orgunits by levels or groups. Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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] Percentages on Pie Charts
Hi Jan and Devs, I think it will be quite useful to have percentages shown alongside( or without) the actual values for pie charts in the data visualizer. It is often easier to base interpretations on percentages rather than actual values - the option to show value can be extended to calculate and show percentages? Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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] runing Analytics errors.
Hi, This is related to a bug with analytics and sql views that was initially fixed but seems to have crept in again. It will need to be fixed – A temporary workaround is to delete sql views from your database. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Dhis2-users [mailto:dhis2-users-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Emmanuel Willer CHARLES Sent: 24 April 2014 15:31 To: DHIS 2 developers; dhis2-us...@lists.launchpad.net; kren...@futuresgroup.com; Lars Helge Øverland; Knut Staring Subject: [Dhis2-users] runing Analytics errors. Hi All, we are having error to run analytic reports, it lasts longer than usual. when we try to run a resource table, we have the following error message. Please Help. ERROR MESSAGE Link to error message: http://gyazo.com/d50d019cb8374ec38dcf020488c0167a <http://i.gyazo.com/d50d019cb8374ec38dcf020488c0167a.png> Thank you for prompt answer. -- ___ Charles Emmanuel Willer 12,Lilavois 50 Croix des Bouquets, HT Tels: +509-3842-3854 / +509-3270-0655 Skype: emmanuelwiller emmanuelwil...@gmail.com <mailto:emmanuelwil...@gmail.com> emmanuelwil...@yahoo.com <mailto:emmanuelwil...@yahoo.com> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Bug 1211010] Re: Analytics tables not generated when sql views linked to analytics tables exist
This bug has somehow found its way back ( tested on 2.14 build revision 13844). Needs to be fixed asap. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1211010 Title: Analytics tables not generated when sql views linked to analytics tables exist Status in DHIS 2: Confirmed Bug description: Analytics tables are not generated when sql view linked to the analytics table is present. Postgres cannot drop a table linked to a view without a cascade statement dropping the particular view. Since postgres cannot drop the analytics tables to populate a new one, the process is truncated . Using version 2.12 build 11268. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1211010/+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] Inactive Organisation Unit
Tricky issue Discussed before. The problem is that the OU attributes that should control this seem to conflict each other. For instance even if the closed date is set / Registers Data set to No and datasets are allocated to the OU data will still be captured against this OU. Lars, we may need to review the functionality of closing date for OUs and also other relevant metadata like dataelements and indicators. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Dhis2-users [mailto:dhis2-users-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Lars Helge Øverland Sent: 04 April 2014 10:38 To: Wilson,Randy Cc: dhis2-us...@lists.launchpad.net; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-users] [Dhis2-devs] Inactive Organisation Unit 4. Remove all associations between the org unit and data sets. ___ 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] Surveillance Alerts - Sending Alerts
Thats right Prosper, Thanks for flagging this. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Prosper BT Sent: 13 March 2014 09:14 To: Lars Helge Øverland Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] Surveillance Alerts - Sending Alerts Thanks Guys, I think the role was also affecting its use, I go for user groups. Regards On Thu, Mar 13, 2014 at 11:12 AM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: Good. I would say lets change to groups, not too many are using it still. Lars On Mar 12, 2014 6:44 PM, "Jim Grace" mailto:jimgr...@gmail.com> > wrote: An option to configure this per validation rule group sounds fine. In the interest of not making this too complicated for the user, would it better to leave it with roles (optionally restricted within the org unit hierarchy), or change the implementation from roles to user groups (optionally restricted within the org unit hierarchy). Of course we could support both roles and user groups, but I'm just trying to see if we can keep it simpler for the user. Cheers, Jim On Wed, Mar 12, 2014 at 1:11 PM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: I think the suggestion from Jim is good. Could it be configurable by validation rule group? So we have a true/false option "send alerts to users within hierarchy only" or similar on the validation rule group. Then messages only goes out to users who have the originating org unit of the alert in their sub-hierarchies. I think in general having user roles and not user groups was a (my) mistake - we could simply change it. regards, Lars On Thu, Mar 6, 2014 at 8:26 PM, Prosper BT mailto:ptb3...@gmail.com> > wrote: Yes Jim this would suit my use case, but not sure if its global enough others can comment may be On Thu, Mar 6, 2014 at 10:23 PM, Jim Grace mailto:jimgr...@gmail.com> > wrote: Maybe the most useful next step is to leave the user interface the same, but filter for the organisation unit assigned to the user when sending the messages. So for example a national user would see alerts from anywhere in the country, but a district user would see alerts only from within their district. (We probably should have done it that way in the first place!) Would this help? Cheers, Jim On Thu, Mar 6, 2014 at 2:15 PM, Prosper BT mailto:ptb3...@gmail.com> > wrote: Thanks Jim for the quick response. As we talk about the two the more I see them complicated. For the user role, my use case is on the Uganda national system where user roles and creating users is guarded like a gold mine. Only two people allowed to create roles and users though the rest of us can create user groups. But for now I will ask them to create a user role with only one role that can do much with the system and try it out. For the second one, my use case is in four districts where community health workers are sending weekly maternal surveillance reports. These are like over 4000 villages in level 5 on the hierarchy. I want districts at level 3 to receive alerts whenever a death is reported So if I implement it the way it is now, I have to create 4 district accounts and assign all them the alert user role. Once a death happen in one district all the districts will receive the alert. May be as you suggest we should add hierarchy selection (level) in creating the rule and if we specify sending to a given level (district, region, national,...) an alert is only sent to only users assigned to that level and only for that hierarchy of that orgunit. Example Uganda/Northern Region/Gulu District/Alur Soubcounty/Gulu Hospital/Village A Uganda/Western Region/Kibaale District/Mutoke Soubcounty/Kagadi Hospital/Village W If death is reported from Village W and the rule was set to send to only users at level 3 only users assigned to Kibaale District with the alert role should receive the alert, but if level 1 is chosen then all users assigned to Uganda would receive the alert. Regards On Thu, Mar 6, 2014 at 9:39 PM, Jim Grace mailto:jimgr...@gmail.com> > wrote: You also raise a good point about sending alerts from different parts of the org unit hierarchy to different groups of users. I'm trying to imagine how this could be configured. Perhaps when you configure a validation rule group you could choose a point in the org unit hierarchy and assign a user group to be alerted for organisations at or below that point -- and then you could make similar assignments for other points in the org unit hierarchy as well. This sounds very useful to me, if a bit awkward. Can you imagine a simpler mechanism? If you can say a bit more about the use case, that also strengthens the case for a new fea
Re: [Dhis2-devs] Advocating for changes to Data (values) Model/Table in DHIS2
Hi, Very Interesting view points here and it tells a lot about how we approach Country Health Information Systems. The idea that IPs can generate separate values for the same dataelement for same orgunits negates the principles of essential/minimum datasets. Weakening of Country HIS basically start from this as "Nobody believes the MOH vaues". Of course there can be additional reporting requirements outside of the essential datasets and which are often time bound and IP/Program dependent. One interesting thing that has happened in Nigeria is the Regionalization of IPs(HIV/AIDs) which essentially means no 2 IPs will work in the same facility/district at least on HIV/AIDS. In other words the system needs to be structured first rather than put the burden on the technology . I know this is simpler said than implemented . On the other hand, from Greg's Initial concerns, Individual records in the DHIS can be aggregated to existing aggregated data tables . if patient records are going to be migrated via EMRs , I assume this will be done using the patientdatavalue tables? And then this should be easily aggregated from queries? The question will be which aggregated value to accept - from the manual facility aggregates of patient level data. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Jim Grace Sent: 06 March 2014 23:29 To: Vincent Shaw Cc: Farai Mutero; Jason Phillips; Greg Rowles; Ferdie Botha; DHIS 2 developers Subject: Re: [Dhis2-devs] Advocating for changes to Data (values) Model/Table in DHIS2 Hi Vincent, I agree that in theory it would be best to use the MoH values. One challenge with this is timing. For example the deadlines to finalize data in the MoH DHIS2 instance in Kenya are later than the deadlines by which PEPFAR needs its data finalized for reporting to the US government. The other challenge is that a partner may not agree with the official MoH number. In the end, the funding organization such as PEPFAR needs to get the numbers that the implementing partner believes are right, whether or not they are the same numbers as the MoH system, or have (yet) been entered into the MoH system. Having said that, of course all the numbers should be the same. What I've heard from PEPFAR is that if two partners report the same data element from the same facility for the same time period, the numbers should be equal. I've heard that partners should not pro-rate their numbers because of the amount or duration of support at a given site. If two partners give different numbers for the same data element, facility and period, this represents an error that needs to be reconciled so the two will report the same number. That's the "official" story I've been told to assume. If I assume all the numbers are the same, then the automatic "deduplication" could work: If (n) facilities report for the same item, and each reports the same value, you just subtract (n-1) times the value. If this were (or is) not the case, then you could do manual "deduplication". which is what I had assumed before I heard the above explanation. In manual deduplication, someone has to make a judgement as to what the total number should be "deduplicated" across partners. Then the manually-determined difference could be attributed to the dummy partner to make the aggregation work. Cheers, Jim On Thu, Mar 6, 2014 at 4:48 PM, Vincent Shaw mailto:vps...@gmail.com> > wrote: Hi Jim What you suggest below is an interesting option. But I am struggling to understand how you would decide the value of the negative values in the dummy IP? My thinking... one source of data would be the MoH (say the Facility Information Officer (FIO)) and that they would capture the data which represents the "single point of truth" for that facility data. This is likely to be comprehensive across all the services? The data that IP use may then be the same values as the MoH data, or a % of those values (or even just other values captured on the basis of their own records), based on the type of support provided, and their level of effort. If you add the %'s across IP you may end up exceeding 100% (or exceeding the value entered by the MoH) since their services may overlap. The point is, even if you do create a Dummy IP that has negative values, how will you determine what the negative value is in the absence of some reference. If the MoH values are the reference, you may as well just use the MoH values? Regards V From: Jim Grace [mailto:jimgr...@gmail.com <mailto:jimgr...@gmail.com> ] Sent: 06 March 2014 17:44 PM To: Vincent Shaw Cc: Greg Rowles; DHIS 2 developers; Farai Mutero; Ferdie Botha; Jason Phillips Subject: Re: [Dhis2-devs] Advocating for changes to
Re: [Dhis2-devs] short name in analysis modules
Hi Lars, Thought I should resuscitate this as it seems the fix did not make it to 2.14 ( at least as at now) . I think this feature is quite important especially for use of information in the DHIS . As Knut suggested it will be better to actually have the option set in each analysis module per user but implementing that will be quite a task I imagine. The original `implementation that allows a user to define use of shortname vs longnames as a global `setting will at least provide some shorterm solution while we look for more lasting answers. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Knut Staring [mailto:knu...@gmail.com] Sent: 13 December 2013 09:04 To: Lars Helge Øverland Cc: Dapo Adejumo; DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules This should have a high priority, since many charts look quite stupid and often actually misleading/wrong with long names. Orgunit names present a particular challenge, as in many countries there is a need to have "double names" such as Lao+English, since Orgunit names are currently not translatable. But I'm not sure I would want it to be a universal user choice, would perhaps feels more natural to have it as an option for each chart or map? Or maybe as a universal choice which could be overridden for particular resources. On Tue, Dec 10, 2013 at 11:02 AM, Lars Helge Øverland mailto:larshe...@gmail.com> > wrote: Hi Dapo, this feature did not completely make it into 2.13 and was unfortunately half-done. The setting was removed from 2.13 last week. Will implement as soon as we get time. Lars On Dec 8, 2013 10:28 PM, "Dapo Adejumo" mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, Just to make sure I wasn’t doing anything wrong before reporting this as a bug. Users should be able to choose whether to use ‘name’ or ‘short name’ for metadata in analysis modules. This should be set by each user under their profiles……this doesn’t seem to be working – Any similar experiences or how should this work? ........ Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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 <mailto:dhis2-devs@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- Knut Staring Dept. of Informatics, University of Oslo +4791880522 http://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] Web pivot cell limit
Thanks Lars .will only try this at home Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 23 January 2014 20:34 To: Dapo Adejumo Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] Web pivot cell limit Okay then there is trick based on generating the analytics URL yourself. Using the API you can ignore the limit. Docs here <http://www.dhis2.org/doc/snapshot/en/user/html/ch27s16.html#d5e8374> . - In chrome click F12, go to Network - Generate the pivot table you want (and let it fail validation) - Copy the URL of the request going to the server, starting with api/analytics/.. etc. - In the URL, replace the file extension .json with .xls , then append a query parameter: &ignoreLimit=true Don't try this at home. Lars On Thu, Jan 23, 2014 at 9:13 PM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Lars, to be able to download will be fine not necessarily to view in the browser. .... Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto: <mailto:larshe...@gmail.com> larshe...@gmail.com] Sent: 23 January 2014 19:36 To: Dapo Adejumo Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] Web pivot cell limit Hi Dapo, sorry not through the UI. Is it enough to download the table as excel/csv, or do you want to it in the browser? Lars On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily? Any ideas? ........ Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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] Web pivot cell limit
Hi Lars, to be able to download will be fine not necessarily to view in the browser. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 23 January 2014 19:36 To: Dapo Adejumo Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] Web pivot cell limit Hi Dapo, sorry not through the UI. Is it enough to download the table as excel/csv, or do you want to it in the browser? Lars On Thu, Jan 23, 2014 at 8:30 PM, Dapo Adejumo mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily? Any ideas? Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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
[Dhis2-devs] Web pivot cell limit
Hi Devs, The cell limit for the web pivot has been set to 50,000 understandably to protect the server. But is there a way to override this temporarily? Any ideas? Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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] analytics bugfix
Thanks Lars. Sent from my windows mobile. -Original Message- From: Lars Helge Øverland Sent: 1/21/2014 16:55 To: DHIS 2 Developers list; DHIS 2 Users list Subject: [Dhis2-users] analytics bugfix Hi, we have made a fix for a bug in analytics which caused certain indexes not to be created. The issue affects 2.13 since Dec 2013 and 2.14 and Live. We recommend that you upgrade from www.dhis2.org/downloads regards, Lars ___ 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 1265015] [NEW] DHIS allows duplication of dataelement name during creation
Public bug reported: There is a warning when a user tries to create a dataelement with an existing name, however is the user rewords the dataelement and then reverts to the original duplicate, the duplicate name is created but with a different uid. This is not good for data integrity. Also, import schemes also use names as identifiers. Affects 2.13 build 12932 ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1265015 Title: DHIS allows duplication of dataelement name during creation Status in DHIS 2: New Bug description: There is a warning when a user tries to create a dataelement with an existing name, however is the user rewords the dataelement and then reverts to the original duplicate, the duplicate name is created but with a different uid. This is not good for data integrity. Also, import schemes also use names as identifiers. Affects 2.13 build 12932 To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1265015/+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] short name in analysis modules
Thanks. Regards, Dapo Adejumo +2348033683677 skype : dapojorge From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 10 December 2013 11:03 To: Dapo Adejumo Cc: DHIS 2 Developers list Subject: Re: [Dhis2-devs] short name in analysis modules Hi Dapo, this feature did not completely make it into 2.13 and was unfortunately half-done. The setting was removed from 2.13 last week. Will implement as soon as we get time. Lars On Dec 8, 2013 10:28 PM, "Dapo Adejumo" mailto:dapo_adej...@yahoo.com> > wrote: Hi Devs, Just to make sure I wasnt doing anything wrong before reporting this as a bug. Users should be able to choose whether to use name or short name for metadata in analysis modules. This should be set by each user under their profiles this doesnt seem to be working Any similar experiences or how should this work? Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net <mailto: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
[Dhis2-devs] short name in analysis modules
Hi Devs, Just to make sure I wasn't doing anything wrong before reporting this as a bug. Users should be able to choose whether to use 'name' or 'short name' for metadata in analysis modules. This should be set by each user under their profiles..this doesn't seem to be working - Any similar experiences or how should this work? .... Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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 1230385] Re: Org unit tree selection misbehaving for users with restricted access
Yes...Its fine now. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1230385 Title: Org unit tree selection misbehaving for users with restricted access Status in DHIS 2: Fix Committed Bug description: Assuming current user has access to only a lower part of the organisation unit hierarchy. This is enforced by displaying only that subtree in the org unit selection tree. In edit org unit group screen, when editing an existing group, then organisation units which are hidden from the view will be unintentionally un-selected. It should not be possible to un-select org units in this way. This might lead to large selections being cleared. Affects org unit group, data set - org unit assignment. This applies to data set > org unit and program > org unit association. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1230385/+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] [Bug 1256311] [NEW] Previous orgunitgroup allocations cleared after a user assigned to a lower orgunit level edits group
Public bug reported: When a user assigned to a lower level in the orgunit tree logs in to update orgunit group allocations and saves, previous allocations done by other users at lower or higher levels of the orgunit tree is cleared leading to large orgunit group allocations been cleared from the database. Affects - 2.13 Revision 12884. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1256311 Title: Previous orgunitgroup allocations cleared after a user assigned to a lower orgunit level edits group Status in DHIS 2: New Bug description: When a user assigned to a lower level in the orgunit tree logs in to update orgunit group allocations and saves, previous allocations done by other users at lower or higher levels of the orgunit tree is cleared leading to large orgunit group allocations been cleared from the database. Affects - 2.13 Revision 12884. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1256311/+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] [Bug 1230385] Re: Org unit tree selection misbehaving for users with restricted access
Hi, Bug still exists..tested on demo and trunk. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1230385 Title: Org unit tree selection misbehaving for users with restricted access Status in DHIS 2: Fix Committed Bug description: Assuming current user has access to only a lower part of the organisation unit hierarchy. This is enforced by displaying only that subtree in the org unit selection tree. In edit org unit group screen, when editing an existing group, then organisation units which are hidden from the view will be unintentionally un-selected. It should not be possible to un-select org units in this way. This might lead to large selections being cleared. Affects org unit group, data set - org unit assignment. This applies to data set > org unit and program > org unit association. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1230385/+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] Wrong db on dhis2 demo
Hi Devs..seems the wrong database is on the DHIS2 demo. http://apps.dhis2.org/demo/ Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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 1230385] Re: Org unit tree selection misbehaving for users with restricted access
Hi Lars, Any hope this will be sorted soon? -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1230385 Title: Org unit tree selection misbehaving for users with restricted access Status in DHIS 2: New Bug description: Assuming current user has access to only a lower part of the organisation unit hierarchy. This is enforced by displaying only that subtree in the org unit selection tree. In edit org unit group screen, when editing an existing group, then organisation units which are hidden from the view will be unintentionally un-selected. It should not be possible to un-select org units in this way. This might lead to large selections being cleared. Affects org unit group, data set - org unit assignment. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1230385/+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] Save Value Action?
Hi Devs, Just started picking up a lot of this in the logs lately - "338 value_is_zero_and_not_zero_significant (SaveValueAction.java)" . This is not a warning though but Info.. Is this related to cached forms not been updated on the client side? Or any ideas Thank you. Regards, Dapo Adejumo +2348033683677 skype : dapojorge ___ 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] Android client
Hi Arazgood work! I also got the error...wrong url and I am using the latest build. -- On Thu 19 Sep, 2013 8:10 PM CEST Araz Abishov wrote: >Hi Lars, > >Here is brief description of client possibilities: > >In general android dhis2 client is an interface for some of the core DHIS2 >functionality. >All forms are automatically downloaded from the DHIS2 server, stored in >device and presented to the user. >Because of the bad network coverage in some areas, client supports an >offline workflow, where app and its >data entry can work even outside network coverage, and the data is >submitted when there is network coverage available again. > >Currently app supports next dhis2 functionality: >* Aggregate data entry >* Tracking events and programs (Currently only "single event without >registration" is supported) >* Users can modify their personal information and then submit it to dhis2 >instance > >- In order to cover wide range of devices, application supports wide range >of android os versions (2.3 - 4.3). >- Tablet version is adapted for big screens and provides more convenient >way to select forms and enter data. (Thanks to SlidingMenu library :) ) >- Application supports four foreign languages: Spanish, French, Portuguese, >Indonesian. > > >On Thu, Sep 19, 2013 at 10:01 PM, Araz Abishov >wrote: > >> Hi Juma, >> >> First of all, thank you for testing application :) Some answers regarding >> issues are below: >> >> (1) In the login screen, i cannot change the url. I thought i can just put >> the url of my dhis2 instance! When i change the url, the error msg is: >> wrong url >> (2) Menu one (Aggregate report) - It says "wrong url" >> (3) Single Event, again wrong url >> >> >> Of course you can enter url of your dhis2 instance. I've tested app now >> with dev version of dhis2 and it works. http://apps.dhis2.org/dev >> (username: admin, password: district) >> >> It seems that problem is in dhis2 instance which you are using (android >> client works with new endpoints in API which were implemented after 2.12 >> release). Could you provide build version of your dhis2 instance? >> >> >> It is also not clear where the data get saved. Is it synchronising to the >> remote server automatically or it save the data in the local mobile >> (tablet). If it save locally, when does it synchronise the data? If it save >> to a remote server, what will happen if the user get disconnected and >> connected later. >> >> >> After save button is pressed, new account information will be saved on >> device and synchronised with server as well. If there is no connection to >> server at the moment when user saves changes, data will be synchronised in >> background as soon as connection is restored. >> >> >> All in all, this is a good work. It give hopes to those who want to >> collect large amount of data and make some analysis while they are in >> mobile mood :) >> Congratulations >> >> >> Thank you :). I'm very pleased to hear that this project will be useful >> for dhis2 community. >> >> >> >> >> >> >> >> >> >> >> >> >> >> On Thu, Sep 19, 2013 at 9:07 PM, Juma Lungo wrote: >> >> Dear Araz >> >> I have installed and tested your "Tablet" version. It is a very promising >> app. However, i have some questions: >> (1) In the login screen, i cannot change the url. I thought i can just >> put the url of my dhis2 instance! When i change the url, the error msg is: >> wrong url >> (2) Menu one (Aggregate report) - It says "wrong url" >> (3) Single Event, again wrong url >> (4) My Profile. It works! I can save data >> >> It is also not clear where the data get saved. Is it synchronising to the >> remote server automatically or it save the data in the local mobile >> (tablet). If it save locally, when does it synchronise the data? If it save >> to a remote server, what will happen if the user get disconnected and >> connected later. >> >> >> All in all, this is a good work. It give hopes to those who want to >> collect large amount of data and make some analysis while they are in >> mobile mood :) >> >> Congratulations >> >> -- >> *From:* Araz Abishov >> *To:* dhis2-devs@lists.launchpad.net >> *Sent:* Wednesday, September 18, 2013 7:35 PM >> *Subject:* [Dhis2-devs] Android client >> >> Hi everybody, >> >> Just wanted to share with new android client for dhis2. It would be great >> if you could test it and provide feedback. Any suggestions about how I can >> improve application are appreciated. >> >> Mobile version: http://bit.ly/1giZ8M9 >> Tablet version: http://bit.ly/16ukZir >> >> ___ >> 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
Re: [Dhis2-devs] Setting MinMax Values
Hi, It will be great if the generation of min-max values can be automated based on a global setting ( ability to select last 3,6 or 12 months data) . I am curious what happens to these hard coded min/max values when the database is set to generate min/max values from the frontend I will assume they are discarded since they reside in the same table? Or which takes precedence ? Thanks. Regards, Dapo Adejumo +234803363677 skype : dapojorge From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Jason Pickering Sent: Thursday, September 19, 2013 6:28 PM To: Juma Lungo Cc: dhis2-devs Subject: Re: [Dhis2-devs] Setting MinMax Values I think I agree with Lars as well. Our use case was we wanted to restrict values between 0 and 31, and not do it with a validation rule, to provide visual clues during data entry. As an aside, one may also want to calculate these values and save them to the database. The current algorithm uses a standard deviation approach, which is problematic, in that in many cases the data which is typically observed does not follow a normal Gaussian distribution. Other statistical models often provide better estimates of the mix/max, but currently, cannot be calculated automatically by the system. If these values are calculated externally in some statistical package, they can be inserted back into the system (or even automated). Regards, Jason On Thu, Sep 19, 2013 at 6:25 PM, Juma Lungo mailto:jlu...@yahoo.com> > wrote: I agree with Lars Lungo _ From: Lars Helge Øverland < <mailto:larshe...@gmail.com> larshe...@gmail.com> To: Jason Pickering < <mailto:jason.p.picker...@gmail.com> jason.p.picker...@gmail.com> Cc: dhis2-devs < <mailto:dhis2-devs@lists.launchpad.net> dhis2-devs@lists.launchpad.net> Sent: Thursday, September 19, 2013 2:43 PM Subject: Re: [Dhis2-devs] Setting MinMax Values Hi Conrad, the min-max data element is per org unit and data element like you say, so it applies to all current and future periods by definition. I don't know your use-case... but in general one might want to think twice before setting the same max value for all facilities, since they usually have very different catchment population and hence natural variations in numbers. Lars ___ Mailing list: https://launchpad.net/~dhis2-devs Post to: dhis2-devs@lists.launchpad.net <mailto: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] [Bug 1211010] Re: Analytics tables not generated when sql views linked to analytics tables exist
Thanks Jason...glad you found it :) - the sequence needs to be changed. .. Regards Dapo Adejumo +2348033683677 Skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of jason.p.pickering Sent: Sunday, August 11, 2013 5:14 PM To: dhis2-devs@lists.launchpad.net Subject: [Dhis2-devs] [Bug 1211010] Re: Analytics tables not generated when sql views linked to analytics tables exist Well, you are right Dapo. I thought I was all clever, but did not look through the entire log. :/ The process does fail, because the SQL views are not being dropped prior to the creation of the analytics tables. Looks like this needs to occur after their creation and not after the creation of the resource tables. ** Changed in: dhis2 Status: Incomplete => Confirmed -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1211010 Title: Analytics tables not generated when sql views linked to analytics tables exist Status in DHIS 2 - District Health Information Software: Confirmed Bug description: Analytics tables are not generated when sql view linked to the analytics table is present. Postgres cannot drop a table linked to a view without a cascade statement dropping the particular view. Since postgres cannot drop the analytics tables to populate a new one, the process is truncated . Using version 2.12 build 11268. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1211010/+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 ___ 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] [Bug 1211010] Re: Analytics tables not generated when sql views linked to analytics tables exist
Hi Jason, Strange.the sql view was created in DHIS2. Also try clearing the analytics tables from maintenance. .. Regards Dapo Adejumo +2348033683677 Skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of jason.p.pickering Sent: Sunday, August 11, 2013 4:53 PM To: dhis2-devs@lists.launchpad.net Subject: [Dhis2-devs] [Bug 1211010] Re: Analytics tables not generated when sql views linked to analytics tables exist This is not a bug with DHIS2. If you are creating views directly on the DB, you will need to encapsulate your view in a stored procedure if you are linking to any table which is dropped (same with the resource tables). In general, you cannot have a view directly on the DHIS2 database. If you do, it must be an SQL view in DHIS and not a view directly stored in the DB. So, I think when you mean SQL view, it is not an SQL view within DHIS2. I am not able to reproduce this by the following procedure. 1) Create an SQL view in DHIS2 SELECT * FROM analytics 2013 LIMIT 10; 2) Regenerate the analytics tables (no error). However if you create a view directly on the database, you will get an error, but this is not a bug with DHIS2. ** Changed in: dhis2 Status: New => Incomplete -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1211010 Title: Analytics tables not generated when sql views linked to analytics tables exist Status in DHIS 2 - District Health Information Software: Incomplete Bug description: Analytics tables are not generated when sql view linked to the analytics table is present. Postgres cannot drop a table linked to a view without a cascade statement dropping the particular view. Since postgres cannot drop the analytics tables to populate a new one, the process is truncated . Using version 2.12 build 11268. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1211010/+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 ___ 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 1211010] [NEW] Analytics tables not generated when sql views linked to analytics tables exist
Public bug reported: Analytics tables are not generated when sql view linked to the analytics table is present. Postgres cannot drop a table linked to a view without a cascade statement dropping the particular view. Since postgres cannot drop the analytics tables to populate a new one, the process is truncated . Using version 2.12 build 11268. ** Affects: dhis2 Importance: Undecided Status: New ** Tags: 11268 2.12 build -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1211010 Title: Analytics tables not generated when sql views linked to analytics tables exist Status in DHIS 2 - District Health Information Software: New Bug description: Analytics tables are not generated when sql view linked to the analytics table is present. Postgres cannot drop a table linked to a view without a cascade statement dropping the particular view. Since postgres cannot drop the analytics tables to populate a new one, the process is truncated . Using version 2.12 build 11268. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1211010/+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] Error populating Analytics Tables
n.java:150) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncEx ecutionInterceptor.java:89) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) ... 1 more .. Regards Dapo Adejumo +2348033683677 Skype : dapojorge ___ 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] [Bug 1201132] [NEW] Metadata Import for "Users" fails to import data.
Yes Bob, same results with superuser privilege. .. Regards Dapo Adejumo +2348033683677 Skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Bob Jolliffe Sent: Sunday, July 14, 2013 8:01 PM To: dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] [Bug 1201132] [NEW] Metadata Import for "Users" fails to import data. Hi Dapo This sounds a bit similar to my earlier issue posted to the list today. Have you tried doing the metadata import with superuser privilege? Bob On 14 July 2013 18:25, Dapo Adejumo <1201...@bugs.launchpad.net> wrote: > Public bug reported: > > Metadata Import for users fails to import any values despite records > in xml/json file. No log activity is recorded to indicate a failure. > > ** Affects: dhis2 > Importance: Undecided > Status: New > > -- > You received this bug notification because you are a member of DHIS 2 > developers, which is subscribed to DHIS. > https://bugs.launchpad.net/bugs/1201132 > > Title: > Metadata Import for "Users" fails to import data. > > Status in DHIS 2 - District Health Information Software: > New > > Bug description: > Metadata Import for users fails to import any values despite records > in xml/json file. No log activity is recorded to indicate a failure. > > To manage notifications about this bug go to: > https://bugs.launchpad.net/dhis2/+bug/1201132/+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 > -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1201132 Title: Metadata Import for "Users" fails to import data. Status in DHIS 2 - District Health Information Software: New Bug description: Metadata Import for users fails to import any values despite records in xml/json file. No log activity is recorded to indicate a failure. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1201132/+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 ___ 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] [Bug 1201132] [NEW] Metadata Import for "Users" fails to import data.
Forgot to add - affects both latest versions of 2.11 (Revision 10585) and 2.12 (Revision 11221). .. Regards Dapo Adejumo +2348033683677 Skype : dapojorge -Original Message- From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo@lists.launchpad.net] On Behalf Of Dapo Adejumo Sent: Sunday, July 14, 2013 5:26 PM To: dhis2-devs@lists.launchpad.net Subject: [Dhis2-devs] [Bug 1201132] [NEW] Metadata Import for "Users" fails to import data. Public bug reported: Metadata Import for users fails to import any values despite records in xml/json file. No log activity is recorded to indicate a failure. ** Affects: dhis2 Importance: Undecided Status: New -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1201132 Title: Metadata Import for "Users" fails to import data. Status in DHIS 2 - District Health Information Software: New Bug description: Metadata Import for users fails to import any values despite records in xml/json file. No log activity is recorded to indicate a failure. To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/1201132/+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 ___ 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