[Dhis2-devs] DHIS 2 Symposium - Register now!

2018-02-13 Thread Lars Helge Øverland
Hi all, we are gearing up for the biggest DHIS 2 event of the year, happening in just a few weeks on March 22nd and 23rd in Washington, DC. If you haven't registered yet, don't wait, as tickets are limited, and we have sold out

[Dhis2-devs] Updating data elements via CSV import eliminates aggregationlevels

2018-02-13 Thread Calle Hedberg
Hi, I see that importing a set of data elements - some new, some existing - is wiping out all stored aggregation levels for existing data elements. is this a bug or intended behaviour? Regards Calle *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH

Re: [Dhis2-devs] table for Category Options

2018-02-13 Thread Bob Jolliffe
Sure Calle, I guess postgres must defend itself from the likes of us :-) On 13 February 2018 at 09:48, Calle Hedberg wrote: > Morten > > Thanks for prompt reply, I had actually looked at the properties for that > and all other tables with category/options in the name (in

[Dhis2-devs] Support for Time and DateTime

2018-02-13 Thread Bernard Sadaka (IM Advisor)
Hello guys, Maybe this was already tackled before, but apparently, in my 2.28 instance, the Support for Time and DateTime is working in the “maintenance” app but not in the “event capture” app (didn’t test the tracker capture app). I have checked JIRA and found this one as solved in 2.28:

Re: [Dhis2-devs] Support for Time and DateTime

2018-02-13 Thread Bernard Sadaka (IM Advisor)
Thank you Lukas, You will add them to JIRA? To the repository? When/where will the fix be available for download? In the WAR file? If yes, which one? All the best, Bernard Bernard Sadaka Information Management Advisor Première Urgence - Aide Médicale Internationale Nehmeh Building,

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Aaron C White
Thanks, Lars and Preeti. I checked the indicator formulation and found a problem with a d2:condition() statement using a text option set value. I converted it to an integer and was able to see the calculated data across stages. I think it might be related to the parentheses issue inside the

Re: [Dhis2-devs] table for Category Options

2018-02-13 Thread Calle Hedberg
Morten Thanks for prompt reply, I had actually looked at the properties for that and all other tables with category/options in the name (in pgadmin), but it was showing with only 1 records. Had to actually open the table to see the options, so I guess postgresql don't automatically update it's

[Dhis2-devs] Meta-data export with dependencies Fails

2018-02-13 Thread Calle Hedberg
Hi I'm trying to export a single data set from one instance to another - it is a relatively simple data set with about 20 data elements, all using the same categorycombo. Import fails with the following message: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique

Re: [Dhis2-devs] table for Category Options

2018-02-13 Thread Morten Olav Hansen
dataelementcategoryoption -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Tue, Feb 13, 2018 at 4:38 PM, Calle Hedberg wrote: > Hi > > Quick question: I have just added two CATEGORY OPTIONS to an instance - > but in which table

[Dhis2-devs] table for Category Options

2018-02-13 Thread Calle Hedberg
Hi Quick question: I have just added two CATEGORY OPTIONS to an instance - but in which table in the database are those options stored? Regards Calle *** Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell:

Re: [Dhis2-devs] Support for Time and DateTime

2018-02-13 Thread Bernard Sadaka (IM Advisor)
Thank you. 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

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Martin Van Aken
Hi everyone. Thanks Lars for the answer - we face problems with priorities (hence needing parenthesis) there too. Glad to know this will be solved, but what would be the possible workarounds in the meantime? I wanted to decompose in different indicators, but programIndicators can't use other

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

2018-02-13 Thread Lars Helge Øverland
HI Aaron, that sounds good, glad to hear you got cross-stage calculations to work. Unfortunately program indicator expressions do not support nested parentheses/functions - we plan to develop a new version of our program indicator parser which will be more flexible in this regard. regards,