Import a translation from an Excel spreadsheet

The System Import Sets application contains four import tables and corresponding transform maps to assist with importing translations from an Excel spreadsheet.

  1. Navigate to System Import Sets > Load Data.
  2. Select Use Existing and the Table name that matches the type of data being imported, as follows.
    • For choices, select the [u_sys_choice] table.
    • For field labels, select the [u_sys_documentation] table.
    • For translated names and fields, select the [u_sys_translated] table.
    • For messages, select the [u_sys_ui_message] table.
    • For translated text, select the [u_sys_translated_text] table.
  3. Select Upload an Excel file, and then click Browse to select the source Excel spreadsheet.
  4. If appropriate, specify the Work sheet and Header row number.
  5. Click Go.

    The translations are now available in the appropriate Import Set Table.

  6. Navigate to System Import Sets > Table Name and review the imported information to verify that the import was successful.
  7. To transform the imported data into the corresponding table, navigate to System Import Sets > Run Transform.
  8. Select the appropriate transform map, as follows.
    Note: Make sure you choose a transform map that has the Run Business Rule option selected. If the transform map does not have this option selected, any customized translations you have may be overwritten during the next upgrade.
    • For choices, select the Sys Choice Translation Map.
    • For field labels, select the Sys Documentation Translation Map.
    • For translated names and fields, select the Sys Translated Translation Map.
    • For messages, select the Sys UI Message Translation Map.
    • For translated text, select the Sys Translated Text Translation Map.
  9. Click Transform.