Versions Compared

Old Version 9

changes.mady.by.user Henry Lopez

Saved on

compared with

New Version 10

changes.mady.by.user Henry Lopez

Saved on

Key

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

...

  • 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 Rearranging the tab order in the Excel template will not change impact the DHIS2 configurations.

  • This template can only be used to edit existing DHIS2 program, program creation is not supportedis designed solely for the modification of existing DHIS2 programs; it does not support the creation of new programs.

...

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.

...

All cells within the spreadsheet are protected in the spreadsheet, the instruction tab contains the program setting for the selected . The "Instruction" tab encompasses program settings for the chosen tracker or event, also the instruction tab contain alongside a section for the server info about server from the template was downloadeddetailing server information pertinent to the template's download source.

...

The TEAs tab

This tab contains the Tracked Entity Attributes assigned to the current program.

...

  1. Structure (Column A): In this cell, the user will have to select TEA in the options. Once you have selected TEA the following users need to choose a Tracked Entity Attribute (TEA) from the provided options. Upon selecting a TEA, the subsequent columns must be highlighted in red to show that are mandatoriesindicate their mandatory status:

    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, Short name, Value Type and Aggregation Type are used to verify that the TEA exists in the server, in case the TEA doesn’t exit, the cells will display a “Not found” message.

  • If In case the expected cells are not automatically filled in, then drag aren't automatically populated, you can resolve this by dragging the formula from another cell in within the same column.

  • Columns I to L will default to "No" if the cells are left blank.

...