Question on DHIS 1.4 file of routine data values of type !=EntryNumber

Support - Assistance technique
1

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? 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.

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/\)

Regards,
Jason

···

--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

2

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

···

On Mon, Nov 8, 2010 at 11:59 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

3

Done

https://bugs.launchpad.net/dhis2/+bug/673405

···

2010/11/10 Lars Helge Øverland <larshelge@gmail.com>:

On Mon, Nov 8, 2010 at 11:59 AM, Jason Pickering > <jason.p.pickering@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.pickering@gmail.com
tel:+260968395190

4

Done

https://bugs.launchpad.net/dhis2/+bug/673405

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

···

2010/11/10 Jason Pickering <jason.p.pickering@gmail.com>:

2010/11/10 Lars Helge Øverland <larshelge@gmail.com>:

On Mon, Nov 8, 2010 at 11:59 AM, Jason Pickering >> <jason.p.pickering@gmail.com> wrote:

Lars

--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help