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 <id>'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 Dec 5, 2012, at 9:48 AM, Carl Leitner <[email protected]> wrote: > 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 Dec 5, 2012, at 1:03 AM, Bob Jolliffe <[email protected]> wrote: > >> 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 <[email protected]> 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 <[email protected]> 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 :-) >> >> 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 :-) >> >> >> 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 <uid/>s in the snippet below. Is this OK? >> >> Yes. >> >> Bob >> >> >> Cheers, >> -carl >> P.S. sorry if this message is a repeat >> >> >> <dxf> >> <dataElements> >> <dataElement> >> <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> >> </dataElement> >> <!-- etc --> >> </dataElements> >> <!-- assume that I have already created a dataElementGroup "Post" with id >> 987654 --> >> <dataElementGroupMembers> >> <dataElementGroupMember> >> <dataElementGroup>987654</dataElementGroup> >> <dataElement>123456</dataElement> >> </dataElementGroupMember> >> <!-- etc --> >> </dataElementGroupMembers> >> </dxf> >> >> >> >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
