Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-06 Thread Sam Kasozi
Hi Jason,

You can create the SQLview through the data administration module. However,
when browsing the WebAPI, it does not appear among the listed resources.

I created a empty databases and tried with one of the latest war files,
however it was not appearing either.



Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: sam.kasoziug


On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering  wrote:

> Hi Sam,
> Do you mean that you do not see any views in an empty database, or that
> you are unable to access the "SQL View" functionality through the "Data
> administration" dialog?
>
> Regards,
> Jason
>
>
>
> On Sun, Sep 7, 2014 at 8:14 AM, Sam Kasozi  wrote:
>
>> Hi all, I see the SQLview resource on the demo server, however it does
>> seem to appear on any other instances; including an empty database running 
>> 2.16
>> (16404)
>>
>> regards,
>>
>> Sam Kasozi
>> Information Systems Consultant
>> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
>> +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype:
>> sam.kasoziug
>>
>> ___
>> 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] WebAPI resource - SQLview missing

2014-09-06 Thread Jason Pickering
Hi Sam,
Do you mean that you do not see any views in an empty database, or that you
are unable to access the "SQL View" functionality through the "Data
administration" dialog?

Regards,
Jason



On Sun, Sep 7, 2014 at 8:14 AM, Sam Kasozi  wrote:

> Hi all, I see the SQLview resource on the demo server, however it does
> seem to appear on any other instances; including an empty database running 
> 2.16
> (16404)
>
> regards,
>
> Sam Kasozi
> Information Systems Consultant
> HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
> +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype:
> sam.kasoziug
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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


[Dhis2-users] WebAPI resource - SQLview missing

2014-09-06 Thread Sam Kasozi
Hi all, I see the SQLview resource on the demo server, however it does seem
to appear on any other instances; including an empty database running 2.16 (
16404)

regards,

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: sam.kasoziug
___
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] DHIS2 - Averaging over orgunits

2014-09-06 Thread Rodolfo Melia
Hi - i just want to add support to the importance of splitting the aggregator 
operator across time and org units. I'm planning around its availability for 
2.17

Rodolfo Meliá


> On 5 Sep 2014, at 17:26, Robin Martens  wrote:
> 
> Hi Lars,
>  
> Thank you. I thought so but couldn't find the reference.
>  
> In the blueprint it is assigned to release 2.17, is this still being 
> maintained?
>  
> Regards,
>  
> Robin
>  
> From: Lars Helge Øverland [mailto:larshe...@gmail.com] 
> Sent: 05 September 2014 18:24
> To: Robin Martens
> Cc: dhis2-users; dhis2-d...@lists.launchpad.net
> Subject: Re: DHIS2 - Averaging over orgunits
>  
> Hi Robin,
>  
> I get your point. This has actually been raised before and we plan to support 
> individual aggregation operators for the org unit and time dimensions. 
> Blueprint here:
>  
> https://blueprints.launchpad.net/dhis2/+spec/orgunit-hierarchy-aggregation-operator
>  
> regards,
> 
> Lars
>  
>  
>  
>  
>  
> 
> On Thu, Sep 4, 2014 at 12:49 PM, Robin Martens  wrote:
> Hi there,
>  
> As per the manual, the "average" option when defining data elements 
> aggregates by average over periods but sum over orgunits. This limits 
> severely the reporting possibilities, for instance when calculating the 
> average person age over multiple districts but I can think of many other 
> examples (prices, age, education grades,...). Is there any way to configure 
> DHIS2 to average over orgunits?
>  
> Thank you,
>  
> Robin
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Retrieve Indicator values through WEB API

2014-09-06 Thread Lars Helge Øverland
Hello Morina,

a good way of learning how the analytics web api works is to use the pivot
table and play around with indicator data there. When you have created a
pivot view of the indicators you want you can click download > plan data
source - JSON. From this you can study the URL in your browser in order to
understand the analytics URL syntax.

Let us know how it goes.

regards,

Lars





On Sat, Sep 6, 2014 at 9:47 AM, Morina Matasi 
wrote:

> I want to retrieve indicator values through WEB API. Can somebody help,
> the manual is not very clear (have tried examples in vain) on how to
> retrieve data from indicators, or I am missing something.
>
> Regards,
>
> Morina
>
>
> ___
> 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] Retrieve Indicator values through WEB API

2014-09-06 Thread Jan Henrik Øverland
https://www.dhis2.org/doc/snapshot/en/user/html/ch32s21.html

Example:

api/analytics?dimension=dx:&dimension=pe:2013&dimension=ou:



On Sat, Sep 6, 2014 at 3:49 PM, Knut Staring  wrote:

> "have tried examples in vain" is not very informative.
>
> Which examples, what results?
>
>
> On Sat, Sep 6, 2014 at 8:17 PM, Morina Matasi 
> wrote:
>
>> I want to retrieve indicator values through WEB API. Can somebody help,
>> the manual is not very clear (have tried examples in vain) on how to
>> retrieve data from indicators, or I am missing something.
>>
>> Regards,
>>
>> Morina
>>
>>
>> ___
>> 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
> +4791880522
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
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] Retrieve Indicator values through WEB API

2014-09-06 Thread Knut Staring
"have tried examples in vain" is not very informative.

Which examples, what results?


On Sat, Sep 6, 2014 at 8:17 PM, Morina Matasi 
wrote:

> I want to retrieve indicator values through WEB API. Can somebody help,
> the manual is not very clear (have tried examples in vain) on how to
> retrieve data from indicators, or I am missing something.
>
> Regards,
>
> Morina
>
>
> ___
> 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
+4791880522
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


[Dhis2-users] Retrieve Indicator values through WEB API

2014-09-06 Thread Morina Matasi
I want to retrieve indicator values through WEB API. Can somebody help, the
manual is not very clear (have tried examples in vain) on how to retrieve
data from indicators, or I am missing something.

Regards,

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