dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Hi

and attached is a composite text file with all the upgrade stuff.

Regards

Calle

On 10 July 2017 at 09:30, Calle Hedberg <calle.hedberg@xxxxxxxxx> wrote:

> Hannan,
>
> If you don't get 2.16 and 2.17, then I can give you a copy of 2.17 - I
> keep the latest war files for all versions since 2.17, but I've never dealt
> with any 2.16 or earlier instance so I don't have that.
>
> As far as I know, there should be a repository of old war files somewhere
>
> Regards
> Calle
>
> On 10 July 2017 at 08:58, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> Hi Hannan,
>>
>> Maybe first try go directly for 2.18 (after backing up the db, of
>> course).
>>
>> There should not be a lot required:
>> https://www.dhis2.org/217-upgrade
>> https://www.dhis2.org/218-upgrade
>>
>>
>> On Mon, Jul 10, 2017 at 8:34 AM, Hannan Khan <hannank@xxxxxxxxx> wrote:
>>
>>> Thanks Knut.
>>>
>>> Yes I find version 18 onward, but can get 16, 17. Need upgraded war
>>> file. Can you please explore.
>>>
>>> Regards
>>>
>>> Hannan
>>>
>>> On Mon, Jul 10, 2017 at 12:22 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>
>>>> Not sure about 16 and 17 - might have to build them (I will take a
>>>> look).
>>>>
>>>> From 2.18, this works;
>>>>
>>>> https://www.dhis2.org/download/releases/2.18/dhis.war
>>>>
>>>> On Jul 10, 2017 08:02, "Hannan Khan" <hannank@xxxxxxxxx> wrote:
>>>>
>>>>> Dear all
>>>>>
>>>>> I need earlier war files from 16 on ward; from where I can download?
>>>>>
>>>>> Regards
>>>>>
>>>>> Muhammad Abdul Hannan Khan
>>>>> Team Leader
>>>>> Support to the National HMIS
>>>>> MIS, Director General of Health Service
>>>>> Ministry of Health and Family Welfare
>>>>>
>>>>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>>>>> F +88 02 58813 875
>>>>> M+88 01819 239 241
>>>>> M+88 01534 312 066
>>>>> E hannank@xxxxxxxxx
>>>>> S hannan.khan.dhaka
>>>>> B hannan-tech.blogspot.com
>>>>> L https://bd.linkedin.com/in/hannankhan
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>
>>>
>>> --
>>> Muhammad Abdul Hannan Khan
>>> Team Leader
>>> Support to the National HMIS
>>> MIS, Director General of Health Service
>>> Ministry of Health and Family Welfare
>>>
>>> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
>>> F +88 02 58813 875
>>> M+88 01819 239 241
>>> M+88 01534 312 066
>>> E hannank@xxxxxxxxx
>>> S hannan.khan.dhaka
>>> B hannan-tech.blogspot.com
>>> L https://bd.linkedin.com/in/hannankhan
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522 <+47%20918%2080%20522>
>> Skype: knutstar
>> http://dhis2.org
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>


-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

2.19 upgrade script:


-- Set org unit of program instance to org unit of tracked entity instance

alter table programinstance add column organisationunitid integer;

update programinstance pi
set organisationunitid = (
  select organisationunitid from trackedentityinstance tei
  where pi.trackedentityinstanceid = tei.trackedentityinstanceid)
where pi.organisationunitid is null;


2.20 upgrade script


-- Set userid of messageconversation table based on first message

alter table messageconversation drop constraint fk_messageconversation_userid;

alter table messageconversation add column userid integer;

update messageconversation mc set userid=(
  select m.userid from message m
  inner join messageconversation_messages mcm on m.messageid = mcm.messageid
  where mcm.messageconversationid = mc.messageconversationid
  and mcm.sort_order=1
  limit 1)
where mc.userid is null;

-- Set organisation units with no opening date to 1970 and set not null

update organisationunit set openingdate='1970-01-01' where openingdate is null;
alter table organisationunit alter column openingdate set not null;

2.22
Config file now called dhis.conf

2.23 upgrade script

-- Update source type for program rules

update programrulevariable set sourcetype = 'DATAELEMENT_CURRENT_EVENT', lastupdated = current_timestamp 
where uid in (
  select prv.uid from programrulevariable prv 
  inner join program p on p.programid = prv.programid 
  where p.type = 'WITHOUT_REGISTRATION' and (
  prv.sourcetype = 'DATAELEMENT_NEWEST_EVENT_PROGRAM' or prv.sourcetype = 'DATAELEMENT_NEWEST_EVENT_PROGRAM_STAGE')
);



2.24 Upgrade
User Interface

Maintenance operations for metadata attributes, constants and option sets have been moved to the Maintenance app.
Web API

The translations solution has been rewritten, and translations are now included for each object in the API response 
instead of from the old /api/translations endpoint. Please consult the translations documentation.
Web API versioning is gradually being introduced. If you want to write your app against a specific API version 
for greater stability you can use /api/24 as base URL. An example is play.dhis2.org/demo/api/24/dataElements. 
This work will be completed in v 2.25.


-- 2.25 upgrade script

-- Add deleted column to datavalue table

-- This will be handled by DHIS 2, however running this script will be much faster in comparison for large datavalue tables

begin;

-- 1) Drop indexes and foreign keys

alter table datavalue drop constraint datavalue_pkey;
drop index in_datavalue_lastupdated;

-- 2) Add deleted column, set to false, set to not-null and create index

alter table datavalue add column deleted boolean;
update datavalue set deleted = false where deleted is null;
alter table datavalue alter column deleted set not null;
create index in_datavalue_deleted on datavalue(deleted);

-- 3) Recreate indexes and foreign keys

alter table datavalue add constraint datavalue_pkey primary key(dataelementid, periodid, sourceid, categoryoptioncomboid, attributeoptioncomboid);
create index in_datavalue_lastupdated on datavalue(lastupdated);

end;


-- 2.26 upgrade script

-- Set data value 'created' and 'lastupdated' columns to now if null and set to not null

update datavalue set created = now()::timestamp where created is null;
alter table datavalue alter column created set not null;

update datavalue set lastupdated = now()::timestamp where lastupdated is null;
alter table datavalue alter column lastupdated set not null;

-- Upgrade coordinate tracked entity data values to use brackets

update trackedentitydatavalue
set value = '[' || value || ']'
where dataelementid in (
  select dataelementid from dataelement
  where valuetype='COORDINATE')
and value is not null
and value ~ ','
and value not like '\[%\]';

-- Upgrade coordinate tracked entity attribute values to use brackets

update trackedentityattributevalue
set value = '[' || value || ']'
where trackedentityattributeid in (
  select trackedentityattributeid from trackedentityattribute
  where valuetype='COORDINATE')
and value is not null
and value ~ ','
and value not like '\[%\]';

-- Upgrade authority for messaging module

insert into userroleauthorities 
select userroleid, 'M_dhis-web-messaging'
from userroleauthorities 
where authority = 'M_dhis-web-dashboard-integration';

-- Add new event analytics authority to user roles with access to event reports/visualizer/dashboard

insert into userroleauthorities(userroleid,authority)
select distinct ura.userroleid, 'F_VIEW_EVENT_ANALYTICS' as view_event_analytics
from userroleauthorities ura
where ura.authority in ('M_dhis-web-event-reports', 'M_dhis-web-event-visualizer', 'M_dhis-web-dashboard-integration');


--2.27 upgrade script

NONE