Framework:Multilingual function:Internal data maintenance: Difference between revisions
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
==Tabelle: sys_ML_Objects== | ==Tabelle: sys_ML_Objects== | ||
{| | {| class="wikitable" width="60%" | ||
|- | |- {{Tabellentitel}} | ||
| | | ObjectKey | ||
| | | Parameter1 | ||
| | | Parameter2 | ||
| | | Parameter3 | ||
| | | ObjectID | ||
|- | |- | ||
|63……… | |63……… | ||
| Line 29: | Line 29: | ||
==Tabelle: sys_ML_Strings== | ==Tabelle: sys_ML_Strings== | ||
{| | {| class="wikitable" width="60%" | ||
|- | |- {{Tabellentitel}} | ||
| | | ObjectID | ||
| | | RowID | ||
| | | Translation | ||
|- | |- | ||
|1 | |1 | ||
Latest revision as of 09:37, 6 March 2012
Data maintenance occurs in two tables, i. e. sys_ML_Objects and sys_ML_Strings. The objects table contains the information as to which object is translated into which language. The strings table contains the translation texts.
The two tables are connected as follows:
Tabelle: sys_ML_Objects
| ObjectKey | Parameter1 | Parameter2 | Parameter3 | ObjectID |
| 63……… | COPSYS_DIM_NAME | english | 1 |
Description of the sys_ML_Objects table
This table serves as identification of the object. The ObjectKey column contains the name of the object. Parameter1 contains the name of the column and Parameter2 the name of the language into which the object has been translated. Parameter3 currently has not yet any functionality but has been integrated with a view to possible extensions. The combination of information results in an OjectID which is saved in the OjbectID column.
Tabelle: sys_ML_Strings
| ObjectID | RowID | Translation |
| 1 | 64……… | Racebikes |
Description of the sys_ML_Strings table
This table contains the actual translations. In the ObjectID column you will find the identification number from the sys_ML_Objects table which has resulted from the above-mentioned criteria. RowID contains the COPSYS_ID of the dataset that has been translated. In the translation column you will find the translated text. Manual modifications in these tables may lead to serious problems.
