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_properties
Source_Primary_Key: [ordernumber, firma]
Target_Primary_Key: [ordernumber, firma]
Datapool: iwm_additional_properties_new
Datapool_Definition:
ordernumber: VARCHAR(255) NOT NULL
mainnumber: VARCHAR(255) DEFAULT NULL
firma: VARCHAR(255) NOT NULL
propertyGroupName: VARCHAR(255) DEFAULT NULL
propertyValueName: VARCHAR(255) DEFAULT NULL
Mapping:
ordernumber:
Source: t2.ordernumber
mainnumber:
Source: t2.mainnumber
firma:
Source: t2.firma
propertyGroupName:
Source: t2.propertyGroupName
propertyValueName:
Source: t2.propertyValueName
Field_Adapter:
- replace: [',','|']
- replace: [';',',']
Sql: SELECT * FROM (
SELECT ORDERNUMBER as ordernumber, 1 as firma, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName
FROM `iwm_articles_additional_properties`
GROUP BY ORDERNUMBER
UNION ALL
SELECT CONCAT(ORDERNUMBER, '-1') as ordernumber, 1 as firma, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName
FROM `iwm_articles_additional_properties`
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_properties |
| Source_Primary_Key | [ "ordernumber", "firma" ] |
| Target_Primary_Key | [ "ordernumber", "firma" ] |
| Datapool | iwm_additional_properties_new |
| Datapool_Definition | { "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) DEFAULT NULL", "firma": "VARCHAR(255) NOT NULL", "propertyGroupName": "VARCHAR(255) DEFAULT NULL", "propertyValueName": "VARCHAR(255) DEFAULT NULL" } |
| Mapping | { "ordernumber": { "Source": "t2.ordernumber" }, "mainnumber": { "Source": "t2.mainnumber" }, "firma": { "Source": "t2.firma" }, "propertyGroupName": { "Source": "t2.propertyGroupName" }, "propertyValueName": { "Source": "t2.propertyValueName", "Field_Adapter": [ { "replace": [ ",", "|" ] }, { "replace": [ ";", "," ] } ] } } |
| Sql | SELECT * FROM ( SELECT ORDERNUMBER as ordernumber, 1 as firma, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName FROM `iwm_articles_additional_properties` GROUP BY ORDERNUMBER UNION ALL SELECT CONCAT(ORDERNUMBER, '-1') as ordernumber, 1 as firma, ORDERNUMBER as mainnumber, 'Eigenschaften' as propertyGroupName, GROUP_CONCAT(PROPERTIES) as propertyValueName FROM `iwm_articles_additional_properties` GROUP BY ORDERNUMBER ) as t1 |