Managing Translations

Manage Translations allows you to create and delete translations, and determine the method used.

Accessing manage translations

1. Select the Consolidate module.
2. Select the Administration category.
3. Expand Foreign Exchange.
4. Click Manage Translations. The Manage Translations dialog appears and contains the following options:
   • Import
   • Manage
   • Export

Importing translations

The import option in the Manage Translations dialog allows you to create and update translation settings in the database from a .csv file.

To import translations:

1. For Option, select Import.
2. Select the .csv file to import from.
3. Click OK. A table will be displayed showing the summary of all actions performed by the import.

.csv file example:

where:

• Source indicates the source currency, enclosed in double quotation marks.
• Target indicates the target currency, enclosed in double quotation marks
• Method indicates the translation method used, enclosed in double quotation marks. The options for translation method include:

  Method	Value
  ASC	TASC
  Elimination Cash Flow	TELIMCF
  IFRS	TIFRS
  Do Not Translate	TNONE

Managing translations

The Manage option in the Manage Translations dialog allows you to create, update and delete translation settings from within the Manage Translations table.

To manage translations:

1. For Option, select Manage.
2. Select the translated currency to manage. In the Manage Translations table the list of translations selected is displayed.

   Note: You may leave the currency selection blank to start with an empty table. This can be used if translations only need to be added; not deleted or modified.

Adding a translation

1. Click Add to add a new translation.

   Note: You can add a new translation that has similar settings by selecting an existing row and clicking duplicate.

2. For each translation fill in the following fields:

   1. Currency: Select the source currency from the list.

   2. Translate To: Select the target currency from the list.

   3. Use Method: Select the translation method to use.

Translations are not added until you click Apply.

Deleting a translation

Delete a translation by selecting the row and clicking delete. The translation is not deleted until you click Apply.

Editing a translation

You can change the method used for a translation by selecting a different one from the list. No changes are applied until you click Apply.

Applying changes

To apply changes to the translations, click Apply.

For new rows in the table

• Each new translation will be created.
• The translate to currency will be updated for the new source currency.
• The entity translation settings will be updated to use the chosen translation method to translate all entities with the Currency as their functional currency to the Translate To currency.

For modified translations:

• The entity translation setting is updated.

For deleted rows:

• Each deleted translation will be confirmed before deleting.
  • If confirmed, the related symbols are deleted. The source currency is removed from the Translate To currency settings.
  • Otherwise, the settings are restored in the table.

Results

• All actions performed are presented at the end of processing with:
  • Each row identified by its row number.
  • The action performed or the reason any error occurred.
• Any valid changes, not cancelled, are applied.

Refreshing the translations

1. Click Refresh to refresh the list of translations.
2. Click Selections to change the selected translation and refresh the list of translations.

In either case, if there are any unapplied changes, you will be prompted to apply or discard any changes that have not yet been applied.

• Choose Apply Changes to apply any changes made, then refresh the list of translations. If there are any errors the refresh will not be performed.
• Choose Discard Changes to discard any changes made, then refresh the list of translations.
• Click Cancel to return to the table without refreshing the list of translations.

Importing into the translations table

1. Click Import to import from a .csv file into the translations table.

2. Select the file to import. See .csv file example: for import file format.

3. Select one of the following options to replace existing rows:

   1. Replace Existing Rows: If this option is checked, all rows in the table view will be cleared and replaced with the translations in the import file.

      Note: This will only clear the translations from the table view. It will NOT delete any translations in the database.

   2. Do Not Replace Existing Rows: If this option is unchecked, all entries in the import file will be appended to the table view.

      Note: Any translations that exist multiple times in the same import file will be initially duplicated in the table view. Any translations that exist in the import file AND already exist in the table prior to import will be initially duplicated in the table view. Once you click Apply, the settings for the last instance of the duplicated translation will be used.

4. Click OK. The file will be imported into the table.
5. Click Apply to save the changes.

Exporting from the translations table

1. Click Export to export from the translations table to a .csv file.
2. Select the .csv file to export to.

   Note: If the file selected does not currently exist, it will be created during the export process.

3. Click OK. A confirmation dialog will appear.
4. Click View File to view the exported file.