You can use Salesforce’s Data Loader to export a CSV with all of your Translation records generated from the Fonteva Community Languages tool, apply translations, and then import them back to Salesforce.

If the Data Loader is not already installed in your org, you may need to install it. Follow Salesforce’s instructions for installing on macOS or Windows.

You can find a detailed guide to using the Data Loader here in Salesforce’s Developer Documentation.

Exporting Translation Records

  1. Open the Salesforce Data Loader and select Export.

  2. The Data Loader will require you to log in using your Salesforce credentials. Enter your credentials in the provided fields and click Login.

  3. After successfully logging in, click Next to navigate the second step.

  4. On Step 2: Select Data Objects, select the Translation object from the list of objects provided.

  5. Click Browse and select a location on your device for your CSV to export to.

  6. Click Next to navigate to Step 3: Mapping.

  7. Select fields from the Choose the query fields below box. Ensure you select Framework_Language_Code, Framework_Translation, and Framework_ObjectID or ID.

  8. Click Finish. Files will export into a CSV file in the location you designated.

You will receive a confirmation message when the export is finished detailing the number of successful extractions and errors. You can click View Extraction to view a copy of your CSV export. Click Ok to close.

Importing Translation Records

You can open your CSV document in an external program such as Excel to enter your translations. When you’re ready, you can import your translations back into Salesforce.

  1. Open the Data Loader and click Update. You may be directed to log in. After, click Next to navigate to Step 2: Select Data Objects.

  2. On Step 2, select the Translation object from the list of objects provided.

  3. Click Browse and select the CSV file that holds your translations.

  4. Click Next to navigate to Step 3: Mapping.

  5. A Data Selection modal will open indicating the number of records you will be updating from your selected CSV file. Click Ok.

  6. Step 3 is where you will associate object fields with the columns of your CSV file. Click Create or Edit a Map to open the Mapping Dialog window.

  7. Click Auto-Match Fields to Columns to automatically match fields to your CSV columns. This is the easiest and fasted way to create a mapping.

    1. You also have the option to manually map these fields. Drag and drop fields from the top table down to the bottom table in the Name column for the corresponding column header.

  8. Click Save Mapping to save this mapping for use in the future. A modal will open for you to save your mapping.

  9. Enter a name for your mapping in the modal and select a location to save it in. Click Save.

  10. Click Ok to exit the Mapping Dialog window and return to the Data Loader.

  11. Click Next to navigate to Step 4: Finish.

  12. Click Browse to select a directory to save the success and error files generated when you import your CSV file.

  13. Click Finish.

  14. A confirmation message will open. Click Yes. The Data Loader will begin updating your fields in Salesforce with your CSV.

An Operation Finished message will open when the operation has completed. It will detail the number of successful updates and the number of errors and provide options to view them.

Click Ok to exit this window. If there were no errors, your translations should be updated successfully in Salesforce.