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_prices
Source_Primary_Key: [ITEMFIRM, ORDERNUMBER, PRVKHS]
Target_Primary_Key: [firma, ordernumber, verkaufshaus] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_articles_prices
Add_Indices:
- Add_Index:
Datapool: iwm_articles_prices
Index_Name: idx_ITEMFIRM_ORDERNUMBER_PRVKHS_DATE_FROM
Fields: ITEMFIRM, ORDERNUMBER, PRVKHS, DATE_FROM
Sql: 'SELECT t1.ORDERNUMBER, t1.MAINNUMBER, t1.PRVKHS, t1.ITEMFIRM, t1.PRICE, t1.PRICE1, t1.PRICE2, t1.ITEMMRP, t1.DATE_FROM, t1.CHANGE_TIME, t1.HWG, t1.VERSANDART, t1.ETIKETTENART from iwm_articles_prices t1
JOIN (SELECT ITEMFIRM, ORDERNUMBER, PRVKHS, MAX(DATE_FROM) as maxdate FROM iwm_articles_prices GROUP BY ITEMFIRM, ORDERNUMBER, PRVKHS) as t2
ON (t1.ITEMFIRM = t2.ITEMFIRM) AND (t1.ORDERNUMBER = t2.ORDERNUMBER) AND (t1.PRVKHS = t2.PRVKHS) AND (t1.DATE_FROM = t2.maxdate)
JOIN (SELECT ITEMFIRM, ORDERNUMBER, PRVKHS, DATE_FROM, MAX(CHANGE_TIME) as maxchangetime FROM iwm_articles_prices GROUP BY ITEMFIRM, ORDERNUMBER, PRVKHS, DATE_FROM) as t3
WHERE (t1.ITEMFIRM = t3.ITEMFIRM) AND (t1.ORDERNUMBER = t3.ORDERNUMBER) AND (t1.PRVKHS = t3.PRVKHS) AND (t2.maxdate = t3.DATE_FROM) AND (t1.CHANGE_TIME = t3.maxchangetime)
GROUP BY t1.ORDERNUMBER, t1.MAINNUMBER, t1.PRVKHS, t1.ITEMFIRM, t1.PRICE, t1.PRICE1, t1.PRICE2, t1.ITEMMRP, t1.DATE_FROM, t1.CHANGE_TIME
ORDER BY ITEMFIRM ASC, PRVKHS DESC, ORDERNUMBER ASC, DATE_FROM DESC, CHANGE_TIME DESC'
Datapool_Definition:
ordernumber: VARCHAR(25) NOT NULL
mainnumber: VARCHAR(25) DEFAULT NULL
verkaufshaus: VARCHAR(255) NOT NULL
firma: INT(11) NOT NULL
lieferant: VARCHAR(50) DEFAULT NULL
abholpreis: VARCHAR(40) DEFAULT NULL
lieferpreis: VARCHAR(40) DEFAULT NULL
vollservicepreis: VARCHAR(40) DEFAULT NULL
pseudoprice: VARCHAR(40) DEFAULT NULL
date_from: VARCHAR(50)
hwg: VARCHAR(20)
etikettenart: VARCHAR(20)
attr18: VARCHAR(20)
attr13: VARCHAR(20)
# montage: VARCHAR(20)
Mapping:
ordernumber:
Source: t1.ORDERNUMBER
mainnumber:
Source: t1.MAINNUMBER
verkaufshaus:
Source: t1.PRVKHS
firma:
Source: t1.ITEMFIRM
lieferant: ()
abholpreis:
Source: t1.PRICE
lieferpreis:
Source: t1.PRICE1
vollservicepreis:
Source: t1.PRICE2
pseudoprice:
Source: t1.ITEMMRP
date_from:
Source: t1.DATE_FROM
hwg:
Source: t1.HWG
etikettenart:
Source: t1.ETIKETTENART
attr18: ()
attr13:
Source: t1.VERSANDART
# montage: ()
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_prices |
| Source_Primary_Key | [ "ITEMFIRM", "ORDERNUMBER", "PRVKHS" ] |
| Target_Primary_Key | [ "firma", "ordernumber", "verkaufshaus" ] |
| Datapool | iwm_articles_prices |
| Add_Indices | [ { "Add_Index": { "Datapool": "iwm_articles_prices", "Index_Name": "idx_ITEMFIRM_ORDERNUMBER_PRVKHS_DATE_FROM", "Fields": "ITEMFIRM, ORDERNUMBER, PRVKHS, DATE_FROM" } } ] |
| Sql | SELECT t1.ORDERNUMBER, t1.MAINNUMBER, t1.PRVKHS, t1.ITEMFIRM, t1.PRICE, t1.PRICE1, t1.PRICE2, t1.ITEMMRP, t1.DATE_FROM, t1.CHANGE_TIME, t1.HWG, t1.VERSANDART, t1.ETIKETTENART from iwm_articles_prices t1 JOIN (SELECT ITEMFIRM, ORDERNUMBER, PRVKHS, MAX(DATE_FROM) as maxdate FROM iwm_articles_prices GROUP BY ITEMFIRM, ORDERNUMBER, PRVKHS) as t2 ON (t1.ITEMFIRM = t2.ITEMFIRM) AND (t1.ORDERNUMBER = t2.ORDERNUMBER) AND (t1.PRVKHS = t2.PRVKHS) AND (t1.DATE_FROM = t2.maxdate) JOIN (SELECT ITEMFIRM, ORDERNUMBER, PRVKHS, DATE_FROM, MAX(CHANGE_TIME) as maxchangetime FROM iwm_articles_prices GROUP BY ITEMFIRM, ORDERNUMBER, PRVKHS, DATE_FROM) as t3 WHERE (t1.ITEMFIRM = t3.ITEMFIRM) AND (t1.ORDERNUMBER = t3.ORDERNUMBER) AND (t1.PRVKHS = t3.PRVKHS) AND (t2.maxdate = t3.DATE_FROM) AND (t1.CHANGE_TIME = t3.maxchangetime) GROUP BY t1.ORDERNUMBER, t1.MAINNUMBER, t1.PRVKHS, t1.ITEMFIRM, t1.PRICE, t1.PRICE1, t1.PRICE2, t1.ITEMMRP, t1.DATE_FROM, t1.CHANGE_TIME ORDER BY ITEMFIRM ASC, PRVKHS DESC, ORDERNUMBER ASC, DATE_FROM DESC, CHANGE_TIME DESC |
| Datapool_Definition | { "ordernumber": "VARCHAR(25) NOT NULL", "mainnumber": "VARCHAR(25) DEFAULT NULL", "verkaufshaus": "VARCHAR(255) NOT NULL", "firma": "INT(11) NOT NULL", "lieferant": "VARCHAR(50) DEFAULT NULL", "abholpreis": "VARCHAR(40) DEFAULT NULL", "lieferpreis": "VARCHAR(40) DEFAULT NULL", "vollservicepreis": "VARCHAR(40) DEFAULT NULL", "pseudoprice": "VARCHAR(40) DEFAULT NULL", "date_from": "VARCHAR(50)", "hwg": "VARCHAR(20)", "etikettenart": "VARCHAR(20)", "attr18": "VARCHAR(20)", "attr13": "VARCHAR(20)" } |
| Mapping | { "ordernumber": { "Source": "t1.ORDERNUMBER" }, "mainnumber": { "Source": "t1.MAINNUMBER" }, "verkaufshaus": { "Source": "t1.PRVKHS" }, "firma": { "Source": "t1.ITEMFIRM" }, "lieferant": "()", "abholpreis": { "Source": "t1.PRICE" }, "lieferpreis": { "Source": "t1.PRICE1" }, "vollservicepreis": { "Source": "t1.PRICE2" }, "pseudoprice": { "Source": "t1.ITEMMRP" }, "date_from": { "Source": "t1.DATE_FROM" }, "hwg": { "Source": "t1.HWG" }, "etikettenart": { "Source": "t1.ETIKETTENART" }, "attr18": "()", "attr13": { "Source": "t1.VERSANDART" } } |