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.
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.
Raw YAML
Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.
Adapter_Name: iwm_articles_stock
Engine: Unitize
Source_Config: unitizeEngine
Target_Config: enhanceEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: iwm_articles_stock
Target_Datapool: iwm_articles_stock
#Engine_Mode: full
Engine_Mode: delta
Datapool_Definition:
ordernumber: VARCHAR(255) DEFAULT NULL
mainnumber: VARCHAR(255) DEFAULT NULL
firma: INT(11) DEFAULT NULL
anlieferart: VARCHAR(10) DEFAULT NULL
stock: VARCHAR(40) DEFAULT NULL
stock_inventory: VARCHAR(40) DEFAULT NULL
witten: VARCHAR(40) DEFAULT NULL
bottrop: VARCHAR(40) DEFAULT NULL
haan: VARCHAR(40) DEFAULT NULL
recklinghausen: VARCHAR(40) DEFAULT NULL
leverkusen: VARCHAR(40) DEFAULT NULL
stock_local: VARCHAR(40) DEFAULT NULL
Mapping:
ordernumber:
Source: iwm_articles_stock.ordernumber
mainnumber:
Source: iwm_articles_stock.mainnumber
File_Field_Adapter:
File: iwm_articles_stock.mainnumber
title:
Source: iwm_articles_stock.ordernumber
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: name_oms #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
firma: attr1
In_Export: no
attr2:
Source: iwm_articles_stock.ordernumber
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: attr2 #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
firma: attr1
In_Export: no
firma: iwm_articles_stock.firma
anlieferart:
Source: iwm_articles_stock.anlieferart
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_new #name of cross datapool
Cross_Field: anlieferart #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
firma: attr1
witten:
Source: iwm_articles_stock.witten
Field_Adapter:
- replace_empty: 0
bottrop:
Source: iwm_articles_stock.bottrop
Field_Adapter:
- replace_empty: 0
recklinghausen:
Source: iwm_articles_stock.recklinghausen
Field_Adapter:
- replace_empty: 0
haan:
Source: iwm_articles_stock.haan
Field_Adapter:
- replace_empty: 0
leverkusen:
Source: iwm_articles_stock.leverkusen
Field_Adapter:
- replace_empty: 0
stock_inventory:
Source: iwm_articles_stock.stock_inventory
stock:
Source: iwm_articles_stock.stock
Field_Adapter:
- replace_empty: 0
File_Field_Adapter:
File: iwm_articles_stock.stock
stock_local:
Source: iwm_articles_stock.stock
File_Field_Adapter:
File: iwm_articles_stock.stock_local
Metadata
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Adapter_Name | iwm_articles_stock |
|---|---|
| Engine | Unitize |
| Source_Config | unitizeEngine |
| Target_Config | enhanceEngine |
| Mysql_Engine | InnoDB |
| Default_Charset | latin1 |
| Source_Connection_Type | database |
| Source_Database_Connection_Service | DatabaseConnectionService |
| Source_Datapool | iwm_articles_stock |
| Target_Datapool | iwm_articles_stock |
| Engine_Mode | delta |
| Datapool_Definition | { "ordernumber": "VARCHAR(255) DEFAULT NULL", "mainnumber": "VARCHAR(255) DEFAULT NULL", "firma": "INT(11) DEFAULT NULL", "anlieferart": "VARCHAR(10) DEFAULT NULL", "stock": "VARCHAR(40) DEFAULT NULL", "stock_inventory": "VARCHAR(40) DEFAULT NULL", "witten": "VARCHAR(40) DEFAULT NULL", "bottrop": "VARCHAR(40) DEFAULT NULL", "haan": "VARCHAR(40) DEFAULT NULL", "recklinghausen": "VARCHAR(40) DEFAULT NULL", "leverkusen": "VARCHAR(40) DEFAULT NULL", "stock_local": "VARCHAR(40) DEFAULT NULL" } |
| Mapping | { "ordernumber": { "Source": "iwm_articles_stock.ordernumber" }, "mainnumber": { "Source": "iwm_articles_stock.mainnumber", "File_Field_Adapter": { "File": "iwm_articles_stock.mainnumber" } }, "title": { "Source": "iwm_articles_stock.ordernumber", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "articles_new", "Cross_Field": "name_oms", "Mapping": { "ordernumber": "ordernumber", "firma": "attr1" } } } ], "In_Export": "no" }, "attr2": { "Source": "iwm_articles_stock.ordernumber", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "articles_new", "Cross_Field": "attr2", "Mapping": { "ordernumber": "ordernumber", "firma": "attr1" } } } ], "In_Export": "no" }, "firma": "iwm_articles_stock.firma", "anlieferart": { "Source": "iwm_articles_stock.anlieferart", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_new", "Cross_Field": "anlieferart", "Mapping": { "ordernumber": "ordernumber", "firma": "attr1" } } } ] }, "witten": { "Source": "iwm_articles_stock.witten", "Field_Adapter": [ { "replace_empty": 0 } ] }, "bottrop": { "Source": "iwm_articles_stock.bottrop", "Field_Adapter": [ { "replace_empty": 0 } ] }, "recklinghausen": { "Source": "iwm_articles_stock.recklinghausen", "Field_Adapter": [ { "replace_empty": 0 } ] }, "haan": { "Source": "iwm_articles_stock.haan", "Field_Adapter": [ { "replace_empty": 0 } ] }, "leverkusen": { "Source": "iwm_articles_stock.leverkusen", "Field_Adapter": [ { "replace_empty": 0 } ] }, "stock_inventory": { "Source": "iwm_articles_stock.stock_inventory" }, "stock": { "Source": "iwm_articles_stock.stock", "Field_Adapter": [ { "replace_empty": 0 } ], "File_Field_Adapter": { "File": "iwm_articles_stock.stock" } }, "stock_local": { "Source": "iwm_articles_stock.stock", "File_Field_Adapter": { "File": "iwm_articles_stock.stock_local" } } } |