Translating the metadata structure into the target language in Excel is quite straightforward. Simply open the XML file in Excel: choose the default settings As an XML table and Excel will create a schema based on the XML source data.
Identifier is the identifier of the concept, i.e. the word or phrase to be translated. For example, an identifier starting with PropertyDef indicates that it is a property definition name. ObjectType is an object type name and UserGroup is a user group name. M-Files creates these identifiers automatically. The translator does not need to pay much attention to these identifiers as such, although they can be helpful pointers when choosing a suitable translation.
The Source column contains the concepts to be translated. The Target column is empty. The translator enters the translations in this column.
The exported XML table opened in Excel for translation.
In the above example, a translation from English to the target language has been started. The translation for each source language string is to be placed in the target column. When the translation has been added, the 0 in the translated column should be replaced with 1. This tells M-Files that the strings has been translated.