Engine / Editor
export_articles_oms_channelpilot_to_delete
Mandant default
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
export
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#Connections Source_Config: enhanceEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service Mysql_Engine: InnoDB Default_Charset: latin1 #Source Source_Datapool: articles_new #sql from Joins: - Left_Join: Datapool: iwm_articles_properties_farbe Join_Condition: articles_new.ordernumber = iwm_articles_properties_farbe.ordernumber AND articles_new.attr1 = iwm_articles_properties_farbe.firma #- Left_Join: # Datapool: shopware_article_info # Join_Condition: articles_new.ordernumber = shopware_article_info.ordernumber AND shopware_article_info.shop = 'oms' - Left_Join: Datapool: export_for_dataengine Join_Condition: articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'oms' Datapool_Definition: ordernumber: VARCHAR(20) NOT NULL mainnumber: VARCHAR(20) NOT NULL title: VARCHAR(50) DEFAULT NULL description: MEDIUMTEXT DEFAULT NULL suppliernumber: VARCHAR(20) DEFAULT NULL supplier: VARCHAR(50) DEFAULT NULL google_product_category: VARCHAR(255) DEFAULT NULL product_type: VARCHAR(255) DEFAULT NULL link: VARCHAR(255) DEFAULT NULL image_link: VARCHAR(255) DEFAULT NULL additional_image_link: TEXT DEFAULT NULL condition1: VARCHAR(20) DEFAULT NULL availability: VARCHAR(10) DEFAULT NULL price: VARCHAR(20) DEFAULT NULL sale_price: VARCHAR(20) DEFAULT NULL brand: VARCHAR(50) DEFAULT NULL gtin: VARCHAR(15) DEFAULT NULL mpn: VARCHAR(25) DEFAULT NULL adwords_grouping: VARCHAR(255) DEFAULT NULL custom_label_0: VARCHAR(255) DEFAULT NULL custom_label_1: VARCHAR(255) DEFAULT NULL custom_label_2: VARCHAR(255) DEFAULT NULL custom_label_3: VARCHAR(255) DEFAULT NULL custom_label_4: VARCHAR(255) DEFAULT NULL Abmessung: VARCHAR(40) DEFAULT NULL Durchmesser: VARCHAR(40) DEFAULT NULL Laenge: VARCHAR(40) DEFAULT NULL Breite: VARCHAR(40) DEFAULT NULL Tiefe: VARCHAR(40) DEFAULT NULL Hoehe: VARCHAR(40) DEFAULT NULL color: VARCHAR(50) DEFAULT NULL energy_efficiency_class: VARCHAR(20) DEFAULT NULL shipping_weight: VARCHAR(20) DEFAULT NULL shipping: VARCHAR(20) DEFAULT NULL pubDate: VARCHAR(50) DEFAULT NULL attr2: VARCHAR(3) DEFAULT NULL Produktart: VARCHAR(255) DEFAULT NULL stock: VARCHAR(255) DEFAULT NULL category: VARCHAR(500) DEFAULT NULL ean: VARCHAR(255) DEFAULT NULL attr23: VARCHAR(10) DEFAULT NULL wiederbeschaffungszeit: VARCHAR(10) DEFAULT NULL product_condition: VARCHAR(255) DEFAULT NULL # LBKALK: VARCHAR(255) DEFAULT NULL suppliernumber_original: VARCHAR(50) DEFAULT NULL supplier_number: VARCHAR(50) DEFAULT NULL tax: VARCHAR(255) DEFAULT NULL price_VK: VARCHAR(255) DEFAULT NULL pseudoprice_VK: VARCHAR(255) DEFAULT NULL versandkosten_berechnet: VARCHAR(255) DEFAULT NULL herstellerartikelnummer: VARCHAR(255) DEFAULT NULL dispositionsart: VARCHAR(255) DEFAULT NULL lieferzeitinwochen: VARCHAR(255) DEFAULT NULL versandart: VARCHAR(255) DEFAULT NULL versandkosten_addition: VARCHAR(255) DEFAULT NULL textverwendungskennzeichen_mitbewerber_name: VARCHAR(255) DEFAULT NULL configurator_options: VARCHAR(255) DEFAULT NULL weight: VARCHAR(255) DEFAULT NULL Liegeflaeche: VARCHAR(40) DEFAULT NULL Haertegrad: VARCHAR(40) DEFAULT NULL Bezug: VARCHAR(50) DEFAULT NULL Dessin: VARCHAR(40) DEFAULT NULL Fuss: VARCHAR(40) DEFAULT NULL Tischplatte: VARCHAR(40) DEFAULT NULL Gestellfarbe: VARCHAR(40) DEFAULT NULL Front: VARCHAR(100) DEFAULT NULL Korpus: VARCHAR(40) DEFAULT NULL Anschlag: VARCHAR(40) DEFAULT NULL Varianten: VARCHAR(100) DEFAULT NULL Holzart: VARCHAR(100) DEFAULT NULL Kissenbezug: VARCHAR(50) DEFAULT NULL Sitzschale: VARCHAR(40) DEFAULT NULL Oberflaeche: VARCHAR(40) DEFAULT NULL Fussform: VARCHAR(40) DEFAULT NULL Groesse: VARCHAR(40) DEFAULT NULL Mass: VARCHAR(40) DEFAULT NULL Fussfarbe: VARCHAR(40) DEFAULT NULL Farbvariante: VARCHAR(60) DEFAULT NULL Sitz: VARCHAR(40) DEFAULT NULL Gestell: VARCHAR(40) DEFAULT NULL Materialvariante: VARCHAR(40) DEFAULT NULL Bezug1: VARCHAR(40) DEFAULT NULL Bezug2: VARCHAR(40) DEFAULT NULL Rueckenlehne: VARCHAR(40) DEFAULT NULL Polsterung: VARCHAR(40) DEFAULT NULL Kontrastnaht: VARCHAR(40) DEFAULT NULL Leder: VARCHAR(40) DEFAULT NULL Holzausfuehrung: VARCHAR(40) DEFAULT NULL Sitzhoehe: VARCHAR(40) DEFAULT NULL Nahtart: VARCHAR(40) DEFAULT NULL Korpus_und_Arbeitsplatte: VARCHAR(40) DEFAULT NULL Griff: VARCHAR(40) DEFAULT NULL Funktion: VARCHAR(40) DEFAULT NULL Armlehne: VARCHAR(40) DEFAULT NULL Ruecken: VARCHAR(40) DEFAULT NULL Korpusbezug: VARCHAR(40) DEFAULT NULL Sitz_und_Kissen: VARCHAR(40) DEFAULT NULL Arbeitsplatte: VARCHAR(40) DEFAULT NULL Innenkorpus: VARCHAR(40) DEFAULT NULL Applikationsfarbe: VARCHAR(40) DEFAULT NULL Wangenform: VARCHAR(40) DEFAULT NULL Tischsaeule: VARCHAR(40) DEFAULT NULL Design: VARCHAR(40) DEFAULT NULL Energieeffizienzklasse: VARCHAR(40) DEFAULT NULL Produktdatenblatt: VARCHAR(255) DEFAULT NULL EEK_Label: VARCHAR(255) DEFAULT NULL Farbe: VARCHAR(200) DEFAULT NULL Farbtemperatur: VARCHAR(40) DEFAULT NULL Fassung: VARCHAR(40) DEFAULT NULL Flaechengewicht: VARCHAR(40) DEFAULT NULL Fleachengewicht_exakt: VARCHAR(40) DEFAULT NULL Florhoehe: VARCHAR(40) DEFAULT NULL Florhoehe_exakt: VARCHAR(40) DEFAULT NULL Form: VARCHAR(40) DEFAULT NULL fuer_Fussbodenheizung_geeignet: VARCHAR(40) DEFAULT NULL Gesamtgewicht: VARCHAR(40) DEFAULT NULL Leistung: VARCHAR(40) DEFAULT NULL Lichtstrom: VARCHAR(40) DEFAULT NULL Material: VARCHAR(40) DEFAULT NULL Muster: VARCHAR(40) DEFAULT NULL Raum: VARCHAR(40) DEFAULT NULL Stil: VARCHAR(40) DEFAULT NULL Typ: VARCHAR(40) DEFAULT NULL Synonyme: VARCHAR(255) DEFAULT NULL Modellfamilie: VARCHAR(255) DEFAULT NULL sortiert: VARCHAR(255) DEFAULT NULL Bulletpoints: VARCHAR(255) DEFAULT NULL imageUrl: TEXT DEFAULT NULL bestellsperre: VARCHAR(10) DEFAULT NULL auslaufkennzeichen: VARCHAR(10) DEFAULT NULL Mapping: ordernumber: articles_new.ordernumber mainnumber: articles_new.mainnumber attr1: Source: articles_new.attr1 In_Export: no attr2: Source: articles_new.attr2 In_Export: no attr3: Source: articles_new.attr3 In_Export: no attr4: Source: articles_new.attr4 In_Export: no attr11: Source: articles_new.attr11 In_Export: no attr12: Source: articles_new.attr12 In_Export: no title: articles_new.name_ost description: Source: articles_new.description_long_oms Field_Adapter: - replace: [';', ''] suppliernumber: Source: articles_new.suppliernumber supplier: Source: articles_new.supplier_oms google_product_category: IF(articles_new.cat_google = "", "Möbel",articles_new.cat_google) AS google_product_category product_type: export_for_dataengine.category produktart: #Produktart Source: articles_new.name_oms Field_Adapter: - explode: [' ','0'] In_Export: no link: export_for_dataengine.link image_link: Source: articles_new.imageUrl Field_Adapter: - explode: [',', 0] #explode source field by ',' and chooses the first element additional_image_link_1: Source: export_for_dataengine.additional_image_link_1 In_Export: no additional_image_link_2: Source: export_for_dataengine.additional_image_link_2 In_Export: no additional_image_link_3: Source: export_for_dataengine.additional_image_link_3 In_Export: no additional_image_link: Source: articles_new.imageUrl File_Field_Adapter: File: export_articles_oms_channelpilot.additional_image_link condition1: (new) availability: (in stock) price: Source: articles_new.pseudoprice_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: [',', '.'] sale_price: Source: articles_new.price_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: [',', '.'] brand: Source: articles_new.supplier_oms Field_Adapter: - replace: ['Sonstige',''] gtin: articles_new.ean mpn: articles_new.attr9 adwords_grouping: articles_new.attr2 custom_label_0: articles_new.attr2 custom_label_1: articles_new.attr3 custom_label_2: articles_new.attr4 custom_label_3: articles_new.attr13 custom_label_4: () Abmessung: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' # In_Export: no Durchmesser: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channelpilot.Durchmesser # In_Export: no Laenge: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channelpilot.Laenge # In_Export: no Breite: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channelpilot.Breite # In_Export: no Hoehe: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channelpilot.Hoehe # In_Export: no Tiefe: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channelpilot.Tiefe # In_Export: no instock: Source: articles_new.instock In_Export: no stock_local: Source: articles_new.attr30 In_Export: no stock_ir: Source: articles_new.stock_ir In_Export: no stock_witten: Source: articles_new.stock_witten In_Export: no color: iwm_articles_properties_farbe.farbe energy_efficiency_class: iwm_articles_properties_farbe.Energieeffizienzklasse shipping_weight: articles_new.weight shipping: Source: articles_new.attr8 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 pubDate: articles_new.changed unterwarengruppe: Source: articles_new.attr3 Field_Adapter: - replace: [';', ''] In_Export: no systemnummer: Source: articles_new.attr4 Field_Adapter: - replace: [';', ''] In_Export: no warenpool: Source: articles_new.attr5 Field_Adapter: - replace: [';', ''] In_Export: no metatext: Source: articles_new.swag_attr22 Field_Adapter: - replace: [';', ''] In_Export: no typenplan_id: Source: articles_new.attr7 Field_Adapter: - replace: [';', ''] In_Export: no versandkosten_berechnet: Source: articles_new.attr8 Field_Adapter: - replace: [';', ''] herstellerartikelnummer: Source: articles_new.attr9 Field_Adapter: - replace: [';', ''] textverwendungskennzeichen_hersteller_name: Source: articles_new.swag_attr25 Field_Adapter: - replace: [';', ''] In_Export: no dispositionsart: Source: articles_new.attr11 Field_Adapter: - replace: [';', ''] lieferzeitinwochen: Source: articles_new.attr12 Field_Adapter: - replace: [';', ''] versandart: Source: articles_new.attr13 Field_Adapter: - replace: [';', ''] versandkosten_addition: Source: articles_new.attr14 Field_Adapter: - replace: [';', ''] iwm_versandkosten: Source: articles_new.attr15 Field_Adapter: - replace: [';', ''] In_Export: no montagekosten: Source: articles_new.attr16 Field_Adapter: - replace: [';', ''] In_Export: no textverwendungskennzeichen_mitbewerber_name: Source: articles_new.swag_attr24 Field_Adapter: - replace: [';', ''] etikettenart: Source: articles_new.attr18 Field_Adapter: - replace: [';', ''] In_Export: no document_id: Source: articles_new.attr19 Field_Adapter: - replace: [';', ''] In_Export: no iwm_seo_name: Source: articles_new.name_oms Field_Adapter: - replace: [';', ''] In_Export: no kind: Source: articles_new.kind In_Export: no shippingfree: Source: articles_new.shippingfree In_Export: no LBKALK: Source: articles_new.LBKALK Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: LBKALK #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: '0' In_Export: no Liegeflaeche: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Liegefläche:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] #explode by : and get Array[1] - trim: ' |' #trim with space Haertegrad: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Härtegrad:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Bezug: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Dessin: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Dessin:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fuss: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Fuß:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Tischplatte: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Tischplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Gestellfarbe: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Gestellfarbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Front: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Front:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Korpus_und_Arbeitsplatte: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Korpus und Arbeitsplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Anschlag: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Anschlag:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Varianten: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Varianten:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Holzart: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Holzart:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Kissenbezug: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug Kissen:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitzschale: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitzschale:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Oberflaeche: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Oberfläche:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fussform: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Fußform:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Groesse: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Größe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Farbvariante: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitz: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitz:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Gestell: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Gestell:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Materialvariante: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Bezug1: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug 1:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Bezug2: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug 2:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Rueckenlehne: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Rückenlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Polsterung: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Polsterung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Kontrastnaht: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Kontrastnaht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Leder: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Leder:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Holzausfuehrung: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Holzausführung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitzhoehe: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitzhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Nahtart: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Nahtart:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Korpus: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Korpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Griff: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Griff:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Funktion: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Funktion:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Armlehne: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Armlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Ruecken: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Rücken:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Korpusbezug: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug Korpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitz_und_Kissen: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitz und Kissen:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Arbeitsplatte: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Arbeitsplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Innenkorpus: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Innenkorpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Applikationsfarbe: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Applikationsfarbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Wangenform: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Wangenform:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Tischsaeule: Source: articles_new.configuratorOptions Field_Adapter: - get_preg_match: ['/Tischsäule:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Design: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Design:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Energieeffizienzklasse: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Energieeffizienzklasse:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Produktdatenblatt: () #articles_new.enev_download EEK_Label: () # articles_new.enev_image Farbe: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Farbtemperatur: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Farbtemperatur:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fassung: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Fassung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Flaechengewicht: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Flächengewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fleachengewicht_exakt: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Flächengewicht exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Florhoehe: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Florhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Florhoehe_exakt: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Florhöhe exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Form: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Form:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' fuer_Fussbodenheizung_geeignet: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/für Fußbodenheizung geeignet:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Gesamtgewicht: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Gesamtgewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Leistung: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Leistung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Lichtstrom: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Lichtstrom:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Material: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Muster: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Muster:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Raum: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Raum:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Stil: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Stil:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Typ: Source: iwm_articles_properties_farbe.propertyValueName Field_Adapter: - get_preg_match: ['/Typ:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Synonyme: Source: articles_new.swag_attr24 Modellfamilie: Source: articles_new.modellfamilie sortiert: Source: articles_new.swag_attr26 Bulletpoints: Source: articles_new.name_oms File_Field_Adapter: File: export_articles_oms_channelpilot.Bulletpoints imageUrl: Source: articles_new.imageUrl File_Field_Adapter: File: export_articles_oms_channelpilot.imageUrl bestellsperre: articles_new.bestellsperre auslaufkennzeichen: articles_new.auslaufkennzeichen Filters: - Filter: name: 'empty ordernumber' condition: (ordernumber == '') reason: 'empty ordernumber' - Filter: name: 'Abmessung leer' condition: (Abmessung == '') reason: 'Artikel ohne Abmessungen' - Filter: name: not_in_oms_export condition: Not_In_Pool_Filter_Adapter: Config: exportEngine Datapool: export_articles_oms Local_Key: ordernumber Cross_Key: ordernumber reason: 'not in oms online export' #Target Datapool: export_articles_oms_channelpilot #sql table Primary_Key: [ordernumber]
Definition aktualisieren