Legacy-Definition sicher vergleichen
Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.
draft
Raw YAML
Dateiinhalt
Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.
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_properties_additional
Source_Primary_Key: [ordernumber]
Target_Primary_Key: [ordernumber]
Datapool: iwm_articles_properties_additional
Datapool_Definition:
ordernumber: VARCHAR(255) NOT NULL
mainnumber: VARCHAR(255) DEFAULT NULL
propertyGroupName: VARCHAR(255) DEFAULT NULL
propertyValueName: MEDIUMTEXT DEFAULT NULL
Mapping:
ordernumber:
Source: t2.ordernumber
mainnumber:
Source: t2.mainnumber
propertyGroupName:
Source: t2.propertyGroupName
propertyValueName:
Source: t2.propertyValueName
Field_Adapter:
- replace: [',','|']
- replace: [';',',']
Sql: SELECT * FROM (
SELECT ORDERNUMBER as ordernumber, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName
FROM `iwm_articles_properties_additional`
GROUP BY ORDERNUMBER
UNION ALL
SELECT CONCAT(ORDERNUMBER, '-1') as ordernumber, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName
FROM `iwm_articles_properties_additional`
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_properties_additional |
| Source_Primary_Key | [ "ordernumber" ] |
| Target_Primary_Key | [ "ordernumber" ] |
| Datapool | iwm_articles_properties_additional |
| Datapool_Definition | { "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) DEFAULT NULL", "propertyGroupName": "VARCHAR(255) DEFAULT NULL", "propertyValueName": "MEDIUMTEXT DEFAULT NULL" } |
| Mapping | { "ordernumber": { "Source": "t2.ordernumber" }, "mainnumber": { "Source": "t2.mainnumber" }, "propertyGroupName": { "Source": "t2.propertyGroupName" }, "propertyValueName": { "Source": "t2.propertyValueName", "Field_Adapter": [ { "replace": [ ",", "|" ] }, { "replace": [ ";", "," ] } ] } } |
| Sql | SELECT * FROM ( SELECT ORDERNUMBER as ordernumber, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName FROM `iwm_articles_properties_additional` GROUP BY ORDERNUMBER UNION ALL SELECT CONCAT(ORDERNUMBER, '-1') as ordernumber, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName FROM `iwm_articles_properties_additional` GROUP BY ORDERNUMBER ) as t1 |