2010/11/10 Jason Pickering <jason.p.picker...@gmail.com>: > 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.
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.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 > _______________________________________________ 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
