HRIS data import via SDMX-HD

Support - Assistance technique
1

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html
How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

I have omitted the s in the snippet below. Is this OK?

Cheers,
-carl
P.S. sorry if this message is a repeat

Nurse 
 <shortName>Nurse</shortName>
  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->
  <description></description>
  <active>true</active>

  <type>int</type>
  <domainType>aggregate</domainType>
  <aggregationOperator>average</aggregationOperator>
  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->

  <lastUpdated>2010-02-05</lastUpdated>
987654 123456
2

Hi Carl

Sorry to have been unresponsive on this but have been trapped in a meeting the past 2 days. I will be back at home tomorrow evening and try to give some better instruction.

···

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html
How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

We have never implemented the importing of SDMX DSD. What we did do before was was generate the DSD from our side. Regarding association of dsd with schema (in fact schema should be generated from the dsd) let me explain more tomorrow. Its late here now :slight_smile:

What you would probably want to do if you are going this way around and you already have the codelists, is use those to create dataelements in dxf and import them. Again I can help with the detail but not right now.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

yes

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

if categorycombo is meant to be default you can just leave it out. Importer is smart enough to figure you mean default by default :slight_smile:

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

Sure. The ids don’t have to be numeric. Great relief to have moved beyond that. So any sensible code of your choosing will do and dhis will accept it (as long as it doesn’t collide).

I have omitted the s in the snippet below. Is this OK?

Yes.

Bob

Cheers,
-carl
P.S. sorry if this message is a repeat

Nurse 
 <shortName>Nurse</shortName>
  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->
  <description></description>
  <active>true</active>




  <type>int</type>
  <domainType>aggregate</domainType>
  <aggregationOperator>average</aggregationOperator>
  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->




  <lastUpdated>2010-02-05</lastUpdated>
987654 123456

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

3

And if you hadn’t found how to post the dataset from the manual, look here

http://dhis2.org/doc/snapshot/en/user/html/ch23s06.html

···

On 5 December 2012 00:01, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Carl

Sorry to have been unresponsive on this but have been trapped in a meeting the past 2 days. I will be back at home tomorrow evening and try to give some better instruction.

On 4 December 2012 09:56, Frederick Leitner litlfred@ibiblio.org wrote:

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html
How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

We have never implemented the importing of SDMX DSD. What we did do before was was generate the DSD from our side. Regarding association of dsd with schema (in fact schema should be generated from the dsd) let me explain more tomorrow. Its late here now :slight_smile:

What you would probably want to do if you are going this way around and you already have the codelists, is use those to create dataelements in dxf and import them. Again I can help with the detail but not right now.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

yes

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

if categorycombo is meant to be default you can just leave it out. Importer is smart enough to figure you mean default by default :slight_smile:

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

Sure. The ids don’t have to be numeric. Great relief to have moved beyond that. So any sensible code of your choosing will do and dhis will accept it (as long as it doesn’t collide).

I have omitted the s in the snippet below. Is this OK?

Yes.

Bob

Cheers,
-carl
P.S. sorry if this message is a repeat

Nurse 
 <shortName>Nurse</shortName>
  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->
  <description></description>
  <active>true</active>





  <type>int</type>
  <domainType>aggregate</domainType>
  <aggregationOperator>average</aggregationOperator>
  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->





  <lastUpdated>2010-02-05</lastUpdated>
987654 123456

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

4

Thanks so much Bob.

For reference, here is the repo.
https://github.com/litlfred/zimbabwe-sdmx-hd
We are working on the dxf this morning under transforms/dhis/dhis.sxf.xsl

Cheers,
-carl

···

On 5 December 2012 00:01, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Carl

Sorry to have been unresponsive on this but have been trapped in a meeting the past 2 days. I will be back at home tomorrow evening and try to give some better instruction.

On 4 December 2012 09:56, Frederick Leitner litlfred@ibiblio.org wrote:

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html
How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

We have never implemented the importing of SDMX DSD. What we did do before was was generate the DSD from our side. Regarding association of dsd with schema (in fact schema should be generated from the dsd) let me explain more tomorrow. Its late here now :slight_smile:

What you would probably want to do if you are going this way around and you already have the codelists, is use those to create dataelements in dxf and import them. Again I can help with the detail but not right now.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

yes

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

if categorycombo is meant to be default you can just leave it out. Importer is smart enough to figure you mean default by default :slight_smile:

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

Sure. The ids don’t have to be numeric. Great relief to have moved beyond that. So any sensible code of your choosing will do and dhis will accept it (as long as it doesn’t collide).

I have omitted the s in the snippet below. Is this OK?

Yes.

Bob

Cheers,
-carl
P.S. sorry if this message is a repeat

Nurse 
 <shortName>Nurse</shortName>
  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->
  <description></description>
  <active>true</active>





  <type>int</type>
  <domainType>aggregate</domainType>
  <aggregationOperator>average</aggregationOperator>
  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->





  <lastUpdated>2010-02-05</lastUpdated>
987654 123456

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

5

Hi Bob,

Here is the .dxf we generated.

https://github.com/litlfred/zimbabwe-sdmx-hd/blob/master/outputs/dhis/dhis.dxf

you’ll see that the 's are alphanumeric created by concatenating “post” and the internal id’s used by zHRIS.

When we tried to load these into DHIS (2.9) if failed with a number format exception in the log file. Maybe I misread, but I thought alphanumeric id’s were ok…

Cheers,
-carl

···

On 5 December 2012 00:01, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Carl

Sorry to have been unresponsive on this but have been trapped in a meeting the past 2 days. I will be back at home tomorrow evening and try to give some better instruction.

On 4 December 2012 09:56, Frederick Leitner litlfred@ibiblio.org wrote:

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html
How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

We have never implemented the importing of SDMX DSD. What we did do before was was generate the DSD from our side. Regarding association of dsd with schema (in fact schema should be generated from the dsd) let me explain more tomorrow. Its late here now :slight_smile:

What you would probably want to do if you are going this way around and you already have the codelists, is use those to create dataelements in dxf and import them. Again I can help with the detail but not right now.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

yes

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

if categorycombo is meant to be default you can just leave it out. Importer is smart enough to figure you mean default by default :slight_smile:

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

Sure. The ids don’t have to be numeric. Great relief to have moved beyond that. So any sensible code of your choosing will do and dhis will accept it (as long as it doesn’t collide).

I have omitted the s in the snippet below. Is this OK?

Yes.

Bob

Cheers,
-carl
P.S. sorry if this message is a repeat

Nurse 
 <shortName>Nurse</shortName>
  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->
  <description></description>
  <active>true</active>





  <type>int</type>
  <domainType>aggregate</domainType>
  <aggregationOperator>average</aggregationOperator>
  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->





  <lastUpdated>2010-02-05</lastUpdated>
987654 123456

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

6

Thank frederick for your informatoon. The intergration of iHRIS in Kenya is not there. The county team is focusing on other human resouse systemand is near finalization. The only system which is interoparable to DHIS is TIBU SYSTEM and small of IQCARE. The said iHris is not true figure and the datain irhis is based on salaried data wich is copy and paste. The country teamis working on sytem which meet set standards and open to all stakeholders.

We shall share how we have implemented Kenya system.

Itwas good to know

···

On Dec 4, 2012 11:57 AM, “Frederick Leitner” litlfred@ibiblio.org wrote:

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html
How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

I have omitted the s in the snippet below. Is this OK?

Cheers,
-carl
P.S. sorry if this message is a repeat

Nurse 
 <shortName>Nurse</shortName>
  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->
  <description></description>
  <active>true</active>



  <type>int</type>
  <domainType>aggregate</domainType>
  <aggregationOperator>average</aggregationOperator>
  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->



  <lastUpdated>2010-02-05</lastUpdated>
987654 123456

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

7

Thanks good people, The iRHIS team has done commendable Job but still alot to be done.

My statement is based on last month meeting with other stakeholder and one HR representative inform the team. I was with Dykki in Ethiopia and we discuss the challenges by then and even with BOb with no solution. People have see many presentation on iHRIS which is nice but not on the ground.

The HIS was mandate to support the new system to address the sector need. and if iHRIS is there it could be it use with small unit.

Let me not assume for the progress it could be it been handle by individual because the sector is looking beyond. We were ready to assist even Oslo team was ready by then and no development was done based on iintegration. It will be a disaster to invest with no impact based on Kenyan needed. By quiz, was there country requirement done and if then what was the milestone of the system.

As the country to address the many system in the sector it will be good to reach out to many stakeholders and work with the users of the system beyond the unit and individuals. using IPPD in iHRIS will not address the needs but require beyond.

Some of the workers who use to work with iHRIS is supporting new system in other capacities and they understand now our dilemma with iHRIS and approach used.

All the system will have major problem as we move to two government where human resource will be managed from individual county and National government If the system does not address the need them it will be done something.

Bravo

···

On Wed, Dec 5, 2012 at 2:44 PM, Carl Leitner cleitner@capacityplus.org wrote:

Dear Samuel,

Dykki has reached out to our team in country and asked them to get in touch with you to address these issues.

Please stay in close touch with us as we get this resolved.

Thanks for your patience.

Cheers,

-carl

On Dec 5, 2012, at 12:18 PM, Samuel Cheburet samuelcheburet@gmail.com wrote:

Thank frederick for your informatoon. The intergration of iHRIS in Kenya is not there. The county team is focusing on other human resouse systemand is near finalization. The only system which is interoparable to DHIS is TIBU SYSTEM and small of IQCARE. The said iHris is not true figure and the datain irhis is based on salaried data wich is copy and paste. The country teamis working on sytem which meet set standards and open to all stakeholders.

We shall share how we have implemented Kenya system.

Itwas good to know

On Dec 4, 2012 11:57 AM, “Frederick Leitner” litlfred@ibiblio.org wrote:

Hi All,

I am in Zimbabwe and we are working on setting up a linkage from their HRIS, zHRIS, to DHIS2 via SDMX-HD as a cross-sectional data set. I am following the same pattern as we have done for Kenya, Zanzibar, and Sierra Leone. However, I have always worked on the HRIS side of things and this time around I need some direction/helpful hints on the DHIS side.

As a first step, we are trying to import in DHIS2 the data (# health workers, facility, post)

So far, we have generated the necessary DSD.xml and KF_POST_FACILITY.xsd files and I believe the actual import process will should follow this outline:

http://dhis2.org/doc/snapshot/en/user/html/ch24s04.html

How can one associate the DSD and KF_POST_FACILITY.xsd to this process so it can be validated.

Next, I want to know how to properly get the posts properly loaded into DHIS. These are not (at least for now) going to be further disaggregated by things like gender. Looking at some previous examples I think that I should be generating a dxf file for this. Something along the lines of the snippet below. Is this headed in the right direction?

Assuming so, I want the categoryCombo to be “default”, but it seems that the id is different on each system. I assume that I would I need to look it up on the target DHIS system first, or is there some other way?

The id’s for the post dataElements are coming from the zHRIS, e.g. 123456 As I can’t guarantee that there won’t be collision with ids for existing dataElement ids, can I put a prefix on the id, e.g. HRIS123456? Is there some other way I can avoid collision?

I have omitted the s in the snippet below. Is this OK?

Cheers,

-carl

P.S. sorry if this message is a repeat

 <name>Nurse</name>

 <shortName>Nurse</shortName>

  <code>HRIS_123456</code>  <!-- this code is coming from zHRIS -->

  <description></description>

  <active>true</active>

  <type>int</type>

  <domainType>aggregate</domainType>

  <aggregationOperator>average</aggregationOperator>

  <categoryCombo>5</categoryCombo>  <!-- I want this to be the default categoryCombo.  Suppose that it is 5 on the target DHIS system -->

  <lastUpdated>2010-02-05</lastUpdated>

<!--  etc -->

  <dataElementGroup>987654</dataElementGroup>

  <dataElement>123456</dataElement>

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

–

Mr.Samuel K. Cheburet (Bsc. HRIM,Dip. HRIT)

***Division of Health Information System, ******

Afya House, Room LG 37***

PO. Box 30016, 00100.

Ministry of Health Headquarters, Nairobi, Kenya.** **

mobile + 254-721624338

***Email: samuelcheburet@gmail.com, ******samuel.cheburet@health.go.ke , ***hishealth@health.go.ke

**Skype *****samuelcheburet ***