Re: [Dhis2-users] Event Report (Events) - select data items which have no value

[Martin Van Aken]

Hello !
Good to know, thanks. To be fair - the doc does not refer to any support of
a null operator, I just tried my luck there.

I'll try Aaron logic - if I can create an indicator whose value would be 0
when the 'main' indicator has no value, I got a proxy for my query which is
all I need.

I'll follow the jira anyway.

Martin

On Tue, Feb 6, 2018 at 5:46 AM, Prosper BT  wrote:

> Dear Martin,
>
> Refer to this jira issues DHIS2-1219
>  requesting additional support
> for Null and missing in Events report filters
> Its to be done in 2.30
>
> Regards
>
> Prosper Behumbiize, MPH
> DHIS2 Implementation Adviser| HISP Uganda
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> On Tue, Feb 6, 2018 at 12:57 AM, Abyot Asalefew Gizaw 
> wrote:
>
>> Hi,
>>
>> Seems we have a bug there...  please file a JIRA issue and we would
>> address it as soon as we can.
>>
>> Otherwise, since 2.25 on we have introduced support to filter events
>> based on data element values. You can play around with columns of the event
>> grid in event capture app to see the request url sent to server. Below is
>> an example
>>
>> https://play.dhis2.org/dev/api/28/events/query.json?orgUnit=
>> DiszpKrYNg8=Zj7UnCAulEk=qrur9Dvnyt5:GT:10:LT:100
>> =qrur9Dvnyt5,S33cRBsnXPo,fWIAEtYVEGk,K6uUAvq500H&
>> order=lastUpdated:desc=50=1=true
>>
>> It goes by something like
>>
>> *api/events/query?filter=DATAELEMENT_UID:OPERATOR:VALUE*
>>
>> *api/events/query?filter=DATAELEMENT_UID:EQ:NULL*
>>
>> Unfortunately, we have a bug  in handling NULL as part of the query
>> parameter.
>>
>> --
>> Abyot A. Gizaw.
>> Senior Engineer, DHIS2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Mon, Feb 5, 2018 at 10:01 PM, Martin Van Aken > > wrote:
>>
>>> Ok, got it, I was missing some context. Looks an interesting way to
>>> actually tackle some of the "queries" I have to do for a project.
>>>
>>> Thanks a lot!
>>>
>>> Martin
>>>
>>> On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White 
>>> wrote:
>>>
 I just had to tackle something similar recently, so it's fresh on my
 mind.  The functions are built in to DHIS2 (but I believe are part of the
 JEXL library according to the docs).You would need to create the
 program indicator first, run analytics, and then request the program
 indicator instead of the data element in question.  I don't think you
 can use it to hit the analytics endpoint directly.  You can find some
 examples and more detail here
 
 .

 Aaron


 --
 Aaron C. White
 919.522.5585 <(919)%20522-5585>

 On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken <
 mar...@joyouscoding.com> wrote:

> Would not have though of that approach - your examples uses the d2 JS
> library? Are those "operators" usable in a analytics/events/query filter
> string? (tried the "aggregate" null operator, but it did not work)
>
> Thanks !
>
> Martin
>
> On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White 
> wrote:
>
>> Martin,
>>
>> What if you made a program indicator with inverse logic?  Something
>> like "!d2:hasValue(#{your_de_uid})", since if the value is numeric
>> "d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
>> positive and otherwise returns 0.  I bet one of those or a combination
>> would solve that problem.
>>
>> Aaron
>>
>>
>> --
>> Aaron C. White
>> 919.522.5585 <(919)%20522-5585>
>>
>> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken <
>> mar...@joyouscoding.com> wrote:
>>
>>> Hi everyone,
>>> We are interested to get an event report with all events where a
>>> specific data item has no value (ie, not 0, no value at all). We're on
>>> 2.26, an all the conditins available are <, <=, =, > etc.
>>>
>>> Putting "=" then an empty field does not filter anything, and in
>>> this case "0" is taken as a separated value than "no value".
>>>
>>> Is there any way to do this?
>>>
>>> Thanks,
>>>
>>> Martin
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken
>>> 
>>> Call me on Skype : vanakenm
>>> Hang out with me : mar...@joyouscoding.com
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe 

Re: [Dhis2-users] Discrepancy in weekly vs monthly reporting period

[Prosper BT]

Dear Raheel,

This is caused by the overlap in weeks over different months, it will not
perfectly match unless you are collecting data daily.

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Thu, Feb 1, 2018 at 10:02 PM, Raheel Ayaz  wrote:

> Hi all,
>
> I get different monthly consultation numbers when I create same pivot
> table using weekly and monthly reporting period for same period (let’s say
> Jan-2018).  Therefore, I was wondering if anyone ever encounter same issue
> with  DHIS2 implementation and how I can resolve this problem because I
> can’t rely on monthly, quarterly, annual reporting period numbers as they
> are not accurate as weekly.
>
>
> Many thanks,
>
> Raheel
>
>
>
>
> ___
> Mailing list: https://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] Event Report (Events) - select data items which have no value

[Prosper BT]

Dear Martin,

Refer to this jira issues DHIS2-1219
 requesting additional support
for Null and missing in Events report filters
Its to be done in 2.30

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda
pros...@hispuganda.org  | pros...@dhis2.org | Skype:
prospertb

On Tue, Feb 6, 2018 at 12:57 AM, Abyot Asalefew Gizaw 
wrote:

> Hi,
>
> Seems we have a bug there...  please file a JIRA issue and we would
> address it as soon as we can.
>
> Otherwise, since 2.25 on we have introduced support to filter events based
> on data element values. You can play around with columns of the event grid
> in event capture app to see the request url sent to server. Below is an
> example
>
> https://play.dhis2.org/dev/api/28/events/query.json?orgUnit=DiszpKrYNg8;
> programStage=Zj7UnCAulEk=qrur9Dvnyt5:GT:10:LT:100&
> dataElement=qrur9Dvnyt5,S33cRBsnXPo,fWIAEtYVEGk,
> K6uUAvq500H=lastUpdated:desc=50=1=true
>
> It goes by something like
>
> *api/events/query?filter=DATAELEMENT_UID:OPERATOR:VALUE*
>
> *api/events/query?filter=DATAELEMENT_UID:EQ:NULL*
>
> Unfortunately, we have a bug  in handling NULL as part of the query
> parameter.
>
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org
>
> On Mon, Feb 5, 2018 at 10:01 PM, Martin Van Aken 
> wrote:
>
>> Ok, got it, I was missing some context. Looks an interesting way to
>> actually tackle some of the "queries" I have to do for a project.
>>
>> Thanks a lot!
>>
>> Martin
>>
>> On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White 
>> wrote:
>>
>>> I just had to tackle something similar recently, so it's fresh on my
>>> mind.  The functions are built in to DHIS2 (but I believe are part of the
>>> JEXL library according to the docs).You would need to create the
>>> program indicator first, run analytics, and then request the program
>>> indicator instead of the data element in question.  I don't think you
>>> can use it to hit the analytics endpoint directly.  You can find some
>>> examples and more detail here
>>> 
>>> .
>>>
>>> Aaron
>>>
>>>
>>> --
>>> Aaron C. White
>>> 919.522.5585 <(919)%20522-5585>
>>>
>>> On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken >> > wrote:
>>>
 Would not have though of that approach - your examples uses the d2 JS
 library? Are those "operators" usable in a analytics/events/query filter
 string? (tried the "aggregate" null operator, but it did not work)

 Thanks !

 Martin

 On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White 
 wrote:

> Martin,
>
> What if you made a program indicator with inverse logic?  Something
> like "!d2:hasValue(#{your_de_uid})", since if the value is numeric
> "d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
> positive and otherwise returns 0.  I bet one of those or a combination
> would solve that problem.
>
> Aaron
>
>
> --
> Aaron C. White
> 919.522.5585 <(919)%20522-5585>
>
> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken <
> mar...@joyouscoding.com> wrote:
>
>> Hi everyone,
>> We are interested to get an event report with all events where a
>> specific data item has no value (ie, not 0, no value at all). We're on
>> 2.26, an all the conditins available are <, <=, =, > etc.
>>
>> Putting "=" then an empty field does not filter anything, and in this
>> case "0" is taken as a separated value than "no value".
>>
>> Is there any way to do this?
>>
>> Thanks,
>>
>> Martin
>>
>> --
>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>
>> Mobile : +32 486 899 652
>>
>> Follow me on Twitter : @martinvanaken
>> 
>> Call me on Skype : vanakenm
>> Hang out with me : mar...@joyouscoding.com
>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>> Company website : www.joyouscoding.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
>>
>>
>


 --
 *Martin Van Aken - **Freelance Enthusiast Developer*

 Mobile : +32 486 899 652

 Follow me on Twitter : @martinvanaken
 
 Call me on Skype : vanakenm
 Hang out with me : mar...@joyouscoding.com
 Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
 Company website : www.joyouscoding.com

>>>
>>>
>>
>>
>> --
>> 

Re: [Dhis2-users] Event Report (Events) - select data items which have no value

[Abyot Asalefew Gizaw]

Hi,

Seems we have a bug there...  please file a JIRA issue and we would address
it as soon as we can.

Otherwise, since 2.25 on we have introduced support to filter events based
on data element values. You can play around with columns of the event grid
in event capture app to see the request url sent to server. Below is an
example

https://play.dhis2.org/dev/api/28/events/query.json?orgUnit=DiszpKrYNg8=Zj7UnCAulEk;
filter=qrur9Dvnyt5:GT:10:LT:100
=qrur9Dvnyt5,S33cRBsnXPo,fWIAEtYVEGk,K6uUAvq500H=lastUpdated:desc=50=1=true

It goes by something like

*api/events/query?filter=DATAELEMENT_UID:OPERATOR:VALUE*

*api/events/query?filter=DATAELEMENT_UID:EQ:NULL*

Unfortunately, we have a bug  in handling NULL as part of the query
parameter.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org

On Mon, Feb 5, 2018 at 10:01 PM, Martin Van Aken 
wrote:

