• Published

    • Set Targets & Add Results Excel Download & Upload

    Owned by Harshula Jhala
    Last updated: Oct 21, 2024 by Harshula Jhala
    21 min read

    This page covers:

    Overview: Set Targets and Add Results Offline Using an Excel Template

    Setting Targets and adding Result data can often be a complicated process involving multiple stakeholders. The Excel download and upload feature in Amp Impact enables users to easily download their Target or Result templates to Excel files, enter the data offline in Excel, and then upload it to Amp Impact once they have an internet connection. The uploaded data will then be reflected in the Set Targets/Add Results components in the Project record in Amp Impact.

    Amp Impact comes with two options for managing Target and Result Excel templates: Visualforce and Lightning Web Component. Depending on which option your organization uses, you would need to navigate to different sections to ensure the steps outlined here corresponds with what you’ll see in your system. Check with your System Administrator if you’re unsure which option you are using.

    Downloading and uploading Result data from the Lightning Web Component (LWC) to the Excel template is only available from Indus (v1.31) and later, while the Target LWC template is only available from Kalausi (v1.34) and later. See our Indus and Kalausi Release Notes for more details.

    Target Data Lightning Web Component

    With the Lightning Web Component (LWC) template, users can set Targets for multiple reporting periods at once.

    Download Target Data to an Excel Template Lightning Web Component

    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.

    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. 

    Indicators filtered by Percent Data Type

    1. Once you click the “Download Targets” button, a popup will appear to confirm the Target download for the selected Geographic Area.

    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 Area

      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. 

    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.

    Upload Target Data from an Excel Template Lightning Web Component

    After entering the Target data into the downloaded Target template, you can now upload that template to the Project record in Amp Impact.

    1. Navigate to the Set Targets page on the Project record. 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.

    1. After validating the template, click on the “Upload” button to upload the Targets to the Project.

    2. The system will upload the Targets and display the status of the Targets. The details could include:
      a. Number of successfully uploaded Target records

      b. Number of Target records not uploaded if there have been errors

    1. To view the success entries in an Excel file, click on the “View Successes” button.

      1. The success log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the success log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions that have been uploaded by selecting “View previous versions”.

      3. The updated ContentVersion file is posted on Chatter of the related Project Geographic Area record.

    2. To view the entries not uploaded in an Excel file, click on the “View Errors” button.

      1. The error log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the error log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions.

      3. The updated ContentVersion file is posted on Chatter of the related Project Geographic Area record.

      4. Refer to the errors listed in the Error log to correct them.

    3. Once the Targets have been uploaded successfully, click on the “Close” button.

    4. The Set Targets page will automatically refresh and display the uploaded Targets.

    Result Data Lightning Web Component

    Download Result Data to an Excel Template Lightning Web Component

    To download the template and populate or update the Result data, navigate to the Results table.

    1. Click on the “Download Results” button to download the Results template for a specific Reporting Period and Geographic Area.

    1. A popup window appears to confirm the Excel template download for the selected Reporting Period and Geographic Area.

    1. If there is at least one Project Indicator linked to a Geographic Area and Reporting Period, then selecting “Generate” will generate the Excel Results template, and the user will get an option to “View” and “Download” the template.

      1. Select “View” to preview the file in a new tab.

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

    2. 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 file is posted on Chatter of the related Reporting Period record. 

    3. The downloaded Results 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 AddResults 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. 

    Upload Result Data from an Excel template Lightning Web Component

    After entering the results into the downloaded Results template, you can now upload that template to the Project record in Amp Impact.

    1. Navigate to the “Add Results” page on the Project record and click the “Upload Results” button.

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

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

    4. If the selected file is not validated, a red cross will be displayed next to the attached file, and a list of error messages will be displayed below the attached file.

    5. After validation of the template, click on the “Upload” button to upload the reported Results to the Project.

    6. Click “Upload” to upload the Result data. The popup will display the status of the Result data. The details include:

      1. Number of successfully uploaded Result records;

      2. Number of Result records not uploaded.

    7. To view the success entries in an Excel file, click on the “View Successes” button.

      1. The success log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the success log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions that have been uploaded by selecting “View previous versions”.

      3. The updated ContentVersion file is posted on Chatter of the related Project Geographic Area record.

    8. To view the entries not uploaded in an Excel file, click on the “View Errors” button.

      1. The error log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the error log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions.

      3. The updated ContentVersion file is posted on Chatter of the related Project Geographic Area record.

      4. Refer to the errors listed in the Error log to correct them (see screenshot below).

    9. Once the Results have been uploaded successfully, click on the “Close” button.

    10. The Add Results page will automatically refresh and display the uploaded Results.

    Target Data Visualforce Page

    Download Target Data to an Excel Template Visualforce Page

    1. Navigate to the Results tab and click on the download icon.

    1. Step 1: Generate Excel: This is a confirmation popup to either proceed with generating the Excel template for the selected data or cancel.

    1. Step 2: Download Targets: This is a confirmation popup to either proceed with downloading the Target data from the selected Geographic Area and Reporting Period or cancel.

       

    2. The Excel template with the selected Target 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 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. 

    3. The generated Target 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, 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”.

    Upload Target Data From an Excel Template Visualforce Page

    After entering the Target data into the downloaded Target template, you can now upload that template to the Project record in Amp Impact.

    1. The Target values can be added to the second tab of the downloaded Target template spreadsheet.

    1. Navigate to the Targets tab in Amp Impact and click the upload icon to upload Target data.

    2. Step 1: Drag the .xlsx file over the “Choose File” button or select the template by clicking “Choose File”. Then click “Attach”. Clicking “Cancel” will stop the operation.

    1. Step 2: This is the confirmation popup that validates the Reporting Period, Geographic Area, and Project name of the Target data. Click “Upload” to continue with the Target template upload.

    2. Step 3: Select “Yes” to proceed with the upload or “No” to stop the upload.

    3. Step 4: To view the success entries in an Excel file, click on the “View Successes” button.

      1. The success log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the success log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions that have been uploaded by selecting “View previous versions”.

    4. To view the entries not uploaded in an Excel file, click on the “View Errors” button.

      1. The error log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the error log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions.

    5. Click “Close” to close the popup and automatically refresh the SetTargets page and display the newly updated records.

    Result Data Visualforce Page

    Download Result Data to an Excel Template Visualforce Page

    To download the template and populate or update the Result data, navigate to the Results table.

    1. Click on the download icon to download the Results template for a specific Reporting Period and Geographic Area.

     

    1. Step 1: If there is at least one Project Indicator linked to a Geographic Area and Reporting Period, then selecting “Generate” will generate the Excel Results template.

    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 ContentVersion file is posted on Chatter of the related Reporting Period record. 

    Upload Result Data from an Excel Template Visualforce Page

    After entering the Result data into the downloaded Results template, you can now upload that template to the Project record in Amp Impact.

    1. The Result values can be added to the second tab of the downloaded Results template spreadsheet.

    1. Navigate to the Results tab in Amp Impact and click the upload icon to upload Result data.

    2. Step 1: Drag the .xlsx file over the “Choose File” button or select the template by clicking “Choose File”. Then click “Attach”. Clicking “Cancel” will stop the operation.

    1. Step 2: This is the confirmation popup that validates the Reporting Period, Geographic Area, and Project name of the Result data. Click “Upload” to continue with the Result template upload.

    2. Step 3: Select “Yes” to proceed with the upload or “No” to stop the upload.

    3. Step 4: To view the success entries in an Excel file, click on the “View Successes” button.

      1. The success log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the success log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions that have been uploaded by selecting “View previous versions”.

      3. The rows in the downloaded success log will be ordered by alphabetically ascending Indicator definitions.

    4. To view the entries not uploaded in an Excel file, click on the “View Errors” button.

      1. The error log Excel file will all be stored as ContentVersion files under the Files related list on the relevant Geographic Area.

      2. With each generation of the error log, these ContentVersion files are updated to reflect the last upload date, and the owner of the content version record is updated to the user who last uploaded the Targets. ContentVersion records also allow users to access previous versions.

      3. The rows in the downloaded error log will be ordered by alphabetically ascending Indicator definitions.

      4. Refer to the errors listed in the Error log to correct them (see screenshot below).

    5. Click “Close” to close the popup and automatically refresh the AddResults page and display the newly updated records.