export / export_articles_sovido_leuchten

#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 AND articles_new.active_ost = 1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 Artikelnummer:
    Source: articles_new.ordernumber
 Textfeld_1_Produktname:
    Source: articles_new.name_ost
 Textfeld_2_Abmessung:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_2_Abmessung
 Textfeld_3_Material:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_3_Material
 Textfeld_4_Farbtemperatur:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_4_Farbtemperatur
 Textfeld_5_Leistung:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_5_Leistung
 Textfeld_6_Lebensdauer:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_6_Lebensdauer
 Textfeld_7_Energieeffizienzklasse:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_7_Energieeffizienzklasse
 Textfeld_8_Leuchtmittel:
    Source: iwm_articles_properties.propertyValueName
    File_Field_Adapter:
      File: export_articles_sovido_leuchten.Textfeld_8_Leuchtmittel
 Bild_URL_1_Produktbild:
   Source: articles_new.imageUrl
   Field_Adapter:
     - explode: [',',0]
 Bild_URL_2_Produktbild:
   Source: articles_new.imageUrl
   Field_Adapter:
     - explode: [',',0]
 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

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: 'keine Leuchte'
    condition: (attr2 != 91)
    reason: 'keine Leuchte'
 - Filter:
    name: 'keine Leuchte'
    condition: (attr3 > 60)
    reason: 'keine Leuchte'
 - Filter:
    name: 'Fehlende Eigenschaften'
    condition: (Textfeld_1_Produktname == '') or (Textfeld_2_Abmessung == 'Größe:') or (Textfeld_3_Material == 'Material:') or (Textfeld_4_Farbtemperatur == 'Lichtfarbe:') or (Textfeld_5_Leistung == 'Leistung:') or (Textfeld_6_Lebensdauer == 'Lebensdauer:') or (Textfeld_6_Lebensdauer == 'Lebensdauer:0 Stunden') or (Textfeld_7_Energieeffizienzklasse == 'Energieeffizienzklasse') or (Textfeld_8_Leuchtmittel == 'Leuchtmittel')
    reason: 'Fehlende Eigenschaften'

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