export / export_articles_oms_backup

#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

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: iwm_articles_new_bssp_and_auslauf
  Join_Condition: articles_new.ordernumber = iwm_articles_new_bssp_and_auslauf.ordernumber AND articles_new.attr1 = iwm_articles_new_bssp_and_auslauf.firma and (iwm_articles_new_bssp_and_auslauf.verkaufshaus = 86 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 87)


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

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles_new.ordernumber
 mainnumber:
  Source: articles_new.mainnumber
 name:
  Source: articles_new.name_ost
 supplier:
  Source: articles_new.supplier_oms
 tax:
  Source: articles_new.tax
 price_EK:
  Source: articles_new.price_oms
  Field_Adapter:
    - replace: [',', '']
    - replace: ['.', ',']
 pseudoprice_EK:
   Source: articles_new.pseudoprice_oms
   Field_Adapter:
     - replace: [',', '']
     - replace: ['.', ',']
 baseprice_EK: (0)
 active:
   Source: articles_new.active_oms
 configurator_options:
   Source: articles_new.configuratorOptions
 description_long:
  Source: articles_new.description_long_oms
  Field_Adapter:
      - replace: [';', '']
 supplier_number: articles_new.suppliernumber
 attr1:
    Source: articles_new.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles_new.attr2
     Field_Adapter:
       - replace: [';', '']
 attr3:
     Source: articles_new.attr3
     Field_Adapter:
       - replace: [';', '']
 attr4:
     Source: articles_new.attr4
     Field_Adapter:
       - replace: [';', '']
 attr5:
     Source: articles_new.attr5
     Field_Adapter:
       - replace: [';', '']
 attr6:
     Source: articles_new.swag_attr22
     Field_Adapter:
       - replace: [';', '']
 attr7:
     Source: articles_new.attr7
     Field_Adapter:
       - replace: [';', '']
 attr8:
     Source: articles_new.attr8
     Field_Adapter:
       - replace: [';', '']
 attr9:
     Source: articles_new.attr9
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles_new.swag_attr25
     Field_Adapter:
       - replace: [';', '']
 attr11:
     Source: articles_new.attr11
     Field_Adapter:
       - replace: [';', '']
 attr12:
     Source: articles_new.attr12
     Field_Adapter:
       - replace: [';', '']
 attr13:
     Source: articles_new.attr13
     Field_Adapter:
       - replace: [';', '']
 attr14:
     Source: articles_new.attr14
     Field_Adapter:
       - replace: [';', '']
 attr15:
     Source: articles_new.attr15
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
        Cross_Field: shippingcosts #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: [';', '']
       - replace: [',','.']
 attr16:
     Source: articles_new.attr16
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_oms
        Cross_Field: montage
        Local_Key: ordernumber
        Cross_Key: ordernumber
     File_Field_Adapter:
        File: export_articles_oms.attr16
 attr17:
     Source: articles_new.swag_attr24
     Field_Adapter:
       - replace: [';', '']
 attr18: (0)
 attr19:
     Source: articles_new.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles_new.name_oms
     Field_Adapter:
       - replace: [';', '']
 ean: articles_new.ean
 stock_witten:
     Source: iwm_articles_stock.witten
     Field_Adapter:
       - replace_empty: '0'
     In_Export: no
 shipping_free: articles_new.shippingfree
 kind: articles_new.kind
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 weight:
  Source: articles_new.weight
  Field_Adapter:
    - replace: ['.00', '']
    - replace: [',', '']
    - simple_division: 1000
 bestellsperre: IF (iwm_articles_new_bssp_and_auslauf.bestellsperre = '', articles_new.bestellsperre, iwm_articles_new_bssp_and_auslauf.bestellsperre) as bestellsperre
 auslaufkennzeichen: IF (iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen = '', articles_new.auslaufkennzeichen, iwm_articles_new_bssp_and_auslauf.auslaufkennzeichen) as auslaufkennzeichen
 stock_ir:
   Source: articles_new.stock_ir
   Field_Adapter:
     - replace_empty: 0
   In_Export: no


Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Filter:
    name: Corona-Problem IR-Bestand
    condition: (stock_witten == '0') AND (stock_ir == '0') AND (attr2 == '91') AND (attr11 == 'B')
    reason: 'Corona-Problem IR-Bestand'
 - Filter:
    name: Mindestbestand  #there must always be a space between the key and the comparision operator
    condition: (price_EK < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)'
 - Filter:
    name: 'Preis ungueltig'
    condition: (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
    reason: 'alle Preise = 0'
 - Filter:
    name: 'Lieferant gesperrt'
    condition: (supplier == 'Wimmer Wohnkollektion GmbH')
    reason: 'Lieferant gesperrt'
 - Filter:
    name: 'Zu lange Lieferzeit'
    condition: (attr11 == 'L') and (attr12 > 6) and (stock == 0) and (attr2 > 89)
    reason: 'Zu lange Lieferzeit'
 - Filter:
    name: 'Zu lange Lieferzeit Suppliernumber 782577'
    condition: (attr11 == 'L') and (attr12 > 4) and (stock == 0) and (supplier == 'HPI')
    reason: 'Zu lange Lieferzeit Suppliernumber 782577'
 - Filter:
    name: 'Onlinesperre'
    condition:
      In_Pool_Filter_Adapter:
        Config: enhanceEngine
        Datapool: filter_onlinesperre
        Local_Key: supplier_number
        Cross_Key: LIEFNR
    reason: 'Onlinesperre'
 - Filter:
    name: Auslauf und kein Bestand in Witten - Lagerware
    condition: (auslaufkennzeichen == 'J') and (stock_witten == 0) and (price_EK < 149) and (attr11 == 'L')
    reason: Auslauf und kein Bestand in Witten - Lagerware
 - Filter:
    name: Auslauf und nirgendwo Bestand - Lagerware
    condition: (auslaufkennzeichen == 'J') and (stock == 0) and (price_EK > 149) and (attr11 == 'L')
    reason: Auslauf und nirgendwo Bestand - Lagerware
 - Filter:
    name: Auslauf und nirgendwo Bestand - Bestellware
    condition: (auslaufkennzeichen == 'J') and (attr1 == 1) and (attr2 > 80) and (attr11 == 'B') and (stock == 0)
    reason: Auslauf und nirgendwo Bestand - Bestellware
 - Filter:
    name: Bestellsperre und kein Bestand
    condition: (bestellsperre == 'J') and (stock == 0)
    reason: Bestellsperre und kein Bestand

#Target
Datapool: export_articles_oms #sql table
Primary_Key: [ordernumber, attr1]