[Dhis2-users] Removing duplicates in aggregating TEI

2018-10-03 Thread Absolom MURAMIRA
Dear All, I am not sure if this feature is already implemented in DHIS2 but hopefully someone will guide me. We are currently using DHIS2 for M&E of a project for improving services for vulnerable populations. specifically, we use tracker capture app to keep track of services each program benefi

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
Win Server 2016 On Wed, Oct 3, 2018, 19:14 Bob Jolliffe wrote: > Upgrading from 2.28 to 2.29 should be smooth enough. At least I haven't > heard of issues. There a few hazards with the next step as I indicated. > What operating system platform are you on? > > On Wed, 3 Oct 2018 at 18:09, Walus

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Bob Jolliffe
Upgrading from 2.28 to 2.29 should be smooth enough. At least I haven't heard of issues. There a few hazards with the next step as I indicated. What operating system platform are you on? On Wed, 3 Oct 2018 at 18:09, Walusiku Muyunda wrote: > Thank you Bob for the insight. Am currently trying t

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
Thank you Bob for the insight. Am currently trying to upgrade from 2.28 to 2.29(since its recommended to for the sequential releases) then later when am sure the upgrade was successful, I'll upgrade to 2.30 and I'll keep your comments in mind. Am using the dhis user to connect to the data and its t

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Bob Jolliffe
There is a little bit of trickery involved with the upgrade from 2.29 to 2.30. It has been discussed earlier in this group I believe. It is related to the loading of the postgis extension. So it is quite important to understand which user you connect the database to run the upgrade.sql script, w

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
Looks like the upgrade script run just fine, but is there a way to verify that everything upgraded correctly besides waiting for users to report something thats not working? Thank you. On Wed, Oct 3, 2018 at 3:38 PM Walusiku Muyunda wrote: > Using PostgreSQL query window. What am I supposed t

Re: [Dhis2-users] Error when I click on Standard Report

2018-10-03 Thread Knut Staring
Hi Gabriel, Please provide details like version of DHIS2 and send to the dhis2-users@lists.launchpad.net. Regards, Knut On Wed, Oct 3, 2018, 8:57 AM Gabriel wrote: > Error when I click on Standard Report > An exception occurred > > Sorry! The system failed to execute the operation. Usually, no

Re: [Dhis2-users] Error when I click on Standard Report

2018-10-03 Thread Knut Staring
Sorry, see you added the version. Do you have access to the Tomcat log? Knut On Wed, Oct 3, 2018, 9:48 AM Knut Staring wrote: > Hi Gabriel, > Please provide details like version of DHIS2 and send to the > dhis2-users@lists.launchpad.net. > > Regards, > Knut > > On Wed, Oct 3, 2018, 8:57 AM Gabr

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
Using PostgreSQL query window. What am I supposed to use? *Thanks* On Wed, Oct 3, 2018 at 3:32 PM Stephen Ocaya wrote: > What are you using to execute the queries. I think it depends on the UI or > command. Otherwise, I think it should be OK. > > Regards > > On Wed, Oct 3, 2018, 14:23 Walusiku

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
When I execute the script in postgresql query window I get a result in 1sec with only 1 row affected. That does not seem to be good. The documentation next to the download only show what has been moved. Is there a specific way of running the script? On Wed, Oct 3, 2018 at 12:44 PM Mamadou Diao D

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Abdoulaye moria camara
Bien reçu Le mer. 3 oct. 2018 10:45, Mamadou Diao Diallo a écrit : > Hi Walusiku, > > The script should have comment on the procedure to upgrade, find here the > upgrade notes and scripts for all versions : > https://www.dhis2.org/downloads > > Best, > Diao > > *DIALLO MAMADOU DIAO Technical Adv

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Mamadou Diao Diallo
Hi Walusiku, The script should have comment on the procedure to upgrade, find here the upgrade notes and scripts for all versions : https://www.dhis2.org/downloads Best, Diao *DIALLO MAMADOU DIAO Technical Advisor and Developer* *John Snow Research and Training Institute | GOFR Connect - Drupal

[Dhis2-users] Ordinal position of columns for datavalue table differ

2018-10-03 Thread Ant Snyman
Dear DHIS2 community, I have two DHIS2 databases, both WAR2.28 and both the same build (b1abb3a) but the datavalue table differs in the ordinal position of the columns within the table. Would this be an indication of an update script somewhere that did not run through properly? Is there a script

[Dhis2-users] Specifications within a Data Element (Tracker)

2018-10-03 Thread Terence Scott
Dear All I am interested in placing criteria/specifications within a specific data element. For instance, I have created a DE for a unique ID number to be entered. However, there are specific codes that I would like to have entered into this DE (text type DE). For example, the UID should be 1 lett

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
Thank you Elmarie for the quick and very helpful response. I have downloaded the upgrade scripts, where can I find the upgrade procedure documentation? Or do I just run the upgrade script and then replace the war file with the newer version? On Wed, Oct 3, 2018 at 9:31 AM Elmarie Claasen wrote

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Elmarie Claasen
Hi Walusiki, You should always run sequential upgrades to the next version as there may be upgrade scripts for each version. After upgrade you need to start up the instance and then you can proceed to the next version. Regards, *Elmarie Claasen* [image: Hisp logo] Project Manager Health

[Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Walusiku Muyunda
Yet another quick question: Is it okay to upgrade from version 2.28 directly to 2.30. Are there any problems of doing so? Thank you *Walusiku J. Muyunda* *Cell: +260967006614Cell: +260971000614* *"We have heaven to win and hell to shun, our lives testify better!"

Re: [Dhis2-users] Indicators totaling to average rather than sum in pivot tables?

2018-10-03 Thread Elmarie Claasen
Hi Stanley, No, it has not been resolved. The initial bug reports was turned into a new feature DHIS2-2380 which is still pending. Regards, *Elmarie Claasen* [image: Hisp logo] Project Manager Health Information Systems Program Tel: 041-3