[Dhis2-users] Download Program Data API

2017-02-21 Thread Amone Junior. Felimone
Dear all, Im developing an application that get some tracker data from dhis2, im able to get the enrollment data using the api, but i cant find in the API documentation a way to download all data element values of a program (contains only 1 stage) Thanks -- Felimone Amone Junior Data Manager

[Dhis2-users] Support on Tracker program rules

2017-02-21 Thread Absolom MURAMIRA
Dear Community, I am writing program rules in tracker (DHIS 2.25) but quite not sure why there are not working for program attributes. I have tried to follow the user guide but I could probably be missing out on something and someone could please advise me. For example I would like to preven

Re: [Dhis2-users] Download Program Data API

2017-02-21 Thread Abyot Asalefew Gizaw
Hi, Take a look to our developer documentation - especially the events section. https://docs.dhis2.org/master/en/developer/html/dhis2_developer_manual_full.html#webapi_querying_reading_events -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo http://www.dhis2.org On Tue, Feb 21, 2017

Re: [Dhis2-users] Download Program Data API

2017-02-21 Thread Amone Junior. Felimone
Dear Abyot, Thank you very much. On Tue, Feb 21, 2017 at 12:47 PM, Abyot Asalefew Gizaw wrote: > Hi, > > Take a look to our developer documentation - especially the events section. > > https://docs.dhis2.org/master/en/developer/html/dhis2_ > developer_manual_full.html#webapi_querying_reading_ev

[Dhis2-users] Org Units groups/ Sudan DHIS

2017-02-21 Thread seemaa karoum
Dear DHIS community, We have an issue with putting the health facilities into groups, We have a 3 group: Hospitals, Health centres, and health units created in our system but the issue is with the facilities linked to these groups , each time we group the facilities we end up loosing the grouping

Re: [Dhis2-users] FW: My saved favourites not opening

2017-02-21 Thread Knut Staring
Do you see the same in the online demo? On Feb 21, 2017 1:34 PM, "timothy kiyemba" wrote: > I have cleared cache several times. The problem still persists. Im using > DHIS2 2.26 > -- > From: Knut Staring > Sent: ‎21/‎02/‎2017 15:21 > To: Timothy Kiyemba > Subject: R

Re: [Dhis2-users] FW: My saved favourites not opening

2017-02-21 Thread timothy kiyemba
The online demo is working fine -Original Message- From: "Knut Staring" Sent: ‎21/‎02/‎2017 15:36 To: "Timothy Kiyemba" ; "dhis2-users@lists.launchpad.net" Subject: RE: FW: [Dhis2-users] My saved favourites not opening Do you see the same in the online demo? On Feb 21, 2017 1:34 PM,

[Dhis2-users] Hiding Unapproved data in analytics

2017-02-21 Thread Ibrahim Bayoh
Hi All, I have successfully setup data approval and workflow. Users can now approve at facility level. But i cant seem to get "*Hide unapproved data in analytics*" to work. From reading the docs, This option allow unapproved data to be hidden from higher level users until they are approve. Am curre

Re: [Dhis2-users] Org Units groups/ Sudan DHIS

2017-02-21 Thread Knut Staring
What version of Dhis2? On Feb 21, 2017 12:58 PM, "seemaa karoum" wrote: > Dear DHIS community, > > We have an issue with putting the health facilities into groups, We have a > 3 group: Hospitals, Health centres, and health units created in our system > but the issue is with the facilities linked

Re: [Dhis2-users] Org Units groups/ Sudan DHIS

2017-02-21 Thread seemaa karoum
Hi Knut, It's 2.21 Seemaa On 21 February 2017 at 15:59, Knut Staring wrote: > What version of Dhis2? > > On Feb 21, 2017 12:58 PM, "seemaa karoum" wrote: > >> Dear DHIS community, >> >> We have an issue with putting the health facilities into groups, We have >> a 3 group: Hospitals, Health ce

Re: [Dhis2-users] Org Units groups/ Sudan DHIS

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Hi Seemaa, We have experienced this issue while using DHIS2 2.19. At that time, it was linked to the CPU and memory of the server which was very small and could not handle our requests. The solution we took at that time was to save the group edition each time a small set of facilities have been se

Re: [Dhis2-users] Org Units groups/ Sudan DHIS

2017-02-21 Thread seemaa karoum
Thanks Tantely for your email! Most probably our issue is different since we have a good server capacity and not yet loaded with data. Seemaa On 21 February 2017 at 16:24, Raminosoa Rabemanantsoa, Tantely < tramino...@mikolo.org> wrote: > Hi Seemaa, > > We have experienced this issue while u

[Dhis2-users] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I am trying to pull out the list of all orgUnits and the name of the questionnaire assigned to each of them via SQL View. In which table should I base the SQL query in order to have the list of dataSet assigned to an orgUnit? Regards, Tantely. -- *This message and its attachmen

[Dhis2-users] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I am trying to pull out the list of all orgUnits and the name of the questionnaire assigned to each of them via SQL View. In which table should I base the SQL query in order to have the list of dataSet assigned to an orgUnit? Regards, Tantely. -- *This message and its attachmen

Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Jim Grace
If you want to show each pair of assigned orgUnit and dataSet, try something like: SELECT ou.name AS orgunit, ds.name AS dataset FROM dataset ds JOIN datasetsource dss ON dss.datasetid = ds.datasetid JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid ORDER BY ou.name, ds.name; If yo

Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Greg Wilson
And to tag onto Tim's message, if you know the particular OU of interest, you can all datasets associated with it via: https://play.dhis2.org/demo/api/dataSet?filter=organisationUnits.id:eq:THEOUUIDGOESHERE Greg On Tue, Feb 21, 2017 at 1:41 PM, Timothy Harding wrote: > An alternative way to d

[Dhis2-users] Importing metadata with special characters via CSV

2017-02-21 Thread Laura E. Lincks
Version: ​ ​ 2.25 Build revision: ​ ​ da6a2df Can someone provide guidance in how to import special characters (accent marks, etc.) when importing metadata via a CSV file? Must I include escape characters? Would another import file format make this easier? TIA. *Laura E. Lincks* Database Manager

Re: [Dhis2-users] Importing metadata with special characters via CSV

2017-02-21 Thread JM Alcantara
Hello Laura Just make sure the encoding of your file is UTF-8 JM > El 21/02/2017, a las 16:49, Laura E. Lincks > escribió: > > Version:​ ​2.25 > Build revision:​ ​da6a2df > > Can someone provide guidance in how to import special characters (accent > marks, etc.) when importing metadata via a

Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Ant Snyman
and if you also want the datasets that are NOT assigned to ANY orgunits you could change the two JOINs to LEFT OUTER JOIN. On 21 February 2017 at 20:31, Jim Grace wrote: > If you want to show each pair of assigned orgUnit and dataSet, try > something like: > > SELECT ou.name AS orgunit,

Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear Jim, I have tested both scripts and they are all working. The second one is more straightforward for the analyzes that I will run with external list. Thank you for your support! Regards, Tantely. Le 21 févr. 2017 9:32 PM, "Jim Grace" a écrit : > If you want to show each pair of assigned

Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Thank you Ant, that is straightforward! We need that sometimes to counter check all things. Regards, Tantely. On Wed, Feb 22, 2017 at 7:16 AM, Ant Snyman wrote: > and if you also want the datasets that are NOT assigned to ANY > orgunits you could change the two JOINs to LEFT OUTER JOIN...

Re: [Dhis2-users] [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Hi Greg, Tim, Thank you for sharing the alternative way using API. Is it possible to go backward using the API, if I would like to go beyound getting the list of assigned dataSets and this time assign a set of dataSets to a group of OU? That will also be helpful! Kind Regards, Tantely On Tue, F