Re: [Dhis2-users] Adding a time lag functionality to DHIS2

[Jim Grace]

Hazim, you are not alone!

We are looking at exactly this kind of thing now, based on requests from
many users. Just now I've commented on this at
https://community.dhis2.org/t/expression-enhancements-to-space-shift-and-time-shift-data/774
.

In the meantime you might consider the use of predictors that can be used
to bring data forward in time and store it in new data elements, which can
then be used in indicators alongside current data. This does require new
data elements, and storing the same data under two different periods in the
database. We hope to be able to avoid this in the future by allowing
time-shifting in the indicators themselves, very much like what you saw in
the Launchpad blueprint. But using predictors is something you could do
today with existing DHIS2 functionality.

Cheers,
Jim Grace

On Mon, Nov 5, 2018 at 5:41 PM TIMIMI, Hazim Bakir  wrote:

> There are various things we would like to calculate using data from
> different time periods, such as % change between one period and the next,
> or to perform cohort analysis. I see this was raised in 2015 (see
> https://blueprints.launchpad.net/dhis2/+spec/indicator-time-lags).
>
>
>
> Does anyone have any experience of doing this in DHIS2? I didn’t find
> anything on JIRA. We surely can’t be the only people wondering about this?
>
>
>
> Any helpful hints would be most welcome!
>
>
>
> Thanks,
>
> Hazim
>
>
>
> …..
> Hazim Timimi
> Data Manager, Tuberculosis Monitoring and Evaluation, World Health
> Organization, Geneva, Switzerland
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


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

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Category option combinations associated with a data element

[Jim Grace]

https://play.dhis2.org/2.29/api/dataElements?fields=name,id,categoryCombo[categoryOptionCombos[id,name]]

On Wed, Jun 20, 2018 at 10:28 AM, Shurajit Dutta 
wrote:

> Hi everyone
>
> What is the best method to determine which category option combinations
> are associated with a data element, particularly in the case where there
> are multiple copies of the same combination. If this is just an API call
> would appreciate it being shared!
>
> Thanks,
> Nick
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] 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-d...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.picker...@gmail.com
>>> tel:+46764147049
>>>
>>
>>
>>
>> --
>> Regards,
>> Leke Seweje
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> John Francis Mukulu,
> Software Architect, HISPTZ.
> https://hisptanzania.org/
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Approval Workflow Bug

[Jim Grace]

Hi Kate,

Sorry we hadn't gotten to this one yet. I will look into it today and see
what I can do.

What version of DHIS 2 are you using?

Cheers,
Jim


On Tue, Apr 17, 2018 at 1:42 PM, Hesel, Kate  wrote:

> Hello All,
>
> Long time listserve lurker here, seeking advice on a bug:
>
> We're implementing approvals workflows in our instance and experiencing
> behavior where unapproved data is still visible in analytics, even when
> specified to not be. It is the same as the bug reported here in Jira:
> https://jira.dhis2.org/browse/DHIS2-3304
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__jira.dhis2.org_browse_DHIS2-2D3304&d=DwMFaQ&c=M9Y9dUXA_fD4PBleyTV_Lw&r=m4gxa-VtZIK54tuV3rla4t_LAbI8DD16nHm7O0a17eM&m=Q6zgEq939cRLS5XjIsvOms_P7Dht8Un3McFUAqpc5O0&s=2T5_MkeKsebHfpJ5YXksWY59nzrJmyJblgPX10h_AmA&e=>
> .
>
> Having data hidden in analytics is critical to our workflow (and to most
> approval workflows, I'd imagine). Has anyone else experienced this issue?
> Did you find a workaround? We'd also be interested to know the status of
> the bug fix.
>
> Thanks in advance
>
> Kate
>
> --
>
>
> *Kate Hesel, MPH*
>
> Program Officer - Monitoring, Evaluation and Learning
> Planned Parenthood Global
>
> (w) 212.261.4508
> (m) 617.902.8511
> Skype: katehesel
>
> Web <http://www.plannedparenthood.org/global> / Twitter
> <http://www.twitter.com/ppglobe>
>
> *This e-mail is for the sole use of the intended recipient(s) and contains
> information which is confidential and/or legally privileged. If you are
> not
> the intended recipient, you are hereby notified that any disclosure,
> copying, distribution or taking of any action in reliance on the contents
> of this e-mail information is strictly prohibited. If you have received
> this e-mail in error, please immediately notify the sender by reply e-mail
> and destroy all copies of the original message.*
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] VALIDATION RULES

[Jim Grace]

Hi Alex,

At the moment the only way to compare the data between different months in
validation rules is to use predictors -- define a predictor to pull the
data into a different data element in the current period from the past
period (like 3 months ago if you want -- use a predictor sequential sample
count of 3 and a skip count of 2.) Then use a validation rule to compare
the two data elements in the same period. For more about predictors, see
https://docs.dhis2.org/master/en/user/html/manage_predictor.html

The downsides of this are you have to define extra data elements and
predictors, and run the predictors before you do the validation, and store
extra data in the database.

For the future, we are looking at possible extensions to expressions that
would let you process past period data and current period data in the same
expression. If you would like this to apply to validation rules, please
submit a Jira issue to this effect, and preferably tell us more about the
application -- like what kind of data you have and why you want to compare
it between months. This will help us to prioritize the work if we know more
about the use case. :) Then let me know and I will link the issue to the
Jira Epic at https://jira.dhis2.org/browse/DHIS2-3187 where we are
gathering these requirements.

Thanks!

Cheers,
Jim


On Wed, Apr 11, 2018 at 1:03 PM, arungatom65  wrote:

> That is true Mr Akumba validation rules work on defined periods
>
>
>
> Sent from my Samsung Galaxy smartphone.
>  Original message 
> From: Barnabas Akumba 
> Date: 11/04/2018 19:09 (GMT+03:00)
> To: Alex Macharia 
> Cc: dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] VALIDATION RULES
>
> Hello Alex Macharia,
>
> The validation rule analysis page gives you the ability to select a
> range of dates (Start Date and End Date). This means if you want to
> validate data for last three months, you'll have to select the First
> date of the First Month i.e. 1st January, 2018 and Last date of March,
> i.e. 31st March, 2018.
> This will validate all the data that falls between the dates selected
> and give you the corresponding output.
>
> I don't know if this addresses your concern?
>
> Regards
>
> On 4/11/18, Alex Macharia  wrote:
> > Hi,
> >
> > I there a way of creating a VALIDATION RULE that checks into other
> periods?
> >
> > I wish to validate current month in reference to data entered 3 months
> ago.
> >
> > Thanks
> >
> > --
> > ALEX MACHARIA
> >
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Indicator based on previous year's output

[Jim Grace]

Hi Edward,

1. You might consider using predictors. Define additional data elements
(with disaggregations if you like) for your targets. Use predictors to
populate those data elements in the new period based on values from the old
period(s). You can use a predictor formula to sum past data, and even add
5% if you like. Then you will have predicted (target) data in the same
period to compare with your results in that period. For details see
https://docs.dhis2.org/master/en/user/html/manage_predictor.html

2. We are considering possible future enhancements to analytics expressions
including things like pulling data from past periods into an indicator. If
this would be more useful to you than using predictors, please write up a
DHIS2 Jira ticket that describes your use case (the kinds of things you've
said in this email thread would be just fine), and reference the Epic at
https://jira.dhis2.org/browse/DHIS2-3187 (or let me know and I will
reference it -- I'm not sure what privilege is required for this.)

Cheers,
Jim


On Wed, Mar 28, 2018 at 4:05 PM, Tlohang  wrote:

> Hi Edward
>
> I see that I was on a different page altogether.
> Well, I think your situation can still be addressed within DHIS 2 but you
> may have to do some java scripts to manage the data that has to be
> retrieved from the previous periods. We've done something close to this
> with one of our programmes.
>
> Regards,
>
> Tlohang
>
> On 28 Mar 2018 19:53, Edward Robinson 
> wrote:
>
> Thanks Tlohang, yes, I’m aware that we can produce a cumulative number of
> x over a period, but I need to then use those numbers to compare data from
> another period as covered in my last mail, hence I assumed I may be able to
> achieve it using an indicator.  Sorry that I was a bit brief in my initial
> mail,
>
> Regards
>
> Ed
>
>
>
> *From:* Tlohang 
> *Sent:* Wednesday, 28 March 2018 7:18 PM
> *To:* Edward Robinson 
> *Cc:* DHIS Users 
> *Subject:* Re: [Dhis2-users] Indicator based on previous year's output
>
>
>
> Hi Edward
>
>
>
> You probably don't need an indicator for that. The knows how to analyse
> that data element in that cumulative manner once you choose that period
> during analysis.
>
>
>
> I hope this helps.
>
>
>
> Regards,
>
> Tlohang
>
>
>
> On 28 Mar 2018 17:34, Edward Robinson 
> wrote:
>
> What’s the best approach to creating an indicator that’s based on a
> cumulative total of a data element captured monthly, for a set timeframe?
>
>
>
> E.g. I have an indicator called “Number of patients” captured monthly.
>
> I need an indicator that will give me the total number of patients for the
> set period October 2016 – September 2017.
>
>
>
> Thanks in advance!
>
>
>
>
>
> _______
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Predictors - Skip Zero ou Null values

[Jim Grace]

Hi Sakibou,

I can't think of in any simple way to do this, but below is a possible
workaround.

There is a Jira "Epic" at https://jira.dhis2.org/browse/DHIS2-3187 to track
use cases for possible extensions to analytics expressions (like the
expressions for Indicator and Program Indicator). As part of this, we will
also be considering possible extensions to predictors. If anyone has needs
that might be met by additional abilities of these expressions, please
create a Jira ticket and let me know.

The possible workaround:

Do you have a maximum number of periods you want to look back? Let's say
you want to look back for a maximum of 5 periods. You could create 5
predictors to copy these values into the current period:

Predictor Previous1, sequential sample count = 1, outputs to PreviousData1.
Predictor Previous2, sequential sample count = 2, skip count = 1, outputs
to PreviousData2.
Predictor Previous3, sequential sample count = 3, skip count = 2, outputs
to PreviousData3.
Predictor Previous4, sequential sample count = 4, skip count = 3, outputs
to PreviousData4.
Predictor Previous5, sequential sample count = 5, skip count = 4, outputs
to PreviousData5.

Then create another predictor with some IF logic, like:

IF( ! ISNULL(PreviousData1) && PreviousData1 != 0, PreviousData1,
IF( ! ISNULL(PreviousData2) && PreviousData2 != 0, PreviousData2,
IF( ! ISNULL(PreviousData3) && PreviousData3 != 0, PreviousData3,
IF( ! ISNULL(PreviousData4) && PreviousData4 != 0, PreviousData4,
IF( ! ISNULL(PreviousData5) && PreviousData5 != 0, PreviousData5, 0 ) ) ) )
)

You will need to make sure the first 5 predictors run for a period before
the last one does.

Cheers,
Jim


On Thu, Mar 22, 2018 at 8:59 PM, Sakibou ALASSANI 
wrote:

> Hi,
> Please I want to know if Predictors can do that or if not what is the
> workaround.
> I want to SUM 2 past value for one dataElement, but only for 2 periods
> where I have Data not ZERO or NULL.
>
> Use case: to generate data in March. we can SUM ( Feb + Jan) . But If no
> data for example in January, How automaticaly Take December Data if not
> Take November data.
>
> Thank you.
>
>
> **Sakibou
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] trouble with the Default form for data entry

[Jim Grace]

Hi Adam Preston,

Also please check that the category combination Gender contains the
category Gender. (It's not enough for them to have the same name.)

Cheers,
Jim Grace


On Thu, Mar 22, 2018 at 5:25 AM, Nayeem Al Mifthah 
wrote:

> Hi Adam Preston
> Kindly look in category option combo if the option combos have already
> created or not.
>
>
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M&E and Surveillance*
> Email: n.mift...@gmail.com
> Cell:+8801914030574 <+880%201914-030574>
> Skype: nayeem.a.m
>
> On Thu, Mar 22, 2018 at 9:44 AM, Adam Preston 
> wrote:
>
>> Hi everyone.
>>
>> I am running 2..28 and am having a hard time getting the default data
>> entry form to include the category options. According to here
>> <https://docs.dhis2.org/2.26/en/user/html/manage_data_set.html#about_dataset_dataform>
>> :
>>
>> "A default form consist of a list of the data elements belonging to the
>> data set together with a column for inputting the values. If your data
>> set contains data elements with a non-default category combination, for
>> example age groups or gender, additional columns are automatically
>> created in the default form based on the different categories"
>>
>> However, when my default data entry form looks like this:
>>
>>
>>
>> Where:
>>
>> Category Name: Gender
>> Data Dimension Type: Disaggregation
>> Category Option: Male, Female
>>
>> Category Combination Name: Gender
>> Data Dimension Type: Disaggregation
>>
>> Data Element: Persons Trained
>> Category Combination: Gender
>> Domain Type: Aggregate
>>
>> Data Set: Monthly F Data Set
>> Category Combination: None
>> Data Element: Persons Trained
>>
>>
>> It feels like I have something cached, but I can't figure out what (I
>> have tried clearing the browser cache many times)
>>
>>
>> Is there anything else I can do?
>>
>>
>>
>>
>>
>> Sent from Outlook <http://aka.ms/weboutlook>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Using attribute options in indicators

[Jim Grace]

Hi Nick,

Yes, in version 2.27 and onwards you can do exactly that. The
attributeoptcombo-id can be given as a third element in an indicator
variable after the dataelement-id and categoryoptcombo-id. See the
documentation at
https://docs.dhis2.org/master/en/developer/html/webapi_indicators.html.

Cheers,
Jim


On Tue, Mar 20, 2018 at 12:17 AM, Shurajit Dutta 
wrote:

> Hi everyone
>
> Is it possible to use attribute options in indicators calculations. For
> example if I have two partners assigned to a dataset, PSI and Save the
> Children but I only want to include PSI data in the indicator.
>
> Thanks
> Nick
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] what's mean of attribute option combos?

[Jim Grace]

Yes, with attribute option combos you can add any number of additional,
independent, user-defined dimensions to a data set. They are made in the
same way as category option combos: You define one or more categories that
have options, and you combine these categories into a category combo.

Here are some comparisons between category option combos and attribute
option combos:

Category option combo:
- Used for data element disaggregations
- Category combo is assigned to a data element
- All combo values can be entered in a single data set form instance
- Combos are selected by entering data into different fields

Attribute option combos:
- Used for extra dimensions for an entire data set
- Category combo is assigned to a data set
- Only one combination can be entered on a single data set form instance
- Category options are chosen by dropdown menu(s) for the entire form

Examples of attribute option combos can be found at
https://play.dhis2.org/demo in the following data sets:

ART monthly summary - Implementing Partner and Projects (2 options in the
option combo)
Emergency Response - Target vs Result (1 option in the option combo)
EPI Stock - Project (1 option in the option combo)

Note that you need multiple options in the option combo only for truly
independent dimensions. If for example you want project number and partner,
but the project number always uniquely determines the partner, you can use
a single category of project number in the category combo, and then use
category option groups for the partner associated with each project number.
You can even simulate a multi-level dimension by using different category
option group sets. For example, PEPFAR uses a single category of project
number that uniquely determines both a partner and an agency. Partners are
represented by category option groups in the group set "Partner", and
Agencies are represented by category option groups in the group set
"Agency".

We know that the user documentation does not really explain attribute
option combos, and we will address this. Meanwhile you may find interesting
a slide deck I presented at the most recent Experts Academy in Oslo in
August: https://goo.gl/tzmq44

Let me (and the Dhis2-users list) know if you have further questions.

Cheers,
Jim Grace


On Tue, Dec 12, 2017 at 7:23 PM, 林晓东  wrote:

> hi,all
>What's mean of attribute option combos?  how to use?
>I just found it using in data collecting, and assign to dataset, which
> means we can adding extra attribute to all of dataset's DE after DE has
> been defined?
>   
>  Thanks.
>
>
>
>
> --
> 此致
>
>林晓东
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Data Element Version??

[Jim Grace]

Along the same lines, I was thinking of attribute option combinations. The
problem is the same; they should be summable. You could set up some users
to have access to only the final ones used in reporting. But any users with
access to both could inadvertently and confusingly see the sums.

On Tue, Nov 14, 2017 at 4:49 PM, Knut Staring  wrote:

> Perhaps with categoryoptions? Raw, Clear etc. However, that would violate
> the heuristic that categories should be summable, eg male+female=everyone
>
> On Nov 14, 2017 10:27 PM, "Adam Preston"  wrote:
>
>> Greetings from Colorado, USA.
>>
>> I have a project that would like to maintain different versions of the
>> data in DHIS2. For example, they have a bunch of data elements they are
>> getting externally and these would be considered as one version, they do a
>> bunch of cleaning and this would be another version. So when running the
>> reports they would select the version of the data. How can I do this?
>>
>>
>> Sent from Outlook <http://aka.ms/weboutlook>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] Cant not create new approval levels in 2.26

[Jim Grace]

Birk Johansson made the fix, after I determined that the fix needed to be
done in the front end code. Now that we're migrating the user interface to
apps, they're in separate repositories. I see the 2.27 fix in the
settings-app repository at
https://github.com/dhis2/settings-app/commit/8747d606029cb510f178cf86005acf33cc9e0a7c.
I'm not sure where the 2.26 fix is, but I rebuilt the latest 2.26 on my
system and it worked. If you have further questions about the fix, Birk
might be able to shed more light on it.

Cheers,
Jim


On Fri, Nov 10, 2017 at 11:58 AM, Jasper Timm <
jasper.t...@ehealthnigeria.org> wrote:

> Hi Jim,
>
> I can't seem to see the commit for this fix in the 2.26 or 2.27 branch on
> the dhis2-core repo in github.
>
> Did you commit somewhere else?
>
> Thanks,
>
> - Jasper
>
> On Mon, Nov 6, 2017 at 11:48 PM, Ibrahim Bayoh  ehealthafrica.org> wrote:
>
>> thanks, Jim. You are a lifesaver. I'll test and get back to you.
>>
>> Best,
>> Bayoh.
>>
>> On Mon, Nov 6, 2017 at 8:43 PM Jim Grace  wrote:
>>
>>> It's fixed now in the latest builds of 2.26 and 2.27. Apologies for the
>>> long delay.
>>>
>>> Cheers,
>>> Jim
>>>
>>>
>>> On Thu, Nov 2, 2017 at 5:30 AM, Ibrahim Bayoh <
>>> ibrahim.ba...@sl.ehealthafrica.org> wrote:
>>>
>>>> Thanks, Jim
>>>> It seems like this issue has been around for a while. When do you think
>>>> we'll get a fix for it?
>>>> Thanks,
>>>> Bayoh.
>>>>
>>>> On Thu, Oct 26, 2017 at 1:27 PM Trøyel Nerbø 
>>>> wrote:
>>>>
>>>>> FYI: I also reported this in June. https://jira.dhis2.org/browse/
>>>>> DHIS2-1831?jql=issuetype%20%3D%20Bug%20AND%20text%20~%20approval
>>>>>
>>>>>
>>>>>
>>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=
>>>>> nrc...@lists.launchpad.net] *On Behalf Of *Jim Grace
>>>>> *Sent:* torsdag 26. oktober 2017 14.18
>>>>> *To:* Ibrahim Bayoh 
>>>>> *Cc:* dhis2-users 
>>>>> *Subject:* Re: [Dhis2-users] Cant not create new approval levels in
>>>>> 2.26
>>>>>
>>>>>
>>>>>
>>>>> Hi Bayoh,
>>>>>
>>>>>
>>>>>
>>>>> I have reproduced this problem in 2.26 and 2.27. I have created a Jira
>>>>> ticket for this at https://jira.dhis2.org/browse/DHIS2-2449.
>>>>>
>>>>>
>>>>>
>>>>> Apologies for this problem. Thank you for bringing this to our
>>>>> attention. We will fix it.
>>>>>
>>>>>
>>>>>
>>>>> Cheers,
>>>>>
>>>>> Jim
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Oct 26, 2017 at 7:30 AM, Ibrahim Bayoh <
>>>>> ibrahim.ba...@sl.ehealthafrica.org> wrote:
>>>>>
>>>>> Hi All,
>>>>>
>>>>> Am trying to create approval level in 2.26 which failed on saving
>>>>> level. Console error reveals a "Missing required property 'name' " error.
>>>>> See screenshots below.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Bayoh.
>>>>>
>>>>>
>>>>>
>>>>> [image: Screen Shot 2017-10-26 at 11.10.35 AM.png]
>>>>>
>>>>> [image: Screen Shot 2017-10-26 at 11.26.10 AM.png]
>>>>>
>>>>> --
>>>>>
>>>>> Ibrahim Bayoh
>>>>>
>>>>>
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>> Jim Grace
>>>>>
>>>>> Core developer, DHIS 2
>>>>>
>>>>> HISP US Inc.
>>>>>
>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>
>>>> --
>>>> Ibrahim Bayoh
>>>>
>>>
>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>> --
>> Ibrahim Bayoh
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *Jasper Timm*
>
> Lead Software Developer
>
> *eHealth Africa*
>
> Mobile +232 99891119 <+23299891119>
>
> www.ehealthafrica.org
>
>
> <http://www.ehealthafrica.org/>
>
>


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

Re: [Dhis2-users] Cant not create new approval levels in 2.26

[Jim Grace]

It's fixed now in the latest builds of 2.26 and 2.27. Apologies for the
long delay.

Cheers,
Jim


On Thu, Nov 2, 2017 at 5:30 AM, Ibrahim Bayoh <
ibrahim.ba...@sl.ehealthafrica.org> wrote:

> Thanks, Jim
> It seems like this issue has been around for a while. When do you think
> we'll get a fix for it?
> Thanks,
> Bayoh.
>
> On Thu, Oct 26, 2017 at 1:27 PM Trøyel Nerbø  wrote:
>
>> FYI: I also reported this in June. https://jira.dhis2.org/browse/
>> DHIS2-1831?jql=issuetype%20%3D%20Bug%20AND%20text%20~%20approval
>>
>>
>>
>> *From:* Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=
>> nrc...@lists.launchpad.net] *On Behalf Of *Jim Grace
>> *Sent:* torsdag 26. oktober 2017 14.18
>> *To:* Ibrahim Bayoh 
>> *Cc:* dhis2-users 
>> *Subject:* Re: [Dhis2-users] Cant not create new approval levels in 2.26
>>
>>
>>
>> Hi Bayoh,
>>
>>
>>
>> I have reproduced this problem in 2.26 and 2.27. I have created a Jira
>> ticket for this at https://jira.dhis2.org/browse/DHIS2-2449.
>>
>>
>>
>> Apologies for this problem. Thank you for bringing this to our attention.
>> We will fix it.
>>
>>
>>
>> Cheers,
>>
>> Jim
>>
>>
>>
>>
>>
>> On Thu, Oct 26, 2017 at 7:30 AM, Ibrahim Bayoh > ehealthafrica.org> wrote:
>>
>> Hi All,
>>
>> Am trying to create approval level in 2.26 which failed on saving level.
>> Console error reveals a "Missing required property 'name' " error. See
>> screenshots below.
>>
>> Thanks,
>>
>> Bayoh.
>>
>>
>>
>> [image: Screen Shot 2017-10-26 at 11.10.35 AM.png]
>>
>> [image: Screen Shot 2017-10-26 at 11.26.10 AM.png]
>>
>> --
>>
>> Ibrahim Bayoh
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>>
>>
>> --
>>
>> Jim Grace
>>
>> Core developer, DHIS 2
>>
>> HISP US Inc.
>>
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
> --
> Ibrahim Bayoh
>



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

Re: [Dhis2-users] 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-users@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Predictors for "carry forward" and cohorts

[Jim Grace]

Hi Olav and Nick,

Thanks, that's neat. These are uses we never thought of for predictors!

There are no limits on how far back you can go with sequential and skip
sample counts, so I think your technique for bringing forward cohorts
should be good.

Cheers,
Jim


On Thu, Jun 29, 2017 at 8:07 AM, Olav Poppe  wrote:

> Thanks Nick, I think you describe a potentially «generic» approach to
> copying data N months forward which I didn’t think of! Essentially setting
> the sequential sample count to N and the skip count to N-1 (or N+1 and N -
> will have to test). If there aren’t any limits in how many months back you
> could go, this could take care of any cohort period, e.g. 12, 24, 36 etc.
>
> Regards
> Olav
>
>
>
>
>
>
> 29. jun. 2017 kl. 13.33 skrev Shurajit Dutta :
>
> Sorry!
>
> I thought about this for a second again. For 6 months I think it's more
> like this
>
> Period type = Monthly
> Annual sample count = 0
> Sequential sample count = 5
> Sequential skip count = 4
>
> This would eg. take data only from January 2017 to fill in the June 2017
> cohort.
>
> On Jun 29, 2017 10:23 PM, "Shurajit Dutta" 
> wrote:
>
> Hi Olav
>
> I am not sure about all cohort types, would have to look a bit more. I
> believe for 6 months cohort it might work like this (remember I haven't
> tested).
>
> Period type = Monthly
> Annual sample count = 0
> Sequential sample count = 6
> Sequential skip = 5
>
> Then it would exclude the first 5 months of data in relation to the sample
> selected while also going 6 months back.
>
> I guess you could potentially do the same for the other cohorts as long as
> your skip identified how far back you went?
>
> Perhaps I need to test this myself
>
> Nick
>
>
> On Jun 27, 2017 8:44 PM, "Olav Poppe"  wrote:
>
> Hi all,
> I wanted to check if anyone had any experience using predictors for 1)
> «carry forward» of values from one period to the following, or 2) copying
> cohort data forward?
>
> As far as I can tell from some limited testing, 1) should work as it is
> now by setting sequential sample count to 1 and annual sample count to 0.
> You could then for example copy ending balance for May 2017 to starting
> balance June 2017 etc. (note: I don’t mean to start a discussion how to
> collect data on stock).
>
> Moving forward cohorts would similarly work today, but only for 12 month
> cohorts as far as I can figure out. From what I understand, even 12-month
> cohorts are sometimes in reality reported after e.g. 14 months, and there
> are of course others (6 months, 24 months, 36 months). At least on the
> surface, it would seem adding support for specifying the sample period as X
> months back would be a relatively straightforward thing, and it would be
> very helpful for this purpose. I know people are using custom script for
> this type of thing today.
>
> Regards
> Olav
>
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] 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-users@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

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

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

Re: [Dhis2-users] [Dhis2-devs] 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-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> _______
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


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

Re: [Dhis2-users] 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-users@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-users@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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] Data approval workflow for programs

[Jim Grace]

Hi David,

Your understanding is correct. The 2.22 (and 2.23) API calls still refer to
dataset instead of workflow.

- When you "approve" a dataset, you are really approving the workflow
connected to the dataset. (This also approves data in any other datasets
that are also connected to the same workflow.)

- When you get the approval status of a dataset, you are really getting the
approval status of the workflow connected to the dataset.

We do intend to offer workflow-related API approval calls in the future,
and we may at some point retire the dataset-related API approval calls.  We
were not quick to drop the dataset-related calls because we know there are
applications out there that use them.

Cheers,
Jim


On Tue, Apr 12, 2016 at 1:58 PM, David Siang Fong Oh 
wrote:

> Hi Jim,
>
> We are in the process of migrating to v2.22 (and the data approval
> workflows) and are trying to understand the implications for the approvals
> API:
>
>- In v2.22 calls to the data approvals API will still be specified
>using an orgUnit, a period, and *a dataset*. The response will reflect
>however, the state of the approval for the orgUnit, period and associated
>*workflow,* not dataset. Similarly any POST calls will modify the
>approval for the workflow, not the dataset.
>- In v2.23 (or later) the data approvals API will be changed so that
>you specify a workflow directly. Referencing the dataset will be removed.
>
> Is the above correct?
>
> Cheers,
>
> -doh
>
> On Thu, Feb 11, 2016 at 6:26 PM, Jim Grace  wrote:
>
>> Hi Eric,
>>
>> We're sorry, it didn't make it into 2.22. But it should be there in 2.23.
>> What did make it into 2.22 is the "workflow" object, upon which we will
>> base approvals for programs, see
>> https://blueprints.launchpad.net/dhis2/+spec/approval-workflows. In
>> 2.22, rather than approving a dataset (for a given period, organization
>> unit, etc.), approvals operate on a higher level object called a
>> "workflow". This has three advantages: (1) multiple datasets can reference
>> the same workflow and be approved together if desired (or each dataset can
>> have its own workflow), (2) each workflow can reference a subset of
>> approval levels, if not all types of approvals should use all approval
>> levels, and (3) in the future, we will use the workflows for approving
>> programs as well. In fact, a single workflow will be able to approve a
>> single program, or multiple programs, or a mix of programs and datasets,
>> etc.
>>
>> Something we are still working on is understanding best how, or even
>> whether, to lock out program event entry for periods that have been
>> approved. Event entry uses a date picker, and it doesn't easily lend itself
>> to locking out various approved periods. Date pickers generally can be
>> constrained only to a single valid date range from a start date to an end
>> date. Alternatives include that we could set start and/or end dates in the
>> date picker according to what range of time has not been approved, and/or
>> we could have some javascript validation logic to check against approved
>> periods after the user has entered the date. We're still discussing what
>> would be best.
>>
>> It would be helpful if you could share with us any anticipated use case
>> you have for program data approval. Is it important to you that users not
>> be able to enter event data for periods that have been approved? Is it
>> important that event data be hidden from higher level users until approved?
>> Do you expect past periods will be approved up until a point in time and
>> future periods beyond that point will be unapproved -- or might there
>> sometimes be alternating periods that are approved and unapproved?
>>
>> If you -- and anyone else -- can tell us about your anticipated use cases
>> for program data approvals, it will increase the chance that we will finish
>> this feature in a way that will work well for you. :)
>>
>> Cheers,
>> Jim
>>
>> On Thu, Feb 11, 2016 at 6:51 AM, eric mourin 
>> wrote:
>>
>>> Hi everyone,
>>>
>>> I was wondering if the data approval workflow for programs has been
>>> implemented yet, I've seen in a past email (
>>> https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg08144.html)
>>> that it was planned to be released for the current version (2.22) but it
>>> does not seem to work yet.
>>>
>>> Thanks in advance!
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dh

Re: [Dhis2-users] Data approval workflow for programs

[Jim Grace]

Hi Eric,

We're sorry, it didn't make it into 2.22. But it should be there in 2.23.
What did make it into 2.22 is the "workflow" object, upon which we will
base approvals for programs, see
https://blueprints.launchpad.net/dhis2/+spec/approval-workflows. In 2.22,
rather than approving a dataset (for a given period, organization unit,
etc.), approvals operate on a higher level object called a "workflow". This
has three advantages: (1) multiple datasets can reference the same workflow
and be approved together if desired (or each dataset can have its own
workflow), (2) each workflow can reference a subset of approval levels, if
not all types of approvals should use all approval levels, and (3) in the
future, we will use the workflows for approving programs as well. In fact,
a single workflow will be able to approve a single program, or multiple
programs, or a mix of programs and datasets, etc.

Something we are still working on is understanding best how, or even
whether, to lock out program event entry for periods that have been
approved. Event entry uses a date picker, and it doesn't easily lend itself
to locking out various approved periods. Date pickers generally can be
constrained only to a single valid date range from a start date to an end
date. Alternatives include that we could set start and/or end dates in the
date picker according to what range of time has not been approved, and/or
we could have some javascript validation logic to check against approved
periods after the user has entered the date. We're still discussing what
would be best.

It would be helpful if you could share with us any anticipated use case you
have for program data approval. Is it important to you that users not be
able to enter event data for periods that have been approved? Is it
important that event data be hidden from higher level users until approved?
Do you expect past periods will be approved up until a point in time and
future periods beyond that point will be unapproved -- or might there
sometimes be alternating periods that are approved and unapproved?

If you -- and anyone else -- can tell us about your anticipated use cases
for program data approvals, it will increase the chance that we will finish
this feature in a way that will work well for you. :)

Cheers,
Jim

On Thu, Feb 11, 2016 at 6:51 AM, eric mourin  wrote:

> Hi everyone,
>
> I was wondering if the data approval workflow for programs has been
> implemented yet, I've seen in a past email (
> https://www.mail-archive.com/dhis2-users@lists.launchpad.net/msg08144.html)
> that it was planned to be released for the current version (2.22) but it
> does not seem to work yet.
>
> Thanks in advance!
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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

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

Re: [Dhis2-users] Problem selecting a parent org. unit for a unit

[Jim Grace]

Hi Archana,

You can try patching the database with something like the following, then
either restart DHIS 2 (restart Tomcat), or go to Apps -> Data
Administration -> Cache Statistics -> Clear cache

insert into usermembership (organisationunitid, userinfoid) values (
(select organisationunitid from organisationunit where parentid is null),
(select userid from users where username = 'admin') );

This should result in admin being assigned to both the root and the Level 4
org unit. You can then go in and unassign the level 4 org unit if you like.

Cheers,
Jim


On Thu, Jan 21, 2016 at 8:16 AM, Knut Staring  wrote:

> I think you will have to do that directly in the database.
>
> On Thu, Jan 21, 2016 at 2:01 PM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
>> Hi,
>>
>> On DHIS2, I have set up an organisational structure with 5 levels. The
>> admin user is assigned to ROOT Organisation Unit.
>>
>> Later, I assigned the admin to Level 4 Org. Unit and unselected the Root
>> Org. Unit.
>> The admin can now only see or access, the Org. Unit assigned and the ones
>> nested below.
>>
>> How can I re-assign the user to Root Organisation Unit ??
>>
>> I am using DHIS version 2.22
>>
>> Any suggestions??
>>
>>
>>
>> Thanks & Regards,
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> 
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

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

[Dhis2-users] 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

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

Re: [Dhis2-users] Surveillance rule

[Jim Grace]

Hi João,

There are two things I can think of:

1. What happens when you change the operator from ">=" to "<"? Note that
the surveillance rule will send an alert if the condition is *not* met.

2. Are you trying to validate a form? Surveillance rules are not used when
validating forms. They are only used when evaluating a group of validation
rules containing them, either manually or in a scheduled run.

Cheers,
Jim


On Thu, Jul 16, 2015 at 1:54 AM, Joao Mazuze 
wrote:

>  Hi Jim,
>
> I tried to according to your explanation, but still not working. See
> definition bellow, but is always passing successfully when running
> validation rule, even when rule is violated.
>
>
>
> Kind  regards,
>
> João
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 16 July 2015 02:33
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rule
>
>
>
> Hi João,
>
>
>
> To compare a data element's value with the previous month, create a
> validation rule of type "Surveillance", period type "Monthly", set the
> "Sequential sample count" to 1, and leave the "Annual sample count" blank
> (or zero.)
>
>
>
> Then when you reference the data element on the left side of the equation,
> it refers to the value for the current month. When you reference it on the
> right side, it refers to the value in the previous month. For example if
> you are looking at June 2015 data, the June 2015 data will be used on the
> left side of the equation, and May 2015 data will be used on the right side.
>
>
>
> If you wanted to compare the data element's value with the average value
> of the previous (n) months, put the count (n) into the "Sequential sample
> count". For example, if you set Sequential sample count to 2 and are
> looking at June 2015 data, then June 2015 data will be used on the left
> side of the equation, and the average value between April and May 2015 will
> be used on the right side.
>
>
>
> I hope this helps. Let me know if you have any other questions.
>
>
>
> Cheers,
>
> Jim
>
>
>
>
>
> On Wed, Jul 15, 2015 at 6:35 AM, Joao Mazuze 
> wrote:
>
> Dear all,
>
> I need to compare values between previous and current month for the same
> data element, I know that one solution is to create a surveillance rule,
> but seems not working as it is always successfully validate, can anyone
> explain me how this works? May be the problem is how am defining the  
> “*sequential
> sample count”*, as explained bellow, I do not understand well what this
> means.
>
>
>
> ·Enter a *Sequential sample count*. This is the number of time
> periods immediately preceding against which you wish to compare the data.
> For example, if the period type is *Weekly* and this count is 2, the
> current data will be compared with past data averaged over each of the 2
> previous weeks.
>
> Kind regards,
>
> João
>
>
>
>
>
>
>
> Kind regards
>
> _
>
> João Gabriel Mazuze
>
> National Database Manager
>
> Projecto CHASS-SMT
>
> Abt Associates Inc.
>
> Av. Marginal, 4067
>
> Cidade de Maputo, Moçambique
>
> Fax: (+ 258)  21486767
>
> Tel:  (+ 258)  21493525/6/8
>
> Cell: (+258) 82 4236279
>
> www.chasssmt.com
>
>
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: Description: Description: Logotipo CHASS-SMT]
>
> *Somos um projecto financiado  pelo PEPFAR-II, através da USAID, para
> reforçar o Sistema de Saúde das Provincias de  Sofala, Manica e Tete.
> Pretendemos melhorar a ligação e integração do HIV  com os Cuidados
> Primários de Saúde e outros a ele relacionados em coordenação com as
> Direcções Provinciais de Saúde e outros parceiros. Através do projecto
> CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da
> qualidade dos Serviços de Saúde no país.*
>
>
>
>
>
>
>  --
>
> 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://he

Re: [Dhis2-users] Surveillance rule

[Jim Grace]

Hi João,

To compare a data element's value with the previous month, create a
validation rule of type "Surveillance", period type "Monthly", set the
"Sequential sample count" to 1, and leave the "Annual sample count" blank
(or zero.)

Then when you reference the data element on the left side of the equation,
it refers to the value for the current month. When you reference it on the
right side, it refers to the value in the previous month. For example if
you are looking at June 2015 data, the June 2015 data will be used on the
left side of the equation, and May 2015 data will be used on the right side.

If you wanted to compare the data element's value with the average value of
the previous (n) months, put the count (n) into the "Sequential sample
count". For example, if you set Sequential sample count to 2 and are
looking at June 2015 data, then June 2015 data will be used on the left
side of the equation, and the average value between April and May 2015 will
be used on the right side.

I hope this helps. Let me know if you have any other questions.

Cheers,
Jim


On Wed, Jul 15, 2015 at 6:35 AM, Joao Mazuze 
wrote:

>  Dear all,
>
> I need to compare values between previous and current month for the same
> data element, I know that one solution is to create a surveillance rule,
> but seems not working as it is always successfully validate, can anyone
> explain me how this works? May be the problem is how am defining the  
> “*sequential
> sample count”*, as explained bellow, I do not understand well what this
> means.
>
>
>
> ·Enter a *Sequential sample count*. This is the number of time
> periods immediately preceding against which you wish to compare the data.
> For example, if the period type is *Weekly* and this count is 2, the
> current data will be compared with past data averaged over each of the 2
> previous weeks.
>
> Kind regards,
>
> João
>
>
>
>
>
>
>
> Kind regards
>
> _
>
> João Gabriel Mazuze
>
> National Database Manager
>
> Projecto CHASS-SMT
>
> Abt Associates Inc.
>
> Av. Marginal, 4067
>
> Cidade de Maputo, Moçambique
>
> Fax: (+ 258)  21486767
>
> Tel:  (+ 258)  21493525/6/8
>
> Cell: (+258) 82 4236279
>
> www.chasssmt.com
>
>
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: Description: Description: Logotipo CHASS-SMT]
>
> *Somos um projecto financiado  pelo PEPFAR-II, através da USAID, para
> reforçar o Sistema de Saúde das Provincias de  Sofala, Manica e Tete.
> Pretendemos melhorar a ligação e integração do HIV  com os Cuidados
> Primários de Saúde e outros a ele relacionados em coordenação com as
> Direcções Provinciais de Saúde e outros parceiros. Através do projecto
> CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da
> qualidade dos Serviços de Saúde no país.*
>
>
>
>
>
>
> --
> 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Surveillance rules

[Jim Grace]

Thank you, Joao.

Others may be able to speak to this better than I, but validating
cumulative data values may not be a strong use case for a DHIS 2 feature.
The DHIS 2 documentation generally advises against collecting cumulative
numbers in data elements. See for example
https://www.dhis2.org/doc/snapshot/en/implementer/html/dhis2_implementation_guide_en_full.html#d3287e894

Instead, it is recommended to collect only the incremental number that is
added during a time period. This allows a single data value to be entered
-- the count for that month -- and it can be analyzed in DHIS 2 both as a
new count and a cumulative count through time. See for example the use of
indicators to represent cumulative data in
https://www.dhis2.org/doc/snapshot/en/implementer/html/dhis2_implementation_guide_en_full.html#d3287e965

Cheers,
Jim


On Thu, May 14, 2015 at 9:33 AM, Joao Mazuze 
wrote:

>  Yes Jim, these values are cumulative, that´s why we have to compare with
> previous period to avoid user data entry errors. We have often got  many
> problems when analysing data in our reports because of user entry errors,
> so we think this feature will solve this, comparing before post and
> alerting the user if the value entered is lower than previous one.
>
>
>
> Cheers,
>
> Joao
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 14 May 2015 15:24
>
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rules
>
>
>
> Hi Joao,
>
>
>
> Can you say more about the semantics of what you want to compare with past
> periods? For example, are these cumulative values? What do they measure?
>
>
>
> The reason I ask these questions is to understand better the potential
> usefulness of adding this feature to DHIS 2. If you have a compelling use
> case, and if it is consistent with the philosophy of how DHIS 2 is used,
> then it will add more weight to this feature as we compare its priority to
> other possible enhancements.
>
>
>
> Cheers,
>
> Jim
>
>
>
>
>
> On Thu, May 14, 2015 at 9:08 AM, Joao Mazuze 
> wrote:
>
> Hi Jim,
>
> Of course I was trying to validate in an input form. In my own case I have
> a set of data elements that after  entered  current period  values for this
> data elements we have to compare with the respective  immediate previous
> period values as in our scenario will not make sense when user enter
> greater values for the current period when compared to previous. That’s why
> I tried to create an example on the demo site as described on my last
> email, but unfortunately did not work, even when running “validation rule
> analysis” after assigned to “validation rule group”, called   *Testing*.
>
>
>
> Kind regards,
>
> Joao
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 14 May 2015 14:53
>
>
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rules
>
>
>
> Thank you Joao.
>
>
>
> Were you trying to use this validation rule to validate data in an input
> form? Surveillance-type rules are not designed to work this way. They are
> used after data entry to look for patterns in the data, when added to a
> validation rule group and run under "Validation Rule Analysis".
>
>
>
> If you were trying to validate data against previous values, I would like
> to know more about your use case. Can you say more about what the data
> elements are, and how they should relate to previous periods?
>
>
>
> Cheers,
>
> Jim
>
>
>
>
>
> On Thu, May 14, 2015 at 8:30 AM, Joao Mazuze 
> wrote:
>
> Thank you Jim,
>
> Here is the problem´s background:
>
> We need to compare current period value from previous one (monthly period)
> as the current one it is mandatory to be greater than other. In this case
> on the demo system I made an example for *Bumban MCHP* org unit,
> comparing between *March 2015* and *April 2015 *for dataelement “BCG
> doses given (<1y)”, for any value applied to this dataelement the
> validation always passes successfully, what is strange, the related
> surveillance rule is called “*testePreviousPeriod”*. Our goal is to be
> able to compare those monthly periodical datavalues.
>
>
>
> Kind regards
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 14 May 2015 14:15
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rules
>
>
>
> Hi Joao,
>
>
>
> A surveillance-type validation rule should work as you say, comparing the
> current values of the left side with previous values of the right side. I
> don't know why you aren't seeing this behavi

Re: [Dhis2-users] Surveillance rules

[Jim Grace]

Hi Joao,

Can you say more about the semantics of what you want to compare with past
periods? For example, are these cumulative values? What do they measure?

The reason I ask these questions is to understand better the potential
usefulness of adding this feature to DHIS 2. If you have a compelling use
case, and if it is consistent with the philosophy of how DHIS 2 is used,
then it will add more weight to this feature as we compare its priority to
other possible enhancements.

Cheers,
Jim


On Thu, May 14, 2015 at 9:08 AM, Joao Mazuze 
wrote:

>  Hi Jim,
>
> Of course I was trying to validate in an input form. In my own case I have
> a set of data elements that after  entered  current period  values for this
> data elements we have to compare with the respective  immediate previous
> period values as in our scenario will not make sense when user enter
> greater values for the current period when compared to previous. That’s why
> I tried to create an example on the demo site as described on my last
> email, but unfortunately did not work, even when running “validation rule
> analysis” after assigned to “validation rule group”, called   *Testing*.
>
>
>
> Kind regards,
>
> Joao
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 14 May 2015 14:53
>
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rules
>
>
>
> Thank you Joao.
>
>
>
> Were you trying to use this validation rule to validate data in an input
> form? Surveillance-type rules are not designed to work this way. They are
> used after data entry to look for patterns in the data, when added to a
> validation rule group and run under "Validation Rule Analysis".
>
>
>
> If you were trying to validate data against previous values, I would like
> to know more about your use case. Can you say more about what the data
> elements are, and how they should relate to previous periods?
>
>
>
> Cheers,
>
> Jim
>
>
>
>
>
> On Thu, May 14, 2015 at 8:30 AM, Joao Mazuze 
> wrote:
>
> Thank you Jim,
>
> Here is the problem´s background:
>
> We need to compare current period value from previous one (monthly period)
> as the current one it is mandatory to be greater than other. In this case
> on the demo system I made an example for *Bumban MCHP* org unit,
> comparing between *March 2015* and *April 2015 *for dataelement “BCG
> doses given (<1y)”, for any value applied to this dataelement the
> validation always passes successfully, what is strange, the related
> surveillance rule is called “*testePreviousPeriod”*. Our goal is to be
> able to compare those monthly periodical datavalues.
>
>
>
> Kind regards
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 14 May 2015 14:15
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rules
>
>
>
> Hi Joao,
>
>
>
> A surveillance-type validation rule should work as you say, comparing the
> current values of the left side with previous values of the right side. I
> don't know why you aren't seeing this behaviour.
>
>
>
> When you create a new surveillance-type validation rule, be sure to give a
> non-zero "Sequential sample count" to compare with periods immediately
> preceding the current period, and/or a non-zero "Annual sample count" to
> compare with the same period in past years. If you choose both, it will
> compare the current data with a range of sequential periods in this year
> and in past years.
>
>
>
> If this is not the problem, I would need some more information to
> understand better your situation. If you can reproduce the problem on the
> demo system https://apps.dhis2.org/demo/, or on another system to which I
> can be given access, that might help the most.
>
>
>
> Cheers,
>
> Jim
>
>
>
>
>
> On Thu, May 14, 2015 at 4:22 AM, Joao Mazuze 
> wrote:
>
> Hi guys,
>
> I know that surveillance rules compare data from previous periods with the
> current one. Now I need to compare data values from the same data
> elements(left and right side), but the rule ignores the previous value and
> compares only the current value itself which doesn´t make sense as
> surveillance rules compare current values with previous ones. How can I
> solve this?
>
>
>
> Kind regards,
>
> João
>
>
>
> Kind regards
>
> _
>
> João Gabriel Mazuze
>
> National Database Manager
>
> Projecto CHASS-SMT
>
> Abt Associates Inc.
>
> Av. Marginal, 4067
>
> Cidade de Maputo, Moçambique
>
> Fax: (+ 258)  21486767
>
> Tel:  (

Re: [Dhis2-users] Surveillance rules

[Jim Grace]

Thank you Joao.

Were you trying to use this validation rule to validate data in an input
form? Surveillance-type rules are not designed to work this way. They are
used after data entry to look for patterns in the data, when added to a
validation rule group and run under "Validation Rule Analysis".

If you were trying to validate data against previous values, I would like
to know more about your use case. Can you say more about what the data
elements are, and how they should relate to previous periods?

Cheers,
Jim


On Thu, May 14, 2015 at 8:30 AM, Joao Mazuze 
wrote:

>  Thank you Jim,
>
> Here is the problem´s background:
>
> We need to compare current period value from previous one (monthly period)
> as the current one it is mandatory to be greater than other. In this case
> on the demo system I made an example for *Bumban MCHP* org unit,
> comparing between *March 2015* and *April 2015 *for dataelement “BCG
> doses given (<1y)”, for any value applied to this dataelement the
> validation always passes successfully, what is strange, the related
> surveillance rule is called “*testePreviousPeriod”*. Our goal is to be
> able to compare those monthly periodical datavalues.
>
>
>
> Kind regards
>
>
>
> *From:* Jim Grace [mailto:jimgr...@gmail.com]
> *Sent:* 14 May 2015 14:15
> *To:* Joao Mazuze
> *Cc:* dhis1-users
> *Subject:* Re: [Dhis2-users] Surveillance rules
>
>
>
> Hi Joao,
>
>
>
> A surveillance-type validation rule should work as you say, comparing the
> current values of the left side with previous values of the right side. I
> don't know why you aren't seeing this behaviour.
>
>
>
> When you create a new surveillance-type validation rule, be sure to give a
> non-zero "Sequential sample count" to compare with periods immediately
> preceding the current period, and/or a non-zero "Annual sample count" to
> compare with the same period in past years. If you choose both, it will
> compare the current data with a range of sequential periods in this year
> and in past years.
>
>
>
> If this is not the problem, I would need some more information to
> understand better your situation. If you can reproduce the problem on the
> demo system https://apps.dhis2.org/demo/, or on another system to which I
> can be given access, that might help the most.
>
>
>
> Cheers,
>
> Jim
>
>
>
>
>
> On Thu, May 14, 2015 at 4:22 AM, Joao Mazuze 
> wrote:
>
> Hi guys,
>
> I know that surveillance rules compare data from previous periods with the
> current one. Now I need to compare data values from the same data
> elements(left and right side), but the rule ignores the previous value and
> compares only the current value itself which doesn´t make sense as
> surveillance rules compare current values with previous ones. How can I
> solve this?
>
>
>
> Kind regards,
>
> João
>
>
>
> Kind regards
>
> _
>
> João Gabriel Mazuze
>
> National Database Manager
>
> Projecto CHASS-SMT
>
> Abt Associates Inc.
>
> Av. Marginal, 4067
>
> Cidade de Maputo, Moçambique
>
> Fax: (+ 258)  21486767
>
> Tel:  (+ 258)  21493525/6/8
>
> Cell: (+258) 82 4236279
>
> www.chasssmt.com
>
>
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: Description: Description: Logotipo CHASS-SMT]
>
> *Somos um projecto financiado  pelo PEPFAR-II, através da USAID, para
> reforçar o Sistema de Saúde das Provincias de  Sofala, Manica e Tete.
> Pretendemos melhorar a ligação e integração do HIV  com os Cuidados
> Primários de Saúde e outros a ele relacionados em coordenação com as
> Direcções Provinciais de Saúde e outros parceiros. Através do projecto
> CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da
> qualidade dos Serviços de Saúde no país.*
>
>
>
>
>
>
>  --
>
> 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
> This message may contain privileged and confidenti

Re: [Dhis2-users] Surveillance rules

[Jim Grace]

Hi Joao,

A surveillance-type validation rule should work as you say, comparing the
current values of the left side with previous values of the right side. I
don't know why you aren't seeing this behaviour.

When you create a new surveillance-type validation rule, be sure to give a
non-zero "Sequential sample count" to compare with periods immediately
preceding the current period, and/or a non-zero "Annual sample count" to
compare with the same period in past years. If you choose both, it will
compare the current data with a range of sequential periods in this year
and in past years.

If this is not the problem, I would need some more information to
understand better your situation. If you can reproduce the problem on the
demo system https://apps.dhis2.org/demo/, or on another system to which I
can be given access, that might help the most.

Cheers,
Jim


On Thu, May 14, 2015 at 4:22 AM, Joao Mazuze 
wrote:

>  Hi guys,
>
> I know that surveillance rules compare data from previous periods with the
> current one. Now I need to compare data values from the same data
> elements(left and right side), but the rule ignores the previous value and
> compares only the current value itself which doesn´t make sense as
> surveillance rules compare current values with previous ones. How can I
> solve this?
>
>
>
> Kind regards,
>
> João
>
>
>
> Kind regards
>
> _
>
> João Gabriel Mazuze
>
> National Database Manager
>
> Projecto CHASS-SMT
>
> Abt Associates Inc.
>
> Av. Marginal, 4067
>
> Cidade de Maputo, Moçambique
>
> Fax: (+ 258)  21486767
>
> Tel:  (+ 258)  21493525/6/8
>
> Cell: (+258) 82 4236279
>
> www.chasssmt.com
>
>
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: Description: Description: Logotipo CHASS-SMT]
>
> *Somos um projecto financiado  pelo PEPFAR-II, através da USAID, para
> reforçar o Sistema de Saúde das Provincias de  Sofala, Manica e Tete.
> Pretendemos melhorar a ligação e integração do HIV  com os Cuidados
> Primários de Saúde e outros a ele relacionados em coordenação com as
> Direcções Provinciais de Saúde e outros parceiros. Através do projecto
> CHASS-SMT, o Governo Americano apoia o Governo Moçambicano na melhoria da
> qualidade dos Serviços de Saúde no país.*
>
>
>
>
>
>
> --
> 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-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

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

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

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

Re: [Dhis2-users] dhis 2.17 Password Algorithm

[Jim Grace]

Here's another approach:

Create the superuser account in the production system by hand. Copy out the
hashed password from a SQL query:

select password from users where username='...';

Set the password to null in the production system to effectively disable
the account. Then as a part of your batch procedure, enable the password in
the STAGING system with an update command like:

update users set password = '...' where username='...’;

Cheers,
Jim


On Mon, Jan 12, 2015 at 9:32 AM, Jason Phillips  wrote:

> Hi Bob/Jason P/Lars/all,
>
>
>
> Many thanks for your responses/input!
>
> Perhaps my specific reasons for my request would clear up the requirement:
>
>
>
> We normally have three “copies” of any one instance running at any given
> time: a LIVE system, a STAGING system, and a TRAINING system.  The STAGING
> system is used for testing changes to the LIVE without actually affecting
> the LIVE, for obvious reasons.
>
> We want to regularly update the STAGING database with a copy of the LIVE –
> but, in so doing, inject a superuser account that can be used for login by
> our support/technical/data staff; people that we would ideally like NOT to
> have access to the LIVE system.
>
> I would (ideally) like this to happen during our automated backup process,
> so something scripted would be great.  The injected username/password would
> remain reasonably stable, but for security reasons we would like to be able
> to change it from time to time.
>
> Any suggestion which presupposes an existing (presumably) super-user
> account poses a problem in that each database has different super-users,
> and the password for each is neither known to me nor stable or consistent.
>
> For example, I do not have login/access to most of the DHIS2 databases we
> host, but I am required occasionally to log in to assist with technical
> queries.  Using the method described above, I can be given super-user
> access to a copy of the system without having login creds for the real deal.
>
>
>
> I hope that clarifies?  Any suggestions would greatly appreciated.
>
>
>
> Kind regards,
>
> Jason.
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+jason=
> hisp@lists.launchpad.net] *On Behalf Of *Bob Jolliffe
> *Sent:* 12 January 2015 02:15 PM
> *To:* Halvdan Grelland
> *Cc:* DHIS 2 Users List; Henk Brink
> *Subject:* Re: [Dhis2-users] dhis 2.17 Password Algorithm
>
>
>
> Hi Jason
>
>
>
> Expanding yet further - and clearing up terminology - dhis2 does not
> encrypt the password and store it.  If it did, and you had the key, then
> you could decrypt it.  What dhis2 stores is a hash which is something
> calculated from the password.  These hash algorithms are designed to be as
> irreversable as possible ie. you can calculate the hash from the password
> (which is what happens when your password is checked when you login) but
> not the password from the hash.  So there is no encryption/decryption key
> involved.
>
>
>
> In general I think Lars's advice is what you should follow if you can.
> Creating a bunch of user/password combinations in advance gives you two
> headaches : (i) how do you generate the passwords?  (ii) how do you then
> securely distribute them?
>
>
>
> Maybe the one case where you might want to create a user with a
> pre-generated password is if you are trying to match credentials across
> systems.
>
>
>
> Bob
>
>
>
> On 12 January 2015 at 11:41, Halvdan Grelland  wrote:
>
> To further expand on this: bcrypt is a fully portable format which should
> allow you to generate and authenticate valid credentials using any (sane)
> implementation. Good implementations are available for most programming
> languages.
>
>
>
> Also, I might be misunderstanding you, but in reference to item #3 on your
> list: if your design requires you to decrypt password hashes (which is, as
> Jason P. suggests virtually impossible) it should probably be reconsidered.
>
>
>
> If you for some reason need to work with pre 2.17 systems there is a
> standalone implementation of the DHIS2 password hashing algo available at
> https://github.com/dhis2/dhispassword
>
>
>
>
>
> 2015-01-12 9:18 GMT+01:00 Jason Pickering :
>
> Hi Jason,
>
>
>
> DHIS2 currently uses Bcrypt for encryption of the passwords.
>
>
>
> By far the easiest way achieve what you want is to create an XML (DXF2)
> payload of the user(s) you need to create and import that into DHIS2. The
> password in XML can be clear text,and will be encrypted by DHIS2 upon
> import.
>
>
>
> Yes, users can be assigned to orgunits in this process.
>
>
>
> Although it is possible to decrypt the password in the DHIS2 database, it
> could be a lengthy process requiring the password to be cracked. There is
> no known algorithm to  efficiently decrypt passwords which have been hashed
> with Bcrypt.
>
>
>
> Best regards,
>
> Jason Pickering
>
>
>
>
>
>
>
> On Mon, Jan 12, 2015 at 8:05 AM, Jason Phillips  wrote:
>
> Hi all,
>
>
>
> A happy New Year to everyone, and may 2015 be a happy, healthy a

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [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-d...@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-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] 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-d...@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-d...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp


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

Re: [Dhis2-users] Creating Users through Account Invites using Web Api

[Jim Grace]

Hi Busoye,

Good. Assigning one or more organisationUnits is required. You may also
optionally assign one or more dataViewOrganisationUnits.

Cheers,
Jim



On Thu, Sep 4, 2014 at 10:55 AM,  wrote:

>  Thanks Jim,
>
> I was using dataviewOrganisationUnit in the call. Will try the just
> "organisationUnits"
>
> Best regards,
>
> Busoye
>
>
>
>
> On 2014-09-04 16:34, Jim Grace wrote:
>
> Hi Busoye,
>
> The documentation, as you may have seen, is at
>
>
> https://www.dhis2.org/doc/snapshot/en/user/html/dhis2_user_manual_en_full.html#d5e10755
> .
>
> I agree that it should be expanded. Meanwhile, here are some additional
> tips: To see the format that you should send for a user invitation, try
> getting a user in json format through the API, such as:
>
> https://apps.dhis2.org/demo/api/users/OYLGMiazHtW.json
>
> You can use this as general ideas of what json to submit as the user
> invite. But you only need to submit a small subset of this. Note that for
> an invitation, the email address is essential. For example, the json file
> can contain something like:
>
>  {
> "email": "nore...@dhis2.org",
> "userCredentials": { "username": "inviteduser" },
> "groups": [ { "id": "wl5cDMuUhmF" }, { "id": "QYrzIjSfI8z" } ],
> "organisationUnits": [ { "id":"ImspTQPwCqd" } ]
> }
>
> Edit the email address to your own email for testing, and this json file
> should work with:
>
> curl -d @user.json "https://apps.dhis2.org/demo/api/users/invite"; -H
> "Content-Type:application/json" -u admin:district -v
>
> This will send an invitation for the user to register, with a preassigned
> user name of "invitedUser". If you want the user to pick their own user
> name (like what they do when self-registering), you can leave out the
> "userCredentials" line. Note that as of now, user roles need to be assigned
> in a subsequent API call for the created user.
>
> Hope this helps.
>
> Cheers,
> Jim
>
>
>
> On Thu, Sep 4, 2014 at 7:33 AM,  wrote:
>
>>  Hi Morten, Abyot and other DHIS2 users,
>>
>> I am trying to create users by sending User Account Invites through the
>> web api but can't find much in the way of documentation. Can anyone help?
>>
>> I am using Version:2.16 Build revision:16384
>>
>> Thanks.
>>
>> Busoye
>>
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Creating Users through Account Invites using Web Api

[Jim Grace]

Hi Busoye,

The documentation, as you may have seen, is at

https://www.dhis2.org/doc/snapshot/en/user/html/dhis2_user_manual_en_full.html#d5e10755
.

I agree that it should be expanded. Meanwhile, here are some additional
tips: To see the format that you should send for a user invitation, try
getting a user in json format through the API, such as:

https://apps.dhis2.org/demo/api/users/OYLGMiazHtW.json

You can use this as general ideas of what json to submit as the user
invite. But you only need to submit a small subset of this. Note that for
an invitation, the email address is essential. For example, the json file
can contain something like:

{
"email": "nore...@dhis2.org",
"userCredentials": { "username": "inviteduser" },
"groups": [ { "id": "wl5cDMuUhmF" }, { "id": "QYrzIjSfI8z" } ],
"organisationUnits": [ { "id":"ImspTQPwCqd" } ]
}

Edit the email address to your own email for testing, and this json file
should work with:

curl -d @user.json "https://apps.dhis2.org/demo/api/users/invite"; -H
"Content-Type:application/json" -u admin:district -v

This will send an invitation for the user to register, with a preassigned
user name of "invitedUser". If you want the user to pick their own user
name (like what they do when self-registering), you can leave out the
"userCredentials" line. Note that as of now, user roles need to be assigned
in a subsequent API call for the created user.

Hope this helps.

Cheers,
Jim



On Thu, Sep 4, 2014 at 7:33 AM,  wrote:

>  Hi Morten, Abyot and other DHIS2 users,
>
> I am trying to create users by sending User Account Invites through the
> web api but can't find much in the way of documentation. Can anyone help?
>
> I am using Version:2.16 Build revision:16384
>
> Thanks.
>
> Busoye
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [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-d...@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-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] [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-d...@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-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Alerts..

[Jim Grace]

Hello Jerome,

No problem. Good questions. When you create a new validation rule, be sure
to set the Period Type to "Daily" on the new validation rule screen, if you
want to see elements belonging to daily data sets. Otherwise the default is
Monthly.

If you create a Surveillance type rule, the left-hand side will be
restricted to data elements from data set with the selected period. So if
you chose a Daily period, you can only choose this type of element on the
left side. However the right side of the equation may contain data elements
from data sets with longer period types. So, for example, the left side can
refer to a data element collected daily, while the right side can refer to
a threshold value that is entered less frequently (like yearly, for
example.)

The surveillance parameters you mention are described at
http://www.dhis2.org/doc/snapshot/en/user/html/dhis2_user_manual_en_full.html#d5e1568.
But please feel free to email again if you have further questions about
these.

Cheers,
Jim



On Tue, May 27, 2014 at 2:33 PM, Jerome Shaguy wrote:

> Hello Jim,
>
> Let me bother you for a bit... So I copy your explanation about the
> validation rule set up. A few issues I have encountered... I find that data
> elements belonging to datasets that have been set up to be collected daily,
> do not come up in the validation rule setup, i.e. does this mean only data
> elements that are collected monthly are to be validated? And also when
> setting up a surveillance type rule: what do the following parameters
> represent? I looked through all the docs and in the online help, but
> couldn't find an explanation.
>
> Sequential sample count Annual sample count High outliers Low outliers
>
> Appreciate your help!
>
>
> On Thu, May 22, 2014 at 7:24 PM,  wrote:
>
>> Thanks Sire
>>
>>  Sent from my BlackBerry 10 smartphone.
>>   *From: *Jim Grace
>> *Sent: *Thursday, 22 May 2014 18:59
>> *To: *Jerome Shaguy
>> *Subject: *Re: Alerts..
>>
>> Hi Jerome,
>>
>> Validation rules refer to data elements only, not calculated Indicators.
>> However, you can build a validation rule with the same kind of logic that
>> you use to build an indicator. So it can accomplish the same thing.
>>
>> I'm guessing that the "Low Threshold" values may be entered less
>> frequently than the than the stock on hand. If this is true, then you will
>> want to use a "surveillance" type validation rule (choose the
>> "surveillance" type when you create the rule.) With a surveillance rule,
>> you can put the current stock level on the left-hand side, that is entered
>> more frequently, and the baseline value you are comparing it to on the
>> right-hand side, which could be entered less frequently.
>>
>> Finally, to get alerts, create a validation rule group containing all the
>> validation rules you want to send alerts for. In this validation rule group
>> you can choose one or more "User groups to alert". The validation rules are
>> run nightly, and users in those groups will be alerted.
>>
>> I hope this helps. Let me know if you have any more questions -- and
>> please copy the dhis2 user mailing list dhis2-users@lists.launchpad.net in
>> case others may be helped from the discussion.
>>
>> Cheers,
>> Jim
>>
>>
>>
>> On Thu, May 22, 2014 at 12:19 PM, Jerome Shaguy 
>> wrote:
>>
>>> Hi Jim,
>>>
>>> Would appreciate some help with this: I am trying to create an alert. I
>>> have a data element called Low Threshold... Values for low stocks will be
>>> captured into this element. I have another Calculated element called stock
>>> on hand, I need the Validation rule to check stock on hand and compare it
>>> to Stock threshold and send out an alert; where stock on hand is lower than
>>> the threshold... Any ideas anyone?
>>>
>>
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Problem with data approval

[Jim Grace]

Hello Ese,

Also, there were some data approval bug fixes on May 4, revision 15144. Are
you running that version, or a later version of 2.15? (Go to Profile ->
About Dhis 2 and look for the build revision.)

Cheers,
Jim



On Thu, May 15, 2014 at 12:54 PM, Ese Egerega  wrote:

> No I didn't. I will try an incognito window in Chrome and see.
>
>
> On Thu, May 15, 2014 at 5:44 PM, Knut Staring  wrote:
>
>> Perhaps caching? Did you try an incognito window in Chrome?
>> On May 15, 2014 10:46 PM, "Ese Egerega"  wrote:
>>
>>>  Hello,
>>>
>>> I just upgraded to 2.15 and I am trying out the data approval feature. I
>>> followed the steps on the documentation carefully but it doesn't seem to be
>>> working on my setup. The dataset status keeps going back to "Ready for
>>> Approval" even though I had approved it. I am also able to enter data; the
>>> dataset is supposed to be locked for the particular org unit and period
>>> after approval but it's not.
>>>
>>> I have followed the same steps on the demo site (Sierra Leone) and it
>>> works perfectly but it wouldn't work in my setup. I am wondering what I am
>>> not getting right.
>>>
>>> Your comments will me appreciated.
>>>
>>> Thanks,
>>> Ese
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] Approve data

[Jim Grace]

Hi Channara,

Yes, it's working. To understand data approval, start here:

http://www.dhis2.org/doc/snapshot/en/user/html/dhis2_user_manual_en_full.html#d5e2848

Post again if you have any further questions.

Cheers,
Jim



On Thu, Mar 13, 2014 at 11:35 PM, channara rin wrote:

> Dear All users,
> by the way, I am using DHIS2 V2.14. I saw data set section has function:
> Approval Data and in User Role section also has authorities: "Approve data"
> and "Approve data at lower levels". So is it work now?
>
> Thank you
> CHANNARA
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data Set

[Jim Grace]

Hi Channara,

Note that you can put the same data elements into multiple data sets. To
give an example of what Thuy is saying, let's say you have data elements 1,
2, 3 and 4. You want facilities A and B to fill elements 1, 2, and 3, but
you want facilities C and D to fill elements 2, 3 and 4.

You can create one data set with elements 1, 2 and 3, and assign this data
set to facilities A and B. Then you can create another data set with
elements 2, 3 and 4, and assign this data set to facilities C and D.

Cheers,
Jim Grace



On Wed, Mar 12, 2014 at 4:55 AM, Thuy Nguyen wrote:

> Hi Channara,
>
> May be you can create more data sets, these datasets have different number
> of data elements. And then you assign different datasets to different
> organisation unit groups.
>
>
> On Wed, Mar 12, 2014 at 3:49 PM, channara rin wrote:
>
>> Dear All DHIS2 users and developers,
>> I would like to ask question relate to "Data set".
>> Can we put flexible data elements into one Data Set and assign to many
>> org units?
>>
>> NOTE: flexible data elements: mean some data elements will show for a few
>> org units and other data elements are not relate to org unit will hide When
>> Data Entry. And the some hide data elements will show back with another org
>> units when Data Entry.
>>
>> Thank you...
>> CHANNARA
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Maps of outbreaks

[Jim Grace]

Hi Knut,

Nice thoughts about more flexible data entry forms "pivoting" in different
dimensions. And given how much easier the auto-generated forms are than
designing your own, it would be great to expand the number of cases that
one can use auto-generated forms for. Developing a detailed proposal for
this sounds like a very useful effort. Any takers?

I quite agree that we should provide "tools for people who are not
programmers allowing them to configure what they want". My question about
the appropriate use of apps isn't really focused on when do we expect users
to write their own. It's more the question of when are features provided in
the core vs. when are they provided in the app store.

Speaking of which, if we provide general-purpose, configurable apps in the
app store, I wonder how we can provide a user-friendly way to customize app
metadata through DHIS, so the user wouldn't have to edit the manifest file
inside the app. We could extend the DHIS UI to be able to configure
app-specific metadata settings for an app that has been uploaded. I wonder
if the app manifest itself could describe the various system settings
choices to be made (e.g., the allowable numeric range of a metadata
setting, the list of choices, etc.) I'm not familiar enough yet with the
app manifest format to know whether it supports this already, or how
awkward it might be to graft it on. I known that OpenMRS modules, for
example, can add their own settings section to the OpenMRS UI, so they can
be configured through OpenMRS. The end result is that the non-programmer
user can simply download an OpenMRS module, install it, and then configure
it through the OpenMRS UI. The equivalent for DHIS apps could be very
useful. Or should the app include its own configuration screens, and the
configuration data is somehow stored in DHIS? (I apologize for my lack of
knowledge about apps.)

Cheers,
Jim


On Sat, Feb 15, 2014 at 10:26 AM, Knut Staring  wrote:

> Thanks for the thoughts, Jim. Some comments below.
>
> On Sat, Feb 15, 2014 at 2:49 PM, Jim Grace  wrote:
>
>> Hi Knut,
>>
>> It sounds to me like a natural for an app (as you mentioned). If we had 
>> "Start
>> date" and "End date" in a YEARLY dataset, that might preclude two outbreaks
>> (by any other name) for the same year and same organisation unit, so that
>> might not be the best method for data entry. (And outbreaks that span the
>> new year would still have to be entered twice.)
>>
>
> Quite right, I was already wondering how to handle things that cross
> years. I guess the user should select start and end dates, but these would
> not be stored. Tending towards preserving the information as much as
> possible through using a daily dataset  - this implies lots of (generated)
> datavalues for a long outbreak, but is usually for a limited number of
> orgunits (the total number is over 3000). Monthly data will be interpreted
> to cover all days in the month.
>
>
>> Interesting idea about entering through time on the same form. I wonder
>> what that would look like. Would the periods be columns? Given that we
>> already use columns for disaggregations, that might make the form too wide
>> -- so maybe the periods would be rows. I wonder how the number of periods
>> would be determined -- perhaps specify the number in the form design (or in
>> the data set for an automatically-generated form), or maybe specify a
>> longer period type and show all periods within the longer duration.
>>
>
> In this particular case there is but one data element and no
> disaggregations, so it could go either way. It really depends on how you
> get your data - sometimes you have lots of data for just one OrgUnit, and
> then it's a hassle to constantly select new periods when the screen could
> easily accommodate a matrix grid rather than a one dimensional column.
>
> But of course you would have to somehow specify the number of periods,
> preferably on a dataset basis rather than as a global setting. We already
> support the choice of horizontal or vertical (row/column) multi-orgunit
> data entry, so would not be too far fetched to do something similar for
> periods (though they are potentially infinite in number). In fact, the
> OpenHealth prototype that was developed for WHO back in 2007 had a data
> entry interface quite akin to our Pivot Table.
>
>
>> Most of all I wonder what other use cases there might be for entry over
>> multiple time periods. Is this worth building in, or is it best done by an
>> app?
>>
>
> I would argue that though our Data Entry is already quite powerful, there
> are a lot of enhancements that I would really love to see in the core. It
> would be wonderful if most use cases could gener

Re: [Dhis2-users] Maps of outbreaks

[Jim Grace]

Hi Knut,

It sounds to me like a natural for an app (as you mentioned). If we had "Start
date" and "End date" in a YEARLY dataset, that might preclude two outbreaks
(by any other name) for the same year and same organisation unit, so that
might not be the best method for data entry. (And outbreaks that span the
new year would still have to be entered twice.)

Interesting idea about entering through time on the same form. I wonder
what that would look like. Would the periods be columns? Given that we
already use columns for disaggregations, that might make the form too wide
-- so maybe the periods would be rows. I wonder how the number of periods
would be determined -- perhaps specify the number in the form design (or in
the data set for an automatically-generated form), or maybe specify a
longer period type and show all periods within the longer duration.

Most of all I wonder what other use cases there might be for entry over
multiple time periods. Is this worth building in, or is it best done by an
app? It seems like a good idea to develop apps for a lot of specialized
requirements, and maybe even some common ones. How much have we developed
our philosophy about when to put things in apps and when in the core
product?

Cheers,
Jim



On Sat, Feb 15, 2014 at 3:42 AM, Alvin B. Marcelo
wrote:

> +1 on Inception (in the context of the movie)It may seem amusing but
> to some extent the term is appropriate...
>
>
>
>
> Sent from my BB Curve 9320
> --
> *From: * Brajesh Murari 
> *Date: *Sat, 15 Feb 2014 16:30:30 +0800 (SGT)
> *To: *alvin.marc...@gmail.com; Knut Staring<
> knu...@gmail.com>; Dhis2-users gmail@lists.launchpad.net>; dhis2-users@lists.launchpad.net<
> dhis2-users@lists.launchpad.net>
> *ReplyTo: * Brajesh Murari 
> *Subject: *Re: [Dhis2-users] Maps of outbreaks
>
> Hi,
>
> There are some synonyms for 'outbreak' are given below
>
> explosion, blast, eruption, outburst, detonation, blowup, outburst,
> plosion, advent, repullulation, commence, inception, initiation,
> inchoation, eruption, insurgency,
>
> I think "Insurgency" or 'Inception' would be nice to use for 'outbreak' in
> context of DHIS2.
>
> Regards
> Brajesh Murari
>
>
>
>   On Saturday, 15 February 2014 1:25 PM, Alvin B. Marcelo <
> alvin.marc...@gmail.com> wrote:
>  I'm not sure if I got the 3Cs correctly. Pls google too...
>
>
> Sent from my BB Curve 9320
>
> -Original Message-
> From: "Alvin B. Marcelo" 
> Date: Sat, 15 Feb 2014 07:41:03
> To: Knut Staring;
> Dhis2-users gmail@lists.launchpad.net>; dhis2-users@lists.launchpad.net<
> dhis2-users@lists.launchpad.net>
> Reply-To: alvin.marc...@gmail.com
> Subject: Re: [Dhis2-users] Maps of outbreaks
>
> Hi Knut,
>
> My two cents as we recently experienced a measles 'outbreak'.
>
> First, better not to call it an 'outbreak'. Health officials are very
> sensitive about the term. We can gain their confidence if we don't
> "presume" an outbreak by labeling it as such on the interface.
>
> Second, we missed this 'outbreak' in Metro Manila (of all places!) because
> the health workers waited for official lab confirmation (which takes 3
> weeks in this part of the world). The health workers forgot to execute the
> protocol that if the 3Cs are present (colds, cohryza, conjunctivitis) they
> should suspect measles and immediately vaccinate the surrounding children.
>
> Lesson: if any child comes in with any one of the 3Cs, the information
> system should alert them for the other 2Cs. The 3Cs will be reported
> upwards and it will be a syndromic report and not an outbreak report.
>
> The first syndromes (in retrospect) started coming in as early as August
> but it was only December when the trend became evident (due to the lack of
> near-real time reporting and health worker forgetting the protocol).
>
> I fully support this initiative. Such a system, if it works, could have
> saved lives in the Philippines. A better name might be DHIS2 syndromic
> surveillance decision support system with the ability to inform officials
> of dangerous trends.
>
> We'll leave it up to the health officials to call it an outbreak.
>
> Alvin
>
>
>
>
> Sent from my BB Curve 9320
>
> -Original Message-
> From: Knut Staring 
> Sender: "Dhis2-users"
> Date:
> Sat, 15 Feb 2014 08:16:23
> To: dhis2-users@lists.launchpad.net
> Subject: [Dhis2-users] Maps of outbreaks
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> 

Re: [Dhis2-users] [Dhis2-devs] Welcome Andreas

[Jim Grace]

Welcome Andreas (from the U.S.)



On Tue, Jan 14, 2014 at 7:27 AM, Morten Olav Hansen wrote:

> Welcome!
>
> --
> Morten
>
>
> On Tue, Jan 14, 2014 at 1:25 PM, Lars Helge Øverland 
> wrote:
>
>> Welcome to the team..
>>
>> Lars
>>
>>
>> On Tue, Jan 14, 2014 at 12:59 PM, Lars Kristian Roland wrote:
>>
>>> Hi all, (sorry for cross-posting)
>>>
>>> Andreas Nergaard is joining the DHIS mobile team to coordinate the
>>> mobile requirements and development. Andreas comes from a product
>>> management background and has a lot of experience with mobile client
>>> development, working with operators etc. He will be taking on some of the
>>> coordination tasks I've done (and not done) so that I can work more on my
>>> PhD.
>>>
>>> I have worked with Andreas before and I'm very happy that he's joining
>>> the team.
>>>
>>> Best regards,
>>> Lars
>>>
>>> --
>>> Lars Kristian Roland
>>> Research Fellow, Department of Informatics, University of Oslo
>>> Email: l...@roland.bz - rol...@ifi.uio.no
>>> Phone: +47 90733036
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Mark Polak joins as developer

[Jim Grace]

Welcome, Mark (from the U.S.)



On Fri, Jan 10, 2014 at 8:02 AM, Muhire Andrew wrote:

> Warm welcome Mark...
>
>
>
>
> --
> Happy new year!! The 2014 is shaping up to be the year of the connected
> devices which means that heaps of data are going to be collected, sorted,
> and analysed for Policy makers in Decision making.
>
>
>
> * 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 *
>
>
>On Friday, January 10, 2014 1:08 PM, Lars Helge Øverland <
> larshe...@gmail.com> wrote:
>   Hi all,
>
> I have the pleasure to announce that Mark Polak has joined the team as
> software developer on a 30% basis.
>
> Mark is from the Netherlands and has 7 years of software development
> experience, in particular with web and client side technologies, and has
> worked on several large projects. He has already demonstrated a flair for
> user interface design during the "dhis" master course at UiO. Mark is
> currently a master student at UiO.
>
> We are excited to you get on the team. Welcome!
>
> regards,
>
> Lars
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Homologous periods for indicators

[Jim Grace]

Hi all,

By all means tell anyone requesting this type of analysis about the new
surveillance-type validation rules. They do exactly this type of analysis,
for example the calculation Knut mentioned, comparing this year's weekly
data with the average of the three previous years (e.g. week 48),
multiplied by 1.5. Surveillance rule features also include:

- You can average not only just over the same period in a number of
previous years, but over a bounded set of weeks surrounding the week in
question, or a combination of both (e.g. comparing week 48 this year with
the average of weeks 47,48 and 49 in the previous two years, and week 47
this year.)

- You can throw out a configurable number of high and/or low outliers from
previous data before doing the average, so you're not comparing the new
data data against previous outbreaks and/or unusually low values.

- You can analyze the data automatically as it comes in from data entry
each day, for any data elements (singly or in a formula) in all
organisation units at whatever levels you like, with customized formulas at
each different organizational unit level (e.g. an alarming district-wide
increase may be a lower percent than what could be random variation at
individual sites.) And be notified automatically through DHIS messaging (by
email if you like) of any outliers.

If they want the data for display, this would have to be added whether in
the visualizer or a new app. But if they want the data for outbreak
detection, by all means also tell them about the new surveillance rules.

Cheers,
Jim



On Thu, Dec 5, 2013 at 2:17 AM, Bram Piot  wrote:

> Hi all,
>
> Surprisingly, yesterday I had exactly the same request from one of our
> users in Uganda: they'd like to see monthly data for current and past year
> as separate lines on the same chart, very similar to Knut's example. I can
> imagine that this would be rather complex to handle in the visualiser -
> maybe this needs a separate app?
>
> bram piot
>
>
>
> On 5 December 2013 10:08, Knut Staring  wrote:
>
>> Thanks Ola, it's a good idea to have this also available as part of
>> validation rules. However, my immediate need and what organizations dealing
>> with seasonal epidemics such as WHO and CDC would like to see are charts
>> with two lines:
>>
>> The trend of cases and deaths for the current year as compared to the
>> trend lines for a) the previous year or b) some kind of average for several
>> previous years. See the attached example.
>>
>> Knut
>>
>>
>> On Thursday, December 5, 2013, Ola Hodne Titlestad wrote:
>>
>>> Knut,
>>>
>>> Your example looks more like the kind of functionality we have/could
>>> build into in surveillance type validation rules.
>>>
>>> Ola
>>> --
>>> On 4 Dec 2013 22:07, "Knut Staring"  wrote:
>>>
 We have the same requirement, in our case to compare this year's weekly
 data with the average of the three previous years foe the corresponding
 periods (e.g. week 48), multiplied by 1.5. Perhaps this should be available
 in the indicator calculation? And/or an easy way to get it through the api.
 Could you start on a Blueprint for this?
 4. des. 2013 20:46 skrev "Paulo Grácio" 
 følgende:

> Hi,
>
>
>
> One of the challenges that I have at the moment is the creation of an
> indicator based on homologous period to have evolution. Any
> idea/suggestion?
>
>
>
> For instance get Malaria deaths for period (2013) and Malaria deaths
> for period-1 (2012).
>
>
>
> Regards
>
> Paulo Grácio
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-d...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp


>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https:

Re: [Dhis2-users] [Dhis2-devs] abyot gizaw joins as developer

[Jim Grace]

Welcome Abyot!


On Tue, Oct 29, 2013 at 2:16 PM, Morten Olav Hansen wrote:

> Welcome to the team!
>
> --
> Morten
>
>
> On Tue, Oct 29, 2013 at 6:04 PM, Knut Staring  wrote:
>
>> Great, welcome Abyot!!
>> 29. okt. 2013 17:53 skrev "Ola Hodne Titlestad" 
>> følgende:
>>
>> Welcome!
>>>
>>> --
>>> Ola Hodne Titlestad (Mr)
>>> HISP
>>> Department of Informatics
>>> University of Oslo
>>>
>>> Mobile: +47 48069736
>>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps 
>>> link
>>>
>>>
>>> On 29 October 2013 17:40, Jan Henrik Øverland <
>>> janhenrik.overl...@gmail.com> wrote:
>>>
 Good news!


 On Tue, Oct 29, 2013 at 5:30 PM, Lars Helge Øverland <
 larshe...@gmail.com> wrote:

> Hi,
>
> we are happy to announce that Abyot Gizaw joins the DHIS 2 team as
> software developer. Abyot has been part of the DHIS community for a long
> time and has developed several components of the software. Over the last
> years he's been a research fellow at the University of Oslo and he lately
> submitted his PhD thesis.
>
> Abyot has great knowledge of the case-based data domain and will be a
> very valuable addition to our team. We are happy to get you on board
> full-time. Welcome!
>
> best regards,
>
> Lars
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

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


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

Re: [Dhis2-users] dhis to submit anonymous data

[Jim Grace]

Hi Lars and Jason,

Good idea, and good questions about security.

One way to approach IP address security is to not record them anywhere (and 
make sure the central server to which the data is sent does not keep any log of 
them.) If the central server doesn't know the IP addresses, they can't be 
divulged to any third party.

A very different approach to openness and security is taken by the optional 
OpenMRS "Atlas module". This opt-in module allows an OpenMRS installation to 
provide information that is available in a public OpenMRS "atlas" of 
implementations. The atlas can facilitate interactions between OpenMRS 
community members, including prospective members, and it also serves as 
publicity for OpenMRS as well as the implementers. I'll leave it for others to 
say whether DHIS2 administrators would feel comfortable or even welcome this 
kind of public information for their implementations. See 
http://openmrs.org/atlas/ for the OpenMRS atlas itself, and 
https://wiki.openmrs.org/display/docs/Atlas+Module+User+Guide for the atlas 
module user guide.

Cheers,
Jim

On Jun 28, 2013, at 9:22 AM, Jason Pickering  
wrote:

> Hi Lars,
> 
> Sounds interesting. Wish I would have been there for the discussion. Sounds 
> like it might be possible,  assuming the process and data is transparent, and 
> allow for an option to "opt-out" of collection of such data. 
> 
> Having said that, I think we should be exceedingly careful. I assume that the 
> data would be beamed back to a central server someplace. Who would control 
> that server? Who would have access to the "sensitive" data like IP addresses 
> of the servers, i.e. the data which would not be publicly disclosed? Given 
> recent revelations in the news, how would possible data requests from third 
> parties be handled (such as a list of IP addresses for where DHIS2 is used)?
> 
> Regards,
> Jason
> 
> 
> 
> 
> 
> On Thu, Jun 27, 2013 at 10:07 PM, Lars Helge Øverland  
> wrote:
> Hi there,
> 
> during the Uganda workshop last month we had an interesting suggestion from 
> one of the participants.
> 
> The idea is to let DHIS submit anonymous, non-sensitive data to a central 
> system in order to gather basic statistics related to usage. The data sent 
> would include:
> 
> - A random, anonymous system identifier
> - DHIS 2 version
> - Java server version
> - Operating system and version
> 
> Then we could make an optional feature for "activating" or "registering" your 
> DHIS instance, where you could optionally inform about:
> 
> - System contact person
> - System description
> 
> It would be quite useful and interesting to know things like:
> 
> - How many DHIS instances there are out there
> - How fast are new DHIS versions adopted
> - What is the dominant server operating system/environment
> 
> 
> This info would of course be disclosed only in aggregate form.
> 
> What do people think about this? Any strong objections?
> 
> 
> best regards,
> 
> Lars
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] dhis to submit anonymous data

[Jim Grace]

Sounds interesting. Was there an idea of what the data would be used for?

On Jun 27, 2013, at 10:59 PM, Lars Helge Øverland  wrote:

> Hi there,
> 
> during the Uganda workshop last month we had an interesting suggestion from 
> one of the participants.
> 
> The idea is to let DHIS submit anonymous, non-sensitive data to a central 
> system in order to gather basic statistics related to usage. The data sent 
> would include:
> 
> - A random, anonymous system identifier
> - Java server version
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp


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

Re: [Dhis2-users] DHIS 2 on Mac

[Jim Grace]

Hi All,

I'm running it fine on OS X (Mountain Lion), following the procedures for 
Ubuntu. As I recall, there may have been one or two directories in different 
places than on Linux, but I found them and adapted. If you try the same and are 
having trouble at any step, let me know the specifics and I'll be glad to help. 
(I can tell you where things ended up on my system.)

Cheers,
Jim

On Jun 21, 2013, at 1:13 PM, Farai Mutero  wrote:

> Hi Makhate
> 
> Yes there are several people who run DHIS2 on their Macs. Pascal from Jembi 
> (copied) is one. Pascal could you please advise Makhate.
> 
> Regards
> 
> Farai
> 
> On Friday, June 21, 2013, makhatemakhate wrote:
> Morning,
> 
> I read on your website that DHIS2 can work on any platform that runs java 
> virtual machine. From the documentation, I only see instructions for 
> installing on Ubuntu. Is there anything for Mac OS X?
> Anyone running DHIS2 on a Mac?
> 
> Regards,
> -- 
> Makhate Gerard Makhate (Mr.)
> Human Resources Information Systems Specialist
> Eastern Central Southern African - Health Community
> +266 5963 3566
> 
> "Forgiveness received makes a jubilant soul, forgiveness granted purifies a 
> soul"
> 
> 
> -- 
> Farai Mutero
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] Define week start day for Weekly periods

[Jim Grace]

I haven't use it yet, but Joda-Time looks impressive at first glance. They 
claim it's "the de facto standard library for advanced date and time in Java" 
and "The Gregorian, Julian, Buddhist, Coptic, Ethiopic and Islamic systems are 
also included" (besides the default ISO8601). http://joda.sourceforge.net/

Cheers,
Jim

On Jun 17, 2013, at 12:21 AM, Johannes Schnitzler  wrote:

> Dear All,
> 
> Coming back to the possibility to define the different "type of weeks" in the 
> setting.
> Does anyone know a library in Java handling this easily? 
> In case this will not be addressed soon in the next versions. What would be 
> the workaround for a given scenario/country - has anyone addressed this 
> already?
> 
> Best regards,
> 
> Johannes
> 
> 
> On 15 June 2013 18:18, Knut Staring  wrote:
> I'm not sure it is important to aggregate along the time dimension for weekly 
> data. But it is important to do so spatially, ie upwards in the hierarchy.
> 
> Sent from my mobile
> 
> On Jun 15, 2013 11:36 AM, "Bob Jolliffe"  wrote:
> Aggregating from weeks to months will always be approximate so these 
> anomalies will happen. Maybe some clever pro-rata scaling can be done.
> 
> 
> On 15 June 2013 10:39, Ola Hodne Titlestad  wrote:
> Not very related, but one issue with weeks that came up in Uganda recently is 
> that monthly aggregates of the reporting rates of weekly datasets got above 
> 100% for months with 5 weeks. Seems the aggregation code here assumes 4 weeks 
> per month throughout the year and with 5 weeks of reported datasets for some 
> months the reporting rate got too high.
> 
> Ola
> --
> 
> On 15 Jun 2013 11:24, "John Lewis"  wrote:
> Hi all,
> Defining week start and end date is quite complicated. I had the same issue 
> in bangladesh. The point also how do we aggregate it to month. Technically we 
> break the data of a week which fall in two month, which is not a good idea. 
> Instead of rewriting.entire aggregation engine would it better to define as 
> daily data set. Since we collect data once a week we can use daily data set 
> and modify data enter screen to show weekly end date.
> On 15 Jun 2013 03:40, "Johannes Schnitzler"  wrote:
> Dear All,
> 
> How I have solved the issue in another application, also used for Cambodia, 
> is that I'm allowing to define the start day of the week e.g. Monday, 
> Tuesday, Wednesday  as well as how many days "touching the new year" are 
> needed to qualify a week to be counted as week 1 of the new year. This is 
> part of the setting of the application and is used to calculate it on the fly 
> e.g. for data entry date / week selection. I have written the code for this 
> in R  (bad code... but it is working). This allows to deal with a lot of 
> countries. 
> 
> For ISO it is 4 days to qualify for the new year and the start day depends on 
> the country, 
> For Cambodia it is 1 day and start day is Wednesday.
> 
> As in DHIS I'm storing the period type daily weekly monthly 
> And for the actual date I'm storing always start date, end date of the period 
> and in addition the Year and the TIme unit..
> For weekly data: start date, end date, Week Number, Year of the week (which 
> might be of course be different from the Year of the first day of the week 
> for the first and last week of the year).
> For daily data: start date, end date (which is of course the same), day 
> number  in year, Year 
> For monthly data: start date, end date, month number, Year 
> 
> 
> In this case one has all freedom to combine data sets from different "week 
> definitions" as one can decide later on which week calculation to be applied 
> across the piece based on the start date of the week knowing that the week 
> counting might be off for some of the countries for a few days. But this is 
> the best what we can do I assume ...
> 
> Best regards,
> 
> Johannes
> 
> 
> On 14 June 2013 19:08, Knut Staring  wrote:
> Will have to investigate and get back to you
> 
> Sent from my mobile
> 
> On Jun 14, 2013 6:06 PM, "Bob Jolliffe"  wrote:
> how do they determine which day is day 1 of week 1?
> 
> 
> On 14 June 2013 17:52, Knut Staring  wrote:
> For my purposes, that's really all I know, and for my requirements it will be 
> exactly parallel to countries that require Monday instead of Sunday.
> 
> But certainly the Nepali, Ethiopian and several others have more complex 
> requirements, which I think partly must be treated as separate cases.
> 
> 
> On Fri, Jun 14, 2013 at 5:42 PM, Bob Jolliffe  wrote:
> Explain the Cambodian calendar a bit more.  I am sure there is more to it 
> than when the weeks start.  Or is that it?
> 
> 
> On 14 June 2013 17:35, Knut Staring  wrote:
> Thanks Jason and Bob.
> 
> Unfortunately, this seems to be a pressing requirement in several countries
> 
> I think one simplification that could be justified would be to have only one 
> week type in one DHIS2 instance. Thus, the exact meaning of 2012W25 is 
> defined by looking at the FIRSTDAYOFWEE

Re: [Dhis2-users] new web site

[Jim Grace]

Very cool -- nice look!

On May 31, 2013, at 11:57 AM, Lars Helge Øverland  wrote:

> Hi all,
> 
> we have a new web site today. We have tried to present DHIS 2 and the 
> community in a more comprehensive way, give the site a modern look and have 
> it scale well on mobile devices.
> 
> The site is built on a zen-based drupal theme and runs on nginx/php.
> 
> http://dhis2.org
> 
> 
> 
> regards,
> 
> Lars
> 
> 
> 
> PS use http://178.79.191.67 if you are still seeing the old site.
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] Downloading DHIS2 war fails. - Now day 2

[Jim Grace]

Bonjour Sovello,

At the moment I'm able to download the war file just fine here in Kenya. But 
earlier this week I was also having a lot of trouble downloading it from 
dhis2.org. It seems that the dhis2.org server is just a bit slower than some 
faster sites I download from, like Oracle. This may not even be noticed where 
you have fast Internet, but it can make all the difference where the Internet 
is not as fast, or probably more important, reliable. I happened to have a very 
fast hosting service in the US so I downloaded it first there, and then to here 
-- which worked fine. The file still happens to be there on my server, so 
please feel free to download it from there -- 
http://www.graces.com/test/dhis.war

I agree with what others have said about a good download manager. That has been 
essential to me in Kenya. My favorite one over the years for Windows is Free 
Download Manager (freeware).

à bientôt,
Jim

On May 23, 2013, at 11:31 AM, Knut Staring  wrote:

> Here's one for Firefox :
> 
> https://addons.mozilla.org/en-US/firefox/addon/downthemall/
> 
> Sent from my mobile
> 
> On May 23, 2013 10:29 AM, "Dayo Adeyomoye"  wrote:
> Oh okay, in the same vein, if someone sends the file to you, it will probably 
> also break during download. A download manager should actually work as 
> suggested by Jason and others.
> 
> Thanks
>  
> BlackBerry: 3114F90C
> Phone: 08028851441, 08035560463
> emails: deemo...@yahoo.com, addyr...@yahoo.com
> Yahoo IM: deemoyes
> Facebook: pharael
> twitter:pharaell
> From: Sovello Hildebrand Mgani 
> To: Dayo Adeyomoye  
> Cc: "dhis2-users@lists.launchpad.net" ; 
> Carlos Nyembwe  
> Sent: Thursday, May 23, 2013 9:22 AM
> Subject: Re: [Dhis2-users] Downloading DHIS2 war fails. - Now day 2
> 
> Merci Dav.
> Je vais essayer avec sourceforge maintenant.
> Dayo, I have tried all those and it ends up somewhere in the process of ca. 
> 80% of the dowloaded stuff.
> 
> Thanks you'll for the quick prompt and concern to assist.
> 
> Cheerio
> 
> 
> 2013/5/23 Dayo Adeyomoye 
> Bonjour,
> 
> The war file is not so big for a broadband though just 82 MB. How are you 
> trying to download it? Are you downloading from terminal on a Linux 
> production environment or you are trying to download directly from the 
> browser? which ever way, this may help if you haven't tried it yet.
> 
> 1. Using terminal
> sudo wget stable.dhis2.org
> 2. Using Web Browser direct
>  download
> http://dhis2.org/download/releases/2.11/dhis.war
> 
> 
> Hope this helps.
> Adedayo
>  
> BlackBerry: 3114F90C
> Phone: 08028851441, 08035560463
> emails: deemo...@yahoo.com, addyr...@yahoo.com
> Yahoo IM: deemoyes
> Facebook: pharael
> twitter:pharaell
> From: Sovello Hildebrand Mgani 
> To: dhis2-users@lists.launchpad.net 
> Cc: Carlos Nyembwe  
> Sent: Thursday, May 23, 2013 8:54 AM
> 
> Subject: [Dhis2-users] Downloading DHIS2 war fails. - Now day 2
> 
> Dear Colleagues!
> Bonjour from Kinshasa [RDC].
> We are a in a kickstart to implementing DHIS2 here. We have been struggling 
> to download the dhis2.war v2.11 file now a second day without any success. 
> I wonder what the problem would be! We first though proxies and other 
> securities could be the reason and went onto a mobile broadband connection, 
> From all sorts of browsers to wget, and no avail.
> If someone has this file, may them share via any means or compress it to an 
> uploadable email file size please? 
> 
> We would be more than grateful.
> 
> Cheerio!
> 
> -- 
> :: Sovello Hildebrand Mgani ::
> 
> 
> 
> --If you teach man to fish, you'll feed him a lifetime--
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
> 
> 
> 
> 
> 
> -- 
> :: Sovello Hildebrand Mgani ::
> 
> 
> 
> --If you teach man to fish, you'll feed him a lifetime--
> 
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] Setting up enviornment variable for DHIS2 on Ubuntu 12.04

[Jim Grace]

Dear Hannan,

Funny thing, I was also trying to find the right "bin" folder for setenv.sh for 
the first time just a couple of hours ago. It isn't /bin at the root of the 
drive, but bin under the Tomcat folder. Mine was at 
/usr/local/apache-tomcat-6.0.36/bin. And putting setenv.sh there worked for me. 
Yours may be somewhere else.

Cheers,
Jim

On May 22, 2013, at 12:41 PM, Saptarshi Purkayastha  wrote:

> Dear Hannan,
> 
> Java 8 is still Early Access. The public release has not been made. 
> The Oracle roadmap says its Q1 2014 and the beta is planned for Sept 2013.
> So its not something that is guaranteed in all cases
> 
> Also it seems likely that tomcat is using the other installed Java.
> Can you do: sudo update-alternatives --config java
>  and select the jdk7 that is installed
> 
> ---
> Regards,
> Saptarshi PURKAYASTHA
> 
> My Tech Blog:  http://sunnytalkstech.blogspot.com
> You Live by CHOICE, Not by CHANCE
> 
> 
> On 22 May 2013 10:56, Hannan Khan  wrote:
> Dear Expert Friends
>  
> As mentioned in the 'DHIS2 Implementation guide' I try to configure few of my 
> new servers I find that the 'setenv.sh' might not working. As per the 
> 'Implementation Guide' i create the 'setenv.sh' in the /bin folder. The 
> active java folder is '/usr/lib/jvm/java-8-oracle' and also java vesrsion 
> showing the proper installation.
>  
>  java version "1.8.0-ea"
> Java(TM) SE Runtime Environ
> Java HotSpot(TM) 64-Bit Ser
> Please note that previous vesrion of Java is there also.
>  
> JAVA_HOME mentioned as
>  
> export JAVA_HOME='/usr/lib/jvm/java-8-oracle'
> But Tomcat Showing diffent JVM with default memory seetings.
>  
> I usullay configure differently. Please can someone tell me whts wrong with 
> this setenv.sh.
>  
> Regards
>  
> Hannan Khan
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

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

Re: [Dhis2-users] Cumulative numbers in DHIS2

[Jim Grace]

Hi Jason,

Thank you, this is immensely helpful. I'm new to Postgresql and wasn't aware of 
the window-aggregate functions. They look very slick. And thanks for all the 
advice of how your aggregations interact with DHIS.

FACES has their DHIS implementation hosted for them, and while I have access to 
the back-end system, it would be best if this mechanism could be maintained in 
the future by those who do not. So my current thinking is I'll write a DHIS SQL 
View that pulls the data to be summed and also pulls the dummy data element 
values that should contain the cumulative amounts. This view is fetched through 
the Web API by a remote Java program and the values compared. (The SQL view can 
order the values by date for the convenience of the Java program to keep 
running totals.) The Java program can use the API to write back any cumulative 
values that need updating where the source values may have been recently 
entered or changed. Then we'll just rely on DHIS to process these data elements 
and we won't have to worry about how the mechanism might change in the future. 
We will only need the monthly values for reporting; we won't look at 
aggregations of the cumulative numbers through time since these will be 
incorrect.

FACES is very happy that they'll be able to pull these values through report 
tables and pivot tables. Thanks everyone for the advice. But eventually I hope 
DHIS will support cumulative indicators. The performance might be a concern, 
but as I said before if you need this data you'll have to pay the performance 
one way or another. DHIS could also report these indicators correctly over 
longer time periods. :)

Cheers,
Jim

On May 17, 2013, at 8:55 AM, Jason Pickering  
wrote:

> Hi Jim
> 
> I will outline my approach here.   
> 
> Create some dummy data elements which will be used for the cumulative data. 
> Data will be drawn from the "datavalue" table.  There are two ways which we 
> have used to aggregate the data 1) In Postgresql using a window-aggregate 
> function 2) in R with the "cumsum" function. I am sure you could use other 
> languages as well for this (Java, Python, etc) There are advantages and 
> disadvantages to both approaches, but generally I prefer to work with R as 
> opposed to SQL as it provides a bit more flexibility, but you will maybe pay 
> a performance penalty, so it really depends on how much data you are dealing 
> with and what language you are most comfortable using. Either way, you must 
> order the data correctly for each dataelement/categorycomboid/sourceid 
> combination, so that the running sum is generated correctly (i.e. ascending 
> date order)
> 
> Once you get the data, you can aggregate it to generate the running sum for 
> each sourceid/dataelementid/categorycomboid combination, with the periods 
> ordered correctly. Data in the "aggregateddatavaluetable" should be truncated 
> for the data elements you are working with, and replaced with the data which 
> you generate through your external aggregation function with appropriate 
> INSERT statements. The other option is to insert the data back into the 
> "datavalue" table, and allow the datamart to aggregate upwards through the 
> organisation unit hierarchy, which will work for the same frequency as your 
> data is collected. But the datamart will by default aggregate the monthly 
> cumulative values to quarterly cumulative values, but of course, this will 
> not work, so you must be very careful analyzing the data should you choose to 
> go this route. The easy way to deal with this is to only aggregate the data 
> at the same frequency and orgunit level as it is collected, and do any 
> subsequent analysis with Pivots or ad-hoc SQL queries. 
> 
> I am not sure however how long this approach is going to work, because I know 
> that a lot of stuff which depends on the datamart is being moved over to the 
> "analytics". I suppose the approach would be the same, but I have not looked 
> at it yet. 
> 
> Hope this helps to guide your approach. 
> 
> Best regards,
> Jason
> 
> 
> 
> 
> On Thu, May 16, 2013 at 3:39 PM, Jim Grace  wrote:
> Hi Jason,
> 
> Thanks, that sounds like the best option for us. I had almost gotten there 
> myself. I've just been describing to our M&E folks the various suggestions 
> I've received (thanks by the way Knut for the HTML report idea!) They are 
> having a hard time understanding why something so easy in Excel isn't 
> supported more simply through DHIS. I'm speculating that it may be because 
> HIV/AIDS treatment and care is a relatively new service, so people may be 
> more interested in cumulative numbers in this area; nobody is asking how many 
> deliveries have been d

Re: [Dhis2-users] Cumulative numbers in DHIS2

[Jim Grace]

Hi Jason,

Thanks, that sounds like the best option for us. I had almost gotten there 
myself. I've just been describing to our M&E folks the various suggestions I've 
received (thanks by the way Knut for the HTML report idea!) They are having a 
hard time understanding why something so easy in Excel isn't supported more 
simply through DHIS. I'm speculating that it may be because HIV/AIDS treatment 
and care is a relatively new service, so people may be more interested in 
cumulative numbers in this area; nobody is asking how many deliveries have been 
done in a hospital since it was founded 100 years ago!

I was thinking as a last resort we could define an extra data element but don't 
put it in one of the entry datasets. Then through the Web API I could 
periodically compute it for each site/month and upload it. But your approach 
sounds more efficient. Short of plunging in and reading the source code (which 
maybe I should do anyway), how do I understand what to do? Do I create a dummy 
indicator? How is the aggregateddatavalue table used? (Is it still used now 
that we have dynamic aggregation?) If you give me some initial help I may be 
able to find my way from there.

Cheers,
Jim

On May 16, 2013, at 4:07 PM, Jason Pickering  
wrote:

> Hi Jim,
> 
> Personally, I think the easiest way would be an external script which would 
> process the data and then inject it back into the aggregateddatavalue table. 
> Some might call this a  "hack", but we have used this approach for 
> calculation of these types of cumulative numbers and it seems to work fine. 
> In our case, we use a R script to make the calculation, and then inject the 
> data back into the aggregateddatavalue table. The script is executed on a 
> nightly basis. 
> 
>  The advantage with this approach is that the cumulative numbers are then 
> available through the normal tools to the user, such as the charts, and of 
> course, could be pulled out quite easily with the WebAPI into this Access 
> tool. 
> 
> I am sure there are other approaches, but this is one of them. :)
> 
> Regards,
> Jason
> 
> 
> 
> 
> 
> On Thu, May 16, 2013 at 2:47 PM, Jim Grace  wrote:
> Hi Jason,
> 
> Thanks. I agree it's best not to collect a cumulative amount as a data 
> element when it could be derived. You've given me some ideas how to pull it 
> out -- for instance I see I can write a Jasper report based on a query. 
> Although otherwise I was thinking we could pull all the data we need through 
> Report Tables -- which would be easier for FACES to maintain after I leave. 
> As a possible future DHIS enhancement, I think some way of getting this 
> functionality in a Report Table would be preferable, whether as a report 
> table feature, or as a way of defining a cumulative indicator (even better in 
> my opinion, because of the many ways that indicators can be used.) I realize 
> it would be performance expensive to compute such an indicator. But if it's 
> what you need, you have to pay this price one way or another.
> 
> At the moment I'm writing some code to use the Web API to pull out the FACES 
> data and put it into the MS Access reporting tool. Kenya is set to convert 
> from this tool to DHIS, but meanwhile we have to report through it. So it 
> sounds like for each site/month I will have to pull this data element for all 
> previous months and sum it in my tool. Or could I somehow get this through a 
> SQL view? I don't see any way of using parameters in a SQL view. (Am I 
> missing something?) So would I have to write a SQL view to generate the 
> cumulatives for all possible reporting months for all FACES sites? That 
> sounds awkward. Maybe pulling all prior months through the API is the lesser 
> evil, even though the Internet connection is somewhat slow here in Kenya.
> 
> Cheers,
> Jim
> 
> On May 16, 2013, at 2:26 PM, Jason Pickering  
> wrote:
> 
>> Hi Jim,
>> I have seen this exact same data element being collected USAID/PEPFAR 
>> supported organisations in Nigeria, Different organisations there, follow 
>> different approaches, either of collecting it in the way which you mention, 
>> or recording the cumulative figure each month. In the context of DHIS2, the 
>> recording of cumulative totals is not really a great idea, because there is 
>> not a "LATEST" aggregation operator, whereby the system simply would take 
>> the latest available cumulative figure as the current one. 
>> 
>> With that in mind, it is number better to simply record the number of new 
>> entrants each month. Once you have this, you can easily create a custom 
>> report to accumulate the data from inception, use an SQL query to aggregate 
>> it di

Re: [Dhis2-users] Cumulative numbers in DHIS2

[Jim Grace]

P.S. I was also hoping we could pull all our needed data into pivot tables. But 
it looks like these can't contain our "ever enrolled" number unless we collect 
it as a data element.

On May 16, 2013, at 3:47 PM, Jim Grace  wrote:

> Hi Jason,
> 
> Thanks. I agree it's best not to collect a cumulative amount as a data 
> element when it could be derived. You've given me some ideas how to pull it 
> out -- for instance I see I can write a Jasper report based on a query. 
> Although otherwise I was thinking we could pull all the data we need through 
> Report Tables -- which would be easier for FACES to maintain after I leave. 
> As a possible future DHIS enhancement, I think some way of getting this 
> functionality in a Report Table would be preferable, whether as a report 
> table feature, or as a way of defining a cumulative indicator (even better in 
> my opinion, because of the many ways that indicators can be used.) I realize 
> it would be performance expensive to compute such an indicator. But if it's 
> what you need, you have to pay this price one way or another.
> 
> At the moment I'm writing some code to use the Web API to pull out the FACES 
> data and put it into the MS Access reporting tool. Kenya is set to convert 
> from this tool to DHIS, but meanwhile we have to report through it. So it 
> sounds like for each site/month I will have to pull this data element for all 
> previous months and sum it in my tool. Or could I somehow get this through a 
> SQL view? I don't see any way of using parameters in a SQL view. (Am I 
> missing something?) So would I have to write a SQL view to generate the 
> cumulatives for all possible reporting months for all FACES sites? That 
> sounds awkward. Maybe pulling all prior months through the API is the lesser 
> evil, even though the Internet connection is somewhat slow here in Kenya.
> 
> Cheers,
> Jim
> 
> On May 16, 2013, at 2:26 PM, Jason Pickering  
> wrote:
> 
>> Hi Jim,
>> I have seen this exact same data element being collected USAID/PEPFAR 
>> supported organisations in Nigeria, Different organisations there, follow 
>> different approaches, either of collecting it in the way which you mention, 
>> or recording the cumulative figure each month. In the context of DHIS2, the 
>> recording of cumulative totals is not really a great idea, because there is 
>> not a "LATEST" aggregation operator, whereby the system simply would take 
>> the latest available cumulative figure as the current one. 
>> 
>> With that in mind, it is number better to simply record the number of new 
>> entrants each month. Once you have this, you can easily create a custom 
>> report to accumulate the data from inception, use an SQL query to aggregate 
>> it directly, or pull it out into other analytical tools such as R/Stata. I 
>> think if you need something for end-users, you would need to develop a 
>> custom report to achieve this, whereby data would be aggregated from 
>> inception of reporting, up until the "End date" chosen by the user. 
>> 
>> Best regards,
>> Jason
>> 
>> 
>> 
>> 
>> On Thu, May 16, 2013 at 10:58 AM, Jim Grace  wrote:
>> Hi All,
>> 
>> My PEPFAR partner organization FACES in Kenya is configuring our own DHIS2 
>> instance to collect data among the clinics we support. One of the standard 
>> government variables we collect and report each month is "ever enrolled in 
>> [HIV/AIDS] care". This means the cumulative number enrolled since the start 
>> of the service at each facility, which is often several years ago. It equals 
>> the sum of all the "enrolled this month" numbers going back through time. 
>> For example if "ever enrolled" is 4000 in January 2013, and "enrolled this 
>> month" is 100 in February 2013, then "ever enrolled" must be 4100 in 
>> February.
>> 
>> I am not (yet) seeing a good way to compute this in DHIS, so I'm asking 
>> advice. When we first started collecting this data from clinics in our 
>> current system of spreadsheets, we asked each clinic to compute the 
>> cumulative total and enter it for each month. We had a lot of errors this 
>> way, and we realized that it would be better calculating this in our tool 
>> instead of asking the data clerks to do this. So in our spreadsheets we just 
>> compute it by taking the previous month's "ever enrolled" and adding this 
>> month's "enrolled this month". Our records don't always go back to the start 
>> of care at each clinic, so we usually have an initial, hand-ent

Re: [Dhis2-users] Cumulative numbers in DHIS2

[Jim Grace]

Hi Jason,

Thanks. I agree it's best not to collect a cumulative amount as a data element 
when it could be derived. You've given me some ideas how to pull it out -- for 
instance I see I can write a Jasper report based on a query. Although otherwise 
I was thinking we could pull all the data we need through Report Tables -- 
which would be easier for FACES to maintain after I leave. As a possible future 
DHIS enhancement, I think some way of getting this functionality in a Report 
Table would be preferable, whether as a report table feature, or as a way of 
defining a cumulative indicator (even better in my opinion, because of the many 
ways that indicators can be used.) I realize it would be performance expensive 
to compute such an indicator. But if it's what you need, you have to pay this 
price one way or another.

At the moment I'm writing some code to use the Web API to pull out the FACES 
data and put it into the MS Access reporting tool. Kenya is set to convert from 
this tool to DHIS, but meanwhile we have to report through it. So it sounds 
like for each site/month I will have to pull this data element for all previous 
months and sum it in my tool. Or could I somehow get this through a SQL view? I 
don't see any way of using parameters in a SQL view. (Am I missing something?) 
So would I have to write a SQL view to generate the cumulatives for all 
possible reporting months for all FACES sites? That sounds awkward. Maybe 
pulling all prior months through the API is the lesser evil, even though the 
Internet connection is somewhat slow here in Kenya.

Cheers,
Jim

On May 16, 2013, at 2:26 PM, Jason Pickering  
wrote:

> Hi Jim,
> I have seen this exact same data element being collected USAID/PEPFAR 
> supported organisations in Nigeria, Different organisations there, follow 
> different approaches, either of collecting it in the way which you mention, 
> or recording the cumulative figure each month. In the context of DHIS2, the 
> recording of cumulative totals is not really a great idea, because there is 
> not a "LATEST" aggregation operator, whereby the system simply would take the 
> latest available cumulative figure as the current one. 
> 
> With that in mind, it is number better to simply record the number of new 
> entrants each month. Once you have this, you can easily create a custom 
> report to accumulate the data from inception, use an SQL query to aggregate 
> it directly, or pull it out into other analytical tools such as R/Stata. I 
> think if you need something for end-users, you would need to develop a custom 
> report to achieve this, whereby data would be aggregated from inception of 
> reporting, up until the "End date" chosen by the user. 
> 
> Best regards,
> Jason
> 
> 
> 
> 
> On Thu, May 16, 2013 at 10:58 AM, Jim Grace  wrote:
> Hi All,
> 
> My PEPFAR partner organization FACES in Kenya is configuring our own DHIS2 
> instance to collect data among the clinics we support. One of the standard 
> government variables we collect and report each month is "ever enrolled in 
> [HIV/AIDS] care". This means the cumulative number enrolled since the start 
> of the service at each facility, which is often several years ago. It equals 
> the sum of all the "enrolled this month" numbers going back through time. For 
> example if "ever enrolled" is 4000 in January 2013, and "enrolled this month" 
> is 100 in February 2013, then "ever enrolled" must be 4100 in February.
> 
> I am not (yet) seeing a good way to compute this in DHIS, so I'm asking 
> advice. When we first started collecting this data from clinics in our 
> current system of spreadsheets, we asked each clinic to compute the 
> cumulative total and enter it for each month. We had a lot of errors this 
> way, and we realized that it would be better calculating this in our tool 
> instead of asking the data clerks to do this. So in our spreadsheets we just 
> compute it by taking the previous month's "ever enrolled" and adding this 
> month's "enrolled this month". Our records don't always go back to the start 
> of care at each clinic, so we usually have an initial, hand-entered "ever 
> enrolled" to get things started on the month before we enter real data for 
> that clinic.
> 
> Now we are trying to convert our system of spreadsheets to DHIS, and I don't 
> see a good way to do this. I've tried creating a Report Table with "Include 
> cumulative" checked, but it only gives me cumulative numbers within the range 
> of report months. What we really need is to get the numbers for one or more 
> sites, for one or more months, and to have "ever enrolled" as one of the 
>

[Dhis2-users] Cumulative numbers in DHIS2

[Jim Grace]

Hi All,

My PEPFAR partner organization FACES in Kenya is configuring our own DHIS2 
instance to collect data among the clinics we support. One of the standard 
government variables we collect and report each month is "ever enrolled in 
[HIV/AIDS] care". This means the cumulative number enrolled since the start of 
the service at each facility, which is often several years ago. It equals the 
sum of all the "enrolled this month" numbers going back through time. For 
example if "ever enrolled" is 4000 in January 2013, and "enrolled this month" 
is 100 in February 2013, then "ever enrolled" must be 4100 in February.

I am not (yet) seeing a good way to compute this in DHIS, so I'm asking advice. 
When we first started collecting this data from clinics in our current system 
of spreadsheets, we asked each clinic to compute the cumulative total and enter 
it for each month. We had a lot of errors this way, and we realized that it 
would be better calculating this in our tool instead of asking the data clerks 
to do this. So in our spreadsheets we just compute it by taking the previous 
month's "ever enrolled" and adding this month's "enrolled this month". Our 
records don't always go back to the start of care at each clinic, so we usually 
have an initial, hand-entered "ever enrolled" to get things started on the 
month before we enter real data for that clinic.

Now we are trying to convert our system of spreadsheets to DHIS, and I don't 
see a good way to do this. I've tried creating a Report Table with "Include 
cumulative" checked, but it only gives me cumulative numbers within the range 
of report months. What we really need is to get the numbers for one or more 
sites, for one or more months, and to have "ever enrolled" as one of the 
numbers that is reported per site, per month. The best options I can think of 
are:

1. Ask each site to compute this number each month and enter it as a data 
element.

2. Export the data from DHIS into our own software and have our software 
compute this number.

Are there any better options?

Cheers,
Jim

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