Legacy YAML / Detail

export / export_articles_oms_old

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 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  #sql from

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.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.ordernumber = iwm_articles_new_bssp_and_auslauf.ordernumber AND articles.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  or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 0)


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

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles.ordernumber
 mainnumber:
  Source: articles.mainnumber
 name:
  Source: articles.name_ost
 supplier:
  Source: articles.supplier_oms
  Field_Adapter:
    - replace_empty: 'Sonstige'
 tax:
  Source: articles.tax
 price_EK:
  Source: articles.price_oms
  Field_Adapter:
    - replace: [',', '']
    - replace: ['.', ',']
 pseudoprice_EK:
   Source: articles.pseudoprice_oms
   Field_Adapter:
     - replace: [',', '']
     - replace: ['.', ',']
 baseprice_EK: (0)
 active:
   Source: articles.active_oms
 configurator_options:
   Source: articles.configuratorOptions
 description_long:
  Source: articles.description_long_oms
  Field_Adapter:
      - replace: [';', '']
 supplier_number: articles.suppliernumber
 attr1:
    Source: articles.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles.attr2
     Field_Adapter:
       - replace: [';', '']
 attr3:
     Source: articles.attr3
     Field_Adapter:
       - replace: [';', '']
 attr4:
     Source: articles.attr4
     Field_Adapter:
       - replace: [';', '']
 attr5:
     Source: articles.attr5
     Field_Adapter:
       - replace: [';', '']
 attr6:
     Source: articles.swag_attr22
     Field_Adapter:
       - replace: [';', '']
 attr7:
     Source: articles.attr7
     Field_Adapter:
       - replace: [';', '']
 attr8:
     Source: articles.attr8
     Field_Adapter:
       - replace: [';', '']
 attr9:
     Source: articles.attr9
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles.swag_attr25
     Field_Adapter:
       - replace: [';', '']
 attr11:
     Source: articles.attr11
     Field_Adapter:
       - replace: [';', '']
 attr12:
     Source: articles.attr12
     Field_Adapter:
       - replace: [';', '']
 attr13:
     Source: articles.attr13
     Field_Adapter:
       - replace: [';', '']
 attr14:
     Source: articles.attr14
     Field_Adapter:
       - replace: [';', '']
 attr15:
     Source: articles.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.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.attr16
 attr17:
     Source: articles.attr17
     Field_Adapter:
       - replace: [';', '']
 attr18: (0)
 attr19:
     Source: articles.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles.name_oms
     Field_Adapter:
       - replace: [';', '']
 attr23:
     Source: articles.swag_attr23
     Field_Adapter:
       - replace: [';', '']
 attr24: #Synonyme
     Source: articles.swag_attr24
 attr26: #sortierte Ware
     Source: articles.swag_attr26
 attr27: #Produktart
     Source: articles.swag_attr27
 ean: articles.ean
 stock_witten:
     Source: iwm_articles_stock.witten
     Field_Adapter:
       - replace_empty: 0
     In_Export: no
 shipping_free:
   Source: articles.shippingfree
   File_Field_Adapter:
    Engine: importEngine
    Datapool: static_filter_shippingfree
    Identifier: id
    Fields:
      - supplier_number
      - attr1
      - attr2
      - attr3
      - attr4
      - ordernumber
      - id
      - shop
 kind: articles.kind
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 weight:
  Source: articles.weight
  Field_Adapter:
    - replace: ['.00', '']
    - replace: [',', '']
    - simple_division: 1000
 bestellsperre: IF (iwm_articles_new_bssp_and_auslauf.bestellsperre = '', articles.bestellsperre, iwm_articles_new_bssp_and_auslauf.bestellsperre) as bestellsperre
 auslaufkennzeichen: IF (iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen = '', articles.auslaufkennzeichen, iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen) as auslaufkennzeichen
 prop1: articles.prop1  #Farbe
 prop2: articles.prop2	#Breite
 prop3: articles.prop3	#Länge
 prop4: articles.prop4	#Höhe
 prop5: articles.prop5	#Abmessung
 prop10: articles.prop10	#Modell
 prop11: articles.prop11	#Material
 prop12: articles.prop12	#Raum
 prop50: articles.prop50	#Matratze Größe
 prop51: articles.prop51	#Matratze Härtegrad
 prop52: articles.prop52	#Matratze Bezugsmaterial
 prop53: articles.prop53	#Matratze Matratzenart
 prop60: articles.prop60	#Teppich Flächengewicht
 prop61: articles.prop61	#Teppich Florhöhe
 prop62: articles.prop62	#Teppich Fußbodenheizung
 prop63: articles.prop63	#Teppich Form
 prop64: articles.prop64	#Teppich Muster
 prop_status: #falls mindestens ein prop-Feld gefüllt ist, 1, sonst 0
   Source: articles.prop1
   File_Field_Adapter:
     File: export_articles_oms.prop_status
 enev_color: articles.enev_color
 enev_download: articles.enev_download
 enev_image: articles.enev_image
 enev_klasse: articles.enev_klasse
 enev_spectrumfrom: articles.enev_spectrumfrom
 enev_spectrum: articles.enev_spectrum
 enev_active: articles.enev_active

Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: 'Preis ungueltig oder noch nicht ermittelt'
    condition: (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
    reason: 'alle Preise = 0 - evtl. noch nicht ermittelt'
 - Filter:
    name: 'channel group filter online shops'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_online
        Reason_Key: reason
        Mapping: #left is from current datapool, right from filter datapool
         supplier_number: supplier_number
         supplier: supplier_name
         ordernumber: ordernumber
         attr1: attr1
         attr2: attr2
         attr3: attr3
         attr4: attr4
         attr11: attr11
         attr12: attr12
         price_EK: price
         stock: stock
         stock_witten: stock_witten
         name: name
         description_long: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre
 - Filter:
    name: 'channelfilter moebel-shop.de'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_oms
        Reason_Key: reason
        Mapping: #left is from current datapool, right from filter datapool
         supplier_number: supplier_number
         supplier: supplier_name
         ordernumber: ordernumber
         attr1: attr1
         attr2: attr2
         attr3: attr3
         attr4: attr4
         attr11: attr11
         attr12: attr12
         price_EK: price
         stock: stock
         stock_witten: stock_witten
         name: name
         description_long: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre

#Target
Datapool: export_articles_oms #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
Joins [ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma" }, { "Left_Join": null, "Datapool": "iwm_articles_new_bssp_and_auslauf", "Join_Condition": "articles.ordernumber = iwm_articles_new_bssp_and_auslauf.ordernumber AND articles.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 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 0)" } ]
Read_Conditions [ "articles.active_oms = 1" ]
Mapping { "ordernumber": { "Source": "articles.ordernumber" }, "mainnumber": { "Source": "articles.mainnumber" }, "name": { "Source": "articles.name_ost" }, "supplier": { "Source": "articles.supplier_oms", "Field_Adapter": [ { "replace_empty": "Sonstige" } ] }, "tax": { "Source": "articles.tax" }, "price_EK": { "Source": "articles.price_oms", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "pseudoprice_EK": { "Source": "articles.pseudoprice_oms", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "baseprice_EK": "(0)", "active": { "Source": "articles.active_oms" }, "configurator_options": { "Source": "articles.configuratorOptions" }, "description_long": { "Source": "articles.description_long_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "supplier_number": "articles.suppliernumber", "attr1": { "Source": "articles.attr1", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr2": { "Source": "articles.attr2", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr3": { "Source": "articles.attr3", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr4": { "Source": "articles.attr4", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr5": { "Source": "articles.attr5", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr6": { "Source": "articles.swag_attr22", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr7": { "Source": "articles.attr7", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr8": { "Source": "articles.attr8", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr9": { "Source": "articles.attr9", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr10": { "Source": "articles.swag_attr25", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr11": { "Source": "articles.attr11", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr12": { "Source": "articles.attr12", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr13": { "Source": "articles.attr13", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr14": { "Source": "articles.attr14", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr15": { "Source": "articles.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.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.attr16" } }, "attr17": { "Source": "articles.attr17", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr18": "(0)", "attr19": { "Source": "articles.attr19", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr20": { "Source": "articles.name_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr23": { "Source": "articles.swag_attr23", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr24": { "Source": "articles.swag_attr24" }, "attr26": { "Source": "articles.swag_attr26" }, "attr27": { "Source": "articles.swag_attr27" }, "ean": "articles.ean", "stock_witten": { "Source": "iwm_articles_stock.witten", "Field_Adapter": [ { "replace_empty": 0 } ], "In_Export": "no" }, "shipping_free": { "Source": "articles.shippingfree", "File_Field_Adapter": { "Engine": "importEngine", "Datapool": "static_filter_shippingfree", "Identifier": "id", "Fields": [ "supplier_number", "attr1", "attr2", "attr3", "attr4", "ordernumber", "id", "shop" ] } }, "kind": "articles.kind", "stock": { "Source": "iwm_articles_stock.stock", "Field_Adapter": [ { "replace_empty": 0 } ] }, "weight": { "Source": "articles.weight", "Field_Adapter": [ { "replace": [ ".00", "" ] }, { "replace": [ ",", "" ] }, { "simple_division": 1000 } ] }, "bestellsperre": "IF (iwm_articles_new_bssp_and_auslauf.bestellsperre = '', articles.bestellsperre, iwm_articles_new_bssp_and_auslauf.bestellsperre) as bestellsperre", "auslaufkennzeichen": "IF (iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen = '', articles.auslaufkennzeichen, iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen) as auslaufkennzeichen", "prop1": "articles.prop1", "prop2": "articles.prop2", "prop3": "articles.prop3", "prop4": "articles.prop4", "prop5": "articles.prop5", "prop10": "articles.prop10", "prop11": "articles.prop11", "prop12": "articles.prop12", "prop50": "articles.prop50", "prop51": "articles.prop51", "prop52": "articles.prop52", "prop53": "articles.prop53", "prop60": "articles.prop60", "prop61": "articles.prop61", "prop62": "articles.prop62", "prop63": "articles.prop63", "prop64": "articles.prop64", "prop_status": { "Source": "articles.prop1", "File_Field_Adapter": { "File": "export_articles_oms.prop_status" } }, "enev_color": "articles.enev_color", "enev_download": "articles.enev_download", "enev_image": "articles.enev_image", "enev_klasse": "articles.enev_klasse", "enev_spectrumfrom": "articles.enev_spectrumfrom", "enev_spectrum": "articles.enev_spectrum", "enev_active": "articles.enev_active" }
Filters [ { "Filter": { "name": "Preis ungueltig oder noch nicht ermittelt", "condition": "(price_EK == '') or (price_EK == '0.00') or (price_EK == '0,00') or (price_EK == '0,0')", "reason": "alle Preise = 0 - evtl. noch nicht ermittelt" } }, { "Filter": { "name": "channel group filter online shops", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles_online", "Reason_Key": "reason", "Mapping": { "supplier_number": "supplier_number", "supplier": "supplier_name", "ordernumber": "ordernumber", "attr1": "attr1", "attr2": "attr2", "attr3": "attr3", "attr4": "attr4", "attr11": "attr11", "attr12": "attr12", "price_EK": "price", "stock": "stock", "stock_witten": "stock_witten", "name": "name", "description_long": "description", "auslaufkennzeichen": "auslauf", "bestellsperre": "bestellsperre" } } } } }, { "Filter": { "name": "channelfilter moebel-shop.de", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles_oms", "Reason_Key": "reason", "Mapping": { "supplier_number": "supplier_number", "supplier": "supplier_name", "ordernumber": "ordernumber", "attr1": "attr1", "attr2": "attr2", "attr3": "attr3", "attr4": "attr4", "attr11": "attr11", "attr12": "attr12", "price_EK": "price", "stock": "stock", "stock_witten": "stock_witten", "name": "name", "description_long": "description", "auslaufkennzeichen": "auslauf", "bestellsperre": "bestellsperre" } } } } } ]
Datapool export_articles_oms
Primary_Key [ "ordernumber", "attr1" ]