export / export_articles_oms_channelpilot_to_delete

#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]