Legacy YAML / Detail

export / export_articles_ost_backup

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
export_articles_ost 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 = 96 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 0)

Read_Conditions:  #sql where - Read-Filter
  - articles_new.attr1 = 1 AND articles_new.active_ost = 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_ost
  Field_Adapter:
    - replace_empty: 'Sonstige'
 tax:
  Source: articles_new.tax
 price_EK:
  Source: articles_new.price_ost
  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
 pseudoprice_EK:
   Source: articles_new.pseudoprice_ost
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
     Cross_Field: pseudoprice_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
 baseprice_EK: (0)
 supplier_number: articles_new.suppliernumber
 active:
   Source: articles_new.active_ost
 configurator_options:
   Source: articles_new.configuratorOptions
 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: [';', '']
 attr9:
     Source: articles_new.attr9_strip
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles_new.attr10
     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_ost #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_ost
        Cross_Field: montage
        Local_Key: ordernumber
        Cross_Key: ordernumber
     File_Field_Adapter:
        File: export_articles_ost.attr16
 attr17:
     Source: articles_new.attr17
     Field_Adapter:
       - replace: [';', '']
 attr18:
     Source: articles_new.attr18
     Field_Adapter:
       - replace: [';', '']
 attr19:
     Source: articles_new.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles_new.name_oms
     Field_Adapter:
       - replace: [';', '']
 attr21: articles_new.swag_attr21
 attr22: articles_new.swag_attr22
 attr23: articles_new.swag_attr23
 attr24: #Synonyme
     Source: articles_new.swag_attr24
 attr26: #Synonyme
     Source: articles_new.swag_attr26
 attr27: #Produktart
     Source: articles_new.swag_attr27
 attr28: #Energieeffizienzklassen Küchen
     Source: articles_new.swag_attr28
 attr29: #Energieeffizienzklassen Küchen
     Source: articles_new.swag_attr29
 attr30: #stock local
   Source: articles_new.attr30
   Field_Adapter:
     - replace_empty: 0
 attr31: #stock inventory
   Source: articles_new.attr31
   Field_Adapter:
     - replace_empty: 0
 attr32: #google category
   Source: articles_new.cat_google
 attr33: #ebay category
   Source: articles_new.cat_ebay
 attr34: #amazon category
   Source: articles_new.cat_amazon
 attr35: #lieferzeit für lagernde Ware
   Source: articles_new.lieferzeit
 attr36: #finanzierbare Produkte
   Source: articles_new.attr36
   File_Field_Adapter:
     File: export_articles_ost.attr36
 attr41: articles_new.attr41
 attr43:
   Source: articles_new.description_long_ost #beratungstexte
   File_Field_Adapter:
     File: export_articles_ost.attr43
 ean: articles_new.ean
 weight:
  Source: articles_new.weight
  Field_Adapter:
   - float_pricision: 2
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 stock_witten:
   Source: iwm_articles_stock.witten
   Field_Adapter:
     - replace_empty: 0
   In_Export: no
 kind: articles_new.kind
 shipping_free:
   Source: articles_new.shippingfree
   File_Field_Adapter:
     Engine: importEngine
     Datapool: static_filter_shippingfree
     Identifier: id
     Fields:
       - supplier_number
       - attr1
       - attr2
       - attr3
       - attr4
       - attr18
       - ordernumber
       - id
       - price
       - shop
 attr37:
   Source: articles_new.attr37
   Field_Adapter:
     - getFromJsonField: 'ost'
   File_Field_Adapter:
     File: export_articles_ost.attr37
 attr37_orig:
   Source: articles_new.shipping_ost
 attr8:
   Source: articles_new.attr37
   Field_Adapter:
     - getFromJsonField: 'ost'
   File_Field_Adapter:
     File: export_articles_ost.attr8
 attr49:
   Source: articles_new.modellfamilie
 attr50:
   Source: articles_new.attr50
 attr51:
   Source: articles_new.anlieferart
 attr52:
   Source: articles_new.no_packstation
 description_long:
  Source: articles_new.description_long_ost
  Field_Adapter:
      - replace: [';', '']
  File_Field_Adapter:
    File: export_articles_ost.description_long
    Engine: enhanceEngine
    Datapool: iwm_articles_properties
    Identifier: ordernumber
    Fields:
      - ordernumber
      - Produkteigenschaften
 LBNTEK:
  Source: articles_new.ordernumber
  Cross_Field_Adapter:
    Config: unitizeEngine
    Cross_Datapool: iwm_ek_prices #name of cross datapool
    Cross_Field: A9K300 #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
 LBKALK:
  Source: articles_new.ordernumber
  File_Field_Adapter:
    File: export_articles_ost.LBKALK
 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
 stock_ir:
   Source: articles_new.stock_ir
   Field_Adapter:
     - replace_empty: 0
   In_Export: no
 prop1: articles_new.prop1  #Farbe
 prop2:	articles_new.prop2 #Breite
 prop3: articles_new.prop3	#Länge
 prop4: articles_new.prop4	#Höhe
 prop5: articles_new.prop5	#Abmessung
 prop10: articles_new.prop10	#Modell
 prop11: articles_new.prop11	#Material
 prop12: articles_new.prop12	#Raum
 prop50: articles_new.prop50	#Matratze Größe
 prop51: articles_new.prop51	#Matratze Härtegrad
 prop52: articles_new.prop52	#Matratze Bezugsmaterial
 prop53: articles_new.prop53	#Matratze Matratzenart
 prop60: articles_new.prop60	#Teppich Flächengewicht
 prop61: articles_new.prop61	#Teppich Florhöhe
 prop62: articles_new.prop62	#Teppich Fußbodenheizung
 prop63: articles_new.prop63	#Teppich Form
 prop64: articles_new.prop64	#Teppich Muster
 prop_status: #falls mindestens ein prop-Feld gefüllt ist, 1, sonst 0
   Source: articles_new.prop1
   File_Field_Adapter:
     File: export_articles_ost.prop_status
 enev_color: articles_new.enev_color
 enev_download: articles_new.enev_download
 enev_image: articles_new.enev_image
 enev_klasse: articles_new.enev_klasse
 enev_spectrumfrom: articles_new.enev_spectrumfrom
 enev_spectrum: articles_new.enev_spectrum
 enev_active: articles_new.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'
    condition: (price_EK == '0') or (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
    reason: 'alle Preise = 0'
 - 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: 'channel filter ostermann.de'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_ost
        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_ost #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 = 96 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 0)" } ]
Read_Conditions [ "articles_new.attr1 = 1 AND articles_new.active_ost = 1" ]
Mapping { "ordernumber": { "Source": "articles_new.ordernumber" }, "mainnumber": { "Source": "articles_new.mainnumber" }, "name": { "Source": "articles_new.name_ost" }, "supplier": { "Source": "articles_new.supplier_ost", "Field_Adapter": [ { "replace_empty": "Sonstige" } ] }, "tax": { "Source": "articles_new.tax" }, "price_EK": { "Source": "articles_new.price_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_ost", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "pseudoprice_EK": { "Source": "articles_new.pseudoprice_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_ost", "Cross_Field": "pseudoprice_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "baseprice_EK": "(0)", "supplier_number": "articles_new.suppliernumber", "active": { "Source": "articles_new.active_ost" }, "configurator_options": { "Source": "articles_new.configuratorOptions" }, "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": [ ";", "" ] } ] }, "attr9": { "Source": "articles_new.attr9_strip", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr10": { "Source": "articles_new.attr10", "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_ost", "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_ost", "Cross_Field": "montage", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "File_Field_Adapter": { "File": "export_articles_ost.attr16" } }, "attr17": { "Source": "articles_new.attr17", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr18": { "Source": "articles_new.attr18", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr19": { "Source": "articles_new.attr19", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr20": { "Source": "articles_new.name_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr21": "articles_new.swag_attr21", "attr22": "articles_new.swag_attr22", "attr23": "articles_new.swag_attr23", "attr24": { "Source": "articles_new.swag_attr24" }, "attr26": { "Source": "articles_new.swag_attr26" }, "attr27": { "Source": "articles_new.swag_attr27" }, "attr28": { "Source": "articles_new.swag_attr28" }, "attr29": { "Source": "articles_new.swag_attr29" }, "attr30": { "Source": "articles_new.attr30", "Field_Adapter": [ { "replace_empty": 0 } ] }, "attr31": { "Source": "articles_new.attr31", "Field_Adapter": [ { "replace_empty": 0 } ] }, "attr32": { "Source": "articles_new.cat_google" }, "attr33": { "Source": "articles_new.cat_ebay" }, "attr34": { "Source": "articles_new.cat_amazon" }, "attr35": { "Source": "articles_new.lieferzeit" }, "attr36": { "Source": "articles_new.attr36", "File_Field_Adapter": { "File": "export_articles_ost.attr36" } }, "attr41": "articles_new.attr41", "attr43": { "Source": "articles_new.description_long_ost", "File_Field_Adapter": { "File": "export_articles_ost.attr43" } }, "ean": "articles_new.ean", "weight": { "Source": "articles_new.weight", "Field_Adapter": [ { "float_pricision": 2 } ] }, "stock": { "Source": "iwm_articles_stock.stock", "Field_Adapter": [ { "replace_empty": 0 } ] }, "stock_witten": { "Source": "iwm_articles_stock.witten", "Field_Adapter": [ { "replace_empty": 0 } ], "In_Export": "no" }, "kind": "articles_new.kind", "shipping_free": { "Source": "articles_new.shippingfree", "File_Field_Adapter": { "Engine": "importEngine", "Datapool": "static_filter_shippingfree", "Identifier": "id", "Fields": [ "supplier_number", "attr1", "attr2", "attr3", "attr4", "attr18", "ordernumber", "id", "price", "shop" ] } }, "attr37": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "ost" } ], "File_Field_Adapter": { "File": "export_articles_ost.attr37" } }, "attr37_orig": { "Source": "articles_new.shipping_ost" }, "attr8": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "ost" } ], "File_Field_Adapter": { "File": "export_articles_ost.attr8" } }, "attr49": { "Source": "articles_new.modellfamilie" }, "attr50": { "Source": "articles_new.attr50" }, "attr51": { "Source": "articles_new.anlieferart" }, "attr52": { "Source": "articles_new.no_packstation" }, "description_long": { "Source": "articles_new.description_long_ost", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "File_Field_Adapter": { "File": "export_articles_ost.description_long", "Engine": "enhanceEngine", "Datapool": "iwm_articles_properties", "Identifier": "ordernumber", "Fields": [ "ordernumber", "Produkteigenschaften" ] } }, "LBNTEK": { "Source": "articles_new.ordernumber", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_ek_prices", "Cross_Field": "A9K300", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "LBKALK": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "File": "export_articles_ost.LBKALK" } }, "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", "stock_ir": { "Source": "articles_new.stock_ir", "Field_Adapter": [ { "replace_empty": 0 } ], "In_Export": "no" }, "prop1": "articles_new.prop1", "prop2": "articles_new.prop2", "prop3": "articles_new.prop3", "prop4": "articles_new.prop4", "prop5": "articles_new.prop5", "prop10": "articles_new.prop10", "prop11": "articles_new.prop11", "prop12": "articles_new.prop12", "prop50": "articles_new.prop50", "prop51": "articles_new.prop51", "prop52": "articles_new.prop52", "prop53": "articles_new.prop53", "prop60": "articles_new.prop60", "prop61": "articles_new.prop61", "prop62": "articles_new.prop62", "prop63": "articles_new.prop63", "prop64": "articles_new.prop64", "prop_status": { "Source": "articles_new.prop1", "File_Field_Adapter": { "File": "export_articles_ost.prop_status" } }, "enev_color": "articles_new.enev_color", "enev_download": "articles_new.enev_download", "enev_image": "articles_new.enev_image", "enev_klasse": "articles_new.enev_klasse", "enev_spectrumfrom": "articles_new.enev_spectrumfrom", "enev_spectrum": "articles_new.enev_spectrum", "enev_active": "articles_new.enev_active" }
Filters [ { "Filter": { "name": "Preis ungueltig", "condition": "(price_EK == '0') or (price_EK == '') or (price_EK == '0.00') or (price_EK == '0,00') or (price_EK == '0,0')", "reason": "alle Preise = 0" } }, { "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": "channel filter ostermann.de", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles_ost", "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_ost
Primary_Key [ "ordernumber", "attr1" ]