Importing Organization Units from another system

Hello,

We are trying to import organizational unit data from another system into an instance of DHIS 2.15.

To create the import XML file, I mimicked the Meta-Data XML Export file for exporting only Organizational Units. I stripped that file down to just one simple org unit (at Level 2, Province) and revised it to reflect new test data for a new test org unit.

I have all pertinent data in the XML file (including complete parent data) except for the internally generated “id” for this new org unit – so I tried a couple of things: a) I made an id up, and b) I tried to import without “id”. The Meta-Data import does not import the test data in either scenario. I get no error message but in querying the data on the backend this test org unit does not exist in the database.

Any help would be appreciated. TIA.

···


Laura E. Lincks
Database Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1

New York, NY 10032
Tel: 212 304 7132

Dear Laura,

I once tried it that way but DHIS does now allow org unit import using the meta-data format as you specified.

I am not sure though whether there is a way to import massive number of org units into DHIS using ‎a GUI yet. Maybe the developers can clarify but talking about mimicking, it doesn’t work. It will give no error but you won’t find them in the database.

I hope this helps.

Regards,

Adedayo

ATT001.txt (247 Bytes)

···

Sent from my BlackBerry 10 smartphone.

From: Laura E. Lincks

Sent: Tuesday, 3 June 2014 20:23

To: DHIS Users

Subject: [Dhis2-users] Importing Organization Units from another system

Hello,

We are trying to import organizational unit data from another system into an instance of DHIS 2.15.

To create the import XML file, I mimicked the Meta-Data XML Export file for exporting only Organizational Units. I stripped that file down to just one simple org unit (at Level 2, Province) and revised it to reflect new test data for a new test org unit.

I have all pertinent data in the XML file (including complete parent data) except for the internally generated “id” for this new org unit – so I tried a couple of things: a) I made an id up, and b) I tried to import without “id”. The Meta-Data import does not import the test data in either scenario. I get no error message but in querying the data on the backend this test org unit does not exist in the database.

Any help would be appreciated. TIA.


Laura E. Lincks
Database Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1

New York, NY 10032
Tel: 212 304 7132

Hi Laura,

It is tough to say what is going on without more information. You may want to allow the system to generate the UID for you (which is described here http://www.dhis2.org/doc/snapshot/en/user/html/ch30s25.html) as it must follow a valid specification.

Please include the XML which you created. This will help a lot.

Please include the output of the log file from DHIS2, when you import the XML file.

Please provide your version of DHIS2 and any other information about your system (database, operating system, Java version, etc).

Best regards,

Jason

···

On Tue, Jun 3, 2014 at 9:23 PM, Laura E. Lincks laura.lincks@icap.columbia.edu wrote:

Hello,

We are trying to import organizational unit data from another system into an instance of DHIS 2.15.

To create the import XML file, I mimicked the Meta-Data XML Export file for exporting only Organizational Units. I stripped that file down to just one simple org unit (at Level 2, Province) and revised it to reflect new test data for a new test org unit.

I have all pertinent data in the XML file (including complete parent data) except for the internally generated “id” for this new org unit – so I tried a couple of things: a) I made an id up, and b) I tried to import without “id”. The Meta-Data import does not import the test data in either scenario. I get no error message but in querying the data on the backend this test org unit does not exist in the database.

Any help would be appreciated. TIA.

Laura E. Lincks
Database Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1

New York, NY 10032
Tel: 212 304 7132


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp