Legacy YAML / Detail

export / export_articles_sw6.dev.oms_delta

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_sw6_dev_oms_delta 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: dg_supplierdata_export.export_bestellsperre_und_auslauf_oms
#    Join_Condition: articles_new.ordernumber = export_bestellsperre_und_auslauf_oms.ordernumber AND articles_new.attr1 = export_bestellsperre_und_auslauf_oms.firma


Read_Condition_Vars:
  - date = date("Y-m-dTh:m", strtotime('-2 day'))


Read_Conditions:  #sql where - Read-Filter
  - articles_new.ordernumber LIKE '%-1'
  - articles_new.active_oms = 1
  - articles_new.exclude_hash_change_timestamp >= %date%

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
  ordernumber:
    Source: articles_new.ordernumber
  mainnumber:
    Source: articles_new.mainnumber
    File_Field_Adapter:
      File: export_articles_sw6_dev_oms_delta.mainnumber
  productnumber:
    Source: articles_new.ordernumber
  name:
    Source: articles_new.name_ost
  supplier:
    Source: articles_new.supplier_oms
    Field_Adapter:
      - replace_empty: 'Sonstige'
  taxName: (tax19)
  taxValue: (19)
  tax_id: (tax19)
  price_EK:
    Source: articles_new.price_oms
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_articles_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
    Field_Adapter:
      - replace: [',','.']
  price_gross:
    Source: articles_new.price_oms
    File_Field_Adapter:
      File: export_articles_sw6.price_gross
  pseudoprice_EK:
    Source: articles_new.pseudoprice_oms
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_articles_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
    Field_Adapter:
      - replace: [ ',','.' ]
  baseprice_EK: (0)
  active:
    Source: articles_new.active_oms
  configurator_options:
    Source: articles_new.configuratorOptions
  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.attr6
    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.attr15
    Field_Adapter:
      - replace: [';', '']
  attr15:
    Source: articles_new.attr15
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_articles_oms #name of cross datapool
      Cross_Field: attr8 #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_sw6_dev_oms_delta.attr16
  attr17:
    Source: articles_new.attr17
    Field_Adapter:
      - replace: [';', '']
  attr18: (0)
  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:
    Source: articles_new.swag_attr23
    Field_Adapter:
      - replace: [';', '']
  attr24: #Synonyme
    Source: articles_new.swag_attr24
  attr26: #sortierte Ware
    Source: articles_new.swag_attr26
  attr27: #Produktart
    Source: articles_new.swag_attr27
  attr28: #Produktart
    Source: articles_new.swag_attr28
  attr29: #Produktart
    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 als Text
    Source: articles_new.lieferzeit
  attr36: #finanzierbare Produkte
    Source: articles_new.attr36
    File_Field_Adapter:
      File: export_articles_sw6_dev_oms_delta.attr36
  attr41: articles_new.attr41
  attr43:
    Source: articles_new.description_long_oms #beratungstexte
    File_Field_Adapter:
      File: export_articles_sw6_dev_oms_delta.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: 'oms'
    File_Field_Adapter:
      File: export_articles_sw6_dev_oms_delta.attr37
  attr37_orig:
    Source: articles_new.shipping_oms
  attr8:
    Source: articles_new.attr37
    Field_Adapter:
      - getFromJsonField: 'oms'
    File_Field_Adapter:
      File: export_articles_sw6_dev_oms_delta.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_oms
    Cross_Field_Adapter: #Übernahme auch von Texten neuer Artikel, die mit der Stammdatenaktualisierung gerade erst aktiviert wurden.
      Config: exportEngine
      Cross_Datapool: export_articles_texts_online #name of cross datapool
      Cross_Field: description_long_oms #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: [';', '']
  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_sw6_dev_oms_delta.LBKALK
  attr53:
    Source: articles_new.attr53
  attr54:
    Source: articles_new.ordernumber
    File_Field_Adapter:
      File: export_articles_sw6_dev_oms_delta.attr54
  attr55:
    Source: articles_new.attr55
  attr56:
    Source: articles_new.description_long_oms
  attr57: articles_new.attr57
  attr58: articles_new.material
  attr59: articles_new.ean
  attr60: articles_new.attr60
  attr61: articles_new.attr61
  attr65:
    Source: articles_new.categoryPath_ost
    Cross_Field_Adapter:
      Config: enhanceEngine
      Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
      Cross_Field: herstellerinfo #field to select value from in cross datapool
      Local_Key: arte #key for where condition from datapool
      Cross_Key: arte #key for where condition from cross datapool
  attr66:
    Source: articles_new.categoryPath_ost
    Cross_Field_Adapter:
      Config: enhanceEngine
      Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
      Cross_Field: verantwortlicher #field to select value from in cross datapool
      Local_Key: arte #key for where condition from datapool
      Cross_Key: arte #key for where condition from cross datapool
  tpl_color_badge: articles_new.tpl_color_badge
  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: 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_sw6_dev_oms_delta.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: 'Filter for all articles without test articles'
      condition: (supplier != 'SANSIBAR') AND (supplier != 'WESCO') AND(supplier != 'TRIO') AND(supplier != 'MONDO') AND(supplier != 'HAKU') AND (supplier != 'Casa Nova') AND (supplier != 'BOSCH') AND (supplier != 'TEKO') AND (supplier != 'JOOP!') AND (supplier != 'JANINE') AND (supplier != 'MCA') AND (supplier != 'JAHNKE') AND (supplier != 'PAIDI')
      reason: 'Filter for all articles without test articles'
  - 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_sw6_dev_oms_delta #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" } ]
Read_Condition_Vars [ "date = date(\"Y-m-dTh:m\", strtotime('-2 day'))" ]
Read_Conditions [ "articles_new.ordernumber LIKE '%-1'", "articles_new.active_oms = 1", "articles_new.exclude_hash_change_timestamp >= %date%" ]
Mapping { "ordernumber": { "Source": "articles_new.ordernumber" }, "mainnumber": { "Source": "articles_new.mainnumber", "File_Field_Adapter": { "File": "export_articles_sw6_dev_oms_delta.mainnumber" } }, "productnumber": { "Source": "articles_new.ordernumber" }, "name": { "Source": "articles_new.name_ost" }, "supplier": { "Source": "articles_new.supplier_oms", "Field_Adapter": [ { "replace_empty": "Sonstige" } ] }, "taxName": "(tax19)", "taxValue": "(19)", "tax_id": "(tax19)", "price_EK": { "Source": "articles_new.price_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_oms", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ",", "." ] } ] }, "price_gross": { "Source": "articles_new.price_oms", "File_Field_Adapter": { "File": "export_articles_sw6.price_gross" } }, "pseudoprice_EK": { "Source": "articles_new.pseudoprice_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_oms", "Cross_Field": "pseudoprice_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ",", "." ] } ] }, "baseprice_EK": "(0)", "active": { "Source": "articles_new.active_oms" }, "configurator_options": { "Source": "articles_new.configuratorOptions" }, "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.attr6", "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.attr15", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr15": { "Source": "articles_new.attr15", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_oms", "Cross_Field": "attr8", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ";", "" ] }, { "replace": [ ",", "." ] } ] }, "attr16": { "Source": "articles_new.attr16" }, "attr17": { "Source": "articles_new.attr17", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr18": "(0)", "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": { "Source": "articles_new.swag_attr23", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "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_sw6_dev_oms_delta.attr36" } }, "attr41": "articles_new.attr41", "attr43": { "Source": "articles_new.description_long_oms", "File_Field_Adapter": { "File": "export_articles_sw6_dev_oms_delta.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": "oms" } ], "File_Field_Adapter": { "File": "export_articles_sw6_dev_oms_delta.attr37" } }, "attr37_orig": { "Source": "articles_new.shipping_oms" }, "attr8": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "oms" } ], "File_Field_Adapter": { "File": "export_articles_sw6_dev_oms_delta.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_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_texts_online", "Cross_Field": "description_long_oms", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "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_sw6_dev_oms_delta.LBKALK" } }, "attr53": { "Source": "articles_new.attr53" }, "attr54": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "File": "export_articles_sw6_dev_oms_delta.attr54" } }, "attr55": { "Source": "articles_new.attr55" }, "attr56": { "Source": "articles_new.description_long_oms" }, "attr57": "articles_new.attr57", "attr58": "articles_new.material", "attr59": "articles_new.ean", "attr60": "articles_new.attr60", "attr61": "articles_new.attr61", "attr65": { "Source": "articles_new.categoryPath_ost", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "herstellerinfo", "Local_Key": "arte", "Cross_Key": "arte" } }, "attr66": { "Source": "articles_new.categoryPath_ost", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "verantwortlicher", "Local_Key": "arte", "Cross_Key": "arte" } }, "tpl_color_badge": "articles_new.tpl_color_badge", "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": "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_sw6_dev_oms_delta.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": "Filter for all articles without test articles", "condition": "(supplier != 'SANSIBAR') AND (supplier != 'WESCO') AND(supplier != 'TRIO') AND(supplier != 'MONDO') AND(supplier != 'HAKU') AND (supplier != 'Casa Nova') AND (supplier != 'BOSCH') AND (supplier != 'TEKO') AND (supplier != 'JOOP!') AND (supplier != 'JANINE') AND (supplier != 'MCA') AND (supplier != 'JAHNKE') AND (supplier != 'PAIDI')", "reason": "Filter for all articles without test articles" } }, { "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_sw6_dev_oms_delta
Primary_Key [ "ordernumber", "attr1" ]