export / export_articles_parents_oms_channeladvisor

#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
  - articles_new.ordernumber like '%-1'


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
  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) NOT 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
  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: INT(1) DEFAULT NULL
  active_amazon: INT(1) DEFAULT NULL
  active_otto: INT(1) DEFAULT NULL
  active_check24: INT(1) DEFAULT NULL
  Labels: VARCHAR(255) DEFAULT NULL


#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 sku:
   Source: articles_new.mainnumber
   Field_Adapter:
     - replace: ['-1','-0']
 variation_parent_sku: (Parent)
 relationship_name:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.relationship_name
 Produktart:
   Source: articles_new.name_oms
   Field_Adapter:
     - explode: [' ','0']
 description:
   Source: articles_new.description_long_oms
   Field_Adapter:
     - replace: [';', '']
 category:
   Source: export_for_dataengine.category
 ean: articles_new.ean
 attr23: articles_new.swag_attr23
 wiederbeschaffungszeit: articles_new.attr12
 product_condition: (new)
 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: sku #key for where condition from datapool
     Cross_Key: ordernumber #key for where condition from cross datapool
 supplier:
   Source: articles_new.supplier_oms
   Field_Adapter:
     - replace_empty: 'Sonstige'
 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
 suppliernumber_original: ()
 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
   In_Export: no
 stock_witten:
   Source: iwm_articles_stock.witten
   In_Export: no
 stock_ir:
   Source: articles_new.stock_ir
   In_Export: no
 stock: (0)
 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: ' |'
 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: () #articles_new.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_parents_oms_channeladvisor.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_parents_oms_channeladvisor.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_parents_oms_channeladvisor.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_parents_oms_channeladvisor.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_parents_oms_channeladvisor.Tiefe
 Synonyme:
   Source: articles_new.swag_attr24
 Modellfamilie:
   Source: articles_new.modellfamilie
 sortiert:
   Source: articles_new.swag_attr26
 title:
   Source: articles_new.name_oms
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.title
 Bulletpoints:
   Source: articles_new.name_oms
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.Bulletpoints
 imageUrl: articles_new.imageUrl
 bestellsperre: articles_new.bestellsperre
 auslaufkennzeichen: articles_new.auslaufkennzeichen
 active_amazon:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.active_amazon
 active_ebay:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.active_ebay
 active_otto:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.active_otto
 active_check24:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.active_check24
 Labels:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles_parents_oms_channeladvisor.Labels



Filters:
 - Filter:
    name: Filter articles that are not in main feed
    condition:
      Not_In_Pool_Filter_Adapter:
        Config: exportEngine
        Datapool: export_articles_oms_channeladvisor
        Local_Key: sku
        Cross_Key: variation_parent_sku
    reason: 'Filter articles that are not in main feed'



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