Re: [Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

Hi Tantely, Well, you can use a series of union statements to create a column for each of your data elements, but it might get unwieldy. You can also use the "tablefunc" tools to generate such a cross tab. Its documented here https://www.postgresql.org/docs/9.5/static/tablefunc.html Regards,

[Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

Dear Community, With DHIS2 2.24, I am trying to output raw data in a matrix format. I have used SQL View to output the data. Data values table is presented as following: *orgUnit UID, dataElement1, Value, Period* *orgUnit UID, dataElement2, Value, Period* *orgUnit UID, dataElement3,

Re: [Dhis2-devs] Server version

Hi Arnau, you can use this endpoint .../api/system/info You have more information here: https://docs.dhis2.org/master/en/developer/html/webapi_system_resource.html On Tue, Feb 14, 2017 at 10:47 AM, Arnau Sánchez wrote: > Hi all, > > I am writing a webapp that works only for

[Dhis2-devs] Server version

Hi all, I am writing a webapp that works only for some specific version of dhis2 (25/26). How would I get the version of the server through the API? I'd like to show a warning it the server is running with a non-supported version. I don't see that info at /api/resources. Or should I tackle the

Re: [Dhis2-devs] [Dhis2-users] My DHIS2 Reports app not loading

>From the look of this error, it seems that you have not assigned this user to any organisation units? Regards, Jason XML Parsing Error: no root element found Location: http://localhost:8080/misca/api/legendSets.json?fields=id, displayName|rename(name),legends[id,displayName|rename(

Re: [Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

Dear Jason, Thank you for this instruction. This is what I am looking for. Kind Regards, *Tantely Raminosoa* *Data Officer* Management Sciences for Health Antananarivo Madagascar Mobile: 0344280040 E-mail: tramino...@mikolo.org Skype: traminosoa Stronger health systems.

Re: [Dhis2-devs] Server version

Thanks Jose, that's it! 2017-02-14 10:53 GMT+01:00 Jose Garcia Muñoz : > > Hi Arnau, > > you can use this endpoint .../api/system/info > > You have more information here: https://docs.dhis2.org/ > master/en/developer/html/webapi_system_resource.html > > On Tue, Feb 14, 2017

Re: [Dhis2-devs] [Dhis2-users] Accessing Admin password

Try this: update users set password='$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO. fwFDfMX53hitfx5.3C' where username='admin'; Then restart tomcat to make sure the application cache is cleared. Then log in with admin/district. On Tue, Feb 14, 2017 at 11:30 AM, Timothy Kiyemba

Re: [Dhis2-devs] How to find all Indicators that use a specific DataElement via the API?

Hi Lars, Thanks, that's exactly what I'm looking for. Cheers, Lorill On Mon, Feb 13, 2017 at 1:15 AM, Lars Helge Øverland wrote: > Hi Lorill, > > that is the best way at the moment. We do have primitive support for > logical operators (applies to entire query) so you could

Re: [Dhis2-devs] [Dhis2-users] Error in GIS app DHIS2 2.26

Hi Marc, I've created a date format fix for 2.26 - could you try to upgrade your instance to the latest revision, and check if it solves your problem? https://jira.dhis2.org/browse/DHIS2-1038?filter=10200 Bjørn Sandvik GIS developer, DHIS 2 University of Oslo www.dhis2.org On Tue, Feb 7, 2017

Re: [Dhis2-devs] [Dhis2-users] delete existing data elements

Hi Lorill, this happens due to a lingering legacy database table. We will include a startup statement to remove it. In the meantime you can run this SQL against your database: drop table caseaggregationcondition; regards, Lars ​ On Tue, Feb 14, 2017 at 11:10 PM, Lorill Crees

Re: [Dhis2-devs] [Dhis2-users] delete existing data elements

Thanks for the quick response Lars. In which version was it removed? We are managing multiple instances on different versions and I just want to make sure we remove it from the right ones. Thanks! On Tue, Feb 14, 2017 at 2:20 PM, Lars Helge Øverland wrote: > Hi Lorill, > >

Re: [Dhis2-devs] [Dhis2-users] delete existing data elements

Hi Lars, I am attempting to delete a data element via the API and am getting the below error, due to a foreign key constraint on table "caseaggregationcondition". What are CaseAggregationConditions and where are they in the DHIS 2 UI? In your prior email to Channara you said that "If you

[Dhis2-devs] Tracked entity attribute permission in 2.25

Hi everyone, I can't seem to find the permissions to allow users to add in tracked entity attributes in 2.25 (Add/Update Private Tracked Entity Attribute, Add/Update Public Tracked Entity Attribute, Delete Tracked Entity Attribute). I am running build 25de13d, date 2017-02-14 06:42. This seem to