Altbestand unitize_iwm_articles_tvk_2

Definition prüfen

Raw YAML Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

iwm_articles_tvk_2 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_2
Source_Primary_Key: [ordernumber]
Target_Primary_Key: [ordernumber]
Datapool: iwm_articles_tvk_2

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

Mapping:
 ordernumber:
  Source: t1.ORDERNUMBER
 Modellnamen:
  Source: t1.Modellnamen


Sql: SELECT * from ( 
  SELECT ORDERNUMBER, GROUP_CONCAT(TVK_2_PROPERTIES SEPARATOR '|') as Modellnamen 
  FROM `iwm_articles_tkz_2` 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_2
Source_Primary_Key	[ "ordernumber" ]
Target_Primary_Key	[ "ordernumber" ]
Datapool	iwm_articles_tvk_2
Datapool_Definition	{ "ordernumber": "VARCHAR(255) NOT NULL", "Modellnamen": "MEDIUMTEXT DEFAULT NULL" }
Mapping	{ "ordernumber": { "Source": "t1.ORDERNUMBER" }, "Modellnamen": { "Source": "t1.Modellnamen" } }
Sql	SELECT * from ( SELECT ORDERNUMBER, GROUP_CONCAT(TVK_2_PROPERTIES SEPARATOR '\|') as Modellnamen FROM `iwm_articles_tkz_2` group by ORDERNUMBER ) as t1