Legacy YAML / Detail

export / export_articles_bil_neu

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_bil_neu 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:
  Datapool: iwm_articles_properties
  Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber and articles_new.attr1 = iwm_articles_properties.firma
#- 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 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 0)

Read_Conditions:  #sql where - Read-Filter
  - articles_new.active_bil = 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
  Field_Adapter:
    - replace_empty: 'Sonstige'
 tax:
  Source: articles_new.tax
 price_EK:
  Source: articles_new.price_oms
  Cross_Field_Adapter:
    Config: exportEngine
    Cross_Datapool: export_iwm_articles_prices_oms #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_oms
  Cross_Field_Adapter:
    Config: exportEngine
    Cross_Datapool: export_iwm_articles_prices_oms #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)
 active:
   Source: articles_new.active_bil
 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: [';', '']
 attr9:
     Source: articles_new.attr9_strip
     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_bil_neu.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: [';', '']
 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
 attr41: articles_new.attr41
 attr43:
   Source: articles_new.description_long_oms #beratungstexte
   File_Field_Adapter:
     File: export_articles_bil_neu.attr43
 attr49:
   Source: articles_new.modellfamilie
 attr52:
   Source: articles_new.no_packstation
 tpl_color_badge: articles_new.tpl_color_badge
 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
      - attr18
      - ordernumber
      - id
      - price
      - shop
 attr8:
   Source: articles_new.attr37
   Field_Adapter:
     - getFromJsonField: 'oms'
   File_Field_Adapter:
     File: export_articles_bil_neu.attr8
 kind: articles_new.kind
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 weight:
  Source: articles_new.weight
  Field_Adapter:
    - replace: ['.00', '']
    - replace: [',', '']
    - simple_division: 1000
 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_bil_neu.LBKALK
 bestellsperre:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_oms #name of cross datapool
     Cross_Field: bestellsperre_online #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_empty: 'N'
 auslaufkennzeichen:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_oms #name of cross datapool
     Cross_Field: auslaufkennzeichen_online #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_empty: 'N'
 prop1: iwm_articles_properties.prop1  #Farbe
 prop2: iwm_articles_properties.prop2	#Breite
 prop3: iwm_articles_properties.prop3	#Länge
 prop4: iwm_articles_properties.prop4	#Höhe
 prop5: iwm_articles_properties.prop5	#Abmessung
 prop10: iwm_articles_properties.prop10	#Modell
 prop11: iwm_articles_properties.prop11	#Material
 prop12: iwm_articles_properties.prop12	#Raum
 prop50: iwm_articles_properties.prop50	#Matratze Größe
 prop51: iwm_articles_properties.prop51	#Matratze Härtegrad
 prop52: iwm_articles_properties.prop52	#Matratze Bezugsmaterial
 prop53: iwm_articles_properties.prop53	#Matratze Matratzenart
 prop60: iwm_articles_properties.prop60	#Teppich Flächengewicht
 prop61: iwm_articles_properties.prop61	#Teppich Florhöhe
 prop62: iwm_articles_properties.prop62	#Teppich Fußbodenheizung
 prop63: iwm_articles_properties.prop63	#Teppich Form
 prop64: iwm_articles_properties.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_bil_neu.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 == '') 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 biller.de'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_bil
        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_bil_neu #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_properties", "Join_Condition": "articles_new.ordernumber = iwm_articles_properties.ordernumber and articles_new.attr1 = iwm_articles_properties.firma" } ]
Read_Conditions [ "articles_new.active_bil = 1" ]
Mapping { "ordernumber": { "Source": "articles_new.ordernumber" }, "mainnumber": { "Source": "articles_new.mainnumber" }, "name": { "Source": "articles_new.name_ost" }, "supplier": { "Source": "articles_new.supplier_oms", "Field_Adapter": [ { "replace_empty": "Sonstige" } ] }, "tax": { "Source": "articles_new.tax" }, "price_EK": { "Source": "articles_new.price_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "pseudoprice_EK": { "Source": "articles_new.pseudoprice_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "pseudoprice_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "baseprice_EK": "(0)", "active": { "Source": "articles_new.active_bil" }, "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": [ ";", "" ] } ] }, "attr9": { "Source": "articles_new.attr9_strip", "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_bil_neu.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": [ ";", "" ] } ] }, "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" }, "attr41": "articles_new.attr41", "attr43": { "Source": "articles_new.description_long_oms", "File_Field_Adapter": { "File": "export_articles_bil_neu.attr43" } }, "attr49": { "Source": "articles_new.modellfamilie" }, "attr52": { "Source": "articles_new.no_packstation" }, "tpl_color_badge": "articles_new.tpl_color_badge", "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", "attr18", "ordernumber", "id", "price", "shop" ] } }, "attr8": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "oms" } ], "File_Field_Adapter": { "File": "export_articles_bil_neu.attr8" } }, "kind": "articles_new.kind", "stock": { "Source": "iwm_articles_stock.stock", "Field_Adapter": [ { "replace_empty": 0 } ] }, "weight": { "Source": "articles_new.weight", "Field_Adapter": [ { "replace": [ ".00", "" ] }, { "replace": [ ",", "" ] }, { "simple_division": 1000 } ] }, "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_bil_neu.LBKALK" } }, "bestellsperre": { "Source": "articles_new.ordernumber", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_bestellsperre_und_auslauf_oms", "Cross_Field": "bestellsperre_online", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": "N" } ] }, "auslaufkennzeichen": { "Source": "articles_new.ordernumber", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_bestellsperre_und_auslauf_oms", "Cross_Field": "auslaufkennzeichen_online", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": "N" } ] }, "prop1": "iwm_articles_properties.prop1", "prop2": "iwm_articles_properties.prop2", "prop3": "iwm_articles_properties.prop3", "prop4": "iwm_articles_properties.prop4", "prop5": "iwm_articles_properties.prop5", "prop10": "iwm_articles_properties.prop10", "prop11": "iwm_articles_properties.prop11", "prop12": "iwm_articles_properties.prop12", "prop50": "iwm_articles_properties.prop50", "prop51": "iwm_articles_properties.prop51", "prop52": "iwm_articles_properties.prop52", "prop53": "iwm_articles_properties.prop53", "prop60": "iwm_articles_properties.prop60", "prop61": "iwm_articles_properties.prop61", "prop62": "iwm_articles_properties.prop62", "prop63": "iwm_articles_properties.prop63", "prop64": "iwm_articles_properties.prop64", "prop_status": { "Source": "articles_new.prop1", "File_Field_Adapter": { "File": "export_articles_bil_neu.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 == '') 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 biller.de", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles_bil", "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_bil_neu
Primary_Key [ "ordernumber", "attr1" ]