SAP Knowledge Base Article - Public

2072059 - Beta Goal Import Guide for SuccessFactors Goal Management

Symptom

This KB article reviews many of the questions surrounding goals and explains how to perform import actions with them.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Goal Management

Resolution

Note: In the Attachments section below is the full version MS Word document for the Beta Goal Import Configuration Guide containing images and examples

Requirements

  1. Enable the Goal Import feature via Admin Center > Goal Management Feature Settings
  2. In RBP, grant the permission via Admin Center > Manage Permission Roles > Permission... > Manage Goals > Import Goals
  3. In legacy permissions, the permissions can be granted via Admin Center > Administrative Privileges > Manage Goals > Import Goals
  4. The goal import feature can be accessed from Admin CenterGoal Management > Beta Goal Import

Generate a Goal Import Template

IMPORTANT: Do NOT re-use an old template or import file! The system generates a unique CSV Header for each goal plan that will only work for 1 specific goal plan. The first thing to do before importing goal data is to generate a fresh CSV template for the goal import:

  1. Go to Admin Center > Beta Goal Import
  2. Select the goal plan you want to update
  3. Click "Generate CSV Header" button
  4. Save the CSV file
  5. Populate this header template with your goal data to import

2.jpg

Failure to perform this important step could result in goals being imported into the wrong goal plan or your imports to fail with errors.

Considerations

Many of the issues below are current feature limitations that will be addressed in future product releases:

  • A goal can be updated using either the new or old import feature, as long as you have the GUID for that goal
  • Goals created through the UI can be updated through the import feature

Note: This the internal goal ID which is available through the Goal Search export

  • The new goal import can be scheduled through the SuccessFactors Job Scheduler application
  • The total number of goals being imported for all users should be limited within 30,000 goals for add, update, delete, or assign action, meaning you can have one goal in the CSV file being imported for 30,000 users, or two goals in the CSV file being imported for 15,000 users, or overall 30,000 goals in the CSV file for different users
  • The recommended maximum number of entries to add, update, delete, assign is 30,000. This could be 30,000 goals with no sub-goals, or 3,000 goals - each with 10 sub-goal entries (tasks, targets, milestones, metric lookup)
  • The user name filter is the only filter which supports multiple entries in a single row (separated by semi-colons). All other filter columns only support a single entry per row
  • When updating a goal, only the fields to be updated need to be included in the goal. Leaving values blank will not remove the data from the goal. To remove the data, place "\NULL" as the entry for the column
  • Custom fields to be used as filters must be defined in the data model under <custom-filters>
  • One goal should not be defined twice in the same CSV upload file. This means don't put one row in to add a goal and then another row to update that same goal
  • The calculated goal rating (generated through the metric lookup table) cannot be added/updated through the import. To change or set the calculated rating set values for the actual achievement and metric lookup table
  • Date Formats: You must have all date fields in the format mm/dd/yyyy. If, when importing, you get the error message "due parsing error", open the original file in NotePad and check the date format. Even though the format might look correct via MS Excel, you need to confirm by opening the file in a simple text editor
  • Ensure the value field is in an upper case format, for example "Type: OBJECTIVE, METRICLOOKUP"
  • Ensure the action value is in an uppercase format, for example "ACTION: ADD, UPDATE, DELETE"

Configuring Templates To Allow End Users To Import Goals

Managers may be given permission to import goals into their own Goal Plans. Contact SuccessFactors Customer Success to have your Goal Plan template updated

End User (Non-Admin) Upload for goal Create/Update/Delete

The following needs to be added in the goal plan template for the import from goal plan feature:

<permission for="import-goal">
  <description><![CDATA[ Employees' manager can import the goals from the objective plan. ]]></description>
    <role-name><![CDATA[EM]]></role-name>
    <role-name><![CDATA[E]]></role-name>
</permission>

  • With the permission E, employee can go to his goal plan and upload the goals for himself
  • With the permission EM, employee's manager can go to the goal plan of his subordinate and upload the goals for him

Note: For importing the new group goals in the import CSV file, use the TYPE as OBJECTIVE_GROUPV2. The remaining other columns are same as Personal goals

Keywords

SF, Success Factors, PMGM, GM, generate csv header, goal import template, how to import goal, TGM-3710 , KBA , LOD-SF-GM-REP , Reporting and Data Imports Exports , How To

Product

SAP SuccessFactors Performance & Goals all versions

Attachments

Configuration_Guide_New_Goal_Import.docx
EXAMPLE_KPI_Import_Goals_Create_File.csv
EXAMPLE_KPI_Import_Goals_Create_File_Change_File.csv