dhis2-devs team mailing list archive

["jason.p.pickering" <673405@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
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: New

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.