Legacy YAML / Detail

export / export_articles_oms_test-dev

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
Zurück zum Browser
Managed Definition öffnen

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.

Zum Raw YAML Zu den Metadaten
engine Typ
valid Parse-Status
Managed Status
draft
export_articles_oms_test_dev 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: enhanceEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Source_Datapool: articles_new  #sql from

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma # One row per JOIN
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_new_bssp_and_auslauf
  Join_Condition: articles_new.ordernumber = iwm_articles_new_bssp_and_auslauf.ordernumber AND articles_new.attr1 = iwm_articles_new_bssp_and_auslauf.firma and (iwm_articles_new_bssp_and_auslauf.verkaufshaus = 86 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 87)


Read_Conditions:  #sql where - Read-Filter
  - articles_new.active_oms = 1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles_new.ordernumber
 mainnumber:
  Source: articles_new.mainnumber
 name:
  Source: articles_new.name_ost
 supplier:
  Source: articles_new.supplier_oms
 tax:
  Source: articles_new.tax
 price_EK:
  Source: articles_new.price_oms
  Field_Adapter:
    - replace: [',', '']
    - replace: ['.', ',']
 pseudoprice_EK:
   Source: articles_new.pseudoprice_oms
   Field_Adapter:
     - replace: [',', '']
     - replace: ['.', ',']
 baseprice_EK: (0)
 active:
   Source: articles_new.active_oms
 configurator_options:
   Source: articles_new.configuratorOptions
 description_long:
  Source: articles_new.description_long_oms
  Field_Adapter:
      - replace: [';', '']
 supplier_number: articles_new.suppliernumber
 attr1:
    Source: articles_new.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles_new.attr2
     Field_Adapter:
       - replace: [';', '']
 attr3:
     Source: articles_new.attr3
     Field_Adapter:
       - replace: [';', '']
 attr4:
     Source: articles_new.attr4
     Field_Adapter:
       - replace: [';', '']
 attr5:
     Source: articles_new.attr5
     Field_Adapter:
       - replace: [';', '']
 attr6:
     Source: articles_new.swag_attr22
     Field_Adapter:
       - replace: [';', '']
 attr7:
     Source: articles_new.attr7
     Field_Adapter:
       - replace: [';', '']
 attr8:
     Source: articles_new.attr8
     Field_Adapter:
       - replace: [';', '']
 attr9:
     Source: articles_new.attr9
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles_new.swag_attr25
     Field_Adapter:
       - replace: [';', '']
 attr11:
     Source: articles_new.attr11
     Field_Adapter:
       - replace: [';', '']
 attr12:
     Source: articles_new.attr12
     Field_Adapter:
       - replace: [';', '']
 attr13:
     Source: articles_new.attr13
     Field_Adapter:
       - replace: [';', '']
 attr14:
     Source: articles_new.attr14
     Field_Adapter:
       - replace: [';', '']
 attr15:
     Source: articles_new.attr15
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: shippingcosts #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
     Field_Adapter:
       - replace: [';', '']
       - replace: [',','.']
 attr16:
     Source: articles_new.attr16
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms
        Cross_Field: montage
        Local_Key: ordernumber
        Cross_Key: ordernumber
     File_Field_Adapter:
        File: export_articles_oms_test_dev.attr16
 attr17:
     Source: articles_new.swag_attr24
     Field_Adapter:
       - replace: [';', '']
 attr18: (0)
 attr19:
     Source: articles_new.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles_new.name_oms
     Field_Adapter:
       - replace: [';', '']
 attr23:
     Source: articles_new.swag_attr23
     Field_Adapter:
       - replace: [';', '']
 ean: articles_new.ean
 stock_witten:
     Source: iwm_articles_stock.witten
     Field_Adapter:
       - replace_empty: 0
     In_Export: no
 shipping_free:
   Source: articles_new.shippingfree
   File_Field_Adapter:
    Engine: importEngine
    Datapool: static_filter_shippingfree
    Identifier: id
    Fields:
      - supplier_number
      - attr1
      - attr2
      - attr3
      - attr4
      - ordernumber
      - id
      - shop
 kind: articles_new.kind
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 weight:
  Source: articles_new.weight
 bestellsperre: IF (iwm_articles_new_bssp_and_auslauf.bestellsperre = '', articles_new.bestellsperre, iwm_articles_new_bssp_and_auslauf.bestellsperre) as bestellsperre
 auslaufkennzeichen: IF (iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen = '', articles_new.auslaufkennzeichen, iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen) as auslaufkennzeichen



Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: Mindestbestand  #there must always be a space between the key and the comparision operator
    condition: (price_EK < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Preis ungueltig'
    condition: (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
    reason: 'alle Preise = 0'
 - Filter:
    name: 'Lieferant gesperrt'
    condition: (supplier == 'Wimmer Wohnkollektion GmbH')
    reason: 'Lieferant gesperrt'
 - Filter:
    name: 'Zu lange Lieferzeit'
    condition: (attr11 == 'L') and (attr12 > 6) and (stock == 0) and (attr2 > 89)
    reason: 'Zu lange Lieferzeit'
 - Filter:
    name: 'Zu lange Lieferzeit Suppliernumber 782577'
    condition: (attr11 == 'L') and (attr12 > 4) and (stock == 0) and (supplier == 'HPI')
    reason: 'Zu lange Lieferzeit Suppliernumber 782577'
 - Filter:
    name: 'Onlinesperre'
    condition:
      In_Pool_Filter_Adapter:
        Config: enhanceEngine
        Datapool: filter_onlinesperre
        Local_Key: supplier_number
        Cross_Key: LIEFNR
    reason: 'Onlinesperre'
 - Filter:
    name: Auslauf und kein Bestand in Witten - Lagerware
    condition: (auslaufkennzeichen == 'J') and (stock_witten == 0) and (price_EK < 149) and (attr11 == 'L')
    reason: Auslauf und kein Bestand in Witten - Lagerware
 - Filter:
    name: Auslauf und nirgendwo Bestand - Lagerware
    condition: (auslaufkennzeichen == 'J') and (stock == 0) and (price_EK > 149) and (attr11 == 'L')
    reason: Auslauf und nirgendwo Bestand - Lagerware
 - Filter:
    name: Auslauf und nirgendwo Bestand - Bestellware
    condition: (auslaufkennzeichen == 'J') and (attr1 == 1) and (attr2 > 80) and (attr11 == 'B') and (stock == 0)
    reason: Auslauf und nirgendwo Bestand - Bestellware
 - Filter:
    name: Bestellsperre und kein Bestand
    condition: (bestellsperre == 'J') and (stock == 0)
    reason: Bestellsperre und kein Bestand

#Target
Datapool: export_articles_oms_test_dev #sql table
Primary_Key: [ordernumber, attr1]

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Source_Config enhanceEngine
Target_Config exportEngine
Source_Datapool articles_new
Joins [ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma" }, { "Left_Join": null, "Datapool": "iwm_articles_new_bssp_and_auslauf", "Join_Condition": "articles_new.ordernumber = iwm_articles_new_bssp_and_auslauf.ordernumber AND articles_new.attr1 = iwm_articles_new_bssp_and_auslauf.firma and (iwm_articles_new_bssp_and_auslauf.verkaufshaus = 86 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 87)" } ]
Read_Conditions [ "articles_new.active_oms = 1" ]
Mapping { "ordernumber": { "Source": "articles_new.ordernumber" }, "mainnumber": { "Source": "articles_new.mainnumber" }, "name": { "Source": "articles_new.name_ost" }, "supplier": { "Source": "articles_new.supplier_oms" }, "tax": { "Source": "articles_new.tax" }, "price_EK": { "Source": "articles_new.price_oms", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "pseudoprice_EK": { "Source": "articles_new.pseudoprice_oms", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "baseprice_EK": "(0)", "active": { "Source": "articles_new.active_oms" }, "configurator_options": { "Source": "articles_new.configuratorOptions" }, "description_long": { "Source": "articles_new.description_long_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "supplier_number": "articles_new.suppliernumber", "attr1": { "Source": "articles_new.attr1", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr2": { "Source": "articles_new.attr2", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr3": { "Source": "articles_new.attr3", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr4": { "Source": "articles_new.attr4", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr5": { "Source": "articles_new.attr5", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr6": { "Source": "articles_new.swag_attr22", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr7": { "Source": "articles_new.attr7", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr8": { "Source": "articles_new.attr8", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr9": { "Source": "articles_new.attr9", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr10": { "Source": "articles_new.swag_attr25", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr11": { "Source": "articles_new.attr11", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr12": { "Source": "articles_new.attr12", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr13": { "Source": "articles_new.attr13", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr14": { "Source": "articles_new.attr14", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr15": { "Source": "articles_new.attr15", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "shippingcosts", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ";", "" ] }, { "replace": [ ",", "." ] } ] }, "attr16": { "Source": "articles_new.attr16", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "montage", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "File_Field_Adapter": { "File": "export_articles_oms_test_dev.attr16" } }, "attr17": { "Source": "articles_new.swag_attr24", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr18": "(0)", "attr19": { "Source": "articles_new.attr19", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr20": { "Source": "articles_new.name_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr23": { "Source": "articles_new.swag_attr23", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "ean": "articles_new.ean", "stock_witten": { "Source": "iwm_articles_stock.witten", "Field_Adapter": [ { "replace_empty": 0 } ], "In_Export": "no" }, "shipping_free": { "Source": "articles_new.shippingfree", "File_Field_Adapter": { "Engine": "importEngine", "Datapool": "static_filter_shippingfree", "Identifier": "id", "Fields": [ "supplier_number", "attr1", "attr2", "attr3", "attr4", "ordernumber", "id", "shop" ] } }, "kind": "articles_new.kind", "stock": { "Source": "iwm_articles_stock.stock", "Field_Adapter": [ { "replace_empty": 0 } ] }, "weight": { "Source": "articles_new.weight" }, "bestellsperre": "IF (iwm_articles_new_bssp_and_auslauf.bestellsperre = '', articles_new.bestellsperre, iwm_articles_new_bssp_and_auslauf.bestellsperre) as bestellsperre", "auslaufkennzeichen": "IF (iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen = '', articles_new.auslaufkennzeichen, iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen) as auslaufkennzeichen" }
Filters [ { "Filter": { "name": "Mindestbestand", "condition": "(price_EK < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')", "reason": "Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)" } }, { "Filter": { "name": "Mindestbestand", "condition": "(price_EK < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')", "reason": "Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)" } }, { "Filter": { "name": "Mindestbestand", "condition": "(price_EK < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')", "reason": "Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)" } }, { "Filter": { "name": "Preis ungueltig", "condition": "(price_EK == '') or (price_EK == '0.00') or (price_EK == '0,00') or (price_EK == '0,0')", "reason": "alle Preise = 0" } }, { "Filter": { "name": "Lieferant gesperrt", "condition": "(supplier == 'Wimmer Wohnkollektion GmbH')", "reason": "Lieferant gesperrt" } }, { "Filter": { "name": "Zu lange Lieferzeit", "condition": "(attr11 == 'L') and (attr12 > 6) and (stock == 0) and (attr2 > 89)", "reason": "Zu lange Lieferzeit" } }, { "Filter": { "name": "Zu lange Lieferzeit Suppliernumber 782577", "condition": "(attr11 == 'L') and (attr12 > 4) and (stock == 0) and (supplier == 'HPI')", "reason": "Zu lange Lieferzeit Suppliernumber 782577" } }, { "Filter": { "name": "Onlinesperre", "condition": { "In_Pool_Filter_Adapter": { "Config": "enhanceEngine", "Datapool": "filter_onlinesperre", "Local_Key": "supplier_number", "Cross_Key": "LIEFNR" } }, "reason": "Onlinesperre" } }, { "Filter": { "name": "Auslauf und kein Bestand in Witten - Lagerware", "condition": "(auslaufkennzeichen == 'J') and (stock_witten == 0) and (price_EK < 149) and (attr11 == 'L')", "reason": "Auslauf und kein Bestand in Witten - Lagerware" } }, { "Filter": { "name": "Auslauf und nirgendwo Bestand - Lagerware", "condition": "(auslaufkennzeichen == 'J') and (stock == 0) and (price_EK > 149) and (attr11 == 'L')", "reason": "Auslauf und nirgendwo Bestand - Lagerware" } }, { "Filter": { "name": "Auslauf und nirgendwo Bestand - Bestellware", "condition": "(auslaufkennzeichen == 'J') and (attr1 == 1) and (attr2 > 80) and (attr11 == 'B') and (stock == 0)", "reason": "Auslauf und nirgendwo Bestand - Bestellware" } }, { "Filter": { "name": "Bestellsperre und kein Bestand", "condition": "(bestellsperre == 'J') and (stock == 0)", "reason": "Bestellsperre und kein Bestand" } } ]
Datapool export_articles_oms_test_dev
Primary_Key [ "ordernumber", "attr1" ]