Mapping Languages Dictionnaries

The Mapping Language Dictionaries feature lets you define scripts that update the SEI internal dictionary using data from external dictionaries. The internal dictionary stores table and field descriptions in multiple languages.

You must click Refresh to update the status or reload the list after changes.

When to map languages

• Maintaining multilingual consistency: Ensure that all users see up-to-date, accurate descriptions in their preferred language by updating the internal dictionary regularly.
• Automating large-scale translations: Use scripts to efficiently populate translations for multiple tables or fields, reducing manual data entry.

Create a script

1. From the navigation panel, click the gear icon at the bottom. The Administration page opens.
2. Select Mapping Language Dictionaries from the menu.
3. Click Add New Record.
4. Enter the required fields.
5. Click Create.

Edit a script

1. In the Mapping Language Dictionaries window, select the script you want to edit.
2. Click the pencil icon.
3. Make the relevant changes.
4. Click Update.

Delete a script

1. In the Mapping Language Dictionaries window, select the script you want to delete.
2. Click the trash icon.
3. Click Delete to confirm.

Language dictionnaries properties

Field	Description
Script Description	Enter a description for the script.
Type	Select whether the script updates a table or a field.
Data Sources	Choose the data source used to execute the script.
Script Content	Provide the SQL statement that retrieves the required information from the data source.
Table Name	Specify the column from the SQL script that contains the table name.
Field Name	Specify the column from the SQL script that contains the field name.
Table Description	Specify the column from the SQL script that contains the description of the table or field.
Language	Define the dynamic parameter in the script. This will be replaced by the selected language during execution.

Run a script

1. In the Mapping Language Dictionaries window, select an existing script from the list.
2. Click the Run Script button next to each scripts.
3. Map the SEI Language code with your ERP language code by entering the reference in the Source Language column, taking case sensitivity into account.
   For example, English is defined as en in SEI—while your ERP might use ENG or EN.
4. Click Next.
5. Select the environments where you created your data source, and for each, select the relevant database schema from the dropdowm list. The schema should relate to the tables and fields you want to retrieve descriptions for.
6. Click Confirm.
   In the Status column, you’ll see Running.
   The script runs as a batch job, which may take a minute or two.
7. After the script runs, verify results in the Status column:
   • Executed successfully for success
   • Executed with errors if problems occur

tip

You can cancel execution by clicking Stop. The status will update when the process completes.