Translate exported graphic text dictionary files

After you export the dictionary file containing your application text, use Microsoft Excel to edit the text.

To translate an exported dictionary file

1. Open the XML file in Excel. The Open XML dialog box appears.

2. Select As an XML list, then select OK. A message may appear informing you that an XML schema will be created.

3. Select OK.

   The XML file opens in Excel with columns for the:

   • Phrases in your application.

   • Translated phrases from the translator.

   • Translated font name.

   • Translated font properties.

   • Translated font size.

   • Base font properties.

   • Base font size.

   • Context, phrase ID, language ID and foreign language ID.

     

   Important: Only modify data in the Translation, TranslatedFontSize, TranslatedFontName, and TranslatedFontProperty columns. Do not change any column header. Do not insert or delete rows.

4. Type the language-specific text in the Translation column in the row that corresponds with the base language string in the Phrase column.

5. If necessary, change the font parameters for the translated strings. If you only provide a translation, the Galaxy-configured font for the language is used to render the text after the translation is imported. If you specify a font, it overrides the Galaxy-configured font.

   • In TranslatedFontName column, type the font name.

   • In the TranslatedFontProperty column, type the notation for the font properties:

     B = bold

     I = italic

     U = underline

     For example, if you want to the text to be bold, type B in the TranslatedFontProperty column. If you want the text to be bold and underlined, type BU in the TranslatedFontProperty column.

6. Save the file using XML Data as the file type.

   Important: If you save as another file type, such as XML Spreadsheet, Excel changes the schema and the Galaxy cannot load the file. If you change the name of the XML file, the file will not import properly into the Galaxy.