Tips & Tricks #4 : Quickly translate custom labels from Excel to Salesforce using SFDX
Hello everyone, today we will continue our “Tips & Tricks” series. We will evoke a very painful point for me : TRANSLATIONS.
For everyone who has already worked on that, you know that is an endless journey to translate using Salesforce UI. It’s repetitive, it’s long and maybe boring.
So I’m going to share you a trick to go faster in the translation of custom labels using a Excel file and metadata file and a bit of SFDX.
STEP 1 — Generate a CSV template
Just before starting on this topic, I advise you to create all labels before translating them, it’s easier to update a file every time you create a new one, instead of trying to get all at the end of your tasks or project.
So we will see one of Excel template file you can use to do so.
Let’s create 3 columns :
1- Custom Label Name : Use it to store the custom label’s name.
I like to use this naming convention starting with the object name the label refers to, followed by if it’s a button or a checkbox label…, and give an explicit name, for example : CONTRACT_BUTTON_ACCEPT
2 — The native language value : In my example I used English, it will be easier for the person who will translate and you can use this file as a unique repository for the English texts.
3 — The translated value : Insert here the translated text.
First step is now completed and you are wondering how this can be uploaded to Salesforce.
STEP 2 — Convert to Salesforce language
This part will be…
