Re: [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

2018-10-30 Thread Dayo Adeyomoye
Beautiful. Many thanks for sharing. Kindest regards, Adedayo Sent from Yahoo Mail on Android On Tue, 30 Oct 2018 at 22:34, Lars Helge Øverland wrote: Hi all, heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6. This is in order to take advantage of certain SQL

[Dhis2-users] postgresql version 9.6 required for dhis version 2.31

2018-10-30 Thread Lars Helge Øverland
Hi all, heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6. This is in order to take advantage of certain SQL features introduced in that version. The current required version is 9.4. If you plan to upgrade your PostgreSQL version we recommend going straight to version 10,

Re: [Dhis2-users] Text in Pivot Tables

2018-10-30 Thread Sarah Searle
Hi Damien, Thanks for sharing. We recently experienced the same behavior. It seems the text values are present in the datavaluesets and the analytics tables, they just don't show up in the Pivot App itself. A bit frustrating for the end user because this worked up until quite recently. I need to

Re: [Dhis2-users] Text in Pivot Tables

2018-10-30 Thread Damien Scarlett
Hi Kate, Unsure if anyone else has replied but we tested a Data Element to capture ‘Comments’ in Data Sets & found out it is displayed only when exported to an Excel file in the Pivot Table app/section - an extract is attached. If anyone knows of an update/fix/better alternative please share.

[Dhis2-users] Help needed: Checking a string with single quote in program rule...

2018-10-30 Thread M.Selvaraaj Prabu
Hi all. Kindly assist me to resolve this issue. I want to check a single quoted string in a program rule such as "variable == 'Don't know'". I tried using two single quotes (Don''t know) and escaped with a backward slash (Don\'t know) but it doesn't work. Any suggestions? Your help is very much

Re: [Dhis2-users] [Dhis2-devs] Generating sequential numbers in program rule

2018-10-30 Thread M.Selvaraaj Prabu
Hi Terrance, Sometime back I read about this. I think you need to use the expression like - ORG_UNIT_CODE(…) + "-" + CURRENT_DATE(ww) + "-" + SEQUENTIAL(#) Instead of using the function concatenate. Please refer the below link for more details: -

Re: [Dhis2-users] [Dhis2-devs] Generating sequential numbers in program rule

2018-10-30 Thread Terence Scott
Dear Zubair, Nick I have upgraded the instance to 2.30 now and am attempting to once again implement the sequential numbering using the TextPattern option. I am using it on a TEAttribute, but have not had any success. Thus far, my Defined program rule action looks as follows: d2:concatenate(

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

2018-10-30 Thread Terence Scott
Glad to hear it! Terence Scott Global Alliance for Rabies Control (GARC) Pan-African Rabies Control Network (PARACON) Steering Committee terence.sc...@rabiesalliance.org https://paracon.rabiesalliance.org Skype: tpscott1987 On Tue, Oct 30, 2018 at 1:03 PM M.Selvaraaj Prabu wrote: > Thank

[Dhis2-users] Duplicate Key Error

2018-10-30 Thread gerald thomas
Dear All, It had been awhile now that we had been noticing this error in our log: Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "datavalue_pkey" Detail: Key (dataelementid, periodid, sourceid, categoryoptioncomboid,

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

2018-10-30 Thread M.Selvaraaj Prabu
Thank you very much Mr.Terence for pointing to the right direction. It worked. Thanks and regards MSP On Tue, Oct 30, 2018 at 12:39 PM Terence Scott < terence.sc...@rabiesalliance.org> wrote: > Dear MSP > > I am not sure if you are aware, but see the following documentation for > the codes

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

2018-10-30 Thread Terence Scott
Dear MSP I am not sure if you are aware, but see the following documentation for the codes used to create the "current date" in the program rule. https://docs.dhis2.org/2.30/en/user/html/configure_program_rule.html Please see *Table 21.14. Standard variables to use in program rule expressions

[Dhis2-users] Help needed: Assigning current date to a data element...

2018-10-30 Thread M.Selvaraaj Prabu
Hi all, I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2 (2.29) to manage our OVC database. We are using Tracker App to capture the individual case management. We have a field (data element) called "Data entered on" and this has to be the current date and time. I created a