Re: [Dhis2-users] [Dhis2-devs] LEVEL 2 TRACKER ACADEMY

[Ola Hodne Titlestad]

Dear Stanley,

We are preparing a brand new Level 2 course for Tracker and plan to launch it 
either late 2018 or early 2019.

While waiting for the new course we will keep you and others up to date on new 
Tracker features through our Feature Spotlight.

Please have a look at the videos available here:
https://www.dhis2.org/spotlight

… and look out for new video announcements on our Facebook and Twitter pages:

https://facebook.com/dhis2
https://twitter.com/dhis_2

Ola
-

Ola Hodne Titlestad (Mr)
DHIS2 Implementation Coordinator
HISP UiO
University of Oslo

Mobile/WhatsApp: +47 48069736
Google Hangout/drive: olati...@gmail.com<mailto:olati...@gmail.com>
Skype: olatitle


From: Dhis2-devs <dhis2-devs-bounces+olati=ifi.uio...@lists.launchpad.net> On 
Behalf Of Ocaya Stephen
Sent: 19. mai 2018 10:12
To: Stanley Kalyati <skaly...@gmail.com>
Cc: DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list 
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-devs] [Dhis2-users] LEVEL 2 TRACKER ACADEMY

Dear Stanley,

You can always check for upcoming DHIS2 academy and their different levels 
here<https://www.dhis2.org/academy>

regards

On Fri, May 18, 2018 at 3:47 PM, Stanley Kalyati 
<skaly...@gmail.com<mailto:skaly...@gmail.com>> wrote:
Are we going to have an academy for level 2 Tracker this year? Some of us level 
1 is not ideal,we need to be challenged.

Any information will be appreciated.

Stanley

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



--
--
Stephen Ocaya
Tel: +256 393 217 892 | Mob: +256774558980
www.stephocay.com<http://www.stephocay.com>
SkypeID: stephocay
___
Mailing list: https://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] Shift in strategy for DHIS2 Android development

[Ola Hodne Titlestad]

Hi all,

To respond to the increasing demand for Android apps for DHIS2 and keep up
with the constant and rapid evolution of mobile technologies, HISP UiO
management has decided to change the strategy for DHIS2 Android
development. This decision is based on acknowledging that HISP UiO hasn’t
delivered the high quality and timely Android products the DHIS2 community
is expecting.

Our approach to DHIS2 Android development will from now on be more
distributed. This will make it easier to engage experienced senior Android
experts around the world and allow the development to be more connected to
the field and the variety of country use cases. Also, through a more
collaborative roadmap process and frequent public communication, we intend
to foster a thriving community for DHIS2 Android development and use.

We have reached out to senior experts (business analysts, architects, and
developers) outside UiO and asked for support to set up the necessary
processes to restructure the DHIS2 Android development. We are partnering
with professionals who are close to the community, share our values, and
that we know well from previous collaborations.

This will allow a diverse team of core developers to build a strong SDK as
well as a suite of core apps. At the same time, we will enable the broader
community to build upon this core with a range of locally developed custom
apps, responding to the variety of use cases from countries. Key to the new
approach is also to empower community involvement through a collaborative
roadmap and testing process.

UiO will maintain its central role in coordinating the overall process and
making sure the Android activities are well aligned with the overall DHIS2
platform.

Stay tuned for more updates on Android apps in the near future.

The HISP UiO management team
___
Mailing list: https://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] Difficulties with the Program Indicators

[Ola Hodne Titlestad]

Hi Julie,

Would be good if you could share some more details about your program
configuration, including how you set up your program indicator.

Are you using event capture (single event data) or tracker capture
(multiple events and registration) for this use cases?

When you say you can see the data in event reports, does that include
aggregate values in the 'aggregated mode'?

If I have trouble with my program indicators, I typically like to use pivot
table app to debug. Try to add a few indicators that just count all events
or all enrollments and display these at the same time. Will give you an
indication of whether event analytics worked or not.

Then for your program indicators where you struggle to get data, try to
play with the different options of aggregation, e.g event count, enrollment
count etc. You'll soon see if the issue is related to aggregation or the
filter.

Ola
---

On 17 May 2017 17:48, "Em Le Hong"  wrote:

> Hi,
>
> If everything is ok and your formula is correct but you can't see the
> result. I guess you select both program indicator and data elements to show
> in Pivot table or Event report.
> Until now, DHIS2 only shows data for 1 selection data elements or program
> indicator. If you only select program indicator to show, but you don't see
> result, then you need to check your program indicator formula.
>
> Sincerely,
>
> On Wed, May 17, 2017 at 9:25 PM, Julie Vanhamme 
> wrote:
>
>> Hi Knut,
>>
>> Yes I did.
>>
>> Thank you very much in advance
>> Julie
>>
>> Julie Vanhamme
>>
>>
>>
>> 2017-05-17 16:07 GMT+02:00 Knut Staring :
>>
>>> Hi Julie,
>>>
>>> I am forwarding your question to the appropriate user mailing list.
>>>
>>> Just to make sure, did you run Analytics?
>>>
>>> Regards,
>>> Knut
>>> -- Forwarded message --
>>> From: Julie 
>>> Date: Wed, May 17, 2017 at 3:44 PM
>>> Subject: Difficulties with the Program Indicators
>>> To: Knut Staring 
>>>
>>>
>>> Hi,
>>>
>>> I am using the Event tracker of DHIS2 for a project.
>>>
>>> In a nutshell, I already set up the program and programs stages. I also
>>> run the Analytics and I have will all the data needed in my program.
>>> Indeed, while I am using the Event report with the data element (and not
>>> the indicators), everything is fine and I can see the pivot tables with
>>> the data.
>>>
>>> Now I am trying to create Indicators trough the program and everything
>>> seemed ok (the formula,  etc.). Except that when I am trying to use the
>>> indicator in a pivot table, the table appears but with no data inside.
>>>
>>> So what could be the problem with the indicators and how can I fix it?
>>> Is it a problem of configuration? Formula? ...
>>>
>>> Many thanks.
>>> Julie
>>> --
>>> This message was sent from Launchpad by
>>> Julie (https://launchpad.net/~juvhamme)
>>> using the "Contact this team's admins" link on the DHIS 2 Users team page
>>> (https://launchpad.net/~dhis2-users).
>>> For more information see
>>> https://help.launchpad.net/YourAccount/ContactingPeople
>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522 <+47%20918%2080%20522>
>>> 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
>>
>>
>
>
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.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] [Dhis2-devs] Calculation of conditional Indicators

[Ola Hodne Titlestad]

Hi Sam,

You may consider collecting some of this data with single events
(routine surveys/assessments) and then use program indicators or event
data item aggregation to get the aggregate numbers you are looking
for.

Ola
---
 

  https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail;
target="_blank">https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif;
width="46" height="29" style="width: 46px; height: 29px;" />
Virusfri. https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail;
target="_blank" style="color: #4453ea;">www.avast.com       



--
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 10 May 2017 at 10:01, Sam Kasozi <kaso...@gmail.com> wrote:
> What is the best approach for creating conditional indicators for routine/
> aggregate data such as facilities reporting stock outs or facilities
> providing a service?
>
> Besides creating new data element [Yes/No or (1/0)] that is assigned in the
> custom form whenever the condition is found to be true, is there an
> alternative?
>
>
> regards,
>
> Sam Kasozi
> +256 788-993-565
> Skype: sam.kasoziug
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://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] Need urgent help

[Ola Hodne Titlestad]

Hi Nad,

This could be due a limitation that is set in system settings. Go to
System Settings, look under General and change the top setting called
"Maximum number of analytics records" from "20" to "unlimited".
Then try the download again.

Ola
-
  

  https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail;
target="_blank">https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif;
width="46" height="29" style="width: 46px; height: 29px;" />
Virusfri. https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail;
target="_blank" style="color: #4453ea;">www.avast.com   



--
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 10 May 2017 at 11:18, Muhammad Nadeem <nade...@gmail.com> wrote:
> Hi all,
>
> I am using Event Reports option from dashboard to view all the data. But the
> issue i am facing is in downloading data.
> While downloading data for year 2017 shows total records are 40 but once
> downloaded its only shows 22.
> second not able to download data in excel format. please anyone guide and
> help me out.
>
>
> thanks
> Nad
>
> ___
> Mailing list: https://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] cecilia persson joins as technical writer

[Ola Hodne Titlestad]

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
<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge=en=UTF8=59.893855,10.785116=0.222842,0.585709=eftas%C3%A5sen+68,+0687+Oslo,+=h=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway=16>

On 5 August 2016 at 12:38, <moekets...@yahoo.com> wrote:

> Warm welcome to the team Cecilia!
> Regards,
> Tlohang
> Sent from my BlackBerry® smartphone from Vodacom
>
> -Original Message-
> From: Lars Helge Øverland <l...@dhis2.org>
> Sender: "Dhis2-users"
>  <dhis2-users-bounces+moeketsetf=yahoo@lists.launchpad.net>
> Date: Fri, 5 Aug 2016 12:26:23
> To: DHIS 2 Developers list<dhis2-d...@lists.launchpad.net>; DHIS 2 Users
> list<dhis2-users@lists.launchpad.net>
> Subject: [Dhis2-users] cecilia persson joins as technical writer
>
> ___
> Mailing list: https://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] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

[Ola Hodne Titlestad]

Supporting Jim's suggestion on a system/implementation setting to configure
a default system-wide separator in addition to the possibility of
overriding this for each pivot table or other type of report with display
options. I guess the result of the vote could still be what the default
value for this system setting should be

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge=en=UTF8=59.893855,10.785116=0.222842,0.585709=eftas%C3%A5sen+68,+0687+Oslo,+=h=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway=16>

On 3 May 2016 at 21:12, Jim Grace <j...@dhis2.org> wrote:

> To me the most important way to address this is to allow an
> implementation-wide default. The space character is in many ways the
> "correct" separator according to international norms, and is even making
> inroads into countries such as the US that traditionally use the comma. I
> think the space is probably the best "factory" default for DHIS 2, so that
> large numbers are readable on demonstration systems, and so we follow
> international and emerging standards.
>
> However, an implementation should be able to override this with an
> implementation-wide default of comma, where a preponderance of users for
> that implementation are more used to this, and/or where exporting to Excel
> is a concern.
>
> Expecting users to override the default every time they create a pivot
> table is not very user-friendly.
>
>
> On Tue, May 3, 2016 at 1:46 PM, Prosper BT <ptb3...@gmail.com> wrote:
>
>> I vote for having none as default (1432) then one can choose what they
>> want in options
>>
>>
>> On Tue, May 3, 2016 at 7:36 PM, Lars Helge Øverland <l...@dhis2.org>
>> wrote:
>>
>>> Hi there,
>>>
>>> we are getting many (conflicting) requests for what the default value
>>> should be for the "digit group separator" in the pivot table app.
>>>
>>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>>
>>> http://doodle.com/poll/vtyzgts226aqihev
>>>
>>>
>>> The digit group separator controls how large numbers are being split up,
>>> e.g.
>>>
>>> 1 432
>>> 1,432
>>> 1432
>>>
>>> The digit group separator can be controlled from Options.
>>>
>>> [image: Inline image 1]
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> l...@dhis2.org
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-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 <ptb3...@gmail.com> | 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-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] Program not displaying on the tracker capture page

[Ola Hodne Titlestad]

Hi Bridget,

In addition to giving access to the user you also need to assign the
program to the orgunits that shall use the program. You'll find that in the
program context menu (dropdown) for your program.

Ola
---
On 20 Apr 2016 14:10, "Bridget Magoba"  wrote:

> Dear Prosper,
>
> Thanks but I have done that and the program still does not appear.
>
>
>
> *From:* Prosper BT [mailto:ptb3...@gmail.com]
> *Sent:* Wednesday, April 20, 2016 12:59 PM
> *To:* Bridget Magoba
> *Cc:* DHIS 2 Users list; DHIS 2 Developers list
> *Subject:* Re: [Dhis2-users] Program not displaying on the tracker
> capture page
>
>
>
> Dear Bridget,
>
>
>
> You need to assign the program to a role you are using for tracker data
> entry.
>
>
>
> Now it added by going to User and roles app, edit the role and add the
> program.
>
>
>
> Regards
>
>
>
> On Wed, Apr 20, 2016 at 10:34 AM, Bridget Magoba 
> wrote:
>
> Dear all,
>
> I have created a new program in tracker but does not show up under program
> in tracker capture.
>
>
>
> I have run analytics and cleared cache but nothing yet. After a day it
> sometimes appears again but currently its not showing yet I need to test
> data entry.
>
>
>
> Anyone who has experienced the same?
>
>
>
> Please help.
>
>
>
> Magoba Bridget
>
> Database Manager
>
> MIFUMI
>
> Mobile: +256 774659892
>
> Tel: +256 414666946/392174242
>
> P.O Box 274, Tororo
>
> Plot 13, Martyrs’ Drive, Ntinda
>
> Kampala
>
> www.mifumi.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-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] Program validation rule firing on form load

[Ola Hodne Titlestad]

Hi Jason,

I'm not 100% sure, but I was under the impression that the new program
rules feature would replace the validation rules in Tracker (event and
tracker capture).

I see they are still both there, also in trunk, but I would guess program
rules are both more powerful and better supported, and should be a good
match for this use case.

Ola
--
On 7 Apr 2016 9:16 am, "Jason Pickering" 
wrote:

> Hi there. We have designed an inpatient discharge event capture program
> modeled on the "Inpatient morbidity and mortality" program on the demo
> site.
>
> We have defined a validation rule that the discharge date should be
> greater than the Admission date <= Discharge date.
>
>
> When ever we attempt to register an event, the rule immediately fires
> (even though both values are NULL at this point). This does not seem like
> desired behavior.
>
> This does not seem to happen on the demo. I am not sure if this is a
> difference in version (2.21 versus 2.22) or a difference in the operator (<
> in the demo or <= on our rule).
>
> Any thoughts?
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
> ___
> 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] DATEDIFF function in aggregated query

[Ola Hodne Titlestad]

Hi Pavel,

I moved your question to the DHIS 2 users list, a better place for
technical questions about DHIS 2.
If you haven't signed up for the list yet, please read how to here:
https://www.dhis2.org/contact

For aggregation of events I suggest you have a look at the Program
Indicators, documented here:
http://dhis2.github.io/dhis2-docs/master/en/user/html/ch30.html

Including functions like daysBetween documented here:
http://dhis2.github.io/dhis2-docs/master/en/user/html/ch30s03.html#d5e7283


Ola
-

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge=en=UTF8=59.893855,10.785116=0.222842,0.585709=eftas%C3%A5sen+68,+0687+Oslo,+=h=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway=16>

On 25 February 2016 at 10:59, Pavel Kozlov <pa...@shifo.org> wrote:

> Hello experts!
>
> I have question about DATEDIFF function in aggregated query. How it works?
> Or where I can read about this?
> For example: DATEDIFF([data element one], [data element two]) result in
> days or in data set dimension?
>
> Best regards, Pavel
___
Mailing list: https://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] Tables on event capture

[Ola Hodne Titlestad]

Hi Eric and Prosper,

Prosper, agree we should not allow category combinations to be selected for
data elements with domain type 'tracker'.

As to your example I'd like to add that for events it would probably make
more sense to create separate data elements for 'age' (numeric) and
'gender' (text with option set male/female),  as this will give a lot more
flexibility in terms of analysis and aggregation later. That's part of the
strength of the events model compared to aggregate.

Ola
---
On 23 Feb 2016 4:33 pm, "Prosper BT"  wrote:

> Dear Eric,
>
> Tracker both with and without registration data elements dont support
> category combinations. Its bad that its misleading in the design because
> when you select the domain type as tracker it still allow yo to select the
> category combination.
>
> In the events you will have to create each category as a single different
> data element
> Like these if you have a survey that collects such data
>
> Malaria - male under 5
> Malaria - male over 5
>
> I think the developers should control for this in the design that when you
> select a domain Tracker, some non applicable selection should be disabled.
>
> Regards
>
>
> On Tue, Feb 23, 2016 at 6:07 PM, eric mourin 
> wrote:
>
>> Hello,
>>
>> I have been trying to create tables using Category Combinations on data
>> elements and so far they have worked fine for data sets. Nevertheless, when
>> I used the same setup for event capture, the tables were not created and
>> only the data element was shown. Is this functionality implemented? Does
>> this need to be configured differently to show tables?
>>
>> 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
>>
>>
>
>
> --
> 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
>
>
___
Mailing list: https://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] Favourites with Multiple Analysis Org Units

[Ola Hodne Titlestad]

Pamod,

One relatively new Dashboard feature that might interest you is the ability
to switch 'user orgunit' for all items in a dashboard using the gear icon
next to the Search field. This will basically replace the 'user orgunit'
parameter value with whatever orgunit you select in the orgunit selection
tree.

Ola
--
On 5 Jan 2016 16:47, "Jan Henrik Øverland" 
wrote:

> Hi Pamod,
>
> Having multiple user org units should work well. Please note that "user
> org unit" (it should say "units" instead of "unit", I will fix that) refers
> to "Data capture and maintenance organisation units" in the user
> maintenance ui. The other one, "Data output and analysis organisation
> units", only controls the user's access in the org unit tree.
>
> Jan
>
> On Mon, Dec 28, 2015 at 12:30 PM, Pamod Amarakoon 
> wrote:
>
>> Dear All,
>>
>> Is it possible to create favorites (pivot table, event visualizer) for
>> users who are assigned to multiple data analysis org units, when the option
>> "User org unit" is selected at pivot table/event visualizer.
>>
>> I tried this on demo server by assigning the user "test1" to both Bo and
>> Bombali and it seems to analyze only the first org unit "Bo".
>>
>>
>> ​
>>
>> What's the proper method to follow to get analysis results for users who
>> are assigned for multiple analysis org units.
>>
>> Thank you
>>
>> --
>> Regards,
>> Pamod Amarakoon
>>
>> Confidentiality Notice: the information contained in this email and any
>> attachments may be legally privileged and confidential. If you are not an
>> intended recipient, you are hereby notified that any dissemination,
>> distribution, or copying of this e-mail is strictly prohibited. If you have
>> received this e-mail in error, please notify the sender and permanently
>> delete the e-mail and any attachments immediately. You should not retain,
>> copy or use this e-mail or any attachments for any purpose, nor disclose
>> all or any part of the contents to any other person.
>>
>>
>>
>>
>> ___
>> Mailing list: https://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] [Dhis2-devs] Aggregation levels...

[Ola Hodne Titlestad]

Hi Jerome,

If you can describe how you have configured the aggregation levels and
explain at which orgunit levels the data (for the same data elements) are
captured, then it will be easier to help you and do further investigation.

Thanks.

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge=en=UTF8=59.893855,10.785116=0.222842,0.585709=eftas%C3%A5sen+68,+0687+Oslo,+=h=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway=16>

On 17 November 2015 at 09:23, <jeromesha...@gmail.com> wrote:

> Yeah, we've regenerated analytics... we expect to see values correct for
> the aggregated level. But nothing comes thru!
>
> Sent from my BlackBerry 10 smartphone.
> *From: *Lars Helge Øverland
> *Sent: *Tuesday, 17 November 2015 09:21
> *To: *Jerome Shaguy
> *Cc: *dhis2-devs; DHIS 2 Users list
> *Subject: *Re: [Dhis2-devs] Aggregation levels...
>
> Hi Jerome,
>
> what behavior do you expect here? Tip: you need to re-generate analytics
> tables for aggregation levels to take effect in analytics.
>
> regards,
>
> Lars
>
> On Tue, Nov 17, 2015 at 9:19 AM, Jerome Shaguy <jeromesha...@gmail.com>
> wrote:
>
>> Hi Devs,
>>
>> I have configured datalements and set aggregation levels . However, these
>> aggregations are not coming into the pivot tables. Is there a bug with
>> this? I am on
>>
>> Version:
>> 2.20Build revision:19974
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> 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-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] Pivot table data reporting

[Ola Hodne Titlestad]

Dear Sumudu,

Method 2 should work. Note that you cannot use the data elements details
option then. You will get your 'type of surgery' disaggregation as a
separate dimension in analytics that you can see appearing as a new menu
item in the left side menu and that you can put on columns in the layout
selection. Then select your data elements as before, but in 'total' mode,
not details. Put data elements on rows. The gender dimension you don't
touch as you want all of those collapsed.

Ola
---
On 16 Aug 2015 4:53 pm, sumudu weerasinghe sumudu...@gmail.com wrote:

 Thanks Lars,

 I tried in two ways but unable to gain my need ,

 1.st  Method, it gives subdivision into gender , i need total of all
 gender category, without .
 [image: Inline image 2]


 2 nd method , also unable to give solution , giving same result as above.

 What i need is eg.
  1. no of plastic surgeries (Minor)--- not gender wise categorization


 Can we get it through dhis2?

 Regards
 Sumudu













 On Sat, Aug 15, 2015 at 4:19 PM, Lars Helge Øverland larshe...@gmail.com
 wrote:

 Hi Sumudu,

 yes there are two options:

 1. You can go to the data items  data elements section, the for data
 elements you select Details instead of Totals


 [image: Inline image 1]

 2. You can make sure your category is marked as a Data dimension in the
 maintenance (make sure to re-run analytics afterwards if you changed it).

 You can then use the category in your pivot (from the left side panel),
 select your items and place the dimension on the rows from the Layout
 dialog.


 regards,

 Lars







 On Sat, Aug 15, 2015 at 8:25 AM, sumudu weerasinghe sumudu...@gmail.com
 wrote:

 Dear all,

 We are  using dhis2 , 2.18 for a hospital information system.
 Data element for theater statistics developed by using category
 combination of ,  Gender( M,F,Not define) and Type of surgery(Major, minor,
 intermediate).

 I need to get report on total for each category   as follows,

  eg.



 Major

 Intermediate

 Minor

 No of general surgeries









 No of Plastic surgeries









 Is it possible to get such report in pivot table or any other reporting
 within dhis2?

 Regards,

 Dr.Sumudu Weerasinghe
 Medical officer Health informatics
 Teaching hospital - Ragama
 Srin Lanka

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




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 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-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 reports/charts/graphs Sharing

[Ola Hodne Titlestad]

To see your shared dashboard the user only needs the authority to see the
dashboard module, nothing else. So the user role for that is very basic.

What's important is the user group. You share dashboard with a user group,
not a user role.
Note that each tab on your Dashboards page is referred to as one Dashboard
and has its own sharing settings. For each dashboard you want to
restrict/mange access to, click on Share, then remove the public access and
add one or more  user group that you want to grant read or write access to.

Ola

On Mon, 15 Jun 2015 14:07 Knut Staring knu...@gmail.com wrote:

 What if you try a different browser and chrome incognito mode?

 And what if you make a third group which also have the same access rights?

 On Mon, Jun 15, 2015 at 2:04 PM, Muhammad Tahir mtag...@gmail.com wrote:

 Yes,  I have cleared the cache at admin and other user's end, but the
 results are still different.

 On Mon, Jun 15, 2015 at 5:03 PM, Knut Staring knu...@gmail.com wrote:

 So both user roles have exactly the same rights, but show different
 results? That is weird...

 On Mon, Jun 15, 2015 at 1:55 PM, Muhammad Tahir mtag...@gmail.com
 wrote:

 Hi Matthieu,

 I have created two roles Sales and Health Services with following
 rights,


- M_dhis-web-maintenance-appmanager
- M_dhis-web-maintenance-user
- M_dhis-web-event-visualizer
- M_dhis-web-reporting
- M_dhis-web-maintenance-dataset
- M_dhis-web-pivot
- M_dhis-web-dashboard-integration
- M_dhis-web-dataentry
- M_dhis-web-cache-cleaner
- M_dhis-web-mobile
- M_dhis-web-event-capture
- M_dhis-web-sms
- M_dhis-web-light
- M_dhis-web-maintenance-datadictionary
- M_dhis-web-maintenance-settings
- M_dhis-web-maintenance-program
- M_dhis-web-validationrule
- M_dhis-web-mapping
- See Tabular Tracker Capture
- M_dhis-web-maintenance-organisationunit
- M_dhis-web-importexport
- M_dhis-web-api-fred
- M_dhis-web-caseentry
- M_dhis-web-visualizer
- M_dhis-web-event-reports
- M_dhis-web-maintenance-dataadmin
- M_dhis-web-maintenance-mobile
- M_dhis-web-tracker-capture
- F_EXPORT_EVENTS
- F_EXPORT_DATA
- F_VIEW_DATABROWSER
- F_MYDATAMART_VIEW


 Later user created with each role is added to their respective groups
 Sales Group and HS Group.


 But the dashboard does not appear for Sales user, rather it appears for
 HS User. See the attached screenshots for reference.






 On Mon, Jun 15, 2015 at 4:24 PM, Matthieu Pinard matth...@ifi.uio.no
 wrote:

 Dear Muhammad,

 *Sharing a Dashboard*
 *- Sharing options*
 Could you send a screenshot of you sharing settings of the dashboard?

 *- User Access rights*
 What are the user's access rights of the user who cannot access the
 dashboard?

 *Sharing a chart*
 Yes it should be defined at the level of each chart by clicking the
 blue button in Favourites.

 Cheers,
 Matthieu


 Matthieu Pinard
 DHIS 2 Academy  Community Coordinator | University of Oslo

 On 15 June 2015 at 11:58, Muhammad Tahir mtag...@gmail.com wrote:

 Hi,


 I have created some reports and charts as admin user and have placed
 these on my dashboard.

 Now, I tried to share only selected tabs on my dashboard with a
 particular user group, but nothing appear at that user's end on its
 dashboard.


 Additionally, I would like to limit the visibility of reports/charts
 to specific users/user groups when permitted, as of now, I have to 
 manually
 block each report/chart to none.



 --
 *Regards,*
 *Muhammad Tahir*

 ___
 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





 --
 *Regards,*
 *Muhammad Tahir*

 ___
 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
 Norway: +4791880522
 Skype: knutstar
 http://dhis2.org




 --
 *Regards,*
 *Muhammad Tahir*




 --
 Knut Staring
 Dept. of Informatics, University of Oslo
 Norway: +4791880522
 Skype: knutstar
 http://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-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 entry value does not show in report data set

[Ola Hodne Titlestad]

Hi Thyda,

Depends a little on what you mean by report, but most of the ouput/analysis
modules in DHIS 2 uses the analytics API/tables as their data source and
not the raw/live data value store. By default on a server instance the
analytics data store is refreshed every midnight, so you may not see
changes in e.g. pivot tables immediately after making changes in data
entry.

You can check your scheduling settings for the analytics refresh in
Apps-Data Administration-Scheduling. But on a local install that doesn't
really apply.

You can trigger such a analytics refresh manually from Reports module
(Apps-Reports-Analytics and Data Mart), which may work well on a local
instance where you are the only user (analytics refresh may affect system
performance).

Ola
---




