← Back to team overview

dhis2-users team mailing list archive

Re: Import/Export data between similar but distinct systems


Hi Martin,

when you say import/export I assume data value exchange here - correct?

The approach I recommend is using the "identifier schemes". This allows you
to keep multiple sets of identifiers (id schemes) for data elements and org
units. You can set it up simply by adding unique metadata attributes for
data elements and/org units (do so from maintenance app > Attributes). Then
enter the identifiers used by "the other side".

Example: Add a unique metadata attribute called "Foo ID". Then add those
identifiers like "ID001", "ID002", for your data elements and org units.

Then during import and/or export, you can specify which id scheme to use
for matching data to metadata. You can choose between UID, code and unique

You can read more about id schemes here:


You can read how to use them in data value import here:




On 9 January 2018 at 19:56, Martin Van Aken <martin@xxxxxxxxxxxxxxxx> wrote:

> 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
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo