[Dhis2-users] launchpad mailing list closing - migrated to community.dhis2.org

[Lars Helge Øverland]

Hi all,

this is the final reminder - this Launchpad mailing list is now being
closed and further messages will be rejected.

We are moving to the Disqus platform at:

https://community.dhis2.org/

Please ensure you have an account or create a new one - see you there!



-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] performance fixes in 2.29 and 2.30

[Lars Helge Øverland]

Hi all,

just to let you know that we have made a range of performance fixes in
version 2.29 and 2.30 over the last month. The performance fixes are
related to:

- Saving of aggregate data values during data entry.
- Analytics query optimizations, affecting dashboard, pivots, chart.
- Fixing an incorrect cache configuration, leading to faster metadata
loading.

If you are managing a high-volume DHIS 2 instance it can be a good idea to
upgrade to the latest 2.29 or 2.30 build.

best regards,

Lars




-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] security issue - upgrade action required for 2.28 and older versions

[Lars Helge Øverland]

Hi all,

a potential serious security issue has been discovered with one of the
libraries used by DHIS 2. The issue can potentially allow attackers to
write or copy files to disk in arbitrary locations. The attacker needs to
be logged in to DHIS 2 (authenticated) to do this.

The affected versions are *DHIS 2.28 and older*.

We have patched the following versions: 2.25, 2.26, 2.27, 2.28.

We recommend that you upgrade to the latest build of the mentioned releases
if you are affected. We won't disclose more info about this issue on the
public mailing list.


best,

Lars


-- 

Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Demo 2.29 Down

[Lars Helge Øverland]

Up now.

Lars

On Wed, 14 Nov 2018 at 12:55, Terence Scott <
terence.sc...@rabiesalliance.org> wrote:

> I do too.
>
>
> Terence Scott
>
> Global Alliance for Rabies Control (GARC)
> Pan-African Rabies Control Network (PARACON) Steering Committee
> terence.sc...@rabiesalliance.org
> https://paracon.rabiesalliance.org
> Skype: tpscott1987
>
>
>
> On Wed, Nov 14, 2018 at 1:40 PM Damien Scarlett <
> damien.scarl...@brussels.msf.org> wrote:
>
>> I do as well
>>
>>
>>
>> *From:* Dhis2-users > brussels.msf@lists.launchpad.net> *On Behalf Of *kelvin murumba
>> *Sent:* Wednesday, 14 November 2018 12:15 PM
>> *To:* dhis2-users@lists.launchpad.net
>> *Subject:* [Dhis2-users] Demo 2.29 Down
>>
>>
>>
>> I am getting a Bad getaway error for the demo server. Any one
>> experiencing the same?
>>
>> --
>>
>>
>>
>> Kelvin Murumba
>> Software Engineer,
>>
>> Tel: +254 720 310 436,
>>
>> Skype: kevmurumba,
>> Nairobi, Kenya
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
> _______
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] 2.31 beta testing campaign - your help is needed!

[Lars Helge Øverland]

Dear all,

We will be running a DHIS 2 beta test campaign for 2.31 release from
November 12 to November 23, 2018.

The beta testing campaign is an opportunity for you to preview the very
latest features of DHIS 2 while helping us to catch existing features that
have been broken (regression) and check that new features are fit for
purpose. It's a big advantage to fix bugs and issues before release, so we
hope for your support in testing the release candidate as well as possible.


*Participation will be possible by either:*

   - Testing directly on our release candidate demo instance(s)
   - Downloading the release candidate war file, or building from the
   release candidate tag, and running your own instance


*Pro tip:* With 2.31, we have modified our build process to produce fully
deterministic builds. This means that if you build the war file yourself,
from the release candidate tag, you will get exactly the same war file that
we produce (regardless of when you build it).

The 2.31 final release will be available from *November 30* (assuming no
critical regression issues remain open at that time).


*Webinar: *Subject to demand, we will kick off the beta testing campaign by
holding a webinar with a brief demo of new features on November 12 at
around 14:00 CET. We welcome attendance from all of the DHIS2 Experts
community.

Please let p...@dhis2.org know if you are interested in the demo, and save
the date!

Note that we require a minimum of 10 participants for the webinar so your
support is critical!

Further details will be made available on our website at
www.dhis2.org/beta_testing in due course.


best regards,

Phil and Lars



Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] introducing Discourse for discussions and communications

[Lars Helge Øverland]

Hi all

*TL;DR* We are moving to Discourse <https://community.dhis2.org> for
discussions and communications, Launchpad <https://launchpad.net/dhis2> is
going away!

https://community.dhis2.org/

During the last Experts Academy, we introduced the DHIS2 Community of
Practice (CoP). The CoP is a response from many of you for a one-stop shop
to find relevant resources and information online. The CoP will be a forum
to ask DHIS2 questions and receive many answers with the possibility to
start a discussion. It will be a place to publish DHIS2 roadmaps and
discuss new features, get comments and feedback from the community, and
connect with sector-specific implementers.

The DHIS2 community has been using Launchpad as the mode of communication.
There are many useful functions with Launchpad but we have found that the
Discourse platform will meet more of the needs of the community. We believe
this move will enable us to have more in-depth conversations, include more
of the existing community members and reach new ones. Discourse can also
function as a mailing list and below are five other features that Discourse
offers which would be advantageous to the DHIS2 CoP:

   - Ability to highlight contributors (e.g., badges for most answers to
   questions, likes, topics created) so we can recognize people who have been
   significant participants in conversations and helped others.
   - Ability to build sub-forums to enable more focused discussions (e.g.,
   Case-based surveillance, CHIS, Security, Mobile) where interested parties
   can talk in detail without the entire community being notified.
   - Ability to reduce duplicate posts by showing related questions, pinned
   posts, etc.
   - Ability to add features like FAQ, voting for features or right
   answers, @mentioning relevant user groups or development teams, analytics
   on activity.
   - Ability to keep engaging the community by sending out weekly emails
   with the most active discussions.

To see how the DHIS2 CoP is set up, check out http://community.dhis2.org
and start testing out the new categories
<https://community.dhis2.org/categories> and provide feedback on how you
think the CoP looks so far.

Note also that all mailing list posts would be migrated from the existing
lists so that you can claim and own your old posts and we can start
recognizing major contributors immediately!

The aim is to migrate to Discourse completely in the end of November, with
the official closing of the Launchpad lists and launch of the new DHIS2 CoP
on November 29th.

You can contact commun...@dhis2.org for any questions - or of course post
it on Discourse <https://community.dhis2.org/>.


best regards,

Karoline and Lars




Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Text in Pivot Tables

[Lars Helge Øverland]

Hi there,

can confirm that this is a regression issue in pivots.

Thanks for writing up the bug issue
<https://jira.dhis2.org/browse/DHIS2-5031>. We will look into it.

regards,

Lars


On Tue, 30 Oct 2018 at 22:25, Sarah Searle  wrote:

> Hi Damien,
>
> Thanks for sharing. We recently experienced the same behavior. It seems
> the text values are present in the datavaluesets and the analytics tables,
> they just don't show up in the Pivot App itself. A bit frustrating for the
> end user because this worked up until quite recently. I need to get around
> to adding a Jira ticket for this. If you create one, let us know so we can
> keep an eye on it!
>
> Best,
> Sarah
>
>
> On Tue, Oct 30, 2018 at 5:03 PM Damien Scarlett <
> damien.scarl...@brussels.msf.org> wrote:
>
>> Hi Kate,
>>
>>
>>
>> Unsure if anyone else has replied but we tested a Data Element to capture
>> ‘Comments’ in Data Sets & found out it is displayed only when exported to
>> an Excel file in the Pivot Table app/section - an extract is attached.
>>
>>
>>
>> If anyone knows of an update/fix/better alternative please share.
>>
>>
>>
>> Thanks,
>>
>> *Damien*
>>
>> *From:* Dhis2-users > brussels.msf@lists.launchpad.net> *On Behalf Of *Hesel, Kate
>> *Sent:* Tuesday, 23 October 2018 4:25 PM
>> *To:* dhis2-users@lists.launchpad.net
>> *Subject:* [Dhis2-users] Text in Pivot Tables
>>
>>
>>
>> Hi All,
>>
>>
>>
>> We're *relatively* new users of DHIS2 and are trying to see written text
>> in our pivot tables - with no success so far.
>>
>>
>>
>> 2 questions for this group:
>>
>>1. Do Pivot Tables provide the ability to see written text entered
>>into the system (the text is connected to a data element) ?
>>2. If Yes, is there a particular/different way to query the system to
>>see it?
>>
>> Thanks all!
>>
>> Kate
>>
>>
>>
>> --
>>
>>
>> *Kate Hesel, MPH*
>>
>> Program Officer - Monitoring, Evaluation and Learning
>>
>> Planned Parenthood Global
>>
>> (w) 212.261.4508
>>
>> (m) 617.902.8511
>> Skype: katehesel
>>
>>
>> Web <http://www.plannedparenthood.org/global> / Twitter
>> <http://www.twitter.com/ppglobe>
>>
>> *This e-mail is for the sole use of the intended recipient(s) and
>> contains
>> information which is confidential and/or legally privileged. If you are
>> not
>> the intended recipient, you are hereby notified that any disclosure,
>> copying, distribution or taking of any action in reliance on the contents
>> of this e-mail information is strictly prohibited. If you have received
>> this e-mail in error, please immediately notify the sender by reply
>> e-mail
>> and destroy all copies of the original message.*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
>
>
>
> *Sarah Searle*
> Project Implementation Manager, BAO Systems
> +1 202-536-1541 | ssea...@baosystems.com  |
> http://www.baosystems.comSkype: searle.sarah | 2900 K Street, Suite 507,
> Washington D.C. 20007
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

[Lars Helge Øverland]

On Wed, 31 Oct 2018 at 07:03, stepho...@gmail.com 
wrote:

> Thanks Lars.
>
> Just to be clear, Is that the minimum requirements for PostgreSQL?
>
>
Correct. Version 9.6 or higher.

regards,

Lars



> Sent from my HTC
>
> - Reply message -----
> From: "Lars Helge Øverland" 
> To: "DHIS 2 Users list" , "DHIS 2
> Developers list" 
> Subject: [Dhis2-users] postgresql version 9.6 required for dhis version
> 2.31
> Date: Tue, Oct 30, 2018 23:33
>
> Hi all,
>
> heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6.
>
> This is in order to take advantage of certain SQL features introduced in
> that version. The current required version is 9.4.
>
> If you plan to upgrade your PostgreSQL version we recommend going straight
> to version 10, as it contains several great features and performance
> improvements. Also, we will eventually require this version and so going
> directly to version 10 will avoid multiple successive upgrades.
>
>
> best regards,
>
> Lars
>
>
>
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@dhis2.org
> https://www.dhis2.org
>
>

-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] postgresql version 9.6 required for dhis version 2.31

[Lars Helge Øverland]

On Wed, 31 Oct 2018 at 09:00, moses mwale  wrote:

> Sorry just to interject, so dhis2 does not work with Postgres 9.5?
>

PostgreSQL 9.5 will work up to DHIS 2 version 2.30.

For DHIS 2.31 you will need PostgreSQL 9.6 or higher.

regards,

Lars


> On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik  wrote:
>
>> Hi,
>>
>> PostGIS requirement is 2.2 or later.
>> AFAIK, this will still be the case for 2.31.
>>
>> Regards,
>> Bjørn
>>
>> --
>> Bjørn Sandvik
>> GIS developer, DHIS 2
>> University of Oslo
>> www.dhis2.org
>>
>> On Wed, Oct 31, 2018 at 8:18 AM Calle Hedberg 
>> wrote:
>>
>>> Hi,
>>>
>>> With regard to minimum pg requirements: Bjorn, what is the minimum
>>> version requirement for Postgis, and what is the recommended version?
>>> Again, postGIS 2.5 was released recently, so if people need to upgrade
>>> anyhow it makes sense to upgrade to the latest, tested version...
>>>
>>> Regards
>>> Calle
>>>
>>> On Wed, 31 Oct 2018 at 09:15, Calle Hedberg 
>>> wrote:
>>>
>>>> Lars,
>>>>
>>>> With postgresql version 11 out - are there any specific reasons for NOT
>>>> using pg 11? Many of the key features introduced in 10 - like table
>>>> partitioning - have been further enhanced in 11.
>>>>
>>>> Regards
>>>> Calle
>>>>
>>>> On Wed, 31 Oct 2018 at 08:04, stepho...@gmail.com 
>>>> wrote:
>>>>
>>>>> Thanks Lars.
>>>>>
>>>>> Just to be clear, Is that the minimum requirements for PostgreSQL?
>>>>>
>>>>> Sent from my HTC
>>>>>
>>>>> - Reply message -
>>>>> From: "Lars Helge Øverland" 
>>>>> To: "DHIS 2 Users list" , "DHIS 2
>>>>> Developers list" 
>>>>> Subject: [Dhis2-users] postgresql version 9.6 required for dhis
>>>>> version 2.31
>>>>> Date: Tue, Oct 30, 2018 23:33
>>>>>
>>>>> Hi all,
>>>>>
>>>>> heads up: for DHIS 2 version 2.31 we will require PostgreSQL version
>>>>> 9.6.
>>>>>
>>>>> This is in order to take advantage of certain SQL features introduced
>>>>> in that version. The current required version is 9.4.
>>>>>
>>>>> If you plan to upgrade your PostgreSQL version we recommend going
>>>>> straight to version 10, as it contains several great features and
>>>>> performance improvements. Also, we will eventually require this version 
>>>>> and
>>>>> so going directly to version 10 will avoid multiple successive upgrades.
>>>>>
>>>>>
>>>>> best regards,
>>>>>
>>>>> Lars
>>>>>
>>>>>
>>>>>
>>>>> Lars Helge Øverland
>>>>> Technical lead, DHIS 2
>>>>> University of Oslo
>>>>> l...@dhis2.org
>>>>> https://www.dhis2.org
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to : dhis2-d...@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> ***
>>>>
>>>> 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-19119
>>>>
>>>> Email: calle.hedb...@gmail.com
>>>>
>>>> Skype: calle_hedberg
>>>>
>>>> ***
>>>>
>>>>
>>>
>>> --
>>>
>>> ***
>>>
>>> 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-19119
>>>
>>> Email: calle.hedb...@gmail.com
>>>
>>> Skype: calle_hedberg
>>>
>>> ***
>>>
>>>
>>
>> --
>> Bjørn Sandvik
>> GIS developer, DHIS 2
>> University of Oslo
>> www.dhis2.org
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
> --
> developer_lusaka_systems
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] postgresql version 9.6 required for dhis version 2.31

[Lars Helge Øverland]

On Wed, 31 Oct 2018 at 08:15, Calle Hedberg  wrote:

> Lars,
>
> With postgresql version 11 out - are there any specific reasons for NOT
> using pg 11? Many of the key features introduced in 10 - like table
> partitioning - have been further enhanced in 11.
>
>
No reason that I am aware of and it will likely work fine.

The reason for recommending 10 is that DHIS 2 is *well tested* on that
version as the developers are using it and I am aware of many prod
installations using it.

regards,

Lars




> Regards
> Calle
>
> On Wed, 31 Oct 2018 at 08:04, stepho...@gmail.com 
> wrote:
>
>> Thanks Lars.
>>
>> Just to be clear, Is that the minimum requirements for PostgreSQL?
>>
>> Sent from my HTC
>>
>> - Reply message -
>> From: "Lars Helge Øverland" 
>> To: "DHIS 2 Users list" , "DHIS 2
>> Developers list" 
>> Subject: [Dhis2-users] postgresql version 9.6 required for dhis version
>> 2.31
>> Date: Tue, Oct 30, 2018 23:33
>>
>> Hi all,
>>
>> heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6.
>>
>> This is in order to take advantage of certain SQL features introduced in
>> that version. The current required version is 9.4.
>>
>> If you plan to upgrade your PostgreSQL version we recommend going
>> straight to version 10, as it contains several great features and
>> performance improvements. Also, we will eventually require this version and
>> so going directly to version 10 will avoid multiple successive upgrades.
>>
>>
>> best regards,
>>
>> Lars
>>
>>
>>
>> Lars Helge Øverland
>> Technical lead, DHIS 2
>> University of Oslo
>> l...@dhis2.org
>> https://www.dhis2.org
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
>
> ***
>
> 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-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>

-- 


Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] postgresql version 9.6 required for dhis version 2.31

[Lars Helge Øverland]

Hi all,

heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6.

This is in order to take advantage of certain SQL features introduced in
that version. The current required version is 9.4.

If you plan to upgrade your PostgreSQL version we recommend going straight
to version 10, as it contains several great features and performance
improvements. Also, we will eventually require this version and so going
directly to version 10 will avoid multiple successive upgrades.


best regards,

Lars



Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Calculation indicator for some organisation unit in the formula

[Lars Helge Øverland]

Hi Carlos,

this has now been fixed in latest build of 2.28, 2.29 and 2.30.

Thanks for reporting.

best,

Lars


On Wed, 19 Sep 2018 at 15:06, Stéphan Mestach 
wrote:

> Looks similar to what I've reported :
> http://dhis-developers-list.1563109.n2.nabble.com/Indicator-that-counts-the-number-of-orgunits-within-a-group-by-region-td7613915.html
>
> No news since then. Currently I don't have access to the logs of the dhis2
> server (hosted by a third party).
> May be a having a stacktrace might help them identify the issue.
>
> Stéphan
>
> On Wed, Sep 19, 2018 at 12:58 PM, Carlos Nyembwe 
> wrote:
>
>> Hi dev,
>>
>> Since version 2.26, we have noticed in the analysis of our indicators
>> containing the number of organizational units in the formula, and when we
>> want to display the PivotTable by placing the organizational units either
>> in columns or online , the process is only turning and not results, but
>> with the previous versions, we had tables that were displayed and now they
>> are not displayed anymore.
>>
>> We submitted the problem not as a result.
>>
>> So, how can I solve this problem?
>>
>> Thank you
>>
>> On Fri, Oct 21, 2016 at 12:44 PM Carlos Nyembwe 
>> wrote:
>>
>>> Hi everyone,
>>>
>>> I have a problem in my system, I need to use an indicator just for some
>>> organisation unit, now it's big problem in my mind, I can't to solve it.
>>>
>>> who can help me?
>>>
>>> Thanks
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381*
>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
>>> **Linkedin
>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>> <https://www.facebook.com/carloscnksys> | Twitter
>>> <https://twitter.com/Carlos_CNK> |*
>>>
>>
>>
>> --
>> *Carlos Nyembwe*
>> *I'm just a Computer Scientist*
>>
>> *Skype: carloscnk1*
>> *Cell: (+243)813166381*
>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | 
>> **Linkedin
>> <http://www.linkedin.com/in/carloscnk> | Facebook
>> <https://www.facebook.com/carloscnksys> | Twitter
>> <https://twitter.com/Carlos_CNK> |*
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> Stéphan Mestach
>
> Developer
>
>
> www.bluesquarehub.com
> [image: twitter.png] <https://twitter.com/blsqhub> [image: facebook.png]
> <https://www.facebook.com/blsqhub/> [image: linkedin.png]
> <https://www.linkedin.com/company/bluesquarehub>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Indicator totals count is incorrect

[Lars Helge Øverland]

Hi Gourav,

thanks and, perhaps surprisingly, this is expected behavior as of now.
Indicators are often percentages, and it does not make sense to summarize a
lot percentages across different indicators; it makes more sense to average
them.

That said, sometimes indicators represents plain sums of data elements (no
denominator, or denominator = 1), so we are working on some refinements
here which we will backport.

best,

Lars


On Tue, 18 Sep 2018 at 08:09, gourav sachdeva 
wrote:

> Hello Team,
>
> I'm facing an issue in a pivot table, version 2.28 while calculating the
> total of indicators.
>
> Whenever I try to generate the pivot report with indicators it shows the
> average instead of the sum in the total section. I checked, the same issue
> has been created on Jira and the status is resolved but I am still facing
> the above mentioned.
>
> https://jira.dhis2.org/browse/DHIS2-3350
>
> Version: 2.28
> Build Revision: 6657e9d
> Build Date: 2018-09-17 03:20
>
> The screenshot is enclosed for the reference with the mail.
> Looking forward to your response.
>
> --
> *Thanks & Regards,*
>
> *Gourav Sachdeva*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Request For Help On How to Develop Application in DHIS2

[Lars Helge Øverland]

Hi,

you can use the Apps developer docs as a start:

https://docs.dhis2.org/master/en/developer/html/apps.html

regards,

Lars


On Tue, 28 Aug 2018 at 12:50, Getachew Chala  wrote:

> He all of you there!
> I need help and resources on how to develop applications in DHIS2 and
> Upload it into the DHIS2 Generic Applications' Package.
>
> Thanks for your would be positive reaction.
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] new identity and logo for DHIS 2

[Lars Helge Øverland]

Dear all,

we are today introducing a new identity and logo for DHIS 2. The logo is
meant to illustrate DHIS 2 as a platform and the use of data for action.

Master logo:

[image: master.png]

Reversed logo on blue:

[image: reverse.png]
You can get the source material and read about instructions for use here:

https://github.com/dhis2/dhis2-identity

The logo font is the open source Rubik
<https://fonts.google.com/specimen/Rubik> from Google Fonts.

We will introduce the new logo gradually into the DHIS 2 software and plan
to be done for 2.31 release.

regards,

Lars






-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Setup DHIS2 in Linux (Debian)

[Lars Helge Øverland]

Hi Nayeem,

sorry not to answer you question exactly, but Ubuntu is in fact based on
Debian and is a more user-friendly version of it. They use the same kernel
and package manager, and the Ubuntu install guide will likely work well
also on Debian.

regards,

Lars


On Mon, 27 Aug 2018 at 10:03, Nayeem Al Mifthah  wrote:

> Dear All
> I apologize for any misunderstanding. I know well about DHIS2 installation
> in ububtu, windows, sentOS. I just want to know about any specific area to
> be address in Debian.
>
> *Nayeem Al Mifthah*
> *Health Information Systems Specialist*
> Support to the National HMIS
> MIS, Directorate General of Health Services, Ministry of Health and Family
> Welfare, Bangladesh
> Telephone: +880-2-58816459|Fax: +880-2-58813875|Mobile:
>  +88-01914 030 574
> Email: n.mift...@gmail.com|Skype: nayeem.a.m|   LinkedIn:
> linkedin.com/in/nayeemam
>
>
> On Mon, Aug 27, 2018 at 1:56 PM Sachin Chougule 
> wrote:
>
>> Hi,
>>
>> The below document helped me to setup DHIS2 on my ubuntu machine. I hope
>> it will help you too.
>> Link-
>> https://docs.dhis2.org/2.28/en/implementer/html/install_server_setup.html
>>
>> Regards,
>> Sachin.
>>
>> On Mon, Aug 27, 2018 at 1:20 PM Muhammad Adeel  wrote:
>>
>>> Hi Nayeem,
>>>
>>>
>>>1. I have a Ansible configuration for Ubuntu here
>>>https://github.com/adeelshahid/dhis2-core-ansible/ it can be tuned
>>>for Debian or you can get an idea what needs to be in place to put up
>>>things.
>>>2. *Scaling the setup*. Too much PostgresSQL data, how does one
>>>shard or scale DHIS2 system. Which is important to plan before running 
>>> into
>>>problems in the future. I would recommend some backend person responds on
>>>that.
>>>
>>> Regards,
>>> Adeel
>>>
>>> On Mon, Aug 27, 2018 at 9:45 AM Nayeem Al Mifthah 
>>> wrote:
>>>
>>>> Anyone having documentation on setup DHIS2 in Debian?
>>>>
>>>>
>>>> *Nayeem Al Mifthah*
>>>> *Health Information Systems Specialist*
>>>> Support to the National HMIS
>>>> MIS, Directorate General of Health Services, Ministry of Health and
>>>> Family Welfare, Bangladesh
>>>> Telephone: +880-2-58816459|Fax: +880-2-58813875|Mobile:
>>>>  +88-01914 030 574
>>>> Email: n.mift...@gmail.com|Skype: nayeem.a.m|   LinkedIn:
>>>> linkedin.com/in/nayeemam
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> --
>> Sachin Chougule
>> Jr. System Administrator
>> Plus91 Technologies Private Limited
>> 
>> Email-   sachin.choug...@plus91.in
>> Mobile- +917776057100
>> Web- https://www.plus91.in
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] dhis version 2.30 is released

[Lars Helge Øverland]

*Hi all,DHIS version 2.30 is out with many new features, apps and
improvements.Login with admin/district on the demo
 system.ANALYTICS FEATURES---Linkable
dashboards: Individual dashboards can now be linked to through the URL.
This makes it easier to share dashboards through email and chats.Screenshot

| Demo
Mentions
in interpretations and comments: You can now mention users in
interpretations and comments by using @. Users who are mentioned will
receive a notification in the messaging app. Notifications over email and
SMS can also be enabled through user settings. Interpretations can be
written from the right-side panel.Screenshot

| Demo
Subscribe
to analytics items:  You can now subscribe to analytics items. Subscribing
means that you will receive a notification whenever a new interpretation or
comment is made for the analytical object you subscribed to. Look out for
the bell icon.Screenshot

| Demo
Interpretations
panel in maps: The maps app now has an interpretations panel to the right
which lets you write new interpretations and view existing ones for a
map.Screenshot

| Demo
File
menu in maps: The maps app now supports the file menu you are used to from
pivot table and chart apps.Screenshot

| Demo Buffers in event map
layers: You can now render buffers for events in the maps app. This is
useful e.g. for visualizing coverage of health services. Zoom in to see
buffers on the demo.Screenshot

| Demo
Tracked
entity thematic layer: The maps app now provides a thematic layer for
viewing tracked entities. Users can choose the the tracked entity type,
program, active or complete, period of last updated, organizational unit,
and style including an optional buffer. Screenshot 1

| 2

| 3

| Demo
Style
by data items in event maps: In the maps app you can now style each event
layer independently, i.e. chose the color and size of event points and
clusters.Screenshot 1

| 2

| Demo
APPS---We
have completely rewritten 5 web apps to provide a consistent and better
user interface and improve the software architecture:User app: The user app
has been redesigned with Material UI to provide a more elegant and
user-friendly interface. User roles and authorities management have been
reworked to make it a lot clearer and easier to get the overview of the
available authorities. Tracker authorities have been replaced to a large
extent by the new data level sharing model, simplifying the setup of
tracker user roles.Screenshot 1

| 2

| Demo Import-export
app: The import-export app also has a new, fresh look. The new app also
exposes a lot more of the features and options available through the API in
a rich and intuitive interface.Screenshot 1

| 2

| Demo
Messaging
app: The messaging app is also refreshed, and styled in the manner of
modern email and messaging 

Re: [Dhis2-users] [Dhis2-devs] usage of "light" web module

[Lars Helge Øverland]

Okay thanks Calle for the feedback.

We will do that then - remove light module in 2.30. If there are popular
use-cases for web-based feature phone data entry we will build a new app
using a modern web framework.

regards,

Lars


On Mon, 25 Jun 2018 at 16:01, Calle Hedberg  wrote:

> Hi
>
> I cannot recall having encountered any use of this the last few years.
> Suggest removing it from 2.30, but keep a functional "backup" just in
> case  If nobody yells within the first 2 months, then dump it ;-)
>
> Regards
> Calle
>
> On 25 June 2018 at 14:41, Lars Helge Øverland  wrote:
>
>>
>> Bringing the usage of "light" module to people's attention again. I have
>> only received one message on this topic which says it is not used. Does
>> this mean that we can remove this module from DHIS 2? Any reasons not to
>> remove it out there?
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>>
>> On Thu, 14 Jun 2018 at 13:44, Lars Helge Øverland  wrote:
>>
>>> Hi all,
>>>
>>> the "light" web module for data entry, typically used by low-end mobile
>>> phones, is aging. We are interested in learning to what extent this module
>>> is being used to understand whether we should invest in developing a new
>>> version of it. If you are using the module, or aware of anyone using it,
>>> please let us know either here on the list or directly to me.
>>>
>>> This is the module being referred to:
>>> https://play.dhis2.org/2.29/light/index.action
>>>
>>> best regards,
>>>
>>> Lars
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Technical lead, DHIS 2
>>> University of Oslo
>>> l...@dhis2.org
>>> https://www.dhis2.org
>>>
>>>
>>
>> --
>> Lars Helge Øverland
>> Technical lead, DHIS 2
>> University of Oslo
>> l...@dhis2.org
>> https://www.dhis2.org
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> 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-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>

-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] usage of "light" web module

[Lars Helge Øverland]

Bringing the usage of "light" module to people's attention again. I have
only received one message on this topic which says it is not used. Does
this mean that we can remove this module from DHIS 2? Any reasons not to
remove it out there?

regards,

Lars






On Thu, 14 Jun 2018 at 13:44, Lars Helge Øverland  wrote:

> Hi all,
>
> the "light" web module for data entry, typically used by low-end mobile
> phones, is aging. We are interested in learning to what extent this module
> is being used to understand whether we should invest in developing a new
> version of it. If you are using the module, or aware of anyone using it,
> please let us know either here on the list or directly to me.
>
> This is the module being referred to:
> https://play.dhis2.org/2.29/light/index.action
>
> best regards,
>
> Lars
>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@dhis2.org
> https://www.dhis2.org
>
>

-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] How to Add New Apps to DHIS2

[Lars Helge Øverland]

Hi,

please have a look at the docs here:

https://docs.dhis2.org/master/en/developer/html/apps.html

regards,

Lars


On Sun, 24 Jun 2018 at 09:56, Getachew Chala  wrote:

> Please i need help on how to add apps locally i have developed.
>
> Thank you for your support
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Able to make calls to DHIS 2.28 with /api/25

[Lars Helge Øverland]

Hi Kumar,

we wanted to be a bit relaxed and give clients a chance to warm up to the
versioning but please don't rely on it ;)

regards,

Lars



On Thu, 14 Jun 2018 at 15:24, Kumar Shahdeo 
wrote:

> Hi All,
>
> I recently upgraded to DHIS 2.28 from DHIS 2.27.
> I was using versioned API (/api/25) to make calls in DHIS 2.27
> I found that, I am able to make calls to DHIS 2.28 with /api/25
> It is clearing mentioned in documentation that versioned API is supported
> for three versions i.e /api/25 should be able to make calls to DHIS 2.25,
> 2.26 and 2.27 versions.
> Has anything changed in this contract?
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=kumar-gaurav%20nath%20shahdeo-signature_medium=email_source=thoughtworks-email-signature-generator>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] usage of "light" web module

[Lars Helge Øverland]

Hi all,

the "light" web module for data entry, typically used by low-end mobile
phones, is aging. We are interested in learning to what extent this module
is being used to understand whether we should invest in developing a new
version of it. If you are using the module, or aware of anyone using it,
please let us know either here on the list or directly to me.

This is the module being referred to:
https://play.dhis2.org/2.29/light/index.action

best regards,

Lars


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Short name as a system setting

[Lars Helge Øverland]

Hi there,

I guess this is not really a question of whether it makes sense, rather
that nobody has asked for it ;)

The analytics API
<https://docs.dhis2.org/master/en/developer/html/webapi_analytics.html>
already supports this behavior so adding it to the clients should not be
difficult.

What would be the main usecase here?

regards,

Lars


On Thu, 7 Jun 2018 at 18:33, Knut Staring  wrote:

> There is a lot of value in being able to select "short names" for
> analytical outputs like charts and tables, but currently this is a system
> setting, i.e. you have to make the decision for EVERYTHING. Would it not
> make more sense to specify this PER FAVORITE? And should CODE be a third
> option?
>
> To make it a slightly wider discussion, to what extent are people actually
> using short names for?
>
> Thanks,
> Knut
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] data level sharing and access control in 2.29

[Lars Helge Øverland]

Hi all,

in 2.29 we introduced a significant change in the access control solution
in DHIS 2.

In essence, two new levels within the sharing solution were introduced: *Can
capture data* and *Can view data*. These levels applies to capturing
data/events and viewing data/events in analytics, and complements the two
existing levels so that we now have:

Metadata
--
1. Can edit and view metadata
2. Can view metadata

Data/events
--
3. Can capture and view data
4. Can view data


This means that you can now control who can capture data for data sets,
programs and program stages through the sharing solution. Previous to 2.29
this was done through user roles, where data sets and programs were
associated with user roles.

You can also control who can see data in analytics for programs and
category options through the new "can view data" sharing level.


We have updated the sharing user *documentation* to reflect this:

https://docs.dhis2.org/master/en/user/html/sharing.html


We have also have some excellent new *videos* which elaborates on this
topic - look for "Data level sharing":

https://www.dhis2.org/spotlight


The *motivation* behind this change in the access control model is:

- It provides a single place to control access to DHIS 2 objects. The user
role associations to data sets and programs have been removed and replaced
by the mentioned sharing levels.

- It opens for more flexibility in access control. Going forward we plan to
introduce more fine-grained data level sharing and include support for
entities like data elements and tracked entity attributes.

- It allows better control over who can view data in analytics, in
particular for program and tracker data.


The 2.29 *upgrade* script will create a user group per user role and share
those groups with the appropriate data sets and programs. You can of course
opt not to run this part of the script and instead do the upgrade manually.

https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-229.sql


best regards,

Lars


PS. thanks Nick Dutta for excellent videos.


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Import/Export data between similar but distinct systems

[Lars Helge Øverland]

Hi Martin,

when you say import/export I assume data value exchange here - correct?

The approach I recommend is using the "identifier schemes". This allows you
to keep multiple sets of identifiers (id schemes) for data elements and org
units. You can set it up simply by adding unique metadata attributes for
data elements and/org units (do so from maintenance app > Attributes). Then
enter the identifiers used by "the other side".

Example: Add a unique metadata attribute called "Foo ID". Then add those
identifiers like "ID001", "ID002", for your data elements and org units.

Then during import and/or export, you can specify which id scheme to use
for matching data to metadata. You can choose between UID, code and unique
attributes.

You can read more about id schemes here:

https://docs.dhis2.org/master/en/developer/html/webapi_identifier_schemes.html

You can read how to use them in data value import here:

https://docs.dhis2.org/master/en/developer/html/webapi_data_values.html#webapi_data_values_import_parameters


regards,

Lars







On 9 January 2018 at 19:56, Martin Van Aken <mar...@joyouscoding.com> wrote:

> Hello DHIS2 community,
> We need to make frequent import/export between two different DHIS2
> systems. While they are similar and the format "fits", we know some
> differences, mainly:
>
> - The org units concerned exist on both sides but with different ids
> - Same for the data elements
> - In some situation, the export value may be an indicator, to be imported
> in a data element
>
> I can imagine making the export in CSV, then having a "matching sheet" in
> XLS with the link between OU in the source system and OU in the destination
> system.
>
> Is someone doing those kind of operations? What's your typical flow/way of
> working?
> I think I remember Lars presenting some feature helping with this on one
> of the last DHIS2 releases, but I'm not sure.
>
> Martin
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] dhis 2.29: postgresql only

[Lars Helge Øverland]

A correction to my own statement here - DHIS version 2.29 requires
PostgreSQL *9.4* (not 9.1 as previously stated).

You can find a section in the install docs here which clarifies it:

https://docs.dhis2.org/master/en/implementer/html/install_software_requirements.html


Apologies for the confusion.

Lars


On 26 March 2018 at 12:05, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi,
>
> in dhis version 2.29 we require PostgreSQL as the database platform,
> together with the PostGIS spatial extension. This means that MySQL is no
> longer supported.
>
> The minimum version required is PostgreSQL 9.1. However we recommend
> upgrading to a later version as we plan to take advantage of some of the
> useful features part of PostgreSQL 10 such as logical replication and
> native partitioning in future versions of DHIS 2.
>
> You can read more here:
>
> - What's new in PG 10
> <https://wiki.postgresql.org/wiki/New_in_postgres_10>
> - Install PG 10 on Ubuntu
> <http://yallalabs.com/linux/how-to-install-and-use-postgresql-10-on-ubuntu-16-04/>
> - DHIS 2 installation guide
> <https://docs.dhis2.org/master/en/implementer/html/installation.html>
>
>
> best,
>
> Lars
>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@dhis2.org
> https://www.dhis2.org
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Problem with recaptcha

[Lars Helge Øverland]

Added this as a Q & A here
<https://webmasters.stackexchange.com/questions/113922/recaptcha-v1-not-working-with-dhis-2/113923>
.

Lars


On 27 March 2018 at 12:27, Henning Håkonsen <henn...@dhis2.org> wrote:

> Hi,
>
> With the new recaptcha you are required to add a site key and secret key.
> Please visit Settings -> access and add the keys you get when registering
> on google (https://www.google.com/recaptchal)
>
> Further docs: https://docs.dhis2.org/2.29/en/developer/html/webapi_
> system_settings.html
>
> Regards,
> Henning Håkonsen
> henn...@dhis2.org
>
>
>
>
> On 27 Mar 2018, at 12:20, Elmarie Claasen <elma...@hisp.org> wrote:
>
> Hi all,
>
>
> It seems that Google has stopped support for recaptcha v1 and recaptcha v2
> is necessary.
> I just updated an instance to
> Version:
> 2.28
> Build revision:
> 927ddf9
> Build date:
> 2018-03-27 06:22
>
>
> The recaptcha on self-registration page still shows:
> 
>  But on Sierra Leone the v2 I am not a bot is working.
>
>
> What could be the issue and how does one update existing versions running?
>
>
> Regards,
>
>
> *Elmarie Claasen*
> 
> Project Manager
> Health Information Systems Program
> Tel:  041-367 1027
> Cell: 082 374 2209
> E-mail: 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 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-d...@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-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Locking Data Values when Data Set is Complete

[Lars Helge Øverland]

Hi Pamod,

thanks, to clarify, what you want is simply to disable the input fields
when the complete button is clicked, and the renable the input fields when
the incomplete button is clicked?

Lars


On 27 March 2018 at 08:26, Pamod Amarakoon <pam...@gmail.com> wrote:

> Dear All,
>
> This is with reference to the previous discussion on similar issue in 2015
> (link below)
> https://lists.launchpad.net/dhis2-devs-core/msg00377.html
>
> As I'm aware disabling editing of data values happens through locking
> mechanism which is mainly dependent on expiry date and data approval.
>
> We have a situation in Sri Lanka where we are already using expiry date
> and data approval in the data workflow. But due to practical reasons we
> cannot set a relatively short expiry date. We are assessing performance of
> facilities based on data set completion date. To achieve our objective we
> need to lock the data set after completion thereby if a user needs to edit
> data again then he first has to incomplete data set (so completeness date
> changes accordingly).
>
> Currently we are using a modified form.js in web-data entry folder to
> achieve this. Just wondering whether there are any plans to implement this
> feature in near future.
>
> Thank you.
>
> --
> Regards,
> Pamod Amarakoon
> MBBS (SL)
> MSc (Biomedical Informatics), EMSc (Health Admin), PGCert (MedEd), CEH
>
> HISP Sri Lanka
>
> Confidentiality Notice: the information contained in this email and any
> attachments may be legally privileged and confidential. If you are not an
> intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this e-mail is strictly prohibited. If you have
> received this e-mail in error, please notify the sender and permanently
> delete the e-mail and any attachments immediately. You should not retain,
> copy or use this e-mail or any attachments for any purpose, nor disclose
> all or any part of the contents to any other person.
>
>
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Analytics not stopping

[Lars Helge Øverland]

It seems the analytics process does not start. Can you look in the
developer console for errors and network activity?


On 26 March 2018 at 19:16, Ryan Nazareth <r...@mantaraymedia.co.uk> wrote:

> Hi Lars,
>
>
>
> Ive attached the log file. I have just reinstalled dhis2 and ran it with
> the default dhs conf file – the analytics (export) seemed to do run with a
> summary/report generated. When I ran it again after logging in to DHIS2
> after adjusting the conf file with my PostgreSQL details  -   I get the
> yellow bar (pic below)  and it does not stop.
>
>
>
>
>
> *From:* Lars Helge Øverland <l...@dhis2.org>
> *Sent:* 26 March 2018 15:49
> *To:* Ryan Nazareth <r...@mantaraymedia.co.uk>
> *Cc:* calle.hedb...@gmail.com; dhis2-users@lists.launchpad.net;
> dhis2-d...@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] [Dhis2-devs] Analytics not stopping
>
>
>
> Hi Ryan,
>
>
>
> are you getting any other errors in the tomcat log which you can share?
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
> On 26 March 2018 at 16:42, Ryan Nazareth <r...@mantaraymedia.co.uk> wrote:
>
> Thanks Calle. This a bit strange because Ive had analytics running
> overnight after clicking the ‘Start Export’ button. Do I need to change any
> default settings in some of the other apps before running analytics ?
>
>
>
> Best Wishes
>
> Ryan
>
>
>
> *From:* Calle Hedberg <calle.hedb...@gmail.com>
> *Sent:* 26 March 2018 11:45
> *To:* Ryan Nazareth <r...@mantaraymedia.co.uk>
> *Cc:* dhis2-users@lists.launchpad.net; dhis2-d...@lists.launchpad.net
> *Subject:* Re: [Dhis2-devs] Analytics not stopping
>
>
>
> Ryan
>
>
>
> Those log errors are not relevant - you see them because you haven't run
> analytics yet.
>
>
>
> Regards
>
> Calle
>
>
>
> On 26 March 2018 at 12:22, Ryan Nazareth <r...@mantaraymedia.co.uk> wrote:
>
> Hi all,
>
>
>
> I am trying to import the Sierra Leone database – Ive just run analytics
> after importing the sql dump into PostgreSQL., but it doesn’t seem to stop
> (Ive had it run overnight and re run it again with skipping the event and
> enrolment data generation.
>
> These are some of the errors I was getting in my log fil (below). Any help
> would be greatly appreciated (there is probably something trivial which Ive
> missed out)
>
>
>
> Best Wishes
>
> Ryan
>
>
>
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "analytics_2018" does not exist
>
>   Position: 53
>
> at org.postgresql.core.v3.QueryExecutorImpl.
> receiveErrorResponse(QueryExecutorImpl.java:2476)
>
> at org.postgresql.core.v3.QueryExecutorImpl.
> processResults(QueryExecutorImpl.java:2189)
>
> at org.postgresql.core.v3.QueryExecutorImpl.execute(
> QueryExecutorImpl.java:300)
>
> at org.postgresql.jdbc.PgStatement.executeInternal(
> PgStatement.java:428)
>
> at org.postgresql.jdbc.PgStatement.execute(
> PgStatement.java:354)
>
> at org.postgresql.jdbc.PgStatement.executeWithFlags(
> PgStatement.java:301)
>
> at org.postgresql.jdbc.PgStatement.executeCachedSql(
> PgStatement.java:287)
>
> at org.postgresql.jdbc.PgStatement.executeWithFlags(
> PgStatement.java:264)
>
> at org.postgresql.jdbc.PgStatement.executeQuery(
> PgStatement.java:231)
>
> at com.mchange.v2.c3p0.impl.NewProxyStatement.
> executeQuery(NewProxyStatement.java:327)
>
> at org.springframework.jdbc.core.JdbcTemplate$
> 1QueryStatementCallback.doInStatement(JdbcTemplate.java:458)
>
> at org.springframework.jdbc.core.JdbcTemplate.execute(
> JdbcTemplate.java:408)
>
> ... 18 more
>
> * INFO  2018-03-21 15:33:49,670 Query failed, likely because the requested
> analytics table does not exist (JdbcAnalyticsManager.java
> [taskScheduler-20])
>
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
> SQL grammar [select "dx","co","uidlevel2","yearly", sum(value) as value
> from analytics_2017 where "dx" in ('DTVRnCGamkV') and "co" in
> ('bRowv6yZOF2', 'Prlt0C1RF0s', 'V6L425pT3A0') and "uidlevel2" in
> ('qhqAxPSTUXp') and "yearly" in ('2017') group by
> "dx","co","uidlevel2","yearly"]; nested exception is 
> org.postgresql.util.PSQLException:
> ERROR: relation "analytics_2017" 

Re: [Dhis2-users] [Dhis2-devs] Analytics not stopping

[Lars Helge Øverland]

  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
>
> at java.lang.reflect.Method.invoke(Unknown Source)
>
> at org.springframework.aop.support.AopUtils.
> invokeJoinpointUsingReflection(AopUtils.java:333)
>
> at org.springframework.aop.framework.
> ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.
> java:190)
>
> at org.springframework.aop.framework.
> ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
>
> at org.springframework.aop.interceptor.
> AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:115)
>
> at java.util.concurrent.FutureTask.run(Unknown Source)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(Unknown Source)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.run(Unknown Source)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
> Source)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>
> at java.lang.Thread.run(Unknown Source)
>
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "analytics_2017" does not exist
>
>   Position: 65
>
> at org.postgresql.core.v3.QueryExecutorImpl.
> receiveErrorResponse(QueryExecutorImpl.java:2476)
>
> at org.postgresql.core.v3.QueryExecutorImpl.
> processResults(QueryExecutorImpl.java:2189)
>
> at org.postgresql.core.v3.QueryExecutorImpl.execute(
> QueryExecutorImpl.java:300)
>
> at org.postgresql.jdbc.PgStatement.executeInternal(
> PgStatement.java:428)
>
> at org.postgresql.jdbc.PgStatement.execute(
> PgStatement.java:354)
>
> at org.postgresql.jdbc.PgStatement.executeWithFlags(
> PgStatement.java:301)
>
> at org.postgresql.jdbc.PgStatement.executeCachedSql(
> PgStatement.java:287)
>
> at org.postgresql.jdbc.PgStatement.executeWithFlags(
> PgStatement.java:264)
>
> at org.postgresql.jdbc.PgStatement.executeQuery(
> PgStatement.java:231)
>
> at com.mchange.v2.c3p0.impl.NewProxyStatement.
> executeQuery(NewProxyStatement.java:327)
>
> at org.springframework.jdbc.core.JdbcTemplate$
> 1QueryStatementCallback.doInStatement(JdbcTemplate.java:458)
>
> at org.springframework.jdbc.core.JdbcTemplate.execute(
> JdbcTemplate.java:408)
>
> ... 18 more
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Storing files in the DHIS2

[Lars Helge Øverland]

Hi Pepe,

you can also configure DHIS 2 to store files on AWS S3 cloud storage. If
cloud is an option and you need to a lot of storage this is usually a
cheaper option. Storing files on the local server file system is the
default behavior. Docs here:

https://docs.dhis2.org/master/en/implementer/html/install_file_store_configuration.html

regards,

Lars



On 22 March 2018 at 08:10, Djibril Dione <djib...@hisp.org> wrote:

> Hi Pepe,
>
> DHIS store by default the file uploaded into to folder under DHIS_HOME(
> usually named DHIS2).
>
> To share these file with other users I don’t advise you to share that
> folder directly but create an automatic copy from this folder to a secure
> FTP where users can access those files.
>
>
>
> Kind regards
>
> Djibril
>
>
>
> *From:* Dhis2-users <dhis2-users-bounces+djibril=h
> isp@lists.launchpad.net> *On Behalf Of *Pepe Ken Mvulu
> *Sent:* Wednesday, 21 March 2018 10:59 AM
> *To:* DHIS 2 developers <dhis2-d...@lists.launchpad.net>; Dhis2-User <
> dhis2-users@lists.launchpad.net>
> *Subject:* [Dhis2-users] Storing files in the DHIS2
>
>
>
> Hi all,
>
> I intend to store files (pdf and jpg) in my online DHIS2 instance. I
> wanted to know the default directory where the value type of the data
> elements "File" in the DHIS2 are stored. Is it possible to find it / Report
> / Resources ??
>
> How to share them with other users
>
> I am using version 2.27
>
> Build: 5c1378d
>
> Every idea is welcomed
>
> Best regard !
>
>
>
> Pepe Ken Mvulu, mph | Consortium Swift Meal
>
> Email: pmato...@oxfam.org.uk | pepeken...@gmail.com
>
> Phone numbers:
>
> Mobile: +243 811 515 878 <0811%20515%20878> / +243 892 489 855
> <0892%20489%20855>
>
> Skype name: pepe.ken.mvulu
>
> *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 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Indicator: Numerator and Denominator objects not found.

[Lars Helge Øverland]

Hi Isaiah,

very likely you have exported and then imported indicators without
including the data elements part of your indicator expressions.

Currently we have a set of options under "metadata export with
dependencies" (see Import-export app), but we don't support indicators with
related metadata yet. It would be good to support that.

I the mean time you need to import your data elements manually as well.

regards,

Lars



On 16 March 2018 at 12:27, Isaiah Nyabuto <isaiahnyab...@gmail.com> wrote:

> Hi David:
>
> Thank you. I can see that. Firstly I discovered that the numerators and
> denominators data elements uids are not existing in my database. Is there a
> way I can filter metadata by the date it was last updated?
>
> Thank you
>
> On Fri, Mar 16, 2018 at 12:23 PM, David Muturi <dnmut...@gmail.com> wrote:
>
>> Hi Isaiah,
>> The uid showing on the screen should be that of the data element (please
>> check that it is correct). Also it should be enclosed in the chars as shown
>> #{uid}.
>> rgds
>> David
>>
>>
>> On Fri, 16 Mar 2018, 08:11 Isaiah Nyabuto, <isaiahnyab...@gmail.com>
>> wrote:
>>
>>> Dear Dhis2 users,
>>>
>>> I recently imported a few indicators using an API.  When I check the
>>> indicator numerator from the maintenance, it shows the data element
>>> description and ID but no valid object found. I suspect this could be a
>>> problem with my metadata version. If so, how do I ensure I get the right
>>> version of data elements metadata?
>>>
>>> Thank you.
>>>
>>>
>>> ==
>>> Isaiah Nyabuto
>>> +254729572616 <+254%20729%20572616>
>>> Bsc. Health Records Management and Informatics
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>
>
> --
> 
> 
> Isaiah Nyabuto
> +254 729 572 616
> Bsc. Health Records Management & Informatics, JKUAT.
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] DHIS 2 on stackexchange

[Lars Helge Øverland]

Hi,

as some of you have noticed we have a *dhis2* tag on the *ProWebmasters*
community on StackExchange. This platform is for Q, meaning concrete
questions with concrete answers (as opposed to e.g. the long conversations
you can find on the mailing lists).

There are currently several open and unanswered questions which you can
find here:

https://webmasters.stackexchange.com/questions/tagged/dhis2

It's much appreciated if anyone would like to contribute by answering
questions.



best regards,

Lars



-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Organisational unit by level via API

[Lars Helge Øverland]

Hi Edward,

yes it is:

https://docs.dhis2.org/master/en/developer/html/webapi_organisation_units.html

https://play.dhis2.org/2.29/api/organisationUnits?level=2

regards,

Lars


On 13 March 2018 at 12:37, Edward Robinson <erobin...@projectbalance.com>
wrote:

> Is there a nice clean way of displaying organisational units by level
> using the API?
>
> Thanks in advance!
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] version 2.29 overview

[Lars Helge Øverland]

Hi,

for those looking for brief overview of the features which went into 2.29
(and found the release notes tl;dr
<https://www.urbandictionary.com/define.php?term=tl%3Bdr>) you can find a
visual summary here:

https://www.dhis2.org/229


regards,

Lars







-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] dhis version 2.29 is released

[Lars Helge Øverland]

*Hi all,DHIS version 2.29 is out with many new features, apps and
improvements.Login with admin/district on the demo
 system to try it out.ANALYTICS
FEATURES---Dashboard app: A new dashboard app is now available which lets
you arrange the dashboard items in a completely flexible way. It features
better dashboard search, allows you to create shortcuts by marking
dashboards as favorites, switch between visualization types such as pivot,
chart and map and insert free-text items. Dashboards can be shared,
translated and filtered.Screenshot 1

| 2

| Demo  | Docs
Maps app: A new
maps app (previously GIS) is available, offering a new, intuitive and
user-friendly interface for creating map layers. It lets you arrange the
order of map layers in a simple way, and view the map data in a data table.
Any number of map layers can be added to a map, even layers of the same
type. The contents and order of map layers can be viewed in the left side
menu.Screenshot 1

| 2

| Demo  | Docs
Last value
aggregation type: A new “last value” aggregation type is available for
aggregate and event analytics for data elements and attributes. This
aggregation type will use the last available value or event in the time
dimension, and either sum or average across other dimensions. This is
useful e.g. for facility surveys to analyse data based on the last
observation, or for “patients currently on care” type of
analysis.Screenshot

| Demo Pivot table
scalability: The pivot table rendering engine is now around 10x more
scalable, and allows for very large pivot tables to be viewed in the web
browser. This is accomplished through progressive rendering, i.e. the
browser will only render what you currently see and not load the entire
pivot table into the browser memory.Demo
Event reports
table layout download: You can now download event reports in Excel or CSV
format in the same tabular format which was rendered in the web
browser.Screenshot
Configurable
financial year in analytics: The starting month of the financial year to
use in all analytics apps can now be configured in the settings app.
Available options are April, July and October.Screenshot

| Demo TRACKER
FEATURES---Data capture and data view sharing levels: The sharing solution
has been extended with two new levels for “data capture” and “data view”
access for users and user groups. These levels apply to programs, program
stages, data sets and category options, and replaces the link between user
roles and data sets/programs. This offers a simplified and more flexible
access control solution.Screenshot

| Docs Tracker
programs in maintenance app: You can now create and modify tracker programs
in the maintenance app. The workflow for creating programs have been made
more intuitive and effective, where stages, sections, data entry forms and
notifications can be created from within the main page.Demo
Integrated
search and registration: The steps for searching and registering new
tracked entities are now integrated. When registering a new tracked entity
instance, the registration form will automatically search for possible
duplicates and alert the user in case of suspected duplicates. When a
search comes back with no hits, the searched values are carried over to the
registration form. Screenshot

| Docs
Improved
configurability and security in searches: Search authorization can now be
granted to users at any location in the 

Re: [Dhis2-users] Push analysis causes analytics to fail

[Lars Helge Øverland]

Hi Elmarie,

I don't think this is related to push analysis. I think this issue has been
fixed. Can you please updated to the latest 2.28 build and try again.

regards,

Lars



On 1 March 2018 at 17:00, Elmarie Claasen <elma...@hisp.org> wrote:

> Hi all,
>
>
>
> We have been testing push analysis and set up one push analysis of a
> dashboard to a usergroup but it causes analytics to fail with the following
> message.
>
> The instance is on 2.28.
>
> We unable to test on Sierra Leone to replicate.
>
>
>
> The log file shows the following error:
>
>
>
> * ERROR 2018-01-31 13:45:32,397 Unexpected error occurred in scheduled
> task. (TaskUtils.java [taskScheduler-16])
>
> java.lang.NullPointerException
>
> ERROR 2018-01-31 13:45:32,397 Unexpected error occurred in scheduled task.
> (TaskUtils.java [taskScheduler-16])
>
> java.lang.NullPointerException
>
> at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(
> ConcurrentUtils.java:53)
>
> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.
> applyAggregationLevels(DefaultAnalyticsTableService.java:242)
>
> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.
> update(DefaultAnalyticsTableService.java:137)
>
> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator
> .generateTables(DefaultAnalyticsTableGenerator.java:112)
>
> at org.hisp.dhis.webapi.controller.ResourceTableController.
> lambda$analytics$0(ResourceTableController.java:112)
>
> at org.springframework.scheduling.support.
> DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
> e.java:54)
>
> at java.util.concurrent.Executors$RunnableAdapter.
> call(Executors.java:511)
>
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1149)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:624)
>
> at java.lang.Thread.run(Thread.java:748)
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: 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 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] Error editing Dataset

[Lars Helge Øverland]

Hi Barnabas,

please have a look at guidelines for reporting problems and tell us your
DHIS 2 version:

https://docs.dhis2.org/2.27/en/implementer/html/ch09s03.html

regards,

Lars


On 22 February 2018 at 10:51, Barnabas Akumba <akumbaba...@gmail.com> wrote:

> Hello All,
>
> Has anyone come across this issue before?
> I'm trying to edit Datasets using the maintenance app by selecting the
> edit option.
> The dataset fails to load but gives me an error "Can not add a model
> without id to a ModelCollection" - See attached snip.
>
> Any suggestion on how to sort this out will be appreciated.
>
> Regards
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778 <+234%20803%20619%205778>
> *Skype:* barnabas.akumba
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Error importing tracker events data

[Lars Helge Øverland]

Hi Hakim,

this feedback indicates that some of your events are referring to a tracked
entity instance (e.g. person) that does not exist in your destination
system, with the identifier Ug2TixCkiAy.

regards,

Lars


On 21 February 2018 at 11:54, DJIBRIL Hakim <djib.ha...@gmail.com> wrote:

> Hi all
> Please Can I have help on this
>
> I am trying export event data from DHIS2 instance to another Instance.
> I have the same program on both instances. But got error this error
>
> TypeNombre
> Imported 0
> updated 0
> Ignored 1ErrorEvent.trackedEntityInstance does not point to a valid
> tracked entity instance: Ug2TixCkiAy
>
> What can be the issue
> Best
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] link to App store

[Lars Helge Øverland]

Thanks. Link updated now.

regards,

Lars

On 19 February 2018 at 13:05, Isaiah Nyabuto <isaiahnyab...@gmail.com>
wrote:

> Thank you.
>
> I was using this link; https://www.dhis2.org/appstore that I got from
> https://www.dhis2.org/how-to-create-find-install-apps
>
> Thank you
>
> On Mon, Feb 19, 2018 at 2:59 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi Isaish,
>>
>> where do you get that error? The app store is found here:
>>
>> https://play.dhis2.org/appstore/
>>
>> regards,
>>
>> Lars
>>
>>
>> On 19 February 2018 at 12:25, Isaiah Nyabuto <isaiahnyab...@gmail.com>
>> wrote:
>>
>>> Dear Dhis2 community,
>>>
>>> Where can I find the link to the app store? I get page not found.
>>>
>>> Thank you.
>>>
>>> --
>>> 
>>> 
>>> Isaiah Nyabuto
>>> +254 729 572 616
>>> Bsc. Health Records Management & Informatics, JKUAT.
>>>
>>> _______
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>
>
> --
> 
> 
> Isaiah Nyabuto
> +254 729 572 616
> Bsc. Health Records Management & Informatics, JKUAT.
>



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

Re: [Dhis2-users] [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

[Lars Helge Øverland]

HI Aaron,

that sounds good, glad to hear you got cross-stage calculations to work.

Unfortunately program indicator expressions do not support nested
parentheses/functions - we plan to develop a new version of our program
indicator parser which will be more flexible in this regard.

regards,

Lars


On 13 February 2018 at 20:56, Aaron C White <aaroncwh...@gmail.com> wrote:

> Thanks, Lars and Preeti.  I checked the indicator formulation and found a
> problem with a d2:condition() statement using a text option set value.  I
> converted it to an integer and was able to see the calculated data across
> stages.  I think it might be related to the parentheses issue inside the
> condition as a few other recent emails have suggested.  How should the
> condition be formulated if you also need to check a text option inside that
> condition?  Using double quotes on the outside of the formulation does not
> seem to work properly.  i.e. d2:condition("my_de == '3'", true, false)
>
> Aaron
>
>
> --
> Aaron C. White
> 919.522.5585
>
> On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi Aaron,
>>
>> from your description I think enrollment type program indicators will be
>> appropriate. Can you tell us a bit more about your usecase? I am assuming
>> you want information from two different stages in the *same* program. Do
>> you have multiple enrollments per person (TEI) in your program? If not I
>> think enrollment indicators will do the job.
>>
>> regards,
>>
>> Lars
>>
>>
>> On 8 February 2018 at 21:49, Aaron C White <aaroncwh...@gmail.com> wrote:
>>
>>> Hi all,
>>>
>>> I'm trying to create a program indicator (or just query to the API
>>> directly) that evaluates conditions on data elements from two different
>>> event stages and then be used to find a relevant tracked entity attribute.
>>>
>>> From the docs, it seems that a program indicator type of enrollment
>>> would be most appropriate, but this only works at the aggregate level and
>>> not at an individual tracked entity instance level.  When I use an event
>>> type indicator, I don't receive any values back because the indicator
>>> definition contains data from two stages.
>>>
>>> Am I correct in this assessment?  Any thoughts on how to get around this?
>>>
>>> I've been testing on a v2.28 instance.  A similar reference example from
>>> the demo server would be the "Weight gain(in g) between birth and last
>>> postnatal for Child Programme" program indicator.  The one change would be
>>> that I want to see the weight gain for individual TEIs and view a TEA based
>>> on the weight gain amount instead of the average over all tracked entity
>>> instances.
>>>
>>> Thanks in advance,
>>>
>>> Aaron
>>>
>>> --
>>> Aaron C. White
>>> 919.522.5585 <(919)%20522-5585>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>


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

[Dhis2-users] DHIS 2 Symposium - Register now!

[Lars Helge Øverland]

Hi all,

we are gearing up for the biggest DHIS 2 event of the year, happening in
just a few weeks on March 22nd and 23rd in Washington, DC. If you haven't
registered
<https://www.eventbrite.com/e/dhis-2-symposium-tickets-37884093343> yet,
don't wait, as tickets are limited, and we have sold out every year.

This year we have an exciting lineup of nearly 30 speakers across a variety
of organizations, experiences and technical expertise on the agenda. You
can see speakers, sessions and who's attending here
<https://dhis2symposium2018.sched.com/>. As we confirm additional speakers
we will update the agenda.

We've added more breakout sessions so that we touch on a variety of
different topics from technical to implementation. Don't miss this
opportunity to learn about the latest and greatest news in the DHIS 2
community.  We look forward to seeing you there!

Register here
<https://www.eventbrite.com/e/dhis-2-symposium-tickets-37884093343>!


regards,

Lars



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

Re: [Dhis2-users] [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

[Lars Helge Øverland]

Hi Aaron,

from your description I think enrollment type program indicators will be
appropriate. Can you tell us a bit more about your usecase? I am assuming
you want information from two different stages in the *same* program. Do
you have multiple enrollments per person (TEI) in your program? If not I
think enrollment indicators will do the job.

regards,

Lars


On 8 February 2018 at 21:49, Aaron C White <aaroncwh...@gmail.com> wrote:

> Hi all,
>
> I'm trying to create a program indicator (or just query to the API
> directly) that evaluates conditions on data elements from two different
> event stages and then be used to find a relevant tracked entity attribute.
>
> From the docs, it seems that a program indicator type of enrollment would
> be most appropriate, but this only works at the aggregate level and not at
> an individual tracked entity instance level.  When I use an event type
> indicator, I don't receive any values back because the indicator definition
> contains data from two stages.
>
> Am I correct in this assessment?  Any thoughts on how to get around this?
>
> I've been testing on a v2.28 instance.  A similar reference example from
> the demo server would be the "Weight gain(in g) between birth and last
> postnatal for Child Programme" program indicator.  The one change would be
> that I want to see the weight gain for individual TEIs and view a TEA based
> on the weight gain amount instead of the average over all tracked entity
> instances.
>
> Thanks in advance,
>
> Aaron
>
> --
> Aaron C. White
> 919.522.5585
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Custom forms - disable / enable sections

[Lars Helge Øverland]

Hi Edward,

this is a popular request; unfortunately we do not have a specific feature
for this.

One option is to come up with a few facility "profiles" and create new data
sets for each, while re-using *the same* data elements within the data
sets, then assigning the data sets to the org units accordingly.

We are getting requests for several variants of this feature:

a) assigning data elements to facilities directly
b) assigning sections to facilities directly
c) assigning data elements to org unit groups within a group set
c) assigning sections to org unit groups within a group set

I assume your request is similar to d)? Would be good if you can explain a
bit more about your usecase.

best regards,

Lars




On 10 February 2018 at 00:02, Edward Robinson <erobin...@projectbalance.com>
wrote:

> Is it possible to hide or show certain sections (tabs) of custom forms by
> facility based on some facility property?  We are trying to avoid having
> multiple forms for various services and present them on a single page with
> multiple tabs if possible, but we want to be able to hide tabs that are
> irrelevant for certain facilities.
>
> Thanks in advance for any ideas!
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Possibility of creating non numerical UID prefixes in tracker capture

[Lars Helge Øverland]

Hi Aimee,

Isaiah is right re the UID format and you can find the docs here:

https://docs.dhis2.org/master/en/developer/html/webapi_system_resource.html#d0e11354

Note that the number of possible UID combinations are 5.2 x 10^19, or about
50 million trillion, so I would perhaps rather focus on generating properly
randomized UIDs and not worry so much about collisions.

best regards,

Lars







On 9 February 2018 at 02:17, Isaiah Nyabuto <isaiahnyab...@gmail.com> wrote:

> Hi Aimee,
>
> What is the length of the UIDs? The dhis2 accepts UID length of 11 and can
> accept any other types (letters and numbers) so long as the first one is a
> letter.
>
> If you want to avoid duplication of UID, the easiest way is by generating
> them yourself using other tools or languages.
> See the following example on UID generation.
> https://github.com/jason-p-pickering/dhis2-data-munging/
> blob/master/bootstrap/bootstrap.Rmd
>
> Thank you.
> ==
> Isaiah Nyabuto
> +254729572616 <+254%20729%20572616>
> Bsc. Health Records Management and Informatics
>
>
> On Feb 8, 2018 16:32, "Aimee Edmondo" <aedmo...@akros.com> wrote:
>
> Greetings all,
> In Zambia we are investigating the possibility of having sub instances of
> tracker capture that feed into a main instance, but we want to avoid the
> issue of duplicate UIDs coming from the sub instances. We were hoping to
> add a prefix onto the automatic UID generation - such as NG###, where
> the prefix "NG" remains consistent and the numbers are automatically
> generated. We've experimented with the UID options and the system does not
> accept this pattern. Has anyone successfully done this before or have any
> ideas as to how to do this?
> Thanks,
> *Aimee Edmondo, MPH* | Informatics Associate
> aedmo...@akros.com <acmar...@akros.com> | +260.976.076524
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] coordinates not found

[Lars Helge Øverland]

Hi Natalia,

in addition to Patrick's comments, it is useful to have a look in the
organisationunit table in your database and see what actually got imported,
e.g. with this SQL:

select uid,name,coordinates from organisationunit;

The points should look something like this:

[-12.66,9.38]

best,

Lars



On 9 February 2018 at 03:41, Patrick Albert Chikumba <pchiku...@poly.ac.mw>
wrote:

> Hi Natalie
>
> To which organization units have you imported coordinates? and which ones
> are you trying to access in GIS module?
>
> In other words, describe what you have done. May be you are missing
> something. Or give example.
>
>
>
> On Thu, Feb 8, 2018 at 6:57 PM, Natalie Tibbels <ntibb...@jhu.edu> wrote:
>
>> ​Hi all,
>>
>> Trying to set up GIS in my DHIS2 instance. The GML import is successful,
>> but then when I try to add the layer in GIS, it says "valid coordinates not
>> found". Any ideas of what to check?
>>
>> Thanks,
>>
>> Natalie
>>
>>
>>
>> ---
>> *Natalie Tibbels, MSPH*
>> Senior Research Assistant
>> 410.370.5048 (cell) • natalietib (Skype)
>>
>> Johns Hopkins Bloomberg School of Public Health
>> Center for Communication Programs • ccp.jhu.edu
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Patrick Albert Chikumba
> Computing & IT Department - The Malawi Polytechnic
> +265 885 123 533, patrick_chiku...@yahoo.com
> 
> PhD Student
> University of Oslo - Dept. of Informatics
> OSLO, Norway
> Cell: +47 9575 4367
> Email: patr...@ifi.uio.no
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] Data not showing up in Reports and Pivot Tables

[Lars Helge Øverland]

Hi Stanley,

did you go to reports app > analytics and generate the analytics tables
after you entered data?

Lars

On 26 January 2018 at 11:01, Stanley Kalyati <skaly...@gmail.com> wrote:

> Hi all,
>
> I am using DHIS2 2.26 build version f2dd151.
>
> I have created everything right but i cant seem to know where i am missing
> it.One of the data set is able to display data in the pivot tables but
> others are not able to though data is there on the form.
>
> Has anyone faced such an issue and how did you deal with it.
>
> Thank you in advance.
>
> Stanley
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-users] dhis 2 symposium agenda shaping up

[Lars Helge Øverland]

Hi all,

The 2018 DHIS 2 Symposium agenda is starting to shape up. We have confirmed
speakers from WHO, MSF, University of Oslo, MSH and PEPFAR.

This year we are using Sched – the online agenda management platform to
manage the agenda and speaker list. As we confirm additional speakers we
will update the agenda here <https://dhis2symposium2018.sched.com/>. We are
adding more breakout sessions so that we touch on a variety of different
topics from technical to implementation.

Read more here!
<http://mailchi.mp/611ca9119966/dhis-2-symposium-agenda?e=e7f28d869d>


The symposium takes place on March 22nd and 23rd, FHI 360 Conference Center
in Washington D.C, USA. We look forward to seeing you there!


regards,

Lars




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

Re: [Dhis2-users] [Dhis2-devs] Program objects do not have the code attribute

[Lars Helge Øverland]

Hi Petar,

good catch, it should have been there. We will add a code field to the
program maintenance app. Could you please register an issue in Jira

regards,

Lars

On 19 January 2018 at 10:34, Petar Jovanovic <pe...@essi.upc.edu> wrote:

> Hi,
>
> We have noticed (v2.27, build: 774be18), but also in the v2.28 demo, that
> the program metadata object does not have the code attribute. It cannot be
> set through interface, and neither can be retrieved through API. I do,
> however, see it in the program database table.
>
> Is there any specific reason why this attribute is not available though
> API?
>
>
> Thank you!
>
>
> Best,
> Petar
>
>  _
> Petar Jovanovic
> Department of Service and Information System Engineering (ESSI)
> Universitat Politècnica de Catalunya, BarcelonaTech
> Barcelona, Spain
> _ http://www.essi.upc.edu/~petar/ ___
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



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

Re: [Dhis2-users] [Dhis2-devs] download URLs

[Lars Helge Øverland]

Hi Jason,

sorry we weren't planning on that, as we are trying to automate and
simplify the release process. Now that we are on S3 we do not plan to
change these URLs going forward.

For those building tools, one option would be to set up your own DNS
records which you could control and point to the appropriate locations.

Lars



On 16 January 2018 at 17:26, Jason Pickering <jason.p.picker...@gmail.com>
wrote:

> Anyway to put in a redirect so that the old URLs will stilll work?
>
> On Tue, Jan 16, 2018 at 11:14 AM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi,
>>
>> we have moved download artefacts to AWS S3 and hence the direct download
>> links have changed. You can find the WAR file downloads at the following
>> URLs:
>>
>> https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.28/dhis.war
>> https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.27/dhis.war
>> https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.26/dhis.war
>>
>> Just letting you know in case there are any scripts or tools out there
>> which depend on the URLs.
>>
>>
>> You can find the SQL sample database dumps at the following URLs:
>>
>> https://s3-eu-west-1.amazonaws.com/databases.dhis2.org/
>> sierra-leone/2.28/dhis2-db-sierra-leone.sql.gz
>> https://s3-eu-west-1.amazonaws.com/databases.dhis2.org/
>> sierra-leone/2.27/dhis2-db-sierra-leone.sql.gz
>> https://s3-eu-west-1.amazonaws.com/databases.dhis2.org/
>> sierra-leone/2.26/dhis2-db-sierra-leone.sql.gz
>>
>> The sample databases no longer includes the analytics tables so you will
>> have to generate them yourself using DHIS 2 (this is faster than restoring
>> with postgres and reduces the download size).
>>
>> regards,
>>
>> Lars
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@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 <+46%2076%20414%2070%2049>
>



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

[Dhis2-users] download URLs

[Lars Helge Øverland]

Hi,

we have moved download artefacts to AWS S3 and hence the direct download
links have changed. You can find the WAR file downloads at the following
URLs:

https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.28/dhis.war
https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.27/dhis.war
https://s3-eu-west-1.amazonaws.com/releases.dhis2.org/2.26/dhis.war

Just letting you know in case there are any scripts or tools out there
which depend on the URLs.


You can find the SQL sample database dumps at the following URLs:

https://s3-eu-west-1.amazonaws.com/databases.dhis2.org/sierra-leone/2.28/dhis2-db-sierra-leone.sql.gz
https://s3-eu-west-1.amazonaws.com/databases.dhis2.org/sierra-leone/2.27/dhis2-db-sierra-leone.sql.gz
https://s3-eu-west-1.amazonaws.com/databases.dhis2.org/sierra-leone/2.26/dhis2-db-sierra-leone.sql.gz

The sample databases no longer includes the analytics tables so you will
have to generate them yourself using DHIS 2 (this is faster than restoring
with postgres and reduces the download size).

regards,

Lars



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

[Dhis2-users] stable release demo versions available

[Lars Helge Øverland]

Hi,

we have made the stable releases available on play.dhis2.org. You can now
access previous releases by appending the versions to the play URLs like
this:

https://play.dhis2.org/2.28
https://play.dhis2.org/2.27
https://play.dhis2.org/2.26
https://play.dhis2.org/2.25


This can be useful e.g. in order to test features and triage bugs.

regards,

Lars




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

Re: [Dhis2-users] Issue with Maintenance app

[Lars Helge Øverland]

Hi Aljosa,

can you check that your user has the "ALL" authority (from User app), and
if not add it to one of your user roles? Then try again.

best,

Lars


On 11 January 2018 at 16:05, Aljosa Celebic <aljosa.cele...@lih.lu> wrote:

> Hi, When I open Maintenance app I’m supposed to find Data Elements,
> Organisation Unit building tools… but the only thing that appear is
> Metadata group editor.
>
> Have I missed something before starting to create the entry forms for my
> new project?
>
> Thank you for your help. Kind regards.
>
> AC
>
> Aljosa Celebic
> Data Manager, Competence Center for Methodology and Statistics
>
> *Luxembourg Institute of Health*
> General Management
> 1A-B, rue Thomas Edison, L-1445 Strassen
> Luxembourg
> Tel: +352 26970-399 <+352%2026%2097%2003%2099>
> Fax: +352 26970-719 <+352%2026%2097%2007%2019>
> Email: aljosa.cele...@lih.lu
> Website: https://www.lih.lu
>
>
>
>
> Join us on Facebook and follow our activities on Twitter:
> https://www.facebook.com/Luxembourg.Institute.of.Health
> http://twitter.com/LIH_Luxembourg
> aljosa.cele...@lih.lu
>
> This message (including any attachments) is intended for the addressee
> only and may contain confidential and/or privileged information and/or
> information protected by intellectual property rights. If you have received
> this message  by mistake, please notify the sender by return e-mail and
> delete this message from your system. You should not use, alter, copy or
> distribute this message or disclose its contents to anyone. E-mail
> transmission can not be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
> or incomplete, or contain viruses. Luxembourg Institute of Health shall not
> be responsible nor liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt or damage to your system.
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-users] DHIS 2 Symposium 2018 registration now open

[Lars Helge Øverland]

Hi all,

The annual DHIS 2 Symposium will be held on *March 22nd and 23rd*, 2018 at
the *FHI 360 Conference Center* in Washington, D.C.

The global digital health space is moving at a rapid pace, making
exponential gains within the last few years. After less than 10 years of
development, DHIS 2 is being implemented in more than 60 countries, with
almost 30 operating at national scale. This rapid global expansion of DHIS
2 has led to exciting collaborations and partnerships targeted at improving
LMIC health systems.

In the 4th DHIS 2 Symposium we’ll look at how international partnerships
between NGOs and governments are supporting national system strengthening,
ultimately improving the use of DHIS 2 and bringing us closer to
harmonization of data.

Android mobile applications will be examined and we will hear from the
University of Oslo about efforts to overhaul and re-develop the
applications. Biometrics are making concrete gains in development work and
we’ll hear how it can be incorporated into DHIS 2.

Other topics to be explored include:

- What work is being done around DHIS 2 for the Sustainable Development
Goals and how that work can be moved forward.

- How data is used in concrete ways to drive decision-making,
course-correction and improve impact of your programs.

- How integration with other systems like LMIS and EMRs improve national
systems.

Get your tickets here:


https://www.eventbrite.com/e/dhis-2-symposium-tickets-37884093343?aff=ehomecard


*Are you interested in presenting?* Send an abstract (max 2 pages) to
dhis2sympos...@baosystems.com. Abstracts are due by January 12th.

Want to showcase or demo your product or project? See the vendor ticket

description for more information.

If you have any questions please send them to here
.


best regards,

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

Re: [Dhis2-users] Program stages access

[Lars Helge Øverland]

Hi Julie,

it's a good question and unfortunately you cannot have this level of access
control per today. However the good news is that we plan to support this in
version 2.29 (Feb 1) by introducing a new level of sharing
<https://docs.dhis2.org/master/en/user/html/sharing.html> access called
"Data input". Stay tuned.

regards,

Lars


On 8 December 2017 at 11:01, Julie Vanhamme <juvha...@gmail.com> wrote:

> Hi All,
>
> I configured a program (Event) with three different stage. I have
> different types of users and some of them can only access one stage and not
> the other ones.
>
> How can I limit the access to some of my stages to some users/user roles?
>
> Many thanks
>
> Julie
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Skinning no longer working?

[Lars Helge Øverland]

Hi,

yes it seems this ability to change colors did not make it into the new
header bar component. I am not sure if we want to carry this option
forward, people could instead rely on the web API based UI customization:

https://docs.dhis2.org/master/en/developer/html/webapi_ui_customization.html


Lars


On 7 December 2017 at 16:49, Timothy Harding <thard...@baosystems.com>
wrote:

> Hello Knut!
>
> I too am unable to affect the appearance, but in my testing it is more
> about specific apps. I filed a bug report about this and I invite you to
> take a look: https://jira.dhis2.org/browse/DHIS2-1299
>
>
> *Timothy Harding*
> Sr. Systems Analyst, BAO Systems
> +1 202-536-1541 | thard...@baosystems.com | http://www.baosystems.com | Skype:
> hardi...@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007
>
> On Thu, Dec 7, 2017 at 9:05 AM, Knut Staring <knu...@gmail.com> wrote:
>
>> Trying to select a different style under System settings -> Appearance,
>> selecting a different style seems to have no effect in the online demo?
>>
>> --
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
>> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
>> Skype: knutstar
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Update Category option combination

[Lars Helge Øverland]

For data entry module, you might have to clean your browser cache
<https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache>.

regards,

Lars


On 25 November 2017 at 08:52, Djibril Dione <djib...@hisp.org> wrote:

> Hi Lars,
> I did perform Update category option combinations as decrypt on my email
> but there was no change in the name.
> similarly, I renamed the category option *"Improve Access to Improve
> access to clean water" *on Sierra Leon demo 2.27. but no change after
> performing maintenance.
>
> On Fri, Nov 24, 2017 at 11:28 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi there,
>>
>> try going to data administration app > maintenance > select "Update
>> category option combinations"  and click "perform maintenance".
>>
>> regards,
>>
>> Lars
>>
>>
>> On 24 November 2017 at 15:01, Djibril Dione <djib...@hisp.org> wrote:
>>
>>> Dear DHIS2 community,
>>> We are setting up an aggregated system using Attribute option as part of
>>> the disaggregation. Some of the category option names were not correct and
>>> we have renamed them.
>>>
>>> Now after updating the category option combination through data
>>> administration/Maintenance, the old combination name is still appearing on
>>> the category option combinations on the frontend and at the backend.
>>>
>>> we have renamed some attribute option on Sierra Leon Demo 2.27 and still
>>> found the same issue.
>>>
>>> Is there anyone experiencing the same issue.
>>>
>>> we are using version 2.27 build:5c148f4
>>>
>>> --
>>>
>>> Kind Regards
>>>
>>>
>>> Djibril Dione
>>>
>>> Database Specialist
>>>
>>> Health Information Systems Program – SA
>>>
>>> Cell: +27 71 711 5421 <+27%2071%20711%205421>
>>>
>>> Skype: dione.djibril
>>>
>>> Address: 66 Rigel Ave North, Waterkloof Ridge, Pretoria, 0181
>>> <https://maps.google.com/?q=66+Rigel+Ave+North,+Waterkloof+Ridge,+Pretoria,+0181=gmail=g>
>>> Web: www.hisp.org
>>> NPR Reg No: 2003/005786/08
>>>
>>> *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 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-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>
>
> --
>
> Kind Regards
>
>
> Djibril Dione
>
> Database Specialist
>
> Health Information Systems Program – SA
>
> Cell: +27 71 711 5421 <+27%2071%20711%205421>
>
> Skype: dione.djibril
>
> Address: 66 Rigel Ave North, Waterkloof Ridge, Pretoria, 0181
> <https://maps.google.com/?q=66+Rigel+Ave+North,+Waterkloof+Ridge,+Pretoria,+0181=gmail=g>
> Web: www.hisp.org
> NPR Reg No: 2003/005786/08
>
> *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 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.*
>



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

Re: [Dhis2-users] Update Category option combination

[Lars Helge Øverland]

Hi there,

try going to data administration app > maintenance > select "Update
category option combinations"  and click "perform maintenance".

regards,

Lars


On 24 November 2017 at 15:01, Djibril Dione <djib...@hisp.org> wrote:

> Dear DHIS2 community,
> We are setting up an aggregated system using Attribute option as part of
> the disaggregation. Some of the category option names were not correct and
> we have renamed them.
>
> Now after updating the category option combination through data
> administration/Maintenance, the old combination name is still appearing on
> the category option combinations on the frontend and at the backend.
>
> we have renamed some attribute option on Sierra Leon Demo 2.27 and still
> found the same issue.
>
> Is there anyone experiencing the same issue.
>
> we are using version 2.27 build:5c148f4
>
> --
>
> Kind Regards
>
>
> Djibril Dione
>
> Database Specialist
>
> Health Information Systems Program – SA
>
> Cell: +27 71 711 5421 <+27%2071%20711%205421>
>
> Skype: dione.djibril
>
> Address: 66 Rigel Ave North, Waterkloof Ridge, Pretoria, 0181
> Web: www.hisp.org
> NPR Reg No: 2003/005786/08
>
> *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 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] DHIS 2, PostgreSQL only

[Lars Helge Øverland]

Yes. The datavalue table is definitely a good candidate for partitioning.



On Thu, Nov 9, 2017 at 5:53 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Very good Lars!  Looking at the move to postgresql 10 (presumably one
> or two more versions down the line), have you been considering the
> native partitioning support for dealing with huge datavalue tables?
> This looks like it might be very suited to our classic problem of
> large amounts of historic data..
>
> On 9 November 2017 at 20:47, Lars Helge Øverland <l...@dhis2.org> wrote:
> >
> >
> > On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knu...@gmail.com> wrote:
> >>
> >> Good decision. I assume this means H2 will also no longer be a fallback?
> >> So dhis2 live will also require PG?
> >>
> >
> > We will continue to use H2 for internal purposes (unit testing) for a
> while,
> > and the system will still start and mostly work on H2. However there will
> > gradually be more features requiring PostgreSQL, and we hope to replace
> Live
> > with a Docker image in near future.
> >
> > As part of the move to PostgreSQL we will also require the PostGIS
> > extension.
> >
> >
> >
> > Lars
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > l...@dhis2.org
> > http://www.dhis2.org
> >
> >
> > _______
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to : dhis2-d...@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>



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

Re: [Dhis2-users] [Dhis2-devs] DHIS 2, PostgreSQL only

[Lars Helge Øverland]

On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knu...@gmail.com> wrote:

> Good decision. I assume this means H2 will also no longer be a fallback?
> So dhis2 live will also require PG?
>
>
We will continue to use H2 for internal purposes (unit testing) for a
while, and the system will still start and mostly work on H2. However there
will gradually be more features requiring PostgreSQL, and we hope to
replace Live with a Docker image in near future.

As part of the move to PostgreSQL we will also require the PostGIS
extension.



Lars



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

[Dhis2-users] DHIS 2, PostgreSQL only

[Lars Helge Øverland]

Hi all,

after gathering feedback from the community we have decided to support
PostgreSQL only as database platform for DHIS 2 starting from version 2.29
(i.e. the next release).

This will allow us to utilize some of the sophisticated features specific
to PostgreSQL in order to make a better system. As example, this will help
us to improve the analytics and data import/export functionality.

The minimum version required will be PostgreSQL version 9.0. We do however
recommend migrating to PostgreSQL 10 as it provides performance
improvements and new features which may be utilized in near-future DHIS 2
releases.

best regards,

Lars


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

Re: [Dhis2-users] [WISCENTDs] : Logical indicators

[Lars Helge Øverland]

Hi Lise,

currently I think your best option is to create an org unit group set, with
groups for endemic/not endemic, then classify your org units accordingly.
The downside is that it does not provide a time dimension/ability to keep
changes in status.

This is a popular requirement and something we probably should support in a
better way.

regards,

Lars



On Tue, Oct 24, 2017 at 12:40 PM, GROUT, Lise <gro...@who.int> wrote:

> Dear all,
>
>
>
> I have one DataElement in a DataSet which is the population, and another
> DE in a Program which is the endemicity of a disease (Yes/No).
>
>
>
> I would like to calculate an indicator which is the population at risk,
> i.e. the population living in an org unit where endemicity is “Yes”.
>
>
>
> Is there a way of programming this kind of indicator?
>
>
>
> Thanks
>
> Lise.
>
>
>
> Dr. Lise Grout
>
> *Epidemiologist*
>
>
>
> *World Health Organization*
>
> *Department of Neglected Tropical Diseases (HTM/NTD/IDM)*
> *Innovative and Intensified Disease Management Unit*
> *20, Avenue Appia; CH-1211 Geneva 27*
> *Tel. **+41 22 791 2341 <+41%2022%20791%2023%2041>*
>
> *Mobile +41 79 290 68 61 <+41%2079%20290%2068%2061>*
>
> *Skype: tigrouveto*
>
> http://www.who.int/neglected_diseases
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] financial year reporting

[Lars Helge Øverland]

Hi Adam,

does the "Total births" data element has an average aggregation type? If
so, I just provided a fix in master and 2.28, and I recommend that you
upgrade and try again.

best,

Lars


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

[Dhis2-users] dhis version 2.28 is out

[Lars Helge Øverland]

Hi all,

DHIS version 2.28 is out. This version includes a range of improvements and
stability enhancements.

Log in with admin/district on the demo  system.


ANALYTICS FEATURES

---

Measure criteria support in pivot tables: Pivot table app now supports
measure criteria, meaning criteria to apply to the data being returned,
such as a min and max value. Can be enabled in the Options dialog.

Demo  |
Screenshot



Multiple regression types in charts: Data visualizer and event visualizer
apps now supports a new option for linear, polynomial and loess regression
types (trend lines). Can be enabled in the Options dialog.

Demo 1  | 2
 | Screenshot
1

| 2



Remove gaps in bar/column charts: Data visualizer and event visualizer apps
now support an option for displaying bar/column charts without gaps between
the bars/columns. Can be enabled in the Options dialog.

Demo  |
Screenshot



Daily relative periods in event analytics: Various daily relative periods
are now supported in event reports and event visualizer.

Demo  |
Screenshot



Share favorites with users: Analytics favorites can now be shared with
individual users in addition to user groups. This is useful for more
flexible sharing and removes the need for always creating a group. Click
*Share* from the *Favorites* menu.

Demo

| Screenshot



Favorite filter for “Created by me”: You can now easily filter your
favorites with the new “Created by me”/”Created by others” filter,
available in all the analytics apps.

Demo  |
Screenshot



Sort favorites by created and last updated: Analytics favorites can now be
sorted by the date they were created and the date they were last updated.

Demo

| Screenshot



Combine totals and details in pivots: Total values and details (operands)
can now be combined in pivot tables and charts.

Demo  |
Screenshot



Indicator totals in pivots: The pivot table app now calculates total and
subtotal values in a better way, dividing the sum of numerator values with
the sum of denominator values multiplied by the average of indicator
factors.

Demo  |
Screenshot




TRACKER FEATURES

---

Compare to previous event during data entry: You can now choose to compare
the current data entry for an event with previously completed events. This
option is available when doing data entry for a new event in tracker
capture.

Demo  |
Docs



Tracker and event capture with time, datetime and URL value types: Tracker
and event capture apps now support the “Time”, “Datetime” and “URL” data
element value types.

Demo 



GENERAL FEATURES

---

Persist validation results: Validation results (violations) can now be
persisted. You can also access validation results in the analytics API,
meaning counts of validation violations.

Screenshot

| Docs



Skip form validation for validation 

Re: [Dhis2-users] postgresql 10 released

[Lars Helge Øverland]

Hi,

postgres 10 is out:

https://www.postgresql.org/about/news/1786/

Hint: we plan to leverage some of the new postgres 10 features in DHIS 2
and so planning to upgrade may be a good idea.

regards,

Lars



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

[Dhis2-users] postgresql 10 released

[Lars Helge Øverland]

Hi,

postgres

https://www.postgresql.org/about/news/1786/




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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Lars Helge Øverland]

Thanks all for the feedback on this issue!

regards,

Lars


On Fri, Sep 8, 2017 at 1:19 PM, Hannan Khan <hann...@gmail.com> wrote:

> Hi Lars
>
> Fully agreed. To concentrate one one DB platforms will not only saves time
> and effort, also being efficiency to the system and can make more use of
> advance functionality of the PostgreSQL & PostGIS.
>
> You will have our full support.
>
> Hannan
>
> On Fri, Sep 8, 2017 at 2:26 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi all,
>>
>> I want to bring up the idea of solely support PostgreSQL for DHIS 2 for
>> production use to get feedback from the community.
>>
>> The DHIS 2 team is seeing clear benefits of moving to PostgreSQL-only.
>> The main ones are:
>>
>> 1. Supporting and testing for more than one database platform is
>> time-consuming. The majority of DHIS 2 implementations is using PostgreSQL
>> already.
>>
>> 2. PostgreSQL supports advanced geospatial features through PostGIS. We
>> are already depending on these for the GIS module to work optimally (i.e.
>> for event clustering in GIS). There are no direct equivalent in e.g. MySQL.
>> We are also considering using PostGIS data types in main data model.
>>
>> 3. PostgreSQL will provide some impressive features which will become
>> very useful for us in version 10
>> <https://wiki.postgresql.org/wiki/New_in_postgres_10> and 11. E.g.
>> native partitioning, parallel queries, logical replication, foreign tables
>> and improved query performance will be useful and allow us to develop the
>> next DHIS 2 analytics solution.
>>
>>
>> We are aware this will be inconvenient for users of other databases such
>> as MySQL, but there is the option of migrating your database through the
>> DHIS 2 metadata and data value import-export feature.
>>
>> On a technical note, we will keep the Hibernate development framework and
>> keep supporting the H2 database for unit testing purposes.
>>
>> Please let us know your thoughts on this.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Muhammad Abdul Hannan Khan
> Team Leader
> Support to the National HMIS
> MIS, Director General of Health Service
> Ministry of Health and Family Welfare
>
> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
> <58%2081%2064%2012>
> F +88 02 58813 875
> M+88 01819 239 241
> M+88 01534 312 066
> E hann...@gmail.com
> S hannan.khan.dhaka
> B hannan-tech.blogspot.com
> L https://bd.linkedin.com/in/hannankhan
>
>
>
>


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

Re: [Dhis2-users] DHIS2- Data Types of Data elements

[Lars Helge Øverland]

Hi Omer,

did you look at the "Positive or Zero integer" data element value type?

regards,

Lars


On Wed, Oct 11, 2017 at 12:08 PM, Omer Butt <omerbutt2...@gmail.com> wrote:

> Hi,
>
> Can you please tell me the data type that accept 0 as a first value while
> taking values from user in data entry section.  (other than text data
> type). Because  i want to store integer values that may be start with a 0;
>
> e.g 001001343
>
> Thanks
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Email notifications

[Lars Helge Øverland]

Hi Anna,

okay. Could it be that you have not enabled email notifications? This can
be configured as a system setting, and also be overridden by user specific
settings.

Go Settings app > Messaging and enable email notifications.

Also make sure that your users have not disabled this under Profile > User
settings > email notifications.

regards,

Lars


On Wed, Oct 11, 2017 at 11:57 AM, Anna Mennella <mennella@gmail.com>
wrote:

> Hi there,
>
> I have been trying to send notification emails to some users within my
> team by using the message app; however, I have noticed that any message can
> be read only by logging in into DHIS2 and therefore these emails don't
> reach the email inbox.
> I'm a bit surprised about it as I guess that in some cases the purpose of
> sending notifications/reminders from there is to remind the users to upload
> information and therefore to log in into the system.
>
> Any help?
>
> Thanks
> Anna
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] Bug in option set while cloning

[Lars Helge Øverland]

Hi Seid,

okay that is not good. Can you please report in Jira and share the link.

regards,

Lars


On Fri, Oct 6, 2017 at 10:01 AM, Seid Hussein <seid.h...@gmail.com> wrote:

> Hi all,
>
> We were cloning option sets and it appears that while the new option set
> will get all the options in the original one, the options are removed from
> the old option set.
>
> I have recreated the issue on the demo site as well.
>
> Regards,
>
>
> Seid,
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Check how many time reports are generated

[Lars Helge Øverland]

Hi Martin,

we do have a web API endpoint that supports usage statistics for most
analytical entities (pivot table, chart, map..) _except_ for standard
reports.

https://docs.dhis2.org/master/en/developer/html/webapi_usage_analytics.html

If you want to create a patch and extend this to include standard reports
(html reports) you can look at the following classes:

DataStatistics.java
DataStatisticsEventType.java
DataStatisticsController.java
GetReportAndParamsAction.java


regards,

Lars




On Wed, Oct 4, 2017 at 9:16 AM, Martin Van Aken <mar...@joyouscoding.com>
wrote:

> Hello DHIS2 community,
>
> We have a set of custom reports we built for a customer, and I'm
> interested to follow which one are used (and how often).
>
> Is there any way to retrieve how many times a given report has been
> generated? I'm talking about HTML reports in this case some something like:
>
> http://DHIS2_urL/dhis-web-reporting/generateHtmlReport.
> action?uid=ThScKdiP4Cp=201708=eov2pDYbAK0
>
> Does DHIS2 stores something about it anywhere?
>
> Thanks,
>
> Martin
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-users] DHIS2 Academy, Level 2: Web App Development

[Lars Helge Øverland]

Hi all,


*HISP Tanzania and the University of Oslo are pleased to announce the DHIS2
Academy, Level 2: Web Apps Development to be held November 6 - 10, 2017 at
Ramada Hotel in Dar es salaam, Tanzania.*



This specialization course will teach the basics of DHIS2 Web apps
development and deployment. The Academy focuses on key DHIS2 Web API
features and DHIS2 Apps development concepts and is a hands-on academy
involving development of web apps leveraging the DHIS Web API, Analytics,
D2 javascript services and deployment of apps to app-store.



This is the first time we are holding this Academy. The registration fee is
USD 800,- for 5 days. There will be a strong presence of DHIS 2 core
developers.

Participants are expected to know the basics of Javascript software
development and DHIS 2 concepts.

For more information and registration please visit: https://www.dhis2.org/
webappsacademy2017-home



We are looking forward to seeing you in Dar!



best regards,


Lars




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

[Dhis2-users] DHIS 2 to support PostgreSQL only?

[Lars Helge Øverland]

Hi all,

I want to bring up the idea of solely support PostgreSQL for DHIS 2 for
production use to get feedback from the community.

The DHIS 2 team is seeing clear benefits of moving to PostgreSQL-only. The
main ones are:

1. Supporting and testing for more than one database platform is
time-consuming. The majority of DHIS 2 implementations is using PostgreSQL
already.

2. PostgreSQL supports advanced geospatial features through PostGIS. We are
already depending on these for the GIS module to work optimally (i.e. for
event clustering in GIS). There are no direct equivalent in e.g. MySQL. We
are also considering using PostGIS data types in main data model.

3. PostgreSQL will provide some impressive features which will become very
useful for us in version 10
<https://wiki.postgresql.org/wiki/New_in_postgres_10> and 11. E.g. native
partitioning, parallel queries, logical replication, foreign tables and
improved query performance will be useful and allow us to develop the next
DHIS 2 analytics solution.


We are aware this will be inconvenient for users of other databases such as
MySQL, but there is the option of migrating your database through the DHIS
2 metadata and data value import-export feature.

On a technical note, we will keep the Hibernate development framework and
keep supporting the H2 database for unit testing purposes.

Please let us know your thoughts on this.

regards,

Lars




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

Re: [Dhis2-users] (API) Ordering analytics results

[Lars Helge Øverland]

Hey Martin,

sorry but that is not currently possible. Feel free to write a Jira issue
and we can look into it.

regards,

Lars


On Thu, Aug 10, 2017 at 8:32 PM, Martin Van Aken <mar...@joyouscoding.com>
wrote:

> We want to retreive the 5 entities with the highest values for a given
> period and data element. I can retreive all values easily with an analytics
> call, but is there any way to order the results on the values (I can then
> limit the call to five entities).
>
> I saw example of "order" or "defaultOrder" clauses, but those were all
> related to meta data - in my case I want to order values.
>
> Any help would be most welcome,
>
> Thanks,
>
> Martin
>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Event analytics endpoint broken

[Lars Helge Øverland]

No worries.

Lars

On Thu, Jul 27, 2017 at 6:22 PM, Jesus Solano-Roman <
asol...@broadinstitute.org> wrote:

> Hi Lars.
>
> Thanks for the quick reply. This should fix it, my apologies for not
> reading more carefully.
>
>
>
> *Antonio Solano-Roman*
>
> Data Visualization & User Experience Design
> Sabeti Lab - Broad Institute
>
> On Jul 27 2017, at 12:19 pm, Lars Helge Øverland <l...@dhis2.org> wrote:
>
>> Hi Jesus,
>>
>> the API endpoint should work. There are a few parameters which are
>> mandatory:
>>
>> https://play.dhis2.org/demo/api/26/analytics/events/
>> aggregate/eBAyeGv0exc.json?dimension=ou:ImspTQPwCqd&
>> dimension=pe:LAST_4_QUARTERS=fWIAEtYVEGk&
>> dimension=oZg33kd9taw=Zj7UnCAulEk=
>> SHORTNAME=EVENT=vV9UWAZohSf=AVERAGE
>> <https://play.dhis2.org/demo/api/26/analytics/events/aggregate/eBAyeGv0exc.json?dimension=ou%3AImspTQPwCqd%3Bdimension=pe%3ALAST_4_QUARTERS%3Bdimension=fWIAEtYVEGk%3Bdimension=oZg33kd9taw%3Bstage=Zj7UnCAulEk%3BdisplayProperty=SHORTNAME%3BoutputType=EVENT%3Bvalue=vV9UWAZohSf%3BaggregationType=AVERAGE=lars%40dhis2.org>
>>
>> Have a look at the docs here:
>>
>> https://docs.dhis2.org/master/en/developer/html/webapi_
>> event_analytics.html
>> <https://docs.dhis2.org/master/en/developer/html/webapi_event_analytics.html?recipient=lars%40dhis2.org>
>>
>> regards,
>>
>> Lars
>>
>>
>> On Thu, Jul 27, 2017 at 6:07 PM, Jesus Solano-Roman <
>> asol...@broadinstitute.org> wrote:
>>
>> Hello all.
>>
>> We've been trying to get the Event Analytics endpoint to work (e.g.:)
>>
>> *https://play.dhis2.org/dev/api/analytics/events
>> <https://play.dhis2.org/dev/api/analytics/events?recipient=lars%40dhis2.org>*
>>
>> but we get a 404 error from the server. The same happens on our local
>> installation of DHIS2.
>>
>> Is there a reason why this is happening? Must something setting be
>> enabled or is this endpoint broken?
>>
>> Alternatively, we basically just want to get a list of the Data Elements
>> used in a particular program (event). We think this endpoint will do that
>> but if there's another endpoint we can use feel free to suggest.
>>
>> Otherwise our options are limited to looping and getting unique
>> identifiers using the
>>
>> */api/events?program=[...]*
>>
>> endpoint.
>>
>>
>> As always, thanks for your kind help.
>>
>>
>> Antonio Solano.
>> Broad Institute of MIT and Harvard. Boston, MA. USA
>>
>> _______
>> Mailing list: https://launchpad.net/~dhis2-users
>> <https://launchpad.net/~dhis2-users?recipient=lars%40dhis2.org>
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> <https://launchpad.net/~dhis2-users?recipient=lars%40dhis2.org>
>> More help   : https://help.launchpad.net/ListHelp
>> <https://help.launchpad.net/ListHelp?recipient=lars%40dhis2.org>
>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/?recipient=lars%40dhis2.org>
>>
>>


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

Re: [Dhis2-users] Event analytics endpoint broken

[Lars Helge Øverland]

Hi Jesus,

the API endpoint should work. There are a few parameters which are
mandatory:

https://play.dhis2.org/demo/api/26/analytics/events/aggregate/eBAyeGv0exc.json?dimension=ou:ImspTQPwCqd=pe:LAST_4_QUARTERS=fWIAEtYVEGk=oZg33kd9taw=Zj7UnCAulEk=SHORTNAME=EVENT=vV9UWAZohSf=AVERAGE

Have a look at the docs here:

https://docs.dhis2.org/master/en/developer/html/webapi_event_analytics.html

regards,

Lars


On Thu, Jul 27, 2017 at 6:07 PM, Jesus Solano-Roman <
asol...@broadinstitute.org> wrote:

> Hello all.
>
> We've been trying to get the Event Analytics endpoint to work (e.g.:)
>
> *https://play.dhis2.org/dev/api/analytics/events
> <https://play.dhis2.org/dev/api/analytics/events>*
>
> but we get a 404 error from the server. The same happens on our local
> installation of DHIS2.
>
> Is there a reason why this is happening? Must something setting be enabled
> or is this endpoint broken?
>
> Alternatively, we basically just want to get a list of the Data Elements
> used in a particular program (event). We think this endpoint will do that
> but if there's another endpoint we can use feel free to suggest.
>
> Otherwise our options are limited to looping and getting unique
> identifiers using the
>
> */api/events?program=[...]*
>
> endpoint.
>
>
> As always, thanks for your kind help.
>
>
> Antonio Solano.
> Broad Institute of MIT and Harvard. Boston, MA. USA
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-users] we're hiring - software engineers

[Lars Helge Øverland]

Hi all,

the DHIS 2 team is looking for new software engineers to join our team. If
you are a developer or know someone who might be interested, have a look at
our openings here:

https://www.dhis2.org/careers



regards,

Lars




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

Re: [Dhis2-users] dhis self-service app store is available

[Lars Helge Øverland]

Thanks.

If you find issues or have ideas for the the app store itself (not the apps
inside) you can register bugs and improvements in Jira under the "App Store
for DHIS 2" project:

https://jira.dhis2.org


[image: Inline image 1]

regards,

Lars


On Thu, Jul 20, 2017 at 6:46 AM, GROUT, Lise <gro...@who.int> wrote:

> Dear DHIS2 development team,
>
>
>
> This is a very good news!
>
>
>
> Thanks a lot,
>
> Lise.
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+groutl=who.int@lists.
> launchpad.net] *On Behalf Of *Lars Helge Øverland
> *Sent:* 19 July 2017 15:15
> *To:* DHIS 2 Developers list; DHIS 2 Users list
> *Subject:* [Dhis2-users] dhis self-service app store is available
>
>
>
> Hi all,
>
>
>
> the new self-service app store for DHIS 2 is available today. You can find
> it here:
>
>
>
> https://play.dhis2.org/appstore/
>
>
>
>
>
> The app store lets you sign in and upload your own apps. You can find
> detailed instructions for uploading apps here:
>
>
>
> https://www.dhis2.org/upload-app-to-dhis2-app-store
>
>
>
>
>
> The basics of uploading an app:
>
>
>
> 1. *Sign in* using your Google account ID from the top-right corner.
>
> 2. Click *Upload* in the left side menu, enter all app info and select
> your app ZIP bundle.
>
> 3. Click *Upload* and await approval by the DHIS 2 team.
>
> 4. You can later add more *images* and additional *versions* of your app.
>
>
>
> The apps must be i) generic, meaning usable not just by a single instance
> of DHIS 2 but any instance and ii) have an open source license, allowing
> others to use it free of charge.
>
>
>
>
>
> We hope that this will encourage the developer community to create generic
> apps and share them with others through the app store. This initiative
> should remove bottleneck of manual upload by the DHIS 2 team and allow for
> self-service upload and maintenance of apps.
>
>
>
> As always feedback is appreciated - please use the users list for
> questions, comments and feedback on the new app store.
>
>
>
>
>
> best regards,
>
>
>
> the DHIS 2 development team
>
>
>
>
>
>
>
>
> --
>
> Lars Helge Øverland
>
> Lead developer, DHIS 2
>
> University of Oslo
>
> Skype: larshelgeoverland
>
> l...@dhis2.org
>
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
>



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

[Dhis2-users] dhis self-service app store is available

[Lars Helge Øverland]

Hi all,

the new self-service app store for DHIS 2 is available today. You can find
it here:

https://play.dhis2.org/appstore/


The app store lets you sign in and upload your own apps. You can find
detailed instructions for uploading apps here:

https://www.dhis2.org/upload-app-to-dhis2-app-store


The basics of uploading an app:

1. *Sign in* using your Google account ID from the top-right corner.
2. Click *Upload* in the left side menu, enter all app info and select your
app ZIP bundle.
3. Click *Upload* and await approval by the DHIS 2 team.
4. You can later add more *images* and additional *versions* of your app.

The apps must be i) generic, meaning usable not just by a single instance
of DHIS 2 but any instance and ii) have an open source license, allowing
others to use it free of charge.


We hope that this will encourage the developer community to create generic
apps and share them with others through the app store. This initiative
should remove bottleneck of manual upload by the DHIS 2 team and allow for
self-service upload and maintenance of apps.

As always feedback is appreciated - please use the users list for
questions, comments and feedback on the new app store.


best regards,

the DHIS 2 development team




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

Re: [Dhis2-users] Major speed issue with pg_restore

[Lars Helge Øverland]

Hi Edward,

this is besides the main point but make sure you create pg dumps without
the analytics tables, and instead let DHIS 2 re-generate the analytics
tables (which is faster as indexing is run in parallel).

pg_dump -T analytics*

regards,

Lars

On Sun, Jul 16, 2017 at 10:43 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> Hi Bob, apologies, it’s running on this hardware:
>
> http://www.dell.com/support/home/ht/en/htbsdt1/product-
> support/servicetag/d2fvfx1/configuration
>
> A bit dated, but definitely not a hardware error given the speedy /
> successful restore on Windows.
>
> Regards
>
> Ed
>
>
>
> *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
> *Sent:* Saturday, 15 July 2017 3:02 PM
> *To:* Edward Robinson <erobin...@projectbalance.com>
> *Cc:* Knut Staring <knu...@gmail.com>; dhis2-users <
> dhis2-users@lists.launchpad.net>; Hannan Khan <hann...@gmail.com>
> *Subject:* RE: [Dhis2-users] Major speed issue with pg_restore
>
>
>
> Ed you never answered my earlier question about the hardware you were
> running on?
>
>
>
> On 15 Jul 2017 6:40 p.m., "Edward Robinson" <erobin...@projectbalance.com>
> wrote:
>
> Sorry for this slow response, time has not been on my side 
> Also, thanks Bob, Knut and Hannan for your responses.
>
> So to fill everyone in, I went through postgres.conf with a fine toothed
> comb.  @ Bob, Shared buffers were set to 3200 though I'd set them to 1600
> for the restore as per this article's suggestions:
> http://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html
> Overall I'm convinced the PGSQL environment had nothing to do with the
> issue... what I had suspect is that the combination of Ubuntu 16.04 and our
> hardware was not a good match.  I suspect the SATA channel in particular
> was the bottleneck.
> To prove a point (I have two identical machines), I loaded Win Server 2012
> R2 and and installed PGSQL 9.5.5 on the box and, without so much as
> tweaking a single file, I restored the dump within 50 minutes.  We're
> likely upgrading the platform soon so I'm not going to break my back
> troubleshooting what is likely an issue that won't be there in 6 months
> time.  Dell didn't include Debian or Ubuntu on their list of supported OS
> for the hardware combination, though I have no reason to believe it
> couldn't work with a little effort and a bit of old school compiling, I
> just don't have the luxury of time to fiddle.  It worked well with 12.04
> out of the box.
> I just thought I'd post this in case anyone else was having similar
> trouble - if you've double checked the configs, it's quite possibly a lower
> level issue.
> Cheers!
> Ed
>
>
> _______
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Database version - how to tell

[Lars Helge Øverland]

Hi Edward,

there is no way currently to tell the version from the database. As you say
it is recommended to back up the encryption key when enabling encryption,
otherwise you risk losing attribute data for good (it is mentioned in the
installation docs here
<https://docs.dhis2.org/master/en/implementer/html/install_encryption_configuration.html#install_considerations_for_encryption>
).

The constraint error you get might stem from an application rename of that
foreign key. Have a look at the programstage table and see if there is a
foreign key to dataentryform table with another name. If so either rename
it to *fk_programstage_dataentryform* or just delete it and restart the app.

best regards,

Lars




On Mon, Jul 17, 2017 at 1:48 AM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> An update on this, it turns out the encryption.password setting in the
> hibernate.properties file was overwritten with an incorrect value.
> Fortunately someone on the team recalled what it was previously as the file
> had not been backed up along with the database.  That accounts for the
> org.jasypt.exceptions. EncryptionOperationNotPossibleException error.  I
> am now able to get the system up and access the UI.  Lesson, always backup
> hibernate.properties along with the database!
>
> I am still getting some errors and warnings, they may be benign, but if
> anyone has insight into them, I would appreciate it greatly, particularly
> the errors:
>
>
>
> * WARN  2017-07-16 19:05:27,445 [127.0.0.1]:5701 [dev] [3.2.1] No join
> method is enabled! Starting standalone. (HazelcastInstanceImpl.java
> [localhost-startStop-1])
>
> ** ERROR 2017-07-16 19:05:45,648 HHH000388: Unsuccessful: alter table
> programstage add constraint fk_programstage_dataentryform foreign key
> (dataentryformid) references dataentryform (SchemaUpdate.java
> [localhost-startStop-1])*
>
> ** ERROR 2017-07-16 19:05:45,649 ERROR: constraint
> "fk_programstage_dataentryform" for relation "programstage" already exists
> (SchemaUpdate.java [localhost-startStop-1])*
>
> * WARN  2017-07-16 19:06:37,114 RP discovery / realm validation disabled;
> (RealmVerifier.java [localhost-startStop-1])
>
> * WARN  2017-07-16 19:07:16,113 Did not find any ViewResolvers to delegate
> to; please configure them using the 'viewResolvers' property on the
> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
> [localhost-startStop-1])
>
> * WARN  2017-07-16 19:07:26,335 Did not find any ViewResolvers to delegate
> to; please configure them using the 'viewResolvers' property on the
> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
> [localhost-startStop-1])
>
> * WARN  2017-07-16 19:07:29,027 Ignoring action package with no actions:
> struts-default (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,028 Ignoring action package with no actions:
> spring-default (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,028 Ignoring action package with no actions:
> dhis-web-commons (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,030 Ignoring action package with no actions:
> dhis-web-ohie (DefaultModuleManager.java [http-bio-8080-exec-7])
>
> * WARN  2017-07-16 19:07:29,030 Ignoring action package with no actions:
> dhis-web-portal (DefaultModuleManager.java [http-bio-8080-exec-7])
>
>
>
> Cheers,
>
> Ed
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Drop Down List

[Lars Helge Øverland]

Hi Rabia,

unfortunately there is no built-in feature for that at the moment. You will
need some javascript coding in a custom form to achieve it at the moment.

You can use the organisationUnit API to fetch the children in the hierarchy:

https://play.dhis2.org/demo/api/organisationUnits/O6uvpzGd5pu?fields=id,name,children[id,name]

regards,

Lars


On Mon, Jul 17, 2017 at 8:24 AM, <rab...@pace-tech.com> wrote:

> Hi,
>  I need to know about how can we make dependent drop down lists in custom
> data set form? For Example if i select province from one drop down, it
> shows all the districts present in that specific province in another drop
> down. Also, How can we get values from DataBase to show in our forms. For
> example just like by selecting a province, get the names of district from
> database to show in drop down list.
>
> Thank You!
>
> Regards: Rabia Naz Ali
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



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

Re: [Dhis2-users] [Dhis2-devs] Aggregation for the Time value type

[Lars Helge Øverland]

Okay thanks Sam.

On Tue, Jun 13, 2017 at 11:01 AM, <kaso...@gmail.com> wrote:

> The demo server has a time data element whose aggregation type is set to
> Sum and not none, so I thought Sum was supported.
>
>
>
> We have a variable “walking time to a facility”, which I think can be
> averaged up the hierarchy and across time.
>
>
>
> We will write up a requirement for that.
>
>
>
> Thanks,
>
>
>
> Sam Kasozi
> +256 788-993-565
> Skype: sam.kasoziug
>
>
>
> *From: *Lars Helge Øverland <l...@dhis2.org>
> *Sent: *Tuesday, June 13, 2017 11:49 AM
> *To: *Sam Kasozi <kaso...@gmail.com>
> *Cc: *DHIS 2 developers <dhis2-d...@lists.launchpad.net>;
> dhis2-users@lists.launchpad.net
> *Subject: *Re: [Dhis2-devs] Aggregation for the Time value type
>
>
>
> Hi Sam,
>
>
>
> we do not support aggregation of time value type at the moment (nor other
> data types).
>
>
>
> Feel write to open an issue in Jira where you describe the requirement.
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
>
>
>
>
>
>
> On Tue, Jun 13, 2017 at 9:55 AM, Sam Kasozi <kaso...@gmail.com> wrote:
>
> What are the currently supported aggregation types for the Time value type
> besides SUM?
>
>
>
> AVERAGE does not seem to be supported with version 2.27.
>
>
>
> regards,
>
>
> *Sam Kasozi*
> +256 788-993-565
>
> Skype: sam.kasoziug
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> Lars Helge Øverland
>
> Lead developer, DHIS 2
>
> University of Oslo
>
> Skype: larshelgeoverland
>
> l...@dhis2.org
>
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
>
>
>



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

Re: [Dhis2-users] [Dhis2-devs] Aggregation for the Time value type

[Lars Helge Øverland]

Hi Sam,

we do not support aggregation of time value type at the moment (nor other
data types).

Feel write to open an issue in Jira where you describe the requirement.

regards,

Lars





On Tue, Jun 13, 2017 at 9:55 AM, Sam Kasozi <kaso...@gmail.com> wrote:

> What are the currently supported aggregation types for the Time value type
> besides SUM?
>
> AVERAGE does not seem to be supported with version 2.27.
>
> regards,
>
> Sam Kasozi
> +256 788-993-565
> Skype: sam.kasoziug
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Tie an indicator denominator to a fixed period

[Lars Helge Øverland]

Hi Georgi,

try this:

- collect "Number of beds" as a yearly data value.
- set the aggregation type for the "Number of beds" data element to
"Average (sum in org unit hierarchy".

In indicators, when aggregating for a month, the analytics engine will use
the "standing" value for each month based on the yearly value for the
denominator.

regards,

Lars







On Fri, Jun 2, 2017 at 7:06 PM, Georgi Chakarov <geo...@logicaloutcomes.net>
wrote:

> Hi guys,
>
> Can someone help on this case:
>
> I need to have the Beds’ utilization rate (%) calculated for my 5 Org
> Units.
>
> I collect the "Number of occupied beds" as a separate data element on a
> monthly basis. The number of beds per Org Unit is fixed and I have
> collected the information for them only once in September 2016 in a data
> element called “Number of Beds”. The number of beds does not change.
>
> How can I set up the denominator of the indicator (“Number of occupied
> beds”/Number of Beds) so that the value of the indicator is calculated
> based on the value of the “Number of Beds” data element for September 2016
> and not the value of the current month (apparently there is no values for
> the months after September 2016)?
>
> I cannot use constants, because the number of beds is different for each
> Org Units and I do not want to create 5 separate Indicators for the 5
> separate Org Units.
>
> At the same time I do not want to record the number of beds to be the same
> every month, since it is confusing and it will look like we add up the same
> number of debs every month, which is not the case.
>
> Is there a solution to this issue?
>
> Thanks,
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <+1%20647-478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* <i...@logicaloutcomes.net>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Mix quarterly and monthly data in a (Jasper) report

[Lars Helge Øverland]

Hi Martin,

the analytics app and the API allow you retrieve months and quarters (both
fixed and relative) in a single report / API call.

E.g. in pivot table, select "Last 12 months" as well as "Last 4 quarters"
as load the table.

If you place the periods on columns you can easily include only the needed
periods in your report design.



[image: Inline image 1]

The corresponding analytics API call:

https://play.dhis2.org/dev/api/26/analytics.json?dimension=dx:Jtf34kNZhzP;cYeuwXTCPkU;fbfJHSPpUQD=pe:LAST_12_MONTHS;LAST_4_QUARTERS=ou:ImspTQPwCqd

So yes I think you can achieve this, unless I am missing something in your
question.

regards,

Lars




On Fri, Jun 2, 2017 at 3:03 PM, Martin Van Aken <mar...@joyouscoding.com>
wrote:

> Hi,
> We have a report that requires both montly & quartery data - basically,
> some information (quantity of services provided) are collected monthly,
> while another type (quality of service) is done quarterly. On months 1 and
> 2, we show only the quantity of services, but every third month, we need a
> report showing the quantity for the current month + the quality for the
> quarter.
>
> Is this possible? Showing a mix of monthly data & quarterly values? Are
> there any examples working that way? Does anyone have the same requirement?
>
> Thanks,
>
> Martin
>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

[Dhis2-users] dhis version 2.27 is released

[Lars Helge Øverland]

per/html/webapi_events.html#webapi_querying_reading_events>





Deleted metadata objects log: Deletion of metadata is now logged and can be
queried from a new endpoint /api/deletedObjects. This allows clients with
local databases to react on deleted metadata objects.



Docs
<https://docs.dhis2.org/master/en/developer/html/webapi_deleted_objects.html>





Email sending: A new endpoint for sending email is introduced at /api/email.



Docs <https://docs.dhis2.org/master/en/developer/html/webapi_email.html>





Min-max data element values: A new endpoint for setting and retrieving
min-max data element values is introduced at /api/minMaxDataElements.



Docs
<https://docs.dhis2.org/master/en/developer/html/webapi_min_max_data_elements.html>





Lock exceptions: A new endpoint which lets you create, retrieve and remove
data set lock exceptions is available at /api/lockExceptions.



Docs
<https://docs.dhis2.org/master/en/developer/html/webapi_lock_exceptions.html>





Event export identifier schemes: The event export resource for now
supported identifier schemes, i.e. allows for use of code as well as
identifier.



Docs
<https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events>





RELEASE INFO

---



Release Information

Link

Download release and sample database

https://www.dhis2.org/downloads

Documentation and Javadocs

https://www.dhis2.org/documentation

Upgrade notes

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

Details about each feature on JIRA

https://jira.dhis2.org/issues/?filter=10257

Overview of fixed issues

https://jira.dhis2.org/issues/?filter=10418

Source code on Github

https://github.com/dhis2

Demo instance

https://play.dhis2.org/demo

Instructions for signing up for DHIS 2 mailing lists

https://www.dhis2.org/contact









Enjoy the new release.



Best regards,



The DHIS2 development team








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

Re: [Dhis2-users] [Dhis2-devs] Error Message on Log

[Lars Helge Øverland]

Yep should have been debug, was an oversight.

Lars



On Mon, May 29, 2017 at 6:52 PM, Jasper Timm <jasper.t...@ehealthnigeria.org
> wrote:

> Maybe someone should change the logging level from 'Error' to 'Info' for
> the message then?
>
> On Mon, May 29, 2017 at 12:34 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Noted Lars!!!
>>
>> Thanks
>>
>> On 5/29/17, Lars Helge Øverland <l...@dhis2.org> wrote:
>> > Hi Gerald,
>> >
>> > this is normal and is an internal system log message related to database
>> > connections - nothing to worry about.
>> >
>> > regards,
>> >
>> > Lars
>> >
>> >
>> > On Mon, May 29, 2017 at 1:51 PM, gerald thomas <gerald17...@gmail.com>
>> > wrote:
>> >
>> >> Dear All,
>> >>
>> >> I am having the following errors:
>> >>
>> >> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-191])
>> >> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-191])
>> >> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-187])
>> >> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-152])
>> >>
>> >> Any idea what is it means?
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> Mailing list: https://launchpad.net/~dhis2-users
>> >> Post to : dhis2-users@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> >
>> >
>> > --
>> > Lars Helge Øverland
>> > Lead developer, DHIS 2
>> > University of Oslo
>> > Skype: larshelgeoverland
>> > l...@dhis2.org
>> > http://www.dhis2.org <https://www.dhis2.org/>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>


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

Re: [Dhis2-users] [Dhis2-devs] Troubleshoot CSV data value import on ignored rows

[Lars Helge Øverland]

Hi Trøyel,

okay - could you post the actual feedback you get from the API / UI ?

best,

Lars

On Mon, May 29, 2017 at 6:36 PM, Trøyel Nerbø <troyel.ne...@nrc.no> wrote:

> Dear all,
>
> I am trying to change and move data values where I have exported the data
> from data value export and then I have modified and split the data on
> periods only (same properties imported back but instead of all data in
> 201601 some is distributed onto 201701). Running the latest on 2.26 I get a
> few rows that are ignored in the CSV import, but no conflicts or
> information on what this is. Any ways to troubleshoot this import to get
> debug like in metadata import? Thanks!
>
>
>
> Best,
>
> Trøyel
>
>
> Best Regards
> *Halvar Trøyel Nerbø*
> Reporting Advisor
>
> +47 992 39 817 <992%2039%20817>
>
> Skype: nrc_troyel
> www.nrc.no
>
> [image: nrclogo] <http://www.nrc.no/>
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Error Message on Log

[Lars Helge Øverland]

Hi Gerald,

this is normal and is an internal system log message related to database
connections - nothing to worry about.

regards,

Lars


On Mon, May 29, 2017 at 1:51 PM, gerald thomas <gerald17...@gmail.com>
wrote:

> Dear All,
>
> I am having the following errors:
>
> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-191])
> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-191])
> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-187])
> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-152])
>
> Any idea what is it means?
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



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

Re: [Dhis2-users] Data Elements sharing functionality

[Lars Helge Øverland]

It's supported there too.

On Thu, May 18, 2017 at 11:22 AM, Kristiyan Panayotov <
kristi...@logicaloutcomes.net> wrote:

> What about tracker capture?
>
>
>
> *From:* Lars Helge Øverland [mailto:l...@dhis2.org]
> *Sent:* 18 May 2017 12:20
> *To:* Kristiyan Panayotov <kristi...@logicaloutcomes.net>
> *Cc:* Prosper BT <ptb3...@gmail.com>; dhis2-users@lists.launchpad.net;
> dhis2-d...@lists.launchpad.net; Georgi Chakarov <
> geo...@logicaloutcomes.net>
> *Subject:* Re: [Dhis2-users] Data Elements sharing functionality
>
>
>
>
>
> Yes you can associate a program with category combinations as well. For
> event-based programs (no registration) it works quite similarly as for data
> sets.
>
>
>
>
>



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

Re: [Dhis2-users] Data Elements sharing functionality

[Lars Helge Øverland]

Yes you can associate a program with category combinations as well. For
event-based programs (no registration) it works quite similarly as for data
sets.
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Error updating program between two instances

[Lars Helge Øverland]

Hi Marc,

thanks. I have commented in the Jira issue.

regards,

Lars


On Thu, May 18, 2017 at 10:42 AM, Marc Garnica <marcgarnic...@gmail.com>
wrote:

> Hi all,
>
> I've created this issue in JIRA describing a bug in the import/export of
> programs between two instances. If we are creating from scratch a program
> in the target instances it works fine but the problem comes when we are
> updating and existing program (same ids) in the target instances, then the
> import breaks the link between the program and the trackedEntityAttributes.
>
> Jira issue:
> https://jira.dhis2.org/browse/DHIS2-1655
>
> I've tested the problem in the demo version and it's present also. Thank
> you very much in advance.
>
> Marc Garnica
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Data Elements sharing functionality

[Lars Helge Øverland]

Hi Kristiyan,

you can use sharing
<https://docs.dhis2.org/master/en/user/html/ch20s01.html> to control access
to data elements. However, there is a difference between data entry and
data analysis. In the data entry module, we do not filter data elements
inside forms based on sharing. To control access there, you must either
split out into multiple data sets, or have a category combo linked to the
data set where each category option uses sharing. In data analysis we do
filter data elements according to sharing.

regards,

Lars


On Thu, May 18, 2017 at 9:42 AM, Prosper BT <ptb3...@gmail.com> wrote:

> Dear Kristiyan,
>
> Meta data sharing is key to solving your requirement. You will need to
> group the users into different user groups and under maintenance data
> elements provide view access to those you want to see and and no public
> access. Only user in the group granted view access will be able to see it
> in analysis.
>
> [image: Inline image 1]
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
> prospertb
>
> On Tue, May 16, 2017 at 4:40 PM, Kristiyan Panayotov <
> kristi...@logicaloutcomes.net> wrote:
>
>> Dear DHIS2 community members,
>>
>>
>>
>> I have the following question:
>>
>>
>>
>> I have two partners working on the same program in DHIS2, but I don’t
>> want the one partner to see a specific data element, because it contains
>> sensitive information.
>>
>>
>>
>> Is it possible two users to “see” the same data set/program, but hide
>> one/more data element from one or the other user? Is that possible from the
>> Data elements sharing options? When I tried to assign one Data elements to
>> a specific User, still other Users are able to see that Data Element.
>>
>>
>>
>> Is there a way to achieve this?
>>
>>
>>
>> Any help will be greatly appreciated,
>>
>>
>>
>> With respect
>>
>>
>>
>> Kristiyan Panayotov
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Error in Hierarchy operations Orgunit move

[Lars Helge Øverland]

Hi Elmarie,

sounds like a bug. Can you reproduce on demo server? Please report as bug
on Jira and include version/environment.

regards,

Lars


On Tue, May 16, 2017 at 8:31 AM, Elmarie Claasen <elma...@hisp.org> wrote:

> Hi all,
>
>
>
> I tried to move an orgunit  at OU2 level to another orgunit at OU2 level
> which will effectively create another level in the hierarchy. Received an
> error message in the UI “Failed to move ec Eastern Cape Province ([object
> Object}])
>
>
>
> The browser console error is
>
> maintenance-1ca1c6ea03e38d01c7de.js:1 API request failed with status 500
> Internal Server Error
>
> Request: PUT https://gfccm.dhis.hisp.org/training/api/26/
> organisationUnits/WeeW3tgF69f?mergeMode=REPLACE
>
>
>
> What could be the problem with this?
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: 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 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] scheduling task error on db primrary key

[Lars Helge Øverland]

(
> AbstractEntityPersister.jav
> a:3311)
> at org.hibernate.persister.entity.AbstractEntityPersister.delete(
> AbstractEntityPersister.jav
> a:3548)
> at org.hibernate.action.internal.EntityDeleteAction.execute(
> EntityDeleteAction.java:98)
> at org.hibernate.engine.spi.ActionQueue.executeActions(
> ActionQueue.java:586)
> at org.hibernate.engine.spi.ActionQueue.executeActions(
> ActionQueue.java:460)
> at org.hibernate.event.internal.AbstractFlushingEventListener.
> performExecutions(AbstractFlus
> hingEventListener.java:337)
> at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(
> DefaultFlushEventListener.
> java:39)
> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
> at org.hibernate.internal.SessionImpl.managedFlush(
> SessionImpl.java:468)
> at org.hibernate.internal.SessionImpl.
> flushBeforeTransactionCompletion(SessionImpl.java:3135
> )
> at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(
> SessionImpl.java:2352)
> at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.
> beforeTransactionCompletion(JdbcCo
> ordinatorImpl.java:491)
> at org.hibernate.resource.transaction.backend.jdbc.internal.
> JdbcResourceLocalTransactionCoor
> dinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCo
> ordinatorImpl.java:147)
> at org.hibernate.resource.transaction.backend.jdbc.internal.
> JdbcResourceLocalTransactionCoor
> dinatorImpl.access$100(JdbcResourceLocalTransactionCo
> ordinatorImpl.java:38)
> at org.hibernate.resource.transaction.backend.jdbc.internal.
> JdbcResourceLocalTransactionCoor
> dinatorImpl$TransactionDriverControlImpl.commit(
> JdbcResourceLocalTransactionCoordinatorImpl.java:231
> )
> at org.hibernate.engine.transaction.internal.
> TransactionImpl.commit(TransactionImpl.java:65)
>
> at org.springframework.orm.hibernate5.HibernateTransactionManager.
> doCommit(HibernateTransact
> ionManager.java:582)
> ... 20 more
> Caused by: org.postgresql.util.PSQLException: 错误: 在 "fileresource"
> 上的更新或删除操作违反了在 "ex
> ternalfileresource" 上的外键约束 "fk_fileresource_externalfileresource"
>   详细：键值对(fileresourceid)=(862296)仍然是从表"externalfileresource"引用的.
>
>
>
> --
> 此致
>
> easy
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Pivot Table Not Loading on 2.26

[Lars Helge Øverland]

Hi Gerald,

this looks like a mismatch between the API and the pivot table app. Likely
some app files are stuck in a cache somewhere:

- clear nginx cache on the server:

sudo rm /var/cache/nginx -rf
sudo service nginx restart

- check that you upgraded your WAR file properly (deleted the old directory
+ WAR file)


regards,

Lars


On Sun, Apr 23, 2017 at 11:12 PM, gerald thomas <gerald17...@gmail.com>
wrote:

> Dear Knut,
> As per previous mail sent:
> I had tried it with different browser but the situation is still the
> same. The log on the web browers is as follows:
> GET
> XHR
> https://sl.dhis2.org/hmis/api/26/dataSets.json [HTTP/1.1 200 OK 190ms]
> Empty string passed to getElementById(). sl.dhis2.org
> POST
> XHR
> https://chat.phoenix.edu/http-bind [HTTP/1.1 200 OK 60424ms]
> Empty string passed to getElementById().  sl.dhis2.org
> Empty string passed to getElementById().  ext-all.js:15:88033
> Empty string passed to getElementById().  sl.dhis2.org
> GET
> XHR
> https://sl.dhis2.org/hmis/api/26/analytics.json [HTTP/1.1 200 OK 361ms]
> GET
> XHR
> https://sl.dhis2.org/hmis/api/26/analytics.json [HTTP/1.1 200 OK 485ms]
> TypeError: e.metaData.names is undefined[Learn More]  app.js:1:13534
>
>
>
>
> On 4/23/17, Knut Staring <knu...@gmail.com> wrote:
> > Hi Gerald,
> >
> > It probably is not a bug, since it works here (please always check the
> > online demo):
> > https://play.dhis2.org/demo/dhis-web-pivot/#
> >
> > Then please let us know what you have done so far: Have you tried
> different
> > browsers, incognito mode and cache cleaning?
> >
> > If the problem is still there, please share messages from the browser
> > console and server log.
> >
> > Knut
> >
> > On Sun, Apr 23, 2017 at 12:50 PM, gerald thomas <gerald17...@gmail.com>
> > wrote:
> >
> >> Dear All,
> >> After upgrading my instance to 2.26; i notice that my pivot table and
> >> visualizer are not loading.
> >>
> >> Don't know if it is a bug, please help.
> >>
> >> Build revision:
> >> a52916f
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-users
> >> Post to : dhis2-users@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >
> >
> >
> > --
> > Knut Staring
> > Dept. of Informatics, University of Oslo
> > Norway: +4791880522
> > Skype: knutstar
> > http://dhis2.org
> >
>
>
> --
> Regards,
>
> Gerald
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



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

Re: [Dhis2-users] [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

[Lars Helge Øverland]

Hi Tantely,

to achieve this I think you should use the "org unit group" selection mode.
Under the organisation unit dimension section, click the gear icon and
select "Select groups", then select the org unit group which contains the
org units you would like to display.

In the org unit tree you can leave the selected org unit at the national
level if you would like to include facilities from the entire country.


[image: Inline image 3]


This will render the actual org units from that group in your pivot table.

regards,

Lars





On Thu, Apr 6, 2017 at 5:38 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear community,
>
> I am trying to create a filter to be used with the pivot table results, so
> that only the filtered OrgUnits will appear. For that I have created
> OrgUnit groups and have used them in the pivot table. The layout is
> illustrated in the attached file, by using the OrgUnits in the row
> dimensions. As a result, the pivot table is only using the OrgUnit groups
> as a categorization of the results but not filtering them as all OrgUnits
> are still displayed. I think that an interest using a filter is to avoid
> dumping a huge amount of data, which is sometimes freezing DHIS2 when
> displaying the results at the lowest level of OrgUnits.
>
> Which way should I follow in order to filter the OrgUnits according to
> some criteria (like using a spreadsheet filter)? Would it be possible doing
> that in the pivot table or it would be worth creating an equivalent SQL
> uery? One constraint with using SQL View is that we can only call
> DataElements but not Indicators.
>
> I am using DHIS2 2.24.
>
> Thank you for your support and suggestions!
>
> Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] Limit on data attribute - category options

[Lars Helge Øverland]

Hi Marc,

as Jason says you can use the sharing (docs
<https://docs.dhis2.org/master/en/user/html/sharing.html>) solution for
this by sharing each category option (representing e.g. partners)
appropriately. This can be done in many ways depending on the level of
complexity of your organization. At its very basic level, you can create
one user group per implementing partner, then share each partner category
option with read access to the appropriate user group. This way, when
partners log into data entry, they will only see the category options in
the category drop-down which are relevant to them.

Sharing can easily grow complex so it is advisable to keep things simple
and think through the design up front (as always).

regards,

Lars




On Mon, Apr 3, 2017 at 9:44 AM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> Yes, you can  use "Sharing" controlled with user groups. However, it can
> get complex quickly, and usually requires very careful user management
> routines, coupled with automatic scripting to get it right.
>
>
>
> On Mon, Apr 3, 2017 at 9:31 AM, Marc Garnica <marcgarnic...@gmail.com>
> wrote:
>
>> Dear all,
>>
>> This is also a requirement for us but we are wondering if it is possible
>> to implement a "user" visibility of the data sets category options. For
>> example a user from Spain only being acessible to the Spain Implementer
>> Partners or a user only accessing to the category options where he's in
>> charge to enter data.
>>
>> Thanks a lot!
>> Marc Garnica
>>
>> 2017-04-03 9:15 GMT+02:00 Sam Kasozi <kaso...@gmail.com>:
>>
>>> Yes, we do have fixed relationships within those categories, so this
>>> works for us!
>>>
>>> This implementation is much safer as well since it will not require a
>>> data entrant to filter through the different categories.
>>>
>>>
>>> Thank you.
>>>
>>> Sam Kasozi
>>> +256 788-993-565
>>> Skype: sam.kasoziug
>>>
>>> On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland <l...@dhis2.org>
>>> wrote:
>>>
>>>> Hi Sam,
>>>>
>>>> yes it should be possible to set this up in DHIS 2.
>>>>
>>>> In your case, if you create all 4 as categories you might end up with a
>>>> very high number of option combo permutations.
>>>>
>>>> However, it might be that you have fixed relationships within those
>>>> categories. For example, it could be that one grant is supported by exactly
>>>> one implementing partner and donor. In that case, you should not ask end
>>>> users to actively select partner and donor in data entry; rather have them
>>>> select the grant only (as a data set category). From there, you can set up
>>>> category option groups and group sets:
>>>>
>>>> Group set: Donor
>>>> Groups: USAID, DFID, etc
>>>>
>>>> Group set: Implementing partner
>>>> Groups: PartnerA, PartnerB, etc
>>>>
>>>> Then you assign each grant to exactly one group per group set. You can
>>>> now do analytics based on the above dimensions without having end users
>>>> explicitly selecting them in data entry. This will keep number of category
>>>> option combos low and reduce time and errors during data entry. Make sure
>>>> you set the category option group sets as "data dimension".
>>>>
>>>> Docs here
>>>> <https://docs.dhis2.org/master/en/user/html/manage_category.html>.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi <kaso...@gmail.com> wrote:
>>>>
>>>>> We would like to add the data attributes: Donor, Program, Implementing
>>>>> Partner and Grant in a category combination to some datasets.
>>>>>
>>>>> Looking at the data that needs to be imported, the Donors and Programs
>>>>> are few, however, the IPs and grants are in the range of 200 and 500
>>>>> respectively; of course with potential to increase over time.
>>>>>
>>>>> I am wondering if the DHIS2 is designed to manage that kind of data.
>>>>>
>>>>>
>>>>> regards,
>>>>>
>>>>> Sam Kasozi
>>>>> +256 788-993-565
>>>>> Skype: sam.kasoziug
>>>>>
>>>&

Re: [Dhis2-users] [Dhis2-devs] Limit on data attribute - category options

[Lars Helge Øverland]

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a
very high number of option combo permutations.

However, it might be that you have fixed relationships within those
categories. For example, it could be that one grant is supported by exactly
one implementing partner and donor. In that case, you should not ask end
users to actively select partner and donor in data entry; rather have them
select the grant only (as a data set category). From there, you can set up
category option groups and group sets:

Group set: Donor
Groups: USAID, DFID, etc

Group set: Implementing partner
Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now
do analytics based on the above dimensions without having end users
explicitly selecting them in data entry. This will keep number of category
option combos low and reduce time and errors during data entry. Make sure
you set the category option group sets as "data dimension".

Docs here <https://docs.dhis2.org/master/en/user/html/manage_category.html>.

regards,

Lars





On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi <kaso...@gmail.com> wrote:

> We would like to add the data attributes: Donor, Program, Implementing
> Partner and Grant in a category combination to some datasets.
>
> Looking at the data that needs to be imported, the Donors and Programs are
> few, however, the IPs and grants are in the range of 200 and 500
> respectively; of course with potential to increase over time.
>
> I am wondering if the DHIS2 is designed to manage that kind of data.
>
>
> regards,
>
> Sam Kasozi
> +256 788-993-565
> Skype: sam.kasoziug
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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