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 
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 
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 
> 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 >> > 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 
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] Predictors and Tracker dataelements

[Jim Grace]

Hi Djibril Hakim,

No, predictor output is only to aggregate data values. I will make this
clearer in the documentation. A predicted value is made for a given period,
by using aggregate data for that period and/or event data aggregated over
that period, so it makes sense to store it in aggregate data that is
associated with a period.

If this not work well for you, I would be interested to hear more about the
use case. Perhaps there is another approach where you can use with existing
DHIS2 features. Or perhaps we should consider something more flexible in
the future.

Cheers,
Jim Grace


On Tue, Mar 27, 2018 at 11:30 AM, DJIBRIL Hakim 
wrote:

> Hi all,
> PLEASE ! Does Predictors applicable to tracker datalements as output?
> If yes I understand that we need to specify the program also but can't see
> the selection of programm through the predictor UI.
>
> best
>
> ___
> 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  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  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 
>> 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 
>>>> 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 
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&E*
> 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 
> 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&E*
>> Email: n.mift...@gmail.com
>> Cell:+8801914030574 <01914-030574>
>> Skype: nayeem.a.m
>>
>> On Wed, Sep 28, 2016 at 5:24 PM, Jim Grace  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 
>>> 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&E*
>>>> 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  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  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 
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&utm_medium=email&utm_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]

rkflow 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  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  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  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  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:

[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  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  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  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  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,

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  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  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  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 
>>>>> 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 
>>>>>>

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  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  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 
>>> 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
>>&g

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  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  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" options
>> that include t

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 ot

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 
> 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 list: https://launchpad.net/~dhis2-

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 
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&E*
> 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 
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  wrote:

> Welcome Thomas!
>
> Knut
> On 24 May 2016 9:09 p.m., "Lars Helge Øverland"  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] 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  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  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&utm_medium=email&utm_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&utm_medium=email&utm_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  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 
> 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  | 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  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  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  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 
>> 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  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 to have the illusion that they are
>>&

[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 
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 
> 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  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 
>>> 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
>>>>
>&

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 
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 
> 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

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 
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 
> 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

[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

[Dhis2-devs] [Bug 1505189] [NEW] Event Capture Report date field duplicated

[Jim Grace]

Public bug reported:

For events without registration, and without program stage sections
defined, the "Report date" field is unnecessarily duplicated at the top
of the form. This has appeared in recent builds of 2.20. Please backport
the fix to 2.20

To reproduce on apps.dhis2.org/demo: Create a new program, type "Without
registration", and assign an orgUnit to it (like the root orgUnit). Then
enter a new event against this program. You will see the "Report date"
field listed 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/1505189

Title:
  Event Capture Report date field duplicated

Status in DHIS:
  New

Bug description:
  For events without registration, and without program stage sections
  defined, the "Report date" field is unnecessarily duplicated at the
  top of the form. This has appeared in recent builds of 2.20. Please
  backport the fix to 2.20

  To reproduce on apps.dhis2.org/demo: Create a new program, type
  "Without registration", and assign an orgUnit to it (like the root
  orgUnit). Then enter a new event against this program. You will see
  the "Report date" field listed twice.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1505189/+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] stian sandvold joins as developer

[Jim Grace]

Welcome, Stian!


On Fri, Aug 28, 2015 at 1:50 PM, Abyot Gizaw  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 
>
>
> ___
> 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] nicolay ramm joins as developer

[Jim Grace]

Welcome, Nicolay!


On Fri, Aug 28, 2015 at 12:39 PM, Halvdan Grelland 
wrote:

> Welcome to the team!
>
> 2015-08-28 17:49 GMT+02:00 Lars Helge Øverland :
>
>> 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 
>>
>>
>> ___
>> 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  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 
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  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  >
> > 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 
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] Spanish and French accents in reports as filters

[Jim Grace]

Hi Jose,

If you're using Tomcat, you might want to check and be sure that server.xml
has the 
wrote:

>
> Hi Morten,
>
> Yes, sorry, I am talking about Event Reports (see attached image). When we
> try to filter by '5A09 - Inma Yeanet Pérez Gutierrez' we get a "no values
> found". However, the data is there. I am assuming because it contains the
> accent é.
>
> On Mon, May 11, 2015 at 10:38 AM, Morten Olav Hansen 
> wrote:
>
>> Hi
>>
>> Can you give me a bit more information? where exactly is this? is it in
>> the UI? web-api? which reporting facility?
>>
>> --
>> Morten
>>
>> On Mon, May 11, 2015 at 2:46 PM, Jose Garcia Muñoz 
>> wrote:
>>
>>>
>>> Hi devs,
>>>
>>> We are not being able to filter the reports by options which contains
>>> accents. We just got a "No Values found" message. I have test it with 2.17
>>> and 2.18 (not yet with 2.19). Do you have any plans to allow the use of
>>> this characters in the coming future? This is quite important for our Latin
>>> and French spaking countries users...
>>>
>>> Regards
>>> Jose
>>>
>>> ___
>>> 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] [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 
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 
> 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
>>> ,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 
>>> Date: 2015-01-30 8:39 GMT+02:00
>>> Subject: Re: [Dhis2-users] Issue on Data approval
>>> To: DHIS 2 developers , "
>>> 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 
>>> *À :* DHIS 2 developers ; "
>>> 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 report>data 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]

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 
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 
> *À :* 'Jim Grace' 
> *Cc :* 'dhis1-users' ; 'DHIS 2
> developers' 
> *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 
> 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 
> 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]

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 
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 
> 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 
> 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]

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 
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 
>
> *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 
> 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]

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  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] 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] [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 
wrote:

> What version? It is there from 2.17.
>
> Lars
>
> On Wed, Feb 4, 2015 at 5:51 PM, Bob Jolliffe 
> 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  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):
>
> 
>
> 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:
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
> Note the xml is incidental.  The point is the tree structure. Mind you,
> java doesn't have a built in tree type but it does have a DOM model which
> could be used very adequately for this kind of structure (tip off
> stackoverflow).  Assuming we had created such a DOM model for a particular
> categorycombo, then we can answer our question of wha

[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  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 
> 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  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 
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]

Makes sense.


On Thu, Dec 4, 2014 at 2:29 PM, Bob Jolliffe  wrote:

> Yes data synchronisation is the name of the game, but the current feature
> is a bit too crude.  I don't think it will actually prove too useful as is
> and I am not sure the wisdom of making it too sophisticated.
>
> We've been down this alley before when I embedded an apache camel engine
> into dhis2 to do this synchronisation sort of stuff - that was pretty
> flexible but a bit too cumbersome to configure so we decided it was better
> to manage this sort of thing externally.  The trouble is the use cases get
> a little complex to try and code for all eventualities - for example here
> in rwanda (where I currently am) the simplest case is to pull data from a
> dataelement group and post it on to a datawarehouse.  It gets more complex
>  when the dataelements need to be further aggregated/manipulated/mapped and
> more complex still when you get them from a "foreign" system (like ihris).
>
> So there is no easy escaping from external scripts that pull from one,
> transform/map/translate and push to another.  But I want to try as much as
> possible to pull using the api rather than through sql.  In this case
> having the DE_GROUP-xx thing will solve the problem in the future and will
> be a simple enough feature to implement.  I think the right approach
> currently is to keep chipping away at making the api as useful as possible
> by addressing use cases as they emerge.
>
> On 4 December 2014 at 21:12, Jim Grace  wrote:
>
>> 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 
>> 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  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 
>>>>> 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  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  wrote:
>
>> Would a SQL View work for you?
>>
>>
>> On Thu, Dec 4, 2014 at 1:48 PM, Lars Helge Øverland 
>> 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 
>>> 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 a SQL View work for you?


On Thu, Dec 4, 2014 at 1:48 PM, Lars Helge Øverland 
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 
> 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  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=true&ds=a00b93a8e1a&ds=a0264329d97&ds=a170b8cd5e5&ds=a1869d7c13a&ds=a1a3292f7ce&ds=a2d8612eae4&ds=a3a7972730b&ds=a3e7dd2a626&ds=a3ff8b407cb&ds=a6f379ec1b2&ds=a717250c552&ds=a798ad4eca5&ds=a80a255363a&ds=a9982fbd7a5&ds=aa73eadc073&ds=ab4a6b62fb9&ds=ab6203b3306&ds=ad7fe0ff2af&ds=aed7f5a4bc5&ds=af2c2344212&ds=afcb8adfba5&endDate=2014-11-17&ou=3d760c3a11a&ou=e3e286c6ca8&startDate=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.idleve

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

[Jim Grace]

at 
> org.hisp.dhis.webapi.controller.DataApprovalController.getApproval(DataApprovalController.java:228)
>   at 
> org.hisp.dhis.webapi.controller.DataApprovalController$$FastClassBySpringCGLIB$$3201324d.invoke()
>   at 
> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
>   at 
> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:640)
>   at 
> org.hisp.dhis.webapi.controller.DataApprovalController$$EnhancerBySpringCGLIB$$e9879b14.getApproval()
>   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>   at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>   at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>   at java.lang.reflect.Method.invoke(Method.java:606)
>   at 
> org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
>   at 
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
>   at 
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
>   at 
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
>   at 
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
>   at 
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
>   at 
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
>   at 
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
>   at 
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
>   ... 73 more
> Caused by: org.postgresql.util.PSQLException: ERROR: relation 
> "_orgunitstructure" does not exist
>   Position: 1930
>   at 
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>   at 
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>   at 
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
>   at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
>   at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
>   at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285)
>   at 
> com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
>   at 
> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452)
>   at 
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
>   ... 110 more
>
>
>
> On Fri, Nov 14, 2014 at 2:36 AM, Jim Grace  wrote:
>
>> OK, I guess I'm hoping not to hear from you. ;)
>>
>>
>> On Thu, Nov 13, 2014 at 9:06 AM, Shantala Raman 
>> 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  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
>>

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 
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  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 > > 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  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 
>>>>>>> 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 
>>>>>>>>>> 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,

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 
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  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  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 
>>>>>>>> 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 
>>>>>>>>>> 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  wrote:

>  Welcome Eivind, from the PSI team!
>  --
>   Nicola Hobby
> MIS Program Manager
>
> Office: +1 (202) 469-6685
> Skype: nicolahobby
>
> *Connect with PSI*
> Website   |  Blog   |
> Twitter   |  Facebook
>   |  YouTube
> 
>
>  
> 
> 
> 
>
>  Donate to PSI
> www.psi.org. 94.5 cents of every dollar raised directly supports PSI
> programs.
>
>
>   From: Morten Olav Hansen 
> Date: Wednesday, November 12, 2014 at 8:40 AM
> To: Jan Henrik Øverland 
> Cc: dhis2-users , 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  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]

Very nice script, thanks. Maybe I should start scripting in Python as well!


On Fri, Oct 24, 2014 at 11:42 AM, Adebusoye Anifalaje 
wrote:

> Hi JM,
>
> I had a similar requirement a few weeks back. Pierre from Jembi helped
> with python scripting to convert all the user invites in csv to Json. It
> was then relatively easy to have multiple invites sent out in one command.
>
> If it helps, I have attached the script below and copied Pierre. He had
> mentioned working on this as a contribution to the community.
>
> Best regards,
> Busoye
>
>
>
> On 24 Oct 2014, at 16:01, Jim Grace  wrote:
>
> 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
>
>
>
>
___
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  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 >> > wrote:
>>>
>>>> Thanks.
>>>>
>>>> On Mon, Oct 6, 2014 at 5:35 PM, Jim Grace  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  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 
> wrote:
>
>> Thanks.
>>
>> On Mon, Oct 6, 2014 at 5:35 PM, Jim Grace  wrote:
>>
>>> Should be some time this week.
>>>
>>>
>>> On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal >> > 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  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]

Should be some time this week.


On Mon, Oct 6, 2014 at 7:51 AM, Mansi Singhal 
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  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 
>> 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] /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 
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] Major changes to password handling

[Jim Grace]

Thanks, good work!


On Tue, Sep 30, 2014 at 10:37 AM, Halvdan Grelland 
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 
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]

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

[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 , 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

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  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] [Dhis2-users] halvdan grelland joins as developer

[Jim Grace]

Welcome, Grelland!

Cheers,
Jim



On Sun, Jun 22, 2014 at 3:36 PM, Ese Egerega  wrote:

> Welcome Grelland!
>
> Ese
>
>
> On Friday, June 20, 2014, Lars Helge Øverland  wrote:
>
>> Hi all,
>>
>> I have the pleasure to announce that Halvdan Grelland has joined the team
>> as software developer on a 30% basis.
>>
>> Halvdan is currently a student at University of Oslo and has demonstrated
>> solid skills during the dhis-related course. He has previously worked for
>> the norwegian defence research establishment
>> .
>>
>> We are happy to get you on the team. Welcome!
>>
>> regards,
>>
>> Lars
>>
>>
>>
>
> --
> Sent from Ese's iPhone
>
> ___
> 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] 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 
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
> 
>
> ___
> 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'm liking the simpler option of just adding one dropdown with category
combinations, called something like "Repeat validation rule using". The
default dropdown selection could be something like "[ Use validation rule
as is ]" or "[ Don't repeat rule ]". The following choices are the option
combos: "Age", "Sex", "Age/Sex", or whatever.

On Fri, May 23, 2014 at 2:07 PM, Jim Grace  wrote:

> 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 M&E. Number counselled <= Number tested <= Number positive <= Number
>> receiving results.
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Fri, May 23, 2014 at 1:44 PM, Jim Grace  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 scr

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 M&E. Number counselled <= Number tested <= Number positive <= Number
> receiving results.
>
> Regards,
> Jason
>
>
>
> On Fri, May 23, 2014 at 1:44 PM, Jim Grace  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 <
>>

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 
> 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. 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] [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 wrote:

> 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 *
>
> ___
> 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