On Fri, 12 Jun 2015 at 11:30 Thyda Eng th...@instedd.org wrote:

 Dear Sir,

 I am currently working with dhis2 and I host it on my local server. Anyway
 I have problem on create the new data set and input the value to this data
 set on data entry module, then when I go to see my report of that data set
 it only show the last value of the field not the new input once. Anyway I
 try to clear the browser cache then It show in the report data set. I
 wonder whether is there any other way to let the new entry data show on the
 report data set without clearing the browser cache ? I am waiting for your
 reply.

 Thank,

 Thyda Eng
 ___
 Mailing list: https://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] Value not showing in Data Visualizer

[Ola Hodne Titlestad]

Hi Harsh,

Your approach to annualised monthly indicator values seem correct, but hard
to say why it doesn't work without seeing the whole indicator.
Can you paste in the full indicator formula, incl. information about your
numerator, is it collected monthly?

I've been using indicators of that type without any problems in the latest
2.19 release (and earlier versions), so doubt there is a bug there.

There are many examples of such indicators on the demo, e.g. ANC 1 coverage:
https://apps.dhis2.org/demo/dhis-web-maintenance-datadictionary/showUpdateIndicatorForm.action?id=52486

Denominator data element:
https://apps.dhis2.org/demo/dhis-web-maintenance-datadictionary/showUpdateDataElementForm.action?id=20899update=true

Numerator data element:
https://apps.dhis2.org/demo/dhis-web-maintenance-datadictionary/showUpdateDataElementForm.action?id=359596update=true


Ola
--




On Fri, 12 Jun 2015 at 09:23 Bharath chbhara...@gmail.com wrote:

 Hi All, Can you please tell us if we are making any mistake while defining
 indicators or is it a bug? Thanks in advance.

 On Wed, Jun 10, 2015 at 6:05 PM, Harsh Atal harsh.a...@gmail.com wrote:

 Hi All

 Forwarding this issue reported by Gitika from HISP India Delhi Office :-




 * I am using 2.20 snapshot and have created one data element 'Population'
 with aggregation operator as 'Average (sum in orgunit hierarchy)' which is
 used for annual data entry.Similarly have created an indicator using this
 data element as denominator and Is annualised set to 'Yes'.*
 *While using this data element or indicator in data visualiser for
 analysis, the monthly values are not shown, whereas the annual values are
 shown.*

 *Would like to know if some other users are facing this issue? It was
 working fine in the earlier version 2.17.*


 Every Help is Appreciated.

 Regards
 harsh

 ___
 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




 --

 Regards,
 Bharath Kumar. Ch
  ___
 Mailing list: https://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] Value not showing in Data Visualizer

[Ola Hodne Titlestad]

I see you mention 2.20 snapshot. Please try on https://apps.dhis2.org/dev
and see there. You can replace demo with dev in my example URLs below.

Ola
---


On Fri, 12 Jun 2015 at 09:32 Ola Hodne Titlestad ol...@ifi.uio.no wrote:

 Hi Harsh,

 Your approach to annualised monthly indicator values seem correct, but
 hard to say why it doesn't work without seeing the whole indicator.
 Can you paste in the full indicator formula, incl. information about your
 numerator, is it collected monthly?

 I've been using indicators of that type without any problems in the latest
 2.19 release (and earlier versions), so doubt there is a bug there.

 There are many examples of such indicators on the demo, e.g. ANC 1
 coverage:

 https://apps.dhis2.org/demo/dhis-web-maintenance-datadictionary/showUpdateIndicatorForm.action?id=52486

 Denominator data element:

 https://apps.dhis2.org/demo/dhis-web-maintenance-datadictionary/showUpdateDataElementForm.action?id=20899update=true

 Numerator data element:

 https://apps.dhis2.org/demo/dhis-web-maintenance-datadictionary/showUpdateDataElementForm.action?id=359596update=true


 Ola
 --




 On Fri, 12 Jun 2015 at 09:23 Bharath chbhara...@gmail.com wrote:

 Hi All, Can you please tell us if we are making any mistake while
 defining indicators or is it a bug? Thanks in advance.

 On Wed, Jun 10, 2015 at 6:05 PM, Harsh Atal harsh.a...@gmail.com wrote:

 Hi All

 Forwarding this issue reported by Gitika from HISP India Delhi Office :-




 * I am using 2.20 snapshot and have created one data element
 'Population' with aggregation operator as 'Average (sum in orgunit
 hierarchy)' which is used for annual data entry.Similarly have created an
 indicator using this data element as denominator and Is annualised set to
 'Yes'.*
 *While using this data element or indicator in data visualiser for
 analysis, the monthly values are not shown, whereas the annual values are
 shown.*

 *Would like to know if some other users are facing this issue? It was
 working fine in the earlier version 2.17.*


 Every Help is Appreciated.

 Regards
 harsh

 ___
 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




 --

 Regards,
 Bharath Kumar. Ch
  ___
 Mailing list: https://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] Turn off data aggregation

[Ola Hodne Titlestad]

Hi Laura,

If you can describe how you want the aggregation done we can guide you on
how to configure the aggregation levels.
The configuration and terminology can be a bit confusing at first. If you
are not seeing any aggregate data for higher levels in the analytics (e.g
in pivots) it means you have no data for the level you specified in the
data element's aggregation level.

If you specify e.g. facility and district as aggregation levels for a data
element then the national total for that data element will only include
data from district level and up, and not include data from levels below the
district (e.g. not include facility level data).

You can query and see data for any level in the hierarchy in the analytics
without specifying any aggregation level for a data element, so this is not
about making aggregate data available for the various levels, but about
specifying where to look for raw data when doing aggregations to higher
levels.


Ola
---


On 14 Apr 2015 21:59, Laura E. Lincks laura.lin...@icap.columbia.edu
wrote:

 Michael,

 I was wondering if you had any luck with this. I'm working with an
 instance where some data elements are set up to have Aggregation Levels
 (set at site/facility all the way up to Nation, the highest level of the
 OrgUnit hierarchy.) (However, we're using version 2.14 in this particular
 country). We're having difficulty when summing the data in a pivot table at
 any level above site/facility. If I remove the Aggregation Levels from the
 data elements I have better luck (but still have some strange problem.) I'd
 love to hear what success you've had.

 *Laura E. Lincks*
 Database Manager/Developer
 ICAP - Columbia University
 Mailman School of Public Health
 60 Haven Ave, Floor B1
 New York, NY 10032
 Tel: 212 304 7132



 On Wed, Apr 1, 2015 at 5:20 AM, Michael Mwebaze michael.mweb...@gmail.com
  wrote:

 Hi,

 I have been trying to configure DHIS2.18 to use aggregation levels but
 they seem not to work. I don't want the system to aggregate the data
 element values at each org unit. Setting the selected aggregation level
 with-in the data element doesn't seem to work.

 Anyone done this before?

 Michael

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




 --

 *Laura E. Lincks*
 Database Manager/Developer
 ICAP - Columbia University
 Mailman School of Public Health
 60 Haven Ave, Floor B1
 New York, NY 10032
 Tel: 212 304 7132

 ___
 Mailing list: https://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] Generating Monthly Indicators

[Ola Hodne Titlestad]

Hi Baakai,

This sounds like a caching issue to me. What I mean is that the  system or
bowser, in order to boost performance remembered the query
(indicator,period, orgunit) and gave you the same result from its
memory/cache without actually calculating the values again.

Can you try with another orgunit or period in the pivot table and see if
you still get non-annualised values for that same indicator?

If the numerator is monthly and the denominator is yearly the annualised
option will add a factor of 12 to the indicators value,  so should be easy
to see whether it works or not.

Ola
--
 On 26 Mar 2015 00:35, Baakai Kamoriki btkamor...@gmail.com wrote:

 Thanks Lars and Ola,

 It works!  I have set the aggregation operator to average(sum in org
 unit hierarchy) on the population data elements.  I also noticed that
 even without setting annualized to yes, for the indicators it still
 yield the same result in pivot table as to that set to annualized.

 In fact, after setting aggregation operator to average(sum in org
 unit hierarchy) on the population data element, I went straight to the
 pivot table and run the analysis.  It gives me the result but then I
 realized that I have not set the indicator to annualized.  I decided
 to download a copy of the result to excel before I annualized the
 indicator, just to see what would be the difference in the results.

 Now having set the indicator to annualized - yes, I refresh the
 pivot table and run the same indicator again with same period and org
 unit and to my surprise the results were the same? Does that mean that
 we do not have to annualize the indicator if the denominator is set to
 average(sum in org unit hierarchy).

 I did not try it out with data element aggregation operator set to
 average instead of average (sum in org unit hierarchy).

 Anyway, thanks once again for your help.

 Regards



 On Tue, Mar 24, 2015 at 6:16 PM, Lars Helge Øverland
 larshe...@gmail.com wrote:
  Hi Baakai,
 
  make sure you set the aggregation operator to average (sum in org unit
  hierarchy) on the population data elements. Then set annualized to yes
  for your indicators.
 
  regards,
 
  Lars
 
 
  On Tue, Mar 24, 2015 at 4:49 AM, Baakai Kamoriki btkamor...@gmail.com
  wrote:
 
  Dear all,
 
  Can anyone enlightens on how to generate monthly indicators which uses
  yearly population data?
 
  I had been trying to run pivot table on some health indicator for
  Solomon Islands such as watery diarrhoea, ARI to name a few by month
  but the pivot table always say no values.  In fact these data are
  collected on a monthly basis, however our population figures are
  yearly?
 
  Is there a way to do this kind of analysis in DHIS?
 
  We are currently using version 2.18.
 
  Many thanks.
 
  --
  Mrs Baakai Kamoriki
  Chief Medical Statistician
  HIS Unit/ MOH
  Honiara
  Solomon Islands
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 
 



 --
 Mrs Baakai Kamoriki
 Chief Medical Statistician
 HIS Unit/ MOH
 Honiara
 Solomon Islands

 ___
 Mailing list: https://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] dhis2 2, 18 resource table generate Bugs

[Ola Hodne Titlestad]

Hi Fatema,

This is not a database issue, but a bug that occurs when generating the
period structure table on machines/servers using on of a few specific time
zones.

I think I commented on this issues on another email thread you started.

Morten knows the details, but my quick fix advice is to change the system
time zone to a zone that we know works, e.g. GMT.

Ola
On 20 Mar 2015 14:16, Alex Tumwesigye atumwesi...@gmail.com wrote:

 Dear Fatema,

 All looks good and no duplicates.
 The only odd stuff is this: Note the years (2063 and 2140)
 811017,1,2063-03-11,2063-03-11
 811018,1,2063-03-12,2063-03-12
 811019,1,2063-03-13,2063-03-13
 811020,1,2063-03-14,2063-03-14
 811021,1,2063-03-15,2063-03-15
 811022,1,2063-03-16,2063-03-16
 811023,1,2063-03-17,2063-03-17
 811024,1,2063-03-18,2063-03-18
 811025,1,2063-03-19,2063-03-19
 811026,1,2063-03-20,2063-03-20
 811027,1,2063-03-21,2063-03-21
 811028,1,2063-03-22,2063-03-22
 811029,1,2063-03-23,2063-03-23
 811030,1,2063-03-24,2063-03-24
 811031,1,2063-03-25,2063-03-25
 1555,1,2140-09-03,2140-09-03
 1554,1,2140-09-04,2140-09-04
 1550,1,2140-09-05,2140-09-05
 1551,1,2140-09-06,2140-09-06
 1552,1,2140-09-07,2140-09-07
 1553,1,2140-09-08,2140-09-08

 can you try this query on period table?
 delete from period where enddate is null  or startdate is null;

 After running this query, go to resource table and regenerate them.

 Thanks.

 Alex

 On Fri, Mar 20, 2015 at 3:52 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Alex,

 I have run this query and get two result.

 select enddate,startdate,periodtypeid from period where enddate =
 '2009-12-31' or startdate = '2009-12-31'

 Result is

 2009-12-31;2009-12-01;3
 2009-12-31;2009-01-01;6

 here i attached the file too.

 Thanks a lot


 On Fri, Mar 20, 2015 at 6:37 PM, Alex Tumwesigye atumwesi...@gmail.com
 wrote:

 Fatema,

 Can you dump for me the enddate, startdate and periodtype from period
 table for that date '2009-12-31'

 I need to see the output of select enddate,startdate,periodtypeid from
 period where enddate like '2009-12-31' or startdate like '2009-12-31' 

 Thanks.

 Alex

 On Fri, Mar 20, 2015 at 3:20 PM, Calle Hedberg calle.hedb...@gmail.com
 wrote:

 Did you verify that all three constraints are in place on the period
 table?

 If they are and you are 100% sure there are no duplicates, then I don't
 know - I've had similar error messages a couple of times, but removing the
 duplicates and re-inserting the constraint have always sorted it out.

 Clear cache (DHIS and browser), empty resource tables, re-start tomcat
 - I'm not aware of any other tricks

 Regards
 Calle

 On 20 March 2015 at 14:15, Uddin Fatema fatema...@gmail.com wrote:

 Thanks Calle,

 I have already checked all part and this period is daily, so startdate
 and enddate is same 2009-12-31

 However, my problem is remains same

 What can i do.


 On Fri, Mar 20, 2015 at 6:11 PM, Calle Hedberg 
 calle.hedb...@gmail.com wrote:

 Fatema,

 note that 2009-12-31 looks like an ENDdate, not a startdate.

 Regards
 Calle

 On 20 March 2015 at 14:09, Uddin Fatema fatema...@gmail.com wrote:

 Thanks Bharath Anna and Alex.

 Actually i checked period table with this( 2009-12-31) startdate and
 there is no duplicate period with same startdate.

 Additionally, for test purpose i deleted this period from period
 table and from other related table with this periodid.

 Several time restart the tomcat and clear the cash.

 Although, problem remain same.

 Process failed: PreparedStatementCallback; SQL [insert into
 _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR: duplicate
 key value violates unique constraint _dateperiodstructure_pkey Detail:
 Key (dateperiod)=(2009-12-31) already exists.; nested exception is
 org.postgresql.util.PSQLException: ERROR: duplicate key value violates
 unique constraint _dateperiodstructure_pkey Detail: Key
 (dateperiod)=(2009-12-31) already exists.
 2015-03-20 12:03:45 Generating resource tables  

 What can i do now?

 On Fri, Mar 20, 2015 at 5:22 PM, Alex Tumwesigye 
 atumwesi...@gmail.com wrote:

 Dear Fatema,

 If I remember correctly, this used to be an issue in 2.16. I guess,
 it has been carried to 2.18.

 The problem was that, two similar dates were created and when you
 try to run the resource table, that range is already created.
 Query the period table directly for this date 2009-12-31, two
 duplicates may exist.Please try to attempt to compare ranges for 
 different
 period types, this is where the problem is (You will encounter a range 
 that
 is meant to be for a week, yet it is assigned to daily or monthly)
 If so, you may need drop it manually for the resource tables to be
 generated.
 Let me look for the script

 Thanks.

 Alex


 On Fri, Mar 20, 2015 at 2:06 PM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

 I have upgrade our application from 2.16 to 2.18.
 However, when we generate Resource table,we have get error. the
 error short note given in bellow.

  ERROR, category: 

Re: [Dhis2-users] FW: Data element categories in a stacked column chart

[Ola Hodne Titlestad]

Hi Paul,

It depends on how many data  dimensions you have enabled of course, but my
experience is that you can have quite a few before it becomes difficult to
navigate the left side menu in the analytics modules.

But looking at it from the other side, why collect this extra dimension it
if it's so rarely needed in analysis?

There are a few more possibilities for your chart, but it depends on
whether the your data element(s) have other categories in the category
combination. If FP device is the only category then you can use the details
option in the data element selection on DV. Select all the detailed data
elements (with category options, your FP devices) and put the data
dimensions on series in your chart.

If you have other categories combined with FP devices then you have to use
an indicator to add together your category option combinations for each FP
device.
If your chart aggregates together data for multiple data elements for each
device, then you must add all these data elements together in the indicator
as well.

I find it a lot easier to enable the category as a data dimension.

Ola
--
20. feb. 2015 21:30 skrev Paul Amendola paul.amend...@rescue.org:

  Hi Ola



 Thank you so much for the response, we really appreciate it. I’m sorry,
 just a quick follow-up question – so for any data element we want to
 display by category as a trend, would we need to add it as a data
 dimension? We’re just concerned about keeping the data dimensions
 manageable on the visualizer and pivot tables. For instance, most of our
 users won’t be using the ‘FP Device’ categories (vs gender or age, which
 will be more commonly used).



 Thanks,

 Paul



 *From:* olati...@gmail.com [mailto:olati...@gmail.com] *On Behalf Of *Ola
 Hodne Titlestad
 *Sent:* Thursday, February 19, 2015 4:09 AM
 *To:* Knut Staring
 *Cc:* dhis2-users@lists.launchpad.net; Paul Amendola
 *Subject:* Re: [Dhis2-users] FW: Data element categories in a stacked
 column chart



 Hi Paul,

 First you need to make sure your data element category (FP device type
 or similar) is enabled as data dimension. Edit the category and make sure
 the option Use as data dimension is ticked.

 This will make your category a separate data dimension in analytics, e.g.
 in data visualiser (DV). You need to re-run the analytics export after this
 (if you made a change to the category that is).

 Then go to Data Visualiser and look for the new dimension (data element
 category) in the left side menu (a tab with the same name as the data
 element category, e.g FP device type) and select all its options. Also
 select the data element, orgunit and periods you need.

 In layout put your data element category dimension (FP device type) in
 the series area and period in the category area. Data element and orgunit
 in the filter area.

 Change chart type to stacked bar chart, and click Update. This should give
 you a staked bar chart with your FP devices by type over time.

 Let me know how it goes.

 Ola
 --

 14. feb. 2015 11:07 skrev Knut Staring knu...@gmail.com:


  From: Paul Amendola
  Sent: Friday, February 13, 2015 10:37 AM
  To: 'dhis2-d...@lists.launchpad.net'
  Subject: Data element categories in a stacked column chart
 
 
 
  Hi
 
 
 
  We have a data element with category options that we would like to
 present in a stacked column chart. Ideally, the graph would be showing
 number of family planning devices (by device type) provided over time.
 However, we can’t seem to figure out how to create this chart with data
 element/category options. Any ideas?
 
 
 
  Thanks
 
  Paul
 
 


 ___
 Mailing list: https://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] FW: Data element categories in a stacked column chart

[Ola Hodne Titlestad]

Hi Paul,

First you need to make sure your data element category (FP device type or
similar) is enabled as data dimension. Edit the category and make sure the
option Use as data dimension is ticked.

This will make your category a separate data dimension in analytics, e.g.
in data visualiser (DV). You need to re-run the analytics export after this
(if you made a change to the category that is).

Then go to Data Visualiser and look for the new dimension (data element
category) in the left side menu (a tab with the same name as the data
element category, e.g FP device type) and select all its options. Also
select the data element, orgunit and periods you need.

In layout put your data element category dimension (FP device type) in
the series area and period in the category area. Data element and orgunit
in the filter area.

Change chart type to stacked bar chart, and click Update. This should give
you a staked bar chart with your FP devices by type over time.

Let me know how it goes.

Ola
--
14. feb. 2015 11:07 skrev Knut Staring knu...@gmail.com:


  From: Paul Amendola
  Sent: Friday, February 13, 2015 10:37 AM
  To: 'dhis2-d...@lists.launchpad.net'
  Subject: Data element categories in a stacked column chart
 
 
 
  Hi
 
 
 
  We have a data element with category options that we would like to
 present in a stacked column chart. Ideally, the graph would be showing
 number of family planning devices (by device type) provided over time.
 However, we can’t seem to figure out how to create this chart with data
 element/category options. Any ideas?
 
 
 
  Thanks
 
  Paul
 
 

 ___
 Mailing list: https://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] Associate an org. unit at the event level (and not at the tracked entity lavel)

[Ola Hodne Titlestad]

Hi Yoann,

I'll let the developers answer exactly how you can get this through the Web
API, but I can say that the Tracker has been designed to support different
orgunits for different events across the same enrollment.

So a child can throughout the immunisation program enrollment get vaccines
at different clinics and in the aggregate reports what matters is the
clinic where the child got the vaccine, not where the child was registered
at the beginning of the program.

Each event (programstageinstance in the db) has a reference to an orgunit,
which sounds like what you ask for.
This reference is separate from the event's reference to the enrollment
(which again references a patient (tracked entity instance).

The aggregation of event data is based on the event's orgunit, not the
enrollment/registration orgunit.

Not sure I understand  your requirements for aggregation from your email,
but it sounds like this is already supported.

Ola
--
6. feb. 2015 15:20 skrev Yoann Mira y...@novel-t.ch:

 Hello,



 I have a multiple event with Registration program.

 Is-it possible to associate an org. unit at the event level (instead of
 the patient level)?



 For example, I would like to enroll a Patient in a Program at the City
 level. But then I would like to specify for each event, the location of
 this event (at a clinic level).



 I need this because the patients are not fixed: they can be vaccinated in
 different clinics, but in my report I want to aggregate data at a clinic or
 a city level (a city can contain several clinics).



 Can I do something like this? Right now, I can’t find a way to specify the
 place of vaccination when I create an event for my patient…



 Kind regards.

 *Novel-**T* Sàrl

 *Yoann MIRA *



 ___
 Mailing list: https://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] Aggreration query for single event without registration

[Ola Hodne Titlestad]

Robin,

We have a feature to get number of events for a given program stage.

Two options need to be set:

1) Operator, at the top of the page, need to be 'Number of visits'

2) Under the Program tab, select 'Visited selected program stage'

The formula will then be on this format :
[PS:391]

With 391 being the internal id of the program  stage.

That should give you the total number of events for your single event
without registration program.

Ola
--
21. jan. 2015 10:37 skrev Robin Martens mart...@sher.be følgende:

Hi all,

  Is it possible in the Aggregation Query Builder to use the Number of
 tracked entities operator to calculate a number of events, especially when
 it concerns Single events without registration?

  I tried it and although it finds the events based on the conditions, it
 always returns 0 as a value.

  Regards,

  Robin

 ___
 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] Setting to show less fields in Event Capture

[Ola Hodne Titlestad]

Hi Elmarie,

Take a look at the program stage configuration. The list of selected data
elements should have  a property 'display in reports' (or similar). That's
where you can control which data elements are listed in the event list in
Event Capture.

The show/hide fields feature in Event Capture is just a temporary
adjustment, and changes there are not persisted.

Ola
--
14. jan. 2015 13:10 skrev Elmarie Claasen elma...@hisp.org følgende:

 Hi all,



 I would like to know what I am doing wrong. We have an instance where we
 capture data in the Event Capture form on a custom form. The listing page
 when you open a facility where you are able to search for a record captured
 shows all the fields by default with the ability to click on ‘show/hide
 columns’. I am able to untick some of the columns so that the listing is
 more spread out rather than text over each other but the system does not
 keep that setting. If you move to a 2nd page all the fields show again or
 if you go out and come back in everything shows.



 Is this a bug or am I doing something wrong?



 Version: 2.17

 Build revision: 17605



 I tried to look on Sierra Leone demo but I did not know where the event
 capture data is so couldn’t check that instance to confirm if it behaves
 the same.



 Regards,



 *Elmarie Claasen*

 [image: Hisp logo]

 Project Manager

 Health Information Systems Programme

 Tel:  041-367 1027

 Cell: 082 374 2209

 E-mail: elma...@hisp.org

 Skype:  elmarie.claasen52



 ___
 Mailing list: https://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] Information détail on Organisation unit

[Ola Hodne Titlestad]

Hi Guy,

In addition to the attributes feature you can also add groups to orgunits.
Groups can be further organised in group sets which can be used as
dimensions in the analytics tools like Pivot Tables and Data Visualizer.
The attributes are typically used for more free text descriptions like
Address, P.O. Box etc. , information that does not aggregate well.

As Riddy mentioned you will need to create more custom type reports to get
the attribute information, e.g. using HTML reports and the Web-API.
You can also try sql view (in Data Administration) to quickly see orgunits
and related attribute values joined.

More documentation here:

Orgunits and groups/group sets:
https://www.dhis2.org/doc/snapshot/en/user/html/ch04.html
https://www.dhis2.org/doc/snapshot/en/implementer/html/ch10s02.html

Attributes:
https://www.dhis2.org/doc/snapshot/en/user/html/ch21s15.html

SQL view:
https://www.dhis2.org/doc/snapshot/en/user/html/ch21s06.html

HTML reports:
https://www.dhis2.org/doc/snapshot/en/developer/html/ch03s04.html#d5e4986

On the online demo you can view examples of all of this, inluding SQl views
and HMTL reports.
https://apps.dhis2.org/demo/dhis-web-reporting/displayViewReportForm.action
https://apps.dhis2.org/demo/dhis-web-maintenance-dataadmin/sqlView.action

Ola


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16

On 5 January 2015 at 17:18, riddy ndoma riddynd...@gmail.com wrote:

 Hi Guy,
 You can add them as Attribute. Go to Appsdata Administration Attribut

 To view the organizational units uses the SQL Query

 regards,


 2015-01-05 17:01 GMT+01:00 Guy Ekani constyek...@yahoo.fr:

 Hello everyone,

 I would like  to know if it's possible besides of Organisation Unit Group
 Set, to add additional information détail (Town, PO box) to an organisation
 unit?

 And how can i have a report with of all organisation unit and all these
 information listed (Ownership, Type, region, district, Name, Gps, Contact
 person, telephone, Email) ?

 Sincerely,

 Version:2.16Build revision:16262

 =
 EKANI Guy
 Cameroon




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




 --
 Riddy NDOMA
 Software Developer
 *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
 *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
 *Blog:* http://riddyndoma.blogspot.com/
 *Vous servir est mon désire (Serving you is my desire)*

 ___
 Mailing list: https://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] Accessing Program Instances in the Web API

[Ola Hodne Titlestad]

Hi Simen,

I think we call Program Instances for Enrollments in the api.

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s34.html#d5e3563

Ola


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16

On 6 November 2014 18:24, Simen Skogly Russnes simen_russ...@hotmail.com
wrote:

 Hi all,

 I'm trying to access Program Instances for Tracked Entity Instances using
 the WebAPI because I'm enrolling to stages in a mobile client, and I need
 to set duedate for which I need the registration date of the Program
 Instance. I couldn't find it browsing the api, and I couldn't find it in
 api/events, although I can easily find the Program Stage Instances. Is it
 possible to access it somehow? Perhaps I'm just not seeing it. A list of
 all Program Instances would be good for bulk loading, and for a single
 Tracked Entity Instance on demand but I don't know what's possible.

 Regards,
 Simen

 ___
 Mailing list: https://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] Custom Tracked Entity Instance Page

[Ola Hodne Titlestad]

Hi Pamod,

I think the two apps you should look at are Tracker Capture and Event
Reports.

In Tracker capture the TEI list (Search page) is not meant to show any
event data, but just the attributes you need to identify a TEI.
Which attributes that are displayed in the TEI list (search result) can be
controlled in Edit Program (look for Display in list property), and by
using the Settings in the top right corner of the TE  (where you can
show/hide attributes that have Display in list checked.
If you want to look at the associated event data for a specific TEI, then
click on it and look for events and related data values in the TEI
dashboard.

In Event Reports (Individual cases mode) you can see both attributes and
data element (event) values in a grid format, so that might be what you are
looking for. There you can specify exactly which attributes and data
elements to show in the report.

Ola
---


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 3 September 2014 09:53, Pamod Amarakoon pam...@gmail.com wrote:

 Dear All,

 For a DHIS 2.16 instance I'm currently running, is it possible to have a
 custom tracked entity instance page.

 i.e: I'm trying to display a page where a DHIS user can have at a glance
 some key atrributes and key data elements values as a summary when he
 clicks on Find/Add Instance with possibly a link to entity dashboard (which
 is already available in tracked entity instance). Currently only entity
 attributes are displayed.

 Is it already available or have to get it through web API?

 Thank you
 --
 Pamod Amarakoon


 ___
 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] Custom Tracked Entity Instance Page

[Ola Hodne Titlestad]

On 3 September 2014 15:33, Pamod Amarakoon pam...@gmail.com wrote:

 Hi Ola Hodne Titlestad,

 Thanx for the reply. Yes Event Reports is sort of what I'm looking for but
 only issue is I can't see an option to display attributes.


There was a bug fix for that a few weeks ago. Try to update to the latest
2.16 build. Attributes and data elements are all shown in the same
Available data items list.


 I can view all data elements for relevant individuals. and is there anyway
 to have a link on each record so as to direct to entity dash board.


Not at the moment no, but I like the idea. It might be something we could
include in the future.

Ola
---



 Thanx


 On Wed, Sep 3, 2014 at 6:50 PM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:

 Hi Pamod,

 I think the two apps you should look at are Tracker Capture and Event
 Reports.

 In Tracker capture the TEI list (Search page) is not meant to show any
 event data, but just the attributes you need to identify a TEI.
 Which attributes that are displayed in the TEI list (search result) can
 be controlled in Edit Program (look for Display in list property), and by
 using the Settings in the top right corner of the TE  (where you can
 show/hide attributes that have Display in list checked.
 If you want to look at the associated event data for a specific TEI, then
 click on it and look for events and related data values in the TEI
 dashboard.

 In Event Reports (Individual cases mode) you can see both attributes and
 data element (event) values in a grid format, so that might be what you are
 looking for. There you can specify exactly which attributes and data
 elements to show in the report.

 Ola
 ---


 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
 https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


 On 3 September 2014 09:53, Pamod Amarakoon pam...@gmail.com wrote:

 Dear All,

 For a DHIS 2.16 instance I'm currently running, is it possible to have a
 custom tracked entity instance page.

 i.e: I'm trying to display a page where a DHIS user can have at a glance
 some key atrributes and key data elements values as a summary when he
 clicks on Find/Add Instance with possibly a link to entity dashboard (which
 is already available in tracked entity instance). Currently only entity
 attributes are displayed.

 Is it already available or have to get it through web API?

 Thank you
 --
 Pamod Amarakoon


 ___
 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





 --
 Pamod


___
Mailing list: https://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] ICD10

[Ola Hodne Titlestad]

Hi Simon,

Have a look at the section called Use Case 1: Anonymous inpatient
admissions and deaths with ICD-10 coding on this page:
https://www.dhis2.org/individual-data-records

With aggregate data you will have to pre-define all the data elements with
ICD-10 codes before starting data entry, so that could be thousands of data
elements depending on what you decide to use.

With events data you can collect a few data elements about each case, and
only need one data element to capture Diagnosis. To this data element we
then assign an option set with all the diagnoses with coding. Each
admission to the hospital is one event in the database, so you will enter
data straight from the register book.

Note that to do morbidity and mortality analysis there is no need to
capture person names and ids, what you care about are typically the
diagnosis, age, gender, insurance status, and the outcome etc.-.
- so the events can be anonymous, no need to register the patients for this
use case.

Then with event analysis you can do on the fly aggregations on these events
with all kinds of filters on the data elements and their options/values. In
2.16 you can now build charts (as well as tables) presenting the aggregated
events data also on the dashboard, without having to save these values (the
query/filter is saved) in aggregated data elements.

Have a look at the online demo and the Dashboard called Inpatient
Morbidity and Mortality. Click on one of the charts and you will see the
new event analyzer, very much like the Data Visualizer, but based on the
events data. From there you can up in the top right corner select
Table-Open this chart as a table. That will take you to the event
reports.There you will see that you can look at both aggregated values as
well as Individual cases (top left corner). Try to click on Individual
cases and you will drill down to the actual events (admissions) that made
up these aggregate numbers. Then you can e.g. add more data elements to the
table to see more details about each event.

On a related note I should mention that we are working with WHO to in near
the future distribute (make available in DHIS 2) a more useful ICD-10 list
simplified to be used at local levels. The list Lars referred to is not an
official list (the XML download), and is just a suggestion (proof of
concept) for how this can be done. You should make sure that the options
there are according to how you would like to make use of the ICD-10 codes
as it is not the full official list.

Ola
---

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 7 August 2014 16:20, Simon Muyambo smmuya...@gmail.com wrote:

 Thanks very much. You are right, I was referring to aggregate data so that
 the forms reflect ICD-10 codes



 *Regards*

 *Simon Muyambo*





 *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
 *Sent:* 07 August 2014 13:35
 *To:* Nayeem Al Mifthah
 *Cc:* Simon Muyambo; dhis2-users@lists.launchpad.net
 *Subject:* Re: [Dhis2-users] ICD10



 Thanks Nayeem for sharing that experience.  I had assumed that Simon was
 referring to aggregate data, perhaps wrongly.



 Simon, for individual event capture there is also an example of what
 Nayeem describes on our demo site
 https://apps.dhis2.org/demo/dhis-web-event-capture/index.html.



 Regards

 Bob



 On 7 August 2014 10:58, Nayeem Al Mifthah n.mift...@gmail.com wrote:

 We are using ICD-10 for hospital indoor patient record management and
 causes of death.



 We make option set with all 3 digit and 4 digit codes. Some facility can't
 identify 4 digit code but they can identify 3 digit code due to
 availability of diagnostic facility.



 As a result we include all diseases into one option set including code and
 name for flexibility to search as you type with any of these.


 *Nayeem Al Mifthah*

 HMIS C

 onsultant

 Management Information System

 Directorate General of Health Services (DGHS), Bangladesh

 Supported by: UNICEF

 -Bangladesh



 Email: *n.mift...@gmail.com n.mift...@gmail.com*



 *| nay...@mis.dghs.gov.bd nay...@mis.dghs.gov.bd*

 Cell:*+8801914030574 %2B8801914030574*



 On Thu, Aug 7, 2014 at 3:56 AM, Simon Muyambo smmuya...@gmail.com wrote:

 Can you please guide me to documentation on setting up and using ICD10?



 *Regards*

 *Simon Muyambo*







 __ Information from ESET NOD32 Antivirus, version of virus
 signature database 10214 (20140806) __

 The message was checked by ESET NOD32 Antivirus.

 http://www.eset.com



 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users

Re: [Dhis2-users] DHIS2 - Event list empty

[Ola Hodne Titlestad]

Hi Robin,

The event data is stored in the patientdatavalue table. You'll see a
reference to programstageinstance  (event) there. Through that you can find
your program, in case you have data for more than one program.

The event analytics process only reads from the patientdatavalue table, it
never changes or deletes anything there.

Ola
--
6. aug. 2014 11:51 skrev Robin Martens mart...@sher.be følgende:

  Hi,



 I'm not sure if I understand your question, but the event report shows all
 the data for each of the events.



 I'd like to check manually in the database to verify the entries. In which
 table does DHIS2 store its event data? Also, I understand that the data is
 moved to the analytics tables when running the analytics module, but is
 this a copy-paste or cut-paste of the data?



 Kind regards,



 Robin



 *From:* Abyot Gizaw [mailto:aby...@gmail.com]
 *Sent:* 05 August 2014 21:50
 *To:* Robin Martens
 *Cc:* DHIS 2 Users list
 *Subject:* Re: [Dhis2-users] DHIS2 - Event list empty



 Hi,

 One possibility could be blank events... have you seen details of these
 events in the module they have come visible?

 Thank you,
 Abyot.
 On Aug 5, 2014 6:31 PM, Robin Martens mart...@sher.be wrote:
 
  Hi,
 
 
 
  I've got a small issue here: for a certain program and a certain
 orgunit, it displays the message 'There are no events through the Event
 Capture module, even if I know there are as the events are still visible in
 the Event Reports and Manual Aggregation modules. This is only the case for
 this single orgunit/program combination, all others work fine.
 
 
 
  There's no error log and clearing the cache didn't work. DHIS2.16/16253.
 
 
 
  Any ideas?
 
 
 
  Regards,
 
 
 
  Robin
 
 
  ___
  Mailing list: https://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] [Dhis2-devs] Speed up the Data capture and maintenance organisation units

[Ola Hodne Titlestad]

Hi Chuong,

Have a look at the system setting Maximum offline organisation unit
levels which can be used to reduce the orgunit hierarchy loading time in
cases where you have many orgunits.

Briefly explained here:
http://www.dhis2.org/doc/snapshot/en/user/html/ch23.html#systemGeneralSettings

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 4 June 2014 08:51, Thái Chương thaichuong...@gmail.com wrote:

 Hi Devs,
 In user management, I just feel the Data capture and maintenance
 organisation units list is slower than Data output and analysis
 organisation units
 Is there any way to speed it up? It's causing issue in my slow internet
 connection.

 Thank you very much and best regards,

 --
 Thai Chuong
 YM/Skype : thaichuong159
 Phone: (+84) 918776134

 ___
 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] Speed up the Data capture and maintenance organisation units

[Ola Hodne Titlestad]

On 4 June 2014 21:28, Thái Chương thaichuong...@gmail.com wrote:

 Thank you Ola,
 We have 4 levels and already set to the largest one.

Actually it works the other way around, so setting it as level 2 or 3 would
make it faster and then only download level 4 units to your local storage
when you try to expand a level 3 unit.
So you specify the number of levels of the hierarchy to download, starting
from the level of the user orgunit.
Try to change the settings and see if it helps. If you have many big custom
forms that may also cause some waiting time for the initial download and on
updates.


 The internet connect sometimes lost 50 or 75%. Some computers could not
 load org unit tree.
 But on the user management, feel the Data output and analysis
 organisation units always load quite fast and stable.
 Just wondering that we can do that for other parts also.


I'll let the devs respond to this I think, but the main difference is that
we offer offline data entry which means that orgunits and forms are
downloaded to your browser's local storage.
A new download will be triggered every time there is an update to the
orgunits or forms on the server.

The analysis modules work differently, but also needs to load a
considerable amount to the client of data when opening the module.

Ola
--



 Regards,


 On Wed, Jun 4, 2014 at 5:28 PM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:

 Hi Chuong,

 Have a look at the system setting Maximum offline organisation unit
 levels which can be used to reduce the orgunit hierarchy loading time in
 cases where you have many orgunits.

 Briefly explained here:

 http://www.dhis2.org/doc/snapshot/en/user/html/ch23.html#systemGeneralSettings

 Ola
 --

 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
 https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


 On 4 June 2014 08:51, Thái Chương thaichuong...@gmail.com wrote:

 Hi Devs,
 In user management, I just feel the Data capture and maintenance
 organisation units list is slower than Data output and analysis
 organisation units
 Is there any way to speed it up? It's causing issue in my slow internet
 connection.

 Thank you very much and best regards,

 --
 Thai Chuong
 YM/Skype : thaichuong159
 Phone: (+84) 918776134

 ___
 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





 --
 Thai Chuong
 YM/Skype : thaichuong159
 Phone: (+84) 918776134

 ___
 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] Fwd: Can't select parameter in Jasper reports

[Ola Hodne Titlestad]

Hi Cenk and Laura,

I think the way standard reports are implemented, and especially the
parameters part, have changed a lot between 2.4 and 2.13, so I am quite
sure that your old standard reports from 2.4 will not work out of the box
in DHIS v. 2.13. And your email confirms that I guess...

I can't remember exactly how it was changed, but what you can do is to
create a new standard report in 2.13, choose Jasper report with report
table data source under Type, and the click on Get current design. That
should give you a template of what the xml format supported in 2.13 is.
Open that file in a text editor and you will see that there is a section in
the beginning where the parameters are listed.

Then I suggest you give it a try to merge the old report design with the
new template and make sure you get the new format for parameters correct.

Sorry if this wasn't very helpful. A search through the email archives for
dev and user lists might give you better answers. I remember that at some
point it was a rather painful upgrade of the standard reports, but that was
a long time ago.

Maybe others have better memory of that than I do...

Ola
-








--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 21 May 2014 19:10, D. Cenk Erdil dcer...@gmail.com wrote:


 Hello,

 One of our team members has tried to sent an email to the list but
 apparently it kept bouncing back. I’m forwarding Laura’s original message
 in lieu of her. Any help is appreciated.

 Basically my take of the issue basically is that there are two parameters
 in a Jasper report, one of them (Org Units) gets populated, but the other
 (Reporting Period drop down) does not. Hence you cannot generate reports.

 We have gone through underlying XML code to update SQL statement
 accordingly to reflect the schema changes from 2.4 to 2.13, but apparently
 there is no SQL snippet(s) that generate(s) reporting periods (or we’ve
 missed it).

 A screenshot of the non-working drop down, and the current Jasper report
 design of the report are attached.


 Thanks,
 --
 -Cenk.

 D. Cenk Erdil, PhD
 HMIS Manager
 ICAP at Columbia University http://icap.columbia.edu/



 *From:* Lincks, Laura E.
 *Sent:* Monday, May 05, 2014 12:52 PM
 *To:* DHIS 2 User Group
 *Subject:* Can't select parameter in Jasper report

 We have a version of DHIS 2.13 running. It was upgraded from version 2.4
 There are a series of Standard Jasper reports from the old version which do
 not run in 2.13.

 The reports are of the type “Japser report with report table data source”.
 Most of the reports in question are generated by first selecting a
 Reporting Period and then an Organisation Unit as parameters. I am able to
 access the underlying Report table in DHIS 2.13 and I am prompted with the
 parameter selection screen but I cannot select the Reporting Period.
 Accessing the pulldown menu produces no list of dates. (The Organisation
 Unit tree appears and is accessible, but without passing a reporting period
 parameter, the report fails.)

 While I can “Get current design” of the Standard Report I cannot edit or
 see the source of the associated Report Table which appears to be what
 passes the parameters to the standard report. I am new at generating Jasper
 reports in DHIS and don’t know what I am missing. Any help would be
 appreciated.

 TIA.


 *Laura E. Lincks*
 Database Developer
 ICAP - Columbia University
 Mailman School of Public Health
 60 Haven Ave, Floor B1
 New York, NY 10032
 Tel: 212 304 7132











 ___
 Mailing list: https://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] Pivot Table does not display correct data

[Ola Hodne Titlestad]

Hi José,

As you pointed out the missing data for January in your pivot table is most
likely caused by a problem with the analytics tables generation.

In order to find out what went wrong with the analytics process we need to
see your tomcat log.

The current analytics tables are only replaced when a new analytics export
process has completed successfully, and if it fails the tables remain as
before.
So that is likely why you can still see older data in your pivots, but not
the new January data (you write that analytics process runs indefinitely).

Can you try to run analytics (manually from UI) one more time and then
monitor your tomcat log at the same time, and possibly share the relevant
part of the log with us?

Thanks.

Ola
---


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 22 May 2014 18:32, José Berilo jber...@bemfam.org.br wrote:

 Hi All,

 I have the following problem:

   Data entered in the data entry module does not appear in the pivot table
 as a sequence of screens figure 1, Figure 2 and figure 3. Follow the
 example in the screenshot below with data entered in a unit hierarchically 
 linked
 to Prog Maranhão in January 2014. Pivot Table data that month is not
 displayed. Have tried to update the analytical tables but did not work. Is
 running indefinitely.

 Can someone help?

 Thank you.

 --
 
 José Berilo
 Estatístico
 DEAVE - BEMFAM
 jber...@bemfam.org.br
 Tel. 21 30052412

 ___
 Mailing list: https://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] upgrade from dhis 2.14 to 2.15

[Ola Hodne Titlestad]

On 26 May 2014 13:18, Tony Iha tony...@gmail.com wrote:

 Could anyone point me to some notes on how to do a smooth upgrade from
 2.14 to 2.15

 *My steps.*
 1. I downloaded the latest stable version of 2.15
 Version:2.15 Build revision:15074 Build date:2014-05-25 20:19
 2. Took a sql dump of 2.14 from postgres
 3. I stopped and undeployed 2.14 from TomCat Web Application Manager
 4. On a test server created my new dhis database from my 2.14 dump
 (process completed successful)
 5. Run the upgrade script *rename-patient-to-trackedentity.sql *got the
 following errors (dhis217.txt).
 6. Restarted tomcat and postgtes and can run dhis2 properly with user admin

 Issues:
 -My OU structure has disappeared from the front end
 -Users are not visible only default user is available.

 Tony, if you go to Profile-About DHIS 2, can you confirm that the
database running with DHIS 2 is actually the one you want it to be?
From your problem with missing orgunits and users it sounds like you are
running against a new blank database and that DHIS 2 didn't pick your
database at startup.

If the database is not as expected, then check your tomcat log at startup
to see whether the correct hibernate.properties file was found and used.

Ola
-



 From the backend i can still view the users table with all users from 2.14

 Kindly help

 --
 Tony Iha Kazungu
 ICT Practitioner
 Emails: tony...@gmail.com, m...@tonyiha.com
 Linkedin : ke.linkedin.com/in/tonyiha/
 Skpe: tkazungu


 ___
 Mailing list: https://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] Tracker - Identification number

[Ola Hodne Titlestad]

Hi Sumudu,

Thanks Emma for the response. Just to add a bit more detail on the
identifier issue.

There is no way at the moment to automatically generate IDs on the format
you suggest.
What is possible, as Emma writes, is to define what we call uniqueness
scope for attributes.

So in your case I would create an attribute Clinic Number (the last part
of your ID) with value type Number, then tick unique and select in
program within organisation unit.

This means that the users only deal with the Clinic Number, but in the
back-end the system makes sure that there are no duplicate Clinic Numbers
for any combination of program+organisation unit.

So when you search for Clinic Number you might get multiple hits/persons,
but not for the same organisation unit + program combination. You can then
narrow the search by searching in only one organisation unit and one
program, which will give you maximum 1 person for a full clinic number
search. A typical clinician at a local clinic will only have access to one
or a few programs and typically only one organisation unit, so the search
scope is by default same or similar to the uniqueness scope, which makes
it easier to quickly identify persons using the local Clinic Number (found
at the patient/mother/child card or similar).

We are planning to support period as part of this uniqueness scope as well,
but that is not supported yet in 2.15. That will allow you to support the
typical local practice of restarting the Clinic Number count in the paper
registers at the beginning of every year (or financial year), so that
duplicates will also be allowed for the same program+organisation unit as
long as they are in separate periods (e.g. years) of your selected period
type for uniqueness scope.

On tracked entity, if your programs are about persons then add a tracked
entity called Person and make sure to select that one when creating a new
program. That's all.

Ola
---


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 19 May 2014 09:11, Emma Kassy ekass...@gmail.com wrote:

 Hi Sumudu,

 For version 2.15,
 There is a person Identifier, Go to  Program  Attributes select
 Attributes;
 You can make an ID unique by checking UNIQUE which will give you options
 like unique with in 1.whole system, 2. org unit, 3. program, or 4. program
 and orgunit. This means that you get to enter the clinic number on
 registration. (At some point IDs were automatically generated am not sure
 if that is still the case may be some one can provide more Information on
 this). Also it will be possible to see the orgunit and period as an output
 such as on Search Results.

 Tracked Entity: Helps to define the different objects that you would like
 to track with in your system (no longer limited to persons). This can be
 Persons for TB, HIV and ANC programs or ITEMS if one is interested in
 tracking drugs or any other Logistic Items.

 I hope this helps


 On Sun, May 18, 2014 at 4:01 PM, sumudu weerasinghe 
 sumudu...@gmail.comwrote:

 Dear All,
 I want to create a psychiatric patient identification number as

- it should contain initial code indicating org unit , program, and
year
- number need to be generate by system without manual entering




1. Is it possible in DHIS2 2.15  tracker ?
2. Is there Person Identifier in New version 2.15?
3. What is mean by Tracked entity  in new version 2.15?

 Regards
 Sumudu

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




 --
 Thank you and Kind Regards
 *Immarcqulate. A (Emma Kassy) *

 *You miss 100% of the shots you don't take.*

 ___
 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] Tracker Aggregation for Enrolment

[Ola Hodne Titlestad]

Hi Busoye,

Thanks for reporting this in such detail.

Some comments in-line.

On 28 April 2014 11:58, bus...@hisp.org wrote:

 Hi,

 Not quite sure if this is a bug so I am testing out on this forum before
 reporting.

 We have configured a multiple event tracker database to register clients
 (pregnant women) through the web-api. There are two enrolments used as test
 data at the moment.

 The first set of aggregation queries should be fairly straightforward to
 count the number of enrolments (aggregate data elements have been created,
 included in data sets and assigned to orgunits).

 In the aggregate query builder, I have chosen Number of Tracked
 Entities, selected the program and used the program tab to define the
 condition. For program properties, I chose Program Enrollment and in the
 first instance the condition specified was only Program Enrollment. The
 manual aggregation returned no values.


That's actually the correct way to set up the aggregation query as far as I
know. I tried the same on another database and got the expected results. As
you say it could be something with the database. Maybe you could try the
same approach on another database to see whether it works there, e.g. give
it a try on the online demo. Was this database recently upgraded from
version 2.14, or has this been used with 2.15 or 2.15 snapshot since you
started on it? Something might have happened during the upgrade process
from 2.14 to 2.15.


 To explore another option, I tried Program Enrollment ='true' but still
 no results.

 To try a workaround, I used the attributes tab and selected one of the
 mandatory attributes with a condition of attribute_name is not null. Now
 I got some very interesting results: a value of 2 for every single month in
 the period specified! The value is correct but not for multiple periods; I
 had used April 2012 to April 2014. Will not rule out that this has
 something to do with our database setup. When you expand the aggregation
 period to reveal the values and organisation unit, click on the i symbol
 under Operator, you get an exception. In the log, the error message is:


So your aggregated data element is in a data set with a monthly period type?
I can see that your query (that failed) doesn't have any filters on period.
That might be the reason for getting the save value for all the periods.
So, that sounds like a bug.



 * ERROR 2014-04-28 10:02:56,281 Error while executing action
 (ExceptionInterceptor.java [http-apr-8080-exec-6])
 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
 SQL grammar [SELECT p.name FROM  programinstance as pi INNER JOIN
 trackedentityinstance p on 
 p.trackedentityinstanceid=pi.trackedentityinstanceid
 INNER JOIN organisationunit ou ON ou.organisationunitid=p.organisationunitid
  WHERE  EXISTS (   SELECT * FROM trackedentityattributevalue _pav  WHERE
 _pav.trackedentityinstanceid=pi.trackedentityinstanceid  AND
 _pav.trackedentityattributeid=8818 AND _pav.value  is not null ) ];
 nested exception is org.postgresql.util.PSQLException: ERROR: column
 p.name does not exist.


I also got this. There is a bug with the query here, as you can see column
p.name does not exist. If you want to explore the results now you can run
the sql query above directly on your database and just replace select
p.name with select p.* - that will give all the tracked entity instances
(persons in your case) that meets the aggregation criteria.

So you can use that query if you want to debug further what is happening
with your aggregation queries.

I'll do some more testing on my side as well, and I hope that the devs can
have a look at these bugs quickly.

Ola
--


Moving away from Program Attributes, I tried using the Visited selected
 program stage condition. When The Aggregator Operator is Number of
 Tracked Entity, which is the most appropriate in this case, I get the
 error above. However, when I change to number of visits, this works fine
 but the log shows information that there is a data type mismatch i.e. not
 integer or number. I changed the aggregate data element to text and the
 aggregation value I got was $value This one seems like a bug to me.
  actual aggregation


 Please find some screenshots attached to help illustrate the issues I have
 highlighted.


 Any help of input would be appreciated. I have given lots of detail here
 to cover a spectrum of issues, I don't mind providing more specific
 information into aspects that may help illuminate what the problems are.

 Best regards,

 Busoye



 Version:2.15
 Build revision:14960





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

Re: [Dhis2-users] I need help On setting up SMS on dhis

[Ola Hodne Titlestad]

Hi Anthony,

Good to hear that you have moved forward on this.

May I ask what version and build of DHIS 2 you are using (look it up in
Profile-About DHIS 2)?

Could you please also elaborate a little bit on what your problem is?
What steps have you taken, what errors or problems are you encountering?

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 3 April 2014 11:40, Anthony Danso adans...@gmail.com wrote:

 Please i have successfuly set up the SMS command but am having a probe
 loading the ams gateway?
 On Apr 1, 2014, at 2:30 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrot

 Ok, I assume these are aggregated values, as in number of cases of XXX?

 If so, I suggest you start by reading section 25.4 in the user
 documentation :

 http://www.dhis2.org/doc/snapshot/en/user/html/ch24s05.html

 And come back to this list if you have any questions.

 Ola
 --
 1. apr. 2014 16:26 skrev Anthony Danso adans...@gmail.com følgende:

 We want to use SMS for reporting of some cases in very remote areas in
 the countrt.So in other words users will only report through SMS into
 Dhis2,the cases of some diseases that  were detected in their facilities.
 On Apr 1, 2014, at 2:12 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote:

 Hi Anthony,

 Can you please elaborate a little on what aspects of SMS you want to make
 use of?

 SMS is used for many things in DHIS 2, e.g. for data entry as well as
 many different types of notifications and other outgoing messages.

 What do you want to achieve with SMS?

 Ola
 --
 1. apr. 2014 15:34 skrev Anthony Danso anthonydans...@yahoo.com
 følgende:

 Please can someone help me set up SMS in DHIS2.

 ___
 Mailing list: https://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] I need help On setting up SMS on dhis

[Ola Hodne Titlestad]

Hi Anthony,

Can you please elaborate a little on what aspects of SMS you want to make
use of?

SMS is used for many things in DHIS 2, e.g. for data entry as well as many
different types of notifications and other outgoing messages.

What do you want to achieve with SMS?

Ola
--
1. apr. 2014 15:34 skrev Anthony Danso anthonydans...@yahoo.com
følgende:

 Please can someone help me set up SMS in DHIS2.

 ___
 Mailing list: https://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] I need help On setting up SMS on dhis

[Ola Hodne Titlestad]

Ok, I assume these are aggregated values, as in number of cases of XXX?

If so, I suggest you start by reading section 25.4 in the user
documentation :

http://www.dhis2.org/doc/snapshot/en/user/html/ch24s05.html

And come back to this list if you have any questions.

Ola
--
1. apr. 2014 16:26 skrev Anthony Danso adans...@gmail.com følgende:

 We want to use SMS for reporting of some cases in very remote areas in the
 countrt.So in other words users will only report through SMS into Dhis2,the
 cases of some diseases that  were detected in their facilities.
 On Apr 1, 2014, at 2:12 PM, Ola Hodne Titlestad ol...@ifi.uio.no wrote:

 Hi Anthony,

 Can you please elaborate a little on what aspects of SMS you want to make
 use of?

 SMS is used for many things in DHIS 2, e.g. for data entry as well as many
 different types of notifications and other outgoing messages.

 What do you want to achieve with SMS?

 Ola
 --
 1. apr. 2014 15:34 skrev Anthony Danso anthonydans...@yahoo.com
 følgende:

 Please can someone help me set up SMS in DHIS2.

 ___
 Mailing list: https://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] Indicator

[Ola Hodne Titlestad]

Hi Randy,

To me this sounds like the new surveillance type of validation rules is a
better match.

Have you looked at that?

We would then somehow need to expose those formula values in the Web API
somehow, so that they can be used in reports etc.

Ola
--
31. mars 2014 09:01 skrev Wilson,Randy rwil...@msh.org følgende:

  Actually we need to create an indicator that sums the data over the last
 3 months and divides by 3 – e.g. average monthly consumption for the past 3
 months.



 Similarly we will need a function to average the number of cases of
 epidemic prone disease over the past 6 months and then check to see of the
 current months cases are  2 Standard Deviations from the average.



 I’m not sure if that is how the D function in the indicator definition
 screen does this.



 Randy



 *From:* Dhis2-users [mailto:dhis2-users-bounces+rwilson=
 msh@lists.launchpad.net] *On Behalf Of *Kenneth Børtveit
 *Sent:* Monday, March 31, 2014 8:44 AM
 *To:* Jason Pickering
 *Cc:* dhis2-users@lists.launchpad.net
 *Subject:* Re: [Dhis2-users] Indicator



 Alright, thank you. It solves the problem in a way.



 I was looking for a way to define the indicator so that 'D' would allways
 be the last 3 months, is that possible?



 2014-03-31 8:20 GMT+02:00 Jason Pickering jason.p.picker...@gmail.com:

 You can use the special paramater D which will give you the number of
 days in the period in question. Is this what you want to achieve?


 Regards,

 Jason





 On Mon, Mar 31, 2014 at 8:13 AM, Kenneth Børtveit 
 kenneth.bortv...@gmail.com wrote:

   Hi!



 I am trying to make an indicator that aggregates a dataelement over a
 month and divides it by the number of days in the last 3 months.



 Does anybody have any advice?



 Best regards,

 Kenneth Børtveit



 ___
 Mailing list: https://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] myDataMart

[Ola Hodne Titlestad]

Hi,

Just to add to what Bob writes:

To get an ad-hoc pivot table in Excel for offline data analysis you can
do the following:

1. You go to Services-Pivot Table and select the data you need.
2. When you are happy with the table you go to Download and select Plain
data source-Microsoft Excel.

That will give you an excel file that can easily be converted into a pivot
table using the Pivot Table Wizard in Excel.

3. In Excel 2007 you click on Insert-Pivot Table, let Excel auto-select
all the data and then click OK.
Make sure to drop the value field in the Values/Data area, and then the
other fields (dimensions) on either row, column, or filter areas.

Note that this works fine for one-off pivot tables, but is not a solution
where you can update existing pivot tables in Excel against a DHIS 2 data
source.

Ola
-

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 20 March 2014 10:42, Bob Jolliffe bobjolli...@gmail.com wrote:

 Hi Channara

 Mydatamart is not being actively maintained currently and I don't think
 has been tested against current dhis2 version.  The current recommended way
 of getting data out of dhis2 is via the web based analytics api.

 Regards
 Bob


 On 19 March 2014 09:29, channara rin rin.chann...@gmail.com wrote:

 Dear All users,
 By the way, do you know myDataMart is still working or not?
 Because i tried many time through DHIS2 documentation guide. do step by
 step how to use myDataMart. but i got blank database connection in excel..



 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] List of Health Facilities disaggregated by States in Nigeria

[Ola Hodne Titlestad]

To add to that, on the front page of https://dhis2nigeria.org.ng/ there is
contact information for support.

Ola


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 19 March 2014 20:03, Ola Hodne Titlestad ol...@ifi.uio.no wrote:

 Hi,

 This is not a support list for the Nigerian DHIS 2 instance.

 I suggest you contact FMOH in Nigeria.

 Ola
 ---


 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps 
 linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


 On 19 March 2014 12:50, MUKTAR GADANYA gada...@gmail.com wrote:

 Dear colleagues,

 I am conducting a research that needs sampling of some healthcare
 facilities across the whole country. This list used to be available on
 www.DHIS2nigeria.org.ng (from which I have earlier multiply downloaded
 the list), but now seems to be corrupted and no longer accessible in the
 past several hours. I get the report below from the website whenever I try
 to download the list:


 *type* Exception report

 *message* *Request processing failed; nested exception is
 java.lang.NullPointerException*

 *description* *The server encountered an internal error that prevented
 it from fulfilling this request.*


 Can someone kindly help me with this list?

 best regards,

 Muktar


 ___
 Mailing list: https://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] List of Health Facilities disaggregated by States in Nigeria

[Ola Hodne Titlestad]

Hi,

This is not a support list for the Nigerian DHIS 2 instance.

I suggest you contact FMOH in Nigeria.

Ola
---


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 19 March 2014 12:50, MUKTAR GADANYA gada...@gmail.com wrote:

 Dear colleagues,

 I am conducting a research that needs sampling of some healthcare
 facilities across the whole country. This list used to be available on
 www.DHIS2nigeria.org.ng (from which I have earlier multiply downloaded
 the list), but now seems to be corrupted and no longer accessible in the
 past several hours. I get the report below from the website whenever I try
 to download the list:


 *type* Exception report

 *message* *Request processing failed; nested exception is
 java.lang.NullPointerException*

 *description* *The server encountered an internal error that prevented it
 from fulfilling this request.*


 Can someone kindly help me with this list?

 best regards,

 Muktar


 ___
 Mailing list: https://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] Can't add organisation unit levels in 2.14 build 13820

[Ola Hodne Titlestad]

Hi Randy,

The levels are created based on the orgunit hierarchy in the database,and
not the other way around.

So if you first create some orgunits in a hierarchy and then revisit that
page, you will see the levels listed.

The orgunit levels page is mainly to provide labels to the levels, and not
to create levels for the orgunit hierachy.

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 18 March 2014 19:22, Wilson,Randy rwil...@msh.org wrote:

  I think other have seen this issue.  I’m setting up a new database and
 the option to Add New is missing from the Organisation Unit levels screen.
 I downloaded the latest stable build tonight.







 Any suggestions?



 *Randy Wilson*



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


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

Re: [Dhis2-users] How to calculate Potential Number of hospitalization days(Beds x days in month)

[Ola Hodne Titlestad]

Hi Andrew,

The D (days) is a special parameter that will always be the number of days
in the period you are calculating the indicator value for.

It is meant for exactly the kind of use case you describe, e.g. available
bed days to be used as denominator in bed occupancy rate.

Ola
--
25. jan. 2014 10:33 skrev Muhire Andrew muhireand...@yahoo.com følgende:

 Hi all,
 anyone with the best way of calculating this indicator Potential Number
 of hospitalization days(Beds x days in month)
  Here the months are dynamic based on the normal reporting months(28/29
 days, 30days,31days). We have been using the average of 30dyas but we want
 to use real numbers of days. But in dhis2 indicator module, there is an
 icon(D) which is number of days. can this help?

 Any idea?



 --
 Better Information, better Decisions, better Health


 * Muhire Andrew*
 * Ministry of Health / HMIS*
 *A mind is a terrible thing to waste*

 ***

  ** Cell:(+25)0788436150**
 *** Twitter :andrewmuhire***
  skype:muhire_andrew
 *muhireand...@yahoo.com muhireand...@yahoo.com*

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-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] Homologous periods for indicators

[Ola Hodne Titlestad]

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 knu...@gmail.com 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 pgra...@criticalsoftware.com
 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 *%20your-email%20*



 ___
 Mailing list: https://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] Fwd: blank page

[Ola Hodne Titlestad]

Thobias,

You need to look in the tomcat log to see what went wrong at startup.

Ola
--
On 1 Nov 2013 09:55, Knut Staring knu...@gmail.com wrote:



 -- Forwarded message --
 From: Knut Staring knu...@gmail.com
 Date: Fri, Nov 1, 2013 at 9:53 AM
 Subject: Re: [Dhis2-users] blank page
 To: Joseph Thobias jthobi...@gmail.com


 Hi,

 Are you trying to go directly from 2.10 to 2.13? I doubt that will work.
 Try 2.11 first, then 2.12.

 Knut


 On Fri, Nov 1, 2013 at 9:52 AM, Joseph Thobias jthobi...@gmail.comwrote:

  Hi,
 Iam trying to upgrade my system from DHIS 2.10 to 2.13 but when I browse
 the home page I get  a blank page.
 Please help me to resolve this.See the attached sreen shot

 --
 JOSEPH THOBIAS
 P.O.BOX 490,
 DODOMA.
 *Phone*:+255 713951382
 *email:* jthobi...@gmail.com
 *website:* www.udom.ac.tz

 ___
 Mailing list: https://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
 +4791880522
 http://dhis2.org



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

Re: [Dhis2-users] How to structure information?

[Ola Hodne Titlestad]

Hi,

Agree with Lars. I would use orgunits to represent the departments/wards as
it gives you more flexibility. It will require more customisation time to
get all the orgunit names right in each hospital, but it is worth it, at
least if you want to support data analysis and mangement at each hospital.

Sometimes the hospital prefers to use local names on wards, like Cot ward
A. Cot ward B, up/down etc and also have more than one physical ward/room
for the same type/category.  A standard naming scheme through data element
categories would be difficult to use in this case.

Typically a hospital would like to do analysis by each physical ward (bed
occupancy rates etc) and not always group them together by type of ward.

You can use orgunit groups to apply standard hospital departement names to
all those wards,  which can then be used for aggregation when doing
analysis above the hospital level or when comparing hospitals.

Ola
--
On 31 Oct 2013 09:32, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi Marta,

 I don't know enough about the use-case to be sure. However my suggestion
 would be to use the organisation units to represent the departments. It is
 simply because usually the departments are different across hospitals -
 some are not always there, some are combined and so on. So you could make a
 script that creates the initial setup with all departments in all places
 and then modify it from there. It makes form design easier. The data mart
 performance penalty mentioned above applied at the time of writing but not
 anymore with the analytics engine. A problem with using categories is that
 you get lots of non-applicable fields if you use section forms, and lots of
 maintenance mess if you go with custom forms.

 cheers

 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

Re: [Dhis2-users] Important Bugs in Individual records.

[Ola Hodne Titlestad]

On 25 September 2013 22:35, helder yesid castrillon cobo 
helder_...@hotmail.com wrote:

 Hi again,

 I did all test in my PC, Server and  the demo of sierra leona, also I used
 firefox, Internet explorer and chrome(incognito mode) and cleaned the
 cache, temporal files Etc. finally I found these.

 1) We are using a css style to improve the textBox and this is causing  el
 bug. Then, How can i using a css file?.


OK. Good to know that the standard data entry is OK at least. I'll let
others contribute here on how to put you own css in the data entry form.



 2) this is definitely  a bug, I tested in  the demo of sierra leona and it
 didn´t  work .

 This bug is not on the latest version of 2.12 (http://apps.dhis2.org/demo
).

I have tested this now and cannot reproduce this. Please provide a step by
step explanation that I can follow to reproduce this bug on
http://apps.dhis2.org/demo/

- I can see all, complete, incomplete etc in the visit schedule and when I
make changes to those stages in dashboard I can get updated lists in Visit
Schedule.
All seem to work as expected.



 3) similarly like the previous, I tested in  the demo of sierra leona and
 it didn´t  work.

 4) I hope a new revision.

 Again , please write down the steps (no video needed) I need to follow to
reproduce this on http://apps.dhis2.org/demo/
Also indicate which user you are using.


 5) we don't have any attribute/identifiers selected in the program,  I
 attached a print screen.

OK, must be something else causing this then.
Are you able to reproduce this on  http://apps.dhis2.org/demo/  ?

Ola
-




 thanks Ola.




 *MG. Helder Yesid Castrillon.*
 Secretaría departamental de salud del Cauca (Colombia)
 @heldersoft


 --
 Date: Wed, 25 Sep 2013 16:18:08 +0200
 Subject: RE: [Dhis2-users] Important Bugs in Individual records.

 From: ol...@ifi.uio.no
 To: helder_...@hotmail.com
 CC: dhis2-users@lists.launchpad.net

 Hi Helder,

 On 25 Sep 2013 03:37, helder yesid castrillon cobo 
 helder_...@hotmail.com wrote:
 
  Thanks,
 
  I created a  video with the bugs  http://youtu.be/sEDMuWh6O6I .
 
  the video last 12 minutes and you can find the bugs exactly the minutes
 described below.
 
  1)  When DHIS is accessed for first time to an individual form
 (program), this doesn't change the textbox to green and doesn't save the
 information. On the second attempt works well. (1:22, 6:16 and 7:57 minutes)
 
 Devs will get back to you on this one. Just a quick question,  do you get
 the same issue when you use a local instance on your laptop?

 Anything interesting in the browser console that you could share with us?
   2) in Visit Schedule option doesn't show the people or visits in
 status 'completed' and the same when is chosen in status to 'all'. (9:33
 and  12:35 minutes)
 
 I'll need to do more testing on this one.

  3) When are posted comments with more than 255 characters this allow add
 them and view them without problem, but not save .
 
 Sounds like a bug we need to fix.

  4) I don´t know why sometime after that register a person in some
 program, this doesn't display the tab 'Data entry screen'. to see the image
 attached.
 
 This is most likely related to access. Are you sure the selected orgunit
 has been assigned to the program?

 If not, make sure to clear the browser cache and try again. If you have
 logged on to the system with multiple users with different user roles you
 might have confused the browser.

  5) On the 'full name' column of the person list displays the person
 document. (5:46 minute)
 
 If you look at the selected attribute/identifiers list in the add/edit
 page for your program there is a column for Display is list. If this is
 ticked for your identifier (person document number) it will replace the
 full name in the person list.

 We will introduce a more flexible configuratiln for this in 2.13.

 
  All this behavior is confusing to the end user.
 
 
 
 
 
  MG. Helder Yesid Castrillon.
  Secretaría departamental de salud del Cauca (Colombia)
  @heldersoft
 
 
  
  Date: Tue, 24 Sep 2013 21:34:09 +0200
  Subject: Re: [Dhis2-users] Important Bugs in Individual records.
  From: ol...@ifi.uio.no
  To: helder_...@hotmail.com
  CC: dhis2-users@lists.launchpad.net
 
 
  Hi Helder,
 
  Sorry for the late response from our side. Please could you support your
 bug reports with some step by step explanations on what you are doing to
 reproduce these problems, and also attach some screenshots to explain (at
 least for 1, 3, and 5). Then I will try to go through all these tomorrow
 and test on my side.
 
  And as always, if you have time, we would appreciate if you could use
 our bug report process at launchpad.
 
  Thanks.
 
  Ola
  ---
 
 
  --
  Ola Hodne Titlestad (Mr)
  HISP
  Department of Informatics
  University of Oslo
 
  Mobile: +47 48069736
  Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps

Re: [Dhis2-users] Important Bugs in Individual records.

[Ola Hodne Titlestad]

Hi Helder,

Sorry for the late response from our side. Please could you support your
bug reports with some step by step explanations on what you are doing to
reproduce these problems, and also attach some screenshots to explain (at
least for 1, 3, and 5). Then I will try to go through all these tomorrow
and test on my side.

And as always, if you have time, we would appreciate if you could use our
bug report process at launchpad.

Thanks.

Ola
---


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 24 September 2013 17:07, helder yesid castrillon cobo 
helder_...@hotmail.com wrote:

 Hi,

 Since the last week I reported in Dhis2-users about some problems that it
 has been happening with individual records in version 2.12, revision 11296
 /11306  (tested in Firefox, chrome and internet explorer). But like I
 have not received response then I am reporting the bugs again.

 1) When DHIS is accessed for first time to an individual form (program),
 this doesn't change the textbox to green and doesn't save the information.
 On the second attempt works well.

 2) in Visit Schedule option doesn't show the people or visits in status
 'completed' and the same when is chosen in status to 'all'.

 3) When are posted comments with more than 255 characters this allow add
 them and view them without problem, but not save .

 4) I don´t know why sometime after that register a person in some program,
 this doesn't display the tab 'Data entry screen'.

 5) On the 'full name' column of the person list displays the person
 document.



 Appreciate your cooperation as some people have not been Able to Work with
 DHIS here in the Departmental Health Secretariat of Cauca (Colombia).

 *MG. Helder Yesid Castrillon.*
 Secretaría departamental de salud del Cauca (Colombia)
 @heldersoft

 ___
 Mailing list: https://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] option set doesn't work in individual records

[Ola Hodne Titlestad]

Hi Venuste,

Which version/build of DHIS 2 are you using?

If you are using the individual records (Tracker), make sure your data
elements have:
Domain Type = Patient and
Combination of categories = default.

If you want a drop-down with options then also make sure:
Value Type = Text,
Option set = your selected option set (not Please Select).

Also make sure you clear your browser cache completely before trying again.

Does that help?

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 13 September 2013 09:15, nsanzumuhire venuste vensa...@yahoo.fr wrote:


 Dear all,
 I have created data elements and of cause i linked some of them to the
 categories,just using OPION SET.then when i got through individual
 records,i don't see  the combo box on the form,just data element with
 categories.i am also using Multiple event with registration in the
 program.any one can help?
 Venuste.
 R_HMIS
   --
  *De :* Gerald Thomas gerald...@hotmail.com
 *À :* Knut Staring knu...@gmail.com
 *Cc :* dhis2-users@lists.launchpad.net dhis2-users@lists.launchpad.net

 *Envoyé le :* Vendredi 13 septembre 2013 7h26
 *Objet :* Re: [Dhis2-users] How to Link Tomcat 7 and Postgresql 9.2

 Knut,
 I really don’t know where to put this export statement; because I already
 tried it on the ~/.bashrc file but it is not work. I tried it on the
 /etc/environment; it is not working. I am not start Tomcat using
 bin/startup.sh because I already enable it to run automatically.

 Please find the attached view screen of my dhis screen.

 Sent from Windows Mail

 *From:* Knut Staring
 *Sent:* ‎Friday‎, ‎September‎ ‎13‎, ‎2013 ‎6‎:‎20‎ ‎AM
 *To:* Gerald Thomas
 *Cc:* dhis2-users@lists.launchpad.net

 Also, where did you put the export statement? Are you starting using
 Tomcat's  bin/startup.sh ? Is that where you included the statement below?

 export DHIS2_HOME=/home/DHIS2_HOME/dhis


 On Fri, Sep 13, 2013 at 7:16 AM, Knut Staring knu...@gmail.com wrote:

 This file looks good, and seems to be in the place you are pointing to.

 Please also share the content of the About DHIS2 page.


 On Fri, Sep 13, 2013 at 7:09 AM, Gerald Thomas gerald...@hotmail.comwrote:

  Dear Knut,
 Yes I am talking about Ubuntu installation. My windows installation is
 working ok.
 Please find the attached file as per request

 Sent from Windows Mail

 *From:* Knut Staring
 *Sent:* ‎Friday‎, ‎September‎ ‎13‎, ‎2013 ‎6‎:‎06‎ ‎AM
 *To:* Gerald Thomas
 *Cc:* dhis2-users@lists.launchpad.net

 Hi Gerald, I assume you are talking about and Ubuntu installation even
 though you send from Windows Mail?

 In your /home/DHIS2_HOME/dhis folder, do you have a file called
 hibernate.properties? Can you share the contents of that file with us?

 Inside DHIS2, please go to Help - About DHIS2 and copy the content here.

 Knut






 On Fri, Sep 13, 2013 at 6:44 AM, Gerald Thomas gerald...@hotmail.comwrote:

   Dear Support,
 I already completed the installation but i can't get access to the
 database that i had imported. During my research i have seeing a lot of
 procedures to do it but they seem not to be working. Please can you help
 me with a reliable solution. If possible can you send a your messenger
 ID (Skype or gtalk) so that we can do the process together. Thanks in
 advance for your help.

 Kindly note that I am not having any errors but I can only login to the
 dhis using the default username/password (admin/district). This simply
 means the database that I had imported is not seeing the tomcat.
 Most of the journals said this is my problem “export
 DHIS2_HOME='/home/dhis/config”

 On my configuration DHIS2_HOME directory is found inside the home folder
 of the root; therefore my “export DHIS2_HOME=/home/DHIS2_HOME/dhis
 Please I don’t know if this is were I am getting it all wrong. Please help
 Sent from Windows Mail


 ___
 Mailing list: https://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
 +4791880522
 http://dhis2.org




 --
 Knut Staring
 Dept. of Informatics, University of Oslo
 +4791880522
 http://dhis2.org




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

Re: [Dhis2-users] How to delete the fixed attributes in individual records model

[Ola Hodne Titlestad]

Hi Venuste,

As Lars wrote we are working on simplifying the process to customise
registration/enrolment forms.
In the current trunk (2.13 snapshot) you can already create custom
registration forms where you decide what to include, but we will try to
simplify the way this is done before the 2.13 release.

If you want to test this right now you can give it a try on our demo server
for the trunk version:
http://apps.dhis2.org/dev (it is rebooted on every change so not always up)

or download the latest .war file here and try it out locally:
http://apps.dhis2.org/ci/job/dhis-web-trunk/

In Maintenance-Persons and Programs there is a menu item called Person
Registration form.
Look for your program and click on the Design Data Entry form operation on
the right hand side (second icon).
In the designer you can use exactly the attributes and identifiers you need.
You can also specify that you want to assign a default value to an
attribute and then hide it from the form.
E.g. you may want to set gender=female for an ANC program, but not want the
user to have to type this in on every registration.

For the 2.13 release we will make the hide and default value options
available also to default registration forms, so that you don't have to
work with the html designer to achieve this.

The blueprint describing what we want to do is here:
https://blueprints.launchpad.net/dhis2/+spec/tracker-default-reg-form-configuration

Ola
--

On 13 September 2013 11:42, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi Venuste,

 thanks for reporting. Yes we are aware of this problem, and we are working
 on a function for hiding/displaying fixed attributes in person registration
 form. Hopefully we will get it in for version 2.13.

 regards,

 Lars



 On Wed, Sep 11, 2013 at 11:29 AM, nsanzumuhire venuste 
 vensa...@yahoo.frwrote:

 Dear all,
 we are  creating attributes in the  individual records module,but we
 don't  want to have those fixed attribute in the individual records
 model.we need help  how to remove those Fixed attributes in the form? like
 Full Name,Gender,date of birth,mobile phone number,health staff
 Tks
 Venuste
 Rwanda Health Management Information system specialist.


___
Mailing list: https://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 all districts in orgunit hierarchy in pivot table module

[Ola Hodne Titlestad]

Hi Randy,

There are actually quite a few use cases for aggregation along data element
groups.
But this of course depends on how you design data elements, categories, and
groups, especially how much you have used categories.
Sometimes there are dimensions to the data elements that you want to add
after data entry (shared characteristics across certain data elements) and
then groups can be very useful for doing aggregations along these.

Here's an example of how you can use data element groups for aggregation:

http://tracker.dhis2.org/dhis-web-pivot/app/index.html?id=WCO0fV45zdv
(same login as with the online demo) - you'll see that the Data dimension
is not used at all in this pivot table, but instead data is aggregated and
visualised by groups.

I also find it useful to have groups in pivot tables for ordering purpose,
to e.g. list all Child Health data element on rows, but sorted by their
groups (sub-programs like Immunisation and Nutrition), like this example:
http://tracker.dhis2.org/dhis-web-pivot/app/index.html?id=SflhID5ZObb
(If you open Options you'll notice that I have used the option hide empty
rows).

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 29 August 2013 12:00, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi Randy,


 On Thu, Aug 29, 2013 at 9:03 AM, Wilson,Randy rwil...@msh.org wrote:

  I think I may have seen something related to this before but can’t seem
 to get it to work.  When I want to select all of the districts from the
 orgunit hierarchy for a pivot table, I can select any that are visible, but
 the remaining districts in Western province are not visible (off the
 screen).  I cannot scroll below Muhanga District.  I have tried zooming out
 the page, but nothing seems to work.  Has this been fixed in a newer
 release of 2.12?

 ** **

 

 **


 I have actually seen this a few times on Windows - never on Mac or Linux.
 I suspect it is a bug with the javascript library we using (Ext JS) but we
 will try to look into it more closely and see what we can do.



 **

 While I’m at it, why do the data element group sets appear in the list of
 dimensions in the pivot table dialog?  It makes sense to have orgunit group
 sets like “admin unit type”, “ownership”, but the “Malaria_all” data
 element group set and the “thematic area” data element group set?  I can’t
 see any use case for making them dimensions in the pivot table.  

 ** **

 

 **


 As you know, categories, org unit group sets and data element group sets
 can be used as dynamic data dimensions in DHIS. For the categories you can
 select explicitly which ones should appear as data dimensions (in pivot,
 visualizer etc). We figured that most group sets would make sense as data
 dimensions - but that assumption might be wrong and we could easily add an
 option for picking which group sets should appear as dimensions. Let us
 know.

 I am not sure how your Malaria all group set is defined, but ideally a
 group set should be suitable as data dimension - for instance it could give
 you the totals of groups of malaria-related data elements.

 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


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

Re: [Dhis2-users] How to Track a Patient across multiple org units for the same program

[Ola Hodne Titlestad]

Hi Busoye,

If provided the authority to do so the user at the second facility can
search and find the person and open the person dashboard. There the user
can continue endring data for new stages in the same enrollment or enroll
into the program again (if the previous enrolment was completed).

By authority I refer to the authorities you can assign to user roles in
DHIS 2. On the phone now and can't look up the exact name of this
authority,  but think it's called something like 'Search Persons in all
facilities'.

There is also a 'Search Person in User facilities' that limit the search to
the subtree of the orgunit hierarchy the user can see (has been assigned),
if e.g the user is located at a district office supporting multiple
facilities or I guess at a hospital supporting multiple words.

Being able to track individuals over time AND across facilities (orgunits)
is supported and one of the key use cases for Tracker.

Ola
--
On 28 Aug 2013 09:51, Adebusoye Anifalaje bus...@hisp.org wrote:

 Hi all,

 Not sure how the patient tracker handles patient registration in a program
 that cuts across multiple orgunits. This is a scenario:

 - Patient is admitted into a ward (e.g medical).

  a) This is where the patient details are registered and enrolled into the
 midnight census program
 -Admissions is the first stage of the program

  b)  Patient stays x number of nights in this ward

  c) Patient is then separated e.g. transferred internally…
 - Separation is the second event (program stage)
 - Inpatient days can be calculated by ward

 - If patient is transferred to another speciality within the same ward the
 event is just repeated i.e. admissions and separation…

 - However, if the transfer is to a different ward, we have to choose a
 different org unit. At this stage, the patient is already registered so we
 don't want to have to register the patient again. We would want to

 a) Choose new org unit
 b) Find patient details
 b) Enrol into the same program

 - Maybe I just don't understand the patient module enough but at the
 moment it seems like you can't *track the same patient across multiple
 orgunits for the same program*…


 Would appreciate if anyone can throw some light on how to do this.


 Kind regards,

 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] Limit patient lookup

[Ola Hodne Titlestad]

Hi Juan,

You are correct in that the Search in all Facilities option in FInd/Add
Person searches for persons in all orgunits of the database.
The default search is to search for Persons in the selected (in the left
side orgunit menu) orgunit, which can be done with one orgunit at a time
only.

So far this has been designed to support users that work at a facility and
typically only have their own facility in the orgunit tree.
The search in all is an option to be able to look up persons outside the
facility from any part of the country, in case of migration etc.

The workflow you describe seems different in that you would have DHIS users
at higher levels (e.f. a district or province office) doing
backlog/non-real time data entry for multiple facilities based on
submitted paper reports/forms, but within a limited area of the
country/region/organisation (a subset of the full DHIS orgunit hierarchy).

For this use case we would have to add a new option in the Advanced Search
feature called something like Search in all visible orgunits or Search
in user's orgunits.
This would have to be supported by a new authority (for user roles) that
allows the user to do this kind of search.

See attached screenshot for what I mean.

Would that work for your use case Juan?

Ola





--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 8 August 2013 21:42, Juan M Alcántara Acosta
jmalcant...@apunto.com.mxwrote:

 Hello everyone
 I have users of tracker that need to be able to search clients in all
 facilities, this happens because persons are registered at an
 organizational unit level 3 -state/department- (and this is just an
 example) with a first contact program that provides a referral to a medical
 service, then when the person gets the service we do the enrollment to a
 clinical program at an organizational unit level 5 -medical
 facility/provider-
 Users are just allowed to work and see one of several level 1
 organizational units, but when they do a search that includes all
 facilities, the result includes clients from ALL Organizational Units.
 Is there a way to limit the scope of the search to include only persons
 registered in organizational units the user is allowed to see?
 Best regards,
 JM
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp

attachment: User_facility_search_person.png___
Mailing list: https://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 an Orgunit Lookup in Patient Module

[Ola Hodne Titlestad]

Hi Busoye,

We don't support that kind of patient attributes linked directly to the
orgunit hierrachy.
You can set up an attribute with Value Type = Predefined Value with a flat
list of options, which in theory you can populate with a list of all
sub-districts (e.g. copy from orgunit hierrachy using sql)... But you won't
get the dynamic linking to the orgunit hierarchy that you seem to be asking
for.

The only way to link the person to an orgunit is via the actual
events/visits of a patient, through the orgunit providing the service.
That orgunit, e.g. a health facility, will be linked to a sub-district
through the hierarchy, or could be member of an orgunit group that
specifies the location.
You can also specify coordinates for each event if you need to track event
locations that are outside the orgunit hierarchy.

But if you want to capture a static location for a patient that is
independent of the location of the events/visits, we don't have a way to
link that to the orgunit hierarchy.

Ola
--



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 7 August 2013 13:27, Adebusoye Anifalaje bus...@hisp.org wrote:

 Hi all,

 Is it possible to create an org unit lookup field in the patient tracker
 module? For instance we want to be able to link a Patient_Attribute,
 Sub_District (Address), to the orgunit hierarchy rather than a free text.
 Can anyone help?

 Regards,

 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] Any suggestions for partner reporting in DHIS-2?

[Ola Hodne Titlestad]

Hi Randy,

In the Pivot Tables your categories will appear as dimensions in the left
side menu, given that the category has the option Use as data dimension
enabled (and you run analytics again after enabling that option). This
gives you a lot of flexibility in terms of how you want to aggregate and
display your data.

You could e.g. put the Partner category in the filter position of your
table (in Layout). Then select one or more partners in the left side menu
for the Partners category (dimension), e.g.FHI.

You could put your second category with the target groups reached
(fishermen etc.) (not sure what you call that category) on the column
position and select all its options.
If you then select all the data elements you need and put the Data
dimension on rows, then the table should look like the one in your email.

Let me know if that works.

Ola
--


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 30 July 2013 09:50, Wilson,Randy rwil...@msh.org wrote:

  Hi Lars,

 ** **

 We’ve completed this exercise of moving this system back to the aggregate
 data entry system thanks to your advice, but have come across an issue on
 the output side:

 ** **

 Dataset: FHI

 District: Bugasera

 ** **

 *Type of MARPs*

 *FSW*

 *MSM*

 *TD*

 *Fishermen*

 *PwD*

 1. People reached by peer educators

 ** **

 ** **

 ** **

 ** **

 ** **

 2. Contacts with people where interpersonal communication was provided

 ** **

 ** **

 ** **

 ** **

 ** **

 3. People who received condoms

 ** **

 ** **

 ** **

 ** **

 ** **

 ** **

 Columns are actually category option combos: (FSW ,FHI), (MSM, FHI), (TD,
 FHI), (Fishermen,FHI),(PwD,FHI))

 ** **

 In version 2.12 we now can select details to display category option
 combos (for example (FSW,FHI); (fishermen,FHI)) in the data visualizer, but
 it doesn’t work in the pivot table module yet L and there doesn’t appear
 to be a way to break out an individual category (eg. All Fishermen or all
 FSW, regardless of partner).  I’ve had to create a custom query that parses
 out the two halves of the category combination field that we can then use
 for Excel Pivot table analysis.

 ** **

 SELECT 

   _categoryoptioncomboname.categoryoptioncomboname, 

 àdon’t parse out default category options, but for others make string
 upto comma beneficiary

 case when  _categoryoptioncomboname.categoryoptioncomboname  '(default)'
 then

 substring(_categoryoptioncomboname.categoryoptioncomboname
 from 2 for (position(',' in
 _categoryoptioncomboname.categoryoptioncomboname)-2)) 

 else

 _categoryoptioncomboname.categoryoptioncomboname 

 end as beneficiary,

 àdon’t parse out default category options, but for others make string
 after comma partner

 case when  _categoryoptioncomboname.categoryoptioncomboname  '(default)'
 then


 substring(trim(_categoryoptioncomboname.categoryoptioncomboname) from
 position(',' in _categoryoptioncomboname.categoryoptioncomboname)+2 for **
 **

 position(')' in
 _categoryoptioncomboname.categoryoptioncomboname)-position(',' in
 _categoryoptioncomboname.categoryoptioncomboname)-2) 

 else

 _categoryoptioncomboname.categoryoptioncomboname 

 end as partner,

   dataelement.name as dataelementname,

   aggregateddatavalue.organisationunitid, 

   organisationunit.name as orgunitname, 

   period.startdate, 

   aggregateddatavalue.level, 

   aggregateddatavalue.periodtypeid, 

   aggregateddatavalue.value

 FROM 

   public.dataelement, 

   public.aggregateddatavalue, 

   public.period, 

   public.organisationunit, 

   public._categoryoptioncomboname

 WHERE 

   aggregateddatavalue.dataelementid = dataelement.dataelementid AND

   aggregateddatavalue.categoryoptioncomboid =
 _categoryoptioncomboname.categoryoptioncomboid AND

   aggregateddatavalue.organisationunitid =
 organisationunit.organisationunitid AND

   aggregateddatavalue.periodid = period.periodid

   and   aggregateddatavalue.level = 3 

   and aggregateddatavalue.periodtypeid= 4

   and aggregateddatavalue.dataelementid in

   (SELECT 

   dataelementid 

 FROM 

   public._dataelementgroupsetstructure where thematic_area='MARPS');

   ALTER TABLE _view_healthfacilityhierarchy OWNER TO dhis;

 ** **

 ** **

 Do you have any other suggestions?

 ** **

 Randy

Re: [Dhis2-users] Still having problems getting started

[Ola Hodne Titlestad]

Hi Roger,

The tomcat log will also tell you which hibernate.properties files are
found and used at startup.

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


On 25 June 2013 13:46, Friedman, Roger (CDC/CGH/DGHA) (CTR)
r...@cdc.gov wrote:
 When I start DHIS2 from Tomcat, I get the H2 DB rather than the DB in my
 hibernate.properties file.  There are no messages.  The help about shows my
 java opts at Xmx2048m and Xms512m and DHIS2_HOME as my environment variable.
 DHIS2 _HOME is set at the same point as my VM options and points to the
 directory with my hibernate.properties file.  Help about shows external
 configuration directory as not set.  Version is 2.12.11183 2013-06-18.  Any
 suggestions?


 ___
 Mailing list: https://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] Unsubscribe

[Ola Hodne Titlestad]

There is an unsubscribe link at the bottom of every list email. Please use
that.

Thank you,

Ola
--
On 19 Jun 2013 22:49, Dr UtibeAbasi URUA uti_eu...@yahoo.com wrote:

 Please, unsubscribe me. Thank you.
 Dr Urua

 Sent from my iPad
 Dr UtibeAbasi URUA
 Deputy Director
 (Planing, Research  Statistics)
 National Primary HealthCare Dev. Agency
 Plot 680 Gimbiya street , Area 11 Garki
 Abuja
 Fct

 ___
 Mailing list: https://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] Notification - Deadline for data set submission

[Ola Hodne Titlestad]

Hi Paulo,

We can definitely expand on our notification features.

Could you describe a bit more detailed what you would like here?
(and other readers feel free to contribute)

Some questions to get you started:

- Should the message be sent out x days before deadline, x days after
deadline or both?
- I assume you only want to notify the users that have not yet
submitted their data?
- To know who to send notifications to, would it be possible to create
a recipients list based on orgunit + user role, or simply to all users
assigned to the orgunit?
- Would you like to define notification rules per dataset or common
rules applicable to all data sets?

Feel free to describe all this in a blueprint:
https://blueprints.launchpad.net/dhis2/+addspec

Thanks.

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


On 13 May 2013 12:15, Paulo Grácio pgra...@criticalsoftware.com wrote:
 Hi,



 Similar to Complete notification recipientes is there a way to notify user
 that deadline is being reached for data set submission?



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

Re: [Dhis2-users] Tabular Report in Tracker Draws a Blank Page

[Ola Hodne Titlestad]

Hi John,

This seems to be the same problem that I came across on Friday:
- Tabular report does not load when the user has more than one orgunit.

Try this temporary fix:
1) Edit your user and make sure only one orgunit is assigned (e.g the root
or one province or one district, or one clinic..)
2) Log out and log in again
3) Open tabular report

If this doesn't work you could try to log out, clear browser cache and log
i again.

We will try to fix this bug as soon as possible and backport to 2.11.

Another issue related to Tabular Reports is that it depends on the resource
table _orgunitstructure to produce the tabular reports (with orgunit
hierarchies).

If you haven't enabled Scheduling (which automatically re-generates the
resource tables every night before doing all the aggregations) you must
generate this table manually:
1) go to Maintenance-Data administration-Resource Tables, then click on
Select All followed by Generate Tables.

Hope this helps.

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 5 May 2013 09:56, John Ojo jn...@yahoo.com wrote:

 Hi Ola,

 I have set up the tracker system, have enrolled ten (10) participants and
 entered data for each of them. The data entered is based on the personal
 attributes for each participant as well as data elements created to capture
 details of each training event.

 I tried to see a report of these trainings for the participants by
 selecting Tabular Report in the Individual Records module but this always
 draws a (white) blank page. The text in the address box of the page reads:
 http://localhost:8082/dhis-web-caseentry/app/index.html.

 Please, is there something I need to do before I can see the tabular
 reports?

 Thank you.

 John
 http://www.corridor-sida.org/

   --
  *From:* John Ojo jn...@yahoo.com
 *To:* Ola Hodne Titlestad ol...@ifi.uio.no
 *Cc:* dhis1-users dhis2-users@lists.launchpad.net; DHIS developers 
 dhis2-d...@lists.launchpad.net
 *Sent:* Wednesday, April 24, 2013 9:58 AM
 *Subject:* Re: [Dhis2-users] [Dhis2-devs] Help with Tracker

 Sorry Ola, I missed out the question you posed:

 I'd like to know a bit more about the kind of functionality you want out
 of this system, the outputs, how you will use the data. That can help you
 choose how to structure the transactional data (stages, data elements,
 option sets, attributes etc, orgunits).

 You are right. My aim is to monitor the training of multiple health
 workers over time and get information of what training they have been
 through and where and when this took place.

 John

   --
  *From:* Ola Hodne Titlestad ol...@ifi.uio.no
 *To:* John Ojo jn...@yahoo.com
 *Cc:* dhis1-users dhis2-users@lists.launchpad.net; DHIS developers 
 dhis2-d...@lists.launchpad.net
 *Sent:* Wednesday, April 24, 2013 9:24 AM
 *Subject:* Re: [Dhis2-devs] Help with Tracker

 Hi John,

 Very good questions.

 First I'd like to recommend reading the documentation and use case
 descriptions for Tracker here:
 http://dhis2.org/tracker

 That can help to better understand how Tracker can be implemented to
 support various use cases.
 Your case is not there, but it is a bit similar to use case 4.

 I'd like to know a bit more about the kind of functionality you want out
 of this system, the outputs, how you will use the data.
 That can help you choose how to structure the transactional data (stages,
 data elements, option sets, attributes etc, orgunits).

 It sounds like your major use case is to monitor the training of multiple
 health workers over time and get information of what training they have
 been through and where and when this took place.

 For that use case I think you are right in picking the multiple event with
 registration type of program. You want to follow individuals over time and
 add more data at different points in time, and for this you'll need to
 register persons and store the training data as multiple events (program
 stage instances in the data model).

 The next question is how you organise the data collection. What data will
 be collected for the different types of training events? It sounds almost
 like you could use the same data entry form for all of them since you are
 collecting type of training / level, first time or repeat, location.
 Since you will capture the same type of data for all training events you
 don't need more than one program stage (event type) for this program. BUt
 you'll need to repeat this stage for every training a person goes through,
 so you need to make this stage a repeatable stage. There is a
 property/option called

Re: [Dhis2-users] [Dhis2-devs] Tabular Report in Tracker Draws a Blank Page

[Ola Hodne Titlestad]

Hi John,

Glad it worked.

To generate aggregate data values you must define queries using the
Aggregation Query Builder (Maintenance-Persons and Programs) and run these
queries using Manual Person Aggregation (Services-Individual Records) or
the Automated Aggregation (Maintenance-Persons and Programs) feature.

There are some aggregation query examples here:
http://apps.dhis2.org/dev/dhis-web-maintenance-patient/caseAggregation.action

Ola
---

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 5 May 2013 15:33, John Ojo jn...@yahoo.com wrote:

 Thank you so much Ola.
 I tried the temporary fix: Edited my user and assigned only one orgunit,
 logged out, logged in again and re-tired Tabular Report. It worked!

 My next challenge is getting DHIS2 aggregate the case-based records into
 the aggregating management module of DHIS2. I will provide you with
 specifics and more details in a separate mail.

 Thank you so much for your kind support.
 John

   --
  *From:* Ola Hodne Titlestad ol...@ifi.uio.no
 *To:* John Ojo jn...@yahoo.com
 *Cc:* dhis1-users dhis2-users@lists.launchpad.net; DHIS developers 
 dhis2-d...@lists.launchpad.net
 *Sent:* Sunday, May 5, 2013 10:50 AM
 *Subject:* Re: [Dhis2-users] Tabular Report in Tracker Draws a Blank Page

 Hi John,

 This seems to be the same problem that I came across on Friday:
 - Tabular report does not load when the user has more than one orgunit.

 Try this temporary fix:
 1) Edit your user and make sure only one orgunit is assigned (e.g the root
 or one province or one district, or one clinic..)
 2) Log out and log in again
 3) Open tabular report

 If this doesn't work you could try to log out, clear browser cache and log
 i again.

 We will try to fix this bug as soon as possible and backport to 2.11.

 Another issue related to Tabular Reports is that it depends on the
 resource table _orgunitstructure to produce the tabular reports (with
 orgunit hierarchies).

 If you haven't enabled Scheduling (which automatically re-generates the
 resource tables every night before doing all the aggregations) you must
 generate this table manually:
 1) go to Maintenance-Data administration-Resource Tables, then click on
 Select All followed by Generate Tables.

 Hope this helps.

 Ola
 


 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps 
 linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


 On 5 May 2013 09:56, John Ojo jn...@yahoo.com wrote:

 Hi Ola,

 I have set up the tracker system, have enrolled ten (10) participants and
 entered data for each of them. The data entered is based on the personal
 attributes for each participant as well as data elements created to capture
 details of each training event.

 I tried to see a report of these trainings for the participants by
 selecting Tabular Report in the Individual Records module but this always
 draws a (white) blank page. The text in the address box of the page reads:
 http://localhost:8082/dhis-web-caseentry/app/index.html.

 Please, is there something I need to do before I can see the tabular
 reports?

 Thank you.

 John
  http://www.corridor-sida.org/

   --
  *From:* John Ojo jn...@yahoo.com
 *To:* Ola Hodne Titlestad ol...@ifi.uio.no
 *Cc:* dhis1-users dhis2-users@lists.launchpad.net; DHIS developers 
 dhis2-d...@lists.launchpad.net
 *Sent:* Wednesday, April 24, 2013 9:58 AM
 *Subject:* Re: [Dhis2-users] [Dhis2-devs] Help with Tracker

 Sorry Ola, I missed out the question you posed:

 I'd like to know a bit more about the kind of functionality you want out
 of this system, the outputs, how you will use the data. That can help you
 choose how to structure the transactional data (stages, data elements,
 option sets, attributes etc, orgunits).

 You are right. My aim is to monitor the training of multiple health
 workers over time and get information of what training they have been
 through and where and when this took place.

 John

   --
  *From:* Ola Hodne Titlestad ol...@ifi.uio.no
 *To:* John Ojo jn...@yahoo.com
 *Cc:* dhis1-users dhis2-users@lists.launchpad.net; DHIS developers 
 dhis2-d...@lists.launchpad.net
 *Sent:* Wednesday, April 24, 2013 9:24 AM
 *Subject:* Re: [Dhis2-devs] Help with Tracker

 Hi John,

 Very good

Re: [Dhis2-users] Patientdatavalue - value field is short

[Ola Hodne Titlestad]

Hi Marko and Rodolfo,

We have a comment field available for the programinstance object. This is
for general comments about a person in a program, a bit like a whiteboard
that you can always see on top of the data entry form in Person Dashboard.
This field is also limited to 255 characters, but we can extend it. We have
a patientcomment object that is referenced in programinstance.

Would this meet your needs or you need to have a comment per program stage
instance (encounter/visit)?

I guess we could link to a patientcomment from programstageinstance as
well, and this way make comments available per stage instance?

Ola


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 29 April 2013 21:02, Rodolfo Melia rme...@knowming.com wrote:

 Hi - just to echo on Marko's comment: PSI is also considering the use of a
 large, free text field, for doctor/ nurse to write free text observations
 that we don't need to quantify, but we want to capture, so DHIS can work as
 a light electronic health record. We will try Knut's suggestion on the mean
 time.


 On Fri, Apr 26, 2013 at 8:48 AM, Lars Helge Øverland 
 larshe...@gmail.comwrote:

 Hi Marko,

 we could consider it - the only problem is that we have chosen the
 approach of using one column for all types of values. Most values are short
 numbers and using text as column type over varchar with fixed length
 implies a performance penalty. I am not sure how significant that overhead
 is with latest versions of postgresql/mysql. We could check it out. I guess
 you could do like Knut suggests for now and change the column type manually.

 cheers

 Lars



 On Fri, Apr 26, 2013 at 5:29 AM, Marko David Garcia 
 markodavi...@gmail.com wrote:

 Hi friends, in the table patientdatavalue the field value is
 varchar(255).

 Is possible change this field to a bigger type?

 We need insert long descriptions in this field.

 Thank you very much.

 --
 Cordialmente,


 *Ing. Marko David Garcia M.
 *
 *Área de Sistemas integrados de Información
 Secretaría de Salud Departamental del Cauca

 *

 ___
 Mailing list: https://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




 --
 *Rodolfo Meliá*
 *Principal*
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia

 Note: Please note my new email address, which I will be using for PSI
 related work: rme...@knowming.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] Adding New Indicators results in Duplicate value in PKey Violation Error

[Ola Hodne Titlestad]

Hi,

When you say csv import into postgres you mean that you manually imported
the indicators using sql directly into your database?

We have something called csv import though the DHIS 2 interface as well, so
was a bit confusing.

All ids in the database get the values from the hibernate_sequence and if
you manually insert ids without paying attention to this sequence you will
end up with inconsistencies as you have now experienced.

When doing manual inserts directly on the database in sql you can use the
nextval('hibernate_sequence') function to set the ids. This will keep the
postgres/hibernate sequence in order and make sure DHIS 2 will get the next
correct ids as well.

Then there is no need to set the ids manually or to manually set the
hibernate_sequence value.

Ola
---
--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 25 April 2013 01:23, Thuy Nguyen thuy.hispviet...@gmail.com wrote:

 Hi Busoye
 You can change the current value of hibernate sequence by open your
 postgresql database there you expand the Schemas 
 expand the Sequences right click on Hibernate_sequence and select
 Properties. the Current Value is in the Definition tab.
 Change this number to the highest id from your indicator table or highest
 in all the id value you have in the database to prevent this error happen
 again in future.

 Thuy


 On Thu, Apr 25, 2013 at 3:38 AM, Busoye Anifalaje bus...@hisp.org wrote:

 Hi all,

 I imported 190 new indicators through a csv import into Postgres.
 IndicatorID as the primary key was set incrementally to continue from the
 last highest number (i.e. 33466, 33467, 33468 ... 33673). The imported
 indicators work perfectly.

 Now the problem: I tried to create a new indicator through the front end
 in DHIS2.11 (Build Revision:  10492) but keep getting an error that
 identifies a primary key conflict with the indicatorid. I also found that
 with every retry, the system tries to use the next incremental indicatorid
 (e.g. trial 1: indicatorid 33467 already exists; trial 2: 33468 already
 exists). I manually entered the indicator directly into the postgres table
 without any problem. Again, the indicator works fine. Any ideas on how to
 solve this problem without having to update all the imported indicators
 with new indicator ids?

 Further details of the error are attached in the attached screenshots
 (for some reason my tomcat log is not capturing the error - also attached).


 Thanks.

 Busoye

 DHIS Version: 2.11
 Build Revision: 10492
 OS: Windows XP
 OS Version: 5.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



 ___
 Mailing list: https://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] Help with Tracker

[Ola Hodne Titlestad]

 as incidence date then the scheduled
date for your first training event should be that same date, so you leave
Scheduled days from start to '0'.
This will create a training event automatically when you enrol a new person
and with the date you put for incidence date.

If you want to always schedule a new training event after finishing data
entry for the previous you can tick Display generate event box after
completed, and if not you untick that option.

Description of report date. The first thing the user must fill in during
data entry is the date of the event. Exactly what that date refers to
various from use case to use case so we have made it configurable. This
field is a label that will be displayed in the data entry screen to replace
Report Date. I would use Date of training or Start date of training
in your case.

Regarding person attributes and demographics I think it is entirely up to
you and your data needs to decide what you need. If you don't need more
than the default then no need to add anything, and if you need more you
create new attributes. The rule here is that the attributes to not change
for every training event, they are stable. If you want to capture data for
a variable that changes for every event then it should rather be collected
as a data element and not as a person attribute. Person attributes are
filled in on enrolment. and they can be updated in the person dashboard.

Hope this was useful. Let us know if you have any other questions. When you
get this program up and running it would be good to add it as a new use
case description on http://dhis2.org/tracker so that others can learn from
it as well.

Ola
-


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 24 April 2013 07:56, John Ojo jn...@yahoo.com wrote:

 Hello All,

 This is my first time to use the DHIS2 Tracker and would appreciate your
 kind support to help me move quickly.
 I have read chapter 24 of the DHIS2 manual and things are still not very
 clear yet in my head.

 I want to use DHIS2 version 2.11 to track certain health workers. These
 health workers live in different countries and provide health services in
 the country in which they live. My project provides capacity building to
 the health workers from time to time depending on when a need for capacity
 building is identified (the periodicity of the capacity building events
 therefore, does not follow predefined regular intervals such as we may have
 in for e.g. ANC visits or immunization programs).

 The capacity building activities are: CapBuild_1, CapBuild_2, CapBuild_3,
 CapBuild_4, CapBuild_5, etc.

 Now, for each health worker, I want to be able to track (i.e. a list
 showing):
 All the capacity building activities received by the health worker and
 each capacity building activity showing when (i.e. the date) the capacity
 building activity took place, what capacity building was given (i.e.
 whether CapBuild_1, CapBuild_2, CapBuild_3, etc.), where (i.e. country and
 town) the capacity building took place and whether that capacity building
 was first time or a repeat for the health worker.

 Please I will need help with the following:

 1. 1. What category options (option set) would be appropriate for me
 to create in this scenario?
 ** **
 2.  2. What data elements would I need to create to be able to
 capture the capacity building activity data?
 ** **
 3.  3. Apart from biodata information (e.g. name, age, sex, ID
 number) of each health worker, what additional demographic information
 should I create as attributes for the health worker?
 ** **
 4.  4. I have decided to set up the program as “Multiple events with
 registration”. Is this appropriate for my scenario? What would be an
 appropriate “Description of incident date”?
 ** **
 5.  5. What are the possible “Different Stages” that would be most
 appropriate that I should create for my scenario?
 ** **
 6.  6. When creating the Different Stages of the Program, what would
 be most appropriate for the following:
 ** **
 a.   Name:
 b.  Schedule days from start:
 c.   Auto-generate event
 d.  Description of report date
 ** **
 7.   7. Please what should I do next after creating the different stages?*
 ***

 Thanking you in advance for your time in helping me with this very long
 list of questions.

 Best regards,
 John

 *John Ojo MD, FMCPH
 *
 Pretoria, South Africa.
 Mobile: +27 795 469 129
 Skype:  Johnojo
 Email: jn...@yahoo.com j...@corridor-sida.org
 http://www.corridor-sida.org

Re: [Dhis2-users] DXF Detailed Metadata Export...

[Ola Hodne Titlestad]

There is an unsubscribe button here (look under Mailing List):
https://launchpad.net/~dhis2-users


- the same page where you subscribed.

Ola


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 9 April 2013 09:54, Assaye Tolla bulti...@gmail.com wrote:

 Dear all,

 Please can you help me to unsubscribe? My inbox is stuffed with this!

 Best,



 On Tue, Apr 9, 2013 at 6:16 AM, Juan Manuel Alcantara Acosta 
 jmalcanta...@gmail.com wrote:

 I did the export using this method and then imported to a local server
 and it all worked, exactly as expected.
 Thank you,
 JM


 El 08/04/2013, a las 17:37, Lars Helge Øverland larshe...@gmail.com
 escribió:




 On Mon, Apr 8, 2013 at 11:18 PM, Rodolfo Melia rme...@knowming.comwrote:

 Hi Bob - thanks for your detailed explanation. Because we use naming
 conventions, we wanted to filter on the basis of name. 'WHP - ' is the
 prefix that we were planning to use to locate quickly what we wanted to
 export, and just moved into the one that can be exported.

 We want/ need to export the following elements:
 1. Data Elements - we can certainly put them in a a group if that
 speed-up things. This is the critical one.
 2. Category Combos, Categories and associated options. We can certainly
 rebuild them
 3. Form with sections. That will be nice !

 R



 Hi Rodolfo,

 thanks for the feedback. The detailed export was removed temporarily due
 to time pressure - we wanted to get DXF2 in for 2.12 but didn't have time
 to re-implement detailed export. Will put it back for 2.12.

 In the meantime your needs can be covered through the web api like this
 for data elements (example runs against demo, substitute ART query with WHP
 -):


 http://apps.dhis2.org/demo/api/dataElements/query/ART.xml?viewClass=detailedpaging=falselinks=false

 query/criteria: define your query criteria
 viewClass: ask for all details about data elements
 paging: turn off paging
 links: skip links

 for category combos:


 http://apps.dhis2.org/demo/api/categoryCombos.xml?viewClass=detailedpaging=falselinks=false

 for data sets and custom forms:


 http://apps.dhis2.org/demo/api/dataSets.xml?viewClass=detailedpaging=falselinks=false

 You can then import these files on the other side.

 It's documented here:

 http://dhis2.org/doc/snapshot/en/user/html/ch25s04.html


 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] DXF Detailed Metadata Export...

[Ola Hodne Titlestad]

Hi Rodolfo,

You can also use the Web API to get an xml dump of a group of data elements
like this:
http://apps.dhis2.org/demo/api/dataElementGroups/qfxEYY9xAl6.xml

So you could
1) put all the data elements you want to move over to another instance into
one data element group,
2) use the Web-API browser: http://apps.dhis2.org/demo/api/resources ,
3) click on html link next to DataElementGroups and then look for your
group and click on the XML linkto get the XML you need for your data
elements.
4) That XML can be imported using metadata import on another instance.

Lars just explained that to me today so I have not tested it yet, but it is
supposed to work. Lars, or others, please correct me if I am wrong.

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 8 April 2013 22:34, Bob Jolliffe bobjolli...@gmail.com wrote:

 Hi Rodolfo

 The old metadata export used a very manually crafted parser for a language
 called dxf 1.0 which was past its sell-by date and becoming hard to
 maintain.

 The newer metadata export uses dxf 2.0 which is a much more complete
 reflection of the domain objects but I note it doesn't allow the selection
 of particular dataelement groups or indicator groups.

 We will be working on some functionality to export the selection of all
 metadata which might be related to a particular group of indicators, but
 that is coming.

 In the meantime if there is particular filtering you want to do of the
 full metadata dump then share on this list and I (or someone else) can
 probably help with an xslt transform you could use which would be
 infinitely beter than editing manually.

 If you are wanting to edit then there a number of approaches.  The oxygen
 xml editor is by far the best in my view but sadly not free.  emacs (nxml
 mode) works really well even on mac and windows but is not for everybody.
  For working with xml from the mac or windows shell, then libxml from
 http://www.xmlsoft.org/ comes with the handy xmllint tool which can do
 lots of things, but one of the most useful is to pretty print format the
 xml.

 Bob



 On 8 April 2013 19:20, Rodolfo Melia rme...@knowming.com wrote:

 ... is gone

 Hi - 2.10 as well as early development releases of 2.11 had an 'DXF
 Detailed Metadata Export' option. This function allowed to specify what
 Data Elements and Indicators to export. It was great for prototyping
 something in one server, and then moving the final definitions to another
 box. The final release of 2.11 doesn't have that option anymore. I curios
 to learn why the functionality was axed - i suspect some technical reasons
 relating to the explicit use of UID across the new version.

 So if that function is not coming back, what is the best strategy for
 moving metadata from one instance to another? I imagine the answer is using
 an XML editor  and editing the export XML that you get from the metadata
 export option. Is that the case? Any suggestions of good XML editors that
 allow to read the resulting XML by a human being, so you can be selective
 about what you are moving between boxes? I'm looking for a Mac editor, and
 a Windows editor.

 Rodolfo

 --
 *Rodolfo Meliá*
 *Principal*
 rme...@knowming.com
 www.knowming.com
 +1 708 872 7636
 +44 777 576 4090
 Skype: rod.melia
 Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia

 Note: Please note my new email address, which I will be using for PSI
 related work: rme...@knowming.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


___
Mailing list: https://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] OptionSet and Yes-only Data Elements on Aggregated

[Ola Hodne Titlestad]

HI Randy,

Category combinations are not supported in the Tracker (patient) data model.

Your example seems to fit within the aggregate data domain as it looks like
a summary form for many events/activities.
Why did you go for Tracker (patient domain data elements) for this data?

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 27 March 2013 19:52, Wilson,Randy rwil...@msh.org wrote:

  We’ve been working some more with the patient records module as well and
 have discovered that the category combinations don’t render either.  

 ** **

 For example we have data we’re collecting on number of VCT tests by
 different at risks groups (MARPS).  I was trying to set up a data entry
 form with category combos for the columns, but doesn’t seem to work.  No
 matter how you set up your data element, it seems to revert to displaying
 one column only.

 ** **

 *Type of MARPs*

 *FSW*

 *MSM*

 *TD*

 *Fishermen*

 *PwD*

 1. People reached by peer educators

 ** **

 ** **

 ** **

 ** **

 ** **

 2. Contacts with people where interpersonal communication was provided

 ** **

 ** **

 ** **

 ** **

 ** **

 3. People who received condoms

 ** **

 ** **

 ** **

 ** **

 ** **

 ** **

 This is easy to do in aggregate records, but unfortunately our use case
 requires more than one report per orgunit per period (i.e. different
 partner organizations report for the same periods).

 ** **

 Randy

 ** **

 *From:* dhis2-users-bounces+rwilson=msh@lists.launchpad.net [mailto:
 dhis2-users-bounces+rwilson=msh@lists.launchpad.net] *On Behalf Of *Olav
 Poppe
 *Sent:* Wednesday, March 27, 2013 12:36 PM
 *To:* Rodolfo Melia
 *Cc:* dhis2-users@lists.launchpad.net; James Chang
 *Subject:* Re: [Dhis2-users] OptionSet and Yes-only Data Elements on
 Aggregated

 ** **

 Hi,

 I have not really tried to use the yes only in aggregate, but I can see
 that it renders as a text box instead of a tick mark like you say. Someone
 else will have to respond to whether there is any reason for this, like if
 the yes only is not supported in aggregate like the option sets.

 ** **

 Olav

 ** **

 ** **

 26. mars 2013 kl. 16:05 skrev Rodolfo Melia rme...@knowming.com:



 

 Hi Olav - just to finish the conversation above. It is clear that Option
 Sets are not supported by a DataSet on the aggregated side.

 ** **

 What it is not clear to me is if the 'Yes Only', which renders as a 'tick
 box' on Tracker, should render or not on the DataSets for the aggregated
 side. It will great if it does, as it will improve significantly the use of
 DHIS on a tablet - I'm trying to do a long questionnaire that needs to be
 run every 6 months, and the people running the survey will complete it
 using a tablet. Most of the questions are True/False. At the moment a
 Yes/No/Null means two interaction: one to open the drop-down, one to
 select; a Tick-box will be a single interaction, and when completing over
 100+ questions, it will make a significant difference to the users.

 ** **

 ** **

 R

 On Tue, Mar 26, 2013 at 11:55 AM, Rodolfo Melia rme...@knowming.com
 wrote:

 ok. What about 'Yes-Only' ?

 ** **

 On Tue, Mar 26, 2013 at 11:54 AM, Olav Poppe olav.po...@me.com wrote:***
 *

 Hi,

 OpionSets are only supported in the tracker, assigning an optionset to an
 aggregate type data element will not have any effect.

 ** **

 Olav

 ** **


 Den 26. mars 2013 kl. 12:36 skrev Rodolfo Melia rme...@knowming.com:

  Hi everyone - I have a question about the rendering on Option Sets and
 Yes-Only on DataSets (Aggregated). On Tracker (DataElement.Domain =
 Patient), OptionSet and Yes-only data elements successfully render as
 either a dynamic drop-down or a tick box. But on Aggregated they render as
 a simple text box. On the other hand, Yes/No does render as a drop-down. Is
 this a bug or is this on purpose? I'm using multiple versions of DHIS,
 including the latest release of 2.11.

 ** **

 Below a* screenshot in Tracker, which works as expected*

 image.png

 ** **

 Below, rendering as a *DataSet: no dropdown option or tick box get
 redenred..*.

 image.png

 ** **

 ** **

 ** **

 R
 

 ** **

 -- 

 *Rodolfo Meliá*

 rme...@knowming.com

 www.knowming.com

 +1 708 872 7636

 +44 777 576 4090

 Skype: rod.melia

 Twitter: @RodolfoMelia https://twitter.com/RodolfoMelia

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

Re: [Dhis2-users] Help

[Ola Hodne Titlestad]

Hi David,
For custom sql based reports have a look at section 13.4.3 in the user doc:

http://www.dhis2.org/doc/snapshot/en/user/html/ch13s04.html

You can only run DHIS 2 with one unerlying database, the one you specify in
hibernate.properties. But you can then create custom sql against any entity
in this db, add a nice layout on top of that with iReport and make it
available to the users as a standard report with runtime parameters in the
DHIS 2 UI. Instructions in the link above.

Ola
---
On Feb 7, 2013 8:28 AM, Nyaika David davie2...@gmail.com wrote:

 Hi Guys

 In the dhis-live/conf/hibernate.properties directory, i see there are
 settings for connecting to postgres database.  can i be able to access the
 postgres database entities within  DHIS2 for use in report generation


 Thanks in advance for your help :)

 --
 Regards
 David Nyaika
 Software Developer(SCJP,SCWCD Certified)
 IICS Technologies, Muyenga
 Phone:+256706353274
 Skype:davie2086
 Email: davie2...@gmail.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] [Dhis2-devs] DHIS 2 version 2.10 released

[Ola Hodne Titlestad]

Great work team, congrats!

Ola
---
On Nov 15, 2012 10:21 PM, Muhire Andrew muhireand...@yahoo.com wrote:

 Bravoo to the Team.




 --


 *Muhire Andrew
 *
 *HMIS/Ministry of Health*
 First say to yourself what you would be; and then do what you have to do.*
 .*


   --
 *From:* Juma Lungo jlu...@yahoo.com
 *To:* Lars Helge Øverland larshe...@gmail.com; 
 dhis2-users@lists.launchpad.net dhis2-users@lists.launchpad.net; DHIS
 2 developers dhis2-d...@lists.launchpad.net; Jim Grace 
 jimgr...@gmail.com; Lawi Mamai lawi.ma...@gmail.com; Raphael Pundo 
 raphael_pu...@afyainfo.org; Martin Osumba martin_osu...@afyainfo.org;
 Jim Setzer jim_set...@afyainfo.org; Calle Hedberg 
 calle.hedb...@gmail.com; Greg Rowles greg.row...@gmail.com; Vincent
 Shaw vps...@gmail.com; Farai Mutero fmut...@gmail.com; 
 gehro...@state.gov gehro...@state.gov; donna@theglobalfund.org 
 donna@theglobalfund.org; dset...@intrahealth.org 
 dset...@intrahealth.org; pbion...@regenstrief.org 
 pbion...@regenstrief.org; sgran...@iupui.edu sgran...@iupui.edu;
 Denis Adaletey dadale...@yahoo.com; Amuha, Monica mam...@msh.org;
 Schaefer, Petra pschae...@sure.ug; Alex Tumwesigye 
 atumwesi...@gmail.com; stenges...@s-3.com stenges...@s-3.com; 
 dave.tromb...@gmail.com dave.tromb...@gmail.com; 
 arthurheyw...@gmail.com arthurheyw...@gmail.com; dkima...@nascop.or.ke
 dkima...@nascop.or.ke; rwil...@msh.org rwil...@msh.org
 *Sent:* Thursday, November 15, 2012 10:35 PM
 *Subject:* Re: [Dhis2-users] [Dhis2-devs] DHIS 2 version 2.10 released

 Great work


 Lungo

   --
 *From:* Lars Helge Øverland larshe...@gmail.com
 *To:* dhis2-users@lists.launchpad.net; DHIS 2 developers 
 dhis2-d...@lists.launchpad.net; Jim Grace jimgr...@gmail.com; Lawi
 Mamai lawi.ma...@gmail.com; Raphael Pundo raphael_pu...@afyainfo.org;
 Martin Osumba martin_osu...@afyainfo.org; Jim Setzer 
 jim_set...@afyainfo.org; Calle Hedberg calle.hedb...@gmail.com; Greg
 Rowles greg.row...@gmail.com; Vincent Shaw vps...@gmail.com; Farai
 Mutero fmut...@gmail.com; gehro...@state.gov;
 donna@theglobalfund.org; dset...@intrahealth.org;
 pbion...@regenstrief.org; sgran...@iupui.edu; Denis Adaletey 
 dadale...@yahoo.com; Amuha, Monica mam...@msh.org; Schaefer, Petra
 pschae...@sure.ug; Alex Tumwesigye atumwesi...@gmail.com;
 stenges...@s-3.com; dave.tromb...@gmail.com; arthurheyw...@gmail.com;
 dkima...@nascop.or.ke; rwil...@msh.org
 *Sent:* Thursday, November 15, 2012 10:45 PM
 *Subject:* [Dhis2-devs] DHIS 2 version 2.10 released


 Hi all,

 DHIS 2 version 2.10 has been released. The major features this time:

 - We have included elements from social networking: You can self-register
 a user account, create your own profile, post messages and share
 interpretations. You can easily search and find other peoples profiles and
 communicate through messages.

 - A completely new GIS module, rewritten from scratch, which comes with
 much faster load time, more intuitive user interface and more features.

 - A brand new web-based mobile client with offline support for
 smartphones. It lets you enter data, send messages and manage your profile.


 All new features:


 1. GIS: All map layers can be saved as a single favorites. You can create
 nice maps containing multiple layers and save it all together in a single
 favorite. You can also share map favorites as interpretations by first
 loading or saving a favorite, then clicking share on the top menu. Log in
 with admin/district:

 http://apps.dhis2.org/demo/dhis-web-mapping/app/index.html?id=m16KunJ3pbi

 http://apps.dhis2.org/demo/dhis-web-mapping/app/index.html?id=GmIDubfPzCU


 2. GIS: Improved favorite user interface with paging and free-text search.
 You can rename, overwrite, delete and add the favorite to your dashboard
 straight from the list. Click on Favorites in the top menu:

 http://apps.dhis2.org/demo/dhis-web-mapping/app/index.html

 Documentation here:

 http://dhis2.org/doc/snapshot/en/user/html/ch15.html


 3. GIS: Display surrounding areas as circles around facilities in order to
 visualize density of facility services:

 http://apps.dhis2.org/demo/dhis-web-mapping/app/index.html?id=y3jLMnZTV6i


 4. Web-based mobile client for smartphones: We have a new mobile client
 which lets you enter aggregate data, send and receive messages and manage
 your profile. The data entry functionality works offline, meaning you only
 need connectivity for downloading the data entry forms and submitting data
 to the server. In between you can stay offline and enter data for as long
 as you want. It is targeted at smartphones with touch-based interfaces, and
 works on all Android versions from 2.1 and above. With the rapidly
 decreasing price on smartphones this client is a compelling alternative for
 mobile data entry, compared with the complexity and issues with
 compatibility, installations and upgrade associated with native Java
 clients.

 

Re: [Dhis2-users] Filtering Text in iReport

[Ola Hodne Titlestad]

Hi Daniel,

You can use the Print When Expression property of the Detail band to filter
the rows that are listed in the main table.

Ola
---


On 19 October 2012 11:25, Daniel Bridges dbrid...@akrosresearch.com wrote:

 Is there any way that one can filter the entries in the table of a
 standard report? For example, I have created a report template with data
 from the last 4 quarters, with a chart showing all four quarters data.
 However I only want to show the latest quarters data in the table
 underneath the chart (rather than all 4). I have been experimenting with
 the following in the field expression of the text fields in the table, but
 can't get it to work:

 $F{passive rdt +ve rate}.where($F{periodname}.**equals($F{reporting_month_
 **name}))

 $F{passive rdt +ve rate} - Data field
 $F{periodname} - Period quarters
 $F{reporting_month_name} - Current quarter

 Obviously I have totally made up the where and equals statement, but
 hopefully it gives the idea of what I am trying to do Any ideas if this
 is even possible?

 Thanks in anticipation
 Dan

 __**_
 Mailing list: 
 https://launchpad.net/~dhis2-**usershttps://launchpad.net/~dhis2-users
 Post to : 
 dhis2-users@lists.launchpad.**netdhis2-users@lists.launchpad.net
 Unsubscribe : 
 https://launchpad.net/~dhis2-**usershttps://launchpad.net/~dhis2-users
 More help   : 
 https://help.launchpad.net/**ListHelphttps://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 a map with all facilities

[Ola Hodne Titlestad]

Hi,

There is no export to image for the facility layer (the on with symbols for
the facility types etc.) at the moment.

What I usually do for this use case is to take a screenshot/printscreen.
That way you can also get the google maps background map if you like
(and/or the boundary layer).

Jan is working hard to improve the GIS these days and there will be major
changes in either 2.10 or 2.11.

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 18 October 2012 12:43, Jason Pickering jason.p.picker...@gmail.comwrote:

 Hi Adolphe,

 You can always export your map as a PNG image simply by clicking the
 Export map as image button from the GIS toolbar.

 Best regards,
 Jason


 On Thu, Oct 18, 2012 at 12:16 PM, Adolphe Kamugunga kaa...@gmail.com
 wrote:
  Hi,
 
  I can build a map illustrating the country  combining Boundary layer and
  Facility layer  into DHIS. This map can help to localize a facility  and
  tell the  facility type as all facilities are displayed with symbols. Is
  there any possibility to get this kind of map  out of Dhis2 for other
 uses?
 
 
 
  Adolphe
 
 
 
  From: dhis2-users-bounces+kaadol=gmail@lists.launchpad.net
  [mailto:dhis2-users-bounces+kaadol=gmail@lists.launchpad.net] On
 Behalf
  Of Ola Hodne Titlestad
  Sent: Monday, October 15, 2012 10:54 AM
  To: Marta Vila
  Cc: dhis2-users
  Subject: Re: [Dhis2-users] Doubts on the use of Single Event with
  registration program with repeatable stage
 
 
 
  Hi,
 
 
 
  So this is a disease surveillance/notification system? If the goal is to
  track outbreaks etc. and to collect details about each case, BUT not
 really
  to keep a history of all events for each patient, then I would suggest
 using
  single event without registration. This will be the easiest way to
 collect
  and import data about these events and to generate statistics about
 these.
  You can still include information about the patient such as name,
 relatives,
  location etc. as data elements, but without involving the patient object
 in
  DHIS 2 and skipping the whole registration process.
 
 
 
  If keeping track of a patients history of multiple similar events (same
 data
  collection form) then you need to have registration. You can have a
 program
  with one repeatable stage and schedule and re-schedule new events at any
  time, and there is no need to schedule a new one immediately after data
  entry of the previous event.
 
 
 
  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
 
  On 15 October 2012 10:43, Marta Vila martav...@gmail.com wrote:
 
  Hi Ola,
 
 
 
  it is an event notification system in which the event information is
  gathered in a single stage and a patient can notify more than one event.
 
 
 
  thanks.
 
  Marta
 
 
 
 
 
  On 15 October 2012 10:33, Ola Hodne Titlestad ol...@ifi.uio.no wrote:
 
  HI Marta,
 
 
 
  Can you tell us briefly about your use case (what kind of data, programs,
  encounters)?
 
  Then it will be easier to explain how to set up the programs/stages etc.
 
 
 
  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
 
  On 15 October 2012 10:21, Marta Vila martav...@gmail.com wrote:
 
  Dear all,
 
 
 
  I´m importing some patient legacy data for Colombia pilot project. To do
  that, I´ve trying to understang how the patient module works in the db
 and I
  have some doubts on the use of Single Event with registration program
 with
  repeatable stage.
 
 
 
  I create the program and introduce data for one patient. Complete the
 data
  entry form ... and it appears a pop-up to schedule the next encounter...
  then:
 
 
 
  1) Is it possible not to schedule the next encounter there, but when it
  happens? (Like a spontaneous clinic visit)
 
  2) Is it posible to re-schedule an encounter?
 
  3) How can I retrieve an encounter to introduce data on it? I don´t
 find
  the way, even if i´m on the date the ecounter was scheduled for.
 
 
 
  - I don´t see the options Tracking-Visit Schedule  Tracking- Program
  Tracking that I´ve read in the documentation, in case it has smth to do
 with
  the limitations I found.
 
  (Version 2.9 Build Revision 7897)  I´m using admin acccount.
 
 
 
  Following this functionality, The way I can do it now is creating a new
  instance

Re: [Dhis2-users] Doubts on the use of Single Event with registration program with repeatable stage

[Ola Hodne Titlestad]

HI Marta,

Can you tell us briefly about your use case (what kind of data, programs,
encounters)?
Then it will be easier to explain how to set up the programs/stages etc.

Ola
-

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
linkhttps://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norgehl=enie=UTF8sll=59.893855,10.785116sspn=0.222842,0.585709oq=eftas%C3%A5sen+68,+0687+Oslo,+t=hhnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norwayz=16


On 15 October 2012 10:21, Marta Vila martav...@gmail.com wrote:

 Dear all,

 I´m importing some patient legacy data for Colombia pilot project. To do
 that, I´ve trying to understang how the patient module works in the db and
 I have some doubts on the use of Single Event with registration program
 with repeatable stage.

 I create the program and introduce data for one patient. Complete the data
 entry form ... and it appears a pop-up to schedule the next encounter...
 then:

 1) Is it possible not to schedule the next encounter there, but when it
 happens? (Like a spontaneous clinic visit)
 2) Is it posible to re-schedule an encounter?
 3) How can I retrieve an encounter to introduce data on it? I don´t find
 the way, even if i´m on the date the ecounter was scheduled for.

 - I don´t see the options Tracking-Visit Schedule  Tracking- Program
 Tracking that I´ve read in the documentation, in case it has smth to do
 with the limitations I found.
 (Version 2.9 Build Revision 7897)  I´m using admin acccount.

 Following this functionality, The way I can do it now is creating a new
 instance of the program everytime a patient comes (even if he/she has come
 before) So in the end, for a single patient, I have as many instances of
 the program as visits he/she made, with one encounter per instance with
 data... and one preogrammed but never accesed..

 Any help on understanding this will be much appreciated.
 thanks!

 Marta

 ___
 Mailing list: https://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] Datamart

[Ola Hodne Titlestad]

Hi Kabango,

That is not possible.

You can do it with report tables and standard reports.

Ola
---
On Jul 20, 2012 10:49 AM, Kabango Malewezi kmalew...@jhpiego.net wrote:

 Gentle People,



 I'd like to have Elements and indicators in one excel pivot table. How do
 I do that? The available views I have have either Pivot_Indicator or
 Pivot_Routinedata.



 Kabango Malewezi

 SSDI Services

 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
 Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88
 4 245 431

 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net  |  www.jhpiego.org
 http://www.jhpiego.org/

 Skype: kabango.malewezi | Twitter: kabangoM

 ___
 Mailing list: https://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] Datamart

[Ola Hodne Titlestad]

Jason,
How do you handle the values in this view? Indicator values should be set
up as a calculated field to let excel aggregate numerators and denominators
separately for percentage values. If not the values for higher levels will
be wrong.

Or are you using only one orgunit level in this view?

I guess it is possible to use two separate value fields for data elements
and indicators in the same pivot table?
Sounds confusing, but for a very specific/static table maybe but then I
would recommend standard reports.

Ola
---
On Jul 20, 2012 7:24 PM, Kabango Malewezi kmalew...@jhpiego.net wrote:

 Hi Kabango,

 That is not possible.

 You can do it with report tables and standard reports.

 Ola
 ---
 On Jul 20, 2012 10:49 AM, Kabango Malewezi kmalew...@jhpiego.net
 wrote:

 Gentle People,



 I'd like to have Elements and indicators in one excel pivot table. How do
 I do that? The available views I have have either Pivot_Indicator or
 Pivot_Routinedata.



 Kabango Malewezi

 SSDI Services

 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
 Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0)
 88 4 245 431

 kmalew...@jhpiego.net mailto:kmalew...@jhpiego.net  |  www.jhpiego.org
 http://www.jhpiego.org/

 Skype: kabango.malewezi | Twitter: kabangoM

 ___
 Mailing list: https://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] Problems with Report tables

[Ola Hodne Titlestad]

Hi Jose,

Most likely there are no weekly values in your datamart (where all the
reports fetch data from).

Weekly periods are not selected by default in the datamart scheduler.

Go to Maintenance-Data Administration-Scheduling and tick Weekly in the
Aggregation period types section.
Also make sure to start the scheduler. The datamart will then export at
midnight (server time).

Ola





--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 1 June 2012 13:03, Jose Garcia Muñoz josem...@gmail.com wrote:


 Hi all,

 I have a problem with totals using the report tables. In the picture
 DataEntry.jpg you can see a dataset with different DataElements and two
 categories combined between them. The dataset corresponds to the
 Organization Unit CS Pacu and the period time is the first week of 2012.
 When i try to make a report table of the same information, i get a report
 without totals (as you can see in the picture Report.jpg). The organization
 unit and the period time are the same. So any idea about why is it going
 wrong? I am using the 2.7 version.

 Thank you very much!

 ___
 Mailing list: https://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] Custom form designer creates error in data entry

[Ola Hodne Titlestad]

Just a stupid question:
Have you added data elements to the dataset?

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 26 April 2012 10:11, Hiatt, Mr Tom (WPRO) hia...@wpro.who.int wrote:

 Thanks for your help.

 I don't think this had to do with changing data element names since I was
 never able to add a data element into the form (my other issue). Also, I
 don't think I changed any names or categories.

 Clearing the cache didn't seem to clear things up either, unfortunately.

 Do I need to really dig into the tables then?

 Thanks again,
 Tom

 -Original Message-
 From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
 Sent: 26 April 2012 15:35
 To: Hiatt, Mr Tom (WPRO)
 Cc: dhis2-users@lists.launchpad.net
 Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

 I encountered a similar issue yesterday but did not think much about
 it at the time, however I see it may now really be a bug.

 I added a data element..

 No. of HIV+ pregnant women newly intiated on ART for their own health
 (New)with default category options

 When I opened up the custom data entry form, I managed to dig this out
 of the JavaScript console


 c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4
 f.extend.cssjquery.min.js:4
 f.fn.extend.showjquery.min.js:4
 f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585
 e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161
 e.widget._createjquery-ui-1.8.12.custom.min.js:161
 b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
 b.widget.b.(anonymous function).(anonymous
 function)jquery-ui-1.8.12.custom.min.js:28
 b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
 e.extend.eachjquery.min.js:2
 e.fn.e.eachjquery.min.js:2
 b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
 c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387
 c.widget._createjquery-ui-1.8.12.custom.min.js:380
 b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
 b.widget.b.(anonymous function).(anonymous
 function)jquery-ui-1.8.12.custom.min.js:28
 b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
 e.extend.eachjquery.min.js:2
 e.fn.e.eachjquery.min.js:2
 b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
 (anonymous function)viewDataEntryForm.js:11
 f.Callbacks.njquery.min.js:2
 f.Callbacks.o.fireWithjquery.min.js:2
 e.extend.readyjquery.min.js:2
 c.addEventListener.B

 Not very helpful. When  I changed (New) to (Foo) it got the same
 error, thinking that it might have something to do with the use of
 (New). When I removed (New) it worked just fine. Maybe it is related
 to the name of the DE?

 I do not know what you data element is, but normally that error
 happens when a data element exists in the custom form, which does not
 exist in the database. You may need to clear your cache completely in
 order for the new form to appear. Otherwise, the full stack trace
 would be helpful for the devs.

 Best regards,
 Jason


 On Thu, Apr 26, 2012 at 2:40 AM, Hiatt, Mr Tom (WPRO)
 hia...@wpro.who.int wrote:
  DHIS 2.7 with Chrome
 
 
 
  I tried to create a custom data entry form and it looks like the form
  designer was missing things (I couldn't find data elements to add for
  example).
 
 
 
  I saved the custom version anyway and then went to data entry which now
 had
  an exception. So I went back to the custom form screen, deleted it, but
  there is still an exception for data entry.
 
 
 
  Here's the exception code:
 
 
 
  [+] Exception (org.hibernate.ObjectNotFoundException): No row with the
 given
  identifier exists:
  [org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#61]
 
 
 
  Any idea how I can fix this and hopefully be able to add custom forms?
 
 
 
  Thanks,
 
  Tom
 
 
 
 
 
 
 
 
 
 
 
  
 
  This message was scanned for viruses with Trend Micro ScanMail, GFI
  MailSecurity and GFI MailEssentials by the World Health Organization
  Regional Office for the Western Pacific. However, the recipient is
 advised
  to scan this e-mail and any attached files for viruses.
 
  Disclaimer:
 
  This e-mail, together with any attachments, is intended for the named
  recipients only and is confidential. It may also be privileged or
 otherwise
  protected by law.
 
  If you have received it in error, please notify the sender immediately by
  reply e-mail and delete it and any attachments from your system. You may
 not
  copy or disclose its contents to anyone.
 
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help

Re: [Dhis2-users] Custom form designer creates error in data entry

[Ola Hodne Titlestad]

Hi Tom,

If you send a copy of your paper form it will be easier to comment on how
to map to data elements and categories.

Haven't heard of any problems with more than 3 categories in a combo
before, but this problem might be related to a change in categorycombo for
the data elements in the form (after the form was designed).

Each data field in the form is linked a the data element + a
categoryoptioncombination, and the categoryoptioncombination will be
different when you change from 3 to 4 categories. If you re-design the
custom for (delete all assigned fields) and try again, it should work for
both 4 and 3 categories in a combination.

Ola



--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 26 April 2012 10:46, Hiatt, Mr Tom (WPRO) hia...@wpro.who.int wrote:

 ** ** ** ** ** **

 Okay I think I got it!

 ** **

 It seems DHIS is really fiddly with more than 3 categories in a combo.
 When I changed my data element to only be disaggregated by 3 categories it
 worked again. Afterward I changed it back to the 4 category (age, sex, case
 type, and disability level in case you were wondering) it works again.
 Luckily I don’t have any real data in there yet.

 ** **

 So I’m thinking it’s safer to only have up to 3 categories at a time and
 then, sort of break my data model and create additional (duplicate) data
 elements for the other categories. Is this what you would do?

 ** **

 Thanks again,

 Tom

 ** **
  --

 *From:* Muhire Andrew [mailto:muhireand...@yahoo.com]
 *Sent:* 26 April 2012 16:30
 *To:* Ola Hodne Titlestad; **Hiatt, Mr Tom** (WPRO)

 *Cc:* **dhis2-users@lists.launchpad.net**
 *Subject:* Re: [Dhis2-users] Custom form designer creates error in data
 entry
 

  ** **

 I was thinking the same way as Ola, may be the data element is attached to
 the dataset but later removed from the dataset.

  

 *

 *
  --

 *

 **Muhire Andrew*

 *HMIS/Ministry of Health*

 First say to yourself what you would be; and then do what you have to do.*
 .*

 ** **

 ** **
--

 *From:* Ola Hodne Titlestad ol...@ifi.uio.no
 *To:* **Hiatt, Mr Tom** (WPRO) hia...@wpro.who.int
 *Cc:* **dhis2-users@lists.launchpad.net** **
 dhis2-users@lists.launchpad.net**
 *Sent:* Thursday, April 26, 2012 10:16 AM
 *Subject:* Re: [Dhis2-users] Custom form designer creates error in data
 entry

 ** **

 Just a stupid question:

 Have you added data elements to the dataset?


 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University** of **Oslo

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo**, **Norway. Googlemaps
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway
 

 ** **

 On 26 April 2012 10:11, **Hiatt, Mr Tom** (WPRO) hia...@wpro.who.int
 wrote:

 Thanks for your help.

 I don't think this had to do with changing data element names since I was
 never able to add a data element into the form (my other issue). Also, I
 don't think I changed any names or categories.

 Clearing the cache didn't seem to clear things up either, unfortunately.

 Do I need to really dig into the tables then?

 Thanks again,
 Tom


 -Original Message-
 From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
 Sent: 26 April 2012 15:35
 To: **Hiatt, Mr Tom** (WPRO)
 Cc: dhis2-users@lists.launchpad.net
 Subject: Re: [Dhis2-users] Custom form designer creates error in data entry

 I encountered a similar issue yesterday but did not think much about
 it at the time, however I see it may now really be a bug.

 I added a data element..

 No. of HIV+ pregnant women newly intiated on ART for their own health
 (New)with default category options

 When I opened up the custom data entry form, I managed to dig this out
 of the JavaScript console


 c.defaultView.c.defaultView.getComputedStyle.bAjquery.min.js:4
 f.extend.cssjquery.min.js:4
 f.fn.extend.showjquery.min.js:4
 f.fn.extend.showjquery-ui-1.8.12.custom.min.js:585
 e.widget._create._renderAxisjquery-ui-1.8.12.custom.min.js:161
 e.widget._createjquery-ui-1.8.12.custom.min.js:161
 b.Widget._createWidgetjquery-ui-1.8.12.custom.min.js:30
 b.widget.b.(anonymous function).(anonymous
 function)jquery-ui-1.8.12.custom.min.js:28
 b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
 e.extend.eachjquery.min.js:2
 e.fn.e.eachjquery.min.js:2
 b.widget.bridge.b.fn.(anonymous function)jquery-ui-1.8.12.custom.min.js:29
 c.widget._makeResizablejquery-ui-1.8.12.custom.min.js:387
 c.widget._createjquery-ui-1.8.12.custom.min.js:380
 b.Widget

Re: [Dhis2-users] Reports - where's the data?

[Ola Hodne Titlestad]

That's great.
Mydatamart is a tool that allows the users to have local copies of the
server's datamart with all the relevant local data stored on the user's
machine. This data can then be used in offline data analysis tools like the
Exel PivotTable.
Ola
On Mar 21, 2012 12:06 AM, Mark Spohr mhsp...@gmail.com wrote:

 We've got data!!

 Thanks everyone for your help.  I was confused and thought the Datamart
 utility was for the external program MyDatamart.  I ran it and now my
 reports have actual data in them.  This is a big improvement.  I've set up
 scheduling to keep it up to date.

 I also love the Data Visualizer... quite posh!

 Thanks again,
 Mark

 On Tue, Mar 20, 2012 at 3:02 AM, Ola Hodne Titlestad ol...@ifi.uio.nowrote:

 HI Mark,

 (copying dev list also since many people ask about this)

 Here are datamart instructions for version 2.7:

 *Automatic datamart:*
 (2.6 and 2.7)
 For servers we recommend you use the automatic scheduled datamart (runs
 at midnight every day).
 This can be configured in Data Administration-Scheduling. (see user
 manual section 19.19)
 It is correctly set up when it says Scheduling is running - which means
 that DHIS is scheduled to run a datamart export the next (and every)
 midnight. No need to click on Execute now (that starts the datamart process
 immediately, but this is sometimes needed as well)
 Note that this scheduled datamart will export maximum data for 12 months
 back in time, (but will not delete older data). If you have an empty
 datamart and have data older than 12 months you should use the manual
 approach (see below) for those months that are older than 1 year.
 How fast this scheduled datamart export process is will really depend on
 your CPU and Memory, but it will most likely take a while. In the tomcat
 log you can follow progress and CPU and memory use etc.

 *Manual datamart:*
 (this is or 2.7)
 If you need to do manual datamart exports these are now possible from
 Reports-Datamart, but this is more simple now, it takes all data within
 the period you specify. This has been made much easier now.
 (see section 13.2.1 in the user manual, it has been updated to this new
 datamart window).

 (2.6)
 A bit more complicated UI for datamart export accessed under
 Services-Datamart
 Here you can select exactly what you want to export. Note that this
 export (2.6 and earlier) does not rebuild indexes on the datamart tables.
 After an export, go to Maintenance-Data Administration-Maintenance: and
 tick Rebuild datamart indexes. Without that last step the reports will be a
 lot slower, especially on a multi-user environment.

 Ola
 ---

 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


 On 20 March 2012 09:49, Shinichi Suzuki shin...@gmail.com wrote:

 Report data will generate from entered data by nightly batch job,
 usually.

 You must go to data administration module, then Scheduling. It should
 be on automatically. But it might run out of memory as it uses a lot of
 resources.

 Please try this.

  Suzuki

 *From:* dhis2-users-bounces+shin461=gmail@lists.launchpad.net[mailto:
 dhis2-users-bounces+shin461=gmail@lists.launchpad.net] *On Behalf
 Of *Mark Spohr
 *Sent:* Tuesday, March 20, 2012 8:00 AM
 *To:* dhis2-users@lists.launchpad.net
 *Subject:* [Dhis2-users] Reports - where's the data?

 ** **

 Ok, I'm feeling quite stupid here.
 We've been entering monthly data for 2011 with a form and we can view
 this using the Dataset report and it aggregates for province and for
 quarters and years.
 Now, I want to put together some reports.
 I try the Standard report... this requires a Table.
 I put together a Table report and run it... nice table with data
 elements, org units and periods... but no data! (blank, nada).
 I look at the web Pivot tables and run a few... nice pivot tables, rows,
 columns, periods... no data!... blanks... not even a single number anywhere!

 What am I missing here?

 .Mark


 --
 Mark Spohr, MD
 mhsp...@gmail.com
 +1 530 554 2230

 **
 **

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





 --
 Mark Spohr, MD
 mhsp...@gmail.com
 +1 530 554 2230




___
Mailing list: https://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] Reports - where's the data?

[Ola Hodne Titlestad]

HI Mark,

(copying dev list also since many people ask about this)

Here are datamart instructions for version 2.7:

*Automatic datamart:*
(2.6 and 2.7)
For servers we recommend you use the automatic scheduled datamart (runs at
midnight every day).
This can be configured in Data Administration-Scheduling. (see user manual
section 19.19)
It is correctly set up when it says Scheduling is running - which means
that DHIS is scheduled to run a datamart export the next (and every)
midnight. No need to click on Execute now (that starts the datamart process
immediately, but this is sometimes needed as well)
Note that this scheduled datamart will export maximum data for 12 months
back in time, (but will not delete older data). If you have an empty
datamart and have data older than 12 months you should use the manual
approach (see below) for those months that are older than 1 year.
How fast this scheduled datamart export process is will really depend on
your CPU and Memory, but it will most likely take a while. In the tomcat
log you can follow progress and CPU and memory use etc.

*Manual datamart:*
(this is or 2.7)
If you need to do manual datamart exports these are now possible from
Reports-Datamart, but this is more simple now, it takes all data within
the period you specify. This has been made much easier now.
(see section 13.2.1 in the user manual, it has been updated to this new
datamart window).

(2.6)
A bit more complicated UI for datamart export accessed under
Services-Datamart
Here you can select exactly what you want to export. Note that this export
(2.6 and earlier) does not rebuild indexes on the datamart tables.
After an export, go to Maintenance-Data Administration-Maintenance: and
tick Rebuild datamart indexes. Without that last step the reports will be a
lot slower, especially on a multi-user environment.

Ola
---

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 20 March 2012 09:49, Shinichi Suzuki shin...@gmail.com wrote:

 Report data will generate from entered data by nightly batch job, usually.
 

 You must go to data administration module, then Scheduling. It should be
 on automatically. But it might run out of memory as it uses a lot of
 resources.

 Please try this.

  Suzuki

 *From:* dhis2-users-bounces+shin461=gmail@lists.launchpad.net [mailto:
 dhis2-users-bounces+shin461=gmail@lists.launchpad.net] *On Behalf Of *Mark
 Spohr
 *Sent:* Tuesday, March 20, 2012 8:00 AM
 *To:* dhis2-users@lists.launchpad.net
 *Subject:* [Dhis2-users] Reports - where's the data?

 ** **

 Ok, I'm feeling quite stupid here.
 We've been entering monthly data for 2011 with a form and we can view this
 using the Dataset report and it aggregates for province and for quarters
 and years.
 Now, I want to put together some reports.
 I try the Standard report... this requires a Table.
 I put together a Table report and run it... nice table with data elements,
 org units and periods... but no data! (blank, nada).
 I look at the web Pivot tables and run a few... nice pivot tables, rows,
 columns, periods... no data!... blanks... not even a single number anywhere!

 What am I missing here?

 .Mark


 --
 Mark Spohr, MD
 mhsp...@gmail.com
 +1 530 554 2230

 **
 **

 ___
 Mailing list: https://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] Population

[Ola Hodne Titlestad]

Hi Mark,

Just to add one more thing to what Jason wrote.

Typically the population data sets are yearly, while the numerator data is
most likely monthly or quarterly.

To be able to do data analysis on coverage rates within the normal 0-100%
range the indicators have a property called annualized.
If you set annualized to 'Yes' for an indicator then a relative
annualization factor will be added to the indicator calcuation each time a
new value is calculated.

Let's say you have an indicator BCG coverage 1 year (%) with a numerator
BCG doses administered 1 year (collected monthly) and denominator
Population 1 year (collected yearly), and an indicator type '%' with
factor=100.

The calculation of the monthly indicator value for BCG coverage 1 year
(%) would be 100 x 12 x (BCG doses administered 1 y / Population  1
year).

The quarterly indicator calculation would be 100 x 4 x (BCG doses
administered / Population  1 year) etc.

Ola
-

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 9 March 2012 06:31, Jason Pickering jason.p.picker...@gmail.com wrote:

 Yes, that is the point. Each orgunit should have a population for a
 specified time period (for instance, yearly population values).  So,
 the indicator formula would look something like this

 Numerator = Whatever data element
 Denominator = Population


 If you enter at level 3, you will not be able to get level 4
 indicators, but values will be able to be aggregated up the hierarchy.



 On Fri, Mar 9, 2012 at 7:20 AM, Mark Spohr mhsp...@gmail.com wrote:
  Except each org unit will have population.
  How do you specify which to use in an indicator? ... will these be
  aggregated? ... what if no low level numbers?
 
  Mark Spohr MD
 
  On Mar 8, 2012 9:10 PM, Jason Pickering jason.p.picker...@gmail.com
  wrote:
 
  Create a new data element called Population. Probably want to use
  Average as an aggregation operator here. Add it to a dataset like
  any normal data element and enter the data through the data entry
  screen. :)
 
 
  On Fri, Mar 9, 2012 at 7:01 AM, Mark Spohr mhsp...@gmail.com wrote:
   I am probably missing something obvious here but where do you enter
   population numbers for organization units to use as denominators for
   indicators?
  
   Mark Spohr MD
  
  
   ___
   Mailing list: https://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] Can't get Data Visualizer Module to display any data

[Ola Hodne Titlestad]

Hi Adolphe,

Are you running DHIS on your local machine?

Sounds like you have not managed to update DHIS correctly then.

These are the steps to follow:
- stop tomcat
- delete webapps/dhis folder and webapps/dhis.war file
- put the new dhis.war file in webapps/
- start tomcat

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 7 March 2012 12:10, Kamugunga Adolphe kaa...@gmail.com wrote:

 Probably there is something wrong with this version 2.6! i have the same
 problem! but the system displays this error massage Problem importing
 metadata near,: syntax error  . Trying to go about it, i cleared cache
 memory and restart Tomcat, in vain, but late i find that the system still
 displays 2.5 version from about dhis2 submenu while iknow i am using 2.6
 war file, the same massage  comes when i also tried with 2.7 war file!

 Does any one knows how to deal with it or have the same  situation?

 Adolphe


 On 2 March 2012 19:11, Jason Pickering jason.p.picker...@gmail.comwrote:

 Are you sure the datamart has been configured to aggregate data to the
 desired level?

 --
 Sent from my mobile
 On Mar 2, 2012 6:21 PM, Wilson,Randy rwil...@msh.org wrote:

  We’re trying to rebuild our dashboards with charts produced with the
 data visualizer in Version 2.6.

 ** **

 I’m trying to build charts using data elements.  To ensure I see data,
 I’m picking national level for the org unit and selecting this year as the
 time period for which I clearly see data in the dataset reports. 

 ** **

 When I press update, I get the “No data” message. It doesn’t seem to
 make any difference which data element I select. Over 100 facilities have
 already entered their data for January.

 ** **

 Any suggestions??  

 ** **

 Randy Wilson

 Rwanda/HMIS team

 ___
 Mailing list: https://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] Need some help

[Ola Hodne Titlestad]

If it is only 10 facilities you need I would go with the mydatamart
approach and select 1 facility at a time and download their data into the
same local datamart and then create a pivot table on top of that. A bit
cumbersome, but this requires no extra query on the server side.
More long term we are planning filters in mydatamart to more easily
download subsets of facilities or data elements. Right now you can download
all data for 1 facilty or for all facilities in an area(parent,grandparent
etc).

Ola
 On Feb 14, 2012 9:13 PM, Lars Helge Øverland larshe...@gmail.com wrote:
___
Mailing list: https://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] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

[Ola Hodne Titlestad]

Hi Beatrice,
I think you might have selected too much data for download. If you are
downloading data for the Kenya orgunit you should not select facility as
the analysis level, it will be way too much to download. Try to use
district or county level instead. Or if you need facility level, first
select e.g. a district as your orgunit to narrow down the amount of data.
Also try just a few months as Jason suggests. If it doesn't work out there
is a great team of pivot and mydatamart experts at the HMIS division if you
are still in Nairobi.
Ola
On Jan 15, 2012 2:36 PM, Jason Pickering jason.p.picker...@gmail.com
wrote:

 Hi Beatrice,

 Nice to hear from you again. :)

 The better solution would be to use the MyDatamart tool described here

 http://dhis2.org/doc/snapshot/en/user/html/apb.html


 This tool will provide you with a normal pivot table, which can be
 manipulated as per normal by users.


 Best regards,
 Jason


 On Sun, Jan 15, 2012 at 2:27 PM, Beatrice Ngatia bnga...@gmail.com
 wrote:
  Hi All,
 
  I am trying to use the DHIS2 Pivot Tables and encountering some
 challenges.
 
  The challenge lies with the End-Product i.e. the Excel sheet produced
 once I
  follow the  select Data  Pivot  Download to Excel process.  While
  I successfully select my pivoting parameters and the table produced on
 DHIS
  seems excellent, My problem is that the resultant Pivot table (once I
 click
  download to Excel exports each month to its own separate worksheet and
 not
  onto one combined worksheet where I can then proceed to pivot the data as
  desired.
 
  Is this the current set-up within DHIS2 or am I missing a step?
 
  It seems to make sense to me to have all the data exported into one
  worksheet, and then pivoted by users as need be.
 
  Please Advise.
 
  Thanks,
 
  Beatrice
 
 
 
 
  ___
  Mailing list: https://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

[Dhis2-users] Date validation in Tracker data entry - problematic and confusing

[Ola Hodne Titlestad]

 around these date validations.

Anyway this is actually a good example where some kind of date validation
makes sense, but it could maybe be implemented as a validation rule between
two data elements Birth date and BCG dose received date in stead of
this Due date thing.

So if people agree with me that we should remove the general date
validation rules A and B above, then we should think of how we can provide
validation of dates for the use cases where it makes sense. Some ideas:

i) Maybe it makes sense for some programs like ANC or Child Immunisation to
put some time limit on the dates, since we know that the data for a
pregnant woman should not not receive services much later than 9 months
after the start of the pregnancy. Then we first of all need to find out
what the date of the service/visit is, since that is the only date that it
makes sense to check. This could be an optional property of a program stage
instance, not sure.

ii) For dates for values of individual data elements what to check for will
completely depend on the meaning of the data element. The data element
could ask for a date in the past, a date in the future, or which is the
most likely the date a specific service (e.g. a dose of Measles) was given.
But since we cannot assume that all data elements are the same, we need to
come up with a more custom way of defining this validation. Maybe some kind
of validation rule specific to data elements with value type Date, e.g.
Must be earlier than the current date.

Any thoughts on this? Hope this was not too confusing, it took me some time
to get through this jungle of terms, rules, and messages in this module.

It is all just too confusing and not very user-friendly at the moment I am
afraid.

Ola
-


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway
___
Mailing list: https://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 Update to 2.6

[Ola Hodne Titlestad]

On 3 January 2012 13:54, Knut Staring knu...@gmail.com wrote:

 Hello, as Andrew says, it is mostly a matter of replacing the war file.

 If you are running Tomcat, first stop it and move your current war file
 somewhere else so you have it as backup if there is a problem. Then place
 the new war file and restart tomcat.


And remember to delete the webapps/dhis folder as part of the replace the
war file procedure before starting up tomcat again.

Ola
-




 Knut


 On Tue, Jan 3, 2012 at 1:17 PM, Muhire Andrew muhireand...@yahoo.comwrote:


 Dear Robert, just go in your dhis folder or apache tomcat and paste that
 war file(dhis.war) in webapps!..it wil work.

 --On Tue, Jan 3, 2012 2:56 AM PST Robert G.
 Mesleh Jr. wrote:Hi All, I have tried ways to update my dhis2 to the
 2.6 but I don't see it workingfor me.Can someone give me clear
 instructions on how to update? 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




 --
 Knut Staring
 Informatics, U. of Oslo
 http://hisp.uio.no
 +4791880522


 ___
 Mailing list: https://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] DHIS version 2.6 released

[Ola Hodne Titlestad]

Great work!

Ola
On Dec 27, 2011 4:42 PM, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi all,

 DHIS version 2.6 is released. We have a long list of improvements:

 1. A new Web API module which provides read access to most objects in
 the system and read access to data values and messages: All resources
 are uniquely identified by URLs and have a rich set of representation
 formats; currently HTML, XML, JSON and JSONP. The resources are linked
 and navigable meaning that you can easily move between related
 resources using hyperlinks (for instance from the list of data sets to
 one particular data set, then to one particular data element). Certain
 resources (map, chart, report, report table and resource) have a
 special view of the aggregate data (rather than the meta-data info)
 which can be accessed by appending /data to the URL.

 The primary purpose of the Web API is to make DHIS suitable as a
 platform for third-party software clients and systems such as Web
 portals, content management systems, dashboards and mobile device
 clients. It provides a machine-readable API from where such clients
 can retrieve the desired data over the well-known HTTP protocol,
 without need for any knowledge of the DHIS internal technologies and
 implementation. You can explored it here:

 http://apps.dhis2.org/demo/api/resources
 http://apps.dhis2.org/demo/api/charts/j1gNXBgwKVm
 http://apps.dhis2.org/demo/api/maps/H6jRsZXfDAp

 A small demo on how reports, charts and maps produced by DHIS can be
 embedded in a Web portal can be found here:

 http://dhis2.org/portal

 A more detailed write-up of the purpose and context of the Web API can
 be found here:

 http://dhis2.org/doc/snapshot/en/implementer/html/full.html#d5e1545


 2. Saved charts in data visualizer module: After creating a chart and
 data table you can now save it as a favorite by clicking on the
 Favorites button in the top menu, then on Manage favorites. This
 makes it easy to later reload your chart and also put it on your
 personal dashboard in the dashboard module. Favorites can be saved as
 personal or system views (if user is authorized). This means that
 users can create their own personal charts without affecting the list
 of charts for other users.

 The old chart user interface in reporting module has been removed -
 the data visualizer module is now the place to create charts. Please
 note the new Chart options panel on the left menu - all options from
 the old charts are there but at the moment only implemented in the
 image  version of the charts (accessible from the dashboard). We will
 soon implement these options in the client-side charts in data
 visualizer module in order to make both versions compatible.

 http://apps.dhis2.org/demo/dhis-web-visualizer/app/index.html

 http://dhis2.org/doc/snapshot/en/user/html/full.html#d927e2985


 3. Anonymous events: The beneficiary module now provides functionality
 for registering anonymous events. Use-cases for such events are birth
 certificates, nutrition surveys and inpatient morbidity/mortality
 registries. Data for any number of data elements can be defined and
 registered for a single event (no attributes).

 Programs must be marked as single event and anonymous in
 beneficiary module. Under Event registration in data records module
 you can register the anonymous events. Start by clicking on Create
 new event, then fill the entry form before clicking Complete data
 entry.

 http://apps.dhis2.org/demo/dhis-web-caseentry/anonymousRegistration.action

 (Select e.g. the first facility in the tree, Ngelehun CHC.)


 4. Organisation unit group set analysis in data mart and report table:
 The data mart engine now produces two new data mart tables for data
 element and indicator data aggregated by organisation unit groups. In
 more detail, for all organisation units there are records for all
 organisation unit groups. This feature has currently been implemented
 in the report table tool. You can include groups by clicking on
 Toggle organisation unit groups in the add new report table screen.
 We will implement support for groups in most analysis tools for next
 release. Please note that only groups which are members of a group set
 will be included.

 This feature is particular useful for doing analysis based on facility
 classification such as type and ownership; for instance you can now
 investigate the immunization rates in public, private and faith-based
 facilities within a province and see how they compare. It can also
 support scenarios where donors want to analyse and compare the
 performance of their implementing partners.

 http://apps.dhis2.org/demo/api/reports/KlcaBsIqTV4/data


 5. I18n: The user interface is now completely translated into French.
 This will be very useful for the upcoming DHIS implementations in West
 Africa. Thanks to Jason Pickering for managing this process.


 http://apps.dhis2.org/demo/dhis-web-maintenance-settings/userGeneralSettings.action


 6. Image 

Re: [Dhis2-users] Upgrade 2.0.4 to 2.4

[Ola Hodne Titlestad]

Hi Mark,

I got it up an running with the latest 2.5 build.
(can be downloaded here:
http://apps.dhis2.org/ci/job/dhis-web-2.5/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war)
Should be the same as on dhis2.org/downloads

It seems to run fine, I have been through data entry, data set reports,
data element and orgunit maintenance without any errors so far.

I need some more information about your crashes, so can you please locate
the logs under tomcat-installation-directory/logs
If they are not too big you could zip them all together and send me.

Ola
---

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 16 November 2011 06:01, Mark Spohr mhsp...@gmail.com wrote:

 Hi Ola,
 I would like to impose upon you to take a look at our database.
 This was originally set up under 2.0.4 and we would like to run it under
 the latest 2.5
 The database as is does run under 2.5 but it crashes at odd times (mostly
 when doing maintenance and reports).  Data entry seems to work well.
 I'd appreciate it if you could take a look at this and see what would be
 involved to update it to 2.5.  It's a fairly simple installation with only
 one data entry form and not much in the way of reports.  It includes some
 historical data from 2008 and 2009.
 This is a Postgres pg_dump file.

 Thanks very much,
 Mark


 On Mon, Oct 10, 2011 at 1:16 PM, Ola Hodne Titlestad ol...@ifi.uio.nowrote:

 Hi Mark,

 This upgrade is a difficult one as there have been many major changes to
 the database model since 2.0.4.
 If this 2.0.4 database uses data element categories (other than the
 default), then it might require quite a lot of manual database fixing to
 get it over to the latest version.

 You can always try to start up 2.4 with your database (take a backup
 first), and see what happens (I guess this has failed already since you
 post this question here).
 Pay attention to the tomcat log during the startup routines.

 If it fails you can post the error messages here, or it might be better
 you just send me your database and I can give it a try.

 Ola
 --

 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


 On 10 October 2011 22:02, Mark Spohr mhsp...@gmail.com wrote:

  I am working on a system which was originally set up with version 2.0.4
 and wish to install the latest (2.4) .
 Is there anything that needs to be done to upgrade the data for the new
 version?  Will this be handled somehow?

 Thanks,
 Mark

 --
 Mark Spohr, MD


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





 --
 Mark Spohr, MD


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

Re: [Dhis2-users] [Dhis2-devs] Data visualizer module feedback

[Ola Hodne Titlestad]

Hi Jan,

Some new requests from Kenya:

1) Option to put values on the bars in the chart.

2) Option to switch from colour scheme to a pattern scheme (e.g. dots,
vertical lines, horizontal lines etc.) to distinguish between bars in a
chart when printing in blackwhite mode.

3) Would it be possible to combine indicator and data element into one
object/option in the drop downs for Series, Category, Filter (top of the
page)? This makes sense as you never do a chart with indicators as Category
and data element as Filter or Series. Now the tool complains with Form is
not complete if you select a few data elements and no indicators, and
forget to switch from Indicator to Data Element on e.g. the Series.
Seems unnecessary to force the user to do this switch.

4) Generally the users are happy with this and really appreciate the
possibility of creating and manipulating their own charts. And although
screenshots are always possible they almost can't wait to see the save as
image button on the next release

Good work, keep it up!

Ola
---


--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 5 November 2011 12:29, John Ojo jn...@yahoo.com wrote:

 Thanks Jan. We look forward to the improvements in the coming versions.
 John.

 --
 *From:* Jan Henrik Øverland janhenrik.overl...@gmail.com
 *To:* John Ojo jn...@yahoo.com
 *Cc:* Lars Helge Øverland larshe...@gmail.com; DHIS 2 developers 
 dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net 
 dhis2-users@lists.launchpad.net
 *Sent:* Friday, November 4, 2011 6:16 PM
 *Subject:* Re: [Dhis2-devs] [Dhis2-users] Data visualizer module feedback

 Hi John, thanks for the quick response. Please see my comments below.

 On Fri, Nov 4, 2011 at 18:12, John Ojo jn...@yahoo.com wrote:

 Hi Lars,

 The data visualizer looks great. Would like to suggest the following:

 1. Please kindly remove the data visualizer from among the options for
 Start page under the Appearance settings page. This is because,
 like we had in the past with the GIS module, the data visualiser loops
 back to itself and effectively locks the user out from being able to
 exit from the data visualizer once it is selected as the start page. You
 may try it and see.

 2. Ability to insert charts drawn in the data visualizer into the
 dashboard.


 Yes, we are planning a new dashboard and this is the main reason.





 3. Chart Title (and may be sub-title) for the data visualizer charts.


 The ExtJS chart engine does not offer a dedicated title option, but I just
 found a way to work around it so this will be available in trunk shortly.
 Currently, the chart title is simply displayed on the toolbar, next to the
 update button.



 4. The Chart Type buttons/icons on the top-left portion of the data
 visualizer window don't seem to do anything. Would like to see the
 Example chart change to reflect the user's choice when any of the
 chart type icons is selected.


 The visualizer is designed to be as network friendly as possible. That's
 why the chart type buttons don't execute anything (just think of them as a
 way to select the chart type). The chart is not updated unless the user
 specifically clicks the update button. Otherwise, if the user e.g. wants
 a different chart type and different indicators, and selects the chart type
 first, the chart is unnecessarily updated (and data transferred) twice.



 5. The message in the information box eg. '*No data values*',  '*Form is
 not complete*', that appears when one clicks the Update button
 is too short (and cryptic). We should consider adding more details as
 to what the user should do to get the visualizer display the chart
 depending on the circumstance.


 Improved notifications is already on the 2.6 roadmap. In trunk the Form
 is not complete is replaced by something a bit more informative, like No
 indicators selected, No data elements selected etc, but this will
 definitely be improved further.



 These are the few that readily comes to mind. May add more as I take the
 data visualizer through much deeper tests.


 Please feel free to provide feedback any time.


 Thank you so much to all the developers for making our lives easier with
 DHIS2.


 John.
 *From:* Lars Helge Øverland larshe...@gmail.com
 *To:* DHIS 2 developers dhis2-d...@lists.launchpad.net;
 dhis2-users@lists.launchpad.net
 *Sent:* Friday, November 4, 2011 2:08 PM
 *Subject:* [Dhis2-users] Data visualizer module feedback

 Hi all,

 now that you have had some time to get familiar with the new data
 visualizer module we are interested in getting feedback and
 suggestions for improvements based on real use-cases.

 You can explore the module here:

 http://apps.dhis2.org/demo/dhis-web-visualizer

Re: [Dhis2-users] [Dhis2-devs] Data visualizer module feedback

[Ola Hodne Titlestad]

On 10 November 2011 12:15, Jan Henrik Øverland janhenrik.overl...@gmail.com
 wrote:



 On Thu, Nov 10, 2011 at 10:54, Ola Hodne Titlestad ol...@ifi.uio.nowrote:

 Hi Jan,

 Some new requests from Kenya:

 1) Option to put values on the bars in the chart.


 Already on the 2.6 roadmap.


Great.





 2) Option to switch from colour scheme to a pattern scheme (e.g. dots,
 vertical lines, horizontal lines etc.) to distinguish between bars in a
 chart when printing in blackwhite mode.


 Hm, interesting. I will investigate this.



 3) Would it be possible to combine indicator and data element into one
 object/option in the drop downs for Series, Category, Filter (top of the
 page)? This makes sense as you never do a chart with indicators as Category
 and data element as Filter or Series. Now the tool complains with Form is
 not complete if you select a few data elements and no indicators, and
 forget to switch from Indicator to Data Element on e.g. the Series.
 Seems unnecessary to force the user to do this switch.


 What If the user has selected a couple of indicators *and* data elements?
 If the user wants to switch between the selected indicators and data
 elements - should we force him to deselect and reselect every time?


I was thinking that you would always show all selected data elements and
indicators together on the same dimension/chart position.

Although I agree that it can be useful to quickly switch between already
selected data elements and indicators, I think it will be even more useful
to be able to show them both at the same time, especially now that we treat
calculated data elements as indicators (many indicators are counts just
like data elements).

Ola







 4) Generally the users are happy with this and really appreciate the
 possibility of creating and manipulating their own charts. And although
 screenshots are always possible they almost can't wait to see the save as
 image button on the next release


 Glad to hear that people like it. Image export is obviously on the 2.6 rm
 already :)



 Good work, keep it up!

 Ola
 ---


 --
 Ola Hodne Titlestad (Mr)
 HISP
 Department of Informatics
 University of Oslo

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway



 On 5 November 2011 12:29, John Ojo jn...@yahoo.com wrote:

 Thanks Jan. We look forward to the improvements in the coming versions.
 John.

 --
 *From:* Jan Henrik Øverland janhenrik.overl...@gmail.com
 *To:* John Ojo jn...@yahoo.com
 *Cc:* Lars Helge Øverland larshe...@gmail.com; DHIS 2 developers 
 dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net 
 dhis2-users@lists.launchpad.net
 *Sent:* Friday, November 4, 2011 6:16 PM
 *Subject:* Re: [Dhis2-devs] [Dhis2-users] Data visualizer module
 feedback

 Hi John, thanks for the quick response. Please see my comments below.

 On Fri, Nov 4, 2011 at 18:12, John Ojo jn...@yahoo.com wrote:

 Hi Lars,

 The data visualizer looks great. Would like to suggest the following:

 1. Please kindly remove the data visualizer from among the options for
 Start page under the Appearance settings page. This is because,
 like we had in the past with the GIS module, the data visualiser
 loops back to itself and effectively locks the user out from being able to
 exit from the data visualizer once it is selected as the start page.
 You may try it and see.

 2. Ability to insert charts drawn in the data visualizer into the
 dashboard.


 Yes, we are planning a new dashboard and this is the main reason.





 3. Chart Title (and may be sub-title) for the data visualizer charts.


 The ExtJS chart engine does not offer a dedicated title option, but I
 just found a way to work around it so this will be available in trunk
 shortly. Currently, the chart title is simply displayed on the toolbar,
 next to the update button.



 4. The Chart Type buttons/icons on the top-left portion of the data
 visualizer window don't seem to do anything. Would like to see the
 Example chart change to reflect the user's choice when any of the
 chart type icons is selected.


 The visualizer is designed to be as network friendly as possible. That's
 why the chart type buttons don't execute anything (just think of them as a
 way to select the chart type). The chart is not updated unless the user
 specifically clicks the update button. Otherwise, if the user e.g. wants
 a different chart type and different indicators, and selects the chart type
 first, the chart is unnecessarily updated (and data transferred) twice.



 5. The message in the information box eg. '*No data values*',  '*Form
 is not complete*', that appears when one clicks the Update button
 is too short (and cryptic). We should consider adding more details
 as to what the user should do to get the visualizer display the chart

Re: [Dhis2-users] How to set up Mydatamart and dhis-live 2.5

[Ola Hodne Titlestad]

Hi Adolphe,

If you have an online DHIS 2 server running, there is no need to install
DHIS2 live on regional data mangers' laptops for Excel pivots to work. The
mydatamart tool can connect to the online server and download the data they
want into a local datamart (sql lite database), and then Excel will pull
data from the local datamart.

For this to work the regional data managers will need an internet
connection when downloading data (using mydatamart), and there must be an
online server running somewhere that mydatamart can connect to. After the
download the user can do offline data analysis in Excel.

You can also use mydatamart together with an offline DHIS live install, but
this is not recommended if there is already an online server running and
the local user has access to internet.

With DHIS Live + mydatamart in a completely offline scenario you will then
have to maintain the DHIS live database (and datamart) first and make sure
that it is updated and has all the data you need (e.g. import from district
export files). Then you can use mydatamart to simplify the transfer of data
into Excel.

The mydatamart tool was first of all built to support users of an online
DHIS deployment, to allow them to keep a local updated copy of the data
that e.g. can be used to populate Excel pivot tables (and then enable
offline data analysis).

Ola
-

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 8 November 2011 17:17, Kamugunga Adolphe kaa...@gmail.com wrote:

 Hi all,
 I am trying to set up  dhis-live 2.5 instances to facilitate practices of
 the regional data managers while at home, any idea on how to use
 mydatamart  to extract data into a excel  pivot table? i tried this URL
 http://127.0.0.1:8080/dhis but in vain, the system pops up a massage of
 wrong URL.

 Waiting for hearing from u soon.

 Adolphe



 On 8 November 2011 00:18, Mark Spohr mhsp...@gmail.com wrote:

 We've updated our installation in the Solomons from 2.0.4 to 2.5 without
 making any database changes and it runs but occasionally crashes.  (We also
 updated Postgres and Apache to latest versions.)
 I am thinking that there may be some changes to the database structures
 causing the problem. I would like to compare the 2.0.4 database structures
 which I have from a pg_dump to the current 2.5 database structures.  Anyone
 know of an easy way to do this or if this information already exists
 somewhere?

 Regards,
 Mark

 --
 Mark Spohr, MD


 ___
 Mailing list: https://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] Help Required

[Ola Hodne Titlestad]

 /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
dhis found your hibernate.properties file or not, and tell you if the
DHIS2_HOME was recognised or not.

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to be
 picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for testing
 purposes but might happen because your database configuration was not picked
 up. Please make sure this is intentional. Your data will be destroyed when
 the application shuts down.

 My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 *You can do anything, but not everything.*



 ___
 Mailing list: https://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 in Solomons

[Ola Hodne Titlestad]

Hi Mark,

Can't find any reference to a Make Nield in my mail archive, but we got an
email to this list from an NGO operating on Papa New Guinea in February:
https://lists.launchpad.net/dhis2-users/msg00249.html

(as you see the sender's email address is hidden, I'll send his email
address in a private email to you.

Ola
---

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 5 September 2011 20:54, Mark Spohr mhsp...@gmail.com wrote:

 Hi All,
 I am in the Solomon Islands looking at their HIS.  It seems that a person
 named Mike Nield installed and configured DHIS here last year but it wasn't
 put into production due to server problems.
 I'd like to get this running and it would be useful to talk with this
 person but haven't found his contact information.  They only email I have is
 an old Solomon Islands Ministry of Health email which is not longer active.
 Does anyone know how to contact Mike?  I believe he is Australian.

 All the best,
 Mark

 --
 Mark Spohr, MD


 ___
 Mailing list: https://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] DHIS 2 Live

[Ola Hodne Titlestad]

Hi Olav,

A recommended setup for offline district offices (at least of some size) is
to use a local network with 1 ubuntu server running DHIS 2 and multiple
clients (mostly Windows), allowing users to share the same
installation/database of DHIS. Often there are more than one DHIS user at
the district office and this setup provide more flexibility and access to
the data. Having the DHIS run on a virus-free ubuntu machine compared to a
Windows machine makes a huge difference in terms of tech support needs and
DHIS 2 up time. Of course setting up a local network requires some more
initial tech work, but in the long run it is probably worth it.

This has been used in the offline deployment in Sierra Leone.

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 19 August 2011 13:46, Olav Poppe olav.po...@gmail.com wrote:

 Yes, sounds like disabling some modules might be something to consider.
 We're waiting for a document detailing the connectivity at various offices
 at the moment, hopefully that will give a better overview of how big issue
 this will be.

 As for the HW, the only thing I know at the moment is that the machines
 (windows) running the current system will be used for DHIS 2 as well. So it
 will probably vary quite a bit from location to location.

 Olav

 Den 18. aug. 2011 kl. 15:34 skrev Bob Jolliffe:

  On 18 August 2011 16:14, Knut Staring knu...@gmail.com wrote:
  On Thu, Aug 18, 2011 at 4:25 PM, Bob Jolliffe bobjolli...@gmail.com
 wrote:
 
  On 18 August 2011 14:40, Olav Poppe olav.po...@gmail.com wrote:
  I wonder about the merits of a stripping out the metadata maintenance
  modules in a such a lite-lite install?  Not sure how crippling this
  would be.  Metadata import being the only way to update metadata.
  Maybe that's too draconian but it could work for ultra-offline data
  entry.
 
  I would recommend being quite draconian and pretty much disable the
 whole
  Maintenance menu and quite a bit of the services menu as well. And then
  train them really well on the remaining parts, and creating a targeted,
  short and simple manual (ideally accompanied by some video clips) so
 that
  support can be kept to a minimum (or at worst done over the phone).
 
  And I thought I was the draconian one :-)  Still if its only a matter
  of removing some modules from a custom pom it could be worth looking
  at.  Olav maybe you want to try and see how it looks.
 
  The emphasis on eliminating moving parts and sources of error of course
 also
  harks back to you DHIS appliance idea, Bob. One could even think of
  running DHIS Live with H2 off USB sticks (though they are flimsy), which
  could even be made to boot up something like DamnedSmallLinux.
 
  I'm not too convinced by the usb stick idea.  Not that its not doable.
  And I think its probably great for demos (WHO-on-a-stick) but in
  real-life I don't think these sticks are well suited for database
  read-writes.
 
  One of the issues people do tend to have with h2 is a lack of
  supporting tools to diagnose when things go wrong.  And I'd hate to be
  on the phone to someone stepping through openoffice+jdbc setup or the
  like.  If I were to ship h2 into the darkness of many remote districts
  I think I would write a couple of really simple and small diagnostic
  tools to test the integrity and health of the database and ship that
  too.  Just the where there is no doctor common sorts of faults.
  Then when I get the call help!  my dhis2-ultra-lite doesn't work,
  I'd ask them to run the diagnostic tool and read out the diagnosis
  over the phone to quickly figure out if the h2 file is corrupted, or
  metadata is misconfigured or what have you.  Planning for 170 offline
  installs (or some reasonable proportion of that number) is no picnic.
  The more work up front to make those calls easier the better.
 
  Cheers
  Bob
 
  Knut
 
 
  Bob
 
  Olav
 
  Den 18. aug. 2011 kl. 13:32 skrev Jason Pickering:
 
  I agree with both Bob and Ola.
  We have tried not quite yet succeeded in getting DHIS2 installed with
  Tomcat/Postgres on Windows with a one-click installer, this my caveat
  about
  a supervised install. There are a lot of things which can happen on
  users
  machines and maintenance becomes a huge issue. DHIS is still under
  intense
  development, and a lot of things change quickly. Upgrading a single
  server
  is a piece of cake. Upgrading dozens or hundreds of off-line machines
 is
  a
  true nightmare and a serious risk and resource drain to any
 deployment.
  I agree with Ola. Totally exclude an on-line server as an option
 first.
  If
  you have already done that, all I can say is, be prepared for a LOT of
  tech
  support.
  Regards,
  Jason
 
  On Thu, Aug 18, 2011 at 3:15 PM, Ola

Re: [Dhis2-users] [Dhis2-devs] Problems deploying DHIS2 2.3-SNAPSHOT

[Ola Hodne Titlestad]

Roger,

If on Windows, try starting up tomcat manually with the startup.bat which
gives you a console where you can monitor the log.
This bat file is usually only available when downloading the zip archive of
the binary distribution:
http://tomcat.apache.org/download-70.cgi (look for the .zip files)

On linux you can run the startup.sh and use e.g. tail -f
tomcat_intstall_dir/logs/catalina.out to get the same.

Make sure the dhis.war is in tomcat/webapps before you start tomcat (and
also delete webapps/dhis if there), and then no need to use the tomcat
manager.

This should tell you more on what is going on.

Ola
-

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 21 June 2011 23:15, Yusuph Kassim yusu...@gmail.com wrote:

 try increasing memory for tomcat, sometimes you get nothing if you dont
 have enought memory ( not even the javaOutOfMemory error)

 cheers

 On Tue, Jun 21, 2011 at 10:17 PM, Jo Størset stor...@gmail.com wrote:


 Den 21. juni 2011 kl. 21.03 skrev Friedman, Roger (CDC/CGH/DGHA) (CTR):

 Sorry, didn't say that I had looked at the logs. 
 Manager shows the stop of /dhis2 but not its start.
 Jakarta looks uneventful
 Catalina looks uneventful
 localhost and stdout have not been modified since the steps
 below


 Strange, it does sound suspiciously like PEBKAC :) Just to verify, your
 war file is about 50 MB in size? And you don't have multiple tomcat
 instances interfering in some way? And you have of course tried restarting
 an extra time? Other than that, I'm afraid I'm not the right person to help,
 as I've never tried the tomcat manager..

 Jo

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




 --
 Yusuph Kassim Kulindwa,
 University of Dar Es Salaam,
 Department of Computer Science,
 System Developer/ Research Assistant.

 Cell: +255 713 535648

 ___
 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] Advice on Population denominators

[Ola Hodne Titlestad]

On 11 May 2011 21:18, Jason Pickering jason.p.picker...@gmail.com wrote:

 Hi Randy,

 We have a similar situation in Zambia. We pre-projected the population
 figures for 2000-2010 (from the 2000 census) using growth figures, and
 then inserted these as normal data elements in the DHIS 2 database.
 AFAIK, DHIS 2 has no ability to project data in the manner which you
 describe. We used external statistical programs, followed by data
 transformation and import to accomplish this task.

 I have filed a blueprint on this topic...

 https://blueprints.launchpad.net/dhis2/+spec/data-projection

 In regards to the use of percentages for different populations, this
 should be possible through the use of indicators. If you have a base
 population and a factor for pregnant women, you would need to enter
 both the population and factor as data elements. The combination of
 the two could then be used as a denominator for instance in ANC
 calculations.


Hi Randy,

I would just enter the factor as a static number into the formula itself. No
need to create a data element and enter values for it.
E.g. Total Population * 0.041 in the denominatior expression for
Population 1 y will give the desired 4.1% of total population.

Also note that when using a data element (and data values) to put the factor
it will be aggregated like any other data element, which you don't want.



 I think the best way would be to pre-project the population figures
 for each year and the factors (pregnant women, WPA, etc) and import
 these for each organisational unit by year into DHIS 2. Then, you can
 use this as the basis for calculations for indicators. This is the
 procedure we use in Zambia, and it works fine.

 Agree with this. Projection inside DHIS is not supported and for now you
will have to enter values for each year.

Ola
-


 Regards,
 Jason



 On Wed, May 11, 2011 at 8:56 PM, Wilson,Randy rwil...@msh.org wrote:
  We’ve been setting up DHIS-2 as a health data warehouse and dashboard for
  Rwanda.  So far it has gone well, but I have found no useful
 documentation
  about how to manage admin unit target populations … crucial for any
 coverage
  indicator calculations.
 
 
 
  Ideally we’d like to store the populations once per org unit – for
 example
  at the year of the national census – and then have a table of parameters
  such as population growth rate, and breakdowns of % population in each of
  the major programmatic target groups (e.g. 4.1% expected pregnancies 
  children 1, 23.6% women of reproductive age, etc..) that can be pulled
 into
  indicator calculations.  I’ve tried to create these parameters as data
  elements, but I can’t seem to use them successfully in the indicator
  definition screens, nor do I have any idea where the population data
 should
  be stored.
 
 
 
  Has anyone done this before?
 
 
 
  Randy Wilson
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 
 



 --
 Jason P. Pickering
 email: jason.p.picker...@gmail.com
 tel:+260974901293

 ___
 Mailing list: https://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] Advice on Population denominators

[Ola Hodne Titlestad]

On 12 May 2011 11:06, Wilson,Randy rwil...@msh.org wrote:

 Thanks Samuel,



 This is very helpful.



 I’ve created data elements in a similar way for each of the population
 estimates.  Do you enter a single record at the national level, or do you
 need to create values for each orgunit in the hierarchy, from health
 facility up to national level?  It would be ideal if we could use one single
 record in the database or perhaps one per year rather than having to create
 hundreds of records with the same values.


Are you talking about the population figures themselves or the parameters
here?

Ola
-





 Randy







 *From:* samuel cheburet [mailto:samuelchebu...@gmail.com]
 *Sent:* Wednesday, May 11, 2011 9:12 PM
 *To:* Wilson,Randy
 *Cc:* dhis2-users@lists.launchpad.net
 *Subject:* Re: [Dhis2-users] Advice on Population denominators



 Thanks Wilson for sharing. I hope kenya  approarch can assist to address
 your need. In addressing population as denominator you require to consider
 the aggregation level either you want health facilities to input their
 catchment population and aggreated upwards to get national aggregate. Note:-
 this approach require careful determination of individual catchment
 population. In Kenya health facilities can input catchment population based
 on previous year coverage of service(contribution to the lowest catchment
 area per census figures) the contibution is applied to near year population.
 NB. The data on pupulation is not aggredated upwards except District
 population which can aggregate upwaards to minimums errors or rounding ups.



 Also in kenya we have CHIS which use actual population because CHEWS visit
 every household and he/she has actual records so there is no need of using
 projection/estimate but the population parameters is same.


 Organisation Unit

 [ Select from tree on the left side ]

 Data Set

 [[ Select data set ] \/]

 Period

 [[ Select period ] \/] [Prev][Next]
 --


 Population estimates

 *Value*

 Population total

 Population female

 Population male

 Households

 Population under 1 year

 Population under 5 years

 Population under 15 years

 Population 15-24 years

 Women of childbearing age (15–49yrs)

 Estimated number of deliveries

 Estimated live births

 Population 25-59 years

 Population over 60 years

 Estimated number of emergency obstetric complications

 Estimated of post abortion cases


 Population parameters

 *Value*

 Area in Kilometer square

 Population Growth Rate

 Household size


 Vitamin A Population Category

 *Value*

 6-11 Months(50%of 1yrs)

 12-59 Month (80% of  5yrs)

 6-59 Months (90% of  5yrs



 Regards



 On Wed, May 11, 2011 at 9:56 PM, Wilson,Randy rwil...@msh.org wrote:

 We’ve been setting up DHIS-2 as a health data warehouse and dashboard for
 Rwanda.  So far it has gone well, but I have found no useful documentation
 about how to manage admin unit target populations … crucial for any coverage
 indicator calculations.



 Ideally we’d like to store the populations once per org unit – for example
 at the year of the national census – and then have a table of parameters
 such as population growth rate, and breakdowns of % population in each of
 the major programmatic target groups (e.g. 4.1% expected pregnancies 
 children 1, 23.6% women of reproductive age, etc..) that can be pulled into
 indicator calculations.  I’ve tried to create these parameters as data
 elements, but I can’t seem to use them successfully in the indicator
 definition screens, nor do I have any idea where the population data should
 be stored.



 Has anyone done this before?



 Randy Wilson


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




 --
 Samuel Cheburet
 Ministry Of Health
 P.O. Box 20781
 Nairobi, Kenya
 Mobile- 0721624338



 *Don't Compromise The Quality! Don't Risk It! apply Available Standards to
 Achieve Your/organizational Goal.*

 ___
 Mailing list: https://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