When you choose value translation for an attribute in a directory server, and click the edit button, you will be provided with an interface to set up value translation.
Figure 9: Value translation
Entering values manually
You can provide the values and their translations manually. To do this, uncheck the use lookup table checkbox. Click on the button add to add a new value / translation pair. The value is the value that is present in the stakeholders directory and the translation is the name that you wish to give this value. When you are done adding value / translation pairs, click the OK button. Each value that is found in the stakeholder directory will be translated if a matching value is found in the list that you create.
Using a lookup table
Check the use lookup table checkbox. You can then enter the name of the table that contains the values and translations for the value translation. This table has to reside in the same database as the table that contains the stakeholders. The connection url, username and password that you have provided in the general tab of the directory server will be used to connect to the table. Click the connect button to connect to the table. You will then be provided with a list of the columns in the table. You can choose which column holds the values and which column holds the translations. Click on the preview button to see a preview of the value translation list. Each value for the attribute in the stakeholder table will be translated using the value and translation columns of the value translation table that you have provided.