Salesforce Marketing Cloud now supports the translation of Multirow DataExtensions. Multirow DataExtensions allows importing and exporting of multiple rows per a single locale in a DataExtension. DataExtensions are used to dynamically fill email templates with text. For example, Data Extensions typically contain a row for each component or content item in an email. Primary keys specify the identifier of the email component the row belongs to.
Prerequisite
All of your data extensions that need to be translated should use the same configuration. To ensure your data extensions are configured accordingly, please contact your Smartling Representative and provide the following information:
- Data Extension attribute/column name that contains language
- e.g. "locale", "locale_code", "User_Language__c"
- Language value for the source content
- e.g. "en_gb", "default", "English"
For more information on how to use data extensions, read Salesforce Marketing Cloud documentation.
String Parsing
DataExtension is a table-like entity in Salesforce Marketing Cloud. It has a column definition (schema) where each column is specified with its type and “primary key” flag. For this reason, each row in the table is parsed as a unique string in Smartling. If content in multiple rows should be translated as one string in Smartling, ensure they are in the one row in the table. For more information, read our documentation on strings.
In the Data Extensions table, the first column, typically known as the language column, should specify the source locale using the correct source locale code.
Translating Multirow Data Extensions
When you have completed the table in Salesforce and are ready to translate, follow these simple steps;
- Go to your Salesforce Marketing Cloud project in Smartling
- Click the Salesforce tab
- Choose Multirow Data Extension from the Salesforce filter
- Select the assets for translations
- Click Actions > Request Translation
- Choose the target languages
- Click Authorize. Content will be authorized into the Default Workflow for each selected language.
When the translations are complete, Smartling will populate the Data Extension table with the target language translations, under the source content. The same number rows will be seen in the target language as the source.
For more information, read Translating with Salesforce Marketing Cloud.