Skip to main content
Solved

Mass importing translations through Excel into SF / IAM

  • February 6, 2025
  • 2 replies
  • 50 views
Dennis1690
Vanguard
Forum|alt.badge.img+4

For expansion of our application we want to add a complete translation for an other language than Dutch and English. We do not have access to AI functionalities due to company policies so we can’t use that.

Is there a way to prepare translations in Excel and import those into SF/ IAM (or any other way)?

 

Thanks in advance.

Best answer by Jeroen van den Belt

Hi ​@Dennis1690,

This should be possible. We also do something like this ourselves with new translations each platform release.

  1. In the SF, navigate from the default menu to the advanced menu
  2. Go to Model management > Translations
  3. Set a filter to the desired model and branch
  4. Make an export of this data
    1. Advanced options
    2. Export all rows in the grid
    3. Select all columns
    4. Choose a file destination. Both for Headers and Data, select the option to export the ID's. This will help you later on during the import.
    5. Export
  5. In Excel, replace the value for the appl_lang_id column with the desired language code.
    1. In the Advanced menu, go to Master data > Model > Application languages to find the language code corresponding with your desired language.
  6. In Excel, replace all transl-related columns with the translation of the desired language.
  7. In the SF, navigate from the default menu to the advanced menu
  8. Go to Model management > Translations
  9. Import the Excel with the translated data
    1. Both for Headers and Data, keep the option to import the data based on the ID's intact.
    2. Ensure all columns from the Excel are mapped correctly to the columns in the SF.
    3. Determine the desired value for the column ‘Approval status’. You can choose to directly ‘Approve’ the translations, saving you from validations to do this afterwards. However, if you would like someone to review them from within the SF, fill them with ‘Not yet approved’.
    4. Import

Hopefully this overview helps. Don't hesitate to reach out when you get stuck at a certain step.

View original
Clear Skies
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Hi ​@Dennis1690,

This should be possible. We also do something like this ourselves with new translations each platform release.

  1. In the SF, navigate from the default menu to the advanced menu
  2. Go to Model management > Translations
  3. Set a filter to the desired model and branch
  4. Make an export of this data
    1. Advanced options
    2. Export all rows in the grid
    3. Select all columns
    4. Choose a file destination. Both for Headers and Data, select the option to export the ID's. This will help you later on during the import.
    5. Export
  5. In Excel, replace the value for the appl_lang_id column with the desired language code.
    1. In the Advanced menu, go to Master data > Model > Application languages to find the language code corresponding with your desired language.
  6. In Excel, replace all transl-related columns with the translation of the desired language.
  7. In the SF, navigate from the default menu to the advanced menu
  8. Go to Model management > Translations
  9. Import the Excel with the translated data
    1. Both for Headers and Data, keep the option to import the data based on the ID's intact.
    2. Ensure all columns from the Excel are mapped correctly to the columns in the SF.
    3. Determine the desired value for the column ‘Approval status’. You can choose to directly ‘Approve’ the translations, saving you from validations to do this afterwards. However, if you would like someone to review them from within the SF, fill them with ‘Not yet approved’.
    4. Import

Hopefully this overview helps. Don't hesitate to reach out when you get stuck at a certain step.

Mark Jongeling
Dennis1690
2 people like this
  • Mark Jongeling
    Mark Jongeling
  • Dennis1690
    Dennis1690
Dennis1690
Vanguard
Forum|alt.badge.img+4
  • Dennis1690Vanguard
  • Author
  • Vanguard
  • 25 replies
  • February 10, 2025

Thanks Jeroen, Ill go to work with this. I'll keep you posted in case of succes or if stuck. Thanks again.

Clear Skies
Jeroen van den Belt
1 person likes this
  • Jeroen van den Belt
    Jeroen van den Belt
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings