[Dhis2-users] Problem with the d2:condition function in program operator

[Martin Van Aken]

Hello,
I'm trying to create a program indicator which would evaluate if a ratio is
equal higher than 80 and return 1 or 0 if not the case.

This is what I have in the expression:

d2:condition('((#{tbLC6IHktf0.CpOPiHrFG8C} * 100) /
#{tbLC6IHktf0.spWKINz7xwF}) >= 80', 100, 0)

The program indicator show the expression as valid, but when I try to use
it in a event report, I get this error:

"Illegal arguments, expected 3 arguments: condition, true-value,
false-value."

I tested the ratio separately and it works.

Any one have any insight of what could be wrong there? I could not find a
lot of public examples using d2:condition so I may have done a basic
mistake here.

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] Dataset Custom Forms (CSS & JS)

[Jason Pickering]

Did you have a look at our developer documentation on the use of custom
CSS/JS?

https://docs.dhis2.org/master/en/developer/html/webapi_ui_customization.html

This should also work for inline JS in the form.







On Wed, Feb 7, 2018 at 6:38 AM, Makhate Makhate 
wrote:

> Hi Diao,
>
> Thanks for helping out.
>
> What do you mean when you say "*it maybe possible to use files*" what do
> you mean by files.
>
> The only trick that I could come up with is doing it like this but it
> doesn't quite work:
>
> 
>   /*
>  CSS code here
>   */
> 
>
> 
>
> 
>
> Well, doing it like this, when i hit Preview i can see basic interactivity
> but when i load the actuall dataset, it doesn't work.
>
> Does anyone know exactly where to put JS and CSS code.
>
> Kind regards,
> Makhate,
> ICAP Lesotho
>
> On Tue, Feb 6, 2018 at 5:54 PM, Mamadou Diao Diallo <
> diao_dia...@gn.jsi.com> wrote:
>
>> Hi Makhate,
>>
>> It maybe possible to use files but I used to paste Javascript code in the
>> Source window at the custom form editor, following this link
>> https://docs.dhis2.org/master/en/user/html/database_design.html#d0e36608
>> see the section *30.5.3.1.2. Custom Forms.*
>>
>> Best
>>
>> *Diao*
>>
>> 30.5.3.1.2. Custom Forms
>>
>> On Tue, Feb 6, 2018 at 2:30 PM, Makhate Makhate > > wrote:
>>
>>> ​Hello Communit​y,
>>>
>>> I am customizing the UI form of our datasets here. We need help on where
>>> to put CSS and Javascript files.
>>>
>>> Kind regards,
>>> Makhate Makhate
>>> ICAP, Lesotho
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
>> Health Information Software )*
>>
>>
>> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
>> *Phone : 623909413 | 662256106*
>> *Skype : diawwdiallo*
>> www.jsi.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
>
>


-- 
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] Dataset Custom Forms (CSS & JS)

[Makhate Makhate]

Hi Diao,

Thanks for helping out.

What do you mean when you say "*it maybe possible to use files*" what do
you mean by files.

The only trick that I could come up with is doing it like this but it
doesn't quite work:


  /*
 CSS code here
  */



   


Well, doing it like this, when i hit Preview i can see basic interactivity
but when i load the actuall dataset, it doesn't work.

Does anyone know exactly where to put JS and CSS code.

Kind regards,
Makhate,
ICAP Lesotho

On Tue, Feb 6, 2018 at 5:54 PM, Mamadou Diao Diallo 
wrote:

> Hi Makhate,
>
> It maybe possible to use files but I used to paste Javascript code in the
> Source window at the custom form editor, following this link
> https://docs.dhis2.org/master/en/user/html/database_design.html#d0e36608
> see the section *30.5.3.1.2. Custom Forms.*
>
> Best
>
> *Diao*
>
> 30.5.3.1.2. Custom Forms
>
> On Tue, Feb 6, 2018 at 2:30 PM, Makhate Makhate 
> wrote:
>
>> ​Hello Communit​y,
>>
>> I am customizing the UI form of our datasets here. We need help on where
>> to put CSS and Javascript files.
>>
>> Kind regards,
>> Makhate Makhate
>> ICAP, Lesotho
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> *DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
> Health Information Software )*
>
>
> *Projet de Renforcement du Système d'Information Sanitaire en Guinée*
> *Phone : 623909413 | 662256106*
> *Skype : diawwdiallo*
> www.jsi.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] FW: Access Tracker capture program stage data through API

[Abyot Asalefew Gizaw]

May be complaining about program stage?

---

Thank you,
Abyot.
(sent from mobile)

On Feb 6, 2018 17:21, "Knut Staring"  wrote:

> Hi Abyot,
>
> I am probably just stupid, but why is it complaining about a different
> program (ur1Edk5Oe2n) than the one requested in the URL (eBAyeGv0exc) ?
>
> And even after sharing both programs with the administrator group which
> admin is a member of, I still get the same?
>
> Knut
>
> On Tue, Feb 6, 2018 at 5:00 PM, Abyot Asalefew Gizaw 
> wrote:
> >
> > That is because if the new sharing setting. You need to go and configure
> data read and write sharing settings...
> >
> > The same url should work in 2.28 and lower versions.
> >
> >
> > On Tue, Feb 6, 2018, 16:55 Georgi Chakarov 
> wrote:
> >>
> >> Yes, and I am trying to get all data for all tracked entity instances,
> not for a specific one. Any idea?
> >>
> >>
> >>
> >> From: Knut Staring [mailto:knu...@gmail.com]
> >> Sent: Tuesday, February 6, 2018 5:43 PM
> >>
> >>
> >> To: Georgi Chakarov 
> >> Cc: DHIS 2 Developers list ;
> dhis2-users@lists.launchpad.net; Michal Debski  logicaloutcomes.net>; Wojtek Bak 
> >> Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
> >>
> >>
> >>
> >> I see. I am actually seeing a restriction when trying the example at
> the bottom of the page in the manual:
> >>
> >>
> >>
> >> https://docs.dhis2.org/master/en/developer/html/webapi_
> events.html#webapi_querying_reading_events
> >>
> >>
> >>
> >> https://play.dhis2.org/dev/api/26/events.json?orgUnit=
> DiszpKrYNg8=eBAyeGv0exc=
> gfVxE3ALA9m=2014-01-01=2014-12-31
> >>
> >> {"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User
> has no read access to program: ur1Edk5Oe2n]"}
> >>
> >> This is of course not the response you are getting.
> >>
> >> Knut
> >>
> >>
> >>
> >>
> >>
> >> Virus-free. www.avg.com
> >>
> >>
> >>
> >> On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
> >>
> >> Hi Knut,
> >>
> >>
> >>
> >> I am using a super user account and we don’t have data shared among
> users. Maybe the problem is related to the fact that Tracker data does not
> get exported in any format from the Import/Export app either. Aggregate
> data does, but tracker or event data does not.
> >>
> >>
> >>
> >> Georgi
> >>
> >> From: Knut Staring [mailto:knu...@gmail.com]
> >> Sent: Tuesday, February 6, 2018 3:42 PM
> >> To: Georgi Chakarov 
> >> Cc: DHIS 2 Developers list ;
> dhis2-users@lists.launchpad.net; Michal Debski  logicaloutcomes.net>; Wojtek Bak 
> >> Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
> >>
> >>
> >>
> >> Just a thought - is the user you are using for the API member of the
> user group for which this data has been shared?
> >>
> >>
> >>
> >> Knut
> >>
> >>
> >>
> >> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
> >>
> >> Hi all,
> >>
> >>
> >>
> >> Any thoughts on the below question? Your input is highly needed and
> appreciated!
> >>
> >>
> >>
> >> Regards,
> >>
> >> Georgi
> >>
> >>
> >>
> >> From: Georgi Chakarov
> >> Sent: Monday, February 5, 2018 6:20 PM
> >> To: 'DHIS 2 Developers list' ;
> dhis2-users@lists.launchpad.net
> >> Cc: Michal Debski ; Wojtek Bak <
> woj...@logicaloutcomes.net>
> >> Subject: Access Tracker capture program stage data through API
> >>
> >>
> >>
> >> 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!
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Georgi
> >>
> >>
> >> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x
> 104 <+1%20647-478-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
> >>
> >> Department of Information, Evidence and Research
> >> 

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Knut Staring]

Hi Abyot,

I am probably just stupid, but why is it complaining about a different
program (ur1Edk5Oe2n) than the one requested in the URL (eBAyeGv0exc) ?

And even after sharing both programs with the administrator group which
admin is a member of, I still get the same?

Knut

On Tue, Feb 6, 2018 at 5:00 PM, Abyot Asalefew Gizaw 
wrote:
>
> That is because if the new sharing setting. You need to go and configure
data read and write sharing settings...
>
> The same url should work in 2.28 and lower versions.
>
>
> On Tue, Feb 6, 2018, 16:55 Georgi Chakarov 
wrote:
>>
>> Yes, and I am trying to get all data for all tracked entity instances,
not for a specific one. Any idea?
>>
>>
>>
>> From: Knut Staring [mailto:knu...@gmail.com]
>> Sent: Tuesday, February 6, 2018 5:43 PM
>>
>>
>> To: Georgi Chakarov 
>> Cc: DHIS 2 Developers list ;
dhis2-users@lists.launchpad.net; Michal Debski <
michal.deb...@logicaloutcomes.net>; Wojtek Bak 
>> Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data
through API
>>
>>
>>
>> I see. I am actually seeing a restriction when trying the example at the
bottom of the page in the manual:
>>
>>
>>
>>
https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events
>>
>>
>>
>>
https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc=gfVxE3ALA9m=2014-01-01=2014-12-31
>>
>>
{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User
has no read access to program: ur1Edk5Oe2n]"}
>>
>> This is of course not the response you are getting.
>>
>> Knut
>>
>>
>>
>>
>>
>> Virus-free. www.avg.com
>>
>>
>>
>> On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:
>>
>> Hi Knut,
>>
>>
>>
>> I am using a super user account and we don’t have data shared among
users. Maybe the problem is related to the fact that Tracker data does not
get exported in any format from the Import/Export app either. Aggregate
data does, but tracker or event data does not.
>>
>>
>>
>> Georgi
>>
>> From: Knut Staring [mailto:knu...@gmail.com]
>> Sent: Tuesday, February 6, 2018 3:42 PM
>> To: Georgi Chakarov 
>> Cc: DHIS 2 Developers list ;
dhis2-users@lists.launchpad.net; Michal Debski <
michal.deb...@logicaloutcomes.net>; Wojtek Bak 
>> Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data
through API
>>
>>
>>
>> Just a thought - is the user you are using for the API member of the
user group for which this data has been shared?
>>
>>
>>
>> Knut
>>
>>
>>
>> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
geo...@logicaloutcomes.net> wrote:
>>
>> Hi all,
>>
>>
>>
>> Any thoughts on the below question? Your input is highly needed and
appreciated!
>>
>>
>>
>> Regards,
>>
>> Georgi
>>
>>
>>
>> From: Georgi Chakarov
>> Sent: Monday, February 5, 2018 6:20 PM
>> To: 'DHIS 2 Developers list' ;
dhis2-users@lists.launchpad.net
>> Cc: Michal Debski ; Wojtek Bak <
woj...@logicaloutcomes.net>
>> Subject: Access Tracker capture program stage data through API
>>
>>
>>
>> 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!
>>
>>
>>
>>
>>
>>
>>
>> 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
>>
>>
>>
>>
>>
>> --
>>
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> Skype: knutstar
>>
>>
>>
>>
>> --
>>
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 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   : 

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Georgi Chakarov]

Yes, and I am trying to get all data for all tracked entity instances, not for 
a specific one. Any idea?

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Tuesday, February 6, 2018 5:43 PM
To: Georgi Chakarov 
Cc: DHIS 2 Developers list ; 
dhis2-users@lists.launchpad.net; Michal Debski 
; Wojtek Bak 
Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data 
through API

I see. I am actually seeing a restriction when trying the example at the bottom 
of the page in the manual:

https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events

https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc=gfVxE3ALA9m=2014-01-01=2014-12-31

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User 
has no read access to program: ur1Edk5Oe2n]"}

This is of course not the response you are getting.

Knut



[Image removed by 
sender.]

Virus-free. 
www.avg.com


On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov 
> wrote:
Hi Knut,

I am using a super user account and we don’t have data shared among users. 
Maybe the problem is related to the fact that Tracker data does not get 
exported in any format from the Import/Export app either. Aggregate data does, 
but tracker or event data does not.

Georgi
From: Knut Staring [mailto:knu...@gmail.com]
Sent: Tuesday, February 6, 2018 3:42 PM
To: Georgi Chakarov 
>
Cc: DHIS 2 Developers list 
>; 
dhis2-users@lists.launchpad.net; Michal 
Debski 
>; 
Wojtek Bak >
Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data 
through API

Just a thought - is the user you are using for the API member of the user group 
for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov 
> wrote:
Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,
Georgi

From: Georgi Chakarov
Sent: Monday, February 5, 2018 6:20 PM
To: 'DHIS 2 Developers list' 
>; 
dhis2-users@lists.launchpad.net
Cc: Michal Debski 
>; 
Wojtek Bak >
Subject: Access Tracker capture program stage data through API

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:image003.jpg@01D39F72.5F694920]

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



--
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 
2931 Mob2: +47 9188 0522
Skype: knutstar



--
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 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

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Abyot Asalefew Gizaw]

That is because if the new sharing setting. You need to go and configure
data read and write sharing settings...

The same url should work in 2.28 and lower versions.

On Tue, Feb 6, 2018, 16:55 Georgi Chakarov 
wrote:

> Yes, and I am trying to get all data for all tracked entity instances, not
> for a specific one. Any idea?
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Tuesday, February 6, 2018 5:43 PM
>
>
> *To:* Georgi Chakarov 
> *Cc:* DHIS 2 Developers list ;
> dhis2-users@lists.launchpad.net; Michal Debski <
> michal.deb...@logicaloutcomes.net>; Wojtek Bak  >
> *Subject:* Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
>
>
>
> I see. I am actually seeing a restriction when trying the example at the
> bottom of the page in the manual:
>
>
>
>
> https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events
>
>
>
>
> https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc=gfVxE3ALA9m=2014-01-01=2014-12-31
>
> {"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User
>  has no read access to program: ur1Edk5Oe2n]"}
>
> This is of course not the response you are getting.
>
> Knut
>
>
>
>
>
> [image: Image removed by sender.]
> 
>
> Virus-free. www.avg.com
> 
>
>
>
> On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hi Knut,
>
>
>
> I am using a super user account and we don’t have data shared among users.
> Maybe the problem is related to the fact that Tracker data does not get
> exported in any format from the Import/Export app either. Aggregate data
> does, but tracker or event data does not.
>
>
>
> Georgi
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Tuesday, February 6, 2018 3:42 PM
> *To:* Georgi Chakarov 
> *Cc:* DHIS 2 Developers list ;
> dhis2-users@lists.launchpad.net; Michal Debski <
> michal.deb...@logicaloutcomes.net>; Wojtek Bak  >
> *Subject:* Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
>
>
>
> Just a thought - is the user you are using for the API member of the user
> group for which this data has been shared?
>
>
>
> Knut
>
>
>
> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hi all,
>
>
>
> Any thoughts on the below question? Your input is highly needed and
> appreciated!
>
>
>
> Regards,
>
> Georgi
>
>
>
> *From:* Georgi Chakarov
> *Sent:* Monday, February 5, 2018 6:20 PM
> *To:* 'DHIS 2 Developers list' ;
> dhis2-users@lists.launchpad.net
> *Cc:* Michal Debski ; Wojtek Bak <
> woj...@logicaloutcomes.net>
> *Subject:* Access Tracker capture program stage data through API
>
>
>
> 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!
>
>
>
>
>
>
>
> 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
>
> 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
>
>
>
>
> --
>
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 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   : 

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Knut Staring]

I see. I am actually seeing a restriction when trying the example at the
bottom of the page in the manual:

https://docs.dhis2.org/master/en/developer/html/webapi_events.html#webapi_querying_reading_events

https://play.dhis2.org/dev/api/26/events.json?orgUnit=DiszpKrYNg8=eBAyeGv0exc=gfVxE3ALA9m=2014-01-01=2014-12-31

{"httpStatus":"Conflict","httpStatusCode":409,"status":"ERROR","message":"[User
has no read access to program: ur1Edk5Oe2n]"}

This is of course not the response you are getting.

Knut




Virus-free.
www.avg.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov 
wrote:

> Hi Knut,
>
>
>
> I am using a super user account and we don’t have data shared among users.
> Maybe the problem is related to the fact that Tracker data does not get
> exported in any format from the Import/Export app either. Aggregate data
> does, but tracker or event data does not.
>
>
>
> Georgi
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Tuesday, February 6, 2018 3:42 PM
> *To:* Georgi Chakarov 
> *Cc:* DHIS 2 Developers list ;
> dhis2-users@lists.launchpad.net; Michal Debski  logicaloutcomes.net>; Wojtek Bak 
> *Subject:* Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
>
>
>
> Just a thought - is the user you are using for the API member of the user
> group for which this data has been shared?
>
>
>
> Knut
>
>
>
> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hi all,
>
>
>
> Any thoughts on the below question? Your input is highly needed and
> appreciated!
>
>
>
> Regards,
>
> Georgi
>
>
>
> *From:* Georgi Chakarov
> *Sent:* Monday, February 5, 2018 6:20 PM
> *To:* 'DHIS 2 Developers list' ;
> dhis2-users@lists.launchpad.net
> *Cc:* Michal Debski ; Wojtek Bak <
> woj...@logicaloutcomes.net>
> *Subject:* Access Tracker capture program stage data through API
>
>
>
> 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!
>
>
>
>
>
>
>
> 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
>
> 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
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 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

Re: [Dhis2-users] Dataset Custom Forms (CSS & JS)

[Mamadou Diao Diallo]

Hi Makhate,

It maybe possible to use files but I used to paste Javascript code in the
Source window at the custom form editor, following this link
https://docs.dhis2.org/master/en/user/html/database_design.html#d0e36608
see the section *30.5.3.1.2. Custom Forms.*

Best

*Diao*

30.5.3.1.2. Custom Forms

On Tue, Feb 6, 2018 at 2:30 PM, Makhate Makhate 
wrote:

> ​Hello Communit​y,
>
> I am customizing the UI form of our datasets here. We need help on where
> to put CSS and Javascript files.
>
> Kind regards,
> Makhate Makhate
> ICAP, Lesotho
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
*DIALLO Mamadou Diao Conseiller IT, Specialiste de DHIS 2 **( District
Health Information Software )*


*Projet de Renforcement du Système d'Information Sanitaire en Guinée*
*Phone : 623909413 | 662256106*
*Skype : diawwdiallo*
www.jsi.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] FW: Access Tracker capture program stage data through API

[Abyot Asalefew Gizaw]

Hi,

We have some guide on how to read events through api. See the documentation
here.

https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_querying_reading_events

and an example

