SAP Knowledge Base Article - Public

2076045 - Importing Exporting Form Label Translations in Performance Management

Symptom

How can I export my Form Label Translations for Localized (Multi-lingual) form templates?

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 Performance Management

Resolution

You have the option using message keys (msgKey) to export your existing Form Label Translation file so edits can be made and re-imported.

Note: This enhancement pertains to customers using multi-lingual, or “localized” form templates.

  1. Go to Admin Tools, Company Settings, Manage Form Label Translations > Click Export Form Label Translations.

1.jpg

  1.  You may choose to export all of your labels, or just for a specific form template.

2.jpg

  1. Make any changes and/or additions to the form labels
    • Note - Will get an error if fields are blank so you will need to delete the columns for any languages that you are not using.  
  2. Once your edits are complete, the updated labels can be imported by clicking "Import Form Label Translation File" and selecting the load file your prepared.

3.jpg

Considerations When Making Changes:

  • Always begin with a fresh export of the label translations.
  • Always make an unedited backup of your exported file before making any changes.
  • Always verify the data in your CSV file, make sure the text displays correctly and does not have any invalid characters or corrupted data before re-importing any file.
  • When exporting the form label translation file from the system it is recommended to save the file in .CSV format, it is best not to open directly in Excel. By default Excel will convert the UTF8 text, some characters are not supported and will appear corrupted.
  • Some applications, such as Open Office, will allow you to define the character encoding while opening the file. Select Unicode (UTF8)
  • It is recommended to select Unicode (UTF-8) as the character set when opening the file.  After making your changes, remember to save the file as a .CSV format
  • To edit UTF8 files in Excel you will need to open a blank workbook and import the CSV file. (exact menus/options may vary based on your version of Excel)
    • From a blank workbook, select: Data > Get/Import Data > From File > From Text/CSV
    • Browse to and select your CSV file
    • A dialog box will open, select Unicode (UTF8) from the File Origin drop-down
      • Depending on your version, when you click "Load" Excel may add a header to the file (Column 1, Column 2...). you can cut and paste the correct values (row 2) into the header (row 1) then delete row 2. 
      • To prevent Excel from adding an extra row, instead of clicking "Load" click "Transform Data", then choose "Use First Row as Headers" before clicking "Close & Load" (make sure the first row matches the header row of the export file - label_key, default, en_US,...)
      • The default column is required to avoid errors after import.
  • With the exception of the header (first row), delete all rows you are not making changes to. In other words, only rows that are being updated/added need to be included in the load file.
  • When saving the file, save it as a Unicode .CSV file, in Excel you will need to "Save As" and select "CSV UTF-8 (Comma delimited)(*.csv)"
  • When importing the file, select the file encoding that matches your load file. As mentioned above Unicode (UTF-8) is recommended to ensure support for all characters/languages.

See Also

KB article 2576546 - Working with Manage Language Feature - Platform

Keywords

Manage Languages, SF, success factors, PMGM, PM, The field value for column [default] is empty , KBA , sf performance manage templates , sf performance data management , LOD-SF-PM-ADM , Admin Center, RBP, Permissions and Settings , How To

Product

SAP SuccessFactors Performance & Goals all versions