Altbestand unitize_iwm_articles_tvk_0

Definition prüfen

Raw YAML Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

iwm_articles_tvk_0 Kurzinfo

Raw YAML

Dateiinhalt

Engine: Unitize
Source_Config: importEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: iwm_articles_tkz_0
Source_Primary_Key: [ordernumber]
Target_Primary_Key: [ordernumber]
Datapool: iwm_articles_tvk_0

Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    Synonyme: MEDIUMTEXT DEFAULT NULL

Mapping:
 ordernumber:
  Source: t1.ORDERNUMBER
 Synonyme:
  Source: t1.Synonyme


Sql: SELECT * from ( 
  SELECT ORDERNUMBER, GROUP_CONCAT(PROPERTIES SEPARATOR '|') as Synonyme 
  FROM `iwm_articles_tkz_0` group by ORDERNUMBER ) 
  as t1

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Engine	Unitize
Source_Config	importEngine
Target_Config	unitizeEngine
Mysql_Engine	InnoDB
Default_Charset	latin1
Source_Connection_Type	database
Source_Database_Connection_Service	DatabaseConnectionService
Source_Datapool	iwm_articles_tkz_0
Source_Primary_Key	[ "ordernumber" ]
Target_Primary_Key	[ "ordernumber" ]
Datapool	iwm_articles_tvk_0
Datapool_Definition	{ "ordernumber": "VARCHAR(255) NOT NULL", "Synonyme": "MEDIUMTEXT DEFAULT NULL" }
Mapping	{ "ordernumber": { "Source": "t1.ORDERNUMBER" }, "Synonyme": { "Source": "t1.Synonyme" } }
Sql	SELECT * from ( SELECT ORDERNUMBER, GROUP_CONCAT(PROPERTIES SEPARATOR '\|') as Synonyme FROM `iwm_articles_tkz_0` group by ORDERNUMBER ) as t1