Versions Compared

Old Version 4

changes.mady.by.user Henry Lopez

Saved on

compared with

New Version 5

changes.mady.by.user Henry Lopez

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The template generated to event/Tracker program will contain different tab:

  • Instructions: Contain information how to use the template excel.

  • TEAs: Contain the Program Tracked Entity Attributes management.

  • Stages: These tabs are going to be generated depending on the program stages, a tab is generated for every program stage.

  • Release notes: This tab is for reference only, you cannot edit it. Please refer to this tab for latest features and fixes

  • Mapping: This tab is for reference only, you cannot edit it. This tab will list all the option sets /Health are / Legend etc. Used in the Excel spreadsheet.

Note

Keep in mind:

  • Changing the tab order in the Excel template will not change the DHIS2 configurations

  • This template can only be used to edit existing DHIS2 program, program creation is not supported

When you open the sheet, ‘Template’ tab will be selected by default.

The instructions tab

This tab provides brief information related to the Excel sheet. You can go through this tab to have a thorough understanding of all the fields in the sheet.

...

  • To add another section, the user only will have to add a new row (it is very important to remark that an entire row needs to be added) right below the previous section’s last TEAs.

    • For a new section, the user has to select "Section" on the Structure (A) column.

    • Then type a name on (C) column that will be displayed for the new section.

...

To add a new TEA, you have to find the right position where you want it and add a new entire row right below. The following cell should be filled in:

  1. Structure (Column A): In this cell, the user will have to select TEA in the options. Once you have selected TEA the following columns must be highlighted in red to show that are mandatories:

    1. UID

    2. Name

    3. Short Name

    4. Value type

    5. Aggregation type

  2. UID (Column B): This cell should be automatically filled in once the user enters the TEA name.

Note

  • The UID is used to verify that the TEA exists in the server, in case the TEA doesn’t exit, the cell will display a “Not found” message.

  1. Name (Column C): The user must enter TEA name and the following column should be automatically filled in:

    1. UID

    2. Short name

    3. Value type

    4. Aggregation type

  2. Short Name (Column D):This cell should be automatically filled in once the user enters the TEA name.

  3. Value Type (Column E): This cell should be automatically filled in once the user enters the TEA name.

  4. Aggregation Type (Column F): This cell should be automatically filled in once the user enters the TEA name.

...