Re: [Dhis2-devs] [Dhis2-users] Analyze across events

2017-04-10 Thread Pramil Liyanage
Thanks Markus. I'm on 2.25. Will update to 2.26 and try. Will get back to
you if any issue. Thanks again.

Pramil

On Mon, Apr 10, 2017 at 12:59 PM, Markus Bekken <mar...@dhis2.org> wrote:

> Hi there Pramil,
> if you are on version 2.26 or later you can make a program indicator with
> the "Enrollment" analytics type:
>
> This will let you compare data from different events within the same
> enrollment. The enrollment date is used as the aggregation date when
> looking at the data in a pivot.
>
> Hope this helps, get back if you have any further questions.
>
> Best regards,
> Markus
>
>
> 7. apr. 2017 kl. 21.48 skrev Pramil Liyanage <prami...@gmail.com>:
>
> Hi,
>
> I need to analyze data across variables in two events in a program with
> multiple stages.
>
> For example, I need to find the number of patients marked as cured in 
> *treatment
> outcome* stage,  for a cohort registered during a specified time. Can I
> combine enrollment date or date from another event (e.g. *registration
> event*)? Event reports will aggregate to the event, *treatment outcome*,
> not registration.
>
> I know that this is not possible to combine elements from two events in
> event reports. Is it possible to do this using programme indicators? If so
> what is the syntax?
>
> Regards
> Pramil
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Analyze across events

2017-04-07 Thread Pramil Liyanage
Hi,

I need to analyze data across variables in two events in a program with
multiple stages.

For example, I need to find the number of patients marked as cured in
*treatment
outcome* stage,  for a cohort registered during a specified time. Can I
combine enrollment date or date from another event (e.g. *registration
event*)? Event reports will aggregate to the event, *treatment outcome*,
not registration.

I know that this is not possible to combine elements from two events in
event reports. Is it possible to do this using programme indicators? If so
what is the syntax?

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


[Dhis2-devs] Event Data Items in Analysis

2016-12-19 Thread Pramil Liyanage
Dear All,

In Pivot Tables, Data Visualizer and GIS modules, only some data elements
from tracker are available for analysis under *Event Data Items*. Why only
some elements are seen? How can we get the other elements there?

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


[Dhis2-devs] Use Google streets maps to capture coordinates

2016-11-23 Thread Pramil Liyanage
Hi,

Is it possible to use Google street map in capturing coordinates in tracker
capture in 2.25 which was possible in 2.24 rather than using OpenStreetMap?

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


Re: [Dhis2-devs] Login issue

2016-08-07 Thread Pramil Liyanage
Hi

I also experience the same issue in 2.24. Is this fixed in the latest
builds?

Regards
Pramil
On 5 Aug 2016 10:13, "Em Le Hong"  wrote:

> I saw the response of the same bug.
>
> Thanks,
>
> On Fri, Aug 5, 2016 at 11:22 AM, Em Le Hong 
> wrote:
>
>> Hi dev,
>>
>> I'm using DHIS2 2.23 R.23045
>>
>> I can't login to dhis2 with chrome browser, I fill in the username and
>> password, click on Sign in button, it just refreshes the page, no error
>> message. But when I try with Firefox browser, with the same username and
>> password, then I can login. I clean history cache and also try with other
>> computers, still get the same problem.
>>
>> Is that because of server configuration or anything else?
>>
>> Thanks,
>>
>> --
>> Le Hong Em
>>   +84 126 7171 650
>>
>
>
>
> --
> Le Hong Em
>   +84 126 7171 650
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Tracker UI issue

2016-06-23 Thread Pramil Liyanage
Hi Lars,

In that case, what happens to the blank space? Any method to use it in
default forms? Like by having two columns for elements?

Regards
Pramil

On Fri, Jun 24, 2016 at 1:51 AM, Lars Helge Øverland  wrote:

> Hi Muturi,
>
> this is in fact by design. We would like to keep the labels close to the
> input fields to make it easier to visually connect them. The regular input
> fields don't need to be wider than they currently are for numbers and
> option sets. If you would like free text and larger text areas you can set
> the data element value type to "long text".
>
> best regards,
>
> Lars
>
>
> On Thu, Jun 23, 2016 at 10:00 PM, David Muturi  wrote:
>
>> Hi Devs,
>> I have noticed that the UI for the tracker for default forms collapses
>> instead of expanding as before based on length of label. See attached
>> screen shot. This resilts in a default form that is not user friendly based
>> on the length of the label.
>> This is happening in v 2.23
>> rgds
>> David
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] [Dhis2-users] Deleting individual records in DHIS2

2016-05-18 Thread Pramil Liyanage
Hi Stanley,

Through the web API you can.

http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s54.html

Can a developer clarify more on this? Any other method?

Pramil

On Wed, May 18, 2016 at 3:22 PM, Stanley Kalyati <skaly...@gmail.com> wrote:

> Pramil,
>
> Thank you for your response.
>
> Basing in your response,how can I delete in the individual records.
>
> Regards
>
> Stanley
> ------
> From: Pramil Liyanage <prami...@gmail.com>
> Sent: ‎18/‎05/‎2016 11:48
> To: Archana Chillala <archa...@thoughtworks.com>
> Cc: Stanley Kalyati <skaly...@gmail.com>; DHIS Users
> <dhis2-us...@lists.launchpad.net>; DHIS 2 Developers list
> <dhis2-devs@lists.launchpad.net>
> Subject: Re: [Dhis2-users] [Dhis2-devs] Deleting individual records in
> DHIS2
>
> Hi Stanley,
>
> The method Archana mentioned is for program without registration. If it is
> a program with registration, I don't think you can delete from UI.
>
> Regards
> Pramil
>
>
>
> On Wed, May 18, 2016 at 11:37 AM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
>> Hi Stanley,
>>
>> The individual records in a program can be deleted from the UI. In the
>> Event Capture App, when you select a program, the registered programs will
>> come up in a tabular form. Click on the record you want to delete, and a
>> context menu appears. Click on the "Remove" option. This will remove the
>> entire record.
>>
>>
>> [image: Inline image 1]
>>
>> *Cheers*
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> <http://www.thoughtworks.com/?utm_campaign=archana-chillala-signature_medium=email_source=thoughtworks-email-signature-generator>
>>
>> On Thu, Apr 14, 2016 at 5:52 PM, Stanley Kalyati <skaly...@gmail.com>
>> wrote:
>>
>>> Dear Colleagues,
>>>
>>> How does one delete individual records in a program so that new records
>>> can now be entered?
>>>
>>> I created a program and was trying to enter data to see if the system is
>>> working properly.But i now want to delete and then deploy the system for
>>> use.
>>>
>>> Am using dhis2 2.22 build 21763
>>>
>>> Thank you
>>>
>>> On Thu, Apr 14, 2016 at 2:21 PM, Stanley Kalyati <skaly...@gmail.com>
>>> wrote:
>>>
>>>> Dear Colleagues,
>>>>
>>>> How does one delete individual records in a program so that new records
>>>> can now be entered?
>>>>
>>>> I created a program and was trying to enter data to see if the system
>>>> is working properly.But i now want to delete and then deploy the system for
>>>> use.
>>>>
>>>> Am using dhis2 2.22 build 21763
>>>>
>>>> Thank you
>>>>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] [Dhis2-users] Program data into dataset

2016-05-09 Thread Pramil Liyanage
Hi Uwe and Lars,

Thanks for highlighting the importance. As Uwe said, if DHIS2 to continue
as a data warehouse, aggregating from tracker will be important. I'm sure
there are many who is having the same issue. And in future also there will
be many who will face this when moving into patient records as further
developments.

Hope the developers will provide a better solution soon.

Regards
Pramil

On Mon, May 9, 2016 at 1:11 PM, Uwe Wahser <u...@wahser.de> wrote:

> Hi Pramil & Lars,
>
> actually I think that Pramil is adressing a very valid problem. In my
> current
> understanding of DHIS2 I wouldn't be able to propose any better solution
> than
> using Lars' analysis api and an external tool (php, r, kettle etc) to read
> the
> results and fill them into the datasets.
>
> However, the use-case he describes is the very typical data warehousing
> scenario, where you have different layers of granularity and maturity of
> data
> (e.g. staging area, operational data stores, data marts), especially in an
> infrastructure where you are mainly extracting data from source systems.
> This
> would require DHIS2 to be able to push data internally (from tracker to
> datasets, but also within tracker or from dataset to dataset), while at
> the same
> time being able to transform these data (e.g. as it was possible with the
> aggregation queries).
>
> This has multiple semantic advantages as you can model your data from
> raw-data
> to architected data marts. But also technical aspects as you don't have to
> rebuild your datasets from the source systems, whenever you change their
> definition, but can rebuild them from the granular level instead. Leave
> alone
> the performance issues I'd normally expect when having to include huge
> numbers
> of granular data from tracker into DHIS2 analytics. (btw. do you have any
> reference data on the that?) Of course this would call for nightly builds,
> but
> that's normal data warehousing business.
>
> I am aware of the discussion last year (e.g.
> https://lists.launchpad.net/dhis2-users/msg09609.html) but would like to
> encourage a higher priority of the replacement, if there is still the
> intention
> of positioning DHIS2 as a tool for data warehousing.
>
> I also remember slightly that Knut tried to trigger off a discussion on
> this
> (maybe around 2015-12?), but can't find the thread on that - are there any
> DEV
> internal news on the status of that discussion and the future plans of
> aggregation within DHIS2?
>
> Best regards,
>
> Uwe
>
> ---
> > Pramil Liyanage <prami...@gmail.com> hat am 9. Mai 2016 um 09:00
> geschrieben:
> >
> >
> > Any help on this?
> >
> > Regards
> > Pramil
> >
> > On Sat, May 7, 2016 at 8:53 PM, Pramil Liyanage <prami...@gmail.com>
> wrote:
> >
> > > Thanks Lars. Let me summarize my issue. We have been using aggregated
> > > reporting for TB for a few years and recently introduced individual
> records
> > > and aggregated using query builder to the same aggregated dataset.
> This was
> > > customized to the exact national paper report and report was generated
> from
> > > dataset report for printing.
> > >
> > > Now since agg. queries are not there we will not be able to get data
> from
> > > tracker into the same data element. If we shift to a new report using
> > > program indicators we will not be able to use the previous aggregate
> data
> > > in future analysis and comparison.
> > >
> > > To make the matter worse, there was a lot of disaggregation of data
> > > elements using categories, where we wrote queries for each one.
> > >
> > > We are stuck at a dead end at 2.22! Please suggest the best solution.
> > >
> > > Your suggestion to have program indicators in the custom dataset is a
> good
> > > idea for future. But my issue is get them into existing elements if I
> > > upgrade to 2.23, and not a few, about 700 in all reports.
> > >
> > > Regards
> > > Pramil
> > >
> > >
> > >
> > >
> > >
> > > On Fri, May 6, 2016 at 6:55 PM, Pamod Amarakoon <pam...@gmail.com>
> wrote:
> > >
> > >> Dear Lars,
> > >>
> > >> Making aggregated event data available on the fly in data set report
> > >> would certainly be a useful tool especially when maintaining
> monitoring and
> > >> evaluation forms for tracker activities.
> > >>
> > >> Thank you
> > >>
> > >> On Fri, May 6, 2016 at 6:35 PM, Lars Helge Øverland <

Re: [Dhis2-devs] [Dhis2-users] Program data into dataset

2016-05-09 Thread Pramil Liyanage
Any help on this?

Regards
Pramil

On Sat, May 7, 2016 at 8:53 PM, Pramil Liyanage <prami...@gmail.com> wrote:

> Thanks Lars. Let me summarize my issue. We have been using aggregated
> reporting for TB for a few years and recently introduced individual records
> and aggregated using query builder to the same aggregated dataset. This was
> customized to the exact national paper report and report was generated from
> dataset report for printing.
>
> Now since agg. queries are not there we will not be able to get data from
> tracker into the same data element. If we shift to a new report using
> program indicators we will not be able to use the previous aggregate data
> in future analysis and comparison.
>
> To make the matter worse, there was a lot of disaggregation of data
> elements using categories, where we wrote queries for each one.
>
> We are stuck at a dead end at 2.22! Please suggest the best solution.
>
> Your suggestion to have program indicators in the custom dataset is a good
> idea for future. But my issue is get them into existing elements if I
> upgrade to 2.23, and not a few, about 700 in all reports.
>
> Regards
> Pramil
>
>
>
>
>
> On Fri, May 6, 2016 at 6:55 PM, Pamod Amarakoon <pam...@gmail.com> wrote:
>
>> Dear Lars,
>>
>> Making aggregated event data available on the fly in data set report
>> would certainly be a useful tool especially when maintaining monitoring and
>> evaluation forms for tracker activities.
>>
>> Thank you
>>
>> On Fri, May 6, 2016 at 6:35 PM, Lars Helge Øverland <l...@dhis2.org>
>> wrote:
>>
>>> Hi Pramil,
>>>
>>> you can retrieve aggregated event data from the analytics api.
>>>
>>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s32.html
>>>
>>>
>>> Excerpt from the docs:
>>>
>>> To query for program data elements (of tracker domain type) you can get
>>> those by specifying the program for each data element using the
>>> . syntax:
>>>
>>> /api/analytics.json?dimension=dx:eBAyeGv0exc.qrur9Dvnyt5;eBAyeGv0exc.GieVkTxp4HH
>>> =pe:LAST_12_MONTHS=ou:ImspTQPwCqd
>>>
>>> One work-around could be to write a bit of Javascript and include that
>>> in the custom form to retrieve and display event based aggregated data
>>> inside the data entry form, if that is what you are looking to do.
>>>
>>>
>>> I have been pondering for a while on adding a feature where you could
>>> specify tracker-type data elements in custom data entry forms, and have the
>>> system automatically display aggregated event data, both in forms and in
>>> data set report. Let me know if that could work.
>>>
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, May 5, 2016 at 11:03 AM, Pramil Liyanage <prami...@gmail.com>
>>> wrote:
>>>
>>>> Hi everyone,
>>>>
>>>> Since the aggregation queries are not there anymore is it possible to
>>>> get program indicator value into an existing Aggregate Dataset through data
>>>> entry screen design?
>>>>
>>>> Or any other alternative workaround?
>>>>
>>>> Regards
>>>> Pramil
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> l...@dhis2.org
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> 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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] [Dhis2-users] Program data into dataset

2016-05-07 Thread Pramil Liyanage
Thanks Lars. Let me summarize my issue. We have been using aggregated
reporting for TB for a few years and recently introduced individual records
and aggregated using query builder to the same aggregated dataset. This was
customized to the exact national paper report and report was generated from
dataset report for printing.

Now since agg. queries are not there we will not be able to get data from
tracker into the same data element. If we shift to a new report using
program indicators we will not be able to use the previous aggregate data
in future analysis and comparison.

To make the matter worse, there was a lot of disaggregation of data
elements using categories, where we wrote queries for each one.

We are stuck at a dead end at 2.22! Please suggest the best solution.

Your suggestion to have program indicators in the custom dataset is a good
idea for future. But my issue is get them into existing elements if I
upgrade to 2.23, and not a few, about 700 in all reports.

Regards
Pramil





On Fri, May 6, 2016 at 6:55 PM, Pamod Amarakoon <pam...@gmail.com> wrote:

> Dear Lars,
>
> Making aggregated event data available on the fly in data set report would
> certainly be a useful tool especially when maintaining monitoring and
> evaluation forms for tracker activities.
>
> Thank you
>
> On Fri, May 6, 2016 at 6:35 PM, Lars Helge Øverland <l...@dhis2.org>
> wrote:
>
>> Hi Pramil,
>>
>> you can retrieve aggregated event data from the analytics api.
>>
>> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s32.html
>>
>>
>> Excerpt from the docs:
>>
>> To query for program data elements (of tracker domain type) you can get
>> those by specifying the program for each data element using the
>> . syntax:
>>
>> /api/analytics.json?dimension=dx:eBAyeGv0exc.qrur9Dvnyt5;eBAyeGv0exc.GieVkTxp4HH
>> =pe:LAST_12_MONTHS=ou:ImspTQPwCqd
>>
>> One work-around could be to write a bit of Javascript and include that in
>> the custom form to retrieve and display event based aggregated data inside
>> the data entry form, if that is what you are looking to do.
>>
>>
>> I have been pondering for a while on adding a feature where you could
>> specify tracker-type data elements in custom data entry forms, and have the
>> system automatically display aggregated event data, both in forms and in
>> data set report. Let me know if that could work.
>>
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>>
>> On Thu, May 5, 2016 at 11:03 AM, Pramil Liyanage <prami...@gmail.com>
>> wrote:
>>
>>> Hi everyone,
>>>
>>> Since the aggregation queries are not there anymore is it possible to
>>> get program indicator value into an existing Aggregate Dataset through data
>>> entry screen design?
>>>
>>> Or any other alternative workaround?
>>>
>>> Regards
>>> Pramil
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> 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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Program data into dataset

2016-05-05 Thread Pramil Liyanage
Hi everyone,

Since the aggregation queries are not there anymore is it possible to get
program indicator value into an existing Aggregate Dataset through data
entry screen design?

Or any other alternative workaround?

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


Re: [Dhis2-devs] Manual Aggregation

2016-05-04 Thread Pramil Liyanage
Hi Lars,

Does that mean there will be no connection between aggregate reporting and
individual records in future?

Regards
Pramil

On Wed, May 4, 2016 at 6:16 PM, Lars Helge Øverland  wrote:

> Hi Nayeem,
>
> aggregation queries have been phased on in version 2.23. In version 2.22
> it is only available as a scheduled task.
>
> regards,
>
> Lars
>
>
> On Wed, May 4, 2016 at 1:13 PM, Nayeem Al Mifthah 
> wrote:
>
>> Dear All
>> Gow can I find out Manual Aggregation in 2.22 version.
>>
>> *Nayeem Al Mifthah*
>> Consultant (Team Leader of HMIS)
>> Management Information System
>> Directorate General of Health Services (DGHS), Bangladesh
>> Supported by: UNICEF-Bangladesh
>> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
>> Cell:+8801914030574
>> Skype: nayeem.a.m
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Remove TEI

2016-05-01 Thread Pramil Liyanage
Hi all,

Since the Individual Records Module is not available now, what is the
method to remove a TEI registered by mistake?

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


Re: [Dhis2-devs] Aggregate indicators

2016-04-29 Thread Pramil Liyanage
Hi,

I also faced a similar situation when I tried to create an indicator using
expressions from two other indicators. I think it comes when a limit is
exceeded. It displays expression error and stops working. Could be a bug.

Regards
Pramil

On Sat, Apr 30, 2016 at 7:41 AM, Juan Manuel Alcantara Acosta <
jmalcanta...@gmail.com> wrote:

> Thanks Mark
> When I mentioned the need of a face lift for the editor, I was looking at
> the interface in 2.21 (20997), which is the version where I see the
> errors creating the indicator, sorry I forgot to mention that small bit of
> info ;-)
>
> Best regards,
> JM
>
>
> El 29/04/2016, a las 10:42 a.m., Mark Polak  escribió:
>
> Hey Juan,
>
> I'm open to suggestions on how to improve the usability of the indicator
> editor :) I think if you could come up with some things you would like to
> see changed i can see what i can do.
>
> 20k constants sounds like something that would need searchable constants
> (which it currently doesn't support iirc). Your knowledge of how it is used
> is obviously greater than mine, so if you have any ideas on how it
> could/would work better, feel free to share them and then i can see what we
> can do here to improve that.
>
> Basically please supply a wishlist, but no guarantees for presents ;)
> (things that i can do with the current API are more easily achievable than
> things that need server side work)
>
> Regards,
>
> Mark
>
> On Fri, Apr 29, 2016 at 5:31 PM, Juan Manuel Alcantara Acosta <
> jmalcanta...@gmail.com> wrote:
>
>> Hi Jason
>> Good to hear form you, I hope you are well.
>>
>> I agree, that is a good solution and it works very well when you
>> implement it as a function you can call form a SQL View, then you can use
>> the API to setup a cron job or use other means to take care of the
>> frequency. There is a lot you can do with this approach.
>> I was also able to setup the indicator using the API, but we want to
>> allow the user to create these indicators. Both SQL and the API are a
>> little beyond what they can or want to do. I think the indicator editor is
>> due for an face lift ;-) there are other things to consider, for example
>> having 20K constants to choose from or formulas that requires a data
>> element with an option combination that is not part of the category
>> combination assigned to the data element.
>>
>> Best regards,
>> JM
>>
>>
>>
>>
>>
>> El 29/04/2016, a las 8:30 a.m., Jason Pickering <
>> jason.p.picker...@gmail.com> escribió:
>>
>> Hi JM,
>>
>> Sounds like a bug, but quite crazy to attempt as well!
>>
>> Another way to do this, though perhaps not ideal, would be to perform
>> this calculation through SQL and inject it back into the system as a data
>> element. We have followed this approach for indicators which cannot be
>> calculated with relatively simple formulas provided by indicators, such as
>> those requiring "IF...THEN" types of calculations.
>>
>> Not ideal, but it might be an approach you wish to consider.
>>
>> Regards,
>> Jason
>>
>>
>> On Fri, Apr 29, 2016 at 3:24 PM, Juan Manuel Alcantara Acosta <
>> jmalcanta...@gmail.com> wrote:
>>
>>> Hi Lars
>>> Thank you, I looked at the database and the interface and I didn’t see a
>>> limit imposed by either one. I have a formula that sums 410 data elements,
>>> I know that sounds impractical but that’s just the way it’s required.
>>> When I build the formula, with ~300 data elements I get error #1, with
>>> the 400 I get error #2
>>>
>>> Best regards,
>>> JM
>>>
>>>
>>> Error #1
>>> jquery.min.js?_rev=20997:2 GET
>>> https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm…cZiZ%7D%0A%2B%23%7BAV0dSekxPXl%7D%0A%2B%23%7BINM6uMXWoeK%7D%0A%0A%0A%0A%0A
>>> 
>>> net::ERR_SPDY_PROTOCOL_ERRORsend @ jquery.min.js?_rev=20997:2p.extend.ajax
>>> @ jquery.min.js?_rev=20997:2getExpressionText @
>>> expressionBuilder.js?_rev=20997:82cleanExpression @
>>> expressionBuilder.js?_rev=20997:111onchange @
>>> showUpdateIndicatorForm.action?id=65566:584
>>>
>>>
>>> Error #2
>>> jquery.min.js?_rev=20997:2 GET
>>> https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm…eFqW%7D%0A%2B%23%7BePqg2GN87Ng%7D%0A%2B%23%7BFTrvVVBrdry%7D%0A%0A%0A%0A%0A
>>> 
>>> 400 ()send @ jquery.min.js?_rev=20997:2p.extend.ajax @
>>> jquery.min.js?_rev=20997:2getExpressionText @
>>> expressionBuilder.js?_rev=20997:82cleanExpression @
>>> expressionBuilder.js?_rev=20997:111onchange @
>>> showUpdateIndicatorForm.action?id=65566:584
>>>
>>>
>>>
>>> El 28/04/2016, a las 1:40 a.m., Lars Helge Øverland 
>>> escribió:
>>>
>>> Hi JM,
>>>
>>> there is no hard limit (beyond 2gb expression length;).
>>>
>>> 

Re: [Dhis2-devs] Display indicator in a different dataset

2016-04-29 Thread Pramil Liyanage
Thanks Lars

On Fri, Apr 29, 2016 at 2:10 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Pramil,
>
> no this is not possible out of the box right now.
>
> regards,
>
> Lars
>
>
> On Fri, Apr 29, 2016 at 5:42 AM, Pramil Liyanage <prami...@gmail.com>
> wrote:
>
>> Hi all,
>>
>> Is it possible to display results of an indicator created using data
>> elements of a certain dataset in the data entry form of another dataset?
>>
>> I have tried this, but the values come as zero in dataentry screen, but
>> are available when report is generated from the dataset. Does this mean
>> that indicator value table is not accessed from the form?
>>
>> Regards
>> Pramil
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


[Dhis2-devs] Display indicator in a different dataset

2016-04-28 Thread Pramil Liyanage
Hi all,

Is it possible to display results of an indicator created using data
elements of a certain dataset in the data entry form of another dataset?

I have tried this, but the values come as zero in dataentry screen, but are
available when report is generated from the dataset. Does this mean that
indicator value table is not accessed from the form?

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


Re: [Dhis2-devs] Aggregate indicators

2016-04-28 Thread Pramil Liyanage
Hi Calle,

I have some aggregate forms which have tables with subtotals and grand
totals. There is a big number. Had to use the primary elements in both
indicators which will take up more memory.

Thanks
Pramil

On Thu, Apr 28, 2016 at 3:34 PM, Calle Hedberg <calle.hedb...@gmail.com>
wrote:

> Pramil,
>
> Do you have a SIGNIFICANT requirement for nested indicators - I mean
> beyond one or two random ones? Nested indicators were originally part of
> the DHIS 1.4 design all the way back in 2003, but it was complicated to
> implement and we never had a case where it was absolutely necessary, so it
> remained in the interface but with no code in the indicator engine to
> actually process them.
>
> DHIS 1.4 do have calculated & saved data elements which would be a good
> option if your formulas contain too many data elements, but DHIS2 do not
> support that - it uses indicators for the same purpose, which without
> support for nested indicators won't help you.
>
> One workaround is to create a few "combo" data elements that represent a
> collection of data elements, and then use a script/query to populate it
> every x hours from your original source data elements. Those "combo"
> elements can then be used in indicators the normal way.
>
> Regards
> Calle
>
> On 28 April 2016 at 10:38, Lars Helge Øverland <l...@dhis2.org> wrote:
>
>>
>> Hi Pramil,
>>
>> no, not currently.
>>
>> Lars
>>
>>
>> On Thu, Apr 28, 2016 at 10:35 AM, Pramil Liyanage <prami...@gmail.com>
>> wrote:
>>
>>> Hi,
>>>
>>> Is there any possibility to use an indicator (identifier) in a formula
>>> of another indicator instead of using its formula?
>>>
>>> Regards
>>> Pramil
>>>
>>> On Thu, Apr 28, 2016 at 12:10 PM, Lars Helge Øverland <l...@dhis2.org>
>>> wrote:
>>>
>>>> Hi JM,
>>>>
>>>> there is no hard limit (beyond 2gb expression length;).
>>>>
>>>> However data analytics performance (and entry forms if you have
>>>> indicators there) will of course suffer with extremely large indicators.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>> On Wed, Apr 27, 2016 at 11:44 PM, Juan Manuel Alcantara Acosta <
>>>> jmalcanta...@gmail.com> wrote:
>>>>
>>>>> Hi Devs
>>>>> Is there a limit on the number of data elements that can be added in
>>>>> an indicator formula?
>>>>> Regards,
>>>>> JM
>>>>> ___
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to : dhis2-devs@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Lars Helge Øverland
>>>> Lead developer, DHIS 2
>>>> University of Oslo
>>>> Skype: larshelgeoverland
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to : dhis2-devs@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> 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-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Aggregate indicators

2016-04-28 Thread Pramil Liyanage
Hi,

Is there any possibility to use an indicator (identifier) in a formula of
another indicator instead of using its formula?

Regards
Pramil

On Thu, Apr 28, 2016 at 12:10 PM, Lars Helge Øverland 
wrote:

> Hi JM,
>
> there is no hard limit (beyond 2gb expression length;).
>
> However data analytics performance (and entry forms if you have indicators
> there) will of course suffer with extremely large indicators.
>
> regards,
>
> Lars
>
>
> On Wed, Apr 27, 2016 at 11:44 PM, Juan Manuel Alcantara Acosta <
> jmalcanta...@gmail.com> wrote:
>
>> Hi Devs
>> Is there a limit on the number of data elements that can be added in an
>> indicator formula?
>> Regards,
>> JM
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Datamart error

2016-04-25 Thread Pramil Liyanage
Any help on this error?

On Mon, Apr 25, 2016 at 7:53 PM, Pramil Liyanage <prami...@gmail.com> wrote:

> ​Hi Lars,
>
> Thanks for the reply. Same issue is there in 2.20 also. When upgraded to
> 2.22 there are no errors in the analytic table update, but data entered in
> the dataset is not available in reports. Log also attached.
>
> Thanks
> Pramil
>
> 2016-04-25 14:11:18Analytics tables updated: 00:00:51.725  2016-04-25
> 14:11:18Table update done  2016-04-25 14:11:18Clearing caches  2016-04-25
> 14:11:18Creating SQL views  2016-04-25 14:11:17Swapping tables  2016-04-25
> 14:11:17Swapping analytics tables  2016-04-25 14:11:05Creating indexes
>  2016-04-25 14:11:05Applying aggregation levels  2016-04-25
> 14:11:05Populating analytics tables  2016-04-25 14:11:05Creating analytics
> tables  2016-04-25 14:11:05Performing pre-create table work, processes: 3,
> org unit levels: 4  2016-04-25 14:11:04Updating event analytics table
>  2016-04-25 14:11:04Table update done  2016-04-25 14:11:04Clearing caches
>  2016-04-25 14:11:04Creating SQL views  2016-04-25 14:11:04Swapping tables
>  2016-04-25 14:11:04Swapping analytics tables  2016-04-25 14:11:04Creating
> indexes  2016-04-25 14:11:04Applying aggregation levels  2016-04-25
> 14:11:04Populating analytics tables  2016-04-25 14:11:04Creating analytics
> tables  2016-04-25 14:11:04Performing pre-create table work, processes: 3,
> org unit levels: 4  2016-04-25 14:11:04Updating organisation unit target
> table  2016-04-25 14:11:04Table update done  2016-04-25 14:11:04Clearing
> caches  2016-04-25 14:11:04Creating SQL views  2016-04-25 14:11:04Swapping
> tables  2016-04-25 14:11:04Swapping analytics tables  2016-04-25
> 14:11:04Creating indexes  2016-04-25 14:11:04Applying aggregation levels
>  2016-04-25 14:11:04Populating analytics tables  2016-04-25
> 14:11:04Creating analytics tables  2016-04-25 14:11:04Performing pre-create
> table work, processes: 3, org unit levels: 4  2016-04-25 14:11:04Updating
> completeness target table  2016-04-25 14:11:04Table update done  2016-04-25
> 14:11:04Clearing caches  2016-04-25 14:11:04Creating SQL views  2016-04-25
> 14:11:04Swapping tables  2016-04-25 14:11:04Swapping analytics tables
>  2016-04-25 14:11:03Creating indexes  2016-04-25 14:11:03Applying
> aggregation levels  2016-04-25 14:11:03Populating analytics tables
>  2016-04-25 14:11:03Creating analytics tables  2016-04-25
> 14:11:03Performing pre-create table work, processes: 3, org unit levels: 4
>  2016-04-25 14:11:03Updating completeness table  2016-04-25 14:11:03Table
> update done  2016-04-25 14:11:03Clearing caches  2016-04-25
> 14:11:03Creating SQL views  2016-04-25 14:11:03Swapping tables  2016-04-25
> 14:11:03Swapping analytics tables  2016-04-25 14:11:04Creating indexes
>  2016-04-25 14:11:04Applying aggregation levels  2016-04-25
> 14:11:04Populating analytics tables  2016-04-25 14:11:04Creating analytics
> tables  2016-04-25 14:11:04Performing pre-create table work, processes: 3,
> org unit levels: 4  2016-04-25 14:11:04Updating completeness target table
>  2016-04-25 14:11:04Table update done  2016-04-25 14:11:04Clearing caches
>  2016-04-25 14:11:04Creating SQL views  2016-04-25 14:11:04Swapping tables
>  2016-04-25 14:11:04Swapping analytics tables  2016-04-25 14:11:03Creating
> indexes  2016-04-25 14:11:03Applying aggregation levels  2016-04-25
> 14:11:03Populating analytics tables  2016-04-25 14:11:03Creating analytics
> tables  2016-04-25 14:11:03Performing pre-create table work, processes: 3,
> org unit levels: 4  2016-04-25 14:11:03Updating completeness table
>  2016-04-25 14:11:03Table update done  2016-04-25 14:11:03Clearing caches
>  2016-04-25 14:11:03Creating SQL views  2016-04-25 14:11:03Swapping tables
>  2016-04-25 14:11:03Swapping analytics tables  2016-04-25 14:11:00Creating
> indexes  2016-04-25 14:10:59Applying aggregation levels  2016-04-25
> 14:11:00Creating indexes  2016-04-25 14:10:59Applying aggregation levels
>  2016-04-25 14:10:59Populating analytics tables  2016-04-25
> 14:10:58Creating analytics tables  2016-04-25 14:10:58Performing pre-create
> table work, processes: 3, org unit levels: 4  2016-04-25 14:10:58Updating
> analytics tables  2016-04-25 14:10:59Populating analytics tables
>  2016-04-25 14:10:58Creating analytics tables  2016-04-25
> 14:10:58Performing pre-create table work, processes: 3, org unit levels: 4
>  2016-04-25 14:10:58Updating analytics tables  2016-04-25 14:10:26Updating
> resource tables  2016-04-25 14:10:26Analytics table update process started
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] Datamart error

2016-04-25 Thread Pramil Liyanage
Hi Lars,

I upgraded to 2.22. But the issue after that was data not showing in the
dataset reports and pivot tables. Analytics complete since there is no
datamart so I thought this is the issue.

On Mon, Apr 25, 2016 at 7:19 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

> Hi Pramil,
>
> do you think you could upgrade your instance to a recent DHIS 2 version?
> That way it is easier for us to help you. We usually support the three last
> releases.
>
> https://www.dhis2.org/downloads
>
> regard,
>
> Lars
>
>
>
> On Mon, Apr 25, 2016 at 3:39 PM, Pramil Liyanage <prami...@gmail.com>
> wrote:
>
>> Hi all,
>>
>> I am getting this error when trying to run the datamart in 2.19.
>> (Database postgres)
>>
>> 2016-04-25 13:11:27Process failed: java.sql.SQLSyntaxErrorException:
>> object name already exists: DEYVNZPZ39W2Y_P79KWQPTZRR
>>
>>
>> 2016-04-25 13:11:26
>>
>>
>> Populating crosstabulation table
>>
>> What could be the reason? The second part of the object is a category
>> option combo. Below is the log.
>>
>> Regards
>> Pramil
>>
>>
>> * INFO  2016-04-25 18:40:07,553 Using periods: [[Quarterly: Fri Apr 01
>> 00:00:00 IST 2016 - Thu Jun 30 00:00:00 IST 2016]] (DataMartTask.java
>> [taskScheduler-1])
>> * ERROR 2016-04-25 18:40:07,718 Initialised statement manager
>> (StatementInterceptor.java [taskScheduler-1])
>> * ERROR 2016-04-25 18:40:08,232 Initialised statement manager
>> (StatementInterceptor.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:08,351 Data mart export process started, number
>> of CPU cores: 4, Mem Total in JVM: 4959 Free in JVM: 3514 Max Limit: 6667:
>> 00:00:00.000 (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:08,351 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:40:08 IST 2016, message: Data mart export process started]
>> (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:08,440 Recreated temporary tables: 00:00:00.089
>> (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:08,441 Data elements: 89, indicators: 182,
>> periods: 1, org units: 453: 00:00:00.090 (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:08,552 Retrieved meta-data objects, using
>> periods: [[Quarterly: 2016-04-01 - 2016-06-30]]: 00:00:00.201 (Clock.java
>> [taskScheduler-1])
>> * INFO  2016-04-25 18:40:08,552 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:40:08 IST 2016, message: Filtering meta-data]
>> (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:43,798 Filtered objects: 00:00:35.447
>> (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:43,860 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:40:43 IST 2016, message: Loading indicators]
>> (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:43,947 Exploded indicator expressions:
>> 00:00:35.596 (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:40:43,947 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:40:43 IST 2016, message: Loading data elements]
>> (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:24,111 Retrieved operands: 1002: 00:01:15.760
>> (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:24,299 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:41:24 IST 2016, message: Loading periods]
>> (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:24,904 Number of periods: 1: 00:01:16.553
>> (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:24,905 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:41:24 IST 2016, message: Filtering data elements without
>> data] (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:26,062 Number of operands with data: 97, Mem
>> Total in JVM: 4944 Free in JVM: 3350 Max Limit: 6667: 00:01:17.711
>> (Clock.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:26,062 [Level: INFO, category: DATAMART, time:
>> Mon Apr 25 18:41:26 IST 2016, message: Populating crosstabulation table]
>> (InMemoryNotifier.java [taskScheduler-1])
>> * INFO  2016-04-25 18:41:27,117 Crosstab table columns: 99, rows: 0
>> (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-18])
>> * INFO  2016-04-25 18:41:27,118 Crosstab table columns: 99, rows: 0
>> (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-21])
>> * INFO  2016-04-25 18:41:27,149 Crosstab table columns: 99, rows: 0
>> (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-19])
>> * INFO  2016-04-25 18:41:27,166 Crosstab table columns: 99, rows: 0
>

Re: [Dhis2-devs] [Dhis2-users] Program rule does not seem to be working

2015-09-21 Thread Pramil Liyanage
You are welcome. Same thing happened in an earlier build and I replaced
with the latest at that time which was 19876 and worked for me. Did not try
19884. May be the same issue repeating.

Pramil

On Mon, Sep 21, 2015 at 9:01 PM, Ese Egerega <e...@cis.com.ng> wrote:

> Thanks Pramil,
>
> Using single quotes and clearing my cache fixed the problem for me.
>
> However, it appears that the very latest build version 19884 has a
> problem with program rules. When you create and add a rule, it
> disappears. I tested this on dhis2 demo site and got the same result. I
> have copied the developers list in case this is a bug that needs to be
> fixed.
>
> Thanks again,
>
> -Ese
>
> On Mon, Sep 21, 2015 at 4:06 AM, Ese Egerega <e...@cis.com.ng> wrote:
>
>> Thanks so much Pramil. I will try that now.
>>
>> -Ese
>>
>> On Mon, Sep 21, 2015 at 3:45 AM, Pramil Liyanage <prami...@gmail.com>
>> wrote:
>>
>>> Dear Ese,
>>>
>>> Try with single quotations 'Female' and clear the cache and try.
>>> If not working, get the latest build and try. I also had a similar issue
>>> with an older build, but when I replaced with the latest, worked fine.
>>>
>>> Regards
>>> Pramil
>>>
>>> On Mon, Sep 21, 2015 at 8:00 AM, Ese Egerega <e...@cis.com.ng> wrote:
>>>
>>>> Dear all,
>>>>
>>>> The Program Rule feature does not seem to be working for me. I am
>>>> trying to hide a section in the tracker based on if the Gender selected
>>>> during program registration is Female.
>>>>
>>>> To achieve this, I created a program rule that should hide the section
>>>> but nothing seem to happen in Tracker Capture. The section is still
>>>> displayed as if there is no rule set.
>>>>
>>>> In program rule I entered Gender as source field and used the following
>>>> as my expression:
>>>>
>>>> A{Gender} == "Female"
>>>>
>>>> I will appreciate any assistance.
>>>>
>>>> Thanks,
>>>> Ese
>>>>
>>>>
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-us...@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> <http://hissl.lk/index.php/2015-conference>
>>>
>>
>>
>


-- 
<http://hissl.lk/index.php/2015-conference>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] [Dhis2-users] individual records will be phased out

2015-09-10 Thread Pramil Liyanage
Hi,

Thanks for the info. What will happen to the operations options of tracked
entity instance management? They are not available in the Tracker Capture I
think. For example, deleting an entity instance.

[image: Inline image 1]

Regards
Pramil

On Fri, Sep 11, 2015 at 8:41 AM, Hannan Khan  wrote:

> Dear Lars
>
> Thank you for informing us.
>
> My Issues exactly as Ese Egerega. The 'Active Program' section of patient
> dashboard is important where we can see the existing programs the patient
> enroll with. So please include in the new tracker Dashboard. Also please
> think about improving the look of the existing tracker dashboard.
>
> Thank you again for your continuous initiative to improve DHIS2.
>
> Best regards
>
> Hannan
> HISP Bangladesh
>
> On Thu, Sep 10, 2015 at 4:10 PM, Lars Helge Øverland 
> wrote:
>
>> Hi,
>>
>> we will remove the "Individual records" web module for version 2.21. This
>> module has been replaced by the "Tracker capture" app. If you are still
>> using the individual records module we recommend that you move over to
>> Tracker capture, and that you report potentially missing features in
>> Tracker capture to the DHIS 2 developer list.
>>
>> regards,
>>
>> Lars
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> http://www.dhis2.org 
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

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


Re: [Dhis2-devs] [Dhis2-users] Display indicator in another dataset

2015-07-21 Thread Pramil Liyanage
Yes, Agreed totally. But my requirement is to display the value in the form
only. Not to enter a value. I think that is the purpose to have indicators
available in the Design Data Entry Form page.

In my case it is to used as a guide in data entry. I know that can be done
using validation rules, but prefer to have it while entering the data.

Thanks

On Wed, Jul 22, 2015 at 8:44 AM, Ocaya Stephen stepho...@gmail.com wrote:

 Dear Pramil,

 I am not sure if indicators can just be used for data entry in DHIS2. In
 DHIS2, indicators are calculated from data elements which are instead used
 in data entry.

 In this case, your indicators can be used while generating your reports
 e.g. using pivot table or any other analytics packages of DHIS2.

 Thanks
 Stephen O.
 On Jul 22, 2015 6:07 AM, Pramil Liyanage prami...@gmail.com wrote:

 Hi,

 I have an instance where I calculate an indicator from data of one
 dataset (TB08) and display the indicator in the same dataset as well as in
 another dataset (TB10) in the same quarter
 ​ at data entry form​
 .

 My issue is on the data entry form of TB10, the value of that indicator
 is displayed as zero. I have tried completing the
 ​other ​
 dataset
 ​ (TB08),running the analytics and clearing all the cache. I can see the
 data value in the dataset report of TB10, issue is not displaying at the
 data entry form.

 Is this a bug or DHIS cannot use one indicator in two data entry forms? I
 have attached screenshots.
 ​ I'm running 2.18 on postgres.​


 Thanks

 Pramil


 --




 --
 http://hissl.lk/index.php/2015-conference

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




-- 
http://hissl.lk/index.php/2015-conference
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-devs] TB tracker

2015-07-05 Thread Pramil Liyanage
Dear Hannan,

I have started developing a TB reporting system and currently at the stage
of customizing the aggregated reporting part in 2.18. Will be developing
the individual record part next to aggregate using the queries. In Sri
Lanka, we have a good paper based reporting system and it is easy to
convert that to electronic format.

If you can send me your requirement, I can have a look and we can work
together,

Thanks

Pramil

On Sun, Jul 5, 2015 at 2:48 PM, channara rin rin.chann...@gmail.com wrote:

 Could you share TB patient tracking on DHIS2 forum? I am happy want to
 learn.

 thank you so much
 CHANNARA

 On Sun, Jul 5, 2015 at 1:28 PM, Pamod Amarakoon pam...@gmail.com wrote:

 Dear Hannan,

 Dr. Pramil Liyanage is managing the TB registry in a DHIS2 instance for
 Sri Lanka. I'll copy him.

 On Sun, Jul 5, 2015 at 11:55 AM, Hannan Khan hann...@gmail.com wrote:

 Dear all

 We are trying to include TB patient tracking in our national dhis2
 system. If any of you are using similar system please help me to design our
 system.

 Regards

 Hannan Khan
 Bangladesh DHIS2 coordinator


 --
 Sent from Gmail iPhone

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




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

 [image: eHealth Asia 2015] http://bit.ly/eha2015


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





-- 
http://hissl.lk/index.php/2015-conference
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp