Re: [Dhis2-users] Help needed: Checking a string with single quote in program rule...

[M.Selvaraaj Prabu]

Thank you very much Terence and Markus, for your valuable suggestions.

I am not sure whether the first suggestion can be implemented since we have
already migrated 1000's data with these values.

The second suggestion, using the code sounds good for me. Let me check the
design and see what I can do.

Thanks once again for sparing your valuable time to respond.

Thanks and regards

MSP


On Wed, Oct 31, 2018 at 1:54 PM Markus Bekken  wrote:

> Hey MSP - escaping single quotes is not supported as of now, it would be
> great if you create a feature request for it.
>
> As Terence says, there might be workarounds - one suggested below. If
> "don't know" is one of the options in an option set, I am guessing that
> there is a code for this option value - hopefully the code is without a
> quotation mark. If this is the case, open the program rule variable in
> maintenance and select "use code for option set":
> When this is checked, you can possibly rewrite your rule to check for the
> option instead:
>
> #{variable} == 'OPT_DONT_KNOW_CODE'
>
> Markus
>
> 31. okt. 2018 kl. 07:55 skrev Terence Scott <
> terence.sc...@rabiesalliance.org>:
>
> Hi MSP
>
> I am not sure how to rectify the problem directly, but several easy
> solutions would be to simply reword the response to: 'Unsure', 'unknown',
> 'not known' or similar.
>
> 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 Tue, Oct 30, 2018 at 10:26 PM M.Selvaraaj Prabu 
> wrote:
>
>> Hi all.
>>
>> Kindly assist me to resolve this issue.
>>
>> I want to check a single quoted string in a program rule such as
>> "variable == 'Don't know'". I tried using two single quotes (Don''t know)
>> and escaped with a backward slash (Don\'t know) but it doesn't work.
>>
>> Any suggestions? Your help is very much appreciated.
>>
>> Thanks and regards.
>>
>> MSP
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help needed: Checking a string with single quote in program rule...

[Markus Bekken]

Hey MSP - escaping single quotes is not supported as of now, it would be great 
if you create a feature request for it.

As Terence says, there might be workarounds - one suggested below. If "don't 
know" is one of the options in an option set, I am guessing that there is a 
code for this option value - hopefully the code is without a quotation mark. If 
this is the case, open the program rule variable in maintenance and select "use 
code for option set":

When this is checked, you can possibly rewrite your rule to check for the 
option instead:

#{variable} == 'OPT_DONT_KNOW_CODE'

Markus

> 31. okt. 2018 kl. 07:55 skrev Terence Scott  >:
> 
> Hi MSP
> 
> I am not sure how to rectify the problem directly, but several easy solutions 
> would be to simply reword the response to: 'Unsure', 'unknown', 'not known' 
> or similar. 
> 
> 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 Tue, Oct 30, 2018 at 10:26 PM M.Selvaraaj Prabu  > wrote:
> Hi all.
> 
> Kindly assist me to resolve this issue. 
> 
> I want to check a single quoted string in a program rule such as "variable == 
> 'Don't know'". I tried using two single quotes (Don''t know) and escaped with 
> a backward slash (Don\'t know) but it doesn't work.
> 
> Any suggestions? Your help is very much appreciated.
> 
> Thanks and regards.
> 
> MSP
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> 
> Post to : dhis2-users@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-users 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> 
> Post to : dhis2-users@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-users 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 

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

Re: [Dhis2-users] Help needed: Checking a string with single quote in program rule...

[Terence Scott]

Hi MSP

I am not sure how to rectify the problem directly, but several easy
solutions would be to simply reword the response to: 'Unsure', 'unknown',
'not known' or similar.

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 Tue, Oct 30, 2018 at 10:26 PM M.Selvaraaj Prabu 
wrote:

> Hi all.
>
> Kindly assist me to resolve this issue.
>
> I want to check a single quoted string in a program rule such as "variable
> == 'Don't know'". I tried using two single quotes (Don''t know) and escaped
> with a backward slash (Don\'t know) but it doesn't work.
>
> Any suggestions? Your help is very much appreciated.
>
> Thanks and regards.
>
> MSP
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Help needed: Checking a string with single quote in program rule...

[M.Selvaraaj Prabu]

Hi all.

Kindly assist me to resolve this issue.

I want to check a single quoted string in a program rule such as "variable
== 'Don't know'". I tried using two single quotes (Don''t know) and escaped
with a backward slash (Don\'t know) but it doesn't work.

Any suggestions? Your help is very much appreciated.

Thanks and regards.

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

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

[Terence Scott]

Glad to hear it!


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 Tue, Oct 30, 2018 at 1:03 PM M.Selvaraaj Prabu  wrote:

> Thank you very much Mr.Terence for pointing to the right direction. It
> worked.
>
> Thanks and regards
>
> MSP
>
>
> On Tue, Oct 30, 2018 at 12:39 PM Terence Scott <
> terence.sc...@rabiesalliance.org> wrote:
>
>> Dear MSP
>>
>> I am not sure if you are aware, but see the following documentation for
>> the codes used to create the "current date" in the program rule.
>>
>> https://docs.dhis2.org/2.30/en/user/html/configure_program_rule.html
>>
>> Please see *Table 21.14. Standard variables to use in program rule
>> expressions  *
>>
>> From what I am aware, these variables are applicable to past versions
>> also (therefore should work for 2.29 and 2.28 as I have used them in 2.28).
>>
>> I hope this helps.
>>
>> 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 Tue, Oct 30, 2018 at 12:11 PM M.Selvaraaj Prabu 
>> wrote:
>>
>>> Hi all,
>>>
>>> I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2
>>> (2.29) to manage our OVC database. We are using Tracker App to capture the
>>> individual case management.
>>>
>>> We have a field (data element) called "Data entered on" and this has to
>>> be the current date and time. I created a data element "Data entered on" as
>>> "Date" type. Now I want to assign the current date and time automatically
>>> to this field when the form is opened. Unfortunately, I am failing to set
>>> this up through a program rule. I could not find a function or system
>>> variable to use for this purpose.
>>>
>>> Any help is highly appreciated.
>>>
>>> Thanks and regards
>>>
>>> MSP
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

[M.Selvaraaj Prabu]

Thank you very much Mr.Terence for pointing to the right direction. It
worked.

Thanks and regards

MSP


On Tue, Oct 30, 2018 at 12:39 PM Terence Scott <
terence.sc...@rabiesalliance.org> wrote:

> Dear MSP
>
> I am not sure if you are aware, but see the following documentation for
> the codes used to create the "current date" in the program rule.
>
> https://docs.dhis2.org/2.30/en/user/html/configure_program_rule.html
>
> Please see *Table 21.14. Standard variables to use in program rule
> expressions  *
>
> From what I am aware, these variables are applicable to past versions also
> (therefore should work for 2.29 and 2.28 as I have used them in 2.28).
>
> I hope this helps.
>
> 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 Tue, Oct 30, 2018 at 12:11 PM M.Selvaraaj Prabu 
> wrote:
>
>> Hi all,
>>
>> I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2
>> (2.29) to manage our OVC database. We are using Tracker App to capture the
>> individual case management.
>>
>> We have a field (data element) called "Data entered on" and this has to
>> be the current date and time. I created a data element "Data entered on" as
>> "Date" type. Now I want to assign the current date and time automatically
>> to this field when the form is opened. Unfortunately, I am failing to set
>> this up through a program rule. I could not find a function or system
>> variable to use for this purpose.
>>
>> Any help is highly appreciated.
>>
>> Thanks and regards
>>
>> MSP
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

[Terence Scott]

Dear MSP

I am not sure if you are aware, but see the following documentation for the
codes used to create the "current date" in the program rule.

https://docs.dhis2.org/2.30/en/user/html/configure_program_rule.html

Please see *Table 21.14. Standard variables to use in program rule
expressions  *

>From what I am aware, these variables are applicable to past versions also
(therefore should work for 2.29 and 2.28 as I have used them in 2.28).

I hope this helps.

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 Tue, Oct 30, 2018 at 12:11 PM M.Selvaraaj Prabu 
wrote:

> Hi all,
>
> I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2
> (2.29) to manage our OVC database. We are using Tracker App to capture the
> individual case management.
>
> We have a field (data element) called "Data entered on" and this has to be
> the current date and time. I created a data element "Data entered on" as
> "Date" type. Now I want to assign the current date and time automatically
> to this field when the form is opened. Unfortunately, I am failing to set
> this up through a program rule. I could not find a function or system
> variable to use for this purpose.
>
> Any help is highly appreciated.
>
> Thanks and regards
>
> MSP
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Help needed: Assigning current date to a data element...

[M.Selvaraaj Prabu]

Hi all,

I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2 (2.29)
to manage our OVC database. We are using Tracker App to capture the
individual case management.

We have a field (data element) called "Data entered on" and this has to be
the current date and time. I created a data element "Data entered on" as
"Date" type. Now I want to assign the current date and time automatically
to this field when the form is opened. Unfortunately, I am failing to set
this up through a program rule. I could not find a function or system
variable to use for this purpose.

Any help is highly appreciated.

Thanks and regards

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

Re: [Dhis2-users] HELP NEEDED: Interpretations module

[Terence Scott]

Hi Georgi

We are experiencing the same issues, as we are also working between
multiple countries with data that should not be shared between different
countries. As you mentioned, all of the other permissions restrict other
countries from seeing country-specific data, but the interpretations (and
that associated charts/tables etc.) are shared publicly.

Have you managed to find a means to prevent this?

I did a quick search on JIRA and could not find anything relevant. Have you
opened an issue there that I could possibly vote on?

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, Jan 24, 2018 at 10:12 PM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:

> Hi all,
>
>
>
> We are using DHIS2 2.28 and have a small trouble with Interpretations. We
> have several parties using DHIS2. All of them have individual reports
> (pivot tables and charts) that cannot be seen by the other parties (managed
> through reports sharing options).
>
> The report sharing work and we get only users that need to see certain
> reports to actually see them. However this is not the case with
> interpretations. When a user writes an interpretation on a report they are
> allowed to see, *all other users see that interpretation.*
>
> I would expect that user would be able to see interpretations only for the
> reports that have been shared with them, but this is not the case. All
> users can see all interpretations. Do you have an idea how to fix this? If
> not, is there a way to disable interpretations module?
>
>
>
> Looking forward to your comments!
>
>
>
> Regards,
>
> Georgi
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* 
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] HELP NEEDED: Interpretations module

[Georgi Chakarov]

Hi all,

We are using DHIS2 2.28 and have a small trouble with Interpretations. We have 
several parties using DHIS2. All of them have individual reports (pivot tables 
and charts) that cannot be seen by the other parties (managed through reports 
sharing options).
The report sharing work and we get only users that need to see certain reports 
to actually see them. However this is not the case with interpretations. When a 
user writes an interpretation on a report they are allowed to see, all other 
users see that interpretation.
I would expect that user would be able to see interpretations only for the 
reports that have been shared with them, but this is not the case. All users 
can see all interpretations. Do you have an idea how to fix this? If not, is 
there a way to disable interpretations module?

Looking forward to your comments!

Regards,
Georgi


Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net

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

Re: [Dhis2-users] HELP with program indicator/report

[Georgi Chakarov]

Hi Markus,

I tried both event and enrollment analytics. Neither of them worked.
I will report this as well.

Georgi

From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Monday, August 28, 2017 3:07 PM
To: Georgi Chakarov <geo...@logicaloutcomes.net>
Cc: DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list 
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] HELP with program indicator/report

Hey again Georgi,
this seems like a bug with the d2:hasValue function. Using enrollment 
analytics, the intended outcome for 
d2:hasValue(#{programStageWithNoEvents.dataelement}) is false. Just making sure 
your program indcator was an enrollment program indicator - could you register 
this as a bug?

Markus

28. aug. 2017 kl. 12.01 skrev Georgi Chakarov 
<geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net>>:

Hi Markus,

Thanks a lot for putting thoughts into this! I also did.

I do have a pivotal data element, but regardless of the expression it wouldn’t 
work. This is because DHIS2 cannot evaluate a data element from an event that 
hasn’t been created.
Let’s assume that my entity is at second stage. This means that I have created 
events for the first and the second stage (the third stage will have event only 
when the entity passes at the third stage).
In this case the filter would be:
d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})

I have tested this, but DHIS2 fails to produce a result because stage 3 and 4 
do not have events yet, thus the indicator cannot assess whether the pivotal 
data element in these stages has value or not.
Is this making sense?

So, I decided to play with tracked entity attribute values in the profile of my 
entity.
Markus, can I assign values to a tracked entity (with an option set), based on 
a data element value in a current stage?

Regards,

Georgi


From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Monday, August 28, 2017 11:30 AM
To: Georgi Chakarov 
<geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net>>
Cc: DHIS Users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>; DHIS 
2 Developers list 
<dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>>
Subject: Re: [Dhis2-users] HELP with program indicator/report

Hi there Georgi,
We do not have a function that does exactly what you asked for, but hopefully 
we can find a way if we examine the data elements in your stages. Do the stages 
have a data element that is mandatory, or at least so pivotal that you can sue 
that data element to determine wether the event should be counted? If so I'd 
recommend looking at a program indicator with the analytics type enrollment. 
With this strategy you can make four program indicators that fullfills the 
explicit requirement for 1, 2, 3 and 4 stages:
Just first stage:
d2:hasValue(#{stage1.dataelement}) && !d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
Just first and second stage:
d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
..and so on.

With the above strategy you would find every tracked entity that has followed 
the expected sequence of events. If you have any requirements for how to count 
the possible cases that deviates the normal(just stage 1 and 3 for example), 
the expressions might look different.

If there is no data element that you can use to proxy the presence of events, 
you will need a new function for checking events regardless of data. In that 
case, please report this as a Jira issue.

Markus

25. aug. 2017 kl. 12.11 skrev Georgi Chakarov 
<geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net>>:

Hello all,

I have a tracker program with 4 consecutive non-repeatable stages. Each new 
stage is created after completion of the previous stage.
I am trying to create a report/program indicator that counts the tracked 
entities at their latest stage. In other words, I want to know how many tracked 
entities I have at each stage without double counting.

For example, I have 10 tracked entities each of them starting at stage I. 2 
tracked entities progressed at stage II , 2 progressed at stage III and two 
progressed at stage IV.
My report should show (program indicator should calculate) that 4 tracked 
entities are still at stage I, 2 are in stage II, 2 are in stage III and 2 are 
in stage IV.

Do you have any idea how to build this one?

Georgi


Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | Y

Re: [Dhis2-users] HELP with program indicator/report

[Georgi Chakarov]

Hi Markus,

Thanks a lot for putting thoughts into this! I also did.

I do have a pivotal data element, but regardless of the expression it wouldn't 
work. This is because DHIS2 cannot evaluate a data element from an event that 
hasn't been created.
Let's assume that my entity is at second stage. This means that I have created 
events for the first and the second stage (the third stage will have event only 
when the entity passes at the third stage).
In this case the filter would be:
d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})

I have tested this, but DHIS2 fails to produce a result because stage 3 and 4 
do not have events yet, thus the indicator cannot assess whether the pivotal 
data element in these stages has value or not.
Is this making sense?

So, I decided to play with tracked entity attribute values in the profile of my 
entity.
Markus, can I assign values to a tracked entity (with an option set), based on 
a data element value in a current stage?

Regards,

Georgi


From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Monday, August 28, 2017 11:30 AM
To: Georgi Chakarov <geo...@logicaloutcomes.net>
Cc: DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list 
<dhis2-d...@lists.launchpad.net>
Subject: Re: [Dhis2-users] HELP with program indicator/report

Hi there Georgi,
We do not have a function that does exactly what you asked for, but hopefully 
we can find a way if we examine the data elements in your stages. Do the stages 
have a data element that is mandatory, or at least so pivotal that you can sue 
that data element to determine wether the event should be counted? If so I'd 
recommend looking at a program indicator with the analytics type enrollment. 
With this strategy you can make four program indicators that fullfills the 
explicit requirement for 1, 2, 3 and 4 stages:
Just first stage:
d2:hasValue(#{stage1.dataelement}) && !d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
Just first and second stage:
d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
..and so on.

With the above strategy you would find every tracked entity that has followed 
the expected sequence of events. If you have any requirements for how to count 
the possible cases that deviates the normal(just stage 1 and 3 for example), 
the expressions might look different.

If there is no data element that you can use to proxy the presence of events, 
you will need a new function for checking events regardless of data. In that 
case, please report this as a Jira issue.

Markus

25. aug. 2017 kl. 12.11 skrev Georgi Chakarov 
<geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net>>:

Hello all,

I have a tracker program with 4 consecutive non-repeatable stages. Each new 
stage is created after completion of the previous stage.
I am trying to create a report/program indicator that counts the tracked 
entities at their latest stage. In other words, I want to know how many tracked 
entities I have at each stage without double counting.

For example, I have 10 tracked entities each of them starting at stage I. 2 
tracked entities progressed at stage II , 2 progressed at stage III and two 
progressed at stage IV.
My report should show (program indicator should calculate) that 4 tracked 
entities are still at stage I, 2 are in stage II, 2 are in stage III and 2 are 
in stage IV.

Do you have any idea how to build this one?

Georgi


Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net<mailto:i...@logicaloutcomes.net>

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

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

Re: [Dhis2-users] HELP with program indicator/report

[Markus Bekken]

Hi there Georgi,
We do not have a function that does exactly what you asked for, but hopefully 
we can find a way if we examine the data elements in your stages. Do the stages 
have a data element that is mandatory, or at least so pivotal that you can sue 
that data element to determine wether the event should be counted? If so I'd 
recommend looking at a program indicator with the analytics type enrollment. 
With this strategy you can make four program indicators that fullfills the 
explicit requirement for 1, 2, 3 and 4 stages:
Just first stage:
d2:hasValue(#{stage1.dataelement}) && !d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
Just first and second stage:
d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
..and so on.

With the above strategy you would find every tracked entity that has followed 
the expected sequence of events. If you have any requirements for how to count 
the possible cases that deviates the normal(just stage 1 and 3 for example), 
the expressions might look different.

If there is no data element that you can use to proxy the presence of events, 
you will need a new function for checking events regardless of data. In that 
case, please report this as a Jira issue.

Markus

> 25. aug. 2017 kl. 12.11 skrev Georgi Chakarov :
> 
> Hello all,
>  
> I have a tracker program with 4 consecutive non-repeatable stages. Each new 
> stage is created after completion of the previous stage.
> I am trying to create a report/program indicator that counts the tracked 
> entities at their latest stage. In other words, I want to know how many 
> tracked entities I have at each stage without double counting.
>  
> For example, I have 10 tracked entities each of them starting at stage I. 2 
> tracked entities progressed at stage II , 2 progressed at stage III and two 
> progressed at stage IV.
> My report should show (program indicator should calculate) that 4 tracked 
> entities are still at stage I, 2 are in stage II, 2 are in stage III and 2 
> are in stage IV.
>  
> Do you have any idea how to build this one?
>  
> Georgi
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> 
> Post to : dhis2-users@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-users 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help with a program rule

[Markus Bekken]

Hi there Georgi!
Thanks for the feedback.

It seems you got it almost right except for one little detail on the usage of 
the substring function. 

To get the fifth character you would have to change your expression to:
 d2:substring(A{Client ID}, 5, 6) == '2'

There was an error in the doc, so a small update is on the way here:
19.5.6. Reference information: Operators and functions to use in program rule 
expression 


Hope this helps!

Best regards
Markus

> 4. aug. 2017 kl. 17.58 skrev Georgi Chakarov :
> 
> Hi all (again)! J
>  
> I have a challenging task for whoever is interested. I find it quite 
> difficult working with the functions in program rules expression, especially 
> learning from the user manual.
>  
> I am trying to execute the following rule:
> If the fifth character of Client ID (text attribute) is equal to ‘2’, the Sex 
> (Option set attribute) should be equal to ‘Female’. This is an example of 
> client ID: 2.
>  
> This is what I think:
> 1)  I need to extract the fifth character and evaluate whether it equals 
> ‘2’. I am using d2:substring(text, start-char-num, end-char-num)
> This is my expression d2:substring(A{Client ID}, 5, 5) == '2'
>  
> 2)  I need to push ‘Female’ option to the Sex attribute. I am not sure 
> how to do that from the program rule actions. I tried:
> a)   Assign value to Sex attribute – expression is ‘Female’
> b)  Assign value to Sex attribute – expression is A{Sex} == 'Female'
>  
> None of the combinations 1) + 2a) OR 1) + 2b) worked, regretfully.
>  
> Does any of you know or can figure out how this might work?
>  
> Regards,
>  
> Georgi 
>  
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> 
> Post to : dhis2-users@lists.launchpad.net 
> 
> Unsubscribe : https://launchpad.net/~dhis2-users 
> 
> More help   : https://help.launchpad.net/ListHelp 
> 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Help with a program rule

[Georgi Chakarov]

Hi all (again)! :)

I have a challenging task for whoever is interested. I find it quite difficult 
working with the functions in program rules expression, especially learning 
from the user manual.

I am trying to execute the following rule:
If the fifth character of Client ID (text attribute) is equal to '2', the Sex 
(Option set attribute) should be equal to 'Female'. This is an example of 
client ID: 2.

This is what I think:

1)  I need to extract the fifth character and evaluate whether it equals 
'2'. I am using d2:substring(text, start-char-num, end-char-num)
This is my expression d2:substring(A{Client ID}, 5, 5) == '2'


2)  I need to push 'Female' option to the Sex attribute. I am not sure how 
to do that from the program rule actions. I tried:

a)   Assign value to Sex attribute - expression is 'Female'

b)  Assign value to Sex attribute - expression is A{Sex} == 'Female'

None of the combinations 1) + 2a) OR 1) + 2b) worked, regretfully.

Does any of you know or can figure out how this might work?

Regards,

Georgi



Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net

___
Mailing list: https://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] Help needed: Show/hide previous DE entry based on a selection

[Mugisha, Jean F.]

Dear all,

We have the following use case and your advice would be greatly appreciated.

Our use-case needs to show/hide a previous DE entry based on a current Yes/No 
selection. Below are the few requirements that are needed:


  1.  1st visit: User enters data.
  2.  2nd visit: User enters data.
 *   IF user selects Yes on a data element THEN a text box (message) should 
show up with the previous (in this case 1st visit) data element information (as 
a FYI message to the user).
 *   IF user selects No on a data element THEN the FYI message is hidden.

We have created tracker program to get the data, but unfortunately, we have 
been unable to implement 2.a. in DHIS2. I am sure that we are missing something 
but I can’t seem to figure it out.

Any help would be greatly appreciated.

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

Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue

[Sean Broomhead]

PS: I know Calle has been tackling this in his disease surveillance work.
His update may be useful.

On Tue, Jun 13, 2017 at 11:49 AM, Sean Broomhead <s...@hisp.org> wrote:

> Hello All - this is a key use case for HIV data and will be for many other
> health programmes too. I will be happy to be part of these discussions and
> draw in some more of our public health experts as needed.
>
> Best regards,
> Sean
>
> On Tue, Jun 13, 2017 at 11:45 AM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
>> Thanks Knut!
>>
>>
>>
>> I haven’t yet heard from the community. Looking forward to, though! I
>> believe there must be someone out there working with HIV programs that
>> needs to protect personal client data. Anyone?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Georgi
>>
>>
>>
>> *From:* Knut Staring [mailto:knu...@gmail.com]
>> *Sent:* Monday, June 12, 2017 2:25 PM
>> *To:* Georgi Chakarov <geo...@logicaloutcomes.net>
>> *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>; DHIS
>> Users <dhis2-users@lists.launchpad.net>
>> *Subject:* Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue
>>
>>
>>
>> Thanks for the request Georgi,
>>
>>
>>
>> How to set up and maintain such complex access schemes is still
>> exceedingly tricky, and I think guidance and probably improved user
>> interfaces to handle this is one of the key areas that needs strengthening.
>> There should probably be a task force set up around it - unfortunately that
>> is not likely to happen right now that the summer holidays are approaching,
>> so hopefully experienced members of the community will be able to chip in
>> with tips. I hope this will be a lively thread.
>>
>>
>>
>> Knut
>>
>>
>>
>> On Mon, Jun 12, 2017 at 1:01 PM, Georgi Chakarov <
>> geo...@logicaloutcomes.net> wrote:
>>
>> Hi DHIS 2 community!
>>
>>
>>
>> We have the following case and your advice will be highly appreciated!
>>
>> We have a client that works with vulnerable children and vulnerable
>> adults. Our client has 6 (six) partners that provide a long list of
>> services based on the needs of the beneficiaries. Among these services are
>> HIV testing, HIV status determination and HIV related service. Each partner
>> needs to protect HIV information for its beneficiaries from the other
>> partners.
>>
>> Here are a few requirements, posed by our client:
>>
>> 1)  All partners use the same tool for capturing data (we have
>> configured tracker capture program to register beneficiaries and track
>> service provision)
>>
>> 2)  Partners are able to see each other’s data, EXCEPT FOR HIV
>> related data
>>
>> 3)  There is this one partner whose data should not be seen by
>> anybody else (this partner can see other partners’ data, though)
>>
>> 4)  There are area overlaps, meaning that partners might work in the
>> same village, e.g.
>>
>> We have a design problem, in which we cannot figure out how to enable all
>> partners to use the same tracker program, but at the same time to satisfy
>> the requirements above. This is what we have tried so far:
>>
>> A)  Data element sharing. We tried to share HIV data elements with a
>> few partners only, to test whether the rest of the partners can see those
>> data elements in data entry. Yes, they were able to see them, so this
>> option would not work for us. Sharing data elements determines what users
>> will see in reports, not in data entry.
>>
>> B)  We tried creating Attribute categories and sharing them, with
>> selected partners. This didn’t work for the same reason as above. Sharing
>> restricts access in reporting but not in data entry.
>>
>> C)  We can create six different tracker programs for each partner,
>> but we have so many program indicators to build for reporting that 6
>> separate programs will increase our work by 6. It will also be hard to our
>> client to manage 6 programs for a number of reasons.
>>
>> Our question is: Does anyone have an idea how to design our system so
>> that we enable partners to work on the same tracker program, but be able to
>> see/enter data pertaining only to them?
>>
>>
>>
>> Thanks in advance for your time and attention!
>>
>>
>>
>> Regards,
>>
>>
>>
>> Georgi
>>
>>
>>
>>
>>
>>
>> Georgi Chakarov, 

Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue

[Sean Broomhead]

Hello All - this is a key use case for HIV data and will be for many other
health programmes too. I will be happy to be part of these discussions and
draw in some more of our public health experts as needed.

Best regards,
Sean

On Tue, Jun 13, 2017 at 11:45 AM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:

> Thanks Knut!
>
>
>
> I haven’t yet heard from the community. Looking forward to, though! I
> believe there must be someone out there working with HIV programs that
> needs to protect personal client data. Anyone?
>
>
>
> Thanks,
>
>
>
> Georgi
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Monday, June 12, 2017 2:25 PM
> *To:* Georgi Chakarov <geo...@logicaloutcomes.net>
> *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>; DHIS Users
> <dhis2-users@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue
>
>
>
> Thanks for the request Georgi,
>
>
>
> How to set up and maintain such complex access schemes is still
> exceedingly tricky, and I think guidance and probably improved user
> interfaces to handle this is one of the key areas that needs strengthening.
> There should probably be a task force set up around it - unfortunately that
> is not likely to happen right now that the summer holidays are approaching,
> so hopefully experienced members of the community will be able to chip in
> with tips. I hope this will be a lively thread.
>
>
>
> Knut
>
>
>
> On Mon, Jun 12, 2017 at 1:01 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hi DHIS 2 community!
>
>
>
> We have the following case and your advice will be highly appreciated!
>
> We have a client that works with vulnerable children and vulnerable
> adults. Our client has 6 (six) partners that provide a long list of
> services based on the needs of the beneficiaries. Among these services are
> HIV testing, HIV status determination and HIV related service. Each partner
> needs to protect HIV information for its beneficiaries from the other
> partners.
>
> Here are a few requirements, posed by our client:
>
> 1)  All partners use the same tool for capturing data (we have
> configured tracker capture program to register beneficiaries and track
> service provision)
>
> 2)  Partners are able to see each other’s data, EXCEPT FOR HIV
> related data
>
> 3)  There is this one partner whose data should not be seen by
> anybody else (this partner can see other partners’ data, though)
>
> 4)  There are area overlaps, meaning that partners might work in the
> same village, e.g.
>
> We have a design problem, in which we cannot figure out how to enable all
> partners to use the same tracker program, but at the same time to satisfy
> the requirements above. This is what we have tried so far:
>
> A)  Data element sharing. We tried to share HIV data elements with a
> few partners only, to test whether the rest of the partners can see those
> data elements in data entry. Yes, they were able to see them, so this
> option would not work for us. Sharing data elements determines what users
> will see in reports, not in data entry.
>
> B)  We tried creating Attribute categories and sharing them, with
> selected partners. This didn’t work for the same reason as above. Sharing
> restricts access in reporting but not in data entry.
>
> C)  We can create six different tracker programs for each partner,
> but we have so many program indicators to build for reporting that 6
> separate programs will increase our work by 6. It will also be hard to our
> client to manage 6 programs for a number of reasons.
>
> Our question is: Does anyone have an idea how to design our system so that
> we enable partners to work on the same tracker program, but be able to
> see/enter data pertaining only to them?
>
>
>
> Thanks in advance for your time and attention!
>
>
>
> Regards,
>
>
>
> Georgi
>
>
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* <i...@logicaloutcomes.net>
>
>
>
>
> ___
> Mailing list: https://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 Sta

Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue

[Georgi Chakarov]

Thanks Knut!

I haven’t yet heard from the community. Looking forward to, though! I believe 
there must be someone out there working with HIV programs that needs to protect 
personal client data. Anyone?

Thanks,

Georgi

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Monday, June 12, 2017 2:25 PM
To: Georgi Chakarov <geo...@logicaloutcomes.net>
Cc: DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>; DHIS Users 
<dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue

Thanks for the request Georgi,

How to set up and maintain such complex access schemes is still exceedingly 
tricky, and I think guidance and probably improved user interfaces to handle 
this is one of the key areas that needs strengthening. There should probably be 
a task force set up around it - unfortunately that is not likely to happen 
right now that the summer holidays are approaching, so hopefully experienced 
members of the community will be able to chip in with tips. I hope this will be 
a lively thread.

Knut

On Mon, Jun 12, 2017 at 1:01 PM, Georgi Chakarov 
<geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net>> wrote:
Hi DHIS 2 community!

We have the following case and your advice will be highly appreciated!
We have a client that works with vulnerable children and vulnerable adults. Our 
client has 6 (six) partners that provide a long list of services based on the 
needs of the beneficiaries. Among these services are HIV testing, HIV status 
determination and HIV related service. Each partner needs to protect HIV 
information for its beneficiaries from the other partners.
Here are a few requirements, posed by our client:

1)  All partners use the same tool for capturing data (we have configured 
tracker capture program to register beneficiaries and track service provision)

2)  Partners are able to see each other’s data, EXCEPT FOR HIV related data

3)  There is this one partner whose data should not be seen by anybody else 
(this partner can see other partners’ data, though)

4)  There are area overlaps, meaning that partners might work in the same 
village, e.g.
We have a design problem, in which we cannot figure out how to enable all 
partners to use the same tracker program, but at the same time to satisfy the 
requirements above. This is what we have tried so far:

A)  Data element sharing. We tried to share HIV data elements with a few 
partners only, to test whether the rest of the partners can see those data 
elements in data entry. Yes, they were able to see them, so this option would 
not work for us. Sharing data elements determines what users will see in 
reports, not in data entry.

B)  We tried creating Attribute categories and sharing them, with selected 
partners. This didn’t work for the same reason as above. Sharing restricts 
access in reporting but not in data entry.

C)  We can create six different tracker programs for each partner, but we 
have so many program indicators to build for reporting that 6 separate programs 
will increase our work by 6. It will also be hard to our client to manage 6 
programs for a number of reasons.
Our question is: Does anyone have an idea how to design our system so that we 
enable partners to work on the same tracker program, but be able to see/enter 
data pertaining only to them?

Thanks in advance for your time and attention!

Regards,

Georgi



Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net<mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 
x 104<tel:(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 
720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from 
receiving commercial electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net<mailto:i...@logicaloutcomes.net>


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



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

Re: [Dhis2-users] HELP NEEDED: DHIS2 design issue

[Knut Staring]

Thanks for the request Georgi,

How to set up and maintain such complex access schemes is still exceedingly
tricky, and I think guidance and probably improved user interfaces to
handle this is one of the key areas that needs strengthening. There should
probably be a task force set up around it - unfortunately that is not
likely to happen right now that the summer holidays are approaching, so
hopefully experienced members of the community will be able to chip in with
tips. I hope this will be a lively thread.

Knut

On Mon, Jun 12, 2017 at 1:01 PM, Georgi Chakarov  wrote:

> Hi DHIS 2 community!
>
>
>
> We have the following case and your advice will be highly appreciated!
>
> We have a client that works with vulnerable children and vulnerable
> adults. Our client has 6 (six) partners that provide a long list of
> services based on the needs of the beneficiaries. Among these services are
> HIV testing, HIV status determination and HIV related service. Each partner
> needs to protect HIV information for its beneficiaries from the other
> partners.
>
> Here are a few requirements, posed by our client:
>
> 1)  All partners use the same tool for capturing data (we have
> configured tracker capture program to register beneficiaries and track
> service provision)
>
> 2)  Partners are able to see each other’s data, EXCEPT FOR HIV
> related data
>
> 3)  There is this one partner whose data should not be seen by
> anybody else (this partner can see other partners’ data, though)
>
> 4)  There are area overlaps, meaning that partners might work in the
> same village, e.g.
>
> We have a design problem, in which we cannot figure out how to enable all
> partners to use the same tracker program, but at the same time to satisfy
> the requirements above. This is what we have tried so far:
>
> A)  Data element sharing. We tried to share HIV data elements with a
> few partners only, to test whether the rest of the partners can see those
> data elements in data entry. Yes, they were able to see them, so this
> option would not work for us. Sharing data elements determines what users
> will see in reports, not in data entry.
>
> B)  We tried creating Attribute categories and sharing them, with
> selected partners. This didn’t work for the same reason as above. Sharing
> restricts access in reporting but not in data entry.
>
> C)  We can create six different tracker programs for each partner,
> but we have so many program indicators to build for reporting that 6
> separate programs will increase our work by 6. It will also be hard to our
> client to manage 6 programs for a number of reasons.
>
> Our question is: Does anyone have an idea how to design our system so that
> we enable partners to work on the same tracker program, but be able to
> see/enter data pertaining only to them?
>
>
>
> Thanks in advance for your time and attention!
>
>
>
> Regards,
>
>
>
> Georgi
>
>
>
>
>
>
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104
> <(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation,
> 720 Bathurst Street, Toronto Canada M5S 2R4 | *You may unsubscribe from
> receiving commercial electronic messages from LogicalOutcomes by emailing *
> *i...@logicaloutcomes.net* 
>
>
>
> ___
> Mailing list: https://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

[Dhis2-users] HELP NEEDED: DHIS2 design issue

[Georgi Chakarov]

Hi DHIS 2 community!

We have the following case and your advice will be highly appreciated!

We have a client that works with vulnerable children and vulnerable adults. Our 
client has 6 (six) partners that provide a long list of services based on the 
needs of the beneficiaries. Among these services are HIV testing, HIV status 
determination and HIV related service. Each partner needs to protect HIV 
information for its beneficiaries from the other partners.
Here are a few requirements, posed by our client:

1)  All partners use the same tool for capturing data (we have configured 
tracker capture program to register beneficiaries and track service provision)

2)  Partners are able to see each other's data, EXCEPT FOR HIV related data

3)  There is this one partner whose data should not be seen by anybody else 
(this partner can see other partners' data, though)

4)  There are area overlaps, meaning that partners might work in the same 
village, e.g.
We have a design problem, in which we cannot figure out how to enable all 
partners to use the same tracker program, but at the same time to satisfy the 
requirements above. This is what we have tried so far:

A)  Data element sharing. We tried to share HIV data elements with a few 
partners only, to test whether the rest of the partners can see those data 
elements in data entry. Yes, they were able to see them, so this option would 
not work for us. Sharing data elements determines what users will see in 
reports, not in data entry.

B)  We tried creating Attribute categories and sharing them, with selected 
partners. This didn't work for the same reason as above. Sharing restricts 
access in reporting but not in data entry.

C)  We can create six different tracker programs for each partner, but we 
have so many program indicators to build for reporting that 6 separate programs 
will increase our work by 6. It will also be hard to our client to manage 6 
programs for a number of reasons.
Our question is: Does anyone have an idea how to design our system so that we 
enable partners to work on the same tracker program, but be able to see/enter 
data pertaining only to them?

Thanks in advance for your time and attention!

Regards,

Georgi



Georgi Chakarov, CIA | 
geo...@logicaloutcomes.net | +1-647-478-5634 
x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
electronic messages from LogicalOutcomes by emailing 
i...@logicaloutcomes.net

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

Re: [Dhis2-users] Help! What has happened to my data element and indicator translations?

[Jason Pickering]

This should be part of the upgrade procedure actually. If this did not
happen, then we would need more information from your logs. Something may
have gone wrong during the update.

Do you happen to have any views directly on the database itself (not
created through DHIS2?) Did you drop all views prior to upgrading as
reccomended in the upgrade notes?

On Thu, Dec 1, 2016 at 1:30 PM, TIMIMI, Hazim Bakir <timi...@who.int> wrote:

> Ah, yes, I see now, thanks for that. The dataelementtranslations table, as
> was the objecttranslation table. I added a couple of translations via the
> interface and see now how they are populated.
>
>
>
> Do you know of any ready-made SQL script that would take translations from
> the old format and populate the new tables, or should I just roll my own?
>
>
>
> Thanks again!
>
>
>
> Hazim
>
>
>
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* 01 December 2016 12:53
>
> *To:* TIMIMI, Hazim Bakir
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Help! What has happened to my data element
> and indicator translations?
>
>
>
> Hi.
>
>
>
> If you are on 2.25, these should be stored in the dataelementtranslations
> table.
>
>
>
> Is there anything there? Otherwise, something may have gone wrong during
> the upgrade procedure.
>
>
>
> Regards,
>
> Jason
>
>
>
>
>
> On Thu, Dec 1, 2016 at 12:44 PM, TIMIMI, Hazim Bakir <timi...@who.int>
> wrote:
>
> Hi Jason,
>
>
>
> Thanks for the quick reply. Like I said, we upgraded from 2.23 to 2.25. It
> looks like we are on build revision 6ce8201. I have seen the same problem
> on  a local Ubuntu test server using build revision 221c5d8.
>
>
>
> The translations are not visible anywhere, not in the visualisation
> modules nor in the maintenance module. But I know they are in the
> database’s translate table as per my email below. See screenshots of
> maintenance module and output of the SQL view for one of the data elements.
>
>
>
> [image: cid:image001.jpg@01D24BCE.06E0D5F0]
>
>
>
>
>
> [image: cid:image002.jpg@01D24BCE.06E0D5F0]
>
>
>
> Mystifying!
>
>
>
> Any hints most welcome.
>
>
>
> Thanks and best wishes,
>
>
>
> Hazim
>
>
>
>
>
>
>
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* 01 December 2016 12:14
> *To:* TIMIMI, Hazim Bakir
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Help! What has happened to my data element
> and indicator translations?
>
>
>
> Hi Hazim,
>
>
>
> Which version are you running?  Depending on the version, the translations
> of data elements are no longer in that table.
>
>
>
> Does this happen in specific apps or are they not even visible in the
> maintenance module when looking at a specific data element?
>
> Regards
>
> Jason
>
>
>
>
>
> On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir <timi...@who.int>
> wrote:
>
> Hi there,
>
> We recently upgraded our DHIS2 server from 2.23 to 2.25. The French
> translations we previously had for data elements and indicators no longer
> appear if you change language preferences. In the maintenance module
> clicking on the translate for those data elements/indicators no longer
> shows the translations. Yet when I run the following query (via Data
> Administration > SQL View) I can see that the French translations are still
> there in the translation table:
>
> /* See data element names and descriptions along with French translations
> */
> SELECT  object.uid,
> object.code,
> object.name,
> object.shortname,
> object.description,
> t_name.name_fr,
> shortname_fr,
> description_fr
>
> FROM dataelement AS object
>  LEFT OUTER JOIN (SELECT objectuid, value AS name_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'name'
>) AS t_name ON
>   object.uid = t_name.objectuid
>
>  LEFT OUTER JOIN (SELECT objectuid, value AS
> shortname_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'shortName'
>) AS t_shor

Re: [Dhis2-users] Help! What has happened to my data element and indicator translations?

[TIMIMI , Hazim Bakir]

Ah, yes, I see now, thanks for that. The dataelementtranslations table, as was 
the objecttranslation table. I added a couple of translations via the interface 
and see now how they are populated.
 
Do you know of any ready-made SQL script that would take translations from the 
old format and populate the new tables, or should I just roll my own?
 
Thanks again!
 
Hazim
 
From: Jason Pickering [mailto:jason.p.picker...@gmail.com] 
Sent: 01 December 2016 12:53
To: TIMIMI, Hazim Bakir
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help! What has happened to my data element and 
indicator translations?
 
Hi. 
 

If you are on 2.25, these should be stored in the dataelementtranslations 
table. 

 

Is there anything there? Otherwise, something may have gone wrong during the 
upgrade procedure. 

 

Regards,

Jason

 

 
On Thu, Dec 1, 2016 at 12:44 PM, TIMIMI, Hazim Bakir <timi...@who.int> wrote:
Hi Jason,
 
Thanks for the quick reply. Like I said, we upgraded from 2.23 to 2.25. It 
looks like we are on build revision 6ce8201. I have seen the same problem on  a 
local Ubuntu test server using build revision 221c5d8. 
 
The translations are not visible anywhere, not in the visualisation modules nor 
in the maintenance module. But I know they are in the database’s translate 
table as per my email below. See screenshots of maintenance module and output 
of the SQL view for one of the data elements.
 
 [cid:image001.jpg@01D24BCE.06E0D5F0] 
 
 
 [cid:image002.jpg@01D24BCE.06E0D5F0] 
 
Mystifying!
 
Any hints most welcome.
 
Thanks and best wishes,
 
Hazim
 
 
 
From: Jason Pickering [mailto:jason.p.picker...@gmail.com] 
Sent: 01 December 2016 12:14
To: TIMIMI, Hazim Bakir
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help! What has happened to my data element and 
indicator translations?
 
Hi Hazim,
 

Which version are you running?  Depending on the version, the translations of 
data elements are no longer in that table. 

 

Does this happen in specific apps or are they not even visible in the 
maintenance module when looking at a specific data element?

Regards

Jason

 

 
On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir <timi...@who.int> wrote:
Hi there,

We recently upgraded our DHIS2 server from 2.23 to 2.25. The French 
translations we previously had for data elements and indicators no longer 
appear if you change language preferences. In the maintenance module clicking 
on the translate for those data elements/indicators no longer shows the 
translations. Yet when I run the following query (via Data Administration > SQL 
View) I can see that the French translations are still there in the translation 
table:

/* See data element names and descriptions along with French translations */
SELECT  object.uid,
object.code,
object.name,
object.shortname,
object.description,
t_name.name_fr,
shortname_fr,
description_fr

FROM dataelement AS object
 LEFT OUTER JOIN (SELECT objectuid, value AS name_fr
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'name'
   ) AS t_name ON
  object.uid = t_name.objectuid

 LEFT OUTER JOIN (SELECT objectuid, value AS shortname_fr
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'shortName'
   ) AS t_shortname ON
  object.uid = t_shortname.objectuid

 LEFT OUTER JOIN (SELECT objectuid, value AS description_fr
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'description'
   ) AS t_description ON
  object.uid = t_description.objectuid;


Any clues/advice on how to fix this would be much appreciated!

With many thanks in advance,

Hazim
…..
Hazim Timimi
Data Manager, Tuberculosis Monitoring and Evaluation, World Health 
Organization, Geneva, Switzerland
Tel : +41 22 791 3468



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




 

-- 
Jason P. Pickering
email: jason.p.picker..

Re: [Dhis2-users] Help! What has happened to my data element and indicator translations?

[Jason Pickering]

Hi.

If you are on 2.25, these should be stored in the dataelementtranslations
table.

Is there anything there? Otherwise, something may have gone wrong during
the upgrade procedure.

Regards,
Jason


On Thu, Dec 1, 2016 at 12:44 PM, TIMIMI, Hazim Bakir <timi...@who.int>
wrote:

> Hi Jason,
>
>
>
> Thanks for the quick reply. Like I said, we upgraded from 2.23 to 2.25. It
> looks like we are on build revision 6ce8201. I have seen the same problem
> on  a local Ubuntu test server using build revision 221c5d8.
>
>
>
> The translations are not visible anywhere, not in the visualisation
> modules nor in the maintenance module. But I know they are in the
> database’s translate table as per my email below. See screenshots of
> maintenance module and output of the SQL view for one of the data elements.
>
>
>
> [image: cid:image001.jpg@01D24BCE.06E0D5F0]
>
>
>
>
>
> [image: cid:image002.jpg@01D24BCE.06E0D5F0]
>
>
>
> Mystifying!
>
>
>
> Any hints most welcome.
>
>
>
> Thanks and best wishes,
>
>
>
> Hazim
>
>
>
>
>
>
>
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
> *Sent:* 01 December 2016 12:14
> *To:* TIMIMI, Hazim Bakir
> *Cc:* dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-users] Help! What has happened to my data element
> and indicator translations?
>
>
>
> Hi Hazim,
>
>
>
> Which version are you running?  Depending on the version, the translations
> of data elements are no longer in that table.
>
>
>
> Does this happen in specific apps or are they not even visible in the
> maintenance module when looking at a specific data element?
>
> Regards
>
> Jason
>
>
>
>
>
> On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir <timi...@who.int>
> wrote:
>
> Hi there,
>
> We recently upgraded our DHIS2 server from 2.23 to 2.25. The French
> translations we previously had for data elements and indicators no longer
> appear if you change language preferences. In the maintenance module
> clicking on the translate for those data elements/indicators no longer
> shows the translations. Yet when I run the following query (via Data
> Administration > SQL View) I can see that the French translations are still
> there in the translation table:
>
> /* See data element names and descriptions along with French translations
> */
> SELECT  object.uid,
> object.code,
> object.name,
> object.shortname,
> object.description,
> t_name.name_fr,
> shortname_fr,
> description_fr
>
> FROM dataelement AS object
>  LEFT OUTER JOIN (SELECT objectuid, value AS name_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'name'
>) AS t_name ON
>   object.uid = t_name.objectuid
>
>  LEFT OUTER JOIN (SELECT objectuid, value AS
> shortname_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'shortName'
>) AS t_shortname ON
>   object.uid = t_shortname.objectuid
>
>  LEFT OUTER JOIN (SELECT objectuid, value AS
> description_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'description'
>) AS t_description
> ON
>   object.uid = t_description.objectuid;
>
>
> Any clues/advice on how to fix this would be much appreciated!
>
> With many thanks in advance,
>
> Hazim
> …..
> Hazim Timimi
> Data Manager, Tuberculosis Monitoring and Evaluation, World Health
> Organization, Geneva, Switzerland
> Tel : +41 22 791 3468
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46764147049>
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help! What has happened to my data element and indicator translations?

[TIMIMI , Hazim Bakir]

Hi Jason,
 
Thanks for the quick reply. Like I said, we upgraded from 2.23 to 2.25. It 
looks like we are on build revision 6ce8201. I have seen the same problem on  a 
local Ubuntu test server using build revision 221c5d8. 
 
The translations are not visible anywhere, not in the visualisation modules nor 
in the maintenance module. But I know they are in the database’s translate 
table as per my email below. See screenshots of maintenance module and output 
of the SQL view for one of the data elements.
 
 [cid:image001.jpg@01D24BCE.06E0D5F0] 
 
 
 [cid:image002.jpg@01D24BCE.06E0D5F0] 
 
Mystifying!
 
Any hints most welcome.
 
Thanks and best wishes,
 
Hazim
 
 
 
From: Jason Pickering [mailto:jason.p.picker...@gmail.com] 
Sent: 01 December 2016 12:14
To: TIMIMI, Hazim Bakir
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help! What has happened to my data element and 
indicator translations?
 
Hi Hazim,
 

Which version are you running?  Depending on the version, the translations of 
data elements are no longer in that table. 

 

Does this happen in specific apps or are they not even visible in the 
maintenance module when looking at a specific data element?

Regards

Jason

 

 
On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir <timi...@who.int> wrote:
Hi there,

We recently upgraded our DHIS2 server from 2.23 to 2.25. The French 
translations we previously had for data elements and indicators no longer 
appear if you change language preferences. In the maintenance module clicking 
on the translate for those data elements/indicators no longer shows the 
translations. Yet when I run the following query (via Data Administration > SQL 
View) I can see that the French translations are still there in the translation 
table:

/* See data element names and descriptions along with French translations */
SELECT  object.uid,
object.code,
object.name,
object.shortname,
object.description,
t_name.name_fr,
shortname_fr,
description_fr

FROM dataelement AS object
 LEFT OUTER JOIN (SELECT objectuid, value AS name_fr
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'name'
   ) AS t_name ON
  object.uid = t_name.objectuid

 LEFT OUTER JOIN (SELECT objectuid, value AS shortname_fr
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'shortName'
   ) AS t_shortname ON
  object.uid = t_shortname.objectuid

 LEFT OUTER JOIN (SELECT objectuid, value AS description_fr
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'description'
   ) AS t_description ON
  object.uid = t_description.objectuid;


Any clues/advice on how to fix this would be much appreciated!

With many thanks in advance,

Hazim
…..
Hazim Timimi
Data Manager, Tuberculosis Monitoring and Evaluation, World Health 
Organization, Geneva, Switzerland
Tel : +41 22 791 3468



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




 

-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049


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

Re: [Dhis2-users] Help! What has happened to my data element and indicator translations?

[Jason Pickering]

Hi Hazim,

Which version are you running?  Depending on the version, the translations
of data elements are no longer in that table.

Does this happen in specific apps or are they not even visible in the
maintenance module when looking at a specific data element?
Regards
Jason


On Thu, Dec 1, 2016 at 10:23 AM, TIMIMI, Hazim Bakir 
wrote:

> Hi there,
>
> We recently upgraded our DHIS2 server from 2.23 to 2.25. The French
> translations we previously had for data elements and indicators no longer
> appear if you change language preferences. In the maintenance module
> clicking on the translate for those data elements/indicators no longer
> shows the translations. Yet when I run the following query (via Data
> Administration > SQL View) I can see that the French translations are still
> there in the translation table:
>
> /* See data element names and descriptions along with French translations
> */
> SELECT  object.uid,
> object.code,
> object.name,
> object.shortname,
> object.description,
> t_name.name_fr,
> shortname_fr,
> description_fr
>
> FROM dataelement AS object
>  LEFT OUTER JOIN (SELECT objectuid, value AS name_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'name'
>) AS t_name ON
>   object.uid = t_name.objectuid
>
>  LEFT OUTER JOIN (SELECT objectuid, value AS
> shortname_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'shortName'
>) AS t_shortname ON
>   object.uid = t_shortname.objectuid
>
>  LEFT OUTER JOIN (SELECT objectuid, value AS
> description_fr
>FROMtranslation
>   WHERE  locale = 'fr'
> AND
>
>  objectproperty = 'description'
>) AS t_description
> ON
>   object.uid = t_description.objectuid;
>
>
> Any clues/advice on how to fix this would be much appreciated!
>
> With many thanks in advance,
>
> Hazim
> …..
> Hazim Timimi
> Data Manager, Tuberculosis Monitoring and Evaluation, World Health
> Organization, Geneva, Switzerland
> Tel : +41 22 791 3468
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://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] Help! What has happened to my data element and indicator translations?

[TIMIMI , Hazim Bakir]

Hi there,

We recently upgraded our DHIS2 server from 2.23 to 2.25. The French 
translations we previously had for data elements and indicators no longer 
appear if you change language preferences. In the maintenance module clicking 
on the translate for those data elements/indicators no longer shows the 
translations. Yet when I run the following query (via Data Administration > SQL 
View) I can see that the French translations are still there in the translation 
table:

/* See data element names and descriptions along with French translations */
SELECT  object.uid,
object.code,
object.name,
object.shortname,
object.description,
t_name.name_fr,
shortname_fr,
description_fr

FROM dataelement AS object 
 LEFT OUTER JOIN (SELECT objectuid, value AS name_fr 
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'name'
   ) AS t_name ON
  object.uid = t_name.objectuid

 LEFT OUTER JOIN (SELECT objectuid, value AS shortname_fr 
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'shortName'
   ) AS t_shortname ON
  object.uid = t_shortname.objectuid

 LEFT OUTER JOIN (SELECT objectuid, value AS description_fr 
   FROMtranslation
  WHERE  locale = 'fr' AND
 
objectproperty = 'description'
   ) AS t_description ON
  object.uid = t_description.objectuid;


Any clues/advice on how to fix this would be much appreciated!

With many thanks in advance,

Hazim
…..
Hazim Timimi
Data Manager, Tuberculosis Monitoring and Evaluation, World Health 
Organization, Geneva, Switzerland
Tel : +41 22 791 3468



___
Mailing list: https://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] [HELP] Timezone impact of DHIS Server

[Sultanahamar Mohammad]

Hi All,

We are about to implement DHIS in two level hierarchy one server hosted in
cloud and several other DHIS instances in fields where data is collected
and synced with cloud instance. In this regard, we want to understand on
how each of you are working out with the timezones of server machines. Is
every DHIS server is configured to follow UTC or they have their default
timezone of the region.
Please reply us with your valuable suggestions. Each response is very
important as they would help us achieve deploying DHIS in the right way
from the start.

Regards,
Sultan Ahamar.
___
Mailing list: https://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] Help! for crossDomain issue

[DJIBRIL Hakim]

Hi all
Can anyone please help on this?
I am trying to do design a webportal using this authentification

jQuery(document).ready(function() {

  $.post( base + "dhis-web-commons-security/login.action?authOnly=true", {

  j_username: "admin", j_password: "district"

}

  );

});

I add the hosted url in cors whitelist  but still get the same issue , so I
am choosing to add *crossdomain : true.*


How add *it* in this code?

Best reagrds.


Hakim DJIBRIL
IT advisor.
___
Mailing list: https://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] Help configuring Postgres 9.5 and Java Opts for DHIS-2 2.23

[Wilson, Randy]

Hi all,

I have an Intel Core i7 Windows 10 64bit computer with 16 Gig of RAM and
can't seem to configure it to run analytics correctly.

I ran analytics just fine on the same computer with the same DHIS-2
instance using 2.21 and postgres 9.4 - it took just over 1 hour to run.

Now it seems to hang after about 2 hours... no error message.

I've tried the settings recommended in the 2.23 implementation guide but
then I can't even get the instance to run.  I have cut back on the
Java_opts and added the UseCodeCasheFlushing..

-Xmx7000m -Xms3000m -XX:+UseCodeCacheFlushing

My main postgres.conf file settings - somewhat modified from the
recommendations, are below:

# - Memory -

shared_buffers = 1600MB # min 128kB
work_mem = 10MB # min 64kB
maintenance_work_mem = 512MB # min 1MB
maintenance_work_mem
dynamic_shared_memory_type = windows # the default is the first option
#--
# WRITE AHEAD LOG
#--


synchronous_commit = off # synchronization level;
# off, local, remote_write, or on
wal_buffers = 16MB # min 32kB, -1 sets based on shared_buffers
# (change requires restart)
wal_writer_delay = 1ms # 1-1 milliseconds



-- 
*Randy Wilson*
*Team Leader: **Knowledge Management, Data Use and Research*
Rwanda Health System Strengthening Activity
Management Sciences for Health
Rwanda-Kigali
Direct: +250 788308835
E-mail: rwil...@msh.org
Skype: wilsonrandy_us

Stronger health systems. Greater health impact.



www.msh.org

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help with DSH2 config.

[Lars Helge Øverland]

Hi Norberto,

for that you will need a server which is connected to the internet.

You can read more about server installation here:

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html

You can read more about hosting of DHIS 2 here:

https://www.dhis2.org/hosting


regards,

Lars


On Fri, Dec 5, 2014 at 12:17 PM, Norberto Banze norbertoba...@live.com
wrote:


 Hi guys,

 I am new in this group and still learning about dhis2.
 I have downloaded and installed Dhis2 and linked it with Postgresql on my
 laptop. How can I do to make it available to other users that I have
 created, I want them to access the database over the internet.

 If anyone can help I would be grateful

 best regards,
 Norberto Banze

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


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

[Dhis2-users] Help with DSH2 config.

[Norberto Banze]

Hi guys,

I am new in this group and still learning about dhis2.
I have downloaded and installed Dhis2 and linked it with Postgresql on my 
laptop. How can I do to make it available to other users that I have created, I 
want them to access the database over the internet.

If anyone can help I would be grateful

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

Re: [Dhis2-users] Help with DSH2 config.

[Norberto Banze]

Thanks.

Sent from Samsung Mobile

div Original message /divdivFrom: Lars Helge Øverland 
larshe...@gmail.com /divdivDate:05/12/2014  12:26  (GMT+02:00) 
/divdivTo: Norberto Banze norbertoba...@live.com /divdivCc: 
dhis2-users dhis2-users@lists.launchpad.net /divdivSubject: Re: 
[Dhis2-users] Help with DSH2 config. /divdiv
/div
Hi Norberto,

for that you will need a server which is connected to the internet.

You can read more about server installation here:

https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html

You can read more about hosting of DHIS 2 here:

https://www.dhis2.org/hosting


regards,

Lars


On Fri, Dec 5, 2014 at 12:17 PM, Norberto Banze norbertoba...@live.com
wrote:


 Hi guys,

 I am new in this group and still learning about dhis2.
 I have downloaded and installed Dhis2 and linked it with Postgresql on my
 laptop. How can I do to make it available to other users that I have
 created, I want them to access the database over the internet.

 If anyone can help I would be grateful

 best regards,
 Norberto Banze

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


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

Re: [Dhis2-users] Help with DSH2 config.

[Norberto Banze]

Hi everyone,

Can somebody PLEASE  help me with this error. I am trying to install dhis2. 
When I invoked mvn install I got this error
  


From: norbertoba...@live.com
To: dhis2-users@lists.launchpad.net
Subject: Help with DSH2 config.
Date: Fri, 5 Dec 2014 12:17:15 +0200





Hi guys,

I am new in this group and still learning about dhis2.
I have downloaded and installed Dhis2 and linked it with Postgresql on my 
laptop. How can I do to make it available to other users that I have created, I 
want them to access the database over the internet.

If anyone can help I would be grateful

best regards,
Norberto Banze

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

Re: [Dhis2-users] Help with DSH2 config.

[Knut Staring]

No need to use Maven
On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:

 Hi everyone,

 Can somebody PLEASE  help me with this error. I am trying to install
 dhis2. When I invoked mvn install I got this error





 --
 From: norbertoba...@live.com
 To: dhis2-users@lists.launchpad.net
 Subject: Help with DSH2 config.
 Date: Fri, 5 Dec 2014 12:17:15 +0200


 Hi guys,

 I am new in this group and still learning about dhis2.
 I have downloaded and installed Dhis2 and linked it with Postgresql on my
 laptop. How can I do to make it available to other users that I have
 created, I want them to access the database over the internet.

 If anyone can help I would be grateful

 best regards,
 Norberto Banze

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


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

Re: [Dhis2-users] Help with DSH2 config.

[Norberto Banze]

How should I proceed 

Date: Fri, 5 Dec 2014 21:53:47 +0800
Subject: Re: [Dhis2-users] Help with DSH2 config.
From: knu...@gmail.com
To: norbertoba...@live.com
CC: dhis2-users@lists.launchpad.net

No need to use Maven
On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:



Hi everyone,

Can somebody PLEASE  help me with this error. I am trying to install dhis2. 
When I invoked mvn install I got this error
  


From: norbertoba...@live.com
To: dhis2-users@lists.launchpad.net
Subject: Help with DSH2 config.
Date: Fri, 5 Dec 2014 12:17:15 +0200





Hi guys,

I am new in this group and still learning about dhis2.
I have downloaded and installed Dhis2 and linked it with Postgresql on my 
laptop. How can I do to make it available to other users that I have created, I 
want them to access the database over the internet.

If anyone can help I would be grateful

best regards,
Norberto Banze

  

___

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

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help   : https://help.launchpad.net/ListHelp


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

Re: [Dhis2-users] Help with DSH2 config.

[Norberto Banze]

I am following the steps that come here https://www.dhis2.org/development 

From: norbertoba...@live.com
To: knu...@gmail.com
CC: dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Help with DSH2 config.
Date: Fri, 5 Dec 2014 15:56:54 +0200




How should I proceed 

Date: Fri, 5 Dec 2014 21:53:47 +0800
Subject: Re: [Dhis2-users] Help with DSH2 config.
From: knu...@gmail.com
To: norbertoba...@live.com
CC: dhis2-users@lists.launchpad.net

No need to use Maven
On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:



Hi everyone,

Can somebody PLEASE  help me with this error. I am trying to install dhis2. 
When I invoked mvn install I got this error
  


From: norbertoba...@live.com
To: dhis2-users@lists.launchpad.net
Subject: Help with DSH2 config.
Date: Fri, 5 Dec 2014 12:17:15 +0200





Hi guys,

I am new in this group and still learning about dhis2.
I have downloaded and installed Dhis2 and linked it with Postgresql on my 
laptop. How can I do to make it available to other users that I have created, I 
want them to access the database over the internet.

If anyone can help I would be grateful

best regards,
Norberto Banze

  

___

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

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help   : https://help.launchpad.net/ListHelp



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

Re: [Dhis2-users] Help with DSH2 config.

[Knut Staring]

If you need a server I propose you go with a hosted solution, as described
on our website.

Regards,
Knut
On 5 Dec 2014 21:56, Norberto Banze norbertoba...@live.com wrote:

 How should I proceed

 --
 Date: Fri, 5 Dec 2014 21:53:47 +0800
 Subject: Re: [Dhis2-users] Help with DSH2 config.
 From: knu...@gmail.com
 To: norbertoba...@live.com
 CC: dhis2-users@lists.launchpad.net

 No need to use Maven
 On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:

 Hi everyone,

 Can somebody PLEASE  help me with this error. I am trying to install
 dhis2. When I invoked mvn install I got this error





 --
 From: norbertoba...@live.com
 To: dhis2-users@lists.launchpad.net
 Subject: Help with DSH2 config.
 Date: Fri, 5 Dec 2014 12:17:15 +0200


 Hi guys,

 I am new in this group and still learning about dhis2.
 I have downloaded and installed Dhis2 and linked it with Postgresql on my
 laptop. How can I do to make it available to other users that I have
 created, I want them to access the database over the internet.

 If anyone can help I would be grateful

 best regards,
 Norberto Banze

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


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

Re: [Dhis2-users] Help with DSH2 config.

[Jason Pickering]

Are you sure you are connected to the Internet? maven needs to download a
lot of components, so be sure you are on a fast line. Alternatively, you
can always get the latest build from https://apps.dhis2.org/ci/.

Regards
Jason
On Dec 5, 2014 2:58 PM, Norberto Banze norbertoba...@live.com wrote:

 I am following the steps that come here https://www.dhis2.org/development

 --
 From: norbertoba...@live.com
 To: knu...@gmail.com
 CC: dhis2-users@lists.launchpad.net
 Subject: RE: [Dhis2-users] Help with DSH2 config.
 Date: Fri, 5 Dec 2014 15:56:54 +0200

 How should I proceed

 --
 Date: Fri, 5 Dec 2014 21:53:47 +0800
 Subject: Re: [Dhis2-users] Help with DSH2 config.
 From: knu...@gmail.com
 To: norbertoba...@live.com
 CC: dhis2-users@lists.launchpad.net

 No need to use Maven
 On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:

 Hi everyone,

 Can somebody PLEASE  help me with this error. I am trying to install
 dhis2. When I invoked mvn install I got this error





 --
 From: norbertoba...@live.com
 To: dhis2-users@lists.launchpad.net
 Subject: Help with DSH2 config.
 Date: Fri, 5 Dec 2014 12:17:15 +0200


 Hi guys,

 I am new in this group and still learning about dhis2.
 I have downloaded and installed Dhis2 and linked it with Postgresql on my
 laptop. How can I do to make it available to other users that I have
 created, I want them to access the database over the internet.

 If anyone can help I would be grateful

 best regards,
 Norberto Banze

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


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


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

Re: [Dhis2-users] Help with DSH2 config.

[Bharath]

Hi, I think the issue that Norberto Banze mentioned is exists when building
first time maven is failed to download the smslib jar.

On Fri, Dec 5, 2014 at 7:35 PM, Jason Pickering jason.p.picker...@gmail.com
 wrote:

 Are you sure you are connected to the Internet? maven needs to download a
 lot of components, so be sure you are on a fast line. Alternatively, you
 can always get the latest build from https://apps.dhis2.org/ci/.

 Regards
 Jason
 On Dec 5, 2014 2:58 PM, Norberto Banze norbertoba...@live.com wrote:

 I am following the steps that come here https://www.dhis2.org/development

 --
 From: norbertoba...@live.com
 To: knu...@gmail.com
 CC: dhis2-users@lists.launchpad.net
 Subject: RE: [Dhis2-users] Help with DSH2 config.
 Date: Fri, 5 Dec 2014 15:56:54 +0200

 How should I proceed

 --
 Date: Fri, 5 Dec 2014 21:53:47 +0800
 Subject: Re: [Dhis2-users] Help with DSH2 config.
 From: knu...@gmail.com
 To: norbertoba...@live.com
 CC: dhis2-users@lists.launchpad.net

 No need to use Maven
 On 5 Dec 2014 21:36, Norberto Banze norbertoba...@live.com wrote:

 Hi everyone,

 Can somebody PLEASE  help me with this error. I am trying to install
 dhis2. When I invoked mvn install I got this error





 --
 From: norbertoba...@live.com
 To: dhis2-users@lists.launchpad.net
 Subject: Help with DSH2 config.
 Date: Fri, 5 Dec 2014 12:17:15 +0200


 Hi guys,

 I am new in this group and still learning about dhis2.
 I have downloaded and installed Dhis2 and linked it with Postgresql on my
 laptop. How can I do to make it available to other users that I have
 created, I want them to access the database over the internet.

 If anyone can help I would be grateful

 best regards,
 Norberto Banze

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


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


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




-- 

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

Re: [Dhis2-users] Help for testing DHIS Live

[Tony Iha]

Could do that, is there a test plan and what is the time frame.  I have two
laptops one is running the complete version and would only connect through
the browser to the installed DHIS2 on one laptop.

Yes I could do that, just let me know exactly what areas to look for.


On Thu, Sep 12, 2013 at 9:15 AM, Knut Staring knu...@gmail.com wrote:

 Does someone on the list have some time to test DHIS Live on a clean
 Windows machine (i.e. which is not already set up to run DHIS2)?

 We get a lot of complaints that it is not working.

 Thanks,
 Knut


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


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




-- 
Tony Iha Kazungu
Database Administrator
tony...@gmail.com,tony_...@lycos.com
(254) 0725-547006
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help for testing DHIS Live

[Knut Staring]

Thanks!  The basics are most important : you get it to run and it works
with H2 (ie out of the box). I assume that means it will also work with
Postgres.
Den 12. sep. 2013 13:27 skrev Tony Iha tony...@gmail.com følgende:

 Could do that, is there a test plan and what is the time frame.  I have
 two laptops one is running the complete version and would only connect
 through the browser to the installed DHIS2 on one laptop.

 Yes I could do that, just let me know exactly what areas to look for.


 On Thu, Sep 12, 2013 at 9:15 AM, Knut Staring knu...@gmail.com wrote:

 Does someone on the list have some time to test DHIS Live on a clean
 Windows machine (i.e. which is not already set up to run DHIS2)?

 We get a lot of complaints that it is not working.

 Thanks,
 Knut


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


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




 --
 Tony Iha Kazungu
 Database Administrator
 tony...@gmail.com,tony_...@lycos.com
 (254) 0725-547006

___
Mailing list: https://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] [Help-Data validate]

[riddy ndoma]

Hi all,
I have a problem a problem in terms of rule validation.
I defined the validation rule, but I noticed that she is well respected
when introducing 0 or another value in various input fields. But when the
input fields are empty, the execution of the validation is done with
success, whatever the rule defined

-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Help-Data validate]

[Olav Poppe]

Hi,
you can choose whether all data elements in the expression is required to have 
a value or not for the validation rule to be effective, using the skip for 
missing values property in the expression editor. If skip is true, then it 
requires all data elements to have values. If false, only one data element must 
have a value.

Olav

19. apr. 2013 kl. 12:41 skrev riddy ndoma riddynd...@gmail.com:

 Hi all,
 I have a problem a problem in terms of rule validation. 
 I defined the validation rule, but I noticed that she is well respected when 
 introducing 0 or another value in various input fields. But when the input 
 fields are empty, the execution of the validation is done with success, 
 whatever the rule defined
 
 -- 
 Riddy NDOMA
 Software Developer
 Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
 Twitter: riddyndoma, LinkedIn: riddy ndoma
 Blog: http://riddyndoma.blogspot.com/
 
 Vous servir est mon désire (Serving you is my desire)
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp

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

[Dhis2-users] [Help-me]

[riddy ndoma]

Hi all,

1) I need to pair with the mobile application DHIS2 Open Data Kit (ODK) ...
What to do??
2) I need to customize DHIS2 using Web API ... Who can help me find a good
resource that talks about??

-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Help-me]

[Morten Olav Hansen]

On Wed, Apr 10, 2013 at 5:18 PM, riddy ndoma riddynd...@gmail.com wrote:

 2) I need to customize DHIS2 using Web API ... Who can help me find a
 good resource that talks about??


Sorry, I can't help you with pt 1, but the documentation for our Web API is
located at:
http://dhis2.org/doc/snapshot/en/user/html/ch25.html

Please write back if you have any issues with it.

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

Re: [Dhis2-users] Help-me

[Jason Pickering]

There has been no translation of the user guide into French yet. The system
itself has been recently translated completely into French, but the
documentation itself has yet to be translated. English and Spanish are
available however.

Best regards,
Jason



On Tue, Apr 2, 2013 at 11:30 AM, riddy ndoma riddynd...@gmail.com wrote:

 Hi all,
 I'm a Congolese from the DRC ... I'm looking the User guide of DHIS2
 in French ...If anyone has, please send me to my e-mail??

 --
 Riddy NDOMA
 Software Developer
 *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
 *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
 *Blog:* http://riddyndoma.blogspot.com/

 Vous servir est mon désire (Serving you is my desire)

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

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

Re: [Dhis2-users] Help-me

[Jan Henrik Øverland]

The Google translated version might be helpful:

http://translate.google.no/translate?sl=entl=frjs=nprev=_thl=noie=UTF-8eotf=1u=http%3A%2F%2Fdhis2.org%2Fdoc%2Fsnapshot%2Fen%2Fuser%2Fhtml%2Fdhis2_user_manual_en.html


On Tue, Apr 2, 2013 at 2:38 PM, Jason Pickering jason.p.picker...@gmail.com
 wrote:

 There has been no translation of the user guide into French yet. The
 system itself has been recently translated completely into French, but the
 documentation itself has yet to be translated. English and Spanish are
 available however.

 Best regards,
 Jason



 On Tue, Apr 2, 2013 at 11:30 AM, riddy ndoma riddynd...@gmail.com wrote:

 Hi all,
 I'm a Congolese from the DRC ... I'm looking the User guide of DHIS2
 in French ...If anyone has, please send me to my e-mail??

 --
 Riddy NDOMA
 Software Developer
 *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
 *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
 *Blog:* http://riddyndoma.blogspot.com/

 Vous servir est mon désire (Serving you is my desire)

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



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


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

[Alvin Marcelo]

Dear all,

I want to display the following charts on the frontpage:

1. how many clinics have accounts in DHIS2

2. how many reports DHIS2 has received from the clinics (reporting rate?)

Can someone teach us how? Thanks...
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help with charts/dashboard

[Saptarshi Purkayastha]

You can probably use the Web-API and connect to an external portal (drupal
etc)
http://data.hiskenya.org/ - is a good example of that. Another one is -
https://dhis2vn.org/

1. you can use the http://apps.dhis2.org/dev/api/users.json and look at the
pager-total
But this is all the users registered in the system. If you have one user
per orgunit, this will work
A more robust way would be to get this XML -
http://apps.dhis2.org/dev/api/metaData.xml?assumeTrue=falseusers=true
and then do a XPath expression for unique organisationUnit code=code

2. This is available out-of-the-box. Under Services-Reports-Reporting
Rate Summary.
I am not sure there is an easy way to get this out to a portal, but may be
someone else knows.

---
Regards,
Saptarshi PURKAYASTHA

My Tech Blog:  http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE


On 20 March 2013 01:47, Alvin Marcelo alvin.marc...@gmail.com wrote:

 Dear all,

 I want to display the following charts on the frontpage:

 1. how many clinics have accounts in DHIS2

 2. how many reports DHIS2 has received from the clinics (reporting rate?)

 Can someone teach us how? Thanks...



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


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

[Dhis2-users] help

[Nyaika David]

hi guys

i have managed to import the dhis2 source code in eclipse.
but i can only see java files within eclipse.i cant see the view(.vm files).

how can i run the project from within eclipse using tomcat as my
application server?

thanks in advance

-- 
Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)
IICS Technologies, Muyenga
Phone:+256706353274
Skype:davie2086
Email: davie2...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] help

[Morten Olav Hansen]

Hi

The general instructions for building the source code is (and you need to
do this before trying to import into Eclipse):
mvn clean install -DskipTests=true in dhis-2 directory
mvn clean install -DskipTests=true in dhis-web directory

These two commands will make sure that all local dependencies are met.




--
Morten


On Mon, Feb 18, 2013 at 11:37 PM, Nyaika David davie2...@gmail.com wrote:

 Hi guys


 i get the error as displayed in the image attached when i run the command
 *mvn eclipse:eclipse   for the  directory *
 */dhis-2/dhis-web.

 *
 *i have tried to search for the files org.hisp.dhis-web-commons:jar:2.10
 and  **org.hisp.dhis:dhis-web-commons-resources:war2.10, but i dont seem
 to find them on the web

 *


 thanks in advance for your help :)



 --
 Regards
 David Nyaika
 Software Developer(SCJP,SCWCD Certified)
 IICS Technologies, Muyenga
 Phone:+256706353274
 Skype:davie2086
 Email: davie2...@gmail.com

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


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

Re: [Dhis2-users] help

[Knut Staring]

Have you run the datamart?
Den 8. feb. 2013 17:18 skrev Nyaika David davie2...@gmail.com følgende:

 Hi guys

 i have data captured for my the following datasets as shown
 in the image attached but am getting the error below

  please ensure that there is data stored in the database and that
 data mart has been run properly 

 please look at the image attached to get the whole scenario

 Regards
 David Nyaika
 Software Developer(SCJP,SCWCD Certified)
 IICS Technologies, Muyenga
 Phone:+256706353274
 Skype:davie2086
 Email: davie2...@gmail.com

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


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

Re: [Dhis2-users] help

[Knut Staring]

Have you run the datamart?
Den 8. feb. 2013 17:18 skrev Nyaika David davie2...@gmail.com følgende:

Hi guys

i have data captured for my the following datasets as shown
in the image attached but am getting the error below

 please ensure that there is data stored in the database and that
data mart has been run properly 

please look at the image attached to get the whole scenario

Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)
IICS Technologies, Muyenga
Phone:+256706353274
Skype:davie2086
Email: davie2...@gmail.com

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

Re: [Dhis2-users] help

[Nyaika David]

no i have not yet


On Fri, Feb 8, 2013 at 7:56 PM, Knut Staring knu...@gmail.com wrote:

 Have you run the datamart?
 Den 8. feb. 2013 17:18 skrev Nyaika David davie2...@gmail.com
 følgende:

 Hi guys

 i have data captured for my the following datasets as shown
 in the image attached but am getting the error below

  please ensure that there is data stored in the database and that
 data mart has been run properly 

 please look at the image attached to get the whole scenario

 Regards
 David Nyaika
 Software Developer(SCJP,SCWCD Certified)
 IICS Technologies, Muyenga
 Phone:+256706353274
 Skype:davie2086
 Email: davie2...@gmail.com

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




-- 
Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)
IICS Technologies, Muyenga
Phone:+256706353274
Skype:davie2086
Email: davie2...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help

[Ola Hodne Titlestad]

Hi David,
For custom sql based reports have a look at section 13.4.3 in the user doc:

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

You can only run DHIS 2 with one unerlying database, the one you specify in
hibernate.properties. But you can then create custom sql against any entity
in this db, add a nice layout on top of that with iReport and make it
available to the users as a standard report with runtime parameters in the
DHIS 2 UI. Instructions in the link above.

Ola
---
On Feb 7, 2013 8:28 AM, Nyaika David davie2...@gmail.com wrote:

 Hi Guys

 In the dhis-live/conf/hibernate.properties directory, i see there are
 settings for connecting to postgres database.  can i be able to access the
 postgres database entities within  DHIS2 for use in report generation


 Thanks in advance for your help :)

 --
 Regards
 David Nyaika
 Software Developer(SCJP,SCWCD Certified)
 IICS Technologies, Muyenga
 Phone:+256706353274
 Skype:davie2086
 Email: davie2...@gmail.com

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


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

[Dhis2-users] Help

[Nyaika David]

Hi Guys

In the dhis-live/conf/hibernate.properties directory, i see there are
settings for connecting to postgres database.  can i be able to access the
postgres database entities within  DHIS2 for use in report generation


Thanks in advance for your help :)

-- 
Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)
IICS Technologies, Muyenga
Phone:+256706353274
Skype:davie2086
Email: davie2...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Help

[Nyaika David]

Hi guys

am new to DHIS2, i would like to know if DHIS2 can be used hand in h
and with postgres database to generate reports.i would also like to know
if  i can acces the reports from my JEE application

thanks for your help in advance :)
-- 
Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)
IICS Technologies, Muyenga
Phone:+256706353274
Skype:davie2086
Email: davie2...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help

[Lars Helge Øverland]

Hi David,

DHIS isn't really a pluggable software development library, rather a data
management, capture and analysis system. So you would have to give DHIS
access to your data repository in some way.

It is written entirely in Java, builds with Maven, and has a Web API, so it
should be possible to integrate in many ways. It depends on what level you
want to integrate. At the source code level, If you are using Maven as
build system, you could include the Maven projects into your system or vice
verca. If you want to interface with the Web API, you could utilize some
HTTP client library like Spring / REST template or Apache HttpComponents to
exchange data. It all depends on the requirements and the nature of your
project.

regards, Lars


On Tue, Feb 5, 2013 at 2:31 PM, Nyaika David davie2...@gmail.com wrote:

 Hi guys

 am new to DHIS2, i would like to know if DHIS2 can be used hand in h
 and with postgres database to generate reports.i would also like to know
 if  i can acces the reports from my JEE application

 thanks for your help in advance :)
 --
 Regards
 David Nyaika
 Software Developer(SCJP,SCWCD Certified)
 IICS Technologies, Muyenga
 Phone:+256706353274
 Skype:davie2086
 Email: davie2...@gmail.com

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


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

Re: [Dhis2-users] Help creating links to download materialized views

[Lars Helge Øverland]

Hi Randy,

let me see if I get you correctly: The problem is mainly that you cannot
drop your sql views in an arbitrary order since they depend on each
other? Also, your views do not depend on any dhis resource table, and you
completely maintain your views through the cron job.

Assuming this, would it solve the problem if we introduced a property on
dhis-managed sql views which would allow you to specify whether it should
be dropped and recreated by dhis (i.e. when rebuilding the resource tables)
or not?

For your sql views you could then set this to not to be dropped/created and
you could control those sql views like you prefer.

The advantage here is that we already have the functionality for producing
dhis-managed sql views as json/xml/csv through the web api.

regards,

Lars






On Thu, Dec 20, 2012 at 12:58 PM, Wilson,Randy rwil...@msh.org wrote:

  In Rwanda we have found report tables and MyDatamart inadequate for the
 needs of many of the central level health programs.  What they want is a
 dump of all the datavalues in *specific* *dataelement and indicator groups
 * along with the related orgunit hierarchy.  We originally were doing
 this using SQL views, under Data Administration, however some of the views
 are built on one another so when the Datamart and Resource table procedures
 run they is unable to drop the views before re-creating them…. And
 consequently neither process runs.

 ** **

 Jason Pickering has helped us develop an elegant function that gets around
 the view issue, and creates materialized views for all dataelement groups:
 special tables that are refreshed every night through a chron job (just
 like the datamart).  This gives us exactly what the users want – they
 generally link to the tables with ODBC connection using an excel pivot
 table – and because they are only retrieving the dataelement groups they
 want the file is not too big.  Unfortunately, this only works on the local
 area network – refreshing the pivot tables over the network is likely to be
 too slow, and our security settings don’t enable a remote ODBC connection.
 

 ** **

 We are now beginning to explore the DHIS-2 API to create a portal for
 users to access DHIS-2 objects.  I see that SQL views are exposed through
 this API, but for the reasons stated above we can’t rely on them.  Here is
 where we need help:

 **1.   **Is there a way to expose other tables in the API? 

 **2.   **Does anyone have some sample HTML code that we could use to
 list these special tables (they all start with _*view*_) in the portal
 and download them as xls, csv or xml?  Similar to what is shown in the
 DHIS-2 portal demo for downloading tables.

 **3.   **Could we include the links to these tables as resources in
 users’ dashboards?

 ** **

 *Randy Wilson*

 Senior HMIS and Data Use Advisor

 Rwanda/IHSSP

 Management Sciences for Health

 BOX 371
 Kigali, Rwanda
 +250788308835 (mobile)
 Skype name (wilsonrandy_us)

 www.msh.orghttp://www.msh.org/?utm_source=2012-10-15+MSH+internal+announce+email+signatureutm_campaign=iemailsigutm_medium=email
  

 *Stronger health systems. Greater health impact.*

 ** **

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


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

Re: [Dhis2-users] Help creating links to download materialized views

[Jason Pickering]

Yes, in this context, a materialized view is simply a table which is
produced from an SQL view. The advantage of course is that materialized
views can be indexed, etc and are normally much faster to serve than
dynamic SQL views.

The one thing I did not mention, is the refreshment of the materialized
views. As Randy pointed out, we have scheduled the refresh of the views as
a cron job. Ideally, this would be something which DHIS2 would do. If we
were to represent the 20 or so views as normal DHIS2 SQL views, there is no
native way to refresh them, and this needs to occur each night after the
data mart runs. So, ideally, scheduling of the regeneration of the SQL
views (and resource tables) should be an option as well. There is a work
around using CURL to force the regeneration, but again ,this is a bit of a
kludge as well. Hope this can get included at some point in time.


I think the real fix in this case would be.

1) Implement scheduling of SQL views.
2) If users want to use custom Postgresql functions, they could do this,
and they could be triggered by DHIS with SELECT
my_custom_stored_procedure(); with the scheduler. This would eliminate the
need for a cron job from the system.
3) Allow for users to choose certain tables which should be available as
resources, for instance, _orgunitstructure  (Bob's point) or
_my_custom_table, which might be some external table or materialized
view. DHIS would not do anything other than to produce JSON, HTML, Excel or
whatever from this table. Not really sure why this is not RESTFUL? Isn't
this the same thing as what is being done with the SQL views themselves?



 Regards,
Jason





On Thu, Dec 20, 2012 at 10:51 PM, Lars Helge Øverland
larshe...@gmail.comwrote:

 Okay. So with materialized view you are referring to a plain db table,
 right? I thought you meant creating a view with sql something like create
 materialized view but I can see that has not been implemented directly in
 postgres yet.

 Anyway I think creating a dhis sql view per table is a reasonable
 work-around. It requires you only to create 20 objects, one time.

 One alternative would be to create some sort of dhis sql report. But it
 would be very similar in nature and require some development for 2.11.
  Another alternative would be just to expose database tables through the
 web api but that does not sound very nice or restful to me.

 So if you are willing to create a sql view per table you can achieve 1.

 Re 2 you can simply point directly to the sql views through the web api,
 for instance to the demo like this, for xml:

 http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.xmlhttp://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data

 for csv:

 http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.csv

 I have committed and backported to 2.10 representations for Excel and
 HTML, you can reach them after upgrading by using the extensions .xls and
 .html .

 For web pages you can use plain links like this:

 a 
 href=http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.xmlhttp://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/dataDownload
 as XML/a |
 a href=http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.csv;CSV/a
 | etc

 For 3, yes you can easily include these as resources. Just add a new one,
 give it a name, select external URL as type and point to the sql view
 URLs above.


 For authentication you might get some tips from here:

 http://dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e600


 You can download 2.10 latest from here in half an hour:


 http://apps.dhis2.org/ci/job/dhis-web-2.10/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war





 On Thu, Dec 20, 2012 at 5:28 PM, Jason Pickering 
 jason.p.picker...@gmail.com wrote:

 Hi Randy and Lars,
 The fundemental problem is that view which they were using are linked to
 the resource tables. These tables need to be regenerated, and when they are
 regenerated, the tables are dropped and recreated. If views are linked to
 these tables, the resource table regeneration cannot take place, because
 the database forbids the table to be dropped, because there are linked
 views. DHIS2 fails silently and only says Resource tables generating...
 or something like that. I think we have described this problem on the list
 before and I am sure you are aware of it.

 So, to get around this problem, we use stored procedures
 to materialize the views, and then as Randy indicates, users can get to
 them through ODBC.

 I guess it could be done Randy by creating an SQL View of the
 materialized view. This does not really make a whole lot of sense, but it
 could be done. So, if you create an SQL view in DHIS2 of SELECT * FROM
 _materalized view; you will get a new materialized view available, as Lars
 points out, through the API. A bit wasteful really but certainly possible.

 The elegant part which Randy mentions is that we do not define many
 seperate views, but dynamically define the tables 

Re: [Dhis2-users] Help creating links to download materialized views

[Lars Helge Øverland]

On Fri, Dec 21, 2012 at 5:47 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Yes, in this context, a materialized view is simply a table which is
 produced from an SQL view. The advantage of course is that materialized
 views can be indexed, etc and are normally much faster to serve than
 dynamic SQL views.

 The one thing I did not mention, is the refreshment of the materialized
 views. As Randy pointed out, we have scheduled the refresh of the views as
 a cron job. Ideally, this would be something which DHIS2 would do. If we
 were to represent the 20 or so views as normal DHIS2 SQL views, there is no
 native way to refresh them, and this needs to occur each night after the
 data mart runs. So, ideally, scheduling of the regeneration of the SQL
 views (and resource tables) should be an option as well. There is a work
 around using CURL to force the regeneration, but again ,this is a bit of a
 kludge as well. Hope this can get included at some point in time.


 I think the real fix in this case would be.

 1) Implement scheduling of SQL views.
 2) If users want to use custom Postgresql functions, they could do this,
 and they could be triggered by DHIS with SELECT
 my_custom_stored_procedure(); with the scheduler. This would eliminate the
 need for a cron job from the system.
 3) Allow for users to choose certain tables which should be available as
 resources, for instance, _orgunitstructure  (Bob's point) or
 _my_custom_table, which might be some external table or materialized
 view. DHIS would not do anything other than to produce JSON, HTML, Excel or
 whatever from this table. Not really sure why this is not RESTFUL? Isn't
 this the same thing as what is being done with the SQL views themselves?




Okay. In my opinion the real fix would be to support data element and
indicator group selection in mydatamart. Then one wouldn't have to do any
of this. Anyway, scheduling of sql views and resource tables is already on
the plan and will be done for 2.11. We can also extend the sql view
functionality to support custom select statements like you suggest.
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help creating links to download materialized views

[Wilson,Randy]

Thanks to all of you..

I now have some great short term fixes and look forward to thinking more about 
the best approach over the longer term.  I like the idea of using this function 
to create true views dynamically as well as the tables Jason has created.   
From the user perspective, the nice thing is that they can use the DHIS web 
interface to create useful dataelement and indicator groups - and then the 
function creates the views for them automatically - no need to write SQL 
queries.  We might want to add a check box in the dataelement/indicator group 
definition screens that users can check if they want the a materialized view 
created for the group.  The default would be no.  Then we can change the syntax 
in the function to select only those groups that are checked before looping 
through and creating the tables/views.

As Jason notes the main issue that brought us to build these tables was that 
the SQL syntax in the function uses the resource tables - to create a more 
detailed orgunit view (all reporting entities with the names of the entire 
hierarchy above them (sector, sub-district, district, province).  Many of the 
reports require these groupings of data and the pivot table drill-down/float-up 
capabilities are very helpful.  I'm not sure how we can get around the need to 
drop and rebuild these tables.

Randy


From: Lars Helge Øverland [mailto:larshe...@gmail.com]
Sent: Thursday, December 20, 2012 10:51 PM
To: Jason Pickering
Cc: Wilson,Randy; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help creating links to download materialized views

Okay. So with materialized view you are referring to a plain db table, right? I 
thought you meant creating a view with sql something like create materialized 
view but I can see that has not been implemented directly in postgres yet.

Anyway I think creating a dhis sql view per table is a reasonable work-around. 
It requires you only to create 20 objects, one time.

One alternative would be to create some sort of dhis sql report. But it would 
be very similar in nature and require some development for 2.11.  Another 
alternative would be just to expose database tables through the web api but 
that does not sound very nice or restful to me.

So if you are willing to create a sql view per table you can achieve 1.

Re 2 you can simply point directly to the sql views through the web api, for 
instance to the demo like this, for xml:

http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.xmlhttp://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data

for csv:

http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.csv

I have committed and backported to 2.10 representations for Excel and HTML, you 
can reach them after upgrading by using the extensions .xls and .html .

For web pages you can use plain links like this:

a 
href=http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.xmlhttp://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/dataDownload
 as XML/a |
a href=http://apps.dhis2.org/demo/api/sqlViews/dI68mLkP1wN/data.csv;CSV/a 
| etc

For 3, yes you can easily include these as resources. Just add a new one, give 
it a name, select external URL as type and point to the sql view URLs above.


For authentication you might get some tips from here:

http://dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e600


You can download 2.10 latest from here in half an hour:

http://apps.dhis2.org/ci/job/dhis-web-2.10/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war





On Thu, Dec 20, 2012 at 5:28 PM, Jason Pickering 
jason.p.picker...@gmail.commailto:jason.p.picker...@gmail.com wrote:
Hi Randy and Lars,
The fundemental problem is that view which they were using are linked to the 
resource tables. These tables need to be regenerated, and when they are 
regenerated, the tables are dropped and recreated. If views are linked to these 
tables, the resource table regeneration cannot take place, because the database 
forbids the table to be dropped, because there are linked views. DHIS2 fails 
silently and only says Resource tables generating... or something like that. 
I think we have described this problem on the list before and I am sure you are 
aware of it.

So, to get around this problem, we use stored procedures to materialize the 
views, and then as Randy indicates, users can get to them through ODBC.

I guess it could be done Randy by creating an SQL View of the materialized 
view. This does not really make a whole lot of sense, but it could be done. So, 
if you create an SQL view in DHIS2 of SELECT * FROM _materalized view; you 
will get a new materialized view available, as Lars points out, through the 
API. A bit wasteful really but certainly possible.

The elegant part which Randy mentions is that we do not define many seperate 
views, but dynamically define the tables based on data element groups. The 
views are very similar, they just differ in the data elements which should be 
presented

Re: [Dhis2-users] Help

[Jason Pickering]

Hi Robert,
Bob and I discussed this offline in detail (I was experiencing similar
problems). A partial fix has been committed to trunk and we will test a
better solution soon. In the meantime, your workaround should work fine.

Regards,
Jason

--
Sent from my mobile
On Feb 8, 2012 12:33 PM, Robert G. Mesleh Jr. meslehrobe...@gmail.com
wrote:

 Hi Jason and Knut

 ** **

 I figured out the problem with the exported file not being imported into
 other system is with the change of minorVersion to 1.3

 After I edited the dxf file using Notepad to change the minorVersion back
 to 1.2 as shown below, it is now importing.

 ** **

 ?xml version=1.0?

 dxf exported=*2012-02-07* minorVersion=*1.2* xmlns=*
 http://dhis2.org/schema/dxf/1.0*;

 ** **

 Thanks,

 Robert

 ** **

 *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com]
 *Sent:* Wednesday, January 25, 2012 2:53 PM
 *To:* Robert G. Mesleh Jr.
 *Cc:* dhis2-users@lists.launchpad.net
 *Subject:* Re: [Dhis2-users] Help

 ** **

 Hi Andrew,

 I am not sure which version you are using now (2.5 or 2.6?) but you may
 want to try this directly on the database

 ** **

 ** **

 ALTER TABLE chart ADD COLUMN targetline  boolean NOT NULL DEFAULT false:**
 **

 ALTER TABLE chart ADD COLUMN hidesubtitle  boolean NOT NULL DEFAULT false;
 

 ** **

 Which is described here

 ** **

 https://bugs.launchpad.net/dhis2/+bug/914980  

 ** **

 Regards,

 Jason

 ** **

 ** **

 On Wed, Jan 25, 2012 at 4:08 PM, Robert G. Mesleh Jr. 
 meslehrobe...@gmail.com wrote:

 Hi to all,

 I have a problem where file I export cannot be imported to other systems
 (even back to my own system). Jason and Knut advised me to restore the 2.5
 war file (because I was exporting from the 2.6 version). Now I get a
 message which I have attached along with the log file. Is there any advice
 for me? I can’t use the database.



 __ Information from ESET NOD32 Antivirus, version of virus
 signature database 6825 (20120125) __

 The message was checked by ESET NOD32 Antivirus.

 http://www.eset.com


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

 ** **

 ** **

 __ Information from ESET NOD32 Antivirus, version of virus
 signature database 6825 (20120125) __

 ** **

 The message was checked by ESET NOD32 Antivirus.

 ** **

 http://www.eset.com


 __ Information from ESET NOD32 Antivirus, version of virus
 signature database 6833 (20120127) __

 The message was checked by ESET NOD32 Antivirus.

 http://www.eset.com

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

Re: [Dhis2-users] Help

[Robert G. Mesleh Jr.]

Hi Jason,

I was, at first, using the 2.6. I am getting the error after I downgraded to
2.5.

 

Thanks,

Robert

 

From: Jason Pickering [mailto:jason.p.picker...@gmail.com] 
Sent: Wednesday, January 25, 2012 2:53 PM
To: Robert G. Mesleh Jr.
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Help

 

Hi Andrew,

I am not sure which version you are using now (2.5 or 2.6?) but you may want
to try this directly on the database

 

 

ALTER TABLE chart ADD COLUMN targetline  boolean NOT NULL DEFAULT false:

ALTER TABLE chart ADD COLUMN hidesubtitle  boolean NOT NULL DEFAULT false;

 

Which is described here

 

https://bugs.launchpad.net/dhis2/+bug/914980  

 

Regards,

Jason

 

 

On Wed, Jan 25, 2012 at 4:08 PM, Robert G. Mesleh Jr.
meslehrobe...@gmail.com wrote:

Hi to all,

I have a problem where file I export cannot be imported to other systems
(even back to my own system). Jason and Knut advised me to restore the 2.5
war file (because I was exporting from the 2.6 version). Now I get a message
which I have attached along with the log file. Is there any advice for me? I
can't use the database.



__ Information from ESET NOD32 Antivirus, version of virus signature
database 6825 (20120125) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


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

 

 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 6825 (20120125) __

 

The message was checked by ESET NOD32 Antivirus.

 

http://www.eset.com

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

[Dhis2-users] Help Please! Migration from MySQL to PostgreSQL

[Felix Kayode]

Hi,

I am presently working on a new HMIS project in Ethiopia and require some 
advice. We recently (2 months ago)installed a DHIS online system using MySQL 
and wish to migrate to PostgreSQL, 
without losing information on the table structure or data which have just been 
entered. How can this be done? ___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL

[Felix Kayode]

Thank you Jason, will I be able to migrate the org units including all 
facilities from the MySQL version? This is the section we are concerned with 
and are afraid we may lose a lot of the information created for the facilities. 
We may not be too concerned about the data elements and forms. The data has 
been collected for only two months and can easily be re-entered. 

 Date: Thu, 19 Jan 2012 17:44:38 +0200
 Subject: Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL
 From: jason.p.picker...@gmail.com
 To: felixkay...@hotmail.com
 CC: dhis2-users@lists.launchpad.net
 
 Hi Felix,
 You should be able to migrate most data with the export format (DXF)
 and import this into  a seperate instance which uses Postgres. Most
 (but not all) of the metadata will be migrated. Some things (users,
 custom data entry forms) and some other metadata elements will either
 need to be recreated manually. There are possibly some tools which can
 convert MySQL to Postgresql format  (many here
 http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL)
 . In general, I would try first with DXF, see what is missing, and
 then think about manually recreating things. Other ETL tools like
 Pentaho may make things a bit easier, but one must be exceedingly
 careful about direct injection into the DHIS2 database.
 
 Others may have some more specific reccomendations and experience.
 
 Best regards,
 Jason
 
 
 
 On Thu, Jan 19, 2012 at 4:20 PM, Felix Kayode felixkay...@hotmail.com wrote:
  Hi,
 
  I am presently working on a new HMIS project in Ethiopia and require some
  advice. We recently (2 months ago)installed a DHIS online system using MySQL
  and wish to migrate to PostgreSQL,
  without losing information on the table structure or data which have just
  been entered. How can this be done?
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 
  ___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL

[Felix Kayode]

Thanks Jason. I will try this out and provide a feedback to the list

 Date: Thu, 19 Jan 2012 18:47:50 +0200
 Subject: Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL
 From: jason.p.picker...@gmail.com
 To: felixkay...@hotmail.com
 CC: dhis2-users@lists.launchpad.net
 
 You should have no trouble with migrating all of the organisation
 units and data, including all data elements and indicators  data sets,
 etc.
 
 Migration of the custom data entry forms can be done, but it is quite
 a lot of trouble. It is probably easier to recreate this, at least in
 my opinion.
 
 The export/Import process is described here
 
 http://dhis2.org/doc/snapshot/en/user/html/ch18.html
 
 Just export everything from your database and save the DXF file. If
 you are going to use the same machine, then change your
 hibernate.properties file to point to the new Postgresql database, and
 start DHIS. You should have an empty DHIS database at this point.
 Next, import the file which you exported in the previous step, and you
 should be good to go.
 
 If you encounter any errors, let the list know.
 
 Regards,
 Jason
 
 
 On Thu, Jan 19, 2012 at 6:03 PM, Felix Kayode felixkay...@hotmail.com wrote:
  Thank you Jason, will I be able to migrate the org units including all
  facilities from the MySQL version? This is the section we are concerned with
  and are afraid we may lose a lot of the information created for the
  facilities. We may not be too concerned about the data elements and forms.
  The data has been collected for only two months and can easily be
  re-entered.
 
  Date: Thu, 19 Jan 2012 17:44:38 +0200
  Subject: Re: [Dhis2-users] Help Please! Migration from MySQL to PostgreSQL
  From: jason.p.picker...@gmail.com
  To: felixkay...@hotmail.com
  CC: dhis2-users@lists.launchpad.net
 
 
  Hi Felix,
  You should be able to migrate most data with the export format (DXF)
  and import this into a seperate instance which uses Postgres. Most
  (but not all) of the metadata will be migrated. Some things (users,
  custom data entry forms) and some other metadata elements will either
  need to be recreated manually. There are possibly some tools which can
  convert MySQL to Postgresql format (many here
 
  http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL)
  . In general, I would try first with DXF, see what is missing, and
  then think about manually recreating things. Other ETL tools like
  Pentaho may make things a bit easier, but one must be exceedingly
  careful about direct injection into the DHIS2 database.
 
  Others may have some more specific reccomendations and experience.
 
  Best regards,
  Jason
 
 
 
  On Thu, Jan 19, 2012 at 4:20 PM, Felix Kayode felixkay...@hotmail.com
  wrote:
   Hi,
  
   I am presently working on a new HMIS project in Ethiopia and require
   some
   advice. We recently (2 months ago)installed a DHIS online system using
   MySQL
   and wish to migrate to PostgreSQL,
   without losing information on the table structure or data which have
   just
   been entered. How can this be done?
  
   ___
   Mailing list: https://launchpad.net/~dhis2-users
   Post to : dhis2-users@lists.launchpad.net
   Unsubscribe : https://launchpad.net/~dhis2-users
   More help   : https://help.launchpad.net/ListHelp
  
  ___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

[Beatrice Ngatia]

Hi All,

I am trying to use the DHIS2 Pivot Tables and encountering some challenges.

The challenge lies with the End-Product i.e. the Excel sheet produced once
I follow the * select Data  Pivot  Download to Excel* process.  While
I successfully select my pivoting parameters and the table produced on DHIS
seems excellent, My problem is that the resultant Pivot table (once I click
download to Excel exports each month to its own separate worksheet and
not onto one combined worksheet where I can then proceed to pivot the data
as desired.

Is this the current set-up within DHIS2 or am I missing a step?

It seems to make sense to me to have all the data exported into one
worksheet, and then pivoted by users as need be.

Please Advise.

Thanks,

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

Re: [Dhis2-users] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

[Jason Pickering]

Hi Beatrice,

Nice to hear from you again. :)

The better solution would be to use the MyDatamart tool described here

http://dhis2.org/doc/snapshot/en/user/html/apb.html


This tool will provide you with a normal pivot table, which can be
manipulated as per normal by users.


Best regards,
Jason


On Sun, Jan 15, 2012 at 2:27 PM, Beatrice Ngatia bnga...@gmail.com wrote:
 Hi All,

 I am trying to use the DHIS2 Pivot Tables and encountering some challenges.

 The challenge lies with the End-Product i.e. the Excel sheet produced once I
 follow the  select Data  Pivot  Download to Excel process.  While
 I successfully select my pivoting parameters and the table produced on DHIS
 seems excellent, My problem is that the resultant Pivot table (once I click
 download to Excel exports each month to its own separate worksheet and not
 onto one combined worksheet where I can then proceed to pivot the data as
 desired.

 Is this the current set-up within DHIS2 or am I missing a step?

 It seems to make sense to me to have all the data exported into one
 worksheet, and then pivoted by users as need be.

 Please Advise.

 Thanks,

 Beatrice




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


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

Re: [Dhis2-users] Help - Pivot Tables Export to Excel - Challenge - Each month exported to separate worksheet

[Ola Hodne Titlestad]

Hi Beatrice,
I think you might have selected too much data for download. If you are
downloading data for the Kenya orgunit you should not select facility as
the analysis level, it will be way too much to download. Try to use
district or county level instead. Or if you need facility level, first
select e.g. a district as your orgunit to narrow down the amount of data.
Also try just a few months as Jason suggests. If it doesn't work out there
is a great team of pivot and mydatamart experts at the HMIS division if you
are still in Nairobi.
Ola
On Jan 15, 2012 2:36 PM, Jason Pickering jason.p.picker...@gmail.com
wrote:

 Hi Beatrice,

 Nice to hear from you again. :)

 The better solution would be to use the MyDatamart tool described here

 http://dhis2.org/doc/snapshot/en/user/html/apb.html


 This tool will provide you with a normal pivot table, which can be
 manipulated as per normal by users.


 Best regards,
 Jason


 On Sun, Jan 15, 2012 at 2:27 PM, Beatrice Ngatia bnga...@gmail.com
 wrote:
  Hi All,
 
  I am trying to use the DHIS2 Pivot Tables and encountering some
 challenges.
 
  The challenge lies with the End-Product i.e. the Excel sheet produced
 once I
  follow the  select Data  Pivot  Download to Excel process.  While
  I successfully select my pivoting parameters and the table produced on
 DHIS
  seems excellent, My problem is that the resultant Pivot table (once I
 click
  download to Excel exports each month to its own separate worksheet and
 not
  onto one combined worksheet where I can then proceed to pivot the data as
  desired.
 
  Is this the current set-up within DHIS2 or am I missing a step?
 
  It seems to make sense to me to have all the data exported into one
  worksheet, and then pivoted by users as need be.
 
  Please Advise.
 
  Thanks,
 
  Beatrice
 
 
 
 
  ___
  Mailing list: https://launchpad.net/~dhis2-users
  Post to : dhis2-users@lists.launchpad.net
  Unsubscribe : https://launchpad.net/~dhis2-users
  More help   : https://help.launchpad.net/ListHelp
 

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

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

Re: [Dhis2-users] help with DHIS2 (uploading table?)

[Jason Pickering]

Hi Zayd,

There is no automatic way to upload an Excel table containing codes into
DHIS2. The simplest way would  (I think in your case) be to transform the
Excel sheet to a series of update statements, and then execute this
directly in the DHIS2 database. You can probably use the code field of
the organisationunit table for this purpose.

I do not think it is possible for the user to type a code and begin to
enter data. The would need to select the organisation unit from the orgunit
tree on the left side of the data entry screen and then either the data.

I am not really sure about your second question. I suppose this is some
data for a particular organisational unit and period? If so, again, there
is no way to upload an Excel file with this type of data. You would need to
transform the data either to DXF (the XML format used by DHIS2) or inject
the data directly into the database.

Best regards,
Jason


On Wed, Jan 11, 2012 at 5:20 AM, Zayd Edrylson Tolentino 
ztolent...@ncp.org.ph wrote:

 Hello!

 I would like to verify if it is possible for us to upload an entire table
 (in excel) to the database as a reference table. The table I will be
 uploading would contain the codes for each areas. This will be used as
 reference table so that in the system, when the user types the code, the
 area will be shown and vice versa.

 Or on a simpler note, I'd like to upload a table to be used as reference
 data for the whole system's data entry.

 Is this possible?

 Helpful response would be highly appreciated.
 Thank you very much!

 --
 Zayd Edrylson S. Tolentino
 Systems Administrator
 Information Systems Department
 Nutrition Center of the Philippines / Philippine Nutri-Foods Corp. / NCP
 Publishing Corp.
 2332 Chino Roces Avenue Extension
 Fort Bonifacio, Taguig City 1630
 Tel No: 818-7397

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


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

[Dhis2-users] help on datamart, built 5362

[Aymar Narodar SOME]

Hi,

I get an error when I try to export datamart. I use dhis2 built 5362. Log
is in attached.
thx,

Aymar
* INFO  12:11:01,574 Populated crosstab table: 0:15:38.576 (Clock.java 
[Thread-17])
* INFO  12:11:01,589 Created aggregated data cache: 0:15:38.591 (Clock.java 
[Thread-17])
* WARN  12:11:01,589 [c3p0] A PooledConnection that has already signalled a 
Connection error is still in use! (NewPooledConnection.java [Thread-17])
* WARN  12:11:01,746 [c3p0] Another error has occurred [ 
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, 
commands ignored until end of transaction block ] which will not be reported to 
listeners! (NewPooledConnection.java [Thread-17])
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, 
commands ignored until end of transaction block
at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at 
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at 
org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420)
at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
at 
org.hisp.dhis.aggregation.jdbc.JdbcAggregatedDataValueStore.dropIndex(JdbcAggregatedDataValueStore.java:426)
at 
org.hisp.dhis.aggregation.DefaultAggregatedDataValueService.dropIndex(DefaultAggregatedDataValueService.java:152)
at 
org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:261)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy50.export(Unknown Source)
at 
org.hisp.dhis.datamart.impl.DefaultDataMartService.export(DefaultDataMartService.java:95)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at 
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
at 
org.amplecode.quick.StatementInterceptor.intercept(StatementInterceptor.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at 
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
at 
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
at 

Re: [Dhis2-users] Help Required

[Knut Staring]

Jason is talking about Linux users, not database user's

Regards, Knut (via mobile phone)
On Oct 28, 2011 9:49 AM, Jason Pickering jason.p.picker...@gmail.com
wrote:

 Hi Stephen,
 Just one more important point, and that is to be sure NOT to run Tomcat as
 root'.  If you are using a manual install of Tomcat, as opposed to
 installing it through the package manager of Linux, it is best practice to
 create a seperate user for tomcat, and run the process as a non-privileged
 user. There are numerous examples on the net to show you how to achieve
 this. We should probably highlight this in the implementation guide a bit
 better, but it it documented there from the standpoint of using the package
 manager to install Tomcat, as opposed to a manual install.

 Regards,
 Jason


 On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen stepho...@gmail.comwrote:

 Hullo,

 This is a subsection of the log file catalina.out

 It seems the hibernate.properties could not be read

 Deploying web application archive dhis.war
 * INFO  21:50:29,457 System property dhis2.home not set
 (DefaultLocationManager.java [Thread-2])
 * INFO  21:50:29,459 Environment variable DHIS2_HOME points to
 /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])
 * INFO  21:50:30,999 Could not read external configuration from file
 system (DefaultHibernateConfigurationProvider.java [Thread-2])
 * INFO  21:50:48,557 Sceduled task of type:
 org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])
 * INFO  21:50:50,196 Executing startup routine [1 of 11, runlevel 1]:
 TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
 * INFO  21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

 I have SOLVED the Problem.

 Thanks TO ALL


 On Thu, Oct 27, 2011 at 9:13 PM, stepho...@gmail.com wrote:

 ** Thank you all. Let me checkout on the configuration and have alook at
 the log file.

 As regards the root, so far the computer has that account and it is the
 one that is used to start dhis. May be to confirm, is this the dhis database
 user or the computer user? I hope it is the computer user.

 Will let you. Thanks again

 Sent from my BlackBerry® smartphone provided by Airtel Uganda.
 --
 *From: * Jason Pickering jason.p.picker...@gmail.com
 *Date: *Fri, 28 Oct 2011 05:57:08 +0200
 *To: *Ola Hodne Titlestadol...@ifi.uio.no
 *Cc: *dhis2-users@lists.launchpad.net; Ocaya Stephen
 stepho...@gmail.com
 *Subject: *Re: [Dhis2-users] Help Required

 Have you properly configured postgres to enable tcp/ip connections from
 localhost?

 You should not run tomcat with root. If you are using another user to
 start tomcat, this user may not be able to read anything from /home/root.

 As knut and ola say however, the log will provide you with the answer.

 Regards,
 Jason
 On Oct 28, 2011 12:00 AM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:


  /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
 dhis found your hibernate.properties file or not, and tell you if the
 DHIS2_HOME was recognised or not.

 Ola
 --

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

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


 On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to
 be picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for
 testing purposes but might happen because your database configuration was
 not picked up. Please make sure this is intentional. Your data will be
 destroyed when the application shuts down.

 My Hibernate File is in
 /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 *You can do anything, but not everything.*



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



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




 --

 *You can do anything, but not everything

Re: [Dhis2-users] Help Required

[Orvalho Augusto]

And another recommendation is protect tomcat with Apache (configure it to
work like reverse proxy). Somewhere on the tomcat docs they do recommend
that too.

Caveman




On Fri, Oct 28, 2011 at 9:49 AM, Jason Pickering 
jason.p.picker...@gmail.com wrote:

 Hi Stephen,
 Just one more important point, and that is to be sure NOT to run Tomcat as
 root'.  If you are using a manual install of Tomcat, as opposed to
 installing it through the package manager of Linux, it is best practice to
 create a seperate user for tomcat, and run the process as a non-privileged
 user. There are numerous examples on the net to show you how to achieve
 this. We should probably highlight this in the implementation guide a bit
 better, but it it documented there from the standpoint of using the package
 manager to install Tomcat, as opposed to a manual install.

 Regards,
 Jason



 On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen stepho...@gmail.comwrote:

 Hullo,

 This is a subsection of the log file catalina.out

 It seems the hibernate.properties could not be read

 Deploying web application archive dhis.war
 * INFO  21:50:29,457 System property dhis2.home not set
 (DefaultLocationManager.java [Thread-2])
 * INFO  21:50:29,459 Environment variable DHIS2_HOME points to
 /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])
 * INFO  21:50:30,999 Could not read external configuration from file
 system (DefaultHibernateConfigurationProvider.java [Thread-2])
 * INFO  21:50:48,557 Sceduled task of type:
 org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])
 * INFO  21:50:50,196 Executing startup routine [1 of 11, runlevel 1]:
 TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
 * INFO  21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

 I have SOLVED the Problem.

 Thanks TO ALL


 On Thu, Oct 27, 2011 at 9:13 PM, stepho...@gmail.com wrote:

 ** Thank you all. Let me checkout on the configuration and have alook at
 the log file.

 As regards the root, so far the computer has that account and it is the
 one that is used to start dhis. May be to confirm, is this the dhis database
 user or the computer user? I hope it is the computer user.

 Will let you. Thanks again

 Sent from my BlackBerry® smartphone provided by Airtel Uganda.
 --
 *From: * Jason Pickering jason.p.picker...@gmail.com
 *Date: *Fri, 28 Oct 2011 05:57:08 +0200
 *To: *Ola Hodne Titlestadol...@ifi.uio.no
 *Cc: *dhis2-users@lists.launchpad.net; Ocaya Stephen
 stepho...@gmail.com
 *Subject: *Re: [Dhis2-users] Help Required

 Have you properly configured postgres to enable tcp/ip connections from
 localhost?

 You should not run tomcat with root. If you are using another user to
 start tomcat, this user may not be able to read anything from /home/root.

 As knut and ola say however, the log will provide you with the answer.

 Regards,
 Jason
 On Oct 28, 2011 12:00 AM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:


  /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
 dhis found your hibernate.properties file or not, and tell you if the
 DHIS2_HOME was recognised or not.

 Ola
 --

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

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


 On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to
 be picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for
 testing purposes but might happen because your database configuration was
 not picked up. Please make sure this is intentional. Your data will be
 destroyed when the application shuts down.

 My Hibernate File is in
 /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 *You can do anything, but not everything.*



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



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

Re: [Dhis2-users] Help Required

[Knut Staring]

On Fri, Oct 28, 2011 at 10:42 AM, Orvalho Augusto orvaq...@gmail.com wrote:
 And another recommendation is protect tomcat with Apache (configure it to
 work like reverse proxy). Somewhere on the tomcat docs they do recommend
 that too.

Indeed - this is also in the DHIS2 implementation guide:
http://dhis2.org/doc/snapshot/en/implementer/html/ch10s04.html#d5e981

Bob has further refined the setup to ease the task of running multiple
Tomcat instances behind Apache, and is hoping to add this to the
documentation over the next week or so.

Knut

 Caveman




 On Fri, Oct 28, 2011 at 9:49 AM, Jason Pickering
 jason.p.picker...@gmail.com wrote:

 Hi Stephen,
 Just one more important point, and that is to be sure NOT to run Tomcat as
 root'.  If you are using a manual install of Tomcat, as opposed to
 installing it through the package manager of Linux, it is best practice to
 create a seperate user for tomcat, and run the process as a non-privileged
 user. There are numerous examples on the net to show you how to achieve
 this. We should probably highlight this in the implementation guide a bit
 better, but it it documented there from the standpoint of using the package
 manager to install Tomcat, as opposed to a manual install.

 Regards,
 Jason


 On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen stepho...@gmail.com
 wrote:

 Hullo,

 This is a subsection of the log file catalina.out

 It seems the hibernate.properties could not be read

 Deploying web application archive dhis.war
 * INFO  21:50:29,457 System property dhis2.home not set
 (DefaultLocationManager.java [Thread-2])
 * INFO  21:50:29,459 Environment variable DHIS2_HOME points to
 /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])
 * INFO  21:50:30,999 Could not read external configuration from file
 system (DefaultHibernateConfigurationProvider.java [Thread-2])
 * INFO  21:50:48,557 Sceduled task of type:
 org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])
 * INFO  21:50:50,196 Executing startup routine [1 of 11, runlevel 1]:
 TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
 * INFO  21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

 I have SOLVED the Problem.

 Thanks TO ALL

 On Thu, Oct 27, 2011 at 9:13 PM, stepho...@gmail.com wrote:

 Thank you all. Let me checkout on the configuration and have alook at
 the log file.

 As regards the root, so far the computer has that account and it is the
 one that is used to start dhis. May be to confirm, is this the dhis 
 database
 user or the computer user? I hope it is the computer user.

 Will let you. Thanks again

 Sent from my BlackBerry® smartphone provided by Airtel Uganda.

 
 From: Jason Pickering jason.p.picker...@gmail.com
 Date: Fri, 28 Oct 2011 05:57:08 +0200
 To: Ola Hodne Titlestadol...@ifi.uio.no
 Cc: dhis2-users@lists.launchpad.net; Ocaya
 Stephenstepho...@gmail.com
 Subject: Re: [Dhis2-users] Help Required

 Have you properly configured postgres to enable tcp/ip connections from
 localhost?

 You should not run tomcat with root. If you are using another user to
 start tomcat, this user may not be able to read anything from /home/root.

 As knut and ola say however, the log will provide you with the answer.

 Regards,
 Jason

 On Oct 28, 2011 12:00 AM, Ola Hodne Titlestad ol...@ifi.uio.no
 wrote:

  /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you
 whether dhis found your hibernate.properties file or not, and tell you if
 the DHIS2_HOME was recognised or not.
 Ola
 --

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

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link


 On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to be
 picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for
 testing purposes but might happen because your database configuration was
 not picked up. Please make sure this is intentional. Your data will be
 destroyed when the application shuts down.

 My Hibernate File is in
 /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 You can do anything, but not everything.

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

Re: [Dhis2-users] Help Required

[Lars Helge Øverland]

Not trying to confuse people here. But if a reverse proxy is only
what's needed i can recommend using nginx over apache - its
specifically designed to act as one and a lot more light-weight / less
resource intensive than apache. On debian / ubuntu Install with

sudo apt-get install nginx

and then put this into the server block of /usr/local/nginx/conf/nginx.conf

 location / {
proxy_pass http://localhost:8085/dhis/;
proxy_redirect off;
}

start with

/usr/local/sbin/nginx

and stop with

/usr/local/sbin/nginx -s stop



Lars

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

Re: [Dhis2-users] Help Required

[Knut Staring]

Caveman, we don't recommend windows for servers.

Regards, Knut (via mobile phone)
On Oct 28, 2011 7:35 PM, Orvalho Augusto orvaq...@gmail.com wrote:

 Indeed is ngix is better for reverse proxy and a lot of more people start
 to use it. But I think there is not native ngix for windows so apache would
 fit for this.

 And I think is not good to edit files (on debian way)
 /etc/apache/mods-enabled. So on Docs we must change those reverse proxy
 settings to a file located at /etc/apache/sites-*.

 Sorry if I seem bad guy. Thanks!

 Caveman



 2011/10/28 Lars Helge Øverland larshe...@gmail.com

 Not trying to confuse people here. But if a reverse proxy is only
 what's needed i can recommend using nginx over apache - its
 specifically designed to act as one and a lot more light-weight / less
 resource intensive than apache. On debian / ubuntu Install with

 sudo apt-get install nginx

 and then put this into the server block of
 /usr/local/nginx/conf/nginx.conf

  location / {
proxy_pass http://localhost:8085/dhis/;
proxy_redirect off;
 }

 start with

 /usr/local/sbin/nginx

 and stop with

 /usr/local/sbin/nginx -s stop



 Lars



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

Re: [Dhis2-users] Help Required

[Orvalho Augusto]

Good! Thanks

Caveman

On Fri, Oct 28, 2011 at 7:40 PM, Knut Staring knu...@gmail.com wrote:

 Caveman, we don't recommend windows for servers.

 Regards, Knut (via mobile phone)
 On Oct 28, 2011 7:35 PM, Orvalho Augusto orvaq...@gmail.com wrote:

 Indeed is ngix is better for reverse proxy and a lot of more people start
 to use it. But I think there is not native ngix for windows so apache would
 fit for this.

 And I think is not good to edit files (on debian way)
 /etc/apache/mods-enabled. So on Docs we must change those reverse proxy
 settings to a file located at /etc/apache/sites-*.

 Sorry if I seem bad guy. Thanks!

 Caveman



 2011/10/28 Lars Helge Øverland larshe...@gmail.com

 Not trying to confuse people here. But if a reverse proxy is only
 what's needed i can recommend using nginx over apache - its
 specifically designed to act as one and a lot more light-weight / less
 resource intensive than apache. On debian / ubuntu Install with

 sudo apt-get install nginx

 and then put this into the server block of
 /usr/local/nginx/conf/nginx.conf

  location / {
proxy_pass http://localhost:8085/dhis/;
proxy_redirect off;
 }

 start with

 /usr/local/sbin/nginx

 and stop with

 /usr/local/sbin/nginx -s stop



 Lars



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

[Dhis2-users] Help Required

[Ocaya Stephen]

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
Outlined on the website (dhis2.org) and the application seems not to be
picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
The database is currently running in-memory. This is useful for testing
purposes but might happen because your database configuration was not picked
up. Please make sure this is intentional. Your data will be destroyed when
the application shuts down.

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here.
/usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


Thanks for any Help
Stephen Ocaya

-- 

*You can do anything, but not everything.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Help Required

[Ola Hodne Titlestad]

 /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
dhis found your hibernate.properties file or not, and tell you if the
DHIS2_HOME was recognised or not.

Ola
--

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

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps
linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to be
 picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for testing
 purposes but might happen because your database configuration was not picked
 up. Please make sure this is intentional. Your data will be destroyed when
 the application shuts down.

 My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 *You can do anything, but not everything.*



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


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

Re: [Dhis2-users] Help Required

[Jason Pickering]

Have you properly configured postgres to enable tcp/ip connections from
localhost?

You should not run tomcat with root. If you are using another user to start
tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,
Jason
On Oct 28, 2011 12:00 AM, Ola Hodne Titlestad ol...@ifi.uio.no wrote:


  /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
 dhis found your hibernate.properties file or not, and tell you if the
 DHIS2_HOME was recognised or not.

 Ola
 --

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

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


 On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to be
 picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for testing
 purposes but might happen because your database configuration was not picked
 up. Please make sure this is intentional. Your data will be destroyed when
 the application shuts down.

 My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 *You can do anything, but not everything.*



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



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


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

Re: [Dhis2-users] Help Required

[stephocay]

Thank you all. Let me checkout on the configuration and have alook at the log 
file. 

As regards the root, so far the computer has that account and it is the one 
that is used to start dhis. May be to confirm, is this the dhis database user 
or the computer user? I hope it is the computer user.

Will let you. Thanks again
Sent from my BlackBerry® smartphone provided by Airtel Uganda.

-Original Message-
From: Jason Pickering jason.p.picker...@gmail.com
Date: Fri, 28 Oct 2011 05:57:08 
To: Ola Hodne Titlestadol...@ifi.uio.no
Cc: dhis2-users@lists.launchpad.net; Ocaya Stephenstepho...@gmail.com
Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from
localhost?

You should not run tomcat with root. If you are using another user to start
tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,
Jason
On Oct 28, 2011 12:00 AM, Ola Hodne Titlestad ol...@ifi.uio.no wrote:


  /usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether
 dhis found your hibernate.properties file or not, and tell you if the
 DHIS2_HOME was recognised or not.

 Ola
 --

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

 Mobile: +47 48069736
 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps 
 linkhttp://maps.google.com/maps?f=qsource=s_qhl=engeocode=q=Vetlandsvn.+95B,+0685+Oslo,+Norway


 On 27 October 2011 20:58, Ocaya Stephen stepho...@gmail.com wrote:

 Hullo All,

 I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
 Outlined on the website (dhis2.org) and the application seems not to be
 picking the database connection setting in hibernate.properties.

 On Logging, I See the following Message:
 The database is currently running in-memory. This is useful for testing
 purposes but might happen because your database configuration was not picked
 up. Please make sure this is intentional. Your data will be destroyed when
 the application shuts down.

 My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

 MY Environment Variable is Here.
 /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
 setenv.sh is below

 export JAVA_HOME=/usr/lib/jvm/java-6-sun
 export JAVA_OPTS=-Xmx600m -XX:MaxPermSize=1000m
 export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/


 Thanks for any Help
 Stephen Ocaya

 --

 *You can do anything, but not everything.*



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



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



___
Mailing list: https://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] help me on how to use replaceid syntax

[Muhire Andrew]

Thanks for the quick help,
i have successfully used the select and delete steps(in datavalues and 
datavalue_audit) but using replace id is not working on my side may be am not 
using it well? please update me again (only replace syntax). i have deleted 
data from my data element x and next step was to use replace but am getting 
syntax error! and if i check my data in data entry form i find no data and if i 
delete the data element in an interface next time i get error message for the 
unreplaced id when i open the form.
waiting for your help dear team!
 
 








Muhire Andrew

HMIS/Ministry of Health
andrew.muh...@moh.gov.rw
God is my provider.




From: Jason Pickering jason.p.picker...@gmail.com
To: Muhire Andrew muhireand...@yahoo.com
Cc: Knut Staring knu...@gmail.com; Lars Helge Øverland larshe...@gmail.com; 
dhis2-users@lists.launchpad.net dhis2-users@lists.launchpad.net; 
dhis2-d...@lists.launchpad.net dhis2-d...@lists.launchpad.net
Sent: Monday, September 12, 2011 4:13 PM
Subject: Re: [Dhis2-devs] Dear Dhis2 users how can i delete?


It is best practice in all cases to ensure to you make a backup of your 
database. Even with SELECT and DELETE, you may unknowingly make a typing 
mistake. Anytime you start messing around with the database directly, ensure 
you first make a backup, so that you can easily restore the database in case 
you mess up something unintentionally. 

Another trick is to use a SELECT INTO  statement, to put all of the data you 
are about to delete into a separate table, and then perform the delete 
operation. This way, it is relatively easy to see what you have deleted and 
restore it once again, without reverting to a complete backup restore. 

Regards,
Jason



2011/9/12 Muhire Andrew muhireand...@yahoo.com

Thank you all,
Great Knut its rilly good to select first and then delete because it can cause 
problems in case i delete  the needed data.
 








Muhire Andrew

HMIS/Ministry of Health
andrew.muh...@moh.gov.rw
God is my provider.






From: Knut Staring knu...@gmail.com
To: Lars Helge Øverland larshe...@gmail.com
Cc: Muhire Andrew muhireand...@yahoo.com; dhis2-users@lists.launchpad.net; 
dhis2-d...@lists.launchpad.net
Sent: Monday, September 12, 2011 3:56 PM
Subject: Re: [Dhis2-devs] Dear Dhis2 users how can i delete?



As a rule of thumb, it is usually wise to do a SELECT before a DELETE, so that 
you are 100% sure you are not deleting data you really need.


In this case:


select * from datavalue_audit where dataelementid=id;
select * from datavalue where dataelementid=id;


Knut


2011/9/12 Lars Helge Øverland larshe...@gmail.com

Hi Andrew,

you need to remove the data with SQL in the database. Run:

delete from datavalue_audit where dataelementid=id;
delete from datavalue where dataelementid=id;

and replace id with the dataelementid of the one you want to remove.

You can then go ahead and delete the data element in the user interface.



Lars

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

More help   : https://help.launchpad.net/ListHelp




-- 

Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522



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

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