tracked Entity type data import

Support - Assistance technique
1

I want to import tracked entity type person mass data to my custom instance, how can i prepare a valid JSON file using excel, thanks

1 Like
2

Hi @ButwhyRex

Welcome to the DHIS2 Community of Practice!

I can think of two approaches that you might want to consider:

  • Bulk Load App (@eyeseetea): Generate templates (Excel sheets) for DHIS2 datasets and programs and import multiple data values (as aggregated or events) into DHIS2 instances. Available at: DHIS2 App Hub
    (source)

Or you’d need to prepare the entire JSON file:

  1. Make sure you have to correct UIDs for Tracked Entity Type (Person), the related OUs, and the Tracked Entity Attributes.
  2. Follow the same payload (Tracker - DHIS2 Documentation)
  3. Use the site suggested by several community members @stephocay @Ulanbek @Georgi to Convert from Excel to JSON (or I would recommend to use VS Code extensions such as ‘Data Preview’ but those will require extra work to get the proper payload)… please double check that the JSON follows the format in the docs.
  4. When it’s time to import, if you are using the Import/Export app, remember to use the ‘Dry Run’ first and if any errors appear in the logs, you can reshare them here.

I hope this helps! :folded_hands:

1 Like