dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

** Changed in: dhis2
       Status: Confirmed => Fix Committed

-- 
DHIS 1.4 file  imports ignore routine data values of type !=EntryNumbe
https://bugs.launchpad.net/bugs/673405
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

Status in DHIS 2 - District Health Information Software: Fix Committed

Bug description:
DHIS 1.4 separates different types of values (boolean, number, text)
into three separate columns in the RoutineData  table, namely
EnitryText, EntryNumber, EntryYesNo. DHIS 2 stores all of these values
in the routinedata object/table as character varying(255).

Taking a look at the source file
dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml
I see this line of code..

   <select id="getRoutineDataValues" resultMap="routineDataValueResultMap">
       SELECT DataElementID, DataPeriodID, OrgUnitID, EntryNumber,
LastUserID FROM RoutineData
   </select>
It would appear that values stored in the DHIS 1.4 columns of EntryText and EntryYesNo are thus ignored.