https://play.dhis2.org/dev/api/28/events.json?orgUnit=DiszpKrYNg8=Zj7UnCAulEk=50=1=true

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

On Tue, Feb 6, 2018 at 4:11 PM, Georgi Chakarov 
wrote:

> Hi Knut,
>
>
>
> I am using a super user account and we don’t have data shared among users.
> Maybe the problem is related to the fact that Tracker data does not get
> exported in any format from the Import/Export app either. Aggregate data
> does, but tracker or event data does not.
>
>
>
> Georgi
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Tuesday, February 6, 2018 3:42 PM
> *To:* Georgi Chakarov 
> *Cc:* DHIS 2 Developers list ;
> dhis2-users@lists.launchpad.net; Michal Debski  logicaloutcomes.net>; Wojtek Bak 
> *Subject:* Re: [Dhis2-users] FW: Access Tracker capture program stage
> data through API
>
>
>
> Just a thought - is the user you are using for the API member of the user
> group for which this data has been shared?
>
>
>
> Knut
>
>
>
> On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov <
> geo...@logicaloutcomes.net> wrote:
>
> Hi all,
>
>
>
> Any thoughts on the below question? Your input is highly needed and
> appreciated!
>
>
>
> Regards,
>
> Georgi
>
>
>
> *From:* Georgi Chakarov
> *Sent:* Monday, February 5, 2018 6:20 PM
> *To:* 'DHIS 2 Developers list' ;
> dhis2-users@lists.launchpad.net
> *Cc:* Michal Debski ; Wojtek Bak <
> woj...@logicaloutcomes.net>
> *Subject:* Access Tracker capture program stage data through API
>
>
>
> 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!
>
>
>
>
>
>
>
> 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
>
> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Georgi Chakarov]

Hi Knut,

I am using a super user account and we don’t have data shared among users. 
Maybe the problem is related to the fact that Tracker data does not get 
exported in any format from the Import/Export app either. Aggregate data does, 
but tracker or event data does not.

Georgi
From: Knut Staring [mailto:knu...@gmail.com]
Sent: Tuesday, February 6, 2018 3:42 PM
To: Georgi Chakarov 
Cc: DHIS 2 Developers list ; 
dhis2-users@lists.launchpad.net; Michal Debski 
; Wojtek Bak 
Subject: Re: [Dhis2-users] FW: Access Tracker capture program stage data 
through API

Just a thought - is the user you are using for the API member of the user group 
for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov 
> wrote:
Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,
Georgi

From: Georgi Chakarov
Sent: Monday, February 5, 2018 6:20 PM
To: 'DHIS 2 Developers list' 
>; 
dhis2-users@lists.launchpad.net
Cc: Michal Debski 
>; 
Wojtek Bak >
Subject: Access Tracker capture program stage data through API

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@01D39F6D.7E1A97C0]

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



--
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 
2931 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

Re: [Dhis2-users] Using program rule expressions in Program indicator expressions

[Bernard Sadaka (IM Advisor)]

I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734)



But still doesn’t explain why I can’t use different expressions in program
indicators :(



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org 





From: Dhis2-users
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On
Behalf Of Bernard Sadaka (IM Advisor)
Sent: Tuesday, February 6, 2018 3:53 PM
To: dhis2-users@lists.launchpad.net; 'DHIS 2 developers'

Subject: [Dhis2-users] Using program rule expressions in Program indicator
expressions



Can anyone tell me why I can’t use program rule expressions in Program
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 +
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib@pu-ami.org 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.pu-ami.org 











Virus-free.
 www.avast.com





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://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] Dataset Custom Forms (CSS & JS)

[Makhate Makhate]

​Hello Communit​y,

I am customizing the UI form of our datasets here. We need help on where to
put CSS and Javascript files.

Kind regards,
Makhate Makhate
ICAP, Lesotho
___
Mailing list: https://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] Using program rule expressions in Program indicator expressions

[Bernard Sadaka (IM Advisor)]

Can anyone tell me why I can’t use program rule expressions in Program
indicator expressions?

Functions like ceil, floor, round and others are very useful.



Also I tried to use the “Decimals in data output” in the program indicator
details, it didn’t work.

Also I tried to simulate the round function using conditional modulo
subtraction/addition (the pivot table keeps trying to load) :

C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 +
d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)



Thank you in advance.

Please advise.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org







---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] FW: Access Tracker capture program stage data through API

[Knut Staring]

Just a thought - is the user you are using for the API member of the user
group for which this data has been shared?

Knut

On Tue, Feb 6, 2018 at 2:38 PM, Georgi Chakarov 
wrote:

> Hi all,
>
>
>
> Any thoughts on the below question? Your input is highly needed and
> appreciated!
>
>
>
> Regards,
>
> Georgi
>
>
>
> *From:* Georgi Chakarov
> *Sent:* Monday, February 5, 2018 6:20 PM
> *To:* 'DHIS 2 Developers list' ;
> dhis2-users@lists.launchpad.net
> *Cc:* Michal Debski ; Wojtek Bak <
> woj...@logicaloutcomes.net>
> *Subject:* Access Tracker capture program stage data through API
>
>
>
> 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!
>
>
>
>
>
>
>
> 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

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

[Dhis2-users] FW: Access Tracker capture program stage data through API

[Georgi Chakarov]

Hi all,

Any thoughts on the below question? Your input is highly needed and appreciated!

Regards,
Georgi

From: Georgi Chakarov
Sent: Monday, February 5, 2018 6:20 PM
To: 'DHIS 2 Developers list' ; 
dhis2-users@lists.launchpad.net
Cc: Michal Debski ; Wojtek Bak 

Subject: Access Tracker capture program stage data through API

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

Re: [Dhis2-users] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

[Stanley Kalyati]

Hi Gerald,

I have run analytics,i have also gone to data admin and also cleared catch
but no results.

Only when i add a category combination to the data set,that is when i am
able to see data when i run pivot or data visualizer.

I cant understand

On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas  wrote:

> Stanley,
> Please run analytics and check your pivot tables again.
>
> On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati 
> wrote:
>
>> Hi All,
>>
>> I posted something similar sometime two weeks ago.
>>
>> I have data elements whose value type is number and aggregation type is
>> Sum.I created a data set and assigned it to the Organisation unit.
>>
>> I captured data and run analytics.When i run the pivot tables,no data
>> values.
>>
>> However,when i add a Category Combination which is an attribute to the
>> data set,enter data and run pivot tables,data is there.
>>
>> I am confused.
>>
>> Anyone with an idea?
>>
>> Thank you
>>
>>
>> ___
>> Mailing list: https://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,
>
> Gerald
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

[gerald thomas]

Stanley,
It simply means your data is based on those category combinations that is
why you are seeing them. Please share a print screen of that data set whose
data elements you pivoting for now.

On Tue, Feb 6, 2018 at 12:33 PM, Stanley Kalyati  wrote:

> Hi Gerald,
>
> I have run analytics,i have also gone to data admin and also cleared catch
> but no results.
>
> Only when i add a category combination to the data set,that is when i am
> able to see data when i run pivot or data visualizer.
>
> I cant understand
>
> On Tue, Feb 6, 2018 at 1:40 PM, gerald thomas 
> wrote:
>
>> Stanley,
>> Please run analytics and check your pivot tables again.
>>
>> On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati 
>> wrote:
>>
>>> Hi All,
>>>
>>> I posted something similar sometime two weeks ago.
>>>
>>> I have data elements whose value type is number and aggregation type is
>>> Sum.I created a data set and assigned it to the Organisation unit.
>>>
>>> I captured data and run analytics.When i run the pivot tables,no data
>>> values.
>>>
>>> However,when i add a Category Combination which is an attribute to the
>>> data set,enter data and run pivot tables,data is there.
>>>
>>> I am confused.
>>>
>>> Anyone with an idea?
>>>
>>> Thank you
>>>
>>>
>>> ___
>>> Mailing list: https://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,
>>
>> Gerald
>>
>
>


-- 
Regards,

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

Re: [Dhis2-users] How to track users activity in Dhis2

[Antonia - Pro]

 Thanks Jason,
I created this JIRA issue to solve problems exactly like this one. Hope it
will be resolved into the next release as declared. It will be very useful.

Best regards,
Antonia


*Eng. Antonia Bezenchek*
CIO - ICT Engineer
*InformaPRO S.r.l.* via Guido Guinizelli, 98/100, Roma 00152, Italy
www.informapro.it - *Follow us on* LinkedIn


2018-02-06 12:00 GMT+01:00 Jason Pickering :

> Hi Jean,
>


2018-02-06 12:00 GMT+01:00 Jason Pickering :

> Hi Jean,
>
> If you have the possibility, using Google Analytics is an option. There
> are some security considerations you may need to take into account however.
>
> At the moment however, this approach is a bit limited, as many apps do not
> use Google Analytics due to this limitation https://jira.dhis2.
> org/browse/DHIS2-1436.
>
> If you are able to create an SQL view through the data administration app,
> you should be able to get some CSV data back which you could work up in
> Excel.
>
> Here is a simple SQL snippet which might help you get started.
>
> SELECT username,eventtype,extract(month from timestamp) as month,count(*)
> from datastatisticsevent where age(now(),timestamp) < '6 months'::interval
> GROUP BY username,eventtype,extract(month from timestamp)
>
> Note, that usernames can be exposed here, so you should be careful who has
> access to this view.
>
> The easiest way is to just use the "Usage analytics app" which will
> provide you basically the same data, but not per user.
>
> Hope this helps.
>
> Best regards,
> Jason
>
>
>
>
> On Tue, Feb 6, 2018 at 11:35 AM, Antonia - Pro 
> wrote:
>
>> You can get a file (xml or json - then convert in Excel if you want) with
>> the user's metadata using the export - there are also the last login time
>> of all users, if this is what you want.
>>
>> Best
>> Antonia
>>
>>
>> 2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi > >:
>>
>>> Hi Bernard
>>> I cannot use sql query in our instance because I don't have access to
>>> the server. And SQL View is  too limited.
>>>
>>> Best
>>>
>>>
>>> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) <
>>> lib@pu-ami.org>:
>>>
 Hello Jean,

 I am pretty sure you can run a query in the DB to do so, not sure the
 graphical interface has this (other than the SQL view to run the queries)

 @Others, please correct me if I am mistaken.

 All the best,

 Bernard



 [image: cid:image002.png@01D36F50.572585A0]

 *Bernard Sadaka*

 *Information Management Advisor*

 Première Urgence - Aide Médicale Internationale

 Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

 Ain el Remmaneh, Beirut, Lebanon

 *E-mail:* lib@pu-ami.org

 *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)

 *Skype:* imapuami

 *Website:* https://www.pu-ami.org





 *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
 pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
 *Sent:* Tuesday, February 6, 2018 11:51 AM
 *To:* DHIS Users 
 *Subject:* [Dhis2-users] How to track users activity in Dhis2



 Hello all,

 Is it possible to know what users are doing in the system.?

 If yes what is the procedure



 Thank you


 
  Virus-free.
 www.avast.com
 
 <#m_3414479469341756019_m_3355446565635688959_m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

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

Re: [Dhis2-users] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

[gerald thomas]

Stanley,
Please run analytics and check your pivot tables again.

On Tue, Feb 6, 2018 at 11:11 AM, Stanley Kalyati  wrote:

> Hi All,
>
> I posted something similar sometime two weeks ago.
>
> I have data elements whose value type is number and aggregation type is
> Sum.I created a data set and assigned it to the Organisation unit.
>
> I captured data and run analytics.When i run the pivot tables,no data
> values.
>
> However,when i add a Category Combination which is an attribute to the
> data set,enter data and run pivot tables,data is there.
>
> I am confused.
>
> Anyone with an idea?
>
> Thank you
>
>
> ___
> Mailing list: https://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,

Gerald
___
Mailing list: https://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] DATA ELEMENTS NOT SHOWING DATA IN PIVOT TABLES

[Stanley Kalyati]

Hi All,

I posted something similar sometime two weeks ago.

I have data elements whose value type is number and aggregation type is
Sum.I created a data set and assigned it to the Organisation unit.

I captured data and run analytics.When i run the pivot tables,no data
values.

However,when i add a Category Combination which is an attribute to the data
set,enter data and run pivot tables,data is there.

I am confused.

Anyone with an idea?

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

Re: [Dhis2-users] How to track users activity in Dhis2

[Jason Pickering]

Hi Jean,

If you have the possibility, using Google Analytics is an option. There are
some security considerations you may need to take into account however.

At the moment however, this approach is a bit limited, as many apps do not
use Google Analytics due to this limitation
https://jira.dhis2.org/browse/DHIS2-1436.

If you are able to create an SQL view through the data administration app,
you should be able to get some CSV data back which you could work up in
Excel.

Here is a simple SQL snippet which might help you get started.

SELECT username,eventtype,extract(month from timestamp) as month,count(*)
from datastatisticsevent where age(now(),timestamp) < '6 months'::interval
GROUP BY username,eventtype,extract(month from timestamp)

Note, that usernames can be exposed here, so you should be careful who has
access to this view.

The easiest way is to just use the "Usage analytics app" which will provide
you basically the same data, but not per user.

Hope this helps.

Best regards,
Jason




On Tue, Feb 6, 2018 at 11:35 AM, Antonia - Pro  wrote:

> You can get a file (xml or json - then convert in Excel if you want) with
> the user's metadata using the export - there are also the last login time
> of all users, if this is what you want.
>
> Best
> Antonia
>
>
> 2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi 
> :
>
>> Hi Bernard
>> I cannot use sql query in our instance because I don't have access to the
>> server. And SQL View is  too limited.
>>
>> Best
>>
>>
>> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) <
>> lib@pu-ami.org>:
>>
>>> Hello Jean,
>>>
>>> I am pretty sure you can run a query in the DB to do so, not sure the
>>> graphical interface has this (other than the SQL view to run the queries)
>>>
>>> @Others, please correct me if I am mistaken.
>>>
>>> All the best,
>>>
>>> Bernard
>>>
>>>
>>>
>>> [image: cid:image002.png@01D36F50.572585A0]
>>>
>>> *Bernard Sadaka*
>>>
>>> *Information Management Advisor*
>>>
>>> Première Urgence - Aide Médicale Internationale
>>>
>>> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>>>
>>> Ain el Remmaneh, Beirut, Lebanon
>>>
>>> *E-mail:* lib@pu-ami.org
>>>
>>> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>>>
>>> *Skype:* imapuami
>>>
>>> *Website:* https://www.pu-ami.org
>>>
>>>
>>>
>>>
>>>
>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
>>> pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
>>> *Sent:* Tuesday, February 6, 2018 11:51 AM
>>> *To:* DHIS Users 
>>> *Subject:* [Dhis2-users] How to track users activity in Dhis2
>>>
>>>
>>>
>>> Hello all,
>>>
>>> Is it possible to know what users are doing in the system.?
>>>
>>> If yes what is the procedure
>>>
>>>
>>>
>>> Thank you
>>>
>>>
>>> 
>>>  Virus-free.
>>> www.avast.com
>>> 
>>> <#m_3355446565635688959_m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>
>>
>>
>> ___
>> Mailing list: https://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
>
>


-- 
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] How to track users activity in Dhis2

[Antonia - Pro]

You can get a file (xml or json - then convert in Excel if you want) with
the user's metadata using the export - there are also the last login time
of all users, if this is what you want.

Best
Antonia


2018-02-06 11:09 GMT+01:00 Jean de Dieu Anoubissi :

> Hi Bernard
> I cannot use sql query in our instance because I don't have access to the
> server. And SQL View is  too limited.
>
> Best
>
>
> 2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor)  >:
>
>> Hello Jean,
>>
>> I am pretty sure you can run a query in the DB to do so, not sure the
>> graphical interface has this (other than the SQL view to run the queries)
>>
>> @Others, please correct me if I am mistaken.
>>
>> All the best,
>>
>> Bernard
>>
>>
>>
>> [image: cid:image002.png@01D36F50.572585A0]
>>
>> *Bernard Sadaka*
>>
>> *Information Management Advisor*
>>
>> Première Urgence - Aide Médicale Internationale
>>
>> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>>
>> Ain el Remmaneh, Beirut, Lebanon
>>
>> *E-mail:* lib@pu-ami.org
>>
>> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>>
>> *Skype:* imapuami
>>
>> *Website:* https://www.pu-ami.org
>>
>>
>>
>>
>>
>> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=
>> pu-ami@lists.launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
>> *Sent:* Tuesday, February 6, 2018 11:51 AM
>> *To:* DHIS Users 
>> *Subject:* [Dhis2-users] How to track users activity in Dhis2
>>
>>
>>
>> Hello all,
>>
>> Is it possible to know what users are doing in the system.?
>>
>> If yes what is the procedure
>>
>>
>>
>> Thank you
>>
>>
>> 
>>  Virus-free.
>> www.avast.com
>> 
>> <#m_5664956289659349146_m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] How to track users activity in Dhis2

[Jean de Dieu Anoubissi]

Hi Bernard
I cannot use sql query in our instance because I don't have access to the
server. And SQL View is  too limited.

Best


2018-02-06 10:54 GMT+01:00 Bernard Sadaka (IM Advisor) :

> Hello Jean,
>
> I am pretty sure you can run a query in the DB to do so, not sure the
> graphical interface has this (other than the SQL view to run the queries)
>
> @Others, please correct me if I am mistaken.
>
> All the best,
>
> Bernard
>
>
>
> [image: cid:image002.png@01D36F50.572585A0]
>
> *Bernard Sadaka*
>
> *Information Management Advisor*
>
> Première Urgence - Aide Médicale Internationale
>
> Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
>
> Ain el Remmaneh, Beirut, Lebanon
>
> *E-mail:* lib@pu-ami.org
>
> *Cell:* +961 71 004 881 <+961%2071%20004%20881> (208)
>
> *Skype:* imapuami
>
> *Website:* https://www.pu-ami.org
>
>
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@lists.
> launchpad.net] *On Behalf Of *Jean de Dieu Anoubissi
> *Sent:* Tuesday, February 6, 2018 11:51 AM
> *To:* DHIS Users 
> *Subject:* [Dhis2-users] How to track users activity in Dhis2
>
>
>
> Hello all,
>
> Is it possible to know what users are doing in the system.?
>
> If yes what is the procedure
>
>
>
> Thank you
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_-5275009958228714629_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] How to track users activity in Dhis2

[Bernard Sadaka (IM Advisor)]

Hello Jean,

I am pretty sure you can run a query in the DB to do so, not sure the graphical 
interface has this (other than the SQL view to run the queries)

@Others, please correct me if I am mistaken.

All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Jean de Dieu Anoubissi
Sent: Tuesday, February 6, 2018 11:51 AM
To: DHIS Users 
Subject: [Dhis2-users] How to track users activity in Dhis2



Hello all,

Is it possible to know what users are doing in the system.?

If yes what is the procedure



Thank you



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://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] How to track users activity in Dhis2

[Jean de Dieu Anoubissi]

Hello all,
Is it possible to know what users are doing in the system.?
If yes what is the procedure

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