dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

2010/11/10 Jason Pickering <jason.p.pickering@xxxxxxxxx>:
> Done
>
> https://bugs.launchpad.net/dhis2/+bug/673405
>
> 2010/11/10 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>>
>>
>> On Mon, Nov 8, 2010 at 11:59 AM, Jason Pickering
>> <jason.p.pickering@xxxxxxxxx> wrote:
>>>
>>> Hi there. I have a question regarding the DHIS 1.4 import process.
>>> 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>
>>>
>>> Does this imply that the data stored in EntryText and EntryNumber
>>> columns are not imported?
>>
>> You are right. This is a major oblivion. Write a bug for it and I will fix
>> it.
>>
>>>
>>> I guess more importantly as well, if there
>>> are values in the EntryYesNo for instance (which might be 1) and a
>>> NULL value is returned with this query (as  number would not exist in
>>> the EntryNumber column, and DHIS 2 would transform the NULL entity
>>> into a 0, it would seem that the incorrect number would be imported.
>>> Again, not fully understanding the code, it is difficult for me to
>>> really understand everything that is going on, but I thought I would
>>> at least ask, to put my fears to rest.
>>>
>>
>> Yes this is a consequence of the above but it will not affect the output in
>> DHIS 2 as we use "true" / "false" for boolean values, a "0" will be
>> ignored.
>>
>>>
>>> Also, I see at http://ibatis.apache.org/ that the project has been
>>> retired. Any plans to upgrade to what Ibatis has become
>>> (http://www.mybatis.org/)
>>>
>>
>> No immediate plans but should be looked into.

Would still be nice to have a go at jackcess for this but again, no
immediate plans ....

Bob

>> Lars
>>
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>
> _______________________________________________
> 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
>