Legacy YAML / Detail

enhance / articles_stock_tre_google_local

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live

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.

engine Typ
valid Parse-Status
Managed Status
draft
enhanceEngine Kurzinfo

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: tre_articles_stock_google_local

Enhance_Mode: flexible

#Engine Mode
Engine_Mode: full

Read_Conditions:
  - articles_new.attr1 = 3

Joins:
  - Right_Join: #each condition is joined with "AND"
    Datapool: dg_supplierdata_enhanced.articles_new
    Join_Condition: articles_new.ordernumber = tre_articles_stock_google_local.ordernumber
  - Join:
    Datapool: dg_supplierdata_enhanced.static_storeids
    Join_Condition:  static_storeids.firma = 3

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: trends_s_articles_details
      Identifier: ordernumber
      File: tre_articles_stock_google_local.itemid
      Fields:
        - ArticleId
        - ArticleDetailsId
        - ordernumber
  price:
    Source: tre_articles_stock_google_local.ordernumber #to be ignored
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_iwm_articles_prices_tre #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_tre
      Identifier: ordernumber
      File: tre_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: tre_articles_stock_google_local



Filters:
  - Filter:
      name: DuplicateOrdernumber
      condition:
        Cross_Dataset_Filter_Adapter: filterByDuplicateOrdernumber
      reason: 'There is another dataset with this ordernumber'

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 tre_articles_stock_google_local
Enhance_Mode flexible
Engine_Mode full
Read_Conditions [ "articles_new.attr1 = 3" ]
Joins [ { "Right_Join": null, "Datapool": "dg_supplierdata_enhanced.articles_new", "Join_Condition": "articles_new.ordernumber = tre_articles_stock_google_local.ordernumber" }, { "Join": null, "Datapool": "dg_supplierdata_enhanced.static_storeids", "Join_Condition": "static_storeids.firma = 3" } ]
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": "trends_s_articles_details", "Identifier": "ordernumber", "File": "tre_articles_stock_google_local.itemid", "Fields": [ "ArticleId", "ArticleDetailsId", "ordernumber" ] } }, "price": { "Source": "tre_articles_stock_google_local.ordernumber", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_tre", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "quantity": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "Engine": "exportEngine", "Datapool": "export_articles_stock_tre", "Identifier": "ordernumber", "File": "tre_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 tre_articles_stock_google_local
Filters [ { "Filter": { "name": "DuplicateOrdernumber", "condition": { "Cross_Dataset_Filter_Adapter": "filterByDuplicateOrdernumber" }, "reason": "There is another dataset with this ordernumber" } } ]