Re: [Dhis2-devs] [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-devs] 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,

[Dhis2-devs] 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-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-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(

[Dhis2-devs] Help needed: Instance not starting after cloning...

2018-10-30 Thread M.Selvaraaj Prabu
Hi all, Kindly note I cloned our production instance using the following steps: 1. Created an instance (dhis2-create-instance -p 9095 my_ins) 2. Copied and adjusted the hibernate.properties file from production. 3. Cloned the production instance (dhis2-clone source my_ins) 4. Started

Re: [Dhis2-devs] Use of square brackets [] in metadata field filter

2018-10-30 Thread Vladimer Shioshvili
We faced the same issue, and I have brought it to Lars' attention, and he is aware of the issue. According to him, DHIS2 will be addressing this by changing square brackets in the long term, but in the short term solution you can make square brackets be exempted on the tomcat side by using

Re: [Dhis2-devs] [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

[Dhis2-devs] 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-devs] [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-devs] Use of square brackets [] in metadata field filter

2018-10-30 Thread Jasper Timm
Hi DHIS2 devs, I faced an issue recently with using (unencoded) square brackets in requests to the DHIS2 API. It turns out it was related to a new version of tomcat (7.0.90). I've spoken to the tomcat devs and they've said that they will now consider unencoded square brackets in a request to be

Re: [Dhis2-devs] [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-devs] FW: events report through API

2018-10-30 Thread Bernard Sadaka (IM Advisor)
I sent the bellow few days ago to the users mailing list, but I believe the developers would be able to help more. Thank you in advance for your help. All the best, Bernard Bernard Sadaka Information Management Advisor Première Urgence - Aide Médicale Internationale Nehmeh Building,