export / export_articles_sovido_esstische

#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_properties
  Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma # One row per JOIN


Read_Conditions:  #sql where - Read-Filter
  - articles_new.attr1 = 1
  - articles_new.active_ost = 1
  - articles_new.attr2 = 10 or articles_new.attr2 = 29 or articles_new.attr2 = 30

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 Artikelnummer:
    Source: articles_new.ordernumber
 Textfeld_1_Produktname:
    Source: articles_new.name_ost
 Abmessung:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - replace: ['|','']
 Farbe:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - replace: ['|','']
 Stil:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Stil:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - replace: ['|','']
 Material:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - replace: ['|','']
 Gewicht:
   Source: iwm_articles_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Gewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - replace: ['|','']
 Bild_URL_1_Produktbild:
   Source: articles_new.imageUrl
   Field_Adapter:
     - explode: [',',0]
 Bild_URL_2_Produktbild:
   Source: articles_new.imageUrl
   Field_Adapter:
     - explode: [',',1]
 supplier:
   Source: articles_new.supplier_ost
   Field_Adapter:
     - replace: [' ', '']
     - tolower: 1
   In_Export: no
 attr2:
   Source: articles_new.attr2
   Field_Adapter:
     - replace: [';', '']
   In_Export: no
 attr3:
   Source: articles_new.attr3
   Field_Adapter:
     - replace: [';', '']
   In_Export: no
 stock_witten:
   Source: iwm_articles_stock.witten
   In_Export: no
 price_EK:
   Source: articles_new.price_ost
   In_Export: no
 attr11:
   Source: articles_new.attr11
   Field_Adapter:
     - replace: [';', '']
   In_Export: no
 stock_ir:
   Source: articles_new.stock_ir
   Field_Adapter:
     - replace_empty: 0
   In_Export: no
 name_ost:
   Source: articles_new.name_ost
   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: Mindestbestand
    condition: (price_EK < 6) AND (stock_witten < 10) AND (stock_ir < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand price_ost < 6 AND stock_witten < 10'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 25) AND (stock_witten < 3) AND (stock_ir < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand price_ost < 25 AND stock_witten < 3'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_EK < 100) AND (stock_witten < 1) AND (stock_ir < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand price_ost < 100 AND stock_witten < 1'
 - Filter:
    name: 'kein Esstisch'
    condition:
      File_Filter_Adapter: export_articles_sovido_esstische__filterNoEsstisch
    reason: 'kein Esstisch'
 - Filter:
    name: 'Fehlende Bilder'
    condition: (Bild_URL_1_Produktbild == '') or (Bild_URL_2_Produktbild == '') or (Farbe == 'Farbe:') or (Stil == 'Stil:') or (Material == 'Material:') or (Gewicht == '') or (Farbe == '') or (Stil == '') or (Material == '') or (Gewicht == '') or (Abmessung == '')
    reason: 'Fehlende Eigenschaften'


#Target
Datapool: export_articles_sovido_esstische #sql table
Primary_Key: [Artikelnummer]