← Back to team overview

dhis2-users team mailing list archive

Re: Import/Export data between similar but distinct systems

 

We’re currently working on something for this – a desktop app that runs on Windows / Mac / Linux that allows you to specify some parameters to ‘map’ from one side to the other and a shell app that runs on a Linux box and reads the config file created by the desktop app once a day to transfer data from the one to the other using the API.  We specifically need to transfer aggregate program indicator values from one side to data elements on the other.
Things to think about:

  *   You need to map Organisational units on both sides
  *   You need to specify the from element + category option combo / indicator and the to element + category option combo on the other side
  *   You need to specify the period type and optionally a start / end date so that the system knows what periods to target.
The system is still in development but will effectively enable incremental updates by recording periods already taken care of for each source / destination / ou.
I’ll keep you posted, at this stage we’re not 100% sure when it will be complete, but it should be in the next few weeks.
Ed

From: Dhis2-users <dhis2-users-bounces+erobinson=projectbalance.com@xxxxxxxxxxxxxxxxxxx> On Behalf Of Martin Van Aken
Sent: Tuesday, 09 January 2018 8:56 PM
To: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: [Dhis2-users] Import/Export data between similar but distinct systems

Hello DHIS2 community,
We need to make frequent import/export between two different DHIS2 systems. While they are similar and the format "fits", we know some differences, mainly:

- The org units concerned exist on both sides but with different ids
- Same for the data elements
- In some situation, the export value may be an indicator, to be imported in a data element

I can imagine making the export in CSV, then having a "matching sheet" in XLS with the link between OU in the source system and OU in the destination system.

Is someone doing those kind of operations? What's your typical flow/way of working?
I think I remember Lars presenting some feature helping with this on one of the last DHIS2 releases, but I'm not sure.

Martin
--
Martin Van Aken - Freelance Enthusiast Developer

Mobile : +32 486 899 652

Follow me on Twitter : @martinvanaken<http://twitter.com/martinvanaken>
Call me on Skype : vanakenm
Hang out with me : martin@xxxxxxxxxxxxxxxx<mailto:martin@xxxxxxxxxxxxxxxx>
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com<http://www.joyouscoding.com/>

Follow ups

References