export / export_articles_tre-inhouse_old

#Connections
Source_Config: enhanceEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Source_Datapool: articles  #sql from

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma # One row per JOIN


Read_Conditions:  #sql where - Read-Filter
  - articles.attr1 = 3 AND articles.active_tre = 1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles.ordernumber
 mainnumber:
  Source: articles.mainnumber
 name:
  Source: articles.name_tre
 supplier:
  Source: articles.supplier_tre
 tax:
  Source: articles.tax
 kind:
   Source: articles.kind
 price_EK:
  Source: articles.price_tre
  Field_Adapter:
    - replace: [',', '']
    - replace: ['.', ',']
 pseudoprice_EK:
   Source: articles.pseudoprice_tre
   Field_Adapter:
     - replace: [',', '']
     - replace: ['.', ',']
 active:
   Source: articles.active_tre
 categoryPath:
  Source: articles.categoryPath_tre
  Field_Adapter:
     - addslashes
 configurator_options:
   Source: articles.configuratorOptions
 description_long:
  Source: articles.description_long_tre
  Field_Adapter:
      - replace: [';', '']
 attr1:
    Source: articles.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles.attr2
     Field_Adapter:
       - replace: [';', '']
 attr3:
     Source: articles.attr3
     Field_Adapter:
       - replace: [';', '']
 attr4:
     Source: articles.attr4
     Field_Adapter:
       - replace: [';', '']
 attr5:
     Source: articles.attr5
     Field_Adapter:
       - replace: [';', '']
 attr6:
     Source: articles.attr6
     Field_Adapter:
       - replace: [';', '']
 attr7:
     Source: articles.attr7
     Field_Adapter:
       - replace: [';', '']
 attr8:
     Source: articles.attr8
     Field_Adapter:
       - replace: [';', '']
 attr9:
     Source: articles.attr9
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles.attr10
     Field_Adapter:
       - replace: [';', '']
 attr11:
     Source: articles.attr11
     Field_Adapter:
       - replace: [';', '']
 attr12:
     Source: articles.attr12
     Field_Adapter:
       - replace: [';', '']
 attr13:
     Source: articles.attr13
     Field_Adapter:
       - replace: [';', '']
 attr14:
     Source: articles.attr14
     Field_Adapter:
       - replace: [';', '']
 attr15:
     Source: articles.attr15
     Source: articles.attr15
     Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_tre_inhouse #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: [';', '']
 attr16:
     Source: articles.attr16
     Field_Adapter:
       - replace: [';', '']
 attr17:
     Source: articles.attr17
     Field_Adapter:
       - replace: [';', '']
 attr18:
     Source: articles.attr18
     Field_Adapter:
       - replace: [';', '']
 attr19:
     Source: articles.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles.name_oms
     Field_Adapter:
       - replace: [';', '']
 swag_attr21:
     Source: articles.swag_attr21
     Field_Adapter:
       - replace: [';', '']
 swag_attr22:
  Source: articles.swag_attr22
  Field_Adapter:
      - addslashes
      - replace: [';','']
 swag_attr23:
     Source: articles.swag_attr23
     Field_Adapter:
       - replace: [';', '']
 swag_attr24:
     Source: articles.swag_attr24
     Field_Adapter:
       - replace: [';', '']
 swag_attr25:
     Source: articles.swag_attr25
     Field_Adapter:
       - replace: [';', '']
 swag_attr26:
     Source: articles.swag_attr26
     Field_Adapter:
       - replace: [';', '']
 swag_attr27:
     Source: articles.swag_attr27
     Field_Adapter:
       - replace: [';', '']
 swag_attr28:
     Source: articles.swag_attr28
     Field_Adapter:
       - replace: [';', '']
 swag_attr29:
     Source: articles.swag_attr29
     Field_Adapter:
       - replace: [';', '']
 swag_attr30:
     Source: articles.swag_attr30
     Field_Adapter:
       - replace: [';', '']
 ean: articles.ean
 imageUrl: articles.imageUrl
 weight:
  Source: articles.weight
  Field_Adapter:
    - replace: ['.00', '']
    - replace: [',', '']
    - simple_division: 1000
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 stock_witten:
   Source: iwm_articles_stock.witten
   Field_Adapter:
     - replace_empty: 0
 kind: articles.kind


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_EK == '0') or (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
    reason: 'alle Preise = 0'


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