Export text strings to an Excel spreadsheet

If an application supports multiple languages, you can export the text strings for all the application languages to a Microsoft Excel spreadsheet (*.xls). The following versions of Microsoft Excel are supported:
  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 2007
  • Excel 2010
  • Excel 2013
To export text strings in an application to an Excel spreadsheet
  1. In the
    Language Configuration
     dialog box, click
    Export
    .
  2. In the
    Export Operation
     window, select
    Export strings for all languages to an Excel spreadsheet
    .
  3. If you select the
    Optimize duplicate strings
     check box, the strings that appear repeatedly in the application appear only once in the spreadsheet, and need only be translated or edited once. When the file is imported, each instance of a duplicate string is replaced by the same edited or translated string.
  4. If you select the
    Open exported file
     check box, the exported file opens as soon as the export is finished.
  5. Select a destination for the exported text strings.
    TIP:
    • The default name for an exported Excel file is:
      <
      application name
      >_<
      export version number
      >.xls
      For example, Brewery_1.xls
      The first time you export strings to Excel, the export version number is 1. For each subsequent export from the same application, the number increases by 1.
    • When you export strings to an Excel spreadsheet, undefined strings are exported as "**UNDEFINED**". If this is not replaced with a text string during the translation process, an undefined string will be imported into the application.
    • For the instructions on opening a text file in Microsoft Excel, see "Set up language switching" in the
      FactoryTalk View ME
       User's Guide
      .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal