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

[Jim Grace]

Hello Gourav,

Unfortunately the issue still exists (as you have shown). We are aware of
that. Jira ticket DHIS2-3350 is closed, but if you look at the last comment
you will see:

 This bug will be addressed with a new feature defined in DHIS2-2380
<https://jira.dhis2.org/browse/DHIS2-2380>

There is further discussion in DHIS2-2380.

Cheers,
Jim


On Tue, Sep 18, 2018 at 2:09 AM 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-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Failed to save approval level

[Jim Grace]

Hi Noberto,

I am able to create a new approval level on 2.27.

Can you reproduce the problem on https://play.dhis2.org/2.27/?

Can you give some step-by-step details as to what you did, so we can try to
reproduce it?

Thanks.

Cheers,
Jim Grace


On Tue, May 22, 2018 at 4:08 AM, Norberto Banze <norbertoba...@live.com>
wrote:

> Hi Devs,
>
> I am trying to create a new approval level but the system doesn't allow me
> to save it.
>
> I have the following error message ''Failed to save approval level''.
>
> It allows me to create the Approval workflow although I cant select the
> data approval level on this field.
>
> I am using the version 2.27
>
> HELP PLEASE
>
> Greetings,
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] How to perform logical operations in indicator calculations

[Jim Grace]

Hi Leke,

Thank you for the question. We are collecting requests for enhancements to
indicator expressions, and other analytics expressions, in the Jira Epic at
https://jira.dhis2.org/browse/DHIS2-3187. I have taken the liberty of
copying your email (without the email addresses) into Jira issue
https://jira.dhis2.org/browse/DHIS2-3820 which is linked to this Jira Epic.

Cheers,
Jim


On Thu, May 24, 2018 at 11:34 AM, John Mukulu <john.f.muk...@gmail.com>
wrote:

> Hello Olaleke and Jason,
> We're currently slowly working through documenting the functions
> maintenance, but if you need quick intro and help on it, I have copied my
> Colleague Vincent Minde who's working on it, he'll help.
>
> Cheers.
>
> On Wed, May 23, 2018 at 6:25 PM, Olaleke Seweje <sewejeolal...@gmail.com>
> wrote:
>
>> Thanks Jason, will try these options out and revert.
>>
>> On Wed, May 23, 2018 at 2:00 PM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi  Leke,
>>>
>>> This is currently not possible with aggregate data. You can have a look
>>> at this app (https://play.dhis2.org/appstore/app/dXX2Fk6jwCX) which may
>>> help you to implement this.
>>>
>>> You may also want to have a look at the documentation on analytics
>>> hooks, which may help you to implement these types of indicators with
>>> custom scripts.
>>>
>>> https://docs.dhis2.org/master/en/developer/html/webapi_analy
>>> tics_table_hooks.html
>>>
>>> Best regards,
>>> Jason
>>>
>>>
>>> On Tue, May 22, 2018 at 4:14 PM, Olaleke Seweje <sewejeolal...@gmail.com
>>> > wrote:
>>>
>>>> Hello all,
>>>> Please I am looking for a way to perform logical operations in DHIS.
>>>> I have an indicator calculation that has a denominator specified as
>>>>
>>>> org unit counts that belong to a group (e.g. Group 1) AND have reported
>>>> in the past month.
>>>>
>>>> Any ideas on how I can set this up in DHIS will be appreciated.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Leke Seweje
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049
>>>
>>
>>
>>
>> --
>> Regards,
>> Leke Seweje
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> John Francis Mukulu,
> Software Architect, HISPTZ.
> https://hisptanzania.org/
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Access to Demo Site

[Jim Grace]

It looks like someone changed the admin password (which is within the
authorities of the admin user). It should be back tomorrow when the system
is reset. Meanwhile, I agree that the best thing is just create your own
account.

Cheers,
Jim


On Wed, Apr 18, 2018 at 9:08 AM, Bridget Magoba <bridgetmag...@mifumi.org>
wrote:

> Hi Ifeanyi,
>
> You can try creating your own account, there is a green button at the top
> right corner.
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+bridgetmagoba=mifumi.org@
> lists.launchpad.net] *On Behalf Of *Ifeanyi Okoye
> *Sent:* Wednesday, April 18, 2018 3:43 PM
> *To:* DHIS 2 Users List; DHIS 2 Developers List
> *Subject:* [Dhis2-users] Access to Demo Site
>
>
>
> Hello Everyone,
>
> I have been trying to access the DHIS2 demo site but it keeps saying wrong
> user name or password.
>
>
>
> Anyone else having this issue?
>
>
>
>
> Warm Regards,
>
> Ifeanyi
>
> Read DrMaestro's Blog
> www.ifeanyiokoye.com
>
>
> --
> [image: Avast logo] <https://www.avast.com/antivirus>
>
> This email has been checked for viruses by Avast antivirus software.
> www.avast.com <https://www.avast.com/antivirus>
>
> <#m_6506718407722270092_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Offline support for validation rules in Data Entry (aggregate)

[Jim Grace]

Hi Jasper,

No final decisions have been made, but we are aware of the desire for
running validation rules in the browser. We are considering doing this when
we rewrite data entry in the new user interface style, probably not before.

Cheers,
Jim


On Fri, Jan 26, 2018 at 11:24 AM, Jasper Timm <
jasper.t...@ehealthnigeria.org> wrote:

> Any devs care to comment on this?
>
> It looks like data is sent server side to run the validation rules at the
> moment. Would it be possible to cache the rules and run these checks client
> side for offline support?
>
> On Tue, Jan 16, 2018 at 3:16 PM Jasper Timm <jasper.timm@ehealthnigeria.
> org> wrote:
>
>> Hi DHIS2 devs,
>>
>> In 2.26 it seems when the user is entering data offline and they hit the
>> 'complete' button, if there are validation rules set which prevent the user
>> from completing, they are not run whilst offline and the form is completed.
>>
>> Are there plans to support this in the future?
>>
>> Thanks,
>>
>> - Jasper
>>
>> --
>>
>> *Jasper Timm*
>>
>> Lead Software Developer
>>
>> *eHealth Africa*
>>
>> Mobile +232 99891119 <+23299891119>
>>
>> www.ehealthafrica.org
>>
>>
>> <http://www.ehealthafrica.org/>
>>
>>
> ___________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Cannot view data elements when creating left and right side components of a validation rule

[Jim Grace]

Dear Timothy,

My suggestions:

1. If you haven't already, I suggest you upgrade to the latest build of
2.26 from https://www.dhis2.org/downloads. I have tried to reproduce your
problem on the latest build of 2.26, and was unable to do so. I also tried
to reproduce the problem on a build of 2.26 that I was running from May
2017, but also was unable to do so. Perhaps you are running on a different
build from either of these.

2. If you are still getting this error in the latest build of 2.26, please
look at the server logs and let us know what you find. Your latest
screenshot shows an "internal server error", so hopefully the server has
logged more details in the error log.

Cheers,
Jim


On Thu, Aug 3, 2017 at 6:50 AM, Timothy Kiyemba <tkiye...@gmail.com> wrote:

> Dear Jason,
>
> Thanks for the feedback. I have tried to run this process afresh to view
> more clearer error messages. It looks like the previous ones included
> others that had been resolved. Please see attached. It seems to be pointing
> to something about data element operands. See screen shot attached.
>
> Timothy
>
> On Thu, Aug 3, 2017 at 1:40 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Maybe its down? Blocked by a firewall?
>>
>> This is not really a DHIS2 problem per se,You are just attempting to
>> connect to the server and your browser cannot reach that address. Since its
>> a private IP address (192.168.X.X) , perhaps you are simply not connected
>> to the same local network?
>>
>> On Thu, Aug 3, 2017 at 12:37 PM, Timothy Kiyemba <tkiye...@gmail.com>
>> wrote:
>>
>>> Could it be a memory issue? What could be the cause of the server not
>>> being reachable?
>>>
>>> On Thu, Aug 3, 2017 at 1:35 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
>>>> You can see here
>>>>
>>>>
>>>> That the server is not reachable.
>>>> ​
>>>>
>>>> On Thu, Aug 3, 2017 at 11:29 AM, Timothy Kiyemba <tkiye...@gmail.com>
>>>> wrote:
>>>>
>>>>> Dear All,
>>>>>
>>>>> I am unable to view data elements when creating left and right side
>>>>> components of a validation rule. Any one faced this problem? Please
>>>>> support. I am using DHIS2 2.26. See screen shot attached.
>>>>>
>>>>> Timothy Kiyemba
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Jason P. Pickering
>>>> email: jason.p.picker...@gmail.com
>>>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>>>
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Setting up debug session with Intellij

[Jim Grace]

Hi Alex,

Go under the dhis-2 directory to the dhis-web subdirectory, open up the
pom.xml under dhis-web and make an Intellij project out of that.

Cheers,
Jim


On Thu, Apr 27, 2017 at 5:02 PM, Alexander Freas <
alexander.fr...@ehealthnigeria.org> wrote:

> Hi,
>
> I am trying to set up DHIS2 to run inside Intellij and be able to start a
> debug session when breakpoints in API endpoints are called.  I found this
> resource from last year about doing exactly that:
> http://dhis-developers-list.1563109.n2.nabble.com/GSOC-
> Getting-the-back-end-to-hit-a-debug-break-point-tp7607822p7607830.html
>
> However, I do not see the "DHIS Web Portal" Maven project after opening
> the pom.xml in the main dhis-2 directory.
>
> Am I doing something wrong or is that advice from last year out of date?
> Is there another way to accomplish what I'm after?  I've attached a
> screenshot of what my Maven project window looks like.
>
> Thanks!
>
> Alex
>
> [image: Inline image 1]
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] SQL query for DataSets

[Jim Grace]

If you want to show each pair of assigned orgUnit and dataSet, try
something like:

SELECT ou.name AS orgunit, ds.name AS dataset
FROM dataset ds
JOIN datasetsource dss ON dss.datasetid = ds.datasetid
JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
ORDER BY ou.name, ds.name;

If you want only one row per orgUnit and a column that concatenates all
assigned dataset names, try (in Postgresql):

SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name) AS
datasets
FROM dataset ds
JOIN datasetsource dss ON dss.datasetid = ds.datasetid
JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
GROUP BY ou.name
ORDER BY ou.name;

Cheers,
Jim


On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Dear Community,
>
> I am trying to pull out the list of all orgUnits and the name of the
> questionnaire assigned to each of them via SQL View. In which table should
> I base the SQL query in order to have the list of dataSet assigned to an
> orgUnit?
>
> 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-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Lock Data set in advance

[Jim Grace]

Hi Nayeem,

Thank you for asking again.

This is now implemented in the latest builds of versions 2.24 and
following. Negative expiry days are accepted, and the data set is locked
before the end of the period. With a large enough negative expiry day
count, the data set can be locked as far ahead as you like, even before the
start of the period. As you said, this can be useful for entering future
data such as for planning, forecasting, or targets.

Cheers,
Jim


On Mon, Jan 23, 2017 at 1:20 AM, Nayeem Al Mifthah <n.mift...@gmail.com>
wrote:

> Hi Jim
> Is there any plan to allow dataset lock in advance according to my
> previous mail and discussion.
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M*
> Email: n.mift...@gmail.com
> Cell:+8801914030574 <+880%201914-030574>
> Skype: nayeem.a.m
>
> On Mon, Dec 5, 2016 at 2:53 PM, Nayeem Al Mifthah <n.mift...@gmail.com>
> wrote:
>
>> Dear Developers
>> Is there any plan to incorporate data lock in advance as we are using
>> data set for planning and need to lock before implementation start.
>>
>> *Nayeem Al Mifthah*
>> *Consultant for HSS, Health MIS, M*
>> Email: n.mift...@gmail.com
>> Cell:+8801914030574 <01914-030574>
>> Skype: nayeem.a.m
>>
>> On Wed, Sep 28, 2016 at 5:24 PM, Jim Grace <j...@dhis2.org> wrote:
>>
>>> Agreed, it would be good if negative values were accepted and processed.
>>> This could be useful for one of our other implementations as well, that I'm
>>> working on.
>>>
>>> Meanwhile, another possibility is to use data approvals to lock out data
>>> entry for the future period. It would involve taking action every time you
>>> want the future data locked, but it would do that. See
>>> http://dhis2.github.io/dhis2-docs/master/en/user/html/da
>>> ta_approvals.html.
>>>
>>>
>>> On Wed, Sep 28, 2016 at 2:12 AM, Nayeem Al Mifthah <n.mift...@gmail.com>
>>> wrote:
>>>
>>>> Dear All
>>>> We are using DHIS2 for planning purposes. For this organizations are
>>>> input plan in advance. We want to lock the dataset in advance.
>>>>
>>>>
>>>> Like now we want to lock the next quarter planning data entry before 15
>>>> days from starting of next quarter. But data lock is not taking negative
>>>> (-) value in dataset design.
>>>>
>>>>
>>>> *Nayeem Al Mifthah*
>>>> *Consultant for HSS, Health MIS, M*
>>>> Email: n.mift...@gmail.com
>>>> Cell:+8801914030574
>>>> Skype: nayeem.a.m
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>
>>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1639529] Re: organisation-unit-closed-date-cannot-be-removed

[Jim Grace]

Thanks for the fix. Yes, I had a wide screen and completely did not see
the "X" for removing the date.

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

Title:
  organisation-unit-closed-date-cannot-be-removed

Status in DHIS:
  Fix Released

Bug description:
  In the 2.25 User Interface, once a closed date has been set for an
  organisation unit, it cannot be removed. Since the closed date field
  is optional, there should be some way to remove it, if it has been set
  accidentally.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1639529/+subscriptions

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

Re: [Dhis2-devs] [Bug 1638551] Re: Category option group set should be optional for approval level

[Jim Grace]

It worked already in 2.24 and earlier. It was just a problem in 2.25 and
trunk.


On Sun, Nov 6, 2016 at 5:19 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Great. Can we back-port to 2.24 as well?
>
>
> On Sun, Nov 6, 2016 at 6:52 AM, Morten Olav Hansen <
> 1638...@bugs.launchpad.net> wrote:
>
> > Should be fixed in 2.25 and master. This was happening due to non-
> > standard property mapping for dataApprovalLevel (which our schema
> > introspector didn't understand). So it was overriden with annotation
> > (@Property), it might have been a bit strict. Relaxed it down to not
> > required now.
> >
> > ** Changed in: dhis2
> >Status: New => Incomplete
> >
> > ** Changed in: dhis2
> >Status: Incomplete => Fix Committed
> >
> > --
> > You received this bug notification because you are a member of DHIS 2
> > developers, which is subscribed to DHIS.
> > https://bugs.launchpad.net/bugs/1638551
> >
> > Title:
> >   Category option group set should be optional for approval level
> >
> > Status in DHIS:
> >   Fix Committed
> >
> > Bug description:
> >   When creating a data approval level under Settings -> Approval in 2.25
> >   and trunk, a category option group set must be specified. This should
> >   be optional, as it was in 2.24 and earlier.
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions
> >
> > ___
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to : dhis2-devs@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org <https://www.dhis2.org/>
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1638551
>
> Title:
>   Category option group set should be optional for approval level
>
> Status in DHIS:
>   Fix Committed
>
> Bug description:
>   When creating a data approval level under Settings -> Approval in 2.25
>   and trunk, a category option group set must be specified. This should
>   be optional, as it was in 2.24 and earlier.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>

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

Title:
  Category option group set should be optional for approval level

Status in DHIS:
  Fix Committed

Bug description:
  When creating a data approval level under Settings -> Approval in 2.25
  and trunk, a category option group set must be specified. This should
  be optional, as it was in 2.24 and earlier.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions

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

Re: [Dhis2-devs] [Bug 1638551] Re: Category option group set should be optional for approval level

[Jim Grace]

Great, thanks!


On Sun, Nov 6, 2016 at 1:52 AM, Morten Olav Hansen <
1638...@bugs.launchpad.net> wrote:

> Should be fixed in 2.25 and master. This was happening due to non-
> standard property mapping for dataApprovalLevel (which our schema
> introspector didn't understand). So it was overriden with annotation
> (@Property), it might have been a bit strict. Relaxed it down to not
> required now.
>
> ** Changed in: dhis2
>Status: New => Incomplete
>
> ** Changed in: dhis2
>Status: Incomplete => Fix Committed
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1638551
>
> Title:
>   Category option group set should be optional for approval level
>
> Status in DHIS:
>   Fix Committed
>
> Bug description:
>   When creating a data approval level under Settings -> Approval in 2.25
>   and trunk, a category option group set must be specified. This should
>   be optional, as it was in 2.24 and earlier.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>

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

Title:
  Category option group set should be optional for approval level

Status in DHIS:
  Fix Committed

Bug description:
  When creating a data approval level under Settings -> Approval in 2.25
  and trunk, a category option group set must be specified. This should
  be optional, as it was in 2.24 and earlier.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions

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

[Dhis2-devs] [Bug 1639529] [NEW] organisation-unit-closed-date-cannot-be-removed

[Jim Grace]

Public bug reported:

In the 2.25 User Interface, once a closed date has been set for an
organisation unit, it cannot be removed. Since the closed date field is
optional, there should be some way to remove it, if it has been set
accidentally.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  organisation-unit-closed-date-cannot-be-removed

Status in DHIS:
  New

Bug description:
  In the 2.25 User Interface, once a closed date has been set for an
  organisation unit, it cannot be removed. Since the closed date field
  is optional, there should be some way to remove it, if it has been set
  accidentally.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1639529/+subscriptions

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

Re: [Dhis2-devs] [Bug 1638551] Re: Category option group set should be optional for approval level

[Jim Grace]

The hibernate mapping and the object definition haven't changed since 2.24.
So something else has changed, maybe the import code? Some third-party
library? Hibernate?


On Fri, Nov 4, 2016 at 1:45 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> I tried making the categoryOptionGroupSet property not-null=true
> explicitly in the hbm but that had no effect. Perhaps it is recognized
> as not-null since its part of a "properties unique="true"" element.
>
> ** Changed in: dhis2
>Importance: Undecided => Medium
>
> ** Changed in: dhis2
>  Assignee: (unassigned) => Morten Olav Hansen (mortenoh)
>
> ** Changed in: dhis2
> Milestone: None => 2.25
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1638551
>
> Title:
>   Category option group set should be optional for approval level
>
> Status in DHIS:
>   New
>
> Bug description:
>   When creating a data approval level under Settings -> Approval in 2.25
>   and trunk, a category option group set must be specified. This should
>   be optional, as it was in 2.24 and earlier.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>

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

Title:
  Category option group set should be optional for approval level

Status in DHIS:
  New

Bug description:
  When creating a data approval level under Settings -> Approval in 2.25
  and trunk, a category option group set must be specified. This should
  be optional, as it was in 2.24 and earlier.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions

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

Re: [Dhis2-devs] Approval levels are failing to save

[Jim Grace]

This has recently been noticed and reported as a new bug at
https://bugs.launchpad.net/dhis2/+bug/1638551. The problem is that an
approval level cannot be saved without specifying a Category option group
set -- which should be optional, not required. One workaround until this is
fixed is that you can create an approval level with a category option group
set, and then patch the approval level's categoryoptiongroupsetid field in
the database to NULL. (Then clear the HIbernate cache or restart Tomcat.)

Also note that the workflow field is missing from edit/create dataset in
2.25. This has been reported at
https://bugs.launchpad.net/dhis2/+bug/1638553. Again, as a workaround you
could patch the workflowid into the dataset record and then clear the
HIbernate cache or restart Tomcat.

Cheers,
Jim


On Fri, Nov 4, 2016 at 8:47 AM, Archana Chillala <archa...@thoughtworks.com>
wrote:

> Hi,
>
> We're using DHIS 2.25. In settings app, we have approvals. When we try to
> create an Approval Level and try to save, he application throws a snack-bar
> message saying "*Failed to save approval level*". Approval levels used to
> get saved in earlier DHIS versions. Could you please look into it.
>
> Please find the screenshot attached.
>
>
>
> *Cheers,*
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Set data approvals with dhis 2.23

[Jim Grace]

n workflow with identical dataset name together with
> Province as approval level only.
>
> Reading from the doc, for the dataset to be approved in same time they
> have to be assigned to the the same  workflow. I did that but while testing
> it this message is displayed " Approval status: Waiting for lower levels
> to approve"  while the workflow assigned to it  has Prov, sub district and
> facilities  as approval levels.
>
> What we want is to have user at province level to approve  data from
> facilities under his supervision  and has possibilities to unlock data for
> specific dataset in given reporting unit
>
>
>
> Has any one experienced this  situation or someone who can provide a hint
>  on how to set this approval?
>
> Regards,
>
>
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> Mobile: +250 788 740 578
> Email:kaa...@gmail.com
> Skype: ka.adolphe
>  RWANDA
>
>
>
> _______
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1638551] Re: Category option group set should be optional for approval level

[Jim Grace]

Note: This is not a problem in the UI, but behind the Web API while
importing the new  data approval level. The UI allows the category
option group set to be left blank, but when POSTing the new approval
level, the following message is returned saying that
categoryOptionGroupSet is a required property. It should be optional:

{"httpStatus":"Conflict","httpStatusCode":409,"status":"WARNING","message":"One
more more errors occurred, please see full details in import
report.","response":{"responseType":"ObjectReport","klass":"org.hisp.dhis.dataapproval.DataApprovalLevel","errorReports":[{"message":"Missing
required property
`categoryOptionGroupSet`.","mainKlass":"org.hisp.dhis.dataapproval.DataApprovalLevel","errorKlass":"org.hisp.dhis.dataelement.CategoryOptionGroupSet","errorCode":"E4000"}],"uid":"dj12KaUnskG"}}

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

Title:
  Category option group set should be optional for approval level

Status in DHIS:
  New

Bug description:
  When creating a data approval level under Settings -> Approval in 2.25
  and trunk, a category option group set must be specified. This should
  be optional, as it was in 2.24 and earlier.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions

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

[Dhis2-devs] [Bug 1638553] [NEW] Approval workflow missing from dataset in the UI

[Jim Grace]

Public bug reported:

In 2.25 and trunk the UI for creating and editing a dataset is missing
the optional field for approval workflow (zero or one workflows may be
chosen). This was present in 2.24 and earlier.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Approval workflow missing from dataset in the UI

Status in DHIS:
  New

Bug description:
  In 2.25 and trunk the UI for creating and editing a dataset is missing
  the optional field for approval workflow (zero or one workflows may be
  chosen). This was present in 2.24 and earlier.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638553/+subscriptions

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

Re: [Dhis2-devs] Configuration of approvals in 2.25

[Jim Grace]

Got it. I've created two new bug reports for these problems:

https://bugs.launchpad.net/dhis2/+bug/1638551

https://bugs.launchpad.net/dhis2/+bug/1638553


On Wed, Nov 2, 2016 at 2:59 AM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> Hi Jim,
> Not sure what happened to the image, but its not really important.
>
> My workaround was to basically to
>
> 1) Create a category option group set  with type attribute (I did not have
> any)
> 2) Create the approval levels and approval workflow using that category
> option group set through the UI.
> 3) Update the dataapproval table manually
>
> UPDATE dataapprovallevel set categoryoptiongroupsetid = NULL;
>
> 4) Adjust the dataset to use the workflow I created. I had to do this with
> SQL as well, as the UI did not work for me for some reason.
>
> After all of that, it seems to work (for those who need a work around!)
>
> Regards,
> Jason
>
>
> On Tue, Nov 1, 2016 at 8:07 PM, Jim Grace <j...@dhis2.org> wrote:
>
>> Hi Jason,
>>
>> Your image didn't come through; it was a broken link image.
>>
>> When I create or edit a dataset through the 2.25 UI, I can't find a place
>> to select the workflow. (It was there in 2.23 and 2.24.) So I'm not sure
>> what you mean by "added the workflow to the dataset which needs approval
>> through the UI". But glad you got something working.
>>
>> Cheers,
>> Jim
>>
>>
>> On Tue, Nov 1, 2016 at 9:24 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>>
>>> Hi Jim,
>>>
>>> ​I think i did that actually. Have a look at these three tables.
>>>
>>>
>>> ​
>>>
>>> After making those adjustments, and clearing the application cache, i
>>> went to data approvals, but nothing appeared there, even though I had added
>>> the workflow to the dataset which needs approval through the UI. However,
>>> after checking in the database, it seems the UI did nothing actually. After
>>> adding the workflow via SQL, it seems to work.
>>>
>>> Seems like a series of bugs really, but I guess I did manage to find a
>>> workaround.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>> On Tue, Nov 1, 2016 at 12:52 PM, Jim Grace <j...@dhis2.org> wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> 1. After you patched dataapprovallevel.categoryoptiongroupsetid to
>>>> NULL in the DB, subsequently could you view the approval level with no cat
>>>> option combo in the edit approval level screen?
>>>>
>>>> 2. In order to approve a dataset, you need to create an approval
>>>> workflow, assign one or more approval levels to it, and then assign the
>>>> workflow to one or more datasets (the other bug I mentioned -- you may have
>>>> to patch the workflowid column in the dataset record.)
>>>>
>>>> Cheers,
>>>> Jim
>>>>
>>>>
>>>> On Tue, Nov 1, 2016 at 8:40 AM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> I tried that actually but could not get any data-sets to appear in the
>>>>> approvals dialog.
>>>>>
>>>>> I even tried to create a "Default category option group set",
>>>>> containing only the "default" category option, but that did not work
>>>>> either.
>>>>>
>>>>> Neither hack worked.
>>>>>
>>>>> Unfortunately, we cannot go back to 2.24 at this point, but can wait
>>>>> for this to be fixed to implement the approvals.
>>>>>
>>>>> Thanks for looking into it.
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>> On Tue, Nov 1, 2016 at 12:31 PM, Jim Grace <j...@dhis2.org> wrote:
>>>>>
>>>>>> Lars, should I create bug reports for these two 2.25
>>>>>> approvals-related problems?
>>>>>>
>>>>>> Jason, you could use 2.24, or you could try defining an approval
>>>>>> level with a cat option group set, then find that record in the
>>>>>> dataapprovallevel table and patch the categoryoptiongroupsetid column to
>>>>>> null (and flush the hibernate cache.)
>>>>>>
>>>>>>
>>>>>> On Tue, Nov 1, 2016 at 5:04 

[Dhis2-devs] [Bug 1638551] [NEW] Category option group set should be optional for approval level

[Jim Grace]

Public bug reported:

When creating a data approval level under Settings -> Approval in 2.25
and trunk, a category option group set must be specified. This should be
optional, as it was in 2.24 and earlier.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Category option group set should be optional for approval level

Status in DHIS:
  New

Bug description:
  When creating a data approval level under Settings -> Approval in 2.25
  and trunk, a category option group set must be specified. This should
  be optional, as it was in 2.24 and earlier.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1638551/+subscriptions

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

Re: [Dhis2-devs] Configuration of approvals in 2.25

[Jim Grace]

Hi Jason,

Your image didn't come through; it was a broken link image.

When I create or edit a dataset through the 2.25 UI, I can't find a place
to select the workflow. (It was there in 2.23 and 2.24.) So I'm not sure
what you mean by "added the workflow to the dataset which needs approval
through the UI". But glad you got something working.

Cheers,
Jim


On Tue, Nov 1, 2016 at 9:24 AM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

>
> Hi Jim,
>
> ​I think i did that actually. Have a look at these three tables.
>
>
> ​
>
> After making those adjustments, and clearing the application cache, i went
> to data approvals, but nothing appeared there, even though I had added the
> workflow to the dataset which needs approval through the UI. However, after
> checking in the database, it seems the UI did nothing actually. After
> adding the workflow via SQL, it seems to work.
>
> Seems like a series of bugs really, but I guess I did manage to find a
> workaround.
>
> Regards,
> Jason
>
>
>
>
>
> On Tue, Nov 1, 2016 at 12:52 PM, Jim Grace <j...@dhis2.org> wrote:
>
>> Hi Jason,
>>
>> 1. After you patched dataapprovallevel.categoryoptiongroupsetid to NULL
>> in the DB, subsequently could you view the approval level with no cat
>> option combo in the edit approval level screen?
>>
>> 2. In order to approve a dataset, you need to create an approval
>> workflow, assign one or more approval levels to it, and then assign the
>> workflow to one or more datasets (the other bug I mentioned -- you may have
>> to patch the workflowid column in the dataset record.)
>>
>> Cheers,
>> Jim
>>
>>
>> On Tue, Nov 1, 2016 at 8:40 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> I tried that actually but could not get any data-sets to appear in the
>>> approvals dialog.
>>>
>>> I even tried to create a "Default category option group set", containing
>>> only the "default" category option, but that did not work either.
>>>
>>> Neither hack worked.
>>>
>>> Unfortunately, we cannot go back to 2.24 at this point, but can wait for
>>> this to be fixed to implement the approvals.
>>>
>>> Thanks for looking into it.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Tue, Nov 1, 2016 at 12:31 PM, Jim Grace <j...@dhis2.org> wrote:
>>>
>>>> Lars, should I create bug reports for these two 2.25 approvals-related
>>>> problems?
>>>>
>>>> Jason, you could use 2.24, or you could try defining an approval level
>>>> with a cat option group set, then find that record in the dataapprovallevel
>>>> table and patch the categoryoptiongroupsetid column to null (and flush the
>>>> hibernate cache.)
>>>>
>>>>
>>>> On Tue, Nov 1, 2016 at 5:04 AM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> Hi Jim and Lars,
>>>>>
>>>>> Has this been solved, or is there a workaround which I can use?
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>> On Tue, Oct 25, 2016 at 12:59 PM, Jim Grace <j...@dhis2.org> wrote:
>>>>>
>>>>>> I get the same results. In 2.24 and earlier I am able to save a new
>>>>>> approval level with no category option group set. But 2.25 does not allow
>>>>>> me to do so.
>>>>>>
>>>>>> Note that this is not related to the new category combination field
>>>>>> that we will be adding to approval workflows in 2.26. This has always 
>>>>>> been
>>>>>> an optional field for approval levels.
>>>>>>
>>>>>> Also in 2.25 when adding or updating a data set, there is no field
>>>>>> for data approval workflow. It was there in 2.24.
>>>>>>
>>>>>>
>>>>>> On Tue, Oct 25, 2016 at 2:03 AM, Jason Pickering <
>>>>>> jason.p.picker...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Lars,
>>>>>>>
>>>>>>> Here is the info you asked for.
>>>>>>>
>>>>>>> Version:2.25Build revision:8e07d2fBuild date:2016-10-17 06:38
>>>>>>>
>>>>>>> Regards,
>>>>>>> Jason
>>>>>>>
>>

Re: [Dhis2-devs] Configuration of approvals in 2.25

[Jim Grace]

Hi Jason,

1. After you patched dataapprovallevel.categoryoptiongroupsetid to NULL in
the DB, subsequently could you view the approval level with no cat option
combo in the edit approval level screen?

2. In order to approve a dataset, you need to create an approval workflow,
assign one or more approval levels to it, and then assign the workflow to
one or more datasets (the other bug I mentioned -- you may have to patch
the workflowid column in the dataset record.)

Cheers,
Jim


On Tue, Nov 1, 2016 at 8:40 AM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> I tried that actually but could not get any data-sets to appear in the
> approvals dialog.
>
> I even tried to create a "Default category option group set", containing
> only the "default" category option, but that did not work either.
>
> Neither hack worked.
>
> Unfortunately, we cannot go back to 2.24 at this point, but can wait for
> this to be fixed to implement the approvals.
>
> Thanks for looking into it.
>
> Regards,
> Jason
>
>
> On Tue, Nov 1, 2016 at 12:31 PM, Jim Grace <j...@dhis2.org> wrote:
>
>> Lars, should I create bug reports for these two 2.25 approvals-related
>> problems?
>>
>> Jason, you could use 2.24, or you could try defining an approval level
>> with a cat option group set, then find that record in the dataapprovallevel
>> table and patch the categoryoptiongroupsetid column to null (and flush the
>> hibernate cache.)
>>
>>
>> On Tue, Nov 1, 2016 at 5:04 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Jim and Lars,
>>>
>>> Has this been solved, or is there a workaround which I can use?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Tue, Oct 25, 2016 at 12:59 PM, Jim Grace <j...@dhis2.org> wrote:
>>>
>>>> I get the same results. In 2.24 and earlier I am able to save a new
>>>> approval level with no category option group set. But 2.25 does not allow
>>>> me to do so.
>>>>
>>>> Note that this is not related to the new category combination field
>>>> that we will be adding to approval workflows in 2.26. This has always been
>>>> an optional field for approval levels.
>>>>
>>>> Also in 2.25 when adding or updating a data set, there is no field for
>>>> data approval workflow. It was there in 2.24.
>>>>
>>>>
>>>> On Tue, Oct 25, 2016 at 2:03 AM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> Hi Lars,
>>>>>
>>>>> Here is the info you asked for.
>>>>>
>>>>> Version:2.25Build revision:8e07d2fBuild date:2016-10-17 06:38
>>>>>
>>>>> Regards,
>>>>> Jason
>>>>>
>>>>>
>>>>> On Tue, Oct 25, 2016 at 4:58 AM, Lars Helge Øverland <l...@dhis2.org>
>>>>> wrote:
>>>>>
>>>>>> Hi Jason,
>>>>>>
>>>>>> could you tell us the exact build date for this WAR file?
>>>>>>
>>>>>> Could you also try again with the latest 2.25 WAR build?
>>>>>>
>>>>>> We have introduced this property "categoryOptionGroupSet" in master,
>>>>>> but should not be there in 2.25.
>>>>>>
>>>>>> regards,
>>>>>>
>>>>>> Lars
>>>>>>
>>>>>>
>>>>>> On Sun, Oct 23, 2016 at 12:32 AM, Jason Pickering <
>>>>>> jason.p.picker...@gmail.com> wrote:
>>>>>>
>>>>>>> I am trying to configure a workflow for population projections in
>>>>>>> 2.25.
>>>>>>> First, I created a new approval worfklow called "Population" with a
>>>>>>> yearly frequency.
>>>>>>>
>>>>>>>
>>>>>>> I  then created a new approval level in the UI like this
>>>>>>>
>>>>>>> [image: Inline image 1]
>>>>>>>
>>>>>>> We are not using and category options here. In the logs I see:
>>>>>>>
>>>>>>> * INFO  2016-10-23 06:27:23,519 (admin) Import:Start
>>>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>>>>>> * INFO  2016-10-23 06:27:23,860 (admin) Import:Preheat[REFERENCE]
>>>>>

Re: [Dhis2-devs] Configuration of approvals in 2.25

[Jim Grace]

Lars, should I create bug reports for these two 2.25 approvals-related
problems?

Jason, you could use 2.24, or you could try defining an approval level with
a cat option group set, then find that record in the dataapprovallevel
table and patch the categoryoptiongroupsetid column to null (and flush the
hibernate cache.)


On Tue, Nov 1, 2016 at 5:04 AM, Jason Pickering <jason.p.picker...@gmail.com
> wrote:

> Hi Jim and Lars,
>
> Has this been solved, or is there a workaround which I can use?
>
> Regards,
> Jason
>
>
> On Tue, Oct 25, 2016 at 12:59 PM, Jim Grace <j...@dhis2.org> wrote:
>
>> I get the same results. In 2.24 and earlier I am able to save a new
>> approval level with no category option group set. But 2.25 does not allow
>> me to do so.
>>
>> Note that this is not related to the new category combination field that
>> we will be adding to approval workflows in 2.26. This has always been an
>> optional field for approval levels.
>>
>> Also in 2.25 when adding or updating a data set, there is no field for
>> data approval workflow. It was there in 2.24.
>>
>>
>> On Tue, Oct 25, 2016 at 2:03 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Lars,
>>>
>>> Here is the info you asked for.
>>>
>>> Version:2.25Build revision:8e07d2fBuild date:2016-10-17 06:38
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Tue, Oct 25, 2016 at 4:58 AM, Lars Helge Øverland <l...@dhis2.org>
>>> wrote:
>>>
>>>> Hi Jason,
>>>>
>>>> could you tell us the exact build date for this WAR file?
>>>>
>>>> Could you also try again with the latest 2.25 WAR build?
>>>>
>>>> We have introduced this property "categoryOptionGroupSet" in master,
>>>> but should not be there in 2.25.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>> On Sun, Oct 23, 2016 at 12:32 AM, Jason Pickering <
>>>> jason.p.picker...@gmail.com> wrote:
>>>>
>>>>> I am trying to configure a workflow for population projections in
>>>>> 2.25.
>>>>> First, I created a new approval worfklow called "Population" with a
>>>>> yearly frequency.
>>>>>
>>>>>
>>>>> I  then created a new approval level in the UI like this
>>>>>
>>>>> [image: Inline image 1]
>>>>>
>>>>> We are not using and category options here. In the logs I see:
>>>>>
>>>>> * INFO  2016-10-23 06:27:23,519 (admin) Import:Start
>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:23,860 (admin) Import:Preheat[REFERENCE] took
>>>>> 0.33 seconds (DefaultPreheatService.java [http-bio-127.0.0.1-8090-exec-
>>>>> 4])
>>>>> * INFO  2016-10-23 06:27:23,864 (admin) Import:Validation took 0.00
>>>>> seconds (DefaultObjectBundleValidationService.java
>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:23,890 (admin) Creating 1 object(s) of type
>>>>> DataApprovalWorkflow (DefaultObjectBundleService.java
>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:24,067 (admin) Import:Commit took 0.20
>>>>> seconds (DefaultMetadataImportService.java
>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:24,067 (admin) Import:Done took 0.55 seconds
>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:39,034 (admin) Import:Start
>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:40,309 (admin) Import:Preheat[REFERENCE] took
>>>>> 1.27 seconds (DefaultPreheatService.java [http-bio-127.0.0.1-8090-exec-
>>>>> 4])
>>>>> * INFO  2016-10-23 06:27:40,314 (admin) Import:Validation took 0.00
>>>>> seconds (DefaultObjectBundleValidationService.java
>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>> * INFO  2016-10-23 06:27:40,314 (admin) Import:Done took 1.28 seconds
>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>>>>
>>>>> which seems to be OK, but in the UI, I get a message that creation of
>>>>> the ap

Re: [Dhis2-devs] [Dhis2-users] Fwd: complex category combo for Datasets doesn't show outputs

[Jim Grace]

Hi Deepali,

I haven't tried this, but I believe there is no problem in including the
same donors in both the Donor 1 list and the Donor 2 list.

However Donor 1 and Donor 2 will be treated as different dimensions. I
don't think that you can get a report that combines the data from when ECHO
is chosen as Donor 1 together with the data from when ECHO is chosen as
Donor 2. I expect this to be a major limitation to this approach.

If you can use approach (2) or (3), these should give you a better display
of data in analytics.

Cheers,
Jim


On Wed, Oct 26, 2016 at 1:41 PM, Dipali Sahu <dipali.s...@gmail.com> wrote:

> Hi Jim
>
> Thank you so much for the insight, I am going to test the scenarios you
> have provided.
>
> Another question I have is, when I have 2 donor fields/dimensions in data
> entry, I understand that the category options i.e. the donor list should
> have mutually exclusive names. for example Donor 1 has ECHO and UNHCR and
> Donor 2 had WHO and UNICEF. what happens if i have common items in both the
> list, for example Donor 1 list has ECHO, UNHCR, WHO, UNICEF and Donor 2 has
> the same items as well i.e. ECHO, UNHCR, WHO, UNICEF.
>
> When I enter data in such a scenario will DHIS2 show reports show valid
> numbers.. because for example ECHO will be the same category option , will
> DHSI2 be able to recognize whether ECHO is from donor 1 or from donor 2?
>
> This looks like a really complicated use case to me.. but I am wondering
> with native DHIS2 can handle this without any custom coding hence so many
> questions :)
>
> Thank you
> Deepali
>
> On Wed, Oct 26, 2016 at 3:55 PM, Jim Grace <j...@dhis2.org> wrote:
>
>> Hi Dipali Sahu,
>>
>> I'm sorry for not responding sooner. Thank you for following up.
>>
>> From your screen shot, it looks like you have a dataset-assigned category
>> combination of four categories: Donor 1, CMR Project 1, Donor 2, and CMR
>> Project 2. DHIS 2 will treat these as four independent dimensions. The data
>> you record for any combination of all four dimensions will only show again
>> in data entry if you select all four of the same dimensions. I would expect
>> that when you select all four of the values "ECHO", "ECHO 7654", "UNHCR",
>> and "UNHCR 1212", you will see data that you entered the last time you
>> selected this distinct combination of four values.
>>
>> Without knowing more about your situation, I am not sure the best way to
>> model your requirements. Here are some possibilities:
>>
>> 1. Use a category combination with two categories such as "Project 1" and
>> "Project 2". Each project could have options such as "ECHO 7654", UNHCR
>> 1212", etc. If you want to report in analytics by the donor funding the
>> projects, you could have a category option group set called "donor"
>> containing category option groups like "ECHO" and "UNHCR". The "ECHO"
>> category option group could contain all the "ECHO " category options,
>> and the "UNHCR" category option group could contain all the "UNHCR "
>> category options.
>>
>> Notes:
>> - As with your current example of four dimensions, you will see data in
>> the data entry screen only if you select the same set of category options
>> that you selected originally when you entered the data.
>>
>> - You must always select two projects, no more and no less. If data is
>> attributable to one project only, you may have to have "None" as the option
>> for the other project.
>>
>> - The dimensions "Project 1" and "Project 2" will be two different
>> dimensions in analytics. There may not be an easy way in analytics to see
>> all the data attributed to the same project, if that project is sometimes
>> selected under "Project 1" and sometimes under "Project 2".
>>
>> 2. Use a category combination with one category "Projects". Its category
>> options will have every combination of projects that can be done together
>> (if this is practical). For example one option could be ""ECHO 7654 and
>> UNHCR 1212". Another could be "ECHO 7654 and ABCD 1234". You can also have
>> options for more or less than two projects, for example "ECHO 7654 and
>> UNHCR 1212 and ABCD 1234", or "ECHO 7654". You can define a category option
>> group set "Project" whose groups are "ECHO 7654", "UNHCR 1212", "ABCD
>> 1234", etc. You can assign to each of these groups the "Projects" o

Re: [Dhis2-devs] [Dhis2-users] Fwd: complex category combo for Datasets doesn't show outputs

[Jim Grace]

Hi Dipali Sahu,

I'm sorry for not responding sooner. Thank you for following up.

>From your screen shot, it looks like you have a dataset-assigned category
combination of four categories: Donor 1, CMR Project 1, Donor 2, and CMR
Project 2. DHIS 2 will treat these as four independent dimensions. The data
you record for any combination of all four dimensions will only show again
in data entry if you select all four of the same dimensions. I would expect
that when you select all four of the values "ECHO", "ECHO 7654", "UNHCR",
and "UNHCR 1212", you will see data that you entered the last time you
selected this distinct combination of four values.

Without knowing more about your situation, I am not sure the best way to
model your requirements. Here are some possibilities:

1. Use a category combination with two categories such as "Project 1" and
"Project 2". Each project could have options such as "ECHO 7654", UNHCR
1212", etc. If you want to report in analytics by the donor funding the
projects, you could have a category option group set called "donor"
containing category option groups like "ECHO" and "UNHCR". The "ECHO"
category option group could contain all the "ECHO " category options,
and the "UNHCR" category option group could contain all the "UNHCR "
category options.

Notes:
- As with your current example of four dimensions, you will see data in the
data entry screen only if you select the same set of category options that
you selected originally when you entered the data.

- You must always select two projects, no more and no less. If data is
attributable to one project only, you may have to have "None" as the option
for the other project.

- The dimensions "Project 1" and "Project 2" will be two different
dimensions in analytics. There may not be an easy way in analytics to see
all the data attributed to the same project, if that project is sometimes
selected under "Project 1" and sometimes under "Project 2".

2. Use a category combination with one category "Projects". Its category
options will have every combination of projects that can be done together
(if this is practical). For example one option could be ""ECHO 7654 and
UNHCR 1212". Another could be "ECHO 7654 and ABCD 1234". You can also have
options for more or less than two projects, for example "ECHO 7654 and
UNHCR 1212 and ABCD 1234", or "ECHO 7654". You can define a category option
group set "Project" whose groups are "ECHO 7654", "UNHCR 1212", "ABCD
1234", etc. You can assign to each of these groups the "Projects" options
that include that group. You can have another category option group set
"Donor" whose groups are "ECHO", "UNHCR", "ABCD", etc., and you can assign
to each of these groups the "Projects" options that include that donor.

Note:
- You will see data in the data entry screen only if you select the same
category option under which you entered the data. So for example if you
enter data under "ECHO 7654 and ABCD 1234", you will not see this data in
the data entry screen if you select the category option "ECHO 7654".

3. Use a category combination with one category "Project" that contains
only single projects: "ECHO 7654", "UNHCR 1212", "ABCD 1234", etc. If data
counts for more than one project, it must be entered multiple times, once
for each project. You can have a category option group set "Donor" whose
groups are "ECHO", "UNHCR", "ABCD", etc., and you can assign to each of
these groups the "Project" options that include that donor.

Note that with all these possibilities, you may have the problem of
overcounting in analytics. If data is attributed to multiple projects, then
if you use analytics to display the total across all projects, some data
will be counted multiple times towards that total. There is at least one
implementation of DHIS 2 where this is handled by creating an extra project
called something like "deduplication", which contains negative numbers so
that the total across all projects is not overcounted.

Note that you can use the sharing feature for category options and category
option groups, so that you can restrict which users may enter data for
which category options, and see which data for category option groups in
analytics. For example, you might have some users who are authorized to
enter and/or view only UNHCR data. Also if you have a "deduplication"
category option, this might not be available to most users. You could even
write custom software that uses the Web API to set the deduplication values
based on other va

Re: [Dhis2-devs] Configuration of approvals in 2.25

[Jim Grace]

I get the same results. In 2.24 and earlier I am able to save a new
approval level with no category option group set. But 2.25 does not allow
me to do so.

Note that this is not related to the new category combination field that we
will be adding to approval workflows in 2.26. This has always been an
optional field for approval levels.

Also in 2.25 when adding or updating a data set, there is no field for data
approval workflow. It was there in 2.24.


On Tue, Oct 25, 2016 at 2:03 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Lars,
>
> Here is the info you asked for.
>
> Version:2.25Build revision:8e07d2fBuild date:2016-10-17 06:38
>
> Regards,
> Jason
>
>
> On Tue, Oct 25, 2016 at 4:58 AM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi Jason,
>>
>> could you tell us the exact build date for this WAR file?
>>
>> Could you also try again with the latest 2.25 WAR build?
>>
>> We have introduced this property "categoryOptionGroupSet" in master, but
>> should not be there in 2.25.
>>
>> regards,
>>
>> Lars
>>
>>
>> On Sun, Oct 23, 2016 at 12:32 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> I am trying to configure a workflow for population projections in 2.25.
>>> First, I created a new approval worfklow called "Population" with a
>>> yearly frequency.
>>>
>>>
>>> I  then created a new approval level in the UI like this
>>>
>>> [image: Inline image 1]
>>>
>>> We are not using and category options here. In the logs I see:
>>>
>>> * INFO  2016-10-23 06:27:23,519 (admin) Import:Start
>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:23,860 (admin) Import:Preheat[REFERENCE] took
>>> 0.33 seconds (DefaultPreheatService.java [http-bio-127.0.0.1-8090-exec-
>>> 4])
>>> * INFO  2016-10-23 06:27:23,864 (admin) Import:Validation took 0.00
>>> seconds (DefaultObjectBundleValidationService.java
>>> [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:23,890 (admin) Creating 1 object(s) of type
>>> DataApprovalWorkflow (DefaultObjectBundleService.java
>>> [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:24,067 (admin) Import:Commit took 0.20 seconds
>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:24,067 (admin) Import:Done took 0.55 seconds
>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:39,034 (admin) Import:Start
>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:40,309 (admin) Import:Preheat[REFERENCE] took
>>> 1.27 seconds (DefaultPreheatService.java [http-bio-127.0.0.1-8090-exec-
>>> 4])
>>> * INFO  2016-10-23 06:27:40,314 (admin) Import:Validation took 0.00
>>> seconds (DefaultObjectBundleValidationService.java
>>> [http-bio-127.0.0.1-8090-exec-4])
>>> * INFO  2016-10-23 06:27:40,314 (admin) Import:Done took 1.28 seconds
>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-4])
>>>
>>> which seems to be OK, but in the UI, I get a message that creation of
>>> the approval level failed and in the JS console I see
>>>
>>> {"httpStatus":"Conflict","httpStatusCode":409,"status":"WARNING","message":"One
>>> more more errors occurred, please see full details in import
>>> report.","response":{"responseType":"ObjectReport","uid":"AD
>>> Od9xfvDjH","klass":"org.hisp.dhis.dataapproval.DataApproval
>>> Level","errorReports":[{"message":"Missing required property
>>> `categoryOptionGroupSet`.","mainKlass":"org.hisp.dhis.dataap
>>> proval.DataApprovalLevel","errorKlass":"org.hisp.dhis.datael
>>> ement.CategoryOptionGroupSet","errorCode":"E4000"}]}}
>>>
>>> So, I guess the question is, how do I configure a data approval workflow
>>> with no category option group?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049
>>>
>>> ___
>>> Mailing l

Re: [Dhis2-devs] [Dhis2-users] Lock Data set in advance

[Jim Grace]

Agreed, it would be good if negative values were accepted and processed.
This could be useful for one of our other implementations as well, that I'm
working on.

Meanwhile, another possibility is to use data approvals to lock out data
entry for the future period. It would involve taking action every time you
want the future data locked, but it would do that. See
http://dhis2.github.io/dhis2-docs/master/en/user/html/data_approvals.html.


On Wed, Sep 28, 2016 at 2:12 AM, Nayeem Al Mifthah <n.mift...@gmail.com>
wrote:

> Dear All
> We are using DHIS2 for planning purposes. For this organizations are input
> plan in advance. We want to lock the dataset in advance.
>
>
> Like now we want to lock the next quarter planning data entry before 15
> days from starting of next quarter. But data lock is not taking negative
> (-) value in dataset design.
>
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M*
> Email: n.mift...@gmail.com
> Cell:+8801914030574
> Skype: nayeem.a.m
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1627155] [NEW] Duplicate dataElementDimensions entry in schema

[Jim Grace]

Public bug reported:

When browsing the schema, such as through
https://play.dhis2.org/demo/api/resources, the entry "Data Element
Dimensions" appears twice.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Duplicate dataElementDimensions entry in schema

Status in DHIS:
  New

Bug description:
  When browsing the schema, such as through
  https://play.dhis2.org/demo/api/resources, the entry "Data Element
  Dimensions" appears twice.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1627155/+subscriptions

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

Re: [Dhis2-devs] [Bug 1618147] Re: Web API PATCH not working

[Jim Grace]

You're right. As you can see in my first example, I did a PATCH to /demo
but GET /dev. Sorry about that! Thanks!


On Tue, Aug 30, 2016 at 5:40 PM, Halvdan Hoem Grelland <halv...@dhis2.org>
wrote:

> Jim,
>
> Your example works completely fine. The name is getting changed.
>
> On Tue, Aug 30, 2016 at 2:47 PM, Jim Grace <1618...@bugs.launchpad.net>
> wrote:
>
>> Thanks, Morten.
>>
>> I've tried it without the /name, and it still doesn't change the name,
>> e.g.:
>>
>> curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
>> application/json" -u admin:district
>> https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD
>>
>> I've also tried putting the "id" field into the payload, but also the
>> name doesn't change:
>>
>> curl -X PATCH -d '{"id": "fbfJHSPpUQD", "name": "New Name"}' -H
>> "Content-Type: application/json" -u admin:district
>> https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1618147
>>
>> Title:
>>   Web API PATCH not working
>>
>> Status in DHIS:
>>   New
>>
>> Bug description:
>>   I can't get Web API PATCH to work in 2.24 they way I can in 2.21. The
>>   following commands do not change the names of the referenced
>>   dataElement or dataSet:
>>
>>   curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
>>   application/json" -u admin:district
>>   https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD/name
>>
>>   curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
>>   application/json" -u admin:district
>>   https://play.dhis2.org/dev/api/24/dataSets/lyLU2wR22tC/name
>>
>>   As can be seen by these GETs:
>>
>>   curl -u admin:district
>>   https://play.dhis2.org/demo/api/24/dataElements/fbfJHSPpUQD?
>> fields=id,name
>>
>>   curl -u admin:district
>>   https://play.dhis2.org/demo/api/24/dataSets/lyLU2wR22tC?fields=id,name
>>
>>   The same kind of syntax on a local 2.21 system works fine (without the
>>   /24).
>>
>>   This is following up a problem reported to me in 2.23, so please
>>   backport if appropriate. Also please check to see if this should be
>>   backported to 2.22.
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1618147/+subscriptions
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Halvdan Hoem Grelland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1618147] Re: Web API PATCH not working

[Jim Grace]

Thanks, Morten.

I've tried it without the /name, and it still doesn't change the name,
e.g.:

curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
application/json" -u admin:district
https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD

I've also tried putting the "id" field into the payload, but also the
name doesn't change:

curl -X PATCH -d '{"id": "fbfJHSPpUQD", "name": "New Name"}' -H
"Content-Type: application/json" -u admin:district
https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD

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

Title:
  Web API PATCH not working

Status in DHIS:
  New

Bug description:
  I can't get Web API PATCH to work in 2.24 they way I can in 2.21. The
  following commands do not change the names of the referenced
  dataElement or dataSet:

  curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
  application/json" -u admin:district
  https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD/name

  curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
  application/json" -u admin:district
  https://play.dhis2.org/dev/api/24/dataSets/lyLU2wR22tC/name

  As can be seen by these GETs:

  curl -u admin:district
  https://play.dhis2.org/demo/api/24/dataElements/fbfJHSPpUQD?fields=id,name

  curl -u admin:district
  https://play.dhis2.org/demo/api/24/dataSets/lyLU2wR22tC?fields=id,name

  The same kind of syntax on a local 2.21 system works fine (without the
  /24).

  This is following up a problem reported to me in 2.23, so please
  backport if appropriate. Also please check to see if this should be
  backported to 2.22.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1618147/+subscriptions

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

[Dhis2-devs] [Bug 1618147] [NEW] Web API PATCH not working

[Jim Grace]

Public bug reported:

I can't get Web API PATCH to work in 2.24 they way I can in 2.21. The
following commands do not change the names of the referenced dataElement
or dataSet:

curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
application/json" -u admin:district
https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD/name

curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
application/json" -u admin:district
https://play.dhis2.org/dev/api/24/dataSets/lyLU2wR22tC/name

As can be seen by these GETs:

curl -u admin:district
https://play.dhis2.org/demo/api/24/dataElements/fbfJHSPpUQD?fields=id,name

curl -u admin:district
https://play.dhis2.org/demo/api/24/dataSets/lyLU2wR22tC?fields=id,name

The same kind of syntax on a local 2.21 system works fine (without the
/24).

This is following up a problem reported to me in 2.23, so please
backport if appropriate. Also please check to see if this should be
backported to 2.22.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Web API PATCH not working

Status in DHIS:
  New

Bug description:
  I can't get Web API PATCH to work in 2.24 they way I can in 2.21. The
  following commands do not change the names of the referenced
  dataElement or dataSet:

  curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
  application/json" -u admin:district
  https://play.dhis2.org/dev/api/24/dataElements/fbfJHSPpUQD/name

  curl -X PATCH -d '{"name": "New Name"}' -H "Content-Type:
  application/json" -u admin:district
  https://play.dhis2.org/dev/api/24/dataSets/lyLU2wR22tC/name

  As can be seen by these GETs:

  curl -u admin:district
  https://play.dhis2.org/demo/api/24/dataElements/fbfJHSPpUQD?fields=id,name

  curl -u admin:district
  https://play.dhis2.org/demo/api/24/dataSets/lyLU2wR22tC?fields=id,name

  The same kind of syntax on a local 2.21 system works fine (without the
  /24).

  This is following up a problem reported to me in 2.23, so please
  backport if appropriate. Also please check to see if this should be
  backported to 2.22.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1618147/+subscriptions

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

Re: [Dhis2-devs] thomas lindsjørn joins as android developer

[Jim Grace]

Hi Thomas, welcome!


On Tue, May 24, 2016 at 3:13 PM, Knut Staring <knu...@gmail.com> wrote:

> Welcome Thomas!
>
> Knut
> On 24 May 2016 9:09 p.m., "Lars Helge Øverland" <l...@dhis2.org> wrote:
>
>> Hi all,
>>
>> Thomas Lindsjørn has joined the DHIS 2 team as Android developer. Thomas
>> has 4 years of experience developing Android applications within public
>> transport, sports and finance. He has been involved with architecture, UX
>> design, programming and testing.
>>
>> We with him a warm welcome to the team.
>>
>>
>> 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-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> _______
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs-core] DHIS2 demo admin password

[Jim Grace]

Sounds reasonable to me.


On Mon, May 23, 2016 at 1:16 PM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Increasingly people change the password of the demo server.
>
> Can we put a database trigger in place to prevent this from being changed?
> It causes problems for people in general.
>
> Regards,
> Jason
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
> --
> Mailing list: https://launchpad.net/~dhis2-devs-core
> Post to : dhis2-devs-core@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs-core
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
-- 
Mailing list: https://launchpad.net/~dhis2-devs-core
Post to : dhis2-devs-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs-core
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Patch for DataApprovalWorkflow migrations from v2.19 to v2.22

[Jim Grace]

Hi Hari/Jhansi,

Thank you for alerting us to this. We had fixed this problem in trunk, but
somehow we missed applying the fix to 2.22. This has now been done:

Trunk:
http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/revision/21831
2.22: http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/2.22/revision/22049

I apologize that we missed applying this fix at the time to 2.22, but
appreciate you bringing this to our attention.

Cheers,
Jim

On Tue, May 17, 2016 at 2:45 AM, jhansi <jhans...@thoughtworks.com> wrote:

> Hi Dhis2-devs,
>
> After upgrading DHIS from 2.19 to 2.22, we found an issue in the new data
> approval workflows, where we noticed that few of the data approval workflow
> uids are not generated properly (some uids are lesser than 11 characters).
> Digging little deeper into the code, we found the root cause of the issue
> is in the migration script for upgrading to dataApprovalWorkflow.
>
> We have patched it on one of our own branches of DHIS until the fix is
> merged into DHIS2. Please find the patch on Launchpad at:
> http://bazaar.launchpad.net/~tw-msf/dhis2/v222_api_patch/revision/21956
>
> The diff has also been attached below.
>
> Thanks,
> Hari/Jhansi
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Issue with Aprrovals

[Jim Grace]

See earlier in this thread:

Note that the data approval report asks you to select a dataset, as it has
> in the past. But starting with version 2.22 what is approved by this report
> is actually the workflow associated with that dataset -- so it also
> approves data for any other datasets that may be attached to that same
> workflow. At some point we will likely be updating the data approval
> report so you select a workflow instead of a dataset. We are also in the
> process of updating all the user interface to the new app format -- we
> might do these two at the same time.


If you approve any one of the datasets in a workflow through the UI, it
approves all of the datasets in the workflow. We will fix this in the
future so that you select the workflow instead of the dataset.

Cheers,
Jim


On Mon, May 16, 2016 at 9:30 AM, Archana Chillala <archa...@thoughtworks.com
> wrote:

> Hi Jim,
>
> As you mentioned in the mail, that several data sets can be approved
> together by approving a workflow. How can that be done on the UI?
> Currently, on the demo server, we have to select a data set and reporting
> period to get the data for approval. And for different data sets, we have
> to make several selections. There is no select by workflow as of now. Any
> thoughts?
>
> Thanks,
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator>
>
> On Mon, May 16, 2016 at 12:22 PM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
>> Hi Jim,
>>
>> Thanks for all the information. It was very valuable. We will get back to
>> you with inputs on how we would like data synchronisation and approvals to
>> work together.
>>
>>
>> *Cheers*
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator>
>>
>> On Fri, May 13, 2016 at 11:41 AM, Archana Chillala <
>> archa...@thoughtworks.com> wrote:
>>
>>> ​Hi Theo,
>>>
>>> While running a spike on Data Approvals on DHIS, we came across several
>>> functionalities that could suit our requirements. However, As Jim mentioned
>>> in the previous mail, there is no interaction between approvals and data
>>> synchronisation currently. They do have future possibilities of including
>>> it and they are welcome to take our input as to how we would like approvals
>>> and data synchronisation to work together.
>>>
>>> So, let's us have a discussion around this once you are back from pilot
>>> and let's include Marta from OCBA as well. Thoughts on this?
>>>
>>> *Cheers*
>>>
>>
>>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

[Jim Grace]

To me the most important way to address this is to allow an
implementation-wide default. The space character is in many ways the
"correct" separator according to international norms, and is even making
inroads into countries such as the US that traditionally use the comma. I
think the space is probably the best "factory" default for DHIS 2, so that
large numbers are readable on demonstration systems, and so we follow
international and emerging standards.

However, an implementation should be able to override this with an
implementation-wide default of comma, where a preponderance of users for
that implementation are more used to this, and/or where exporting to Excel
is a concern.

Expecting users to override the default every time they create a pivot
table is not very user-friendly.


On Tue, May 3, 2016 at 1:46 PM, Prosper BT <ptb3...@gmail.com> wrote:

> I vote for having none as default (1432) then one can choose what they
> want in options
>
>
> On Tue, May 3, 2016 at 7:36 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi there,
>>
>> we are getting many (conflicting) requests for what the default value
>> should be for the "digit group separator" in the pivot table app.
>>
>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>
>> http://doodle.com/poll/vtyzgts226aqihev
>>
>>
>> The digit group separator controls how large numbers are being split up,
>> e.g.
>>
>> 1 432
>> 1,432
>> 1432
>>
>> The digit group separator can be controlled from Options.
>>
>> [image: Inline image 1]
>>
>> 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-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype:
> prospertb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1574639] Re: [api] NullPointer when inviting a user through the api

[Jim Grace]

Fixed in trunk, 2.23 and 2.22.

** Changed in: dhis2
   Status: New => Fix Committed

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

Title:
  [api] NullPointer when inviting a user through the api

Status in DHIS:
  Fix Committed

Bug description:
  When trying to send an invite to create a user i receive a null
  pointer.

  This effects both 2.23 and 2.22 (2.22 being the more important version
  for me atm :))

  Send an invite request to
  `https://play.dhis2.org/demo/api/users/invite` with a payload
  equivalent to:

  ```
  {
  "email":"m...@dhis.org",
  "organisationUnits":[{"id":"ImspTQPwCqd"}],
  "dataViewOrganisationUnits":[{"id":"ImspTQPwCqd"}],
  "userCredentials": {}
  }
  ```

  or curl request to run:

  curl https://play.dhis2.org/demo/api/users/invite -u admin:district -d
  
"{\"email\":\"m...@dhis2.org\",\"organisationUnits\":[{\"id\":\"ImspTQPwCqd\"}],\"dataViewOrganisationUnits\":[{\"id\":\"ImspTQPwCqd\"}],\"userCredentials\":{}}"
  -H "Content-Type:application/json"

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1574639/+subscriptions

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

[Dhis2-devs] [Bug 1574639] Re: [api] NullPointer when inviting a user through the api

[Jim Grace]

** Changed in: dhis2
 Assignee: (unassigned) => Jim Grace (jimgrace)

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

Title:
  [api] NullPointer when inviting a user through the api

Status in DHIS:
  New

Bug description:
  When trying to send an invite to create a user i receive a null
  pointer.

  This effects both 2.23 and 2.22 (2.22 being the more important version
  for me atm :))

  Send an invite request to
  `https://play.dhis2.org/demo/api/users/invite` with a payload
  equivalent to:

  ```
  {
  "email":"m...@dhis.org",
  "organisationUnits":[{"id":"ImspTQPwCqd"}],
  "dataViewOrganisationUnits":[{"id":"ImspTQPwCqd"}],
  "userCredentials": {}
  }
  ```

  or curl request to run:

  curl https://play.dhis2.org/demo/api/users/invite -u admin:district -d
  
"{\"email\":\"m...@dhis2.org\",\"organisationUnits\":[{\"id\":\"ImspTQPwCqd\"}],\"dataViewOrganisationUnits\":[{\"id\":\"ImspTQPwCqd\"}],\"userCredentials\":{}}"
  -H "Content-Type:application/json"

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1574639/+subscriptions

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

Re: [Dhis2-devs] [Dhis2-users] Migrated from v2.15 to v2.22 - Data Approval provokes an error

[Jim Grace]

Hi Ryan,

Sorry about the delay in responding.

The error you see makes me wonder if the dataapproval table in your MySQL
database was somehow not correctly updated when you upgraded to 2.22.
Before version 2.22, the dataapproval table had a column datasetid, but
starting with 2.22 this column should be absent, and there should be a
workflowid column instead. The columns in the 2.22 dataapproval table
should be equivalent to the following (taken from Postgresql):

CREATE TABLE dataapproval
(
  dataapprovalid integer NOT NULL,
  dataapprovallevelid integer NOT NULL,
  periodid integer NOT NULL,
  organisationunitid integer NOT NULL,
  accepted boolean NOT NULL,
  created timestamp without time zone NOT NULL,
  creator integer NOT NULL,
  attributeoptioncomboid integer NOT NULL,
  workflowid integer NOT NULL,
  CONSTRAINT dataapproval_pkey PRIMARY KEY (dataapprovalid),
  CONSTRAINT fk_dataapproval_attributeoptioncomboid FOREIGN KEY
(attributeoptioncomboid)
  REFERENCES categoryoptioncombo (categoryoptioncomboid) MATCH SIMPLE
  ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_dataapproval_creator FOREIGN KEY (creator)
  REFERENCES userinfo (userinfoid) MATCH SIMPLE
  ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_dataapproval_dataapprovallevel FOREIGN KEY
(dataapprovallevelid)
  REFERENCES dataapprovallevel (dataapprovallevelid) MATCH SIMPLE
  ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_dataapproval_organisationunitid FOREIGN KEY
(organisationunitid)
  REFERENCES organisationunit (organisationunitid) MATCH SIMPLE
  ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_dataapproval_periodid FOREIGN KEY (periodid)
  REFERENCES period (periodid) MATCH SIMPLE
  ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_dataapproval_workflowid FOREIGN KEY (workflowid)
  REFERENCES dataapprovalworkflow (workflowid) MATCH SIMPLE
  ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT dataapproval_unique_key UNIQUE (dataapprovallevelid,
workflowid, periodid, organisationunitid, attributeoptioncomboid)
)
WITH (
  OIDS=FALSE
);

Can you examine the dataapproval table and let me know what it looks like?
(Maybe find a way to extract a "CREATE TABLE" from your MySQL database,
like the above.)

Cheers,
Jim


On Mon, Apr 4, 2016 at 12:32 PM, WILLIAMS, Ryan O'Neil <williamsr...@who.int
> wrote:

> Dear all,
>
>
>
> I just migrated from v2.15 to v2.22 on a MySQL database.
>
>
>
> I created a workflow and assigned it to all datasets, but I am still
> experiencing the data approval errors/issues.
>
>
>
> Previously approved datasets now show up as “Ready for approval”
>
> When trying to approve a dataset, using “Reports”, “Data Approval”, I get
> the following error in the log
>
> *Field 'datasetid' doesn't have a default value
> (SqlExceptionHelper.java [http-bio-8092-exec-23])*
>
>
>
> Seems that some default entry is missing, any ideas what?
>
> Thanks in advance for any help.
>
>
>
> *Ryan Williams*
>
> *World Health Organization *
>
> *Global Malaria Programme*
>
> 20 Avenue Appia
>
> 1211 Geneva 27
>
> tel: +41 22 791 4207
>
> fax: +41 22 791 4824
>
> williamsr...@who.int
>
> www.who.int/malaria
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1571073] [NEW] Data Elements / Indicators app misleading message

[Jim Grace]

Public bug reported:

When editing an existing object using the 'Data Elements / Indicators'
app introduced in 2.22 (e.g. editing a Category, Category Option, Data
Element, etc.) a message is displayed saying "This object will be
created with public edit and view rights".

This message may be very helpful when creating a new object, but for
editing an existing object the message is confusing (the object has been
created already) and may be misleading (the object  may already have
different rights assigned.)

Unless we can think of a more helpful message, I suggest that we just
remove this message when editing an existing object.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Data Elements / Indicators app misleading message

Status in DHIS:
  New

Bug description:
  When editing an existing object using the 'Data Elements / Indicators'
  app introduced in 2.22 (e.g. editing a Category, Category Option, Data
  Element, etc.) a message is displayed saying "This object will be
  created with public edit and view rights".

  This message may be very helpful when creating a new object, but for
  editing an existing object the message is confusing (the object has
  been created already) and may be misleading (the object  may already
  have different rights assigned.)

  Unless we can think of a more helpful message, I suggest that we just
  remove this message when editing an existing object.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1571073/+subscriptions

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

[Dhis2-devs] [Bug 1571070] [NEW] UI can't assign org units to category options

[Jim Grace]

Public bug reported:

Using the 'Data Elements / Indicators' app introduced in 2.22, I can no
longer assign organisation units to a category option.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  UI can't assign org units to category options

Status in DHIS:
  New

Bug description:
  Using the 'Data Elements / Indicators' app introduced in 2.22, I can
  no longer assign organisation units to a category option.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1571070/+subscriptions

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

[Dhis2-devs] [Bug 1570607] Re: Org unit name wrongly quoted in Data Entry

[Jim Grace]

** Changed in: dhis2
   Status: New => Fix Committed

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

Title:
  Org unit name wrongly quoted in Data Entry

Status in DHIS:
  Fix Committed

Bug description:
  If an organisation unit name contains an ampersand (&), or presumably
  another quotable HTML character, it is in appropriately quoted in the
  "Organisation Unit" field of the Data Entry form, for example as
  "".

  To reproduce, go to https://play.dhis2.org/dev and change the "Bo"
  district name to "Bo & others". Then bring up Data Entry and select
  this org unit. On the left it says "Bo & others" but in the Data Entry
  field for Organisation Unit it says "Bo  others". (See attached
  screen shot.)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1570607/+subscriptions

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

Re: [Dhis2-devs] "All" authority no longer granting access to programs?

[Jim Grace]

Looping Tim back in, who started this thread but seems to have been dropped
from it.

On Fri, Apr 15, 2016 at 9:38 AM, Bob Jolliffe <bobjolli...@gmail.com> wrote:

