DHIS 2.0 Milestone 5 (M5)

Release date: June 15 2006

New features

• New period management including: - Kristian
  • comparison of periodtypes (the intervals)
  • the periodtype OnChange
  • period GUI to generate new periods?

• Possibility to define a common sort order for all datasets in a dataset hierarchy - Torgeir

• Improved dataset maintenance: - Torgeir
  • define whether data (set) elements are registerd or imported and control for duplicate registration (more than one level)
  • quicker setup of full dataset hierarchies with registration/import and sort order automatically set up for all orgunits

• Data Entry update: - Torgeir
  • support the new dataset structure:
    o only allow data entry for DE marked for registration
    o support sort order set by dataset
  • support new period handling
    o support the OnChange periodtype

• Quick import/export - Woinshet

• Calendar pop-up for defining dates in various GUIs - HISP-Vietnam

• Possibility to sort DE by code in all GUIS - Lars
  • add a global option to select sort by code or name

• Integration with BIRT reports
  • report viewer in DHIS 2 portal - Lars
  • set up report templates with db connection and queries - Ola

• Package and Install tool for easy setup - HISP-Vietnam

• Documentation for PostGreSQL setup - HISP-Vietnam

• User-manual in Vietnamese - HISP-Vietnam

Upgrade Note

There have been some changes to the database in M5, so the following
must be done before upgrading to M5:

Rename table "user" to "users"
Rename column "user" to "userid" in the usersetting table
Rename column "min" to "minvalue" in the minmaxdataelement table
Rename column "max" to "maxvalue" in the minmaxdataelement table

MySQL commands:

RENAME TABLE user TO users;
ALTER TABLE usersetting CHANGE user userid INT(11);
ALTER TABLE minmaxdataelement CHANGE min minvalue INT(11);
ALTER TABLE minmaxdataelement CHANGE max maxvalue INT(11);

PostgreSQL commands:

ALTER TABLE user RENAME TO users;
ALTER TABLE usersetting RENAME COLUMN user TO userid;
ALTER TABLE minmaxdataelement RENAME COLUMN min TO minvalue;
ALTER TABLE minmaxdataelement RENAME COLUMN max TO maxvalue;