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.
#Connections
Source_Config: unitizeEngine #config - credetials of source connection service
Target_Config: enhanceEngine #config - credentials of target connection service
#Engine Mode
Source_Datapool: ost_articles_stock_google_local
Enhance_Mode: flexible
#Engine Mode
Engine_Mode: full
Read_Conditions:
- articles_new.attr1 = 1
Joins:
- Right_Join: #each condition is joined with "AND"
Datapool: dg_supplierdata_enhanced.articles_new
Join_Condition: articles_new.ordernumber = ost_articles_stock_google_local.ordernumber
- Join:
Datapool: dg_supplierdata_enhanced.static_storeids
Join_Condition: static_storeids.firma = 1
Mapping:
store_code:
Source: static_storeids.storeid
ordernumber:
Source: articles_new.ordernumber
creation_date:
Source: articles_new.added
In_Export: no
itemid:
Source: articles_new.ordernumber
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: ostermann_s_articles_details
Identifier: ordernumber
File: ost_articles_stock_google_local.itemid
Fields:
- ArticleId
- ArticleDetailsId
- ordernumber
price:
Source: ost_articles_stock_google_local.ordernumber #to be ignored
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
Cross_Field: price_EK #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
quantity:
Source: articles_new.ordernumber #to be ignored
File_Field_Adapter:
Engine: exportEngine
Datapool: export_articles_stock_ost
Identifier: ordernumber
File: ost_articles_stock_google_local.quantity
Fields:
- ordernumber
- stock_WIT
- stock_BOT
- stock_REC
- stock_HAA
- stock_LEV
availability: (0)
pickup_method: (0)
pickup_sla: (0)
Target_Datapool: ost_articles_stock_google_local
Metadata
Erkannte Konfiguration
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Source_Config | unitizeEngine |
|---|---|
| Target_Config | enhanceEngine |
| Source_Datapool | ost_articles_stock_google_local |
| Enhance_Mode | flexible |
| Engine_Mode | full |
| Read_Conditions | [ "articles_new.attr1 = 1" ] |
| Joins | [ { "Right_Join": null, "Datapool": "dg_supplierdata_enhanced.articles_new", "Join_Condition": "articles_new.ordernumber = ost_articles_stock_google_local.ordernumber" }, { "Join": null, "Datapool": "dg_supplierdata_enhanced.static_storeids", "Join_Condition": "static_storeids.firma = 1" } ] |
| Mapping | { "store_code": { "Source": "static_storeids.storeid" }, "ordernumber": { "Source": "articles_new.ordernumber" }, "creation_date": { "Source": "articles_new.added", "In_Export": "no" }, "itemid": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "ostermann_s_articles_details", "Identifier": "ordernumber", "File": "ost_articles_stock_google_local.itemid", "Fields": [ "ArticleId", "ArticleDetailsId", "ordernumber" ] } }, "price": { "Source": "ost_articles_stock_google_local.ordernumber", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_ost", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "quantity": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "Engine": "exportEngine", "Datapool": "export_articles_stock_ost", "Identifier": "ordernumber", "File": "ost_articles_stock_google_local.quantity", "Fields": [ "ordernumber", "stock_WIT", "stock_BOT", "stock_REC", "stock_HAA", "stock_LEV" ] } }, "availability": "(0)", "pickup_method": "(0)", "pickup_sla": "(0)" } |
| Target_Datapool | ost_articles_stock_google_local |