Fast - Load Cost Values

To initiate a cost value upload, you must select the Import Data Type as Cost Values (Time Phased).

This article covers:

• Integration Steps Overview
• Data Preparation
• How-to Steps

Overview

The upload process is the same as benefits or initiative upload. You'll need to complete the following steps.

1. Prepare the excel template with data. 
2. Identify the initiative where cost profiles are defined.
3. Enable Integrations for this initiative's classification.
4. Upload the excel sheet into Amplify.
5. Map columns in the excel sheet to corresponding cost attributes.
6. Process the mapping.

When the integration is complete, all Excel sheet values are added to corresponding benefits in Amplify.

Data Preparation

For data preparation:

Use the Configuration and FastLoad Spreadsheet as a template to create a new upload file. Click here to download this file. Add the following column information into the  Cost Value FastLoad Sheet and save the template in a new name. 

• Cost External ID or Amplify ID
• Cost Name 
• Cost Category
• Series 
• Date 
• Value 

You can create data files from scratch or use existing files after modifying the required data.

Steps

To fast load cost values:

1. Locate the parent initiative and click Integrations.
2. Click New Integration.
   The New Integration form displays.
   
   
   
3. Type in a relevant name for this integration in the Name field.
4. Select Import Data Type as Cost Values (Time Phased). 
5. Click Save.
   Click Run. Note: Ensure that the excel template is ready with valid data. All required columns should be present and filled with data before uploading. 
6. Select Upload New. Note: This option will not display if this is the initial upload.
7. Click Choose File, and select the excel file containing the cost data. 
   • Select Use Previous if you have the used the excel template previously for this integration. When you select an existing file for the same integration instance, you do not need to map the attributes again; Amplify remembers the previous mapping done for this file. However, if you have included additional columns in the excel template since last integration, it is best to select Upload New.
8. Select the Header option if you want to see the first row values in your excel file displayed as headers on the mapping interface. 
9. In the Sheet drop-down field, select the sheet within the template where benefit value data is stored. 

10. Click Continue to proceed. Clicking Cancel will cancel the entire operation.
    The integration interface displays. 

11. The first row in the excel sheet displays as the header row on the interface. Values included in your excel sheet are listed below the header row. Your next step would be to map each header to a corresponding benefit value attribute.

12. Click Edit Mapping.
    
    
    The fields to be mapped display. Refer to Data Mapping Specifications for guidelines on mapping.

13. Click Preview when done. The preview shows mapping mismatches if any. Hover over the error icon to view the error text. 

    Remap faulty columns and preview until all mappings are correct. The Import button will not be enabled until all errors are corrected. Note: To correct some errors, you may need to modify the data in the excel sheet or make changes within Amplify. It is best to delete the previous integration and create a new integration in such situations.  In addition to errors, you may see warnings. Warnings do not block the import process; you can proceed if you are ready to overlook them. 

14. Click Import...when all mismatches are corrected, and the green tick mark shows against all mapped rows.
15. Click Confirm on the confirmation message that displays.
    
    
16. Click End Session when the message All rows successful is displayed at the top of the interface. You can then navigate to the Costs menu and confirm if the values were uploaded correctly within the relevant cost profiles.