export / export_articles_oms_channelpilot

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



Order_By: ordernumber, mainnumber ASC


#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles_new.ordernumber
 mainnumber:
  Source: articles_new.mainnumber
 relationship_name:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.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.description
 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: ordernumber #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'
 suppliernumber_original: ()
 tax:
  Source: articles_new.tax
 Include_Mapping_prices_tre: prices_oms
 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
 supplier_for_otto:
   Source: articles_new.supplier_oms
   File_Field_Adapter:
     File: export_articles.supplier_for_otto
 supplier_for_check24:
   Source: articles_new.supplier_oms
   File_Field_Adapter:
     File: export_articles.supplier_for_check24
 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: [';', '']
 lieferzeit_text:
   Source: articles_new.lieferzeit
 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.stock
 Include_Mapping_properties: iwm_articles_properties.properties
 min_energy_efficiency_class: articles_new.enev_spectrumfrom
 max_energy_efficiency_class: articles_new.enev_spectrum
 certification:
   Source: articles_new.name_oms
   Cross_Field_Adapter:
     Config: unitizeEngine
     Cross_Datapool: iwm_articles_tvk_4_eprel #name of cross datapool
     Cross_Field: eprel #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
   File_Field_Adapter:
     File: export_articles.certification
 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
 Synonyme:
    Source: articles_new.swag_attr24
 Modellfamilie:
   Source: articles_new.modellfamilie
 sortiert:
    Source: articles_new.swag_attr26
 title:
  Source: articles_new.description_long_oms
  File_Field_Adapter:
    File: export_articles.title
 Bulletpoints:
  Source: articles_new.description_long_oms
  File_Field_Adapter:
    File: export_articles.Bulletpoints
 imageUrl:
   Source: articles_new.imageUrl
   File_Field_Adapter:
     File: export_articles.imageUrl
 bestellsperre: articles_new.bestellsperre
 auslaufkennzeichen: articles_new.auslaufkennzeichen
 active_amazon:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.active_amazon
 active_ebay:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.active_ebay
 active_otto:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles.active_otto
 active_check24:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles.active_check24
 active_kaufland:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles.active_kaufland
 Labels:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.Labels





Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Include_Filter: prices_equals_0
 - Filter:
    name: 'inactive for all platforms'
    condition: (active_ebay == 0) and (active_amazon == 0) and (active_otto == 0) and (active_check24 == 0)
    reason: 'inactive for all platforms'
# - Filter:
#    name: 'LBKALK < 50'
#    condition: (LBKALK < 50) and (ordernumber != '426493') and (ordernumber != '426494') and (supplier != 'SANSIBAR') and (attr2 != '79')
#    reason: 'LBKALK < 50'
# - Filter:
#    name: '(LBKALK < 70) and (attr2 == 10)'
#    condition: (LBKALK < 70) and (attr2 == '10') and (ordernumber != '426493') and (ordernumber != '426494') and (supplier != 'SANSIBAR')
#    reason: '(LBKALK < 70) and (attr2 == 10)'
# - Filter:
#    name: '(LBKALK < 70) and (attr2 == 20)'
#    condition: (LBKALK < 70) and (attr2 == '20') and (ordernumber != '426493') and (ordernumber != '426494') and (supplier != 'SANSIBAR')
#    reason: '(LBKALK < 70) and (attr2 == 20)'
# - Filter:
#    name: '(LBKALK < 70) and (attr2 == 29)'
#    condition: (LBKALK < 70) and (attr2 == '29') and (ordernumber != '426493') and (ordernumber != '426494') and (supplier != 'SANSIBAR')
#    reason: '(LBKALK < 70) and (attr2 == 29)'
# - Filter:
#    name: '(LBKALK < 70) and (attr2 == 30)'
#    condition: (LBKALK < 70) and (attr2 == '30') and (ordernumber != '426493') and (ordernumber != '426494') and (supplier != 'SANSIBAR')
#    reason: '(LBKALK < 70) and (attr2 == 30)'
# - Filter:
#    name: '(LBKALK < 70) and (attr2 == 40)'
#    condition: (LBKALK < 70) and (attr2 == '40') and (ordernumber != '426493') and (ordernumber != '426494') and (supplier != 'SANSIBAR')
#    reason: '(LBKALK < 70) and (attr2 == 40)'
# - Filter:
#    name: '(attr2 == 63)'
#    condition: (attr2 == '63') and (ordernumber != '426493') and (ordernumber != '426494')
#    reason: '(attr2 == 63)'
# - Filter:
#    name: '(attr2 == 97)'
#    condition: (attr2 == '97') and (ordernumber != '426493') and (ordernumber != '426494')
#    reason: '(attr2 == 97)'
# - Filter:
#    name: '(attr2 == 91) and (unterwarengruppe == 70)'
#    condition: (attr2 == '91') and (unterwarengruppe == '70') and (ordernumber != '426493') and (ordernumber != '426494')
#    reason: '(attr2 == 91) and (unterwarengruppe == 70)'
# - Filter:
#    name: '(stock_witten < 1)'
#    condition: (stock_witten < 1) and (ordernumber != '426493') and (ordernumber != '426494') and (dispositionsart == 'L')
#    reason: '(stock_witten < 1)'
# - Filter:
#    name: '(attr2 == 91) and (price <= 25)'
#    condition: (attr2 == '91') and (price <= 25) and (ordernumber != '426493') and (ordernumber != '426494')
#    reason: '(attr2 == 91) and (price <= 25)'
# - Filter:
#    name: Wiederbeschaffungszeit
#    condition: (lieferzeitinwochen > 6) AND (dispositionsart == 'L') AND (stock == 0) AND (attr2 > 89)
#    reason: '(lieferzeitinwochen > 6) AND (dispositionsart == L) AND (stock == 0) AND (attr2 > 89)'
# - Filter:
#    name: 'Wiederbeschaffungszeit'
#    condition: (lieferzeitinwochen > 4) AND (dispositionsart == 'L') AND ('stock' == 0) AND (supplier == 'Casa Nova')
#    reason: 'Wiederbeschaffungszeit'
# - Filter:
#    name: filter_suppliers
#    condition: supplier == 'PAIDI' or supplier == 'weber' or supplier == 'vito' or supplier == 'MONDO' or supplier == 'VALMONDO' or supplier == 'LIV´IN' or supplier == 'SELF' or supplier == 'KETTLER' or supplier == 'hülsta' or supplier == 'Kollektion-Wiedemann' or supplier == 'ROLF BENZ'
#    output: positive
#    reason: 'excluded supplier'
# - Filter:
#    name: 'keine Leuchte'
#    condition: (attr2 != 91) and (attr2 != 92) and (attr2 != 93) and (attr2 != 96) and (attr2 != 103) and (attr2 != 81)
#    reason: 'keine Leuchte'
 - 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
         ordernumber: ordernumber
         firma: attr1
         attr2: attr2
         unterwarengruppe: attr3
         systemnummer: attr4
         dispositionsart: attr11
         lieferzeitinwochen: attr12
         price: price
         stock: stock
         stock_witten: stock_witten
         title: name
         description: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre
 - Filter:
    name: 'Artikeldeaktivierung Gesamtmengenfilter'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_oms_channelpilot_marketplaces
        Reason_Key: reason
        Mapping: #left is from current datapool, right from filter datapool
         supplier_number: supplier_number
         supplier: supplier_name
         ordernumber: ordernumber
         firma: attr1
         attr2: attr2
         unterwarengruppe: attr3
         systemnummer: attr4
         dispositionsart: attr11
         lieferzeitinwochen: attr12
         price: price
         stock: stock
         stock_witten: stock_witten
         title: name
         description: description
         sortiert: sortiert
         LBKALK: LBKALK
 #- Filter:
 #    name: 'channel group filter online shops'
 #    condition:
 #      In_Pool_Filter_Adapter:
 #        Config: importEngine
 #        Datapool: static_filter_inactive_articles_online
 #        Reason_Key: reason
 #        Mapping: #left is from current datapool, right from filter datapool
 #          supplier_number: supplier_number
 #          supplier: supplier_name
 #          ordernumber: ordernumber
 #          firma: attr1
 #          attr2: attr2
 #          unterwarengruppe: attr3
 #          systemnummer: attr4
 #          dispositionsart: attr11
 #          lieferzeitinwochen: attr12
 #          price: price
 #          stock: stock
 #          stock_witten: stock_witten
 #          title: name
 #          description: description
 #          auslaufkennzeichen: auslauf
 #          bestellsperre: bestellsperre


#Target
Datapool: export_articles_oms_channelpilot #sql table
Primary_Key: [ordernumber, firma]