Framework:Multilingual function:Internal data maintenance - Revision history

Admin at 07:37, 6 March 2012

2012-03-06T07:37:45Z

← Older revision		Revision as of 09:37, 6 March 2012
Line 6:		Line 6:
	==Tabelle: sys_ML_Objects==		==Tabelle: sys_ML_Objects==

	{\| ~~cellspacing~~="1" ~~cellpadding~~="~~5" width={{{breite\|~~60%~~}}} border="1~~"		{\| class="wikitable" width="60%"
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~ObjectKey~~'''~~		\| ObjectKey
	\| ~~style=background-color:#f6f6f6 \|'''~~Parameter1~~'''~~		\| Parameter1
	\| ~~style=background-color:#f6f6f6 \|'''~~Parameter2~~'''~~		\| Parameter2
	\| ~~style=background-color:#f6f6f6 \|'''~~Parameter3~~'''~~		\| Parameter3
	\| ~~style=background-color:#f6f6f6 \|'''~~ObjectID~~'''~~		\| ObjectID
	\|-		\|-
	\|63………		\|63………
Line 29:		Line 29:
	==Tabelle: sys_ML_Strings==		==Tabelle: sys_ML_Strings==

	{\| ~~cellspacing~~="1" ~~cellpadding~~="~~5" width={{{breite\|~~60%~~}}} border="1~~"		{\| class="wikitable" width="60%"
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~ObjectID~~'''~~		\| ObjectID
	\| ~~style=background-color:#f6f6f6 \|'''~~RowID~~'''~~		\| RowID
	\| ~~style=background-color:#f6f6f6 \|'''~~Translation~~'''~~		\| Translation
	\|-		\|-
	\|1		\|1

Admin at 10:26, 7 May 2010

2010-05-07T10:26:28Z

← Older revision		Revision as of 12:26, 7 May 2010
Line 1:		Line 1:
	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.		[[Framework:Database_on_SQL_Server\|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:		The two tables are connected as follows:

Admin at 07:09, 6 May 2010

2010-05-06T07:09:59Z

← Older revision		Revision as of 09:09, 6 May 2010
Line 20:		Line 20:
	\|1		\|1
	\|}		\|}


	'''Description of the sys_ML_Objects table'''		'''Description of the sys_ML_Objects table'''
Line 38:		Line 39:
	\|Racebikes		\|Racebikes
	\|}		\|}


	'''Description of the sys_ML_Strings table'''		'''Description of the sys_ML_Strings table'''

Admin at 07:09, 6 May 2010

2010-05-06T07:09:43Z

← Older revision		Revision as of 09:09, 6 May 2010
Line 2:		Line 2:

	The two tables are connected as follows:		The two tables are connected as follows:


	==Tabelle: sys_ML_Objects==		==Tabelle: sys_ML_Objects==

Admin at 07:09, 6 May 2010

2010-05-06T07:09:15Z

← Older revision		Revision as of 09:09, 6 May 2010
Line 2:		Line 2:

	The two tables are connected as follows:		The two tables are connected as follows:


	~~==Table: sys_ML_Objects==~~

	~~{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"~~
	\|-
	~~\| style=background-color:#f6f6f6 \|'''ObjectKey'''~~
	~~\| style=background-color:#f6f6f6 \|'''Parameter1'''~~
	~~\| style=background-color:#f6f6f6 \|'''Parameter2'''~~
	~~\| style=background-color:#f6f6f6 \|'''Parameter3'''~~
	~~\| style=background-color:#f6f6f6 \|'''ObjectID'''~~
	\|-
	~~\|63………~~
	~~\|COPSYS_DIM_NAME~~
	~~\|english~~
	~~\| ~~
	\|1
	\|}


	~~Beschreibung der Tabelle sys_ML_Objects~~

	Diese Tabelle dient als Identifikation des Objekts. Die Spalte ObjectKey beinhaltet den Namen des Objekts. Parameter1 enthält den Namen der Spalte und Parameter2 den Namen der Sprache, in welcher das Objekt übersetzt wurde. Parameter3 hat zurzeit noch keine Funktionalität, ist aber auf Grund von möglichen Erweiterungen integriert worden. Aus der Kombination der Informationen ergibt sich eine Objekt ID, welcher in der Spalte ObjectID gespeichert wird.


	==Tabelle: sys_ML_Objects==		==Tabelle: sys_ML_Objects==

Admin: Created page with '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. T…'

2010-05-06T07:08:51Z

Created page with '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. T…'

New page

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:

==Table: sys_ML_Objects==

{| cellspacing="1" cellpadding="5" width={{{breite|60%}}} border="1"
|-
| style=background-color:#f6f6f6 |'''ObjectKey'''
| style=background-color:#f6f6f6 |'''Parameter1'''
| style=background-color:#f6f6f6 |'''Parameter2'''
| style=background-color:#f6f6f6 |'''Parameter3'''
| style=background-color:#f6f6f6 |'''ObjectID'''
|-
|63………
|COPSYS_DIM_NAME
|english
| 
|1
|}

Beschreibung der Tabelle sys_ML_Objects

Diese Tabelle dient als Identifikation des Objekts. Die Spalte ObjectKey beinhaltet den Namen des Objekts. Parameter1 enthält den Namen der Spalte und Parameter2 den Namen der Sprache, in welcher das Objekt übersetzt wurde. Parameter3 hat zurzeit noch keine Funktionalität, ist aber auf Grund von möglichen Erweiterungen integriert worden. Aus der Kombination der Informationen ergibt sich eine Objekt ID, welcher in der Spalte ObjectID gespeichert wird.

==Tabelle: sys_ML_Objects==

{| cellspacing="1" cellpadding="5" width={{{breite|60%}}} border="1"
|-
| style=background-color:#f6f6f6 |'''ObjectKey'''
| style=background-color:#f6f6f6 |'''Parameter1'''
| style=background-color:#f6f6f6 |'''Parameter2'''
| style=background-color:#f6f6f6 |'''Parameter3'''
| style=background-color:#f6f6f6 |'''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==

{| cellspacing="1" cellpadding="5" width={{{breite|60%}}} border="1"
|-
| style=background-color:#f6f6f6 |'''ObjectID'''
| style=background-color:#f6f6f6 |'''RowID'''
| style=background-color:#f6f6f6 |'''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.

__NOEDITSECTION__

[[Category:Framework Multilingual function|Internal data maintenance]]
[[de:Framework:Mehrsprachigkeit:Interne_Datenhaltung]]