export / export_articles_texts

#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

#Read_Conditions:  #sql where - Read-Filter
#  - articles_new.ordernumber NOT IN (SELECT ordernumber FROM article_texts_generated_persistant_ost) -> damit alle Artikel bei Artikeländerungen geprüft werden.
#  - articles_new.attr2 = 20 or (articles_new.attr2 = 29 and articles_new.attr3 IN (21,22,23,24,25,26,27,28,29))
#  - articles_new.ordernumber NOT IN (SELECT ordernumber FROM article_texts_generated_persistant_tre)
#  - articles_new.ordernumber NOT IN (SELECT ordernumber FROM article_texts_generated_persistant_oms)
#  - (articles_new.attr2 = 29 and articles_new.attr3 in (32, 33, 34, 35)) or (articles_new.attr2 = 30 AND articles_new.attr3 in (11, 12, 13, 14, 31, 32, 52, 81, 91)) or (articles_new.attr2 = 50 AND articles_new.attr3 = 52) or (articles_new.attr2 = 80 and articles_new.attr3 in (51, 52, 53)) or (articles_new.name_ost like '%Stuhl%' or articles_new.name_ost like '%Freischwinger%' or articles_new.name_ost like '%barhocker%' or articles_new.name_ost like '%chefsessel%' or  articles_new.name_ost like '%drehsessel%' or  articles_new.name_ost like '%schalensessel%')
#  - articles_new.name_ost not like '%hocker%'
#  - articles_new.name_ost not like '%sessel%'
#  - articles_new.name_ost not like '%tisch%'
#  - articles_new.name_ost not like '%bank%'
#  - articles_new.name_ost not like '%wohnwand%'
#  - articles_new.name_ost not like 'sessel%'
#  - articles_new.name_ost not like '%sessel'
#  - articles_new.name_ost not like '%untergestell%'
#  - articles_new.attr2 != '95'
#  - articles_new.attr2 != '81'
#  - articles_new.name_ost not like 'tisch%'
#  - articles_new.name_ost not like '%tisch'
#  - articles_new.name_ost not like '%bank'
#  - articles_new.name_ost not like 'bank%'
#  - articles_new.attr2 = '91' #leuchten
#  - articles_new.attr2 = '97' #teppiche
#  - articles_new.attr2 = '96' and (articles_new.attr3 in (40,41)) #Bettwäsche
#  - articles_new.attr2 = '70' and (articles_new.attr3 in (11,61)) #Kommoden
#  - articles_new.attr2 = '40' and (articles_new.attr3 in (51)) #Kommoden
#  - articles_new.attr2 = '92' and (articles_new.attr3 in (58)) #Dekoration
#  - articles_new.attr2 = '40' and (articles_new.attr3 in (81,82)) #Matratzen
#  - articles_new.attr2 = '40' and (articles_new.attr3 in (30,41,42,43,44)) #Betten

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles_new.ordernumber
 mainnumber:
  Source: articles_new.mainnumber
 arte:
  Source: articles_new.arte
 name_ost:
  Source: articles_new.name_ost
 name_tre:
   Source: articles_new.name_tre
 name_oms:
   Source: articles_new.name_oms
 supplier_oms:
  Source: articles_new.supplier_oms
  Field_Adapter:
    - replace_empty: 'Sonstige'
 supplier_ost:
   Source: articles_new.supplier_ost
   Field_Adapter:
     - replace_empty: 'Sonstige'
 supplier_tre:
   Source: articles_new.supplier_tre
   Field_Adapter:
     - replace_empty: 'Sonstige'
 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
 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.attr6
     Field_Adapter:
       - replace: [';', '']
 attr7:
     Source: articles_new.attr7
     Field_Adapter:
       - replace: [';', '']
 attr8:
     Source: articles_new.attr8
     Field_Adapter:
       - replace: [';', '']
 attr9:
     Source: articles_new.attr9_strip
     Field_Adapter:
       - replace: [';', '']
 attr10:
     Source: articles_new.attr10
     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
 attr17:
     Source: articles_new.attr17
     Field_Adapter:
       - replace: [';', '']
 attr18: (0)
 attr19:
     Source: articles_new.attr19
     Field_Adapter:
       - replace: [';', '']
 attr20:
     Source: articles_new.name_oms
     Field_Adapter:
       - replace: [';', '']
 attr23:
     Source: articles_new.swag_attr23
     Field_Adapter:
       - replace: [';', '']
 attr24: #Synonyme
     Source: articles_new.swag_attr24
 attr26: #sortierte Ware
     Source: articles_new.swag_attr26
 attr27: #Produktart
     Source: articles_new.swag_attr27
 attr28: #Produktart
     Source: articles_new.swag_attr28
 attr29: #Produktart
     Source: articles_new.swag_attr29
 attr30: #stock local
   Source: articles_new.attr30
   Field_Adapter:
     - replace_empty: 0
 attr31: #stock inventory
   Source: articles_new.attr31
   Field_Adapter:
     - replace_empty: 0
 attr32: #google category
   Source: articles_new.cat_google
 attr33: #ebay category
   Source: articles_new.cat_ebay
 attr34: #amazon category
   Source: articles_new.cat_amazon
 attr35: #lieferzeit für lagernde Ware
   Source: articles_new.lieferzeit
 attr41: articles_new.attr41
 attr49: articles_new.modellfamilie
 ean: articles_new.ean
 stock_witten:
     Source: iwm_articles_stock.witten
     Field_Adapter:
       - replace_empty: 0
     In_Export: no
 kind: articles_new.kind
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: 0
 weight:
  Source: articles_new.weight
  Field_Adapter:
   - float_pricision: 2
 bestellsperre_oms:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_oms #name of cross datapool
     Cross_Field: bestellsperre_online #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: 'N'
 auslaufkennzeichen_oms:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_oms #name of cross datapool
     Cross_Field: auslaufkennzeichen_online #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: 'N'
 bestellsperre_ost:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_ost #name of cross datapool
     Cross_Field: bestellsperre_online #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: 'N'
 auslaufkennzeichen_ost:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_ost #name of cross datapool
     Cross_Field: auslaufkennzeichen_online #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: 'N'
 bestellsperre_tre:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_tre #name of cross datapool
     Cross_Field: bestellsperre_online #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: 'N'
 auslaufkennzeichen_tre:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_bestellsperre_und_auslauf_tre #name of cross datapool
     Cross_Field: auslaufkennzeichen_online #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: 'N'
 prop1: articles_new.prop1  #Farbe
 prop2: articles_new.prop2	#Breite
 prop3: articles_new.prop3	#Länge
 prop4: articles_new.prop4	#Höhe
 prop5: articles_new.prop5	#Abmessung
 prop10: articles_new.prop10	#Modell
 prop11: articles_new.prop11	#Material
 prop12: articles_new.prop12	#Raum
 prop50: articles_new.prop50	#Matratze Größe
 prop51: articles_new.prop51	#Matratze Härtegrad
 prop52: articles_new.prop52	#Matratze Bezugsmaterial
 prop53: articles_new.prop53	#Matratze Matratzenart
 prop60: articles_new.prop60	#Teppich Flächengewicht
 prop61: articles_new.prop61	#Teppich Florhöhe
 prop62: articles_new.prop62	#Teppich Fußbodenheizung
 prop63: articles_new.prop63	#Teppich Form
 prop64: articles_new.prop64	#Teppich Muster
 enev_color: articles_new.enev_color
 enev_download: articles_new.enev_download
 enev_image: articles_new.enev_image
 enev_klasse: articles_new.enev_klasse
 enev_spectrumfrom: articles_new.enev_spectrumfrom
 enev_spectrum: articles_new.enev_spectrum
 enev_active: articles_new.enev_active
 farbe_exakt: iwm_articles_properties.farbe_exakt
 farbe: iwm_articles_properties.farbe
 material: iwm_articles_properties.material
 stil: iwm_articles_properties.stil
 gewicht: iwm_articles_properties.gewicht
 groesse: iwm_articles_properties.groesse
 knuepfart: iwm_articles_properties.knuepfart
 dim1: iwm_articles_properties.dim1
 dim2: iwm_articles_properties.dim2
 dim3: iwm_articles_properties.dim3
 Breite: iwm_articles_properties.Breite
 Laenge: iwm_articles_properties.Laenge
 Hoehe:
   Source: iwm_articles_properties.Hoehe
 Tiefe:
   Source: iwm_articles_properties.Tiefe
 Durchmesser:
   Source: iwm_articles_properties.Durchmesser
 abmessung:
   Source: iwm_articles_properties.abmessung
 funktion:
   Source: iwm_articles_properties.funktion
 ausfuehrungsart: iwm_articles_properties.ausfuehrungsart
 bezug: iwm_articles_properties.bezug
 massagefunktion: iwm_articles_properties.massagefunktion
 aufstehhilfe: iwm_articles_properties.Aufstehhilfe
 Produkteigenschaften:
   Source: iwm_articles_properties.Produkteigenschaften
 PLPKAT: iwm_articles_properties.PLPKAT
 Fassung:
   Source: iwm_articles_properties.Fassung
 Energieeffizienzklasse: iwm_articles_properties.Energieeffizienzklasse
 Lichtstrom:
   Source: iwm_articles_properties.Lichtstrom
 Leistung:
  Source: iwm_articles_properties.Leistung
 Lebensdauer:
   Source: iwm_articles_properties.Lebensdauer
 Farbtemperatur:
   Source: iwm_articles_properties.Farbtemperatur
 Matratzenart:
  Source: iwm_articles_properties.Matratzenart
 Florhoehe_exakt:
   Source: iwm_articles_properties.Florhoehe_exakt
 Florhoehe:
   Source: iwm_articles_properties.Florhoehe
 Flaechengewicht_exakt:
   Source: iwm_articles_properties.Flaechengewicht_exakt
 Flaechengewicht:
   Source: iwm_articles_properties.Flaechengewicht
 Raum:
   Source: iwm_articles_properties.Raum
 Scheuertouren:
   Source: iwm_articles_properties.Scheuertouren
 Qualitaet:
   Source: iwm_articles_properties.Qualitaet
 IP:
   Source: iwm_articles_properties.IP
 Farbwechsler:
   Source: iwm_articles_properties.Farbwechsler
 Fernbedienung:
   Source: iwm_articles_properties.Fernbedienung
 Farbtemparatureinstellbar:
   Source: iwm_articles_properties.Farbtemparatureinstellbar
 Dimmbar:
   Source: iwm_articles_properties.Dimmbar
 fuer_fussbodenheizung_geeignet:
   Source: iwm_articles_properties.fuer_fussbodenheizung_geeignet
 Typ:
   Source: iwm_articles_properties.Typ
 Form:
   Source: iwm_articles_properties.Form
 Design:
   Source: iwm_articles_properties.Design
 Gesamtgewicht: iwm_articles_properties.Gesamtgewicht
 Muster:
   Source: iwm_articles_properties.Muster
 Liegeflaeche: iwm_articles_properties.Liegeflaeche
 Haertegrad: iwm_articles_properties.Haertegrad
 Dessin: iwm_articles_properties.Dessin
 Fuss: iwm_articles_properties.Fuss
 Tischplatte: iwm_articles_properties.Tischplatte
 Gestellfarbe: iwm_articles_properties.Gestellfarbe
 Front: iwm_articles_properties.Front
 Korpus: iwm_articles_properties.Korpus
 Anschlag: iwm_articles_properties.Anschlag
 Varianten: iwm_articles_properties.Varianten
 Holzart: iwm_articles_properties.Holzart
 Kissenbezug: iwm_articles_properties.Kissenbezug
 Sitzschale: iwm_articles_properties.Sitzschale
 Oberflaeche: iwm_articles_properties.Oberflaeche
 Fussform: iwm_articles_properties.Fussform
 Mass: iwm_articles_properties.Mass
 Fussfarbe: iwm_articles_properties.Fussfarbe
 Farbvariante: iwm_articles_properties.Farbvariante
 Sitz: iwm_articles_properties.Sitz
 Gestell: iwm_articles_properties.Gestell
 Materialvariante: iwm_articles_properties.Materialvariante
 Rueckenlehne: iwm_articles_properties.Rueckenlehne
 Polsterung: iwm_articles_properties.Polsterung
 Kontrastnaht: iwm_articles_properties.Kontrastnaht
 Leder: iwm_articles_properties.Leder
 Holzausfuehrung: iwm_articles_properties.Holzausfuehrung
 Sitzhoehe: iwm_articles_properties.Sitzhoehe
 Nahtart: iwm_articles_properties.Nahtart
 Korpus_und_Arbeitsplatte: iwm_articles_properties.Korpus_und_Arbeitsplatte
 Griff:  iwm_articles_properties.Griff
 Armlehne: iwm_articles_properties.Armlehne
 Ruecken: iwm_articles_properties.Ruecken
 Korpusbezug: iwm_articles_properties.Korpusbezug
 Sitz_und_Kissen: iwm_articles_properties.Sitz_und_Kissen
 Arbeitsplatte: iwm_articles_properties.Arbeitsplatte
 Innenkorpus: iwm_articles_properties.Innenkorpus
 Applikationsfarbe: iwm_articles_properties.Applikationsfarbe
 Wangenform: iwm_articles_properties.Wangenform
 Tischsaeule: iwm_articles_properties.Tischsaeule
 append_text:
   Source: articles_new.name_ost
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_texts_scanned #name of cross datapool
     Cross_Field: append_text #field to select value from in cross datapool
     Local_Key: arte #key for where condition from datapool
     Cross_Key: arte #key for where condition from cross datapool
 forbid_text_generation:
   Source: articles_new.name_ost
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_texts_scanned #name of cross datapool
     Cross_Field: forbid_text_generation #field to select value from in cross datapool
     Local_Key: arte #key for where condition from datapool
     Cross_Key: arte #key for where condition from cross datapool
 old_hash_oms:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: enhanceEngine
     Cross_Datapool: article_texts_generated_persistant_oms #name of cross datapool
     Cross_Field: hash #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
 new_hash_oms:
   Source: articles_new.name_ost
   File_Field_Adapter:
     File: export_articles_texts.new_hash_oms
 old_hash_ost:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: enhanceEngine
     Cross_Datapool: article_texts_generated_persistant_ost #name of cross datapool
     Cross_Field: hash #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
 new_hash_ost:
   Source: articles_new.name_ost
   File_Field_Adapter:
     File: export_articles_texts.new_hash_ost
 old_hash_tre:
   Source: articles_new.ordernumber
   Cross_Field_Adapter:
     Config: enhanceEngine
     Cross_Datapool: article_texts_generated_persistant_tre #name of cross datapool
     Cross_Field: hash #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
 new_hash_tre:
   Source: articles_new.name_tre
   File_Field_Adapter:
     File: export_articles_texts.new_hash_tre
 to_text: #bool 0/1
   Source: articles_new.name_ost
   File_Field_Adapter:
     File: export_articles_texts.to_text
 pending_text: #bool 0/1
   Source: articles_new.description_long_oms
   File_Field_Adapter:
     File: export_articles_texts.pending_text
# description_long_ost_manually:
#   Source: articles_new.description_long_oms
# description_long_tre_manually:
#   Source: articles_new.description_long_tre
# description_long_oms_manually:
#   Source: articles_new.description_long_oms
 category:
   Source: articles_new.ordernumber
   File_Field_Adapter:
     File: export_articles_texts.category
 description_long_ost:
   Source: articles_new.description_long_oms
   File_Field_Adapter:
     File: export_articles_texts.description_long_ost
 description_long_tre:
   Source: articles_new.description_long_tre
   File_Field_Adapter:
     File: export_articles_texts.description_long_tre
 description_long_oms:
   Source: articles_new.description_long_oms
   File_Field_Adapter:
     File: export_articles_texts.description_long_oms
 texted: #bool 0/1
   Source: articles_new.name_ost
   File_Field_Adapter:
     File: export_articles_texts.texted

#just to use for mapping export for 2txt to avoid
# to_text: ()
# pending_text: ()
# description_long_ost: ()
# description_long_tre: ()
# description_long_oms: ()
# texted: ()



#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 oder noch nicht ermittelt'
#    condition: (price_EK == '') or (price_EK == '0.00')  or (price_EK == '0,00')  or (price_EK == '0,0')
#    reason: 'alle Preise = 0 - evtl. noch nicht ermittelt'
# - 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_ost: supplier_name
#         ordernumber: ordernumber
#         attr1: attr1
#         attr2: attr2
#         attr3: attr3
#         attr4: attr4
#         attr11: attr11
#         attr12: attr12
#         price_EK: price
#         stock: stock
#         stock_witten: stock_witten
#         name_ost: name
#         description_long_ost: description
#         auslaufkennzeichen: auslauf
#         bestellsperre: bestellsperre


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