Update Organisation Unit Information by Using CSV file

[zana_sidi (Sidiki Z Sanogo)]

Hi Team Members,
I have a DHIS2 instance with data to manage a pproject. I want to create a Dashboard like a Map. But before that, I need to fill Orgabisation unit Latitude and Longitude in DHIS2.
I have a coordonate for some Organisation Unit, but if use BIF to update all process is done but Latitude and Longitude field stay empty.

See below the format that I use (From DHIS2 BIF template)
Parent UID,Name,UID,Short Name,Code,Description,Opening Date,Closed Date,Comment,URL,Contact Person,Address,Email,Phone Number,Org Unit Group 1,Org Unit Group 2,Org Unit Group 3,Longitude,Latitude

My questions are :

1. Where can I find Parent UID.Name, UID, Org Unit Group 1,Org Unit Group 2,Org Unit Group 3 Information ?
2. If someone has already implement this approach, I would like to have a guideline to make an update of my Organistions Unit Latitude and Longitude by using CSV file.

Thanks in avance

[Gassim (AL-Gassim Sharaf Addin)]

Hi @zana_sidi
Welcome to the community!

@zana_sidi

Where can I find Parent UID.Name, UID, Org Unit Group 1,Org Unit Group 2,Org Unit Group 3 Information ?

OU details can be viewed in the Maintenance app → Organisation Unit, select the OU options (ellipses - ‘three vertical dots’) → Show details, check the API url. For example, https://play.dhis2.org/2.39.0/api/29/organisationUnits/ImspTQPwCqd.json

OR use the API directly by using the ou name: https://play.dhis2.org/2.39.0/api/29/organisationUnits?filter=name:ilike:OU_NAME_HERE&fields=*

---

@zana_sidi

I would like to have a guideline to make an update of my Organistions Unit Latitude and Longitude by using CSV file.

Please use this template Organisation Unit CSV Format The coordinates column will contain Longitude,Latitude values.

If you use the import/export app or the API it’s easier to use JSON than CSV