Versions Compared

Old Version 20

changes.mady.by.user Harshula Jhala

Saved on

compared with

New Version Current

changes.mady.by.user Harshula Jhala

Saved on

Key

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

...

  1. To download the Targets template for a specific Geographic Area, navigate to the “Targets” tab and click on the “Download Targets” button. Ensure that the table is refreshed to display the most accurate values.

Info

The downloaded Targets template will contain only the Project Indicators that are currently displayed on the Set Targets table. If the table is filtered (or search is active), then only the filtered Project Indicators displayed on the table will be downloaded. 

...

Info

If not no Targets have been added for the downloaded Project Indicators, the blue Target cells in the template will be empty. Similarly, Targets that have been entered in Amp Impact will be displayed in the template.

...

  1. If there is at least one Project Indicator linked to the Geographic Area, then selecting “Generate” will generate the Targets template.

  2. The generated Target Excel file will all be stored as ContentVersion files under the Files related list on the relevant Project Geographic Area. In the Libertas v1.35 release, the content version is not available on the related list on the relevant Project Geographic AreArea

    1. ContentVersion record’s Created Date is the time stamp of download. 

    2. ContentVersion record’s Owner field displays the name of the user who downloaded the file. 

    3. If a user downloads an Excel file multiple times for the same Geographic Area, these ContentVersion files are updated to reflect the last download date, and the owner of the ContentVersion record is updated to the user who last downloaded the Targets. 

    4. The user may access all of the versions that have been downloaded by selecting “View previous versions.”

    5. The updated ContentVerion file is posted on Chatter of the related Geographic Area record. 

  3. After the Excel template is generated, you’ll have the option to “View” or “Download” the generated Targets template.

    1. Select “View” to view the file in a separate tab before downloading it.

    2. Select “Download” to download the Excel file to your device.

  4. The downloaded Excel Targets template will have two tabs:

    1. Tab 1: Instructions: This tab will outline how to enter data in a compatible format to successfully upload the document onto the Set Targets page.

    2. Tab 2: [Geographic Area + Reporting Period]: This tab will reflect the Geographic Area and all associated Reporting Periods for which the Targets template is downloaded. Below the header on the second tab, you can find the date and time of the download and the name of the user who downloaded the file. 

Info

Modify the Columns in the Template: All Up till the Mira (v1.37) release, all columns in the template except Indicator, Disaggregation and Reporting Period columns are controlled by a the ampi__SET_TARGETS_INFO_POPOVER field set.

...

Info

If certain Reporting Periods have been submitted, the submitted Reporting Periods will appear in the template but will be locked for editing. The column name will be as follows: [Reporting Period Name] - (Submitted).

...

  1. The Target values can be added to the second tab of the downloaded Target template spreadsheet.
    Please ensure to refresh the page in case the formatting seems incorrect.


Info

The following elements are editable in the downloaded template:

Nashira (v1.38) release onwards Indicator attribute fields on the Targets Upload Download Excel Template are controlled by INDICATOR_FIELDS_SET_TARGETS_EXCEL_TEMPLATE field set.

If Numerator/Denominator type of indicators exist in the system, the following additional columns will be displayed as part of the downloaded template: 

  • Numerator Definition

  • Denominator Definition

  • Calculation Factor

The above columns will not be displayed if Numerator/Denominator type indicators do not exist in the project for that reporting period and geographic area combination.

...

Info

If certain Reporting Periods have been submitted, the submitted Reporting Periods will appear in the template but will be locked for editing. The column name will be as follows: [Reporting Period Name] - (Submitted).

...

  1. The Target values can be added to the second tab of the downloaded Target template spreadsheet.
    Please ensure to refresh the page in case the formatting seems incorrect.

Info

The following elements are editable in the downloaded template:

  1. The number of tabs;

  2. The values in the input cells which are indicated by the blue background;

  3. The text in the comments column per Project Indicator where Data_Type__c = Input.

The following elements are not editable in the downloaded template (and will cause errors when uploading if they are modified):

  1. The header text on the tab with the downloaded data;

  2. The names of the column headers in the downloaded tab;

  3. The name of the downloaded tab;

  4. The existence of one tab with the Reporting Frequency and Geographic Area as the label.

Warning

The Targets template has the following limitations as of the latest release: 

  • Currency codes are NOT seen for Currency Project Indicator Targets

  • Percentage sign is NOT seen for percentage Project Indicator Targets

  • HTML markdown characters are expected to be seen which includes formatting specific characters. (eg HTML markdown for new line, bold text etc.) in all releases before the Libertas v1.35 release. As of Libertas the display of HTML tags is controlled by a design attribute.

  • Images are not expected to be printed in excel

  • URLs are not expected to be hyperlinked in the excel cell

  • Preview of the downloaded targets template shows a 0/1 value for indicators that are cross disaggregated by sex.

    Status
    colourPurple
    titleLIbERTAS

  • Wrong target values will be displayed on the Total column if only one indicator exists that is disaggregated and of percent data type. Ensure that more than 1 indicator exists that is of percent data type and is disaggregated.

Info

  • Numerator/Denominator indicators are included in the downloaded Targets template from Nashira (V1.38) and onwards.

Info

How to modify the Targets Excel Template: System Administrators can customize the instructions for the downloaded template using Custom Labels and Translation Workbench.

The downloaded Results template spreadsheet's locale representation is determined by the settings of the Spreadsheet/Excel application installed on the user's system.

...

  1. Navigate to the Set Targets page on the Project record and click . Click of the refresh button to ensure that latest targets are calculated and displayed.

  2. Click the “Upload Targets” button.

  3. In the Upload Targets popup, click on “Attach File” and select the Targets template saved on the your device. Alternatively, drop the Targets template in the drop zone (indicated by the dotted box) inside the popup.

    1. If the selected file is validated, a green checkmark will be displayed next to the attached file.

    2. If the selected file is not validated, a red cross will be displayed next to the attached file, and an error message(s) will be displayed below the attached file.

...

Info

The following elements are editable in the downloaded template:

  1. The number of tabs;

  2. The values in the input cells which are indicated by the blue background;

  3. The text in the comments column per Project Indicator where Data_Type__c = Input (Comments may not be uploaded for Aggregated/Calculated Project Indicators on AddResults).

The following elements are not editable in the downloaded template (and will cause errors when uploading if they are modified):

  1. The header text on the tab with the downloaded data;

  2. The names of the column headers in the downloaded tab;

  3. The name of the downloaded tab;

  4. The existence of one tab with the Reporting Frequency and Geographic Area as the labeldownloaded tab;

  5. The name of the downloaded tab;

  6. The existence of one tab with the Reporting Frequency and Geographic Area as the label.

Info

Modify the Columns in the Template: Up till the Mira (v1.37) release, all columns in the template except Indicator, Disaggregation and Reporting Period columns are controlled by the ampi__ADD_RESULTS_INFO_POPOVER field set.

Nashira (v1.38) release onwards Indicator attribute fields on the Results Upload Download Excel Template are controlled by ampi__INDICATOR_FIELDS_ADD_RESULTS_EXCEL_TEMPLATE field set.

If Numerator/Denominator type of indicators exist in the system, the following additional columns will be displayed as part of the downloaded template: 

  • Numerator Definition

  • Denominator Definition

  • Calculation Factor

    Image Added

The above columns will not be displayed if Numerator/Denominator type indicators do not exist in the project for that reporting period and geographic area combination.

Warning

The Results template has the following limitations as of the latest release: 

  • Currency codes are NOT seen for Currency Project Indicator Results

  • Percentage sign is NOT seen for percentage Project Indicator Results

  • HTML markdown characters are expected to be seen which includes formatting specific characters. (eg HTML markdown for new line, bold text etc.) in all releases before the Libertas v1.35 release. As of Libertas the display of HTML tags is controlled by a design attribute.

  • Images are not expected to be printed in excel

  • URLs are not expected to be hyperlinked in the excel cell

  • Numerator/Denominator indicators are included in the downloaded Results template from Nashira (V1.38) and onwards.

Info

How to modify the Result Excel Template: System Administrators can customize the instructions for the downloaded template using Custom Labels and Translation Workbench.

The downloaded Results template spreadsheet's locale representation is determined by the settings of the Spreadsheet/Excel application installed on the user's system.

...

  1. Step 2: Select “Confirm” to download the Result data for the selected Geographic Area and Reporting Period.

  2. The downloaded Excel template with the selected Result data will be downloaded and displayed as follows:

    1. Tab 1: Instructions: This tab will outline how to enter data in a compatible format to successfully upload the document onto the Add Results page.

    2. Tab 2: [Geographic Area + Reporting Period]: This tab will reflect the Geographic Area and all associated Reporting Periods for which the Results template is downloaded. Below the header on the second tab, you can find the date and time of the download and the name of the user who downloaded the file. 

  3. The generated Results Excel file will all be stored as ContentVersion files under the Files related list on the relevant Reporting Period. 

    1. ContentVersion record’s Created Date is the time stamp of download. 

    2. ContentVersion record’s Owner field displays the name of the user who downloaded the file. 

    3. If a user downloads an Excel file multiple times for the same Geographic Area and Reporting Period, these ContentVersion files are updated to reflect the last download date, and the owner of the ContentVersion record is updated to the user who last downloaded the Results. 

    4. The user may access all of the versions that have been downloaded by selecting “View previous versions.”

    5. The updated ContentVerion ContentVersion file is posted on Chatter of the related Reporting Period record. 

...