> Its an interesting problem.  In general Role Based Access Control (RBAC)
> is known to be an insufficient security mechanism/framework for handling
> issues of patient confidentiality without some additional parameterization
> to model things like legitimate relationships, patient consent management
> etc.  In dhis2 we do in fact have just that sort of extension to RBAC by
> having affinity to orgunits and programs.
>
> The problem is that this gets broken by the idea of a super-user, so I
> understand where Abyot was going with this.   There is a reasonable
> difference between having ALL roles and having a legitimate relationship
> with all entities.  I don't think this is a question of inconsistency so
> much as a misunderstanding of the refinement to RBAC that we have
> implemented.
>
> Of course the problem with ALL is that, being god-like, it remains
> possible for the superuser to assign him/herself access anyway so there is
> possibly no point having an artificail barrier of "security theatre".
> Unless we ensure that adequate alarms are sounded when a superuser accesses
> individual records - messaging, WARNING logs etc.
>
>
> On 14 April 2016 at 09:52, Abyot Asalefew Gizaw <ab...@dhis2.org> wrote:
>
>> Thank you all !
>>
>> Seems I should give up and put back "All" authority on programs.
>>
>> It would have been nice if we get the view of those working in "patient"
>> or clinical settings.
>>
>> One thing we need to keep in mind is the way we deal with programs is
>> totally different from that of data sets. There is a lot more workflow and
>> confidentially with programs, their attribute values and events.
>>
>> --
>> Abyot A. Gizaw.
>> Senior Engineer, DHIS2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Thu, Apr 14, 2016 at 12:55 AM, Rodolfo Melia <rme...@knowming.com>
>> wrote:
>>
>>> Hi - I learned to live with this odd situation since at least 2.20,
>>> which I have in multiple boxes. It doesn't make sense that you have access
>>> to all data sets, but not to the programs. I really would like to see the
>>> 'All' authority having access to all programs, for consistency sake.
>>>
>>> *R*
>>>
>>>
>>> On 13 April 2016 at 21:32, Jim Grace <j...@dhis2.org> wrote:
>>>
>>>> Thank you all. I'm with Tim. I don't know if this is still up for
>>>> reconsideration or reversal, but it seems to me a bad idea to ship with a
>>>> "Superuser" role, and an "ALL" authority, neither of which gives access to
>>>> all authorities.
>>>>
>>>> *For installations that do not use tracker for personal data that needs
>>>> protection* (like DATIM, which uses tracker for site surveys), this is
>>>> just confusing. User interface design is all about predictability, and
>>>> words like "all" and "superuser" have unquestioned meanings in many of our
>>>> heads. I know this wasted a bit of Tim's time, and it would have done the
>>>> same for me. It would never occur to me that we would intentionally design
>>>> software to use words like these and not have them mean the obvious things.
>>>> For users who are just getting to know the product, either they don't know
>>>> about these exceptions in which case they misunderstand the software and
>>>> could be in for a surprise of unpredictable behavior, or they know about
>>>> them in which case they will have the feeling that this is
>>>> strangely-designed software that doesn't always live up to expectations.
>>>> The more unpredictable or inconsistent our software is, the lower will be
>>>> our users' opinion of it.
>>>>
>>>> *For installations that use tracker for personal data that needs
>>>> protection*, they need to be serious about protecting the data.
>>>> If they hand out too many superuser roles with the "ALL" authority, they
>>>> will have a problem in any event, as Tim points out, since these users
>>>> could assign themselves the tracker authority. A much better solution, and
>>>> one we should recommend, is to not assign either the "ALL" authority or the
>>>> tracker authorities except to users who really need them. It's better to
>>>> have a well-planned security system than 

[Dhis2-devs] [Bug 1570607] Re: Org unit name wrongly quoted in Data Entry

[Jim Grace]

** Changed in: dhis2
 Assignee: (unassigned) => Jim Grace (jimgrace)

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

Title:
  Org unit name wrongly quoted in Data Entry

Status in DHIS:
  New

Bug description:
  If an organisation unit name contains an ampersand (&), or presumably
  another quotable HTML character, it is in appropriately quoted in the
  "Organisation Unit" field of the Data Entry form, for example as
  "".

  To reproduce, go to https://play.dhis2.org/dev and change the "Bo"
  district name to "Bo & others". Then bring up Data Entry and select
  this org unit. On the left it says "Bo & others" but in the Data Entry
  field for Organisation Unit it says "Bo  others". (See attached
  screen shot.)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1570607/+subscriptions

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

[Dhis2-devs] [Bug 1570607] [NEW] Org unit name wrongly quoted in Data Entry

[Jim Grace]

Public bug reported:

If an organisation unit name contains an ampersand (&), or presumably
another quotable HTML character, it is in appropriately quoted in the
"Organisation Unit" field of the Data Entry form, for example as
"".

To reproduce, go to https://play.dhis2.org/dev and change the "Bo"
district name to "Bo & others". Then bring up Data Entry and select this
org unit. On the left it says "Bo & others" but in the Data Entry field
for Organisation Unit it says "Bo  others". (See attached screen
shot.)

** Affects: dhis2
 Importance: Undecided
 Status: New

** Attachment added: "Screen Shot 2016-04-14 at 5.30.29 PM.png"
   
https://bugs.launchpad.net/bugs/1570607/+attachment/4637121/+files/Screen%20Shot%202016-04-14%20at%205.30.29%20PM.png

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

Title:
  Org unit name wrongly quoted in Data Entry

Status in DHIS:
  New

Bug description:
  If an organisation unit name contains an ampersand (&), or presumably
  another quotable HTML character, it is in appropriately quoted in the
  "Organisation Unit" field of the Data Entry form, for example as
  "".

  To reproduce, go to https://play.dhis2.org/dev and change the "Bo"
  district name to "Bo & others". Then bring up Data Entry and select
  this org unit. On the left it says "Bo & others" but in the Data Entry
  field for Organisation Unit it says "Bo  others". (See attached
  screen shot.)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1570607/+subscriptions

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

Re: [Dhis2-devs] "All" authority no longer granting access to programs?

[Jim Grace]

Thank you all. I'm with Tim. I don't know if this is still up for
reconsideration or reversal, but it seems to me a bad idea to ship with a
"Superuser" role, and an "ALL" authority, neither of which gives access to
all authorities.

*For installations that do not use tracker for personal data that needs
protection* (like DATIM, which uses tracker for site surveys), this is just
confusing. User interface design is all about predictability, and words
like "all" and "superuser" have unquestioned meanings in many of our heads.
I know this wasted a bit of Tim's time, and it would have done the same for
me. It would never occur to me that we would intentionally design software
to use words like these and not have them mean the obvious things. For
users who are just getting to know the product, either they don't know
about these exceptions in which case they misunderstand the software and
could be in for a surprise of unpredictable behavior, or they know about
them in which case they will have the feeling that this is
strangely-designed software that doesn't always live up to expectations.
The more unpredictable or inconsistent our software is, the lower will be
our users' opinion of it.

*For installations that use tracker for personal data that needs protection*,
they need to be serious about protecting the data. If they hand out too
many superuser roles with the "ALL" authority, they will have a problem in
any event, as Tim points out, since these users could assign themselves the
tracker authority. A much better solution, and one we should recommend, is
to not assign either the "ALL" authority or the tracker authorities except
to users who really need them. It's better to have a well-planned security
system than to have the illusion that they are protected when they are not
really. This feature could actually reduce security by giving the illusion
that it is there.

In short, I think the benefits of having Superuser and ALL not include the
tracker are at best questionable and at worst misleading into a false sense
of security, while the costs are real and negative.

My humble opinion.

Cheers,
Jim


On Fri, Apr 8, 2016 at 11:44 AM, Timothy Harding <thard...@baosystems.com>
wrote:

> Thanks Morten, Jim, Abyot,
>
> Abyot:
> Is the point of restricting a super user moot though since the super user
> has the *ability* to assign themselves to whatever they like? It feels
> like an extra step that shouldn't be needed for a superuser.
>
> But, if there is indeed a need for the functionality to be this way, my
> follow up questions are still out there: *Will datasets eventually act
> this way as well*? If not, why the discrepancy?
>
>
>
> *I admit though I am a bit bias having spent more time that I care to
> admit to yesterday trying to figure out why my program would not appear in
> a vanilla instance.*
>
>
>
>
> *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 404, Washington D.C. 20007
>
> On Fri, Apr 8, 2016 at 7:53 AM, Abyot Asalefew Gizaw <ab...@dhis2.org>
> wrote:
>
>> Hi,
>>
>> It was like that before  I think I changed it because at some point
>> there was a discussion saying we have to be careful on granting blanket
>> access in tracker.
>>
>> One could be a superuser, but does this really mean this user will have
>> access to clinical data, names and everything implicitly?
>>
>> By forcing users to explicitly go and assign a program, they know the
>> consequence of doing that...
>>
>> We am open for suggestions and discussions.
>>
>> --
>> Abyot A. Gizaw.
>> Senior Engineer, DHIS2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Fri, Apr 8, 2016 at 4:34 PM, Jim Grace <j...@dhis2.org> wrote:
>>
>>> Perhaps it was just an oversight in the code, forgetting to check for
>>> the "ALL" authority in addition to the particular authority?
>>>
>>> I would certainly expect "ALL" to grant the same access as all
>>> authorities. It would surprise me if there is any good rationale to make it
>>> otherwise.
>>>
>>>
>>> On Thu, Apr 7, 2016 at 11:19 PM, Morten Olav Hansen <mor...@dhis2.org>
>>> wrote:
>>>
>>>> Yes, that is correct. I'm not sure when it was decided so, but you need
>>>> to give the userrole access to that program.
>>>>
>>>> Maybe Abyot remember exactly why?
>>>>
>>>> --
>>>> Morten Olav Hansen
>>>> Senior Engineer, DHIS 2
>>>> University of Os

Re: [Dhis2-devs] "All" authority no longer granting access to programs?

[Jim Grace]

Perhaps it was just an oversight in the code, forgetting to check for the
"ALL" authority in addition to the particular authority?

I would certainly expect "ALL" to grant the same access as all authorities.
It would surprise me if there is any good rationale to make it otherwise.


On Thu, Apr 7, 2016 at 11:19 PM, Morten Olav Hansen <mor...@dhis2.org>
wrote:

> Yes, that is correct. I'm not sure when it was decided so, but you need to
> give the userrole access to that program.
>
> Maybe Abyot remember exactly why?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Fri, Apr 8, 2016 at 9:51 AM, Timothy Harding <thard...@baosystems.com>
> wrote:
>
>> Hey devs,
>>
>> Just wanting to make sure of this: It looks like in version 2.21 and
>> beyond, the "ALL" authority no longer gives the super user access to
>> *everything* (about the same time programs were given their own entry in
>> the roles). This means when that user makes a new (public) program, they
>> need to also add that program to their superuser role. Is this intended? 
>> *Will
>> datasets eventually act this way as well*? If not, why the discrepancy?
>>
>> Steps to reproduce
>> 1. Create blank database in 2.21 or 2.22 (or use the SL demo)
>> 2. Add root ou/set level
>> 3. Add single tracker data element and single aggregate data element
>> 4. Create a program (SENR) and a dataset to use the above respectively
>> - In the program's single stage, specify the tracker element above
>> 5. Assign both the program and the dataset to the root ou
>> 6. Notice that the dataset will show up in the "Data Entry App" and the
>> program will NOT show up in the event viewer.
>>
>>
>> *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 404, Washington D.C. 20007
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs-core] Performance of organisationunit.path prefix matching syntax

[Jim Grace]

Hi All,

Just so you know, PostgreSQL performance depends on which syntax you use
when matching a prefix of the path column in the organisationunit table.
Here are some tests I did just now on my laptop to count the number of
PEPFAR organisationunits under Africa in the DATIM database.

370 ms: select count(*) from organisationunit where path ~
'/ybg3MO3hcf4/KSkooYTy8FB/'

270 ms: select count(*) from organisationunit where path ~
'^/ybg3MO3hcf4/KSkooYTy8FB/'

34 ms: select count(*) from organisationunit where path like
'/ybg3MO3hcf4/KSkooYTy8FB/%'

I did each query several times in a row, so the result would be unaffected
by database caching. All queries returned the same count (66,407).

Feel free to share this with others who might be coding this type of query.

Cheers,
Jim

-- 
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org <https://www.dhis2.org/>
-- 
Mailing list: https://launchpad.net/~dhis2-devs-core
Post to : dhis2-devs-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs-core
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] viet nguyen joins as developer

[Jim Grace]

Welcome, Viet!


On Sat, Feb 6, 2016 at 10:17 AM, Raja Zubair 
wrote:

> Viet,
> Welcome to the gang ;)
>
> R,
> Zubair
> On 6 Feb 2016 14:57, "Mark Polak"  wrote:
>
>> Welcome to the team Viet! :)
>>
>> On Sat, Feb 6, 2016 at 7:39 AM, Pepe Ken Mvulu 
>> wrote:
>>
>>> Thank you Lars,
>>> Viet Nguyen, welcome to the very large DHIS2's family
>>>
>>> Pepe Ken Mvulu
>>>
>>> 2016-02-06 3:18 GMT+01:00 Lars Helge Øverland :
>>> > Hi all,
>>> >
>>> > Viet Nguyen has joined our team as software developer.
>>> >
>>> > Viet has 8 years of experience in Java software development in
>>> different
>>> > fields such as CMS systems, e-commerce and especially health-care.
>>> Viet has
>>> > in fact been working with HISP in a previous period in Vietnam and
>>> India,
>>> > developing on DHIS 2 and OpenMRS.
>>> >
>>> > Viet will be working on the back-end functionality. He is based in
>>> HCMC,
>>> > Vietnam, and will be working together with Morten.
>>> >
>>> > We welcome you as part of the core team!
>>> >
>>> >
>>> > best regards,
>>> >
>>> > Lars
>>> >
>>> > --
>>> > Lars Helge Øverland
>>> > Lead developer, DHIS 2
>>> > University of Oslo
>>> > Skype: larshelgeoverland
>>> > http://www.dhis2.org
>>> >
>>> >
>>> > ___
>>> > Mailing list: https://launchpad.net/~dhis2-users
>>> > Post to : dhis2-us...@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-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1539060] Re: Settings workflow shows wrong levels when new level inserted

[Jim Grace]

Also the workflows tab shows the wrong levels when an approval level is
deleted that was above some of the levels assigned to a workflow.

(This was not a problem when this bug was first reported, because
deleting a level left a gap in the level numbers. This has now been
fixed in trunk and 2.22 so no gap is left in the approval level numbers,
but the workflows tab does not show the updated numbers.)

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

Title:
  Settings workflow shows wrong levels when new level inserted

Status in DHIS:
  New

Bug description:
  v2.22 - In the Settings app, when a new approval level is inserted
  above levels assigned to a workflow, then the workflows tab shows the
  wrong levels (until the settings app is reloaded).

  To reproduce, go to https://play.dhis2.org/demo Apps -> Settings ->
  Approval -> Approval Workflows tab. Note that both workflows are
  assigned to levels 1 and 2. Now go to the Approval Levels tab and add
  a new level "National". This now becomes level "1". Then go back to
  the Approval Workflows tab. It shows -- incorrectly -- that both of
  the workflows are still assigned to levels 1 and 2, when really they
  are now assigned to levels 2 and 3.

  If you exit the settings app and relaunch it -- or launch the settings
  app in a new browser tab or window -- you will see that the workflows
  show that they are correctly assigned to levels 2 and 3.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1539060/+subscriptions

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

[Dhis2-devs] [Bug 1539060] [NEW] Settings workflow shows wrong levels when new level inserted

[Jim Grace]

Public bug reported:

v2.22 - In the Settings app, when a new approval level is inserted above
levels assigned to a workflow, then the workflows tab shows the wrong
levels (until the settings app is reloaded).

To reproduce, go to https://play.dhis2.org/demo Apps -> Settings ->
Approval -> Approval Workflows tab. Note that both workflows are
assigned to levels 1 and 2. Now go to the Approval Levels tab and add a
new level "National". This now becomes level "1". Then go back to the
Approval Workflows tab. It shows -- incorrectly -- that both of the
workflows are still assigned to levels 1 and 2, when really they are now
assigned to levels 2 and 3.

If you exit the settings app and relaunch it -- or launch the settings
app in a new browser tab or window -- you will see that the workflows
show that they are correctly assigned to levels 2 and 3.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Settings workflow shows wrong levels when new level inserted

Status in DHIS:
  New

Bug description:
  v2.22 - In the Settings app, when a new approval level is inserted
  above levels assigned to a workflow, then the workflows tab shows the
  wrong levels (until the settings app is reloaded).

  To reproduce, go to https://play.dhis2.org/demo Apps -> Settings ->
  Approval -> Approval Workflows tab. Note that both workflows are
  assigned to levels 1 and 2. Now go to the Approval Levels tab and add
  a new level "National". This now becomes level "1". Then go back to
  the Approval Workflows tab. It shows -- incorrectly -- that both of
  the workflows are still assigned to levels 1 and 2, when really they
  are now assigned to levels 2 and 3.

  If you exit the settings app and relaunch it -- or launch the settings
  app in a new browser tab or window -- you will see that the workflows
  show that they are correctly assigned to levels 2 and 3.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1539060/+subscriptions

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

[Dhis2-devs] [Bug 1536817] [NEW] Metadata Import slower in 2.21

[Jim Grace]

Public bug reported:

A metadata import of 1090 data elements (with user group sharing
information) that took 946 seconds in v2.20, took 2,932 seconds in
v2.21.

I can supply the import to developers.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Metadata Import slower in 2.21

Status in DHIS:
  New

Bug description:
  A metadata import of 1090 data elements (with user group sharing
  information) that took 946 seconds in v2.20, took 2,932 seconds in
  v2.21.

  I can supply the import to developers.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1536817/+subscriptions

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

Re: [Dhis2-devs] [Dhis2-users] Export hierarchy coordinates

[Jim Grace]

Hi Pepe,

The resource table _orgunitstructure can help you out. There is one row in
this table for every organisation unit in the system, and it has references
to all the higher-level organisation units (if any) above that org unit.

Just make sure that the resource tables are refreshed after you add,
rename, or reorganize any organisation units, and before you run the query.
The resource tables are refreshed as part of the analytics refresh, or they
can be refreshed separately by Apps -> Data Administration -> Resource
Table -> Generate tables, or through a Web API call (see section 1.30 of
the developer manual). Then your query can be something like:

select o1.name, o2.name, o3.name, o4.name, o5.name, o6.name, o6.coordinates
from _orgunitstructure o
join organisationunit o1 on o1.organisationunitid = o.idlevel1
join organisationunit o2 on o2.organisationunitid = o.idlevel2
join organisationunit o3 on o3.organisationunitid = o.idlevel3
join organisationunit o4 on o4.organisationunitid = o.idlevel4
join organisationunit o5 on o5.organisationunitid = o.idlevel5
join organisationunit o6 on o6.organisationunitid = o.idlevel6
where o.level = 6

In this case the 'where' clause may not even be needed. The inner joins on
idlevel1-6 will filter out any table records that apply to higher-level org
units, because these will have a null value in one or more of these columns.

Cheers,
Jim


On Thu, Dec 17, 2015 at 8:06 AM, Pepe ken mvulu <pepeken...@gmail.com>
wrote:

> Hi Jim,
>
> Currently we are using version 2.20, we have 7 levels of organisation
> unit, a map is available at Level 4 (Zone de Santé), level 6 contains the
> coordinates of the villages that I want to export as CVS or Excel format
> using a query or other procedure available.
>
> Here is a screenshot of Level 6
>
> Here is the picture I want to download for all villages
>
>
>
> *Name level 1*
>
> *Name level 2*
>
> *Name level 3*
>
> *Name level 4*
>
> *Name level 5*
>
> *Name level 6*
>
> *Coordinates level 6 (decimal)*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Regards,
>
> Pepe Ken Mvulu
>
>
>
> *De :* Jim Grace [mailto:jimgr...@gmail.com]
> *Envoyé :* mercredi 16 décembre 2015 19:09
> *À :* Pepe Ken Mvulu
> *Cc :* Dhis2-User; DHIS 2 developers
> *Objet :* Re: [Dhis2-users] Export hierarchy coordinates
>
>
>
> Hi Pepe,
>
>
>
> Can you say more about what you mean by "hierarchy coordinates"? Are you
> talking about the GIS location of the organisation units? Or the path of
> ancestor organisation units from each organisation unit up to the root?
> What exactly would you like to see and, ideally, in what format? (An
> example could help.)
>
>
>
> Which version of DHIS 2 are you using. (We've been adding some new
> features relating to organisation unit hierarchy.)
>
>
>
> Cheers,
>
> Jim
>
>
>
> On Wed, Dec 16, 2015 at 9:11 AM, Pepe Ken Mvulu <pepeken...@gmail.com>
> wrote:
>
> Hi All,
> I need to export the hierarchy coordinates of organisation units, but
> I do not know what to do. Any ideas? any query ?
> Best Regards
>
> Pepe Ken Mvulu
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Export hierarchy coordinates

[Jim Grace]

Hi Pepe,

Can you say more about what you mean by "hierarchy coordinates"? Are you
talking about the GIS location of the organisation units? Or the path of
ancestor organisation units from each organisation unit up to the root?
What exactly would you like to see and, ideally, in what format? (An
example could help.)

Which version of DHIS 2 are you using. (We've been adding some new features
relating to organisation unit hierarchy.)

Cheers,
Jim

On Wed, Dec 16, 2015 at 9:11 AM, Pepe Ken Mvulu 
wrote:

> Hi All,
> I need to export the hierarchy coordinates of organisation units, but
> I do not know what to do. Any ideas? any query ?
> Best Regards
>
> Pepe Ken Mvulu
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] New DHIS 2 developer joins HISP US

[Jim Grace]

Hi All,

Ken Haase has just joined the team as a DHIS 2 developer, working through
HISP US. Among other things, Ken has a PhD in Artificial Intelligence from
MIT and has taught at the MIT Media Lab. He also has developed a lot of
software over the years and is looking forward to contributing to DHIS 2.

I'm very excited that HISP US has just doubled in size, and thrilled that
Ken is now with us.

Welcome, Ken!

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

Re: [Dhis2-devs-core] dhis.conf

[Jim Grace]

Hi Lars,

I like it.

While we're at it, could we also add a feature to make it easier to run
multiple DHIS 2 instances on the same machine, each with their own config
file (and hence their own database)? I know there are ways to do this
already, but I wonder if we can make an even simpler one by using a config
file naming convention as follows:

The startup code would get the servlet name from getServletContext
or getServletName (can this be done during startup?), and look for the
config file .conf in the DHIS2_HOME directory. If this file is
not found, look for dhis.conf.

This would make it easy for an implementer to rename dhis.war to other
names, and deploy the other war file(s) either under the same Tomcat
instance or a different Tomcat instance. Each DHIS 2 instance would then
have its own config file in the same DHIS2_HOME directory.

Cheers,
Jim


On Thu, Nov 12, 2015 at 5:58 AM, Lars Helge Øverland 
wrote:

>
>
> On Thu, Nov 12, 2015 at 2:23 AM, Morten Olav Hansen 
> wrote:
>
>> What about at least using a standard extension like .properties?
>>
>
> I think .conf is pretty standard within the unix/linux world
> (postgresql.conf, users.conf, hosts.conf, etc) and it indicates that is a
> configuration file, so my preference is .conf.
>
>
>
>>
>> --
>> Morten
>>
>> On Wed, Nov 11, 2015 at 11:28 PM, Lars Helge Øverland <
>> larshe...@gmail.com> wrote:
>>
>>> I agree that structure is nice. However, the intention is to keep this
>>> as simple as absolutely possibly. I think the average dhis self-taught sys
>>> admin is a bit familiar with good old property files but not so much with
>>> yaml or json, and the risk for people ending up with invalid config is
>>> high. I can foresee a flurry of dev list emails going like this:
>>>
>>> - "the system does not start"
>>> - "if your config file valid yaml?"
>>> - "yaml what?"
>>> - "just read up here http://www.yaml.org/start.html;
>>> - "no i don't need to invoice basketballs"
>>> - "can you post your config file?"
>>> - "yes"
>>> - "no don't include your password, now you must reset it"
>>> - "okay i set it to Pass123 now"
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Mailing list: https://launchpad.net/~dhis2-devs-core
>>> Post to : dhis2-devs-core@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs-core
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
> --
> Mailing list: https://launchpad.net/~dhis2-devs-core
> Post to : dhis2-devs-core@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs-core
> More help   : https://help.launchpad.net/ListHelp
>
>
-- 
Mailing list: https://launchpad.net/~dhis2-devs-core
Post to : dhis2-devs-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs-core
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs-core] Update to like/ilike

[Jim Grace]

i like!


On Thu, Nov 12, 2015 at 10:50 AM, John Mukulu 
wrote:

> This is soo cool!
> Thanks Morten.
> On Nov 12, 2015 7:49 AM, "Morten Olav Hansen"  wrote:
>
>> Hi everyone
>>
>> I just pushed some code that enables the new in-memory filter engine, in
>> that I have also added a few new operators, and updated a few old ones.
>>
>> The new operators are documented here
>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s07.html
>>
>> Please note that we now also have proper support for like and ilike, so
>> you might need to update your apps to use :ilike: instead of :like: if you
>> expect non case sensitive.
>>
>> Please let me know if you see any issues.
>>
>> --
>> Morten
>>
>> --
>> Mailing list: https://launchpad.net/~dhis2-devs-core
>> Post to : dhis2-devs-core@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs-core
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> --
> Mailing list: https://launchpad.net/~dhis2-devs-core
> Post to : dhis2-devs-core@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs-core
> More help   : https://help.launchpad.net/ListHelp
>
>
-- 
Mailing list: https://launchpad.net/~dhis2-devs-core
Post to : dhis2-devs-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs-core
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs-core] dhis.conf

[Jim Grace]

Hi Lars,

That makes sense. Thanks.


On Thu, Nov 12, 2015 at 12:22 PM, Lars Helge Øverland <larshe...@gmail.com>
wrote:

> Hi Jim,
>
> thanks for the feedback.
>
> I am not sure if this is the way to go. There is no standard way of
> getting the servlet name except from a web http request (which we can't
> easily get in the startup process). Also, I think its better to have
> separate Tomcat instances and DHIS2_HOME locations per WAR file. It gives
> better isolation, lets you start/stop instances independently. DHIS_HOME
> contains apps, files, logs, resources besides filestore, so all of that
> must be "namespaced" as well in this case. Having separate Tomcats is quite
> easy - you just set DHIS2_HOME in tomcat/bin/setenv.sh to point to a
> dedicated location and that's it ;)
>
>
>
> On Thu, Nov 12, 2015 at 2:31 PM, Jim Grace <jimgr...@gmail.com> wrote:
>
>> Hi Lars,
>>
>> I like it.
>>
>> While we're at it, could we also add a feature to make it easier to run
>> multiple DHIS 2 instances on the same machine, each with their own config
>> file (and hence their own database)? I know there are ways to do this
>> already, but I wonder if we can make an even simpler one by using a config
>> file naming convention as follows:
>>
>> The startup code would get the servlet name from getServletContext
>> or getServletName (can this be done during startup?), and look for the
>> config file .conf in the DHIS2_HOME directory. If this file is
>> not found, look for dhis.conf.
>>
>> This would make it easy for an implementer to rename dhis.war to other
>> names, and deploy the other war file(s) either under the same Tomcat
>> instance or a different Tomcat instance. Each DHIS 2 instance would then
>> have its own config file in the same DHIS2_HOME directory.
>>
>> Cheers,
>> Jim
>>
>>
>> On Thu, Nov 12, 2015 at 5:58 AM, Lars Helge Øverland <larshe...@gmail.com
>> > wrote:
>>
>>>
>>>
>>> On Thu, Nov 12, 2015 at 2:23 AM, Morten Olav Hansen <morte...@gmail.com>
>>> wrote:
>>>
>>>> What about at least using a standard extension like .properties?
>>>>
>>>
>>> I think .conf is pretty standard within the unix/linux world
>>> (postgresql.conf, users.conf, hosts.conf, etc) and it indicates that is a
>>> configuration file, so my preference is .conf.
>>>
>>>
>>>
>>>>
>>>> --
>>>> Morten
>>>>
>>>> On Wed, Nov 11, 2015 at 11:28 PM, Lars Helge Øverland <
>>>> larshe...@gmail.com> wrote:
>>>>
>>>>> I agree that structure is nice. However, the intention is to keep this
>>>>> as simple as absolutely possibly. I think the average dhis self-taught sys
>>>>> admin is a bit familiar with good old property files but not so much with
>>>>> yaml or json, and the risk for people ending up with invalid config is
>>>>> high. I can foresee a flurry of dev list emails going like this:
>>>>>
>>>>> - "the system does not start"
>>>>> - "if your config file valid yaml?"
>>>>> - "yaml what?"
>>>>> - "just read up here http://www.yaml.org/start.html;
>>>>> - "no i don't need to invoice basketballs"
>>>>> - "can you post your config file?"
>>>>> - "yes"
>>>>> - "no don't include your password, now you must reset it"
>>>>> - "okay i set it to Pass123 now"
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Mailing list: https://launchpad.net/~dhis2-devs-core
>>>>> Post to : dhis2-devs-core@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs-core
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> http://www.dhis2.org <https://www.dhis2.org>
>>>
>>>
>>> --
>>> Mailing list: https://launchpad.net/~dhis2-devs-core
>>> Post to : dhis2-devs-core@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs-core
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>
-- 
Mailing list: https://launchpad.net/~dhis2-devs-core
Post to : dhis2-devs-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs-core
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Bug 1514511] [NEW] Event locally-stored longText won't upload

[Jim Grace]

Public bug reported:

When doing Event entry, enter large amount of text (>2K characters) in a
longText field while offline. Then go back online and click "Upload" to
upload the locally-stored data to the server. The message "Uploading
locally stored data to the server" appears, but stays forever.

To reproduce, you can define a simple "Test program" without
registration in apps.dhis2.org/demo by importing the metadata in the
attached testProgram.xml file (unless it has been defined since the last
refresh). Then:

Apps -> Event Capture -> (leave Sierra Leone selected) -> select "Test
Program" -> Register Event

Disconnect your computer from the network. Status shows "You are
offline, data will be stored locally"

Enter a report date -> enter more than 2K chars into "Visit comment" ->
Click "Save and go back"

Reconnect your computer. Status shows "There is data stored locally,
please upload to server [ Upload ]"

Click [ Upload ]

** Affects: dhis2
 Importance: Undecided
 Assignee: Abyot Asalefew Gizaw (abyot)
 Status: New

** Attachment added: "testProgram.xml"
   
https://bugs.launchpad.net/bugs/1514511/+attachment/4515630/+files/testProgram.xml

** Changed in: dhis2
 Assignee: (unassigned) => Abyot Asalefew Gizaw (abyot)

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

Title:
  Event locally-stored longText won't upload

Status in DHIS:
  New

Bug description:
  When doing Event entry, enter large amount of text (>2K characters) in
  a longText field while offline. Then go back online and click "Upload"
  to upload the locally-stored data to the server. The message
  "Uploading locally stored data to the server" appears, but stays
  forever.

  To reproduce, you can define a simple "Test program" without
  registration in apps.dhis2.org/demo by importing the metadata in the
  attached testProgram.xml file (unless it has been defined since the
  last refresh). Then:

  Apps -> Event Capture -> (leave Sierra Leone selected) -> select "Test
  Program" -> Register Event

  Disconnect your computer from the network. Status shows "You are
  offline, data will be stored locally"

  Enter a report date -> enter more than 2K chars into "Visit comment"
  -> Click "Save and go back"

  Reconnect your computer. Status shows "There is data stored locally,
  please upload to server [ Upload ]"

  Click [ Upload ]

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1514511/+subscriptions

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

Re: [Dhis2-devs] nicolay ramm joins as developer

[Jim Grace]

Welcome, Nicolay!


On Fri, Aug 28, 2015 at 12:39 PM, Halvdan Grelland halvda...@gmail.com
wrote:

 Welcome to the team!

 2015-08-28 17:49 GMT+02:00 Lars Helge Øverland larshe...@gmail.com:

 Hi all,

 Nicolay Ramm has joined the team today as a full-time DHIS 2 developer.
 Nicolay holds a master's degree and has extensive experience as a Web
 developer. He will be working on apps and front-end development.

 Welcome!

 regards,

 Lars






 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


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



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


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

Re: [Dhis2-devs] stian sandvold joins as developer

[Jim Grace]

Welcome, Stian!


On Fri, Aug 28, 2015 at 1:50 PM, Abyot Gizaw aby...@gmail.com wrote:

 Warm Welcome !

 -
 Thank you,
 Abyot.

 (sent from mobile)
 Hi all,

 Stian Sandvold has joined the team today as DHIS 2 developer on a 50 %
 basis. Stian comes from a position as lead developer at Asio, a company
 which develops educational tools and games. He is doing his last year of
 master's at UiO. Stian will work on server-side / back-end development.

 Welcome!


 regards,

 Lars






 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


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


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


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

Re: [Dhis2-devs] Problem with category option combo

[Jim Grace]

Hi Raheel,

Try Apps - Data Administration - Maintenance - check Update category
option combinations - click Perform maintenance. This should create the
category option combos for any new category options you have defined.

Cheers,
Jim


On Tue, Jul 14, 2015 at 4:34 PM, Raheel Ayaz raheela...@gmail.com wrote:

 Hi all,

 I have two categories Donor and Implementing partner with dimension type
 attribute merged together to a category combination Donor  Implementing
 partner. When this category combination was defined so all the possible
 combinations were automatically created under category option combo.

 Now couple of days ago I created one option under option category and then
 later it was added to the Donor category. Even after adding the new value
 to the donor category the combinations for that specific donor with all the
 implementing partners in the list are not created under the category option
 combo and therefore I am facing this error message Attribute option combo
 does not exist for given category combo and category options when i try to
 press complete button for the data entered under that new donor.

 Can someone help me to resolve this problem?

 Thanks in advance for your support.

 Best regards,
 Raheel

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


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

Re: [Dhis2-devs] [Bug 1464211] Re: validation not relevant

[Jim Grace]

Hi Victor,

Thanks for pointing this out. The default dataelementcategoryoption
should also have a null userid. I have now updated the trunk code to check
for this, and also updated the latest versions of 2.18 and 2.19. Hopefully
this will avoid further errors of this type (if people use the latest
code.) Setting publicaccess to rw is still fine, but shouldn't be
necessary with the latest code.

Thanks for your help in solving this.

Cheers,
Jim


On Fri, Jun 12, 2015 at 10:00 AM, Victor Garcia vgarcia...@gmail.com
wrote:

 Hi Jim,

 thanks for the explanation. To verify if it was a configuration error,
 we have created a fresh dhis instance for versions 2.18 and 2.19, and
 in both cases the initial value of publicaccess for default
 dataelementcategoryoption is --. Maybe it has been disconfigured
 at some time.

 It is great to know that this change is safe and solves the problem. Thank
 you!

 Víctor

 On 12 June 2015 at 13:55, Jim Grace jimgr...@gmail.com wrote:
  Victor, thank you for the very good analysis. Do you know how your
 default
  dataelementcategoryoption came to have publicaccess of --? I would
  expect this to be a configuration error. Your fix sounds right.
 
  The SQL code you refer to is critical when using a non-default category
  combination for the dataset. These category combinations can be used for
  projects, funding contracts, etc. Then it is important for users to
 approve
  data only where they are authorized -- only where the category option is
  visible to the user. For data sets with the default category combination,
  the default category option should be visible to the user.
 
  Lionel, can you please check to see if your dataelementcategoryoption
 with
  name default also has a publicaccess of --? If so, please change
 the
  publicaccess value to rw, to see if that solves your problem.
 
  Cheers,
  Jim Grace
 
 
  On Thu, Jun 11, 2015 at 1:30 PM, lionel ruberintwari ruber...@gmail.com
 
  wrote:
 
  Thanks for all your help, the bug is related to java code and it's been
  noticed to DHIS community in order to create a bug fix and release
  another war file. From my side i am limited to a BAO dashboard. Thanks
  once again and we are awaiting for the release of this war file
 
  --
  You received this bug notification because you are a member of DHIS 2
  developers, which is subscribed to DHIS.
  https://bugs.launchpad.net/bugs/1464211
 
  Title:
validation not relevant
 
  Status in DHIS 2:
New
 
  Bug description:
using DHIS2 2.18 version, users with validation data accounts are
experiencing error saying validation not relevant but users with
superuser account can proceed with validation data.
 
  To manage notifications about this bug go to:
  https://bugs.launchpad.net/dhis2/+bug/1464211/+subscriptions
 
  ___
  Mailing list: https://launchpad.net/~dhis2-devs
  Post to : dhis2-devs@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-devs
  More help   : https://help.launchpad.net/ListHelp
 
 
 
  ___
  Mailing list: https://launchpad.net/~dhis2-devs
  Post to : dhis2-devs@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-devs
  More help   : https://help.launchpad.net/ListHelp
 

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

Re: [Dhis2-devs] [Bug 1464211] Re: validation not relevant

[Jim Grace]

Victor, thank you for the very good analysis. Do you know how your
default dataelementcategoryoption came to have publicaccess of --?
I would expect this to be a configuration error. Your fix sounds right.

The SQL code you refer to is critical when using a non-default category
combination for the dataset. These category combinations can be used for
projects, funding contracts, etc. Then it is important for users to approve
data only where they are authorized -- only where the category option is
visible to the user. For data sets with the default category combination,
the default category option should be visible to the user.

Lionel, can you please check to see if your dataelementcategoryoption with
name default also has a publicaccess of --? If so, please change
the publicaccess value to rw, to see if that solves your problem.

Cheers,
Jim Grace


On Thu, Jun 11, 2015 at 1:30 PM, lionel ruberintwari ruber...@gmail.com
wrote:

 Thanks for all your help, the bug is related to java code and it's been
 noticed to DHIS community in order to create a bug fix and release
 another war file. From my side i am limited to a BAO dashboard. Thanks
 once again and we are awaiting for the release of this war file

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

 Title:
   validation not relevant

 Status in DHIS 2:
   New

 Bug description:
   using DHIS2 2.18 version, users with validation data accounts are
   experiencing error saying validation not relevant but users with
   superuser account can proceed with validation data.

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/dhis2/+bug/1464211/+subscriptions

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

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

Re: [Dhis2-devs] [Dhis2-users] Fwd: Issue on Data approval

[Jim Grace]

Please try the latest 2.18 now. I was able to reproduce and fix this on my
system. (Also fixed in the latest trunk.)


On Wed, Apr 29, 2015 at 2:38 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Hi Salimoe and Rodolfo,

 we have confirmed that approval locking does not work for org units below
 the org unit where data was approved - working on a fix.

 regards,

 Lars



 On Tue, Apr 21, 2015 at 4:50 PM, Rodolfo Melia rme...@knowming.com
 wrote:

 Hi - reopening an old conversation.

 I'm using 2.18, April 18 release: I'm having the same issue: all dataset
 are open, although they are marked as approved.
 Is this a bug? Is there a new setting?

 What's is the best way to test this in the Sierra Leone demo? What
 datasets have approval?

 *Rodolfo Meliá*
 *Principal  |  *rme...@knowming.com
 Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 7636
 www.knowming.com

 On Wed, Feb 4, 2015 at 3:03 PM, Salimone Domingos Nhancume 
 snhanc...@gmail.com wrote:


 Dear, i am also having problem in Approving Data, I followed all the
  steps described hire
 https://www.dhis2.org/doc/snapshot/en/user/html/ch19.html,but only
 the users defined as super user have the option approve, and depending to
 the org unit evel they does not change approved data.

 For other users, they can still modify approved data

 Please can someone help me.

 Salimone


 -- Forwarded message --
 From: nsanzumuhire venuste vensa...@yahoo.fr
 Date: 2015-01-30 8:39 GMT+02:00
 Subject: Re: [Dhis2-users] Issue on Data approval
 To: DHIS 2 developers dhis2-devs@lists.launchpad.net, 
 dhis2-us...@lists.launchpad.net dhis2-us...@lists.launchpad.net


 Any Help on the issue of approval data in version 2.17?All data set have
 been unloked after upgrading from 2.16 to 2.17.I have tried to lock again
 but it did not work.users can modify what ever they want.

 Any Help will be appreciated.

 regards.

   --
  *De :* nsanzumuhire venuste vensa...@yahoo.fr
 *À :* DHIS 2 developers dhis2-devs@lists.launchpad.net; 
 dhis2-us...@lists.launchpad.net dhis2-us...@lists.launchpad.net
 *Envoyé le :* Jeudi 29 janvier 2015 15h53
 *Objet :* Issue on Data approval

 Dear all,

 I'm having issue where i had approved data set on previews periods,and
 now when users go to data entry,all data sets are unloked where now users
 can modify the data what ever they want.

 When i'm checking in reportdata approval,i can see all data sets
 are approved,I even went through the data set and approval data is Yes,But
 when users try to access the data entry they find the data set are not
 locked.

 I'm using version 2.17 but on version 2.16 approval was ok.

 Can some one help on this issue?

 Thanks



 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@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-us...@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-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp



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


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

Re: [Dhis2-devs] [Dhis2-users] Data approval always show Approval not relevant

[Jim Grace]

Hi Gijsbert,

I'm not yet seeing the problem.

How have you configured the approval levels and the user?

Can you reproduce the problem on https://apps.dhis2.org/demo, or on another
system I can access?

Thanks,
Jim


On Thu, Apr 16, 2015 at 9:53 PM, Gijsbert Ooms gijsbert.o...@btcctb.org
wrote:

 Tried with the 2.18 (18365, 2015-04-16 02:03), problem is still there.



 I think it’s something with the roles: when adding the “ALL”-authority to
 the user’s role, it works, but when adding all the authorities but the
 “ALL”-authority, it shows “approval not relevant”.



 Cordialement,



 [image: Description: cid:image001.gif@01CD344E.B1AE8370]

 *GIJSBERT OOMS*
 ICT (AJ)
 PAISS

 CTB BURUNDI
 MINISTERE DE LA SANTE PUBLIQUE ET LA LUTTE CONTRE LE SIDA
 AVENUE DE LA CROIX ROUGE
 BP 6708 BUJUMBURA
 T (+257) 71 922 827
 WWW.BTCCTB.ORG http://www.btcctb.org/

 *Save paper! Think before you print*



 *Van:* Jim Grace [mailto:jimgr...@gmail.com]
 *Verzonden:* donderdag 16 april 2015 19:20
 *Aan:* Gijsbert Ooms
 *CC:* Marta Vila; Thuy Nguyen; dhis1-users; DHIS 2 developers

 *Onderwerp:* Re: [Dhis2-users] Data approval always show Approval not
 relevant



 In the last few days we've made some fixes in 2.18 related to this. I
 suggest you try the latest stable 2.18 release.



 Cheers,

 Jim





 On Thu, Apr 16, 2015 at 4:45 AM, Gijsbert Ooms gijsbert.o...@btcctb.org
 wrote:

 Any news on this? I’m having the same problem.



 Cordialement,



 [image: Description: cid:image001.gif@01CD344E.B1AE8370]

 *GIJSBERT OOMS*
 ICT (AJ)
 PAISS

 CTB BURUNDI
 MINISTERE DE LA SANTE PUBLIQUE ET LA LUTTE CONTRE LE SIDA
 AVENUE DE LA CROIX ROUGE
 BP 6708 BUJUMBURA
 T (+257) 71 922 827
 WWW.BTCCTB.ORG http://www.btcctb.org/

 *Save paper! Think before you print*



 *Van:* Dhis2-users [mailto:dhis2-users-bounces+gijsbert.ooms=
 btcctb@lists.launchpad.net] *Namens *Marta Vila
 *Verzonden:* maandag 9 maart 2015 17:12
 *Aan:* Thuy Nguyen
 *CC:* dhis1-users
 *Onderwerp:* Re: [Dhis2-users] Data approval always show Approval not
 relevant



 Hello,

 Was this solved?? I´m experiencing this same behaviour in:

 Version:

 2.18

 Build revision:

 Build date:

 2015-02-05 20:06

 thanks!





 On 23 December 2014 at 18:39, Thuy Nguyen thuy.hispviet...@gmail.com
 wrote:

 Dear all,



 When I try to approve any dataset for any org unit level, but the message 
 Approval
 not relevant always show. I added level of org unit in the Approval
 setting in Setting module, but this doesn't change. But in version 2.15 it
 works fine.

 Please tell me whether I miss some setting in the new version 2.17.



 Thank you very much.



 Thuy


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@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-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp



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

Re: [Dhis2-devs] [Dhis2-users] Data approval always show Approval not relevant

[Jim Grace]

For a user without the 'ALL' authority, it is working fine for me.

How can I reproduce your problem?


On Fri, Apr 17, 2015 at 8:37 AM, nsanzumuhire venuste vensa...@yahoo.fr
wrote:

 In Rwanda We still have the same issue where we had approved data in 2.16
 version and after upgrading to 2.17,all approved data became unapproved.We
 tried to approve again and did not work.We have raised this issue many
 times  but we did not get any response on this.

 Still waiting if some one can help on this
 Regards

 Venuste

   --
  *De :* Gijsbert Ooms gijsbert.o...@btcctb.org
 *À :* 'Jim Grace' jimgr...@gmail.com
 *Cc :* 'dhis1-users' dhis2-us...@lists.launchpad.net; 'DHIS 2
 developers' dhis2-devs@lists.launchpad.net
 *Envoyé le :* Vendredi 17 avril 2015 3h53
 *Objet :* Re: [Dhis2-users] Data approval always show Approval not
 relevant

 Tried with the 2.18 (18365, 2015-04-16 02:03), problem is still there.

 I think it’s something with the roles: when adding the “ALL”-authority to
 the user’s role, it works, but when addding all the authorities but the
 “ALL”-authority, it shows “approval not relevant”.

 Cordialement,

 [image: Description: cid:image001.gif@01CD344E.B1AE8370]
 *GIJSBERT OOMS*
 ICT (AJ)
 PAISS
 CTB BURUNDI
 MINISTERE DE LA SANTE PUBLIQUE ET LA LUTTE CONTRE LE SIDA
 AVENUE DE LA CROIX ROUGE
 BP 6708 BUJUMBURA
 T (+257) 71 922 827
 WWW.BTCCTB.ORG http://www.btcctb.org/
 *Save paper! Think before you print*

 *Van:* Jim Grace [mailto:jimgr...@gmail.com]
 *Verzonden:* donderdag 16 april 2015 19:20
 *Aan:* Gijsbert Ooms
 *CC:* Marta Vila; Thuy Nguyen; dhis1-users; DHIS 2 developers
 *Onderwerp:* Re: [Dhis2-users] Data approval always show Approval not
 relevant

 In the last few days we've made some fixes in 2.18 related to this. I
 suggest you try the latest stable 2.18 release.

 Cheers,
 Jim


 On Thu, Apr 16, 2015 at 4:45 AM, Gijsbert Ooms gijsbert.o...@btcctb.org
 wrote:

 Any news on this? I’m having the same problem.

 Cordialement,

 [image: Description: cid:image001.gif@01CD344E.B1AE8370]
 *GIJSBERT OOMS*
 ICT (AJ)
 PAISS
 CTB BURUNDI
 MINISTERE DE LA SANTE PUBLIQUE ET LA LUTTE CONTRE LE SIDA
 AVENUE DE LA CROIX ROUGE
 BP 6708 BUJUMBURA
 T (+257) 71 922 827
 WWW.BTCCTB.ORG http://www.btcctb.org/
 *Save paper! Think before you print*

 *Van:* Dhis2-users [mailto:dhis2-users-bounces+gijsbert.ooms=
 btcctb@lists.launchpad.net] *Namens *Marta Vila
 *Verzonden:* maandag 9 maart 2015 17:12
 *Aan:* Thuy Nguyen
 *CC:* dhis1-users
 *Onderwerp:* Re: [Dhis2-users] Data approval always show Approval not
 relevant

 Hello,
 Was this solved?? I´m experiencing this same behaviour in:
 Version:
 2.18
 Build revision:
 Build date:
 2015-02-05 20:06
 thanks!


 On 23 December 2014 at 18:39, Thuy Nguyen thuy.hispviet...@gmail.com
 wrote:

 Dear all,

 When I try to approve any dataset for any org unit level, but the message 
 Approval
 not relevant always show. I added level of org unit in the Approval
 setting in Setting module, but this doesn't change. But in version 2.15 it
 works fine.
 Please tell me whether I miss some setting in the new version 2.17.

 Thank you very much.

 Thuy

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@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-us...@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-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help  : https://help.launchpad.net/ListHelp



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

Re: [Dhis2-devs] [Dhis2-users] Data approval always show Approval not relevant

[Jim Grace]

In the last few days we've made some fixes in 2.18 related to this. I
suggest you try the latest stable 2.18 release.

Cheers,
Jim


On Thu, Apr 16, 2015 at 4:45 AM, Gijsbert Ooms gijsbert.o...@btcctb.org
wrote:

 Any news on this? I’m having the same problem.



 Cordialement,



 [image: Description: cid:image001.gif@01CD344E.B1AE8370]

 *GIJSBERT OOMS*
 ICT (AJ)
 PAISS

 CTB BURUNDI
 MINISTERE DE LA SANTE PUBLIQUE ET LA LUTTE CONTRE LE SIDA
 AVENUE DE LA CROIX ROUGE
 BP 6708 BUJUMBURA
 T (+257) 71 922 827
 WWW.BTCCTB.ORG http://www.btcctb.org/

 *Save paper! Think before you print*



 *Van:* Dhis2-users [mailto:dhis2-users-bounces+gijsbert.ooms=
 btcctb@lists.launchpad.net] *Namens *Marta Vila
 *Verzonden:* maandag 9 maart 2015 17:12
 *Aan:* Thuy Nguyen
 *CC:* dhis1-users
 *Onderwerp:* Re: [Dhis2-users] Data approval always show Approval not
 relevant



 Hello,

 Was this solved?? I´m experiencing this same behaviour in:

 Version:

 2.18

 Build revision:

 Build date:

 2015-02-05 20:06

 thanks!





 On 23 December 2014 at 18:39, Thuy Nguyen thuy.hispviet...@gmail.com
 wrote:

 Dear all,



 When I try to approve any dataset for any org unit level, but the message 
 Approval
 not relevant always show. I added level of org unit in the Approval
 setting in Setting module, but this doesn't change. But in version 2.15 it
 works fine.

 Please tell me whether I miss some setting in the new version 2.17.



 Thank you very much.



 Thuy


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@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-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


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

Re: [Dhis2-devs] Error while Accepting data

[Jim Grace]

Hi Mahendra,

I have reviewed your patch, and tested the code with and without it. As far
as I can tell, the patch would break the intended working of the
F_ACCEPT_DATA_LOWER_LEVELS
authority. Here is what I am seeing:

Without the patch: If a user with F_ACCEPT_DATA_LOWER_LEVELS is assigned to
an org unit, they may accept approvals for lower levels under that org
unit, but they may not accept approvals for the org unit to which they are
assigned. This is how the authority is intended to work.

With the patch: If a user with F_ACCEPT_DATA_LOWER_LEVELS is assigned to an
org unit, they may accept approvals for that org unit, or for lower levels
under that org unit. This is not how the authority is intended to work.

If you are seeing differently, please let me know, and please provide more
details of your use case and configuration so I can reproduce your results.

Cheers,
Jim


On Tue, Mar 17, 2015 at 7:24 AM, Mahendra Kariya 
mahendra.kar...@thoughtworks.com wrote:

 Hi,

 While accepting data, we are getting an error Approval level not found
 although the user has F_ACCEPT_DATA_LOWER_LEVELS authority. We were
 accepting the data at the org unit level defined in Approval Level settings.

 On investigating, we found that the issue is in
 DefaultApprovalLevelService.java.
 We have fixed the bug. The patch is attached with this mail.

 Please review and apply it to trunk.



 Thanks,
 Mahendra

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

Re: [Dhis2-devs] Error while Accepting data

[Jim Grace]

Thanks, I will work on reproducing this.


On Wed, Mar 18, 2015 at 11:31 AM, Mahendra Kariya 
mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 Let me describe the use case.

 User is assigned at Org Unit Level 3. User has authority only to accept
 data, not to approve it. (Approval is done by some other user.)
 Data that needs to be accepted is captured at OU level 6.
 One Approval Level is defined at OU Level 6.

 *Without the patch:*
 After data is approved, if user tries to accept the data at OU level 6,
 DHIS shows an error message Approval Level not found. So user is not able
 to accept the approved data.

 *With Patch:*
 User is able to accept the data.

 Just to be clear, this is the behavior on tw-msf branch
 https://launchpad.net/~tw-msf/dhis2/dhis2. On trunk, user is not able
 to see the Accept button at all. We had submitted a patch which was
 reverted recently. Simanta has sent a reminder for this issue to Lars a few
 hours back. I have looped you as well on that thread.

 Let me know if any other information is required.



 Regards,
 Mahendra


 On Wed, Mar 18, 2015 at 8:37 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Mahendra,

 I have reviewed your patch, and tested the code with and without it. As
 far as I can tell, the patch would break the intended working of the 
 F_ACCEPT_DATA_LOWER_LEVELS
 authority. Here is what I am seeing:

 Without the patch: If a user with F_ACCEPT_DATA_LOWER_LEVELS is assigned
 to an org unit, they may accept approvals for lower levels under that org
 unit, but they may not accept approvals for the org unit to which they are
 assigned. This is how the authority is intended to work.

 With the patch: If a user with F_ACCEPT_DATA_LOWER_LEVELS is assigned to
 an org unit, they may accept approvals for that org unit, or for lower
 levels under that org unit. This is not how the authority is intended to
 work.

 If you are seeing differently, please let me know, and please provide
 more details of your use case and configuration so I can reproduce your
 results.

 Cheers,
 Jim


 On Tue, Mar 17, 2015 at 7:24 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi,

 While accepting data, we are getting an error Approval level not
 found although the user has F_ACCEPT_DATA_LOWER_LEVELS authority. We were
 accepting the data at the org unit level defined in Approval Level settings.

 On investigating, we found that the issue is in
 DefaultApprovalLevelService.java.
 We have fixed the bug. The patch is attached with this mail.

 Please review and apply it to trunk.



 Thanks,
 Mahendra




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

Re: [Dhis2-devs] [Bug 1418121] [NEW] Can't view/edit category code

[Jim Grace]

I don't see it there in
https://apps.dhis2.org/dev/dhis-web-maintenance-datadictionary/showAddDataElementCategoryForm.action


On Wed, Feb 4, 2015 at 2:37 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 What version? It is there from 2.17.

 Lars

 On Wed, Feb 4, 2015 at 5:51 PM, Bob Jolliffe bobjolli...@gmail.com
 wrote:

 Public bug reported:

 Maybe not quite a bug so much as a missing/overlooked feature, but there
 is no widget to edit the code of a category.  The code field exists in
 the database.

 ** Affects: dhis2
  Importance: Undecided
  Status: New

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

 Title:
   Can't view/edit category code

 Status in DHIS 2:
   New

 Bug description:
   Maybe not quite a bug so much as a missing/overlooked feature, but
   there is no widget to edit the code of a category.  The code field
   exists in the database.

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/dhis2/+bug/1418121/+subscriptions

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



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


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

Re: [Dhis2-devs] Reconstructing a categoryoptioncombo (long story)

[Jim Grace]

Hi Bob,

Good question. I like the idea of an in-memory cache for speed, as you
suggest. You might try using a HashTable where the key is an array of
option value Strings and the value of the HashTable is the optionCombo. As
you process the import, each time you get from the dataElement a
categoryCombo you haven't seen before, then get all the optionCombos for
this categoryCombo and put them into your HashTable. The order you put them
into the key array can be the same as the order of the
DataElementCategoryCombo.getCategories() method, since it returns a list.
When looking up a bunch of category values, just put them in the same order
into the array.

Obviously once you've built the values-combo lookup, you will want to
reuse it as much as possible. You could put this into a
com.google.common.cache.Cache so that it can be resued not only by
subsequent record in the same import, but by other imports that come before
the cache entry ages out. The only danger of this in theory is that someone
could extend a category combo or add new option values, and then try an
import before the cache expires. Although this is extremely unlikely, you
can protect against it: If a values-combo lookup fails, remove the cached
HashTable for this categoryCombo and rebuild it. If it still fails, then
you've got a real error. :)

Cheers,
Jim


On Thu, Jan 29, 2015 at 1:38 PM, Bob Jolliffe bobjolli...@gmail.com wrote:

 Hi

 Here's a problem.  Apologies, its a long mail, but its a serious business
 and needs to be untangled.

 Two or more systems have matching dataelements, categorycombos, categories
 and categoryoptions.  They could be matched on uid, name, code or what
 ever.  Assuming they also have matching orgunit identifiers, those two
 systems should be able to exchange data.  There is really no need for
 either of them to know anything about the other's categoryoptioncombos.
 Which is a good thing on a number of fronts.  Not least being that if
 either one of the two is not dhis2 then it won't have the faintest notion
 of a categoryoptioncombo anywat.  And even if they were both dhis2, we all
 know that keeping these catoptcombos in synch is notoriously difficult.

 So I've been over some of this ground before, but now thinking about
 implementation, there are some missing pieces in our model (and some
 shortcomings of the java language) which makes this a bit trickier than it
 should be.  Picture this datavalue being imported (using codes for
 legibility):

 datavalue dataElement='MalariaCases' sex='M' age='under5' . /

 1.  Once we know the dataelement we can immediately retrieve the
 categorycombo, which tells us to expect two more attributes: sex and age in
 this case.

 2.  We could go the database at this point and query from the
  categoryoptioncombos_categoryoptions table, having first retrieved the
 primary ids for the categoryoptions.  This would certainly work, but the
 table might be quite big and the query would be required many times for a
 large datavalueset.  Given that we know the categorycombo from 1 above, we
 should only need to query from a very much smaller set of data contained in
 an in-memory data structure.

 3.  But what would such a data structure look like?  Essentially what is
 required is a multidimensional associative array which is keyed along each
 of its dimensions using the categoryoptions of a category.  For most of our
 categorycombos this would be a 1 or 2 dimensional array, but with some
 rarer cases of 3 or 4 categories.  That would allow lookups of the sort
 getCatOptCombo(sex='M', age='u5', ...)

 Such a dynamic associative array is a natural paradigm in languages like
 perl, tcl, php, javascript, and probably R, but java leaves us a bit short.
 The structure is not easily expressed, at least not efficiently.

 4.  One alternative is to model it as a tree structure.  This has a minor
 drawback that a tree has to put the categories (the layers of the tree) in
 some order which is not implicit in our model, but that's not a very big
 problem.  If you know the order they were put in, you can use the same
 order to search them out.  A bit of xml below shows more or less what the
 structure of that tree would be like for a typical age-sex combo:

 categoryCombo name=bhj id=hjhkjkj code=kmjkl
 category name=sex 
 categoryOption name=Male 
 category name=Age 
 categoryOption name=under5 
 catoptcombo name=(Male/under5) id=767866/
 /categoryOption
 /category
 category name=Age 
 categoryOption name=over5 
 catoptcombo name=(Male/under5) id=ghuy8y/
 /categoryOption
 /category
 /categoryOption
 categoryOption name=Female 
 category name=Age 
 categoryOption name=under5 
 catoptcombo name=(Female/under5) id=767876/
 /categoryOption
 

[Dhis2-devs] [Bug 1413990] [NEW] Accented characters don't work in user group name

[Jim Grace]

Public bug reported:

When I create user group in 2.18 with an accented character in the name,
the accented character gets garbled in the user group listing.

To reproduce, go to https://apps.dhis2.org/demo/dhis-web-maintenance-
user/getAllUserGroups.action and click Add New. Enter a user group name
with an accented character, like Côte d'Ivoire user group. Select at
least one user to join the group and hit Add. The user group listing
shows something like Côte d'Ivoire user group.

** Affects: dhis2
 Importance: Undecided
 Status: New

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

Title:
  Accented characters don't work in user group name

Status in DHIS 2:
  New

Bug description:
  When I create user group in 2.18 with an accented character in the
  name, the accented character gets garbled in the user group listing.

  To reproduce, go to https://apps.dhis2.org/demo/dhis-web-maintenance-
  user/getAllUserGroups.action and click Add New. Enter a user group
  name with an accented character, like Côte d'Ivoire user group.
  Select at least one user to join the group and hit Add. The user group
  listing shows something like Côte d'Ivoire user group.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1413990/+subscriptions

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

Re: [Dhis2-devs] [Dhis2-users] On dhis2 as a terminology server ...

[Jim Grace]

Hi Bob,

Regarding point 1, I was picturing a conceptual code table with two fields:
authority and code. The code itself could be as you say be SNOMED code,
ICD10 code, WHO GHO code, HL7 OID, etc. Or it could be a UID if we're
trying to map to UIDs in another DHIS 2 system. I was not picturing the
need for a third field containing a UID for every code in the code table.

We also need to find a way to make this backwards compatible with existing
systems. ;)

Cheers,
Jim


On Mon, Dec 22, 2014 at 9:55 AM, Bob Jolliffe bobjolli...@gmail.com wrote:

 No.  But the first point is to have the data model able.  From there SVS
 and others are easily supportable.

 On 22 December 2014 at 13:13, Carl Leitner cleit...@capacityplus.org
 wrote:

  Hi Bob,
 Have you all discussed what standard you will be using? SVS? FHIR DSTU
 v2?  Something else?

 Cheers,
 -carl
 On Dec 22, 2014 5:23 AM, Bob Jolliffe bobjolli...@gmail.com wrote:

  Just a brief note to capture some points of discussion between Jim
 Grace and myself last week lest they are forgotten forever.

  Three relatively minor enhancements to our model which would allow
 dhis2 to operate as a reasonable terminology service:

  1.  Extend the hard wired single code attribute to allow multiple
 codes or aliases.  ie. identifiable items should be linked to a code table
 with at a minimum fields objectuid, code, authority.  This would allow
 multiple codes to be stored against an item.  For example these are the
 sorts of code one tends to come across: SNOMED code, ICD10 code, WHO GHO
 code, the HL7 oid, the-code-used-in-system-X, the uuid from system Y etc.

  2.  Enforce/enable the use of the new categoryoptiongroup/set mechanism
 so that category options can be grouped by concept, eg age groups, gender
 categories, disease categories etc. rather than the current heterogenous
 bag of unique labels.

  3.  (Related and dependent on 2).  Remove the absolute uniqueness
 requirement on categoryoption names.  Category option names should be
 unique within a group but there is no real informational requirement which
 is served by making them unique across the set of all categoryoptions.
  'Unknown' in the context of age group is different to 'Unknown' in the
 context of sex and can and will have different codes, particularly if
 imported from or mapped to elsewhere.  They should both be able to exist in
 the same table without conflict.

  The above implies two constraints which meet actual information
 requirements:
 1.  there should always be a categoryoptiongroupset called CONCEPT.  This
 can be hard wired in the firmware.
 2.  categoryoptions must be a member of exactly one group within CONCEPT
 3.  categoryoption names must be unique within categoryoption groups.
 4.  categories must draw their categoryoptions from within a single
 categoryoptiongroup

  The above can lead to a simpler UI for managing categoryoptions and
 more seamless interoperability with external coding systems.  It also
 allows dhis2 to be used as a relatively generic terminology service.

  Comments?

  Bob


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


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

Re: [Dhis2-devs] DHIS2 Validation

[Jim Grace]

Hi Joao,

As far as I know, validation rules are working. Here is what I would
suggest to narrow down the problem:

1. Try to reproduce the problem on the demo system at
https://apps.dhis2.org/demo/

2. If you can reproduce the problem on the demo system, send another email
with the exact details of what you are doing there, and what is not working.

3. If it's working on the demo system but not yours, compare the two
systems to see if you can find the difference.

4. If it is still working on the demo system but not your system, let us
know how your validation rules are set up, and what is not working.

Cheers,
Jim Grace


On Mon, Dec 8, 2014 at 7:08 AM, Joao Mazuze joao_maz...@chasssmt.com
wrote:

  Dear all,

 I am facing some problems with validation rules, My dhis2 instance is not
 running data validation, it simply ignoring and is passing successfully all
 validation even when rules are violated. Can someone help me on this?



 Kind regards


 --
 This message may contain privileged and confidential information intended
 solely for the addressee. Please do not read, disseminate or copy it unless
 you are the intended recipient. If this message has been received in error,
 we kindly ask that you notify the sender immediately by return email and
 delete all copies of the message from your system.

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


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

Re: [Dhis2-devs] analytics api question

[Jim Grace]

Would a SQL View work for you?


On Thu, Dec 4, 2014 at 1:48 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Hi Bob,

 sorry - not supported at the moment.

 It's however a very good idea so feel free to write a blueprint and we can
 put it in for 2.18.

 Lars



 On Thu, Dec 4, 2014 at 6:56 PM, Bob Jolliffe bobjolli...@gmail.com
 wrote:

 Hi

 I am trying to make a query for datavalues of dataelements in a
 particular dataelementgroup.

 Something like the dataelement group equivalent of OU_GROUP-.
  de=DE_GROUP-xxx would be nice but perhaps there is a clever workaround.

 I don't really want to pull the 260 dataelement ids and form them into a
 long query of:

 dimension=dx:xxx1;xxx2;;xxx260

 Any suggestions of the best/simplest way?


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



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


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

Re: [Dhis2-devs] analytics api question

[Jim Grace]

Would the data synchronization feature work for you? Or some future
enhancement of it?


On Thu, Dec 4, 2014 at 2:05 PM, Bob Jolliffe bobjolli...@gmail.com wrote:

 Well yes I will have to resort to sql but probably just execute it
 directly on the database.  My intent is to take the results and post them
 on into another dhis2 instance.  The great advantage of the api approach is
 to get the period strings formatted for free.  I suppose its not rocket
 science to do that externally but was hoping to avoid it.

 Meanwhile I was inspired by the OU_GROUP-xxx thing and will propose a
 blueprint for DE_GROUP-xxx.  It might also be handy to have something
 similar on the datavalues api, though the notion of datavalueset is quite
 strongly linked with a dataset rather than a data element group.


 On 4 December 2014 at 20:55, Jim Grace jimgr...@gmail.com wrote:

 Would a SQL View work for you?


 On Thu, Dec 4, 2014 at 1:48 PM, Lars Helge Øverland larshe...@gmail.com
 wrote:

 Hi Bob,

 sorry - not supported at the moment.

 It's however a very good idea so feel free to write a blueprint and we
 can put it in for 2.18.

 Lars



 On Thu, Dec 4, 2014 at 6:56 PM, Bob Jolliffe bobjolli...@gmail.com
 wrote:

 Hi

 I am trying to make a query for datavalues of dataelements in a
 particular dataelementgroup.

 Something like the dataelement group equivalent of OU_GROUP-.
  de=DE_GROUP-xxx would be nice but perhaps there is a clever workaround.

 I don't really want to pull the 260 dataelement ids and form them into
 a long query of:

 dimension=dx:xxx1;xxx2;;xxx260

 Any suggestions of the best/simplest way?


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



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




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

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

Yes, that's fine.

Note that the approvals feature doesn't require data to be present.
Approving a combination of data set / period / org unit with no data means
that you are approving the case that no data is present for that
combination.

Cheers,
Jim


On Mon, Nov 17, 2014 at 8:16 AM, Mahendra Kariya 
mahendra.kar...@thoughtworks.com wrote:

 Ahh Ok!

 I hope it wouldn't be an issue if we generate tables with only the
 metadata (without any data values) in DHIS.

 On Mon, Nov 17, 2014 at 6:02 PM, Jim Grace jimgr...@gmail.com wrote:

 Ah, you need to build the resource tables first. Apps - Data
 Administration - Resource Table - Generate Tables. Or it also happens as
 part of building the analytics tables. The key statement in the error log
 is nested exception is org.postgresql.util.PSQLException: ERROR:
 relation _orgunitstructure does not exist

 Cheers,
 Jim


 On Sun, Nov 16, 2014 at 10:58 PM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 DHIS2 is throwing an exception (stack trace below) when we are trying to
 GET the following URL. We are on rev 17487.


 http://localhost:8080/api/dataApprovals/status?children=trueds=a00b93a8e1ads=a0264329d97ds=a170b8cd5e5ds=a1869d7c13ads=a1a3292f7ceds=a2d8612eae4ds=a3a7972730bds=a3e7dd2a626ds=a3ff8b407cbds=a6f379ec1b2ds=a717250c552ds=a798ad4eca5ds=a80a255363ads=a9982fbd7a5ds=aa73eadc073ds=ab4a6b62fb9ds=ab6203b3306ds=ad7fe0ff2afds=aed7f5a4bc5ds=af2c2344212ds=afcb8adfba5endDate=2014-11-17ou=3d760c3a11aou=e3e286c6ca8startDate=2014-09-22





 HTTP ERROR 500

 Problem accessing /api/dataApprovals/status. Reason:

 Server Error

 Caused by:

 org.springframework.web.util.NestedServletException: Request processing 
 failed; nested exception is 
 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL 
 grammar [select a.categoryoptioncomboid, a.organisationunitid, (select 
 min(coalesce(dal.level, 0)) from period p join dataset ds on ds.datasetid 
 in (7073) and ds.categorycomboid = a.categorycomboid left join dataapproval 
 da on da.datasetid = ds.datasetid and da.periodid = p.periodid and 
 da.attributeoptioncomboid = a.categoryoptioncomboid and 
 da.organisationunitid = a.organisationunitid left join dataapprovallevel 
 dal on dal.dataapprovallevelid = da.dataapprovallevelid where p.periodid in 
 (9197) ) as highest_approved_level, (select substring(min(concat(10 + 
 coalesce(dal.level, 0), coalesce(da.accepted, FALSE))) from 7) from period 
 p join dataset ds on ds.datasetid in (7073) and ds.categorycomboid = 
 a.categorycomboid left join dataapproval da on da.datasetid = ds.datasetid 
 and da.periodid = p.periodid and da.attributeoptioncomboid = 
 a.categoryoptioncomboid and da.organisationunitid = a.organisationunitid 
 left join dataapprovallevel dal on dal.dataapprovallevelid = 
 da.dataapprovallevelid where p.periodid in (9197) ) as 
 accepted_at_highest_level, not exists (select 1 from _orgunitstructure ous 
 left join dataapproval da on da.organisationunitid = ous.organisationunitid 
 and da.dataapprovallevelid = 1 and da.periodid in (9197) and da.datasetid 
 in (7073) and da.attributeoptioncomboid = a.categoryoptioncomboid where 
 ous.idlevel5 = a.organisationunitid and ous.level = 6 and ( 
 da.dataapprovalid is null ) ) as ready_below, false as approved_above from 
 ( select distinct cocco.categoryoptioncomboid, ccoc.categorycomboid, 
 o.organisationunitid from categoryoptioncombos_categoryoptions cocco join 
 categorycombos_optioncombos ccoc on ccoc.categoryoptioncomboid = 
 cocco.categoryoptioncomboid and ccoc.categorycomboid in (14) join 
 dataelementcategoryoption co on co.categoryoptionid = 
 cocco.categoryoptionid and (co.startdate is null or co.startdate = 
 '2014-11-16') and (co.enddate is null or co.enddate = '2014-11-10') join 
 _orgunitstructure o on o.organisationunitid = 9171 left join 
 categoryoption_organisationunits coo on coo.categoryoptionid = 
 co.categoryoptionid left join _orgunitstructure ous on ous.idlevel5= 
 o.organisationunitid and ous.organisationunitid = coo.organisationunitid 
 left join _orgunitstructure o1 on o1.idlevel5 = o.organisationunitid and 
 o1.idlevel1 = coo.organisationunitid left join _orgunitstructure o2 on 
 o2.idlevel5 = o.organisationunitid and o2.idlevel2 = coo.organisationunitid 
 left join _orgunitstructure o3 on o3.idlevel5 = o.organisationunitid and 
 o3.idlevel3 = coo.organisationunitid left join _orgunitstructure o4 on 
 o4.idlevel5 = o.organisationunitid and o4.idlevel4 = coo.organisationunitid 
 left join dataelementcategoryoptionusergroupaccesses couga on 
 couga.categoryoptionid = cocco.categoryoptionid left join usergroupaccess 
 uga on uga.usergroupaccessid = couga.usergroupaccessid left join 
 usergroupmembers ugm on ugm.usergroupid = uga.usergroupid where ( 
 coo.categoryoptionid is null or ous.organisationunitid is not null or 
 o1.organisationunitid is not null or o2.organisationunitid is not null or 
 o3.organisationunitid is not null or o4

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

Hi Shantala,

Sorry for the silence. The features are in trunk now. We've been doing
quite a bit of work to both simplify and speed up the code. Please test and
give any feedback.

I don't know the 2.17 release date but hopefully it's very soon.

Cheers,
Jim


On Thu, Nov 13, 2014 at 12:01 AM, Shantala Raman sra...@thoughtworks.com
wrote:

 Hi Jim,

 Just wanted to check on the status of approval and acceptance related
 changes being implemented. By when do you think these will be completed?
 Also, what is the release date for 2.17?

 Thanks,
 Shantala


 On Tue, Oct 28, 2014 at 2:57 PM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 It would also be great if you can point us to any APIs that have changed
 while you were refactoring.

 On Tue, Oct 28, 2014 at 10:49 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 I saw a lot of commits regarding approval over the weekend. I am not
 sure if /acceptance/multiple was one of them. So I was just wondering if it
 is there in the trunk. If you are too busy and need some help with it,
 please let us know.

 On Mon, Oct 20, 2014 at 4:16 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Mansi,

 My time has been hijacked by some critical work supporting a
 deployment, but I'm now back to work on this. I need to get it done within
 the next couple of days. Sorry about the further delay.

 Cheers,
 Jim


 On Mon, Oct 20, 2014 at 1:31 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 Just wondering if you got time to work on this api.

 On Fri, Oct 10, 2014 at 3:37 PM, Jim Grace jimgr...@gmail.com wrote:

 Sorry, not yet. The work on this was a bit disrupted this week by
 other things. But I'm trying for the end of the weekend.


 On Fri, Oct 10, 2014 at 1:58 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 We were wondering these changes have been checked in to trunk.

 On Mon, Oct 6, 2014 at 5:42 PM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Thanks.

 On Mon, Oct 6, 2014 at 5:35 PM, Jim Grace jimgr...@gmail.com
 wrote:

 Should be some time this week.


 On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hey Jim,

 Can you please tell us, By when these changes are expected to be
 there in trunk ?

 On Mon, Oct 6, 2014 at 4:52 PM, Jim Grace jimgr...@gmail.com
 wrote:

 Hi Mansi,

 We are refactoring some of the approvals service layer for 2.17,
 and will have the ability there already for multiple acceptances. I 
 will
 add support for this in the API controller as well.

 Cheers,
 Jim


 On Mon, Oct 6, 2014 at 4:56 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hi,

 There is an API (/dataApprovals/multiple) for approving
 multiple datasets for a given period and org unit. But we don't 
 have
 /multiple api for accepting data (/acceptances).

 We have a scenario where we need to accept data for multiple
 datasets for a given period and org unit. Would it make sense to 
 the
 broader DHIS2 community to have this API? Are you planning to 
 write api for
 the same or should we submit a patch?

 --
 Regards,
 Mansi Singhal


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





 --
 Regards,
 Mansi Singhal





 --
 Regards,
 Mansi Singhal









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

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

OK, I guess I'm hoping not to hear from you. ;)


On Thu, Nov 13, 2014 at 9:06 AM, Shantala Raman sra...@thoughtworks.com
wrote:

 Awesome, thanks a lot, Jim. We will let you know if it doesn't go well -
 no mails from us on this would mean it works like a charm :).


 On Thu, Nov 13, 2014 at 6:33 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Shantala,

 Sorry for the silence. The features are in trunk now. We've been doing
 quite a bit of work to both simplify and speed up the code. Please test and
 give any feedback.

 I don't know the 2.17 release date but hopefully it's very soon.

 Cheers,
 Jim


 On Thu, Nov 13, 2014 at 12:01 AM, Shantala Raman sra...@thoughtworks.com
  wrote:

 Hi Jim,

 Just wanted to check on the status of approval and acceptance related
 changes being implemented. By when do you think these will be completed?
 Also, what is the release date for 2.17?

 Thanks,
 Shantala


 On Tue, Oct 28, 2014 at 2:57 PM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 It would also be great if you can point us to any APIs that have
 changed while you were refactoring.

 On Tue, Oct 28, 2014 at 10:49 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 I saw a lot of commits regarding approval over the weekend. I am not
 sure if /acceptance/multiple was one of them. So I was just wondering if 
 it
 is there in the trunk. If you are too busy and need some help with it,
 please let us know.

 On Mon, Oct 20, 2014 at 4:16 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Mansi,

 My time has been hijacked by some critical work supporting a
 deployment, but I'm now back to work on this. I need to get it done 
 within
 the next couple of days. Sorry about the further delay.

 Cheers,
 Jim


 On Mon, Oct 20, 2014 at 1:31 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 Just wondering if you got time to work on this api.

 On Fri, Oct 10, 2014 at 3:37 PM, Jim Grace jimgr...@gmail.com
 wrote:

 Sorry, not yet. The work on this was a bit disrupted this week by
 other things. But I'm trying for the end of the weekend.


 On Fri, Oct 10, 2014 at 1:58 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 We were wondering these changes have been checked in to trunk.

 On Mon, Oct 6, 2014 at 5:42 PM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Thanks.

 On Mon, Oct 6, 2014 at 5:35 PM, Jim Grace jimgr...@gmail.com
 wrote:

 Should be some time this week.


 On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hey Jim,

 Can you please tell us, By when these changes are expected to
 be there in trunk ?

 On Mon, Oct 6, 2014 at 4:52 PM, Jim Grace jimgr...@gmail.com
 wrote:

 Hi Mansi,

 We are refactoring some of the approvals service layer for
 2.17, and will have the ability there already for multiple 
 acceptances. I
 will add support for this in the API controller as well.

 Cheers,
 Jim


 On Mon, Oct 6, 2014 at 4:56 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hi,

 There is an API (/dataApprovals/multiple) for approving
 multiple datasets for a given period and org unit. But we don't 
 have
 /multiple api for accepting data (/acceptances).

 We have a scenario where we need to accept data for
 multiple datasets for a given period and org unit. Would it make 
 sense to
 the broader DHIS2 community to have this API? Are you planning 
 to write api
 for the same or should we submit a patch?

 --
 Regards,
 Mansi Singhal


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





 --
 Regards,
 Mansi Singhal





 --
 Regards,
 Mansi Singhal











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

Re: [Dhis2-devs] [Dhis2-users] Eivind Eriksen joins as developer

[Jim Grace]

Welcome Eivind!

Cheers,
Jim


On Wed, Nov 12, 2014 at 7:46 AM, Nicola Hobby nho...@psi.org wrote:

  Welcome Eivind, from the PSI team!
  --
   Nicola Hobby
 MIS Program Manager

 Office: +1 (202) 469-6685
 Skype: nicolahobby

 *Connect with PSI*
 Website http://www.psi.org/  |  Blog http://blog.psiimpact.com/  |
 Twitter https://twitter.com/PSIimpact  |  Facebook
 https://www.facebook.com/PSIHealthyLives  |  YouTube
 http://www.youtube.com/user/healthybehaviors

  http://www.psi.org/http://blog.psiimpact.com/
 https://twitter.com/PSIimpact
 https://www.facebook.com/PSIHealthyLives
 http://www.youtube.com/user/healthybehaviors

  Donate to PSI
 www.psi.org. 94.5 cents of every dollar raised directly supports PSI
 programs.


   From: Morten Olav Hansen morte...@gmail.com
 Date: Wednesday, November 12, 2014 at 8:40 AM
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com
 Cc: dhis2-users dhis2-us...@lists.launchpad.net, DHIS list 
 dhis2-devs@lists.launchpad.net
 Subject: Re: [Dhis2-users] [Dhis2-devs] Eivind Eriksen joins as developer

   Welcome to the team!

  --
 Morten

 On Wed, Nov 12, 2014 at 6:12 PM, Jan Henrik Øverland 
 janhenrik.overl...@gmail.com wrote:

 Welcome!

 On Wed, Nov 12, 2014 at 12:58 PM, Abyot Gizaw aby...@gmail.com wrote:

 Welcome Eivind !


  ---
 Thank you,
  Abyot.

  On Wed, Nov 12, 2014 at 12:51 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

  Hi all,

  I have the pleasure to announce that Eivind Eriksen has joined the
 team as software developer. Eivind will work 40% this year, then full time
 from January.

  Eivind has 6 years of experience as Java software developer at Eniro,
 Visma, 3Media and has been working on search, monitoring and web portals.
 Eivind is 29 and originally from the northern city of Tromsø, Norway.

  We are excited to you get on the team. Welcome!

  regards,

 Lars



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



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



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



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


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

Re: [Dhis2-devs] re-sinding user account invitations

[Jim Grace]

Hi JM,

Both your questions sound like good ideas to me, but unfortunately neither
is supported in the current software.

Cheers,
Jim

On Fri, Oct 24, 2014 at 8:52 AM, Juan Manuel Alcantara Acosta 
jmalcanta...@gmail.com wrote:

 Hello Devs

 I recently had create 250+ user account invitations and I had some
 problems along the way. Some users got codes that were rejected by the
 system, I didn't find a reason for that but it happened to just a few
 users. Others just couldn't  find the emails for multiple reasons and asked
 to resend them. So, I have a couple of questions:

 - Is there a way to re-send the emails perhaps with a new code? Of course
 other than deleting the invitations and creating them again. I imagine I'll
 have to do this at least a couple of times to get every user to activate
 their accounts and I'd like to avoid having to manually delete 200+
 accounts every time I have to renew the invitations.

 - Is it possible to create multiple invitations with a single payload?

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

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

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

Hi Mansi,

My time has been hijacked by some critical work supporting a deployment,
but I'm now back to work on this. I need to get it done within the next
couple of days. Sorry about the further delay.

Cheers,
Jim


On Mon, Oct 20, 2014 at 1:31 AM, Mahendra Kariya 
mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 Just wondering if you got time to work on this api.

 On Fri, Oct 10, 2014 at 3:37 PM, Jim Grace jimgr...@gmail.com wrote:

 Sorry, not yet. The work on this was a bit disrupted this week by other
 things. But I'm trying for the end of the weekend.


 On Fri, Oct 10, 2014 at 1:58 AM, Mahendra Kariya 
 mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 We were wondering these changes have been checked in to trunk.

 On Mon, Oct 6, 2014 at 5:42 PM, Mansi Singhal msing...@thoughtworks.com
  wrote:

 Thanks.

 On Mon, Oct 6, 2014 at 5:35 PM, Jim Grace jimgr...@gmail.com wrote:

 Should be some time this week.


 On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hey Jim,

 Can you please tell us, By when these changes are expected to be
 there in trunk ?

 On Mon, Oct 6, 2014 at 4:52 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Mansi,

 We are refactoring some of the approvals service layer for 2.17, and
 will have the ability there already for multiple acceptances. I will add
 support for this in the API controller as well.

 Cheers,
 Jim


 On Mon, Oct 6, 2014 at 4:56 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hi,

 There is an API (/dataApprovals/multiple) for approving multiple
 datasets for a given period and org unit. But we don't have /multiple 
 api
 for accepting data (/acceptances).

 We have a scenario where we need to accept data for multiple
 datasets for a given period and org unit. Would it make sense to the
 broader DHIS2 community to have this API? Are you planning to write 
 api for
 the same or should we submit a patch?

 --
 Regards,
 Mansi Singhal


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





 --
 Regards,
 Mansi Singhal





 --
 Regards,
 Mansi Singhal





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

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

Sorry, not yet. The work on this was a bit disrupted this week by other
things. But I'm trying for the end of the weekend.


On Fri, Oct 10, 2014 at 1:58 AM, Mahendra Kariya 
mahendra.kar...@thoughtworks.com wrote:

 Hi Jim,

 We were wondering these changes have been checked in to trunk.

 On Mon, Oct 6, 2014 at 5:42 PM, Mansi Singhal msing...@thoughtworks.com
 wrote:

 Thanks.

 On Mon, Oct 6, 2014 at 5:35 PM, Jim Grace jimgr...@gmail.com wrote:

 Should be some time this week.


 On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal msing...@thoughtworks.com
  wrote:

 Hey Jim,

 Can you please tell us, By when these changes are expected to be there
 in trunk ?

 On Mon, Oct 6, 2014 at 4:52 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Mansi,

 We are refactoring some of the approvals service layer for 2.17, and
 will have the ability there already for multiple acceptances. I will add
 support for this in the API controller as well.

 Cheers,
 Jim


 On Mon, Oct 6, 2014 at 4:56 AM, Mansi Singhal 
 msing...@thoughtworks.com wrote:

 Hi,

 There is an API (/dataApprovals/multiple) for approving multiple
 datasets for a given period and org unit. But we don't have /multiple api
 for accepting data (/acceptances).

 We have a scenario where we need to accept data for multiple
 datasets for a given period and org unit. Would it make sense to the
 broader DHIS2 community to have this API? Are you planning to write api 
 for
 the same or should we submit a patch?

 --
 Regards,
 Mansi Singhal


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





 --
 Regards,
 Mansi Singhal





 --
 Regards,
 Mansi Singhal



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

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

Hi Mansi,

We are refactoring some of the approvals service layer for 2.17, and will
have the ability there already for multiple acceptances. I will add support
for this in the API controller as well.

Cheers,
Jim


On Mon, Oct 6, 2014 at 4:56 AM, Mansi Singhal msing...@thoughtworks.com
wrote:

 Hi,

 There is an API (/dataApprovals/multiple) for approving multiple datasets
 for a given period and org unit. But we don't have /multiple api for
 accepting data (/acceptances).

 We have a scenario where we need to accept data for multiple datasets
 for a given period and org unit. Would it make sense to the broader DHIS2
 community to have this API? Are you planning to write api for the same or
 should we submit a patch?

 --
 Regards,
 Mansi Singhal


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


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

Re: [Dhis2-devs] /multiple api for acceptance

[Jim Grace]

Should be some time this week.


On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal msing...@thoughtworks.com
wrote:

 Hey Jim,

 Can you please tell us, By when these changes are expected to be there in
 trunk ?

 On Mon, Oct 6, 2014 at 4:52 PM, Jim Grace jimgr...@gmail.com wrote:

 Hi Mansi,

 We are refactoring some of the approvals service layer for 2.17, and will
 have the ability there already for multiple acceptances. I will add support
 for this in the API controller as well.

 Cheers,
 Jim


 On Mon, Oct 6, 2014 at 4:56 AM, Mansi Singhal msing...@thoughtworks.com
 wrote:

 Hi,

 There is an API (/dataApprovals/multiple) for approving multiple
 datasets for a given period and org unit. But we don't have /multiple api
 for accepting data (/acceptances).

 We have a scenario where we need to accept data for multiple datasets
 for a given period and org unit. Would it make sense to the broader DHIS2
 community to have this API? Are you planning to write api for the same or
 should we submit a patch?

 --
 Regards,
 Mansi Singhal


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





 --
 Regards,
 Mansi Singhal

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

Re: [Dhis2-devs] Major changes to password handling

[Jim Grace]

Thanks, good work!


On Tue, Sep 30, 2014 at 10:37 AM, Halvdan Grelland halvda...@gmail.com
wrote:

 Hi devs,

 Starting from trunk rev. 16881 (2.17 snapshot) we've made some major
 changes to the password handling scheme of DHIS 2. In short: all passwords
 and restore tokens are now stored as bcrypt hashes with random salts. This
 gives a great boost to security, but might carry some challenges for
 developers.

 All existing users in the DB are now being migrated to bcrypt hashes *on
 login*. In production this should work smoothly. However in a development
 context you might encounter the following situation:

  - Logging in with any user on DHIS rev = 16881 will change the password
 hash to the new scheme.
  - A development branch which has not been merged with DHIS rev  16881
 yet will then fail to authenticate the same user (both branches run on the
 same dev db) as the hash is not a valid MD5 digest anymore.

 I strongly suggest you merge any active development branches with trunk
 ASAP to avoid this conflict. You could also run any older branches on a
 different database (the provided sample data has not yet been altered to
 reflect the new scheme).

 Feel free to email me if you have any questions.

 Halvdan Grelland

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


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

Re: [Dhis2-devs] Requirement related to indicators - Target vs achieved

[Jim Grace]

Hi Maheed,

Have you considered using attribute category options for your projects? If
this works for you, you could consider the following with current DHIS 2
features:

- enter any data that applies to a project by selecting the project.
- enter goals/target as separate data elements, selecting the same project.
- use data element groups and/or indicator groups for different types of
reporting needs, e.g. an indicator group for % complete for indicators that
divide data by target.

In analysis, such as pivot table or visualization, select the project(s)
and indicator(s), and report over a sufficient number of years to capture
all the data for any of your projects.

This assumes that you can enter data on a per-project basis. Or does the
data need to be entered regardless of project, and then you impose the
concept of project by goals that apply during a time period?

Cheers,
Jim



On Tue, Sep 2, 2014 at 6:00 AM, Maheed Ramadan maheed.rama...@nrc.no
wrote:

  Hi Bob,



 Regarding point 1, you’re right. What I meant is that currently the actual
 and target data elements are not related in a way or another. So what is
 missing is some way to link them.



 I am also with you that the target value could be either date bound and
 space bound. But I was just looking at it from a simple case/perspective.



 Maybe your point to define target values for indicators is logical. But if
 this is done so that we can select a target data element for an indicator,
 I don’t know how simple it is to implement technically as both indicators
 and target data elements are subject to time and space.



 At the end, I think what is mostly needed is to show/compare the actual 
 target values next to each other easily in pivot tables and/or reports.



 Thanks for your feedback. Looking forward to other people’s comments.





 Maheed







 *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
 *Sent:* Tuesday, September 02, 2014 11:59 AM
 *To:* Maheed Ramadan
 *Cc:* DHIS 2 Developers list; dhis2-users
 *Subject:* Re: [Dhis2-devs] Requirement related to indicators - Target vs
 achieved



 Hi Maheed



 I am sure you will get much more informed feedback on this question
 because I think its something many folk grapple with.  Just a quick
 observation regarding implementation.





 I don’t know if anybody have similar issues or requirements like this one.

 I think 2 thinks are missing here:

 1-  Cannot define the target value for a data element within the data
 element itself. It should be defined using another data element

 2-  The target value are not time-bound. This means we cannot set
 that the target value should be reached starting date X and ending date Y.

  These two seem to be contradictory.  Associating a target value with a
 data element sounds sensible enough except that it would then lose the
 sense of target time.  So you need to use another dataelement. ( I am not
 sure whether that is in fact what you are saying with 1 or you are pointing
 out what is missing).  Note the same time boundedness can also be true of
 space.  It is possible that different countries, provinces, districts set
 different target values.



 Do you think it makes more sense to focus on target values for indicators
 than dataelements?  (Oddly enough I imagine the measured value should be an
 indicator and the target value should be a dataelement because you'd want
 to enter these targets directly).



 So maybe what is missing is the ability to assign a target dataelement to
 an indicator definition.  So an indicator can have (an optional)
 dataelement associated with it for its target values.  Of course you can do
 this manually but, as you say, the reports become laborious.  Having an
 explicit association might make it easier to design smart reports.



 Look forward to hear what other people's experience is.



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


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

[Dhis2-devs] [Bug 1361982] Re: The items listed in a categorycombo api call are less than those listed on the corresponding dimension (using the API)

[Jim Grace]

To see a category's options through the api, try api/categories/.
For example in the demo system at https://apps.dhis2.org/demo/ the first
category, has 6 options as shown through the GUI. If you go to

https://apps.dhis2.org/demo/api/categories/KfdsGBcoiCa

and look under categoryOptions, you should see the same 6 options.
Note that category options and category combos are different things.
Does this help?

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

Title:
  The items listed in a categorycombo api call are less than those
  listed on the corresponding dimension (using the API)

Status in DHIS 2:
  New

Bug description:
  Hi All,

  When I view the category options assigned to a category via
  Maintenance- Data Elements  Indicators - Category, the items listed
  are fewer than those I get form the api/categoryCombos/ API call.

  How can I resolve this?

  DHIS v2.14 Build 13868
  OSX 10.9.4
  Chrome  36.0.1985.143

  Kind regards,

  Derick

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1361982/+subscriptions

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

[Dhis2-devs] [Bug 1361982] Re: The items listed in a categorycombo api call are less than those listed on the corresponding dimension (using the API)

[Jim Grace]

Thanks, I was comparing with api/categoryCombos/ as you had said.

On the demo system when I get a list of categories using
https://apps.dhis2.org/demo/api/categories, it shows that the
Commodities category has a UID of gtuVl6NbXQV. And when I get a list
of dimensions using https://apps.dhis2.org/demo/api/dimensions, it shows
that the Commodities dimension has the same UID of gtuVl6NbXQV. So the
two URLs to access the category and the associated dimension use the
same UID value:

https://apps.dhis2.org/demo/api/categories/gtuVl6NbXQV
https://apps.dhis2.org/demo/api/dimensions/gtuVl6NbXQV

The contents of these pages show the same three category options. Can
you verify whether you are really seeing different UIDs for the same
category and dimension?

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

Title:
  The items listed in a categorycombo api call are less than those
  listed on the corresponding dimension (using the API)

Status in DHIS 2:
  New

Bug description:
  Hi All,

  When I view the category options assigned to a category via
  Maintenance- Data Elements  Indicators - Category, the items listed
  are fewer than those I get form the api/categoryCombos/ API call.

  How can I resolve this?

  DHIS v2.14 Build 13868
  OSX 10.9.4
  Chrome  36.0.1985.143

  Kind regards,

  Derick

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1361982/+subscriptions

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

Re: [Dhis2-devs] Developer manual

[Jim Grace]

Hi Jason,

Sounds like a great idea. The user manual *is* rather large, and I agree
that it would be nice to make a manual more focused on people who are more
focused on the programming side of things.

Programming here is interpreted rather broadly, everything from using
curl with the API through integration with other software, app development,
and even core development. I agree that a good dividing place is to put in
the user manual everything that happens through the UI, and the other
things in the programming manual.

I also like Knut's idea of keeping some information in the user manual, so
that users know there is a next level. Perhaps this could evolve into a
programming chapter, or maybe a less scary name Customizing DHIS2. This
chapter would give an overview of the programming manual content, and the
user is referred to the programming manual for more information. Then a
technical user who wants more than they can get through the UI can be
directed to the programming manual. And a non-technical user who wants more
than they can get through the UI can ask their technical staff to consult
the programming manual and advise them. ;)

Cheers,
Jim



On Thu, Aug 21, 2014 at 8:25 AM, Farai Mutero fmut...@gmail.com wrote:

 Hi Jason

 This a most welcome development which will definitely revolutionize Web
 API driven web development. One issue which I recommend you to note would
 be:

 There have been so many changes in the Web API from 2.14 to 2.16 from the
 perspective of building apps on top of dhis2 such that there is always the
 risk of apps breaking when the underlying dhis2 backend is upgraded. So not
 sure how easy it will be to deal with such challenges in the upcoming
 manual. Maybe some tips and tricks (relevant to the dhis2 version in use)
 will suffice.
  Hi there. Based on some good feedback last week during the Oslo DHIS2
 Academy, I have made a first cut of a developer manual. As I see it, this
 basically involves slicing out all of the stuff really aimed more at
 developers (and in some cases implementers) and less so, users. The chapter
 on the WebAPI is being constantly expanded by the core developers, but in
 many cases, far exceeds the level of information required by most users.
 Some of the developers/implementers which I spoke with last week wanted
 more information in the developers manual. So, I think moving the really
 technical stuff to a dedicated developer manual would be a good idea, and
 allow even more detailed technical stuff to be written, without necessarily
 addressing the needs of the  users.

 I have , for the time being, left the sections (Technical architecture,
 Web API, Apps, and the appendix on R) in the main manual, but I think
 (depending on feedback from the community) that we can slice these out of
 the main user manual, and put them in a dedicated developer document.

 Thoughts?

 Regards,
 Jason


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


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


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

Re: [Dhis2-devs] Great video from Norad on DHIS 2 in Ghana

[Jim Grace]

Very nice. Thanks. I will share it!



On Wed, Jun 4, 2014 at 6:00 AM, Ola Hodne Titlestad ol...@ifi.uio.no
wrote:

 http://youtu.be/gFnnNWC55Iw

 Please feel free to share.

 Ola
 ---

 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
 https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16

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


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

Re: [Dhis2-devs] Atomic data validation rules

[Jim Grace]

 I also like the simpler option better (surprise).


WITYWS.


 If the default option clearly states that there is no change then we are
 not forcing the users who do not need this feature to even understand it.


Good. I think this will be a neat feature. The only challenges will be the
users understanding it. Will give my best shot a the the UI and the
documentation to facilitate this. ;)
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Atomic data validation rules

[Jim Grace]

I like it. A couple of ideas:

- I suggest that this be a new property of validation rules, rather than a
third type in addition to Validation and Surveillance. It could be
potentially useful for either of these two rule types.

- When selecting this option, the user could choose from a list of category
combos that then appears on the add validation rule screen. (We could even
present a list of category combos that are actually *used* by data
elements.) This list could be used to filter the data elements available
when creating the left and right sides, to make sure they all have the same
combos.

Cheers,
Jim



On Fri, May 23, 2014 at 3:55 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Hi Lars,
 Finally got around to creating the blueprint here

 https://blueprints.launchpad.net/dhis2/+spec/atomic-validation-rules

 Regards,
 Jason



 On Wed, Jan 15, 2014 at 6:36 PM, Lars Helge Øverland 
 larshe...@gmail.comwrote:

 Hi Jason,

 yes I think this makes sense. One could make a special kind of validation
 rule, with a constraint that all data elements on the left and right side
 expressions share the same category combination, and then tell the system
 to validate each and every category option combination. Feel free to write
 a blueprint.

 regards,

 Lars



 On Tue, Jan 14, 2014 at 3:52 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Devs,
 I came up against an issue today when looking at implementing a legacy
 database in DHIS2. In the old system, there are about 75 rules. The rules
 in the past have been applied at the atomic level, meaning that each and
 every data element category combination value is compared with a counter
 part. As an example.

 Number of persons currently receiving ART (including pregnant women)
 is greater than or equal to
 Number of individuals NEWLY initiating ART (including pregnant women)

 Each of these data elements are disaggregated by Gender and three age
 groups, and the validation rules need to be applied to each respective
 category combination options (not the totals).

 Although I do not know exactly how many rules we would need to to this,
 it is surely at least several hundred. I have not really come up against
 this before, and need to see if anyone has expericience with how the system
 behaves with large numbers of rules.

 I think it would be good to think about how to we could make the rules
 be applied within category combo options , without having to explicitly
 define each and every rule. Thoughts?

 Regards,
 Jason


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




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


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

Re: [Dhis2-devs] Atomic data validation rules

[Jim Grace]

Hi Jason,

Here's my idea: Add one extra field to ValidationRule, a reference to
DataElementCategoryCombo. If this is null, it means no change from the
current validation rule. If it's not null, it means that the validation
rule should be applied to all option combos within the category combo, for
any data element(s) reference in the left and right side expressions.

On the New Validation Rule screen, add an option right below Rule type
that selects whether or not this will be a template rule. (Except don't
use the word template -- too technical.) Maybe like what you said, or
Apply rule to category combinations (by default No). If Yes is
selected, another option pops into visibility just below to choose a
category combination. Once this is chosen, it is used to filter the list of
data elements that will be available to the editor in Edit left side and
Edit right side. Perhaps the Edit left side and Edit right side
buttons should then be disabled until a category combination is chosen.
Otherwise the UI is left the same -- just the addition of these two fields
and the data element filter. The user is free to make any expressions they
want, but the data elements used on the left and right side must all have
the same category combo.

From the software point of view this could be done much more simply in a
single dropdown of category option combos; it's a matter of the art of UI
design to make this all somewhat intelligible to the user. The semantics
would be that if you choose a combo, the data elements will be restricted
to those having the combo and the rule will be multiplied by every combo
option value. Using our pop-up contextual help feature on this screen (as
well as in many other areas of the product) would assist usability a lot!

At validation rule execution time, some pre-processing is done
in ValidationRunContext.java (to avoid processing things that are common to
a validation run for each org unit / period). We could add an extra private
method to this class that we could take each validation rule with a
category option combo, and multiply it to make an in-memory validation
rule (not persisted) for each category combo. This would be done by taking
the left and right side expressions, looking for the data element tags
inside the expression, and adding each category option combo, respectively,
onto each data element tag. Then the validation run could proceed without
any further modification.

Let me know what you think. I'm also happy to do the implementation if that
makes sense; I'm familiar with the code and it should be pretty quick.

Cheers,
Jim



On Fri, May 23, 2014 at 9:10 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Hi Jim
 Yes, I think I agree with you, but a still a bit fuzzy how it could happen
 with the current UI.  I think the user would have an option like Apply
 this rule to common category combo options, and they would then select a
 left side, and the right side would only show data elements with the same
 category combo. The user would not select individual data elements.  An
 operator would need to be selected as well, obviously.

 For the use case we are dealing with, it is always comparing two data
 elements, one which is typically a subset of another, which is quite common
 in HIV ME. Number counselled = Number tested = Number positive = Number
 receiving results.

 Regards,
 Jason



 On Fri, May 23, 2014 at 1:44 PM, Jim Grace jimgr...@gmail.com wrote:

 I like it. A couple of ideas:

 - I suggest that this be a new property of validation rules, rather than
 a third type in addition to Validation and Surveillance. It could be
 potentially useful for either of these two rule types.

 - When selecting this option, the user could choose from a list of
 category combos that then appears on the add validation rule screen. (We
 could even present a list of category combos that are actually *used* by
 data elements.) This list could be used to filter the data elements
 available when creating the left and right sides, to make sure they all
 have the same combos.

 Cheers,
 Jim



 On Fri, May 23, 2014 at 3:55 AM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Lars,
 Finally got around to creating the blueprint here

 https://blueprints.launchpad.net/dhis2/+spec/atomic-validation-rules

 Regards,
 Jason



 On Wed, Jan 15, 2014 at 6:36 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Jason,

 yes I think this makes sense. One could make a special kind of
 validation rule, with a constraint that all data elements on the left and
 right side expressions share the same category combination, and then tell
 the system to validate each and every category option combination. Feel
 free to write a blueprint.

 regards,

 Lars



 On Tue, Jan 14, 2014 at 3:52 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Devs,
 I came up against an issue today when looking at implementing a legacy
 database in DHIS2. In the old system, there are about 75 rules

Re: [Dhis2-devs-core] Calendar / DatePicker updates

[Jim Grace]

Excellent, thanks Morten.


On Tue, May 20, 2014 at 7:50 AM, Morten Olav Hansen morte...@gmail.comwrote:

 Hi guys

 As you have probably noticed, I have been working on implementing support
 for a more generic calendar in DHIS 2 (to support my ongoing work to have
 the Nepali calendar supported).

 This work is happening in branch
 https://code.launchpad.net/~dhis2-devs-core/dhis2/localized-calendar (I
 hope to have it merged soon).

 What is working:
 - Calendar and date format can be set in general settings - calendar
 - Data entry is updated to show proper local dates, will be converted to
 iso periods when saved
 - Add/edit orgUnit opening/closed date is using localized date picker

 To have this working, I have implemented:

 Java:
 - A new Calendar interface with multiple implementations
 - A new CalendarService which gives you current calendar and current date
 format

 JavaScript:
 - A new Period generator has been implemented which uses the system
 calendar to generate periods
 - A new localized date picker have been implemented which uses system
 generator

 If you use main.vm to bootstrap your page, you can use these two new
 global variables:
 dhis2.period.generator
 dhis2.period.picker

 And you can find more information about the API in dhis2.period.js (in
 commons)

 What I need from you guys:
 - If you want to get todays date, please use calendar.today(), and not jdk
 Calendar / Date since these are not localized
 - For any kind of date / calendar manipulation, please use calendar again
 (it has plusDays, plusWeeks etc)
 - If you use jquery ui date picker, please use the global date picker
 instead
 - When saving dates to the database, please convert to iso first
 (calendar.toIso), and convert to local when getting values out
 (calendar.fromIso)

 Jan: for extjs, please have a look at how the extjs date picker can be
 customized, you should be able to use the generator, but I'm not sure about
 the date picker..

 For 2.16 I think we will stop at input, all outputs will be implemented in
 2.17

 Please, if you have any questions / bug reports, please write directly and
 I will have a look

 --
 Morten

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


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

Re: [Dhis2-devs] [Bug 1311682] [NEW] Exception when adding validation rule groups

[Jim Grace]

Now fixed in 2.15. Will be in the next build.



On Wed, Apr 23, 2014 at 3:10 PM, Morten Olav Hansen 
1311...@bugs.launchpad.net wrote:

 This should be fixed in trunk now. I'm still branching 2.15 (it will take
 some time), will provide 2.15 fix when I can.

 --
 Morten


 On Wed, Apr 23, 2014 at 7:49 PM, Olav P 1311...@bugs.launchpad.net
 wrote:

  Public bug reported:
 
  With 2.15, it is not possible to add validation rule groups. Tested on
  two different databases/servers.
 
  HTTP Status 500 - Unable to instantiate Action,
 
 
 org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction,
  defined for 'addValidationRuleGroup' in namespace '/dhis-web-
  validationrule'Error creating bean with name
 
 
 'org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction'
  defined in URL [jar:file:/llocal/dhis/instances/demo/tomcat/webapps/demo
  /WEB-INF/lib/dhis-web-validationrule-2.15.jar!/META-INF/dhis/beans.xml]:
  Error setting property values; nested exception is
  org.springframework.beans.NotWritablePropertyException: Invalid property
  'userGroupService' of bean class
 
 
 [org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction]:
  Bean property 'userGroupService' is not writable or has an invalid
  setter method. Does the parameter type of the setter match the return
  type of the getter?
 
  ** Affects: dhis2
   Importance: Undecided
   Status: New
 
  --
  You received this bug notification because you are subscribed to DHIS.
  https://bugs.launchpad.net/bugs/1311682
 
  Title:
Exception when adding validation rule groups
 
  Status in DHIS 2:
New
 
  Bug description:
With 2.15, it is not possible to add validation rule groups. Tested on
two different databases/servers.
 
HTTP Status 500 - Unable to instantiate Action,
 
 
 org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction,
defined for 'addValidationRuleGroup' in namespace '/dhis-web-
validationrule'Error creating bean with name
 
 
 'org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction'
defined in URL
[jar:file:/llocal/dhis/instances/demo/tomcat/webapps/demo/WEB-INF/lib
/dhis-web-validationrule-2.15.jar!/META-INF/dhis/beans.xml]: Error
setting property values; nested exception is
org.springframework.beans.NotWritablePropertyException: Invalid
property 'userGroupService' of bean class
 
 
 [org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction]:
Bean property 'userGroupService' is not writable or has an invalid
setter method. Does the parameter type of the setter match the return
type of the getter?
 
  To manage notifications about this bug go to:
  https://bugs.launchpad.net/dhis2/+bug/1311682/+subscriptions
 

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

 Title:
   Exception when adding validation rule groups

 Status in DHIS 2:
   New

 Bug description:
   With 2.15, it is not possible to add validation rule groups. Tested on
   two different databases/servers.

   HTTP Status 500 - Unable to instantiate Action,

 org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction,
   defined for 'addValidationRuleGroup' in namespace '/dhis-web-
   validationrule'Error creating bean with name

 'org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction'
   defined in URL
   [jar:file:/llocal/dhis/instances/demo/tomcat/webapps/demo/WEB-INF/lib
   /dhis-web-validationrule-2.15.jar!/META-INF/dhis/beans.xml]: Error
   setting property values; nested exception is
   org.springframework.beans.NotWritablePropertyException: Invalid
   property 'userGroupService' of bean class

 [org.hisp.dhis.validationrule.action.validationrulegroup.AddValidationRuleGroupAction]:
   Bean property 'userGroupService' is not writable or has an invalid
   setter method. Does the parameter type of the setter match the return
   type of the getter?

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/dhis2/+bug/1311682/+subscriptions

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

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

Re: [Dhis2-devs] [Dhis2-users] Suggestion on the Validation rule using surveillance [User role to alert]

[Jim Grace]

Dear Muhire Andrew,

That's an excellent suggestion, and that's probably how we should have done
it in the first place. Others have made this suggestion also, and we have
implemented it. Starting in 2.15 (about to be released) validation rule
notifications will be based on user groups instead of user roles.

Cheers,
Jim Grace



On Sun, Apr 13, 2014 at 8:35 AM, Muhire Andrew muhireand...@yahoo.comwrote:

 Dear Community,

 I have one input to make on Validation rule using surveillance, instead of
 having User role to alert, It can be more better to use User group. Because
 it is possible to have one user role working on different categories of
 users. This can make us to create a user role called alertMCH,
 ALERTMALARIA, ALERTIMMUNISATION.BUT USER GROUP CAN BE A SOLUTION.

 Regards
 --
 Better Information, better Decisions, better Health


 * Muhire Andrew*
 * Ministry of Health / HMIS*
 *A mind is a terrible thing to waste*

 ***

  ** Cell:(+25)0788436150**
 *** Twitter :andrewmuhire***
  skype:muhire_andrew
 *muhireand...@yahoo.com muhireand...@yahoo.com*

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


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

Re: [Dhis2-devs] Surveillance Alerts - Sending Alerts

[Jim Grace]

Hi Ola,

Actually the alert does not keep going off. Each time the nightly
surveillance run starts, it records in a system property the time of the
start. In the subsequent run the next night, it only considers alerts that
involve data values that have been entered since the start of the pervious
run.

We save the start of the run to be conservative, just in case new data is
entered in the middle of a run as the alert task is running. Worst case is
if some data is entered in the middle of a run, it may be reported that
night and the next night too -- which is better than not reporting it at
all.

The time is noted at the start of the run, but not written in the database
until the end of the run. So if there is a system failure in the middle of
the alert run, the new data will be reported in the next run.

The very first time the alerts are run, it looks at all the data from the
periods just finished (previous day, previous week, previous month, etc.)
After that, subsequent runs just give the new incremental news.

So the alerts are kind of like a headline news service, to report the
latest news. This can be used for data quality (in which case the data
should be fixed so the alerts are resolved) or for surveillance, in which
case the data should not necessarily be resolved because it is reporting
a health issue of concern. You can configure different rules going to
different groups of users for one or both types of these functions on the
same system.

In the case of data quality, a user can always run the same validations
again at any point (covering as much past data as they like) to see if any
issues have been resolved.

Cheers,
Jim



On Thu, Mar 13, 2014 at 4:05 PM, Ola Hodne Titlestad ol...@ifi.uio.nowrote:

 Hi,

 I also see a need to be able to configure how we deal with (repeated)
 alerts over time.
 If the data is not changed the alert will be re-created every night as it
 is right now, correct?

 I have some ideas for improvements, but would be good to hear what others
 are thinking here.

 - should we have some kind of status on the alert, to turn it off or
 snooze (1 day, 3 days, 7 days etc.) that the alert recipients can update?
 - should we allow the pre-configuration of how alerts are repeated? -e.g.
 send again after 1,3,5,7,10 days if data has not changed.
 - should we allow for pre-configuration of escalating alerts where new
 user groups are alerted if the alert is not resolved? E.g. (just an
 example):
 1st (0 days) alert to district surveillance officers, 2nd alert
 after 7 days to province surveillance officers, 3rd alert after 12
 days to national surveillance officers

 Ola
 -



 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps 
 linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


 On 13 March 2014 09:13, Prosper BT ptb3...@gmail.com wrote:

 Thanks Guys,

 I think the role was also affecting its use, I go for user groups.

 Regards


 On Thu, Mar 13, 2014 at 11:12 AM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Good. I would say lets change to groups, not too many are using it still.

 Lars
 On Mar 12, 2014 6:44 PM, Jim Grace jimgr...@gmail.com wrote:

 An option to configure this per validation rule group sounds fine. In
 the interest of not making this too complicated for the user, would it
 better to leave it with roles (optionally restricted within the org unit
 hierarchy), or change the implementation from roles to user groups
 (optionally restricted within the org unit hierarchy).

 Of course we could support both roles and user groups, but I'm just
 trying to see if we can keep it simpler for the user.

 Cheers,
 Jim



 On Wed, Mar 12, 2014 at 1:11 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 I think the suggestion from Jim is good. Could it be configurable by
 validation rule group? So we have a true/false option send alerts to 
 users
 within hierarchy only or similar on the validation rule group. Then
 messages only goes out to users who have the originating org unit of the
 alert in their sub-hierarchies.

 I think in general having user roles and not user groups was a (my)
 mistake - we could simply change it.

 regards,

 Lars



 On Thu, Mar 6, 2014 at 8:26 PM, Prosper BT ptb3...@gmail.com wrote:

 Yes Jim this would suit my use case, but not sure if its global
 enough others can comment may be


 On Thu, Mar 6, 2014 at 10:23 PM, Jim Grace jimgr...@gmail.comwrote:

 Maybe the most useful next step is to leave the user interface the
 same, but filter for the organisation unit assigned to the user when
 sending the messages. So for example a national user would see alerts 
 from
 anywhere in the country, but a district user

Re: [Dhis2-devs] Surveillance Alerts - Sending Alerts

[Jim Grace]

An option to configure this per validation rule group sounds fine. In the
interest of not making this too complicated for the user, would it better
to leave it with roles (optionally restricted within the org unit
hierarchy), or change the implementation from roles to user groups
(optionally restricted within the org unit hierarchy).

Of course we could support both roles and user groups, but I'm just trying
to see if we can keep it simpler for the user.

Cheers,
Jim



On Wed, Mar 12, 2014 at 1:11 PM, Lars Helge Øverland larshe...@gmail.comwrote:

 I think the suggestion from Jim is good. Could it be configurable by
 validation rule group? So we have a true/false option send alerts to users
 within hierarchy only or similar on the validation rule group. Then
 messages only goes out to users who have the originating org unit of the
 alert in their sub-hierarchies.

 I think in general having user roles and not user groups was a (my)
 mistake - we could simply change it.

 regards,

 Lars



 On Thu, Mar 6, 2014 at 8:26 PM, Prosper BT ptb3...@gmail.com wrote:

 Yes Jim this would suit my use case, but not sure if its global enough
 others can comment may be


 On Thu, Mar 6, 2014 at 10:23 PM, Jim Grace jimgr...@gmail.com wrote:

 Maybe the most useful next step is to leave the user interface the same,
 but filter for the organisation unit assigned to the user when sending the
 messages. So for example a national user would see alerts from anywhere in
 the country, but a district user would see alerts only from within their
 district. (We probably should have done it that way in the first place!)
 Would this help?

 Cheers,
 Jim


 On Thu, Mar 6, 2014 at 2:15 PM, Prosper BT ptb3...@gmail.com wrote:

 Thanks Jim for the quick response.

 As we talk about the two the more I see them complicated.

 For the user role, my use case is on the Uganda national system where
 user roles and creating users is guarded like a gold mine. Only two people
 allowed to create roles and users though the rest of us can create user
 groups. But for now I will ask them to create a user role with only one
 role that can do much with the system and try it out.

 For the second one, my use case is in four districts where community
 health workers are sending weekly maternal surveillance reports. These are
 like over 4000 villages in level 5 on the hierarchy. I want districts at
 level 3 to receive alerts whenever a death is reported

 So if I implement it the way it is now, I have to create 4 district
 accounts and assign all them the alert user role. Once a death happen in
 one district all the districts will receive the alert.

 May be as you suggest we should add hierarchy selection (level) in
 creating the rule and if we specify sending to a given level (district,
  region, national,...) an alert is only sent to only users assigned to that
 level and only for that hierarchy of that orgunit.

 Example

 Uganda/Northern Region/Gulu District/Alur Soubcounty/Gulu
 Hospital/Village A
 Uganda/Western Region/Kibaale District/Mutoke Soubcounty/Kagadi
 Hospital/Village W

 If death is reported from Village W and the rule was set to send to
 only users at level 3 only users assigned to Kibaale District with the
 alert role should receive the alert, but if level 1 is chosen then all
 users assigned to Uganda would receive the alert.

 Regards




 On Thu, Mar 6, 2014 at 9:39 PM, Jim Grace jimgr...@gmail.com wrote:

 You also raise a good point about sending alerts from different parts
 of the org unit hierarchy to different groups of users. I'm trying to
 imagine how this could be configured. Perhaps when you configure a
 validation rule group you could choose a point in the org unit hierarchy
 and assign a user group to be alerted for organisations at or below that
 point -- and then you could make similar assignments for other points in
 the org unit hierarchy as well. This sounds very useful to me, if a bit
 awkward. Can you imagine a simpler mechanism?

 If you can say a bit more about the use case, that also strengthens
 the case for a new feature. In particular, can you tell me what kinds of
 position(s) the users have who want to know about maternal or
 neonatal deaths in their district?

 Thanks,
 Jim


 On Thu, Mar 6, 2014 at 1:17 PM, Jim Grace jimgr...@gmail.com wrote:

 Prosper, thanks for the feedback. The role is only used to identify a
 group of users, so it doesn't matter what authorities the role has. You
 could create any number of otherwise dummy roles for this purpose.

 But your point is very well taken that user groups are in general
 easier to set up and administer (without needing the authority to create
 roles.) That's a very good suggestion for the future.

  Thanks,
 Jim



 On Thu, Mar 6, 2014 at 12:53 PM, Prosper BT ptb3...@gmail.comwrote:

 Dear Team and Jim

 Thanks for this validation rule type that helps us send alerts above
 set thresholds. Am planning to implement it on one of our use case -
 Maternal