Done https://bugs.launchpad.net/dhis2/+bug/673405
2010/11/10 Lars Helge Øverland <larshe...@gmail.com>: > > > On Mon, Nov 8, 2010 at 11:59 AM, Jason Pickering > <jason.p.picker...@gmail.com> 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. > Lars > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+260968395190 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