> Ok, got it, I was missing some context. Looks an interesting way to
> actually tackle some of the "queries" I have to do for a project.
>
> Thanks a lot!
>
> Martin
>
> On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White 
> wrote:
>
>> I just had to tackle something similar recently, so it's fresh on my
>> mind.  The functions are built in to DHIS2 (but I believe are part of the
>> JEXL library according to the docs).You would need to create the
>> program indicator first, run analytics, and then request the program
>> indicator instead of the data element in question.  I don't think you
>> can use it to hit the analytics endpoint directly.  You can find some
>> examples and more detail here
>> 
>> .
>>
>> Aaron
>>
>>
>> --
>> Aaron C. White
>> 919.522.5585 <(919)%20522-5585>
>>
>> On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken 
>> wrote:
>>
>>> Would not have though of that approach - your examples uses the d2 JS
>>> library? Are those "operators" usable in a analytics/events/query filter
>>> string? (tried the "aggregate" null operator, but it did not work)
>>>
>>> Thanks !
>>>
>>> Martin
>>>
>>> On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White 
>>> wrote:
>>>
 Martin,

 What if you made a program indicator with inverse logic?  Something
 like "!d2:hasValue(#{your_de_uid})", since if the value is numeric
 "d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
 positive and otherwise returns 0.  I bet one of those or a combination
 would solve that problem.

 Aaron


 --
 Aaron C. White
 919.522.5585 <(919)%20522-5585>

 On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken <
 mar...@joyouscoding.com> wrote:

> Hi everyone,
> We are interested to get an event report with all events where a
> specific data item has no value (ie, not 0, no value at all). We're on
> 2.26, an all the conditins available are <, <=, =, > etc.
>
> Putting "=" then an empty field does not filter anything, and in this
> case "0" is taken as a separated value than "no value".
>
> Is there any way to do this?
>
> Thanks,
>
> Martin
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken
> 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.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
>
>

>>>
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken 
>>> Call me on Skype : vanakenm
>>> Hang out with me : mar...@joyouscoding.com
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>>
>>
>>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.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] Event Report (Events) - select data items which have no value

[Martin Van Aken]

Ok, got it, I was missing some context. Looks an interesting way to
actually tackle some of the "queries" I have to do for a project.

Thanks a lot!

Martin

On Mon, Feb 5, 2018 at 9:56 PM, Aaron C White  wrote:

> I just had to tackle something similar recently, so it's fresh on my
> mind.  The functions are built in to DHIS2 (but I believe are part of the
> JEXL library according to the docs).You would need to create the
> program indicator first, run analytics, and then request the program
> indicator instead of the data element in question.  I don't think you can
> use it to hit the analytics endpoint directly.  You can find some
> examples and more detail here
> 
> .
>
> Aaron
>
>
> --
> Aaron C. White
> 919.522.5585 <(919)%20522-5585>
>
> On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken 
> wrote:
>
>> Would not have though of that approach - your examples uses the d2 JS
>> library? Are those "operators" usable in a analytics/events/query filter
>> string? (tried the "aggregate" null operator, but it did not work)
>>
>> Thanks !
>>
>> Martin
>>
>> On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White 
>> wrote:
>>
>>> Martin,
>>>
>>> What if you made a program indicator with inverse logic?  Something like
>>> "!d2:hasValue(#{your_de_uid})", since if the value is numeric
>>> "d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
>>> positive and otherwise returns 0.  I bet one of those or a combination
>>> would solve that problem.
>>>
>>> Aaron
>>>
>>>
>>> --
>>> Aaron C. White
>>> 919.522.5585 <(919)%20522-5585>
>>>
>>> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken <
>>> mar...@joyouscoding.com> wrote:
>>>
 Hi everyone,
 We are interested to get an event report with all events where a
 specific data item has no value (ie, not 0, no value at all). We're on
 2.26, an all the conditins available are <, <=, =, > etc.

 Putting "=" then an empty field does not filter anything, and in this
 case "0" is taken as a separated value than "no value".

 Is there any way to do this?

 Thanks,

 Martin

 --
 *Martin Van Aken - **Freelance Enthusiast Developer*

 Mobile : +32 486 899 652

 Follow me on Twitter : @martinvanaken
 
 Call me on Skype : vanakenm
 Hang out with me : mar...@joyouscoding.com
 Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
 Company website : www.joyouscoding.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


>>>
>>
>>
>> --
>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>
>> Mobile : +32 486 899 652
>>
>> Follow me on Twitter : @martinvanaken 
>> Call me on Skype : vanakenm
>> Hang out with me : mar...@joyouscoding.com
>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>> Company website : www.joyouscoding.com
>>
>
>


-- 
*Martin Van Aken - **Freelance Enthusiast Developer*

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken 
Call me on Skype : vanakenm
Hang out with me : mar...@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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] Event Report (Events) - select data items which have no value

[Aaron C White]

I just had to tackle something similar recently, so it's fresh on my mind.
The functions are built in to DHIS2 (but I believe are part of the JEXL
library according to the docs).You would need to create the program
indicator first, run analytics, and then request the program indicator
instead of the data element in question.  I don't think you can use it to
hit the analytics endpoint directly.  You can find some examples and more
detail here

.

Aaron


--
Aaron C. White
919.522.5585

On Mon, Feb 5, 2018 at 3:48 PM, Martin Van Aken 
wrote:

> Would not have though of that approach - your examples uses the d2 JS
> library? Are those "operators" usable in a analytics/events/query filter
> string? (tried the "aggregate" null operator, but it did not work)
>
> Thanks !
>
> Martin
>
> On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White 
> wrote:
>
>> Martin,
>>
>> What if you made a program indicator with inverse logic?  Something like
>> "!d2:hasValue(#{your_de_uid})", since if the value is numeric
>> "d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
>> positive and otherwise returns 0.  I bet one of those or a combination
>> would solve that problem.
>>
>> Aaron
>>
>>
>> --
>> Aaron C. White
>> 919.522.5585 <(919)%20522-5585>
>>
>> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken > > wrote:
>>
>>> Hi everyone,
>>> We are interested to get an event report with all events where a
>>> specific data item has no value (ie, not 0, no value at all). We're on
>>> 2.26, an all the conditins available are <, <=, =, > etc.
>>>
>>> Putting "=" then an empty field does not filter anything, and in this
>>> case "0" is taken as a separated value than "no value".
>>>
>>> Is there any way to do this?
>>>
>>> Thanks,
>>>
>>> Martin
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken 
>>> Call me on Skype : vanakenm
>>> Hang out with me : mar...@joyouscoding.com
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.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
>>>
>>>
>>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.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] Event Report (Events) - select data items which have no value

[Martin Van Aken]

Would not have though of that approach - your examples uses the d2 JS
library? Are those "operators" usable in a analytics/events/query filter
string? (tried the "aggregate" null operator, but it did not work)

Thanks !

Martin

On Mon, Feb 5, 2018 at 6:24 PM, Aaron C White  wrote:

> Martin,
>
> What if you made a program indicator with inverse logic?  Something like
> "!d2:hasValue(#{your_de_uid})", since if the value is numeric
> "d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
> positive and otherwise returns 0.  I bet one of those or a combination
> would solve that problem.
>
> Aaron
>
>
> --
> Aaron C. White
> 919.522.5585 <(919)%20522-5585>
>
> On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken 
> wrote:
>
>> Hi everyone,
>> We are interested to get an event report with all events where a specific
>> data item has no value (ie, not 0, no value at all). We're on 2.26, an all
>> the conditins available are <, <=, =, > etc.
>>
>> Putting "=" then an empty field does not filter anything, and in this
>> case "0" is taken as a separated value than "no value".
>>
>> Is there any way to do this?
>>
>> Thanks,
>>
>> Martin
>>
>> --
>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>
>> Mobile : +32 486 899 652
>>
>> Follow me on Twitter : @martinvanaken 
>> Call me on Skype : vanakenm
>> Hang out with me : mar...@joyouscoding.com
>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>> Company website : www.joyouscoding.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
>>
>>
>


-- 
*Martin Van Aken - **Freelance Enthusiast Developer*

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken 
Call me on Skype : vanakenm
Hang out with me : mar...@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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] Event Report (Events) - select data items which have no value

[Aaron C White]

Martin,

What if you made a program indicator with inverse logic?  Something like
"!d2:hasValue(#{your_de_uid})", since if the value is numeric
"d2:oizp(#{your_de_uid})".  d2:oizp returns 1 if the value is zero or
positive and otherwise returns 0.  I bet one of those or a combination
would solve that problem.

Aaron


--
Aaron C. White
919.522.5585

On Mon, Feb 5, 2018 at 10:53 AM, Martin Van Aken 
wrote:

> Hi everyone,
> We are interested to get an event report with all events where a specific
> data item has no value (ie, not 0, no value at all). We're on 2.26, an all
> the conditins available are <, <=, =, > etc.
>
> Putting "=" then an empty field does not filter anything, and in this case
> "0" is taken as a separated value than "no value".
>
> Is there any way to do this?
>
> Thanks,
>
> Martin
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.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] Access Tracker capture program stage data through API

[Georgi Chakarov]

Hi all,

Can anyone tell me what is the query to read all data entered in a Tracker 
capture program stage?

We have tried this:
/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc
and other versions like /api/26/events.json?orgUnit=YuQRtpLP10I=CHILDREN 
but we get the result below. Your feedback is highly appreciated!


[cid:image001.jpg@01D39EAD.EDD22760]

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] Event Report (Events) - select data items which have no value

[Martin Van Aken]

Hi everyone,
We are interested to get an event report with all events where a specific
data item has no value (ie, not 0, no value at all). We're on 2.26, an all
the conditins available are <, <=, =, > etc.

Putting "=" then an empty field does not filter anything, and in this case
"0" is taken as a separated value than "no value".

Is there any way to do this?

Thanks,

Martin

-- 
*Martin Van Aken - **Freelance Enthusiast Developer*

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken 
Call me on Skype : vanakenm
Hang out with me : mar...@joyouscoding.com
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.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] [Dhis2-devs] Program indicators export to another system

[Knut Staring]

Agree very much on having a GUI/app for mapping.

For example, I am currently setting up an instance with simplified
geometries for the whole world based on GADM - with the hierarchy down to
admin level 1, 2, 3, 4 created based on the shapefiles and using the codes
from GADM for admin1 and admin2

It would then be great to be able to link the GADM orgunits with
names/codes used by existing MoH data collection setups (whether Excel,
Access, DHIS2 or other). Would be good to preserve the mapping for later
also, perhaps as an attribute.

On a side note, I heard that someone created an app which can import such
mapping between a shapefile and an exciting orgunit hierarchy in Excel,
which is also not a bad solution.

Knut

On Mon, Feb 5, 2018 at 11:02 AM, Calle Hedberg 
wrote:

> Knut
>
> I did that for IDSR/Malaria in order to "map" local IDSR program
> indicators to the WHO aggregated malaria data elements.
>
> It is, frankly, a painful and "expert" approach to the problem, and in my
> opinion very difficult to maintain.
>
> The presumably simplest solution is to expand the "Data Value Set"
> download option under the pivot table app to incorporate the optional use
> of CODES or NAMES. While some might argue that using the same code or name
> for a Program Indicator as for an aggregated data element is not "purist",
> it should work.
>
> A more sophisticated solution that would be useful for any type of data
> import is to introduce data element and organisationunit "mapping" during
> import - similar functionality has been available in DHIS v1 since time
> immemorial.
>
> Users can then define/store/use two lookup field values: uid (or
> code/name) INCOMING, and uid (or code/name) IMPORTING. So incoming
> uid/code/name will automatically be replaced by the equivalent/correct
> value before the system start POSTing records.
>
> Regards
> Calle
>
> On 1 February 2018 at 18:07, Knut Staring  wrote:
>
>> Hi Elmarie,
>>
>> This is an important issue, and I expect others will have a better
>> answer, but one approach could perhaps be to replace the UID for the
>> Programme Indicators with the desired data element UID. I suppose that
>> would have to be done either directly in the database or through the API,
>> but if it were to be a recommended way to link databases it should also be
>> possibly to do this kind of mapping through the user interface
>>
>> Knut
>>
>> On Thu, Feb 1, 2018 at 4:59 PM, Elmarie Claasen  wrote:
>>
>>> Hi all,
>>>
>>> Any response to this question?
>>>
>>> Regards
>>>
>>> Elmarie
>>>
>>> On 30 Jan 2018 12:11, "Elmarie Claasen"  wrote:
>>>
 Hi all,



 We create Programme Indicators and would like to export those to other
 systems with different data element UIDs than the created Programme
 Indicator UID.

 If adding a code to the Programme Indicator which is same as the Data
 Element code will this allow matching on import?



 Regards,



 *Elmarie Claasen*

 [image: Hisp logo]

 Project Manager

 Health Information Systems Program

 Tel:  041-367 1027

 Cell: 082 374 2209

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

 Skype:  elmarie.claasen52



>>>
>>> *This message and any attachments are subject to a disclaimer published
>>> at http://www.hisp.org/policies.html#comms_disclaimer
>>> .  Please read the
>>> disclaimer before opening any attachment or taking any other action in
>>> terms of this electronic transmission.  If you cannot access the
>>> disclaimer, kindly send an email to disclai...@hisp.org
>>>  and a copy will be provided to you. By replying to
>>> this e-mail or opening any attachment you agree to be bound by the
>>> provisions of the disclaimer.*
>>>
>>> ___
>>> 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
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
>> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
>> Skype: knutstar
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
>
> Tel/fax (home): +27-21-685-6472 

Re: [Dhis2-users] [Dhis2-devs] Program indicators export to another system

[Aaron C White]

Elmarie,

The devs might correct me, but I don't think that the code import scheme
would account for different data element ids since the import tool would be
trying to match a code for the programIndicator itself and not the
configured expression or filter.

I ran into this problem last year and did not have the ability to control
the source server, but I had API access to read metadata configuration.  If
you are familiar with a scripting language, you could create a set of
key/value pairs where the key is the existing ID from your source system
and the new ID in the destination system.  Get the programIndicators in
JSON/XML format via the API.  Then for each unique pair, recursively search
through the metadata for the key (source UID) and replace with the value
(destination UID) wherever found using a regex-like function. It can be
slow if you're dealing with a large configuration but ensures that you
don't miss an association somewhere that you forgot to explicitly code.

For just programIndicators, you would want to at least check the expression
and the filter attributes for the IDs in question.  Since it sounds like
you have the same configuration but different ID values, you also would
want to confirm that the programStage IDs are also correctly mapped.  In
the programIndicator construction you would see this as #{programStageId.
dataElementId}.

When I did this, I stored the source server UIDs in the code attribute of
my destination server since we were not using that field as a way to
persist the "map" between the two systems.  As Calle said, this whole
process is certainly an "expert" level approach and can degrade over time
if your source server changes metadata configuration. The proposed
SOURCE/DESTINATION mapping using the existing import tool would be great,
but still would require maintenance if the configuration changes (if you're
trying to maintain a matching configuration).

Otherwise, you would need to replace the references via the UI, but that
probably wouldn't be a great plan if you have to update more than one or
two.

Aaron


--
Aaron C. White
919.522.5585

On Thu, Feb 1, 2018 at 11:07 AM, Knut Staring  wrote:

> Hi Elmarie,
>
> This is an important issue, and I expect others will have a better answer,
> but one approach could perhaps be to replace the UID for the Programme
> Indicators with the desired data element UID. I suppose that would have to
> be done either directly in the database or through the API, but if it were
> to be a recommended way to link databases it should also be possibly to do
> this kind of mapping through the user interface
>
> Knut
>
> On Thu, Feb 1, 2018 at 4:59 PM, Elmarie Claasen  wrote:
>
>> Hi all,
>>
>> Any response to this question?
>>
>> Regards
>>
>> Elmarie
>>
>> On 30 Jan 2018 12:11, "Elmarie Claasen"  wrote:
>>
>>> Hi all,
>>>
>>>
>>>
>>> We create Programme Indicators and would like to export those to other
>>> systems with different data element UIDs than the created Programme
>>> Indicator UID.
>>>
>>> If adding a code to the Programme Indicator which is same as the Data
>>> Element code will this allow matching on import?
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> *Elmarie Claasen*
>>>
>>> [image: Hisp logo]
>>>
>>> Project Manager
>>>
>>> Health Information Systems Program
>>>
>>> Tel:  041-367 1027
>>>
>>> Cell: 082 374 2209
>>>
>>> E-mail: elma...@hisp.org
>>>
>>> Skype:  elmarie.claasen52
>>>
>>>
>>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>> ___
>> 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
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype: knutstar
>
> ___
> Mailing list: https://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] A bug notification in DHIS2

[n M]

Dear Sir or Madam,

 During the process to make the third data entry form for a program(all 
camcer2) in DHIS2 (version number 2.28), I recieved this bug notification "an 
exception occured sorry! The system failed to execute the operation. Usually, 
no dara is lost and you can continue working by going back to the previous 
page" , but I cannot continue preparing the entry form by going back to the 
previous page.  I started to prepare a new program with those data entry forms 
but I recieved the notification again. Could you please help me to solve this 
problem. I'm looking forward to hearing from you as soon as it possible.

Thanks,
Najme

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

Re: [Dhis2-users] DHIS2 Android Dashboard Application Pulling Org Unit Codes instead of Org Unit Names

[Ignacio Foche]

Hi Alison,

This problem may be another example of what's been already reported on Jira
in this issue: https://jira.dhis2.org/browse/ACA-117 that's blocked by this
other server issue: https://jira.dhis2.org/browse/DHIS2-2437. If that's the
case, it has to do with how charts are generated on the server. Android App
just calls the server to provide a png with the image of the chart. As far
as I know, this is not going to be addressed in the short-term, but
probably somebody from the web team can correct me. Otherwise, maybe you
can write directly to those issues.

Just in case, if you want to get what Android is showing you:
- If it's an chart: click on "Favorites" -> "Get Link" -> "Open in web api"
- If it's an table: click on "Download" -> "HTML"
- If it's a map -> "Share" - "API link"

If you see there what you're seeing on your Android device, then I guess
writing to the DHIS2-2437 issue providing details of your situation is the
way to proceed. If you're not seeing the same, then writing to the ACA-117
issue is probably the right thing.

I hope it helps.

Best regards


Le lun. 5 févr. 2018 à 10:10, Alison Ngulube  a écrit :

> Hi DHIS2 Community
>
> We are having an issue with the dhis2 dashboard android application where
> the org units on the charts are being downloaded with org unit codes
> instead of org unit names. Could this be a setting on our instance that is
> causing this or could it be an issue with the android application itself?
> Find attached an image of what am talking about.
>
> Regards,
>
> Alison.
> [image: Akros] 
> Alison Ngulube | Information Systems Technician
> angul...@akros.com | +260.978.949.533
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
-- 
Ignacio Foche Pérez
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Program indicators export to another system

[Calle Hedberg]

Knut

I did that for IDSR/Malaria in order to "map" local IDSR program indicators
to the WHO aggregated malaria data elements.

It is, frankly, a painful and "expert" approach to the problem, and in my
opinion very difficult to maintain.

The presumably simplest solution is to expand the "Data Value Set" download
option under the pivot table app to incorporate the optional use of CODES
or NAMES. While some might argue that using the same code or name for a
Program Indicator as for an aggregated data element is not "purist", it
should work.

A more sophisticated solution that would be useful for any type of data
import is to introduce data element and organisationunit "mapping" during
import - similar functionality has been available in DHIS v1 since time
immemorial.

Users can then define/store/use two lookup field values: uid (or code/name)
INCOMING, and uid (or code/name) IMPORTING. So incoming uid/code/name will
automatically be replaced by the equivalent/correct value before the system
start POSTing records.

Regards
Calle

On 1 February 2018 at 18:07, Knut Staring  wrote:

> Hi Elmarie,
>
> This is an important issue, and I expect others will have a better answer,
> but one approach could perhaps be to replace the UID for the Programme
> Indicators with the desired data element UID. I suppose that would have to
> be done either directly in the database or through the API, but if it were
> to be a recommended way to link databases it should also be possibly to do
> this kind of mapping through the user interface
>
> Knut
>
> On Thu, Feb 1, 2018 at 4:59 PM, Elmarie Claasen  wrote:
>
>> Hi all,
>>
>> Any response to this question?
>>
>> Regards
>>
>> Elmarie
>>
>> On 30 Jan 2018 12:11, "Elmarie Claasen"  wrote:
>>
>>> Hi all,
>>>
>>>
>>>
>>> We create Programme Indicators and would like to export those to other
>>> systems with different data element UIDs than the created Programme
>>> Indicator UID.
>>>
>>> If adding a code to the Programme Indicator which is same as the Data
>>> Element code will this allow matching on import?
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>>
>>> *Elmarie Claasen*
>>>
>>> [image: Hisp logo]
>>>
>>> Project Manager
>>>
>>> Health Information Systems Program
>>>
>>> Tel:  041-367 1027
>>>
>>> Cell: 082 374 2209
>>>
>>> E-mail: elma...@hisp.org
>>>
>>> Skype:  elmarie.claasen52
>>>
>>>
>>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>> ___
>> 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
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype: knutstar
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

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

[Dhis2-users] BAO Systems Newsletter November 2017

[BAO Systems]

The latest from BAO Systems

BAO Systems Newsletter
View email in browser 
(http://mailchi.mp/dc6ff9eb74d9/bao-systems-newsletter-november-2017?e=4aa0044015)


** November 2017 Newsletter



** Upcoming events



** DHIS 2 Symposium



** March 22-23, 2018

https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=acf719a022=4aa0044015
Since 2013, DHIS 2 has become the management information system of choice for 
many international NGOs working across a variety of sectors. The DHIS 2 
symposium brings together experienced DHIS 2 users, technical experts, 
implementers and trainers across the public and NGO sectors in order to share 
best practices and lessons learned in the implementation and use of DHIS 2.

The symposium is the only DHIS 2 US-based event.  It is an opportunity for 
participants to learn about the development roadmap of the software, meet the 
development team and learn about UiO (University of Oslo) initiatives in 
advancing the DHIS 2 learning environment. The event will showcase use cases 
that have adopted DHIS 2 in creative ways to solve data management challenges.

Please contact nlan...@baosystems.com (mailto:nlan...@baosystems.com) for info 
on sponsorship and marketing opportunities.
Register 
(https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=5e1ca41352=4aa0044015)


** DHIS 2 Configuration+ Training



** March 20-21, 2018

https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=53a8d67c74=4aa0044015
The pre-symposium training will focus on simplified approaches and tools that 
can be used to set up projects in DHIS 2. Trainees will also be introduced to 
different data exchange solutions and processes between DHIS 2 instances as 
well as migration of legacy data from other systems.

To get the most out of this course, some prior exposure to DHIS 2 is required. 
However, facilitators will go over the basics and main building blocks of the 
system. At the end of this training, participants will have hands-on experience 
of front-end configuration, importing of configurations as well as integration 
and data migration.
Register 
(https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=840aedf680=4aa0044015)


** DHIS 2 Fundamentals Training



** January 9-11, 2018

https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=2bdd2a7949=4aa0044015
The DHIS 2 Fundamentals Training is designed to provide an overview of the DHIS 
2 platform to those who have little or no exposure to the software. The 3-day 
orientation training will cover the basics of use and features of DHIS 2. It 
will be particularly useful for individuals hoping to evaluate the 
appropriateness of DHIS 2 for their organization or use case. Exercises will be 
included throughout the course.

Day 1:
* Overview of the evolution of the software from a District Health Information 
Software to an Enterprise Platform used by international NGOs across multiple 
sectors.
* Establish an understanding of the fundamental building blocks of DHIS 2
* Learn how projects are conceptualized and configured

Day 2:
* Setup metadata object such as organizational hierarchy, data elements, users, 
roles
* Create datasets

Day 3:
* Overview of the analytic and reporting features
* Create graphs, pivot tables, maps
* Create role-based user dashboard with favorites
* Learn about options for integration and data exchange with other systems

The training sessions will be interactive and structured around hands-on 
examples where participants can navigate and explore the software.
Register 
(https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=7f5a1b5118=4aa0044015)


** DHIS 2 Video Archive



** DHIS 2.27 New Features:

Follow along as Tim Harding provides a visual demonstration of the recently 
added features to DHIS 2.27, including the use of Tables, Charts, and 
Indicators.
https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=bb16d097ac=4aa0044015


** DHIS 2.25 Features Overview

This detailed instructional video provides you with all the information you 
need to build a solid foundation for working with DHIS 2.25.
https://baosystems.us14.list-manage.com/track/click?u=38f9f36c957d459edd112cca2=46205ed719=4aa0044015

Re: [Dhis2-users] [Dhis2-devs] Populating data from Excel to DHIS2 Data Entry Web Form with Internet Explorer

[Damasceno Lopes]

Hi Knut,

I'm not using HTTP request to post the data to DHIS2, Im just filling DHIS2
Web Data Entry Form Automatically with MS Excel data. We choose this Option
to fill Large Forms so the mappings will secure no error on data entering.

Check a sample on the video attached.

Thanks

2017-10-26 17:12 GMT+02:00 Knut Staring :

> Given the widespread knowledge of VBA coupled with the huge trove of
> legacy data in Excel and the continued use of Excel for offline data
> collection, it could be nice to add an appendix to the documentation with
> code snippets to import data directly from Excel to the API, in addition to
> the R documentation (munging?).
>
> Perhaps it is something you could be interesting in developing and
> sharing, Damasceno?
>
> Cheers,
> Knut
>
> On Thu, Oct 26, 2017 at 4:55 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> You may also want to consider just making the HTTP request, instead of
>> working with the form itself
>>
>> https://support.microsoft.com/en-us/help/301102/how-to-make-
>> a-get-request-by-using-visual-basic--net-or-visual-basic-2
>>
>> The DHIS2 dataValue API is documented in here
>> 
>> in "Section 1.19.7. Sending, reading and deleting individual data values"
>>
>> Regards,
>> Jason
>>
>>
>> On Thu, Oct 26, 2017 at 4:18 PM, Damasceno Lopes <
>> damascenolop...@gmail.com> wrote:
>>
>>> Hi!
>>>
>>>
>>>
>>> I’m trying to populate data from Excel to  DHIS2 Data Entry Web Form
>>> using VBA code in Excel with Internet Explorer, the data goes to form but
>>> not persisted to database. Anyone already try to do that?
>>>
>>>
>>>
>>> The VBA code, tested to fill form in the demo instance:
>>>
>>>
>>>
>>> 'Before run this Macro make sure to login into dhis2-demo using Internet
>>> Explorer
>>>
>>> Sub FillInternetForm()
>>>
>>> Dim IE As Object
>>>
>>>
>>>
>>> Set IE = CreateObject("InternetExplorer.Application")
>>>
>>>
>>>
>>> IE.Navigate "https://play.dhis2.org/demo/dhis-web-dataentry/index.action
>>> "
>>>
>>> IE.Visible = True
>>>
>>>
>>>
>>> While IE.busy
>>>
>>> DoEvents 'wait until IE is done loading page.
>>>
>>> Wend
>>>
>>>
>>>
>>> 'You have 30 seconds to choose Orgunit, form and period
>>>
>>> 'Eg. Sierra Leone, Emergency Response, Result
>>>
>>> Application.Wait Now + TimeValue("00:00:30")
>>>
>>>
>>>
>>> 'Populating Data to two first fields
>>>
>>> IE.document.getElementById("KFnFpbqDqji-bRowv6yZOF2-val").Focus
>>>
>>> IE.document.getElementById("KFnFpbqDqji-bRowv6yZOF2-val").Value = "20"
>>>
>>> Application.Wait Now + TimeValue("00:00:02")
>>>
>>> IE.document.getElementById("zFFb3bar4Ct-bRowv6yZOF2-val").Focus
>>>
>>> IE.document.getElementById("zFFb3bar4Ct-bRowv6yZOF2-val").Value = "30"
>>>
>>>
>>>
>>> End Sub
>>>
>>>
>>>
>>> The result:
>>>
>>>
>>>
>>>
>>>
>>> The Data goes to the field but not persisted, the field don’t change
>>> color.
>>>
>>> I appreciate your help if you can provide.
>>>
>>>
>>>
>>> Thank you
>>>
>>> *Damasceno Lopes,  MSc*
>>>
>>> *Health Information System Officer*
>>>
>>> Friends in Global Health, Mozambique
>>>
>>> *+258844626770 <+258%2084%20462%206770>*  | *+258829502145
>>> *
>>>
>>> [image: FGH]
>>>
>>>
>>>
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522 <+47%20918%2080%20522>
> Skype: knutstar
> http://dhis2.org
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Mobile Device Management - systems and experiences

[goncalo . castro]

Dear DHIS2 community

I was wondering if any of you has experience to share on Mobile Device 
Management  in low and middle income settings... 

As part of a large scale Android deployment we are studying alternatives 
on which systems and approaches to follow.

Did you use an cloud-based solution? On premises? Open-source?

Thank you

Gonçalo 


Gonçalo Castro 
Health Informatics Specialist
Swiss Centre for International Health
Tel:  +41 61 284 8357
Skype: goncalo.castro
goncalo.cas...@swisstph.ch

Swiss Tropical and Public Health Institute
Socinstrasse 57, P.O. Box 
4002 Basel, Switzerland
www.swisstph.ch



--
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
If you have received this email in error, please notify us immediately by 
reply e-mail and delete this message from your system.
--___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Powerpoint

[Seid Hussein]

Hi Adam,

You can use this presentation I prepared a while back. Please remove the
logo of the ministry and make appropriate changes as necessary - especially
the Month names and Facility levels are adapted for Ethiopia.


Seid,

On Thu, Sep 21, 2017 at 1:24 AM, Adam Preston  wrote:

> Hello,
>
> Does someone have an introductory powerpoint presentation on DHIS2 I can
> use?
>
> Thanks
>
> Sent from Outlook 
>
> ___
> Mailing list: https://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] Job opening: full time eHealth Program Manager based in Brussels

[Pierre-Louis (Pilou) Mercereau]

Hello,

Médecins Sans Frontières Belgium is looking for an eHealth Program Manager 
based in Brussels. He of she is part of the eHealth Unit of MSF Belgium. 
Fluency in English is required as well as the willingness to travel abroad. 
French is an asset.

https://msf-azg.be/fr/job/ehealth-program-manager-m-f

Don't hesitate to share the vacancy with your network.

Best,

--
Pierre-Louis Mercereau
eHealth Team Leader
Médecins Sans Frontières - Belgium
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp