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.
SAP SuccessFactors Performance Management
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.
- Go to Admin Tools, Company Settings, Manage Form Label Translations > Click Export Form Label Translations.
- You may choose to export all of your labels, or just for a specific form template.
- 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.
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,...)
- 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.
KB article 2576546 - Working with Manage Language Feature - Platform
Manage Languages, SF, success factors, PMGM, PM , KBA , sf performance manage templates , sf performance data management , LOD-SF-PM-ADM , Admin Center, RBP, Permissions and Settings , How To