Re: [Dhis2-users] [Dhis2-devs] Mandatory attributes can not be made optional

[Neeraj Gupta]

Hi Elmarie,
Thanks for the clarification but no, in my case the attributes which are
creating the problem are not part of the Tracked entity.

On Wed, Oct 24, 2018 at 5:42 PM Elmarie Claasen  wrote:

> Hi Neeraj,
>
>
>
> These attributes that you refer to are they part of the Tracked Entity
> defined? My understanding which may be wrong is if you define certain
> attributes as part of the tracked entity e.g. Person then those attributes
> would be mandatory in the programs.
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
> *From:* Dhis2-devs  hisp@lists.launchpad.net> *On Behalf Of *Neeraj Gupta
> *Sent:* Wednesday, October 24, 2018 9:34 AM
> *To:* DHIS 2 Users list ; DHIS 2
> developers 
> *Subject:* [Dhis2-devs] Mandatory attributes can not be made optional
>
>
>
> Dear All,
>
>
>
> Once the attribute is made mandatory and if at a later stage it is
> considered to be optional then we are able to go to attributes of the
> program and uncheck the mandatory field but this is not reflected in the
> registration page.
> It always treats the attribute as mandatory, the user cannot move forward
> without entering data for those attributes.
>
>
>
> Version: 2.30
> Build revision: bd6e33e
>
> Build date: 2018-10-23 02:06
>
>
>
> --
>
> Thanks,
> Neeraj Gupta
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Mandatory attributes can not be made optional

[Neeraj Gupta]

Thanks Terence.

On Wed, Oct 24, 2018 at 5:27 PM Terence Scott <
terence.sc...@rabiesalliance.org> wrote:

> Dear Neeraj
>
> I have recently upgraded to 2.30 and I am also experiencing similar. The
> attributes that are requested at the beginning of the data entry are all
> mandatory (when none of them were mandatory previously). Therefore, the
> user cannot progress as mentioned. I will vote on your Jira issue.
>
> Kind regards,
> Terence
>
>
> Terence Scott
>
> Global Alliance for Rabies Control (GARC)
> Pan-African Rabies Control Network (PARACON) Steering Committee
> terence.sc...@rabiesalliance.org
> https://paracon.rabiesalliance.org
> Skype: tpscott1987
>
>
>
> On Wed, Oct 24, 2018 at 1:53 PM Neeraj Gupta 
> wrote:
>
>> Yes Calle,
>> I have reported this on JIRA DHIS2-5026
>> <https://jira.dhis2.org/browse/DHIS2-5026>
>>
>> On Wed, Oct 24, 2018 at 4:55 PM Calle Hedberg 
>> wrote:
>>
>>> Neeraj,
>>>
>>> if correct, then it is an obvious BUG. Have you written a JIRA bug
>>> report for it?
>>>
>>> Regards
>>> Calle
>>>
>>> On Wed, 24 Oct 2018 at 09:34, Neeraj Gupta 
>>> wrote:
>>>
>>>> Dear All,
>>>>
>>>> Once the attribute is made mandatory and if at a later stage it is
>>>> considered to be optional then we are able to go to attributes of the
>>>> program and uncheck the mandatory field but this is not reflected in the
>>>> registration page.
>>>> It always treats the attribute as mandatory, the user cannot move
>>>> forward without entering data for those attributes.
>>>>
>>>> Version: 2.30
>>>> Build revision: bd6e33e
>>>> Build date: 2018-10-23 02:06
>>>>
>>>> --
>>>> Thanks,
>>>> Neeraj Gupta
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-d...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>>
>>> --
>>>
>>> ***
>>>
>>> Calle Hedberg
>>>
>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>
>>> Tel/fax (home): +27-21-685-6472
>>>
>>> Cell: +27-82-853-5352
>>>
>>> Iridium SatPhone: +8816-315-19119
>>>
>>> Email: calle.hedb...@gmail.com
>>>
>>> Skype: calle_hedberg
>>>
>>> ***
>>>
>>>
>>
>> --
>> Thanks,
>> Neeraj Gupta
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Mandatory attributes can not be made optional

[Neeraj Gupta]

Yes Calle,
I have reported this on JIRA DHIS2-5026
<https://jira.dhis2.org/browse/DHIS2-5026>

On Wed, Oct 24, 2018 at 4:55 PM Calle Hedberg 
wrote:

> Neeraj,
>
> if correct, then it is an obvious BUG. Have you written a JIRA bug report
> for it?
>
> Regards
> Calle
>
> On Wed, 24 Oct 2018 at 09:34, Neeraj Gupta  wrote:
>
>> Dear All,
>>
>> Once the attribute is made mandatory and if at a later stage it is
>> considered to be optional then we are able to go to attributes of the
>> program and uncheck the mandatory field but this is not reflected in the
>> registration page.
>> It always treats the attribute as mandatory, the user cannot move forward
>> without entering data for those attributes.
>>
>> Version: 2.30
>> Build revision: bd6e33e
>> Build date: 2018-10-23 02:06
>>
>> --
>> Thanks,
>> Neeraj Gupta
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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 in Custom registration form of Tracker capture

[Neeraj Gupta]

I have created an issue on JIRA for this DHIS2-5025
<https://jira.dhis2.org/browse/DHIS2-5025>
This is urgent as we have to use the custom form in one of the program
which is to be implemented very soon and we need to capture the whole
hierarchy of the patient, we can not use default form as we are using some
scripts in the form.

Requesting the development team to please prioritize this issue.

On Wed, Oct 24, 2018 at 12:46 PM Neeraj Gupta  wrote:

> Dear All,
>
> I am facing some issues with the custom registration form in Tracker
> capture.
> I am using Organisation Unit type and Age type data elements, when I use
> these with the custom registration form, the + icon does not load the
> organisation unit tree ( Which is the expected behavior), however, this is
> working fine in case of the default form.
> Same is happening with the Age type of data element, when the age is
> entered the dates are not loaded.
>
> I am using
> Version: 2.30
> Build revision: bd6e33e
> Build date: 2018-10-23 02:06
>
> I have checked this on play.dhis2.org and found the same behavior.
> Any quick help is highly appreciated.
>
> --
> Thanks,
> Neeraj Gupta
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Mandatory attributes can not be made optional

[Neeraj Gupta]

Dear All,

Once the attribute is made mandatory and if at a later stage it is
considered to be optional then we are able to go to attributes of the
program and uncheck the mandatory field but this is not reflected in the
registration page.
It always treats the attribute as mandatory, the user cannot move forward
without entering data for those attributes.

Version: 2.30
Build revision: bd6e33e
Build date: 2018-10-23 02:06

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Problem in Custom registration form of Tracker capture

[Neeraj Gupta]

Dear All,

I am facing some issues with the custom registration form in Tracker
capture.
I am using Organisation Unit type and Age type data elements, when I use
these with the custom registration form, the + icon does not load the
organisation unit tree ( Which is the expected behavior), however, this is
working fine in case of the default form.
Same is happening with the Age type of data element, when the age is
entered the dates are not loaded.

I am using
Version: 2.30
Build revision: bd6e33e
Build date: 2018-10-23 02:06

I have checked this on play.dhis2.org and found the same behavior.
Any quick help is highly appreciated.

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Positive or Zero Integer Value type does not save zero vlaues

[Neeraj Gupta]

Hi Emma,

There is an attribute called 'Store Zero data values' for data elements,
you need to select 'Yes', in order to save 0 as value.

regrads,
Neeraj

On Mon, Jun 12, 2017 at 3:42 PM, Immaculate Ayebazibwe <ekass...@gmail.com>
wrote:

> Hi,
> I have an instance running on 2.25 where the value is 0 is as important as
> any other.
> So for a DE of tracker type I assigned the value type Positive or Zero
> integer so that 0 can be entered. However whenever I enter 0 the system
> gives an error and does not save.
> I went further and tested this on 2.26 and 2.27 (demo) now on these
> versions though it does give an error on save when I return or refresh it
> shows the DE or value to be empty.
> I have attached some images for clarity.
>
> Is this intentional or a possible bug?
>
>
> 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
>
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] The DHIS 2 Tracker Academy - Goa 2017 is coming up. Register now!

[Neeraj Gupta]

*
*

*20 - 24 February*

*2017*

*DHIS 2 Tracker Academy - Goa 2017*



We are pleased to announce the "DHIS 2 Tracker Academy, Level 1 - Goa 2017"
to be held at "The International Centre, Goa" from Feb 20-24. This five day
Tracker Academy will focus on emerging needs for case based reporting,
disease registries, disease surveillance and event reporting.

Register Now! https://www.dhis2.org/india2017-home


We would like to invite you and other staff from your organization engaged
in HIS design, implementation and use to participate in the workshop.
We invite  both new and experienced DHIS 2 implementers to participate,
although it would be preferred that you have had some prior experience with
DHIS 2.

HISP India is one of the pioneers in the design, development and
implementation of DHIS 2 related projects for over a decade, and has worked
with important partners both in India and globally. For more information:
https://hispindia.org




The focus on Tracker is in response to the heightened demand for case based
information systems, especially relating to disease control and
surveillance. The Academy will cover key functionalities of the Tracker,
approaches to their customization and we will provide real life use cases
where the DHIS 2 Tracker has been customized for innovative and scalable
applications.

The conference is being hosted in Goa, the touristic land of extreme
beauty. This will provide the opportunity for participants to participate
in the festivities of the Carnival
following
the workshop.

We look forward to seeing you in the beautiful city of Goa in
February, where we can combine both learning and leisure.

Reach out to us with questions at india2...@dhis2.org

See you in Goa!

The Organizing Committee
___
Mailing list: https://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] 25 hours in completing Analytic

[Neeraj Gupta]

Hi Calle,

Thanks for all this.

Yes, we will have a test server available with us by first week of
November, I can start test scenarios suggested by you after that.

Thanks,
Neeraj

On Mon, Oct 24, 2016 at 3:50 PM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Neeraj,
>
> Thanks for that, it is useful info.
>
> The instance has a very skewed balance between data elements/catcombos and
> indicators, but what else is new - outside of South Africa, most countries
> have the same: they collect a huge number or data elements but turn very
> few of them into indicators (SA collect very very few data elements that
> are NOT part of any indicator). But that is a separate discussion.
>
> I would NOT expect the number of data elements & catcombos + the number of
> orgunits to have a significant impact on analytics performance, but that
> needs to be verified.
>
> I WOULD expect the number of indicators to have a significant impact, so
> if you doubled or quadrupled the number of indicators I would expect a
> significant impact on analytics time
>
> Using your and my numbers as a baseline, I would envision the following
> tests to be revealing:
>
> Baseline system 1: SSD, 4-core CPU: 100 mill values, 400 DEs, 250
> indicators, 30,000 OUs, few catcombos -> 1 hour for analytics processing
>
> Baseline system 2: SSD, 12-core CPU: 500 mill values, 3,500 DEs, 15,000
> OUs, 25 catcombos -> ~10 hours for analytics processing
>
> Test 1: Using system 1, reduce OUs to 15,000 - run analytics (hypothesis:
> no significant difference)
> Test 2: Using system 1, reduce indicators to 125 - run analytics, then to
> 0 - run analytics (hypothesis: analytics reduced to 45 min)
> Test 3: Using system 1, increase datavalues from 100mill to 500 mill by
> introducing additional attributecombos (easy) - run analytics (hypothesis:
> ~15 hours for analytics processing, with 4-cores instead of 12-cores)
> Test 4: Using system 1, increase datavalues to 1 billion - run analytics
> (hypothesis: 35 hours for analytics processing).
>
> Neeraj, I don't know if you have a similar sandbox server available for
> testing, but if you do:
>
> Test 5: Using system 2, increase number of indicators to 600 (just export
> the 200 you have, modify the names and uids a bit, and re-import - for the
> purpose of this test, it does not matter that many of the indicators have
> identical formulas). Hypothesis: Analytics time up at least 20%
> Test 6: using system 2 (with 200 indicators), shift half of the 500 mill
> data values forward or backward in time resulting in twice the number of
> analytics tables at half the size. (hypothesis: slight reduction in
> processing time)
> Test 7: Using system 2 (with 200 indicators), increase datavalues to 1
> billion using a new attributecombo - run analytics (hypothesis: analytics
> time up to 25 hours again).
>
> As far as I've seen, the bulk of analytics processing time is taken up by
> indexing - which I would expect to follow a moderately quadratic curve in
> terms of analytics table sizes.
>
> Best regards
> Calle
>
> On 24 October 2016 at 10:39, Neeraj Gupta <neeraj.h...@gmail.com> wrote:
>
>> Calle,
>>
>> We have around 500 million record in database with 3666 data elements
>> having 26 category combinations and 201 indicators and there are 14398
>> organisation units.
>>
>> Thanks,
>> Neeraj
>>
>> On Mon, Oct 24, 2016 at 1:50 PM, Calle Hedberg <calle.hedb...@gmail.com>
>> wrote:
>>
>>> Neeraj,
>>>
>>> You never stated the number of records you have in the datavalue table -
>>> what is it?
>>>
>>> In the same context: anybody have a rough idea of how many datavalue
>>> records there are in the global DATIM database - which I think currently
>>> might be the largest DHIS2 instance around?
>>>
>>> Given our own recent work on performance + what Neeraj has reported,
>>> I've been thinking of creating one test instance with let us say 500 mill
>>> datavalue records and another with let us say 1 billion, then use them to
>>> identify key bottlenecks in various processes AND use them to ensure that
>>> DHIS2 analytics performance is as linear as possible in terms of database
>>> size. Postgresql has introduced a number of new indexing algorithms in
>>> recent versions, and I'm not sure if DHIS2 is taking full advantage of them.
>>>
>>> Best regards
>>> Calle
>>>
>>> On 24 October 2016 at 07:53, Brajesh Murari <brajesh.mur...@gmail.com>
>>> wrote:
>>>
>>>> Congratulation Neeraj and team ...it much apprec

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

[Neeraj Gupta]

Calle,

We have around 500 million record in database with 3666 data elements
having 26 category combinations and 201 indicators and there are 14398
organisation units.

Thanks,
Neeraj

On Mon, Oct 24, 2016 at 1:50 PM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Neeraj,
>
> You never stated the number of records you have in the datavalue table -
> what is it?
>
> In the same context: anybody have a rough idea of how many datavalue
> records there are in the global DATIM database - which I think currently
> might be the largest DHIS2 instance around?
>
> Given our own recent work on performance + what Neeraj has reported, I've
> been thinking of creating one test instance with let us say 500 mill
> datavalue records and another with let us say 1 billion, then use them to
> identify key bottlenecks in various processes AND use them to ensure that
> DHIS2 analytics performance is as linear as possible in terms of database
> size. Postgresql has introduced a number of new indexing algorithms in
> recent versions, and I'm not sure if DHIS2 is taking full advantage of them.
>
> Best regards
> Calle
>
> On 24 October 2016 at 07:53, Brajesh Murari <brajesh.mur...@gmail.com>
> wrote:
>
>> Congratulation Neeraj and team ...it much appreciated
>>
>> On Mon, Oct 24, 2016 at 11:08 AM, Neeraj Gupta <neeraj.h...@gmail.com>
>> wrote:
>>
>>> Dear Team, Thanks for all your suggestions.
>>>
>>> Now the time of analytic is reduced to 10 hours 41 minutes.
>>>
>>> We tried to VACUUM as Sam suggested but it didn't help then we upgraded
>>> postgres from 9.4 to 9.5.4 and as Calle and Bob suggested we made some
>>> changes in configuration file of postgres and it reduced the time. But the
>>> database size is still same.
>>>
>>> Thanks for all your help!
>>>
>>> Thanks,
>>> Neeraj
>>>
>>> On Wed, Oct 19, 2016 at 6:46 PM, Calle Hedberg <calle.hedb...@gmail.com>
>>> wrote:
>>>
>>>> Neeraj,
>>>>
>>>> It's always an element of uncertainty linked to database sizes - ref
>>>> Sam's post over. So indicating the number of records you have in the
>>>> datavalue table & key meta-data tables would be useful + indicating whether
>>>> you are running other instances on the same server. Some comments - I've
>>>> been doing a lot of similar optimising work recently:
>>>>
>>>> 1. Upgrading to 9.5.4 is strongly recommended (and don't use 9.6 before
>>>> the worst bugs are fixed and it has stabilised).
>>>>
>>>> 2. Carefully check your postgres.conf against the recommended settings.
>>>> The guide is a bit superficial in the sense that it has recommended "fixed"
>>>> values only and no explanations around ranges below or above those, but you
>>>> can experiment a bit yourself (e.g. the recommended "max_connections = 200"
>>>> might not be sufficient for a really large system like what you have.
>>>>
>>>> 3. If your server is running that single instance only, then 48GB or
>>>> RAM should be sufficient. Our servers are all having 128GB RAM so we
>>>> experimented quite a bit earlier this year with giving a DHIS2 instance
>>>> large amounts or RAM (up to 60-70gb), with negligible impact on
>>>> performance. According to Lars, the DHIS2 cannot really utilize more than
>>>> around 16gb RAM (at least that is how I understood his communication at the
>>>> time). So 48GB should be sufficient for a single instance.
>>>>
>>>> 4. I've been doing performance optimizing recently on an instance with
>>>> - 4-core server with 2x 512gb ssd, 12gb allocated to DHIS2
>>>> - 31,000 Orgunits
>>>> - 420 data elements
>>>> - 250 indicators
>>>> - around 100 mill datavalue records
>>>> - total size around 140gb with analytics tables.
>>>>
>>>> So the size is only 25% of your 500GB, but RUNNING ANALYTICS ON THAT
>>>> DATABASE INSTANCE IS TAKING JUST OVER 1 HOUR. Fundamentally, if the
>>>> analytics engine is designed well, I would expect a nearly linear
>>>> relationship between database size and the time analytics takes to run. So
>>>> running analytics on your database on our server should in theory take 4-5
>>>> hours.
>>>>
>>>> We are obviously comparing oranges and nectarines here, in the sense
>>>> that there might be other aspects of our server and database that is
>

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

[Neeraj Gupta]

>>
>>
>> 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
>>
>>
>>
>>
>>
>> --
>>
>> 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
>>
>>
>>
>>
>>
>> --
>>
>> Best Regards,
>>
>>
>>
>> Brajesh Murari,
>>
>> Postgraduate, Department of Computer Science and Engineering,
>>
>> Chaudhary Devi Lal University, Sirsa,
>>
>> India.
>>
>>
>>
>> The three basic dimensions of human development: a long and healthy life,
>> access to knowledge, and a decent standard of living.
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] 25 hours in completing Analytic

[Neeraj Gupta]

gt;> 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
>>
>>
>>
>>
>>
>> --
>>
>> 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
>>
>>
>>
>>
>>
>> --
>>
>> Best Regards,
>>
>>
>>
>> Brajesh Murari,
>>
>> Postgraduate, Department of Computer Science and Engineering,
>>
>> Chaudhary Devi Lal University, Sirsa,
>>
>> India.
>>
>>
>>
>> The three basic dimensions of human development: a long and healthy life,
>> access to knowledge, and a decent standard of living.
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] 25 hours in completing Analytic

[Neeraj Gupta]

Thanks Knut and Brajesh,

Lars we are using 12 Core CPu with SSD and having 48GB RAM but using
Postgres 9.4.

We will try with Postgres 9.5 now and let you know the results.
Do you recommend anything else other than this?

Thanks,
Neeraj

On Wed, Oct 19, 2016 at 12:35 PM, Knut Staring <knu...@gmail.com> wrote:

> Just a heads-up that there seems to be a JDBC issue with Postgres 9.6, so
> perhaps you should try upgrading to 9.5 first.
>
> On Wed, Oct 19, 2016 at 8:58 AM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>>
>> Hi Neeraj,
>>
>> what usually helps to improve runtime is to improve/increase:
>>
>> - ssd (read and write speed)
>> - number of CPUs
>> - using latest postgresql (9.6 claims to have even better indexing
>> performance <https://www.postgresql.org/docs/9.6/static/release-9-6.html>
>> than 9.5)
>> - tuning
>> <https://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_postgresql_performance_tuning>
>> of postgresql
>>
>>
>> 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
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>



-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] 25 hours in completing Analytic

[Neeraj Gupta]

Thanks Lars, we will give this a try and let you know.
How much time do you expect to run for 100 GB database in ideal conditions?

Thanks,
Neeraj

On Wed, Oct 19, 2016 at 12:28 PM, Lars Helge Øverland <l...@dhis2.org>
wrote:

>
> Hi Neeraj,
>
> what usually helps to improve runtime is to improve/increase:
>
> - ssd (read and write speed)
> - number of CPUs
> - using latest postgresql (9.6 claims to have even better indexing
> performance <https://www.postgresql.org/docs/9.6/static/release-9-6.html>
> than 9.5)
> - tuning
> <https://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_postgresql_performance_tuning>
> of postgresql
>
>
> 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/>
>
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] 25 hours in completing Analytic

[Neeraj Gupta]

Dear team,

In one of the Indian state we are using DHIS 2.23 and the database size is
going around 100 GB and once we run analytic it reaches to 500 GB and
analytic is taking around 25 hours to complete. We are using Postgres 9.4.

Has anyone experienced the situation with 100 GB database or more?
How did you deal with the time of analytic, Is there any way so that the
time of analytic can be reduced?

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Need help on AD integration with DHIS2

[Neeraj Gupta]

Dear team,

Has some done this earlier?

On Mon, Aug 29, 2016 at 4:18 PM, Neeraj Gupta <neeraj.h...@gmail.com> wrote:

> Hi Team,
>
> We are using DHIS2 version 2.21.
> We need to use AD integration in the application. Is it possible to
> integrate AD with DHIS version 2.21?
>
> Has anyone used it already with any of the version?
>
> --
> Thanks,
> Neeraj Gupta
>
> ___
> 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
>
>


-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] (no subject)

[Neeraj Gupta]

Hi Team,

We are using DHIS2 version 2.21.
We need to use AD integration in the application. Is it possible to
integrate AD with DHIS version 2.21?

Has anyone used it already with any of the version?

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Need help in Program Rules

[Neeraj Gupta]

Hello All,

I am using DHIS version 2.20 build revision 19691.

I am having a doubt in Program rules.

We have a case where

Data element 'Age Type' has options i.e. *Hours/Days/Weeks/Months/Years*
Now if the user is selecting 'Age type' as *Hours *then another data
element 'Age' should accept value between *0 to 23*, application should not
accept any value more that 23 in case of *Hours *'Age type'.
Similarly, If 'Age type' is *Days  *then it should not accept more that *6 *for
'Age' data element.

Can we add these kind of program rules?

Can some one please guide?

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] Problem with Get as image option in Dashboard for Data Visualizer

[Neeraj Gupta]

Hi,

In Data Visualizer when we are generating charts, we can hide empty
category items and same can be used in Dashboard but on Dashboard if we are
clicking on *'Get as image'* option then in image it displays Empty
categories as well.

Is there a solution for this so that in image also we will not get Empty
categories?

-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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 and visualiser

[Neeraj Gupta]

Hi,

Please make sure that you are running analytics before using Pivot tables
and Visualizer.

On Fri, Jun 5, 2015 at 12:31 PM, bridgetmag...@mifumi.org wrote:

 Hi team,
 Am a database manager using DHIS2, am having a challenge in generating
 data in the reports i.e. pivot table and visualizer. When I check through
 manual aggregation, it shows data is in the system but is not reflected
 through the reports.

 Please help

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




-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] GML Files

[Neeraj Gupta]

Hi Sushil,

It will be very interesting to work with such an app. Can you please guide
us for the app.

On Fri, Apr 10, 2015 at 1:25 PM, Knut Staring knu...@gmail.com wrote:

 Hi Muhammad,

 Actually, the GML route is not strictly necessary, and quite cumbersome,
 as it involves a number of tools. I strongly suggest you rather work with
 Sushil Chitrakar (copied) and try his App which takes care of both properly
 formatting and importing shapefiles directly. Sushil can guide you through
 all the steps, and will also be grateful for any feedback on the App and
 the process.

 Regards,
 Knut

 On Fri, Apr 10, 2015 at 9:32 AM, Muhammad Bilal Siddqui 
 m.bilalsidd...@micromerger.com wrote:

 Can i get some GML file sample that can import in DHIS2. I want to make a
 GML file for my country OUs but i dont know how to make one? Is GML file is
 some .gml file like that or else?

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




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

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




-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] GML Files

[Neeraj Gupta]

Thanks Sushil for your commitment.

Actually, to use GIS in any of the application we are working with shape
files and converting shape files to GML files and then we are importing to
DHIS2 which needs a number of tools but as per my understanding with Knut's
mail, with your app we can cut down the processes and tools.

I am eager to know about your app and would definitely like to use the app
for future.

On Wed, Apr 15, 2015 at 2:58 PM, Sushil Chitrakar sushilch...@gmail.com
wrote:

 Hello Neeraj,
 yeah sure. Just let me know what you need, and the we can move ahead.

 Regards,
 Sushil

 On 15 April 2015 at 15:11, Neeraj Gupta neeraj.h...@gmail.com wrote:

 Hi Sushil,

 It will be very interesting to work with such an app. Can you please
 guide us for the app.

 On Fri, Apr 10, 2015 at 1:25 PM, Knut Staring knu...@gmail.com wrote:

 Hi Muhammad,

 Actually, the GML route is not strictly necessary, and quite cumbersome,
 as it involves a number of tools. I strongly suggest you rather work with
 Sushil Chitrakar (copied) and try his App which takes care of both properly
 formatting and importing shapefiles directly. Sushil can guide you through
 all the steps, and will also be grateful for any feedback on the App and
 the process.

 Regards,
 Knut

 On Fri, Apr 10, 2015 at 9:32 AM, Muhammad Bilal Siddqui 
 m.bilalsidd...@micromerger.com wrote:

 Can i get some GML file sample that can import in DHIS2. I want to make
 a GML file for my country OUs but i dont know how to make one? Is GML file
 is some .gml file like that or else?

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




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

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




 --
 Thanks,
 Neeraj Gupta





-- 
Thanks,
Neeraj Gupta
___
Mailing list: https://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] GML Files

[Neeraj Gupta]

Thanks Sushil,

I will surely get back to you with feedback and my queries if I will have
any.

On Wed, Apr 15, 2015 at 3:12 PM, Sushil Chitrakar sushilch...@gmail.com
wrote:

 Hello Neeraj,
 yes you are right. With this email I am sending you the app. I hope this
 will head start the work.

 So features and key notes:
 1. remove digits from the coordinates, ie. coordinates will have only 4
 digits after .(eg: 23. - 23.)
 2. display the dbf values
 3. allow user to map the columns with the columns in the DHIS2 database.
 4. automatically try to find the parent of each organisation units from
 the db, if not all user to select the parent.
 5. import the organisation units into the db with coordinates.

 Things you need:
 1. Shaper files(.dbf and .shp) for each layer
 2. coordinates in the .shp file must be of projection EPSG:4326 in case
 of DHIS2

 I have included the steps to follow after installing the app for importing:

 1. open the app.
 2. choose the level*.shp file. level*.shp file is the shape file that you
 have. First(zero level) is country
 3. now drag the corresponding .dbf file into the browser. ie dbf file of
 the country ( you can drag or upload both files at once aswell)
 4. after dragging the .dbf , adjust the detail of map you want to be
 imported using the slider in the browser. You can see slight changes in the
 map detail.
 5.  now use the button Org Unit to display the list of org units in the
 .dbf file.
 6. in the same page, you choose column with the id of the org unit, its
 parent, name and short name and level of the organisation units. The
 columns for corresponding data  are listed in the select box on top of
 table.  For  country since its a zero level, it does not have a parent, so
 do not choose anything. For other level like in the first level,
  development region , you need to choose the id of country or its parent
 there. After choosing all the mandatory fields the Map field button will be
 enabled.

 7. Use the map fields button to map the fields with the database and find
 the parent automatically on the basis of  code.

 8. If the app finds the matching parent it will show up in the parent
 column. If not you will be allowed to choose the parent from the select box.
 9. Then choose the organisations units that you want to import. After
 choosing the at least one row from the list, import button will be
 displayed.
 10. then use import button to import the data into the dhis.

 11. If you want to see the GML data, please choose the show GML text
 check box.  It will also display the GML data at the right side in a text
 box.
 12. now follow the same process again.

 I hope that you can provided me some feedback on this app and help me work
 on this more and also for my thesis.  Let me know if you have any issues
 installing the app or using it. One link that can be helpful for installing
 the app is:
 https://www.dhis2.org/doc/snapshot/en/developer/html/ch02s03.html

 Please take a look on the work and also please send me some feedback how
 this app worked for you. What are the issues that you find with the GML,
 how this solved your problem if it did and your other remarks.


 Regards,
 Sushil

 On 15 April 2015 at 15:22, Neeraj Gupta neeraj.h...@gmail.com wrote:

 Thanks Sushil for your commitment.

 Actually, to use GIS in any of the application we are working with shape
 files and converting shape files to GML files and then we are importing to
 DHIS2 which needs a number of tools but as per my understanding with Knut's
 mail, with your app we can cut down the processes and tools.

 I am eager to know about your app and would definitely like to use the
 app for future.

 On Wed, Apr 15, 2015 at 2:58 PM, Sushil Chitrakar sushilch...@gmail.com
 wrote:

 Hello Neeraj,
 yeah sure. Just let me know what you need, and the we can move ahead.

 Regards,
 Sushil

 On 15 April 2015 at 15:11, Neeraj Gupta neeraj.h...@gmail.com wrote:

 Hi Sushil,

 It will be very interesting to work with such an app. Can you please
 guide us for the app.

 On Fri, Apr 10, 2015 at 1:25 PM, Knut Staring knu...@gmail.com wrote:

 Hi Muhammad,

 Actually, the GML route is not strictly necessary, and quite
 cumbersome, as it involves a number of tools. I strongly suggest you 
 rather
 work with Sushil Chitrakar (copied) and try his App which takes care of
 both properly formatting and importing shapefiles directly. Sushil can
 guide you through all the steps, and will also be grateful for any 
 feedback
 on the App and the process.

 Regards,
 Knut

 On Fri, Apr 10, 2015 at 9:32 AM, Muhammad Bilal Siddqui 
 m.bilalsidd...@micromerger.com wrote:

 Can i get some GML file sample that can import in DHIS2. I want to
 make a GML file for my country OUs but i dont know how to make one? Is 
 GML
 file is some .gml file like that or else?

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