export / export_articles_oms_channelpilot_preissuchmaschinen

#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

Mysql_Engine: InnoDB
Default_Charset: latin1

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: shopware_article_info
#  Join_Condition: articles_new.ordernumber = shopware_article_info.ordernumber and shopware_article_info.shop = 'oms' # One row per JOIN
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_properties
  Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma
- Left_Join:
  Datapool: export_for_dataengine
  Join_Condition: articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'oms'


Read_Conditions:  #sql where - Read-Filter
  - articles_new.active_oms = 1

Order_By: ordernumber, mainnumber ASC

Datapool_Definition:
 sku: VARCHAR(255) NOT NULL
 variation_parent_sku:  VARCHAR(255) DEFAULT NULL
 relationship_name:  VARCHAR(255) DEFAULT NULL
 title: VARCHAR(350)  DEFAULT NULL
 firma: VARCHAR(10) NOT NULL
 attr2: VARCHAR(3) DEFAULT NULL
 description: TEXT 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
 shipping: VARCHAR(255) DEFAULT NULL
# LBKALK: VARCHAR(255) DEFAULT NULL
 supplier: 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
 Fernbedienung: VARCHAR(100) DEFAULT NULL
 Dimmbar: VARCHAR(100) 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
 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
 active_ebay: VARCHAR(1) DEFAULT NULL
 active_amazon: VARCHAR(1) DEFAULT NULL
 active_otto: VARCHAR(1) DEFAULT NULL
 active_check24: VARCHAR(1) DEFAULT NULL
 Labels: VARCHAR(255) DEFAULT NULL

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 sku:
   Source: articles_new.ordernumber
 variation_parent_sku:
  Source: articles_new.mainnumber
  File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.variation_parent_sku
 relationship_name:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.relationship_name
 Produktart:
   Source: articles_new.name_oms
   Field_Adapter:
     - explode: [' ','0']
 description:
  Source: articles_new.description_long_oms
  Field_Adapter:
      - replace: [';', '']
  File_Field_Adapter:
      File: export_articles_oms_channelpilot_preisvergleiche.description
 category:
   Source: export_for_dataengine.category
 ean: articles_new.ean
 attr23: articles_new.swag_attr23
 wiederbeschaffungszeit: articles_new.attr12
 product_condition: (new)
 shipping: shopware_article_info.shipping
 supplier:
  Source: articles_new.supplier_oms
  Field_Adapter:
    - replace_empty: 'Sonstige'
 suppliernumber_original: ()
 tax:
  Source: articles_new.tax
 price_VK:
  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: sku #key for where condition from datapool
    Cross_Key: ordernumber #key for where condition from cross datapool
 pseudoprice_VK:
  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: sku #key for where condition from datapool
    Cross_Key: ordernumber #key for where condition from cross datapool
 supplier_number:
  Source: articles_new.suppliernumber
 active:
   Source: articles_new.active_oms
   In_Export: no
 configurator_options:
   Source: articles_new.configuratorOptions
 weight:
  Source: articles_new.weight
 firma:
    Source: articles_new.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles_new.attr2
     Field_Adapter:
       - replace: [';', '']
 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
 stock_witten:
   Source: iwm_articles_stock.witten
   In_Export: no
 stock_ir:
   Source: articles_new.stock_ir
   In_Export: no
 stock:
   Source: iwm_articles_stock.witten
   Field_Adapter:
     - replace_empty: '0'
   File_Field_Adapter:
     File: export_articles_oms_channelpilot_preisvergleiche.stock
 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: ' |'
 Fernbedienung:
   Source: iwm_articles_properties.Fernbedienung
 Dimmbar:
   Source: iwm_articles_properties.Dimmbar
 Abmessung:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Design:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Design:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Energieeffizienzklasse:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Energieeffizienzklasse:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Produktdatenblatt: () #articles_new.enev_download
 EEK_Label:
   Source: articles_new.enev_image
 Farbe:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Farbtemperatur:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Farbtemperatur:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Fassung:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Fassung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Flaechengewicht:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Flächengewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Fleachengewicht_exakt:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Flächengewicht exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Florhoehe:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Florhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Florhoehe_exakt:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Florhöhe exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Form:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Form:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 fuer_Fussbodenheizung_geeignet:
   Source: iwm_articles_properties.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.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Gesamtgewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Leistung:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Leistung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Lichtstrom:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Lichtstrom:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Material:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Muster:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Muster:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Raum:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Raum:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Stil:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Stil:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Typ:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Typ:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
 Durchmesser:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.Durchmesser
 Laenge:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.Laenge
 Breite:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.Breite
 Hoehe:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.Hoehe
 Tiefe:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.Tiefe
 Synonyme:
    Source: articles_new.swag_attr24
 Modellfamilie:
   Source: articles_new.modellfamilie
 sortiert:
    Source: articles_new.swag_attr26
 title:
  Source: articles_new.name_ost
  File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.title
 Bulletpoints:
  Source: articles_new.name_oms
  File_Field_Adapter:
    File: export_articles_oms_channelpilot_preisvergleiche.Bulletpoints
 imageUrl:
   Source: articles_new.imageUrl
   File_Field_Adapter:
     File: export_articles_oms_channelpilot_preisvergleiche.imageUrl
 bestellsperre: articles_new.bestellsperre
 auslaufkennzeichen: articles_new.auslaufkennzeichen





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_VK == '0') or (price_VK == '') or (price_VK == '0.00')  or (price_VK == '0,00')  or (price_VK == '0,0')
    reason: 'alle Preise = 0'
 - Filter:
    name: 'channelfilter moebel-shop.de -> Artikel, die auf moebel-shop.de nicht sind, bekommen sonst bei den Rückimportfeldern keine Kategorie und keine Versandkosten'
    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
         sku: ordernumber
         firma: attr1
         attr2: attr2
         unterwarengruppe: attr3
         systemnummer: attr4
         dispositionsart: attr11
         lieferzeitinwochen: attr12
         price_VK: price
         stock: stock
         stock_witten: stock_witten
         title: name
         description: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre
 - Filter:
     name: 'channelfilter channelpilot'
     condition:
       In_Pool_Filter_Adapter:
         Config: importEngine
         Datapool: static_filter_inactive_articles_channelpilot
         Reason_Key: reason
         Mapping: #left is from current datapool, right from filter datapool
           supplier_number: suppliernumber
           supplier: supplier_name
           sku: ordernumber
           Produktart: produktart
           firma: attr1
           attr2: attr2
           unterwarengruppe: attr3
           systemnummer: attr4
           dispositionsart: attr11
           lieferzeitinwochen: attr12
           price_VK: price
           stock_local: stock_local
           stock_witten: stock_witten
           stock: instock
           stock_ir: stock_ir
           title: name
           description: description
 #- 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
 #          sku: ordernumber
 #          firma: attr1
 #          attr2: attr2
 #          unterwarengruppe: attr3
 #          systemnummer: attr4
 #          dispositionsart: attr11
 #          lieferzeitinwochen: attr12
 #          price_VK: price
 #          stock: stock
 #          stock_witten: stock_witten
 #          title: name
 #          description: description
 #          auslaufkennzeichen: auslauf
 #          bestellsperre: bestellsperre


#Target
Datapool: export_articles_oms_channelpilot_preisvergleiche #sql table
Primary_Key: [sku, firma]