enhance / enhance_articles_new

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

Enhance_Mode: flexible

#Engine Mode
Engine_Mode: delta

Add_Indices:
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_attr1_ordernumber
      Fields: attr1, ordernumber
  - Add_Index:
      Datapool: iwm_articles_stock
      Index_Name: idx_firma_ordernumber
      Fields: firma, ordernumber


#Source
Source_Datapool: iwm_articles_new  #sql from

Order_By: ordernumber ASC


Joins:
    - Left_Join:
      Datapool: iwm_articles_stock
      Join_Condition: iwm_articles_new.attr1 = iwm_articles_stock.firma and iwm_articles_new.ordernumber = iwm_articles_stock.ordernumber
    #- Left_Join:
    #  Datapool: dg_supplierdata_enhanced.iwm_articles_properties
    #  Join_Condition: iwm_articles_new.ordernumber = iwm_articles_properties.ordernumber and iwm_articles_new.attr1 = iwm_articles_properties.firma
    - Left_Join:
      Datapool: dg_supplierdata_enhanced.iwm_articles_properties_pil
      Join_Condition: iwm_articles_new.ordernumber = iwm_articles_properties_pil.ordernumber and iwm_articles_new.attr1 = iwm_articles_properties_pil.firma

Exclude_From_Hash: [instock, stock_ir, stock_witten, swag_attr23, attr30, attr31, attr37_pre_oms, attr37_pre_ost, attr37_pre_tre, attr37]



#Target
Datapool: articles_new #sql table
Target_Datapool: articles_new  #sql from
Primary_Key: [ordernumber, attr1]



#Mapping -> Mappings source fields are detected by Mapping
Mapping:
    ordernumber: iwm_articles_new.ordernumber
    mainnumber:
        Source: iwm_articles_new.mainnumber
        File_Field_Adapter:
            File: articles_new.mainnumber
    arte:
        Source: iwm_articles_new.arte
        File_Field_Adapter:
            File: articles_new.arte
    name_oms:
        Source: iwm_articles_new.name_oms
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_names_6
                  Cross_Field: name_oms
                  Mapping:
                      arte: arte
                      attr1: firma
                  Options:
                      - match_only: true
    name_tre:
        Source: iwm_articles_new.name_tre
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_names_6
                  Cross_Field: name_tre
                  Mapping:
                      arte: arte
                      attr1: firma
                  Options:
                      - match_only: true
    name_ost:
        Source: iwm_articles_new.name_ost
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_names_6
                  Cross_Field: name_ost
                  Mapping:
                      arte: arte
                      attr1: firma
                  Options:
                      - match_only: true
    tax:
        Source: iwm_articles_new.tax
        Field_Adapter:
            - replace: [',','.']
            - float_pricision: 2
    price_ost: ()
    price_tre: ()
    price_oms: ()
    shipping_ost: ()
    shipping_tre: ()
    shipping_oms: ()
    pseudoprice_ost: ()
    pseudoprice_tre: ()
    pseudoprice_oms: ()
    purchaseprice:
        Source: iwm_articles_new.purchaseprice
        Field_Adapter:
            - replace: [',','.']
            - float_pricision: 2
    baseprice: iwm_articles_new.baseprice
    active_ost: iwm_articles_new.active_ost
    active_tre: iwm_articles_new.active_tre
    active_oms: iwm_articles_new.active_oms
    description:
        Source: iwm_articles_new.description
        Field_Adapter:
            - addslashes:
            - replace: ['http://', 'https://']
    description_long_ost:
        Source: iwm_articles_new.description_long_ost
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: exportEngine
                  Cross_Datapool: export_articles_texts_online #name of cross datapool
                  Cross_Field: description_long_ost #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: attr1
        Field_Adapter:
          - replace: [ ';', '' ]
        File_Field_Adapter:
          File: export_articles_ost.description_long
          Engine: enhanceEngine
          Datapool: iwm_articles_properties
          Identifier: ordernumber
          Fields:
            - ordernumber
            - Produkteigenschaften
    description_long_tre:
        Source: iwm_articles_new.description_long_tre
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: exportEngine
                  Cross_Datapool: export_articles_texts_online #name of cross datapool
                  Cross_Field: description_long_tre #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: attr1
        Field_Adapter:
          - replace: [ ';', '' ]
        File_Field_Adapter:
          File: export_articles_tre.description_long
          Engine: enhanceEngine
          Datapool: iwm_articles_properties
          Identifier: ordernumber
          Fields:
            - ordernumber
            - Produkteigenschaften
    description_long_oms:
        Source: iwm_articles_new.description_long_oms
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: exportEngine
                  Cross_Datapool: export_articles_texts_online #name of cross datapool
                  Cross_Field: description_long_oms #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: attr1
        Field_Adapter:
          - replace: [ ';', '' ]
        File_Field_Adapter:
          File: export_articles_oms.description_long
          Engine: enhanceEngine
          Datapool: iwm_articles_properties
          Identifier: ordernumber
          Fields:
            - ordernumber
            - Produkteigenschaften
    added: iwm_articles_new.added
    changed: iwm_articles_new.changed
    unitID: iwm_articles_new.unitID
    attr9:
        Source: iwm_articles_new.attr9
        Field_Adapter:
            - addslashes
    variant_ean: iwm_articles_new.variant_ean
    suppliernumber_original: iwm_articles_new.suppliernumber_original
    suppliernumber:
        Source: iwm_articles_new.suppliernumber
        File_Field_Adapter:
            Engine: importEngine
            Datapool: static_mapping_suppliernumber
            Identifier: id
            File: articles_new.suppliernumber
            Fields:
                - id
                - name_ost
                - firma
                - systemnummer
                - lieferantennummer
                - attr9
                - hwg
                - suppliernumber
    ean:
        Source: iwm_articles_new.ean
        Field_Adapter:
            - str_pad: ['13', '0', 'left']
            - replace: ['0000000000000','']
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: iwm_articles_eans #name of cross datapool
                  Cross_Field: EAN #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      attr9: ATTR9
                      suppliernumber_original: SUPPLIERNUMBER_ORIGINAL
                  Options:
                      keep_existing: true
        File_Field_Adapter:
            File: articles_new.ean
    attr9_strip:
        Source: iwm_articles_new.attr9
        Field_Adapter:
            - replace: ['.','']
            - replace: [',','']
            - replace: ['(','']
            - replace: [')','']
            - replace: ['-','']
            - replace: ['_','']
            - replace: [' ','']
    categories: iwm_articles_new.categories
    referenceUnit: iwm_articles_new.referenceUnit
    supplier_ost:
        Source: iwm_articles_new.supplier_ost
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_3 #name of cross datapool
            Cross_Field: supplier_ost #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
    supplier_tre:
        Source: iwm_articles_new.supplier_tre
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_3 #name of cross datapool
            Cross_Field: supplier_tre #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
    supplier_oms:
        Source: iwm_articles_new.supplier_oms
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_3 #name of cross datapool
            Cross_Field: supplier_oms #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
    purchaseUnit: iwm_articles_new.purchaseUnit
    metaTitle: iwm_articles_new.metaTitle
    packUnit: iwm_articles_new.packUnit
    configSetId: iwm_articles_new.configSetId
    configuratorType: iwm_articles_new.configuratorType
    configuratorOptions:
        Source: iwm_articles_new.configuratorOptions
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_variants
            Cross_Field: configuratorOptions
            Local_Key: ordernumber
            Cross_Key: ordernumber
    kind:
        Source: iwm_articles_new.kind
        File_Field_Adapter:
            File: articles_new.kind
    weight:
        Source: iwm_articles_new.weight
    height:
        Source: iwm_articles_new.height
        Field_Adapter:
            - replace: [',','.']
            - float_pricision: 2
    width: iwm_articles_new.width
    swag_attr27: #Produktart
        Source: iwm_articles_new.name_oms
        Field_Adapter:
            - explode: [' ','0']
    categoryPath_ost:
        Source: iwm_articles_new.categoryPath_ost
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: shopware_article_info_ost
                  Cross_Field: category
                  Mapping:
                      ordernumber: ordernumber
    categoryPath_tre:
        Source: iwm_articles_new.categoryPath_tre
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: shopware_article_info_tre
                  Cross_Field: category
                  Mapping:
                      ordernumber: ordernumber
    categoryPath_oms:
        Source: iwm_articles_new.categoryPath_oms
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: shopware_article_info_oms
                  Cross_Field: category
                  Mapping:
                      ordernumber: ordernumber
    cat_google_produktart:
        Source: iwm_articles_new.cat_google
        Cross_Field_Adapters_Target_Injection:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: dynamic_mapping_categories
                  Cross_Field: google_category_ID
                  Mapping:
                      swag_attr27: Produktart
    cat_google_shop_category:
        Source: iwm_articles_new.cat_google
        Cross_Field_Adapters_Target_Injection:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: dynamic_mapping_categories
                  Cross_Field: google_category_ID
                  Mapping:
                      categoryPath_oms: Shop_category
    cat_google:
        Source: iwm_articles_new.cat_google
        File_Field_Adapter:
            File: articles_new.cat_google
    #       - Cross_Field_Adapter:
    #          Config: importEngine
    #          Cross_Datapool: dynamic_mapping_categories
    #          Cross_Field: google_category_ID
    #          Mapping:
    #            categoryPath_oms: Shop_category
    #          Options:
    #              - keep_existing: true
    cat_ebay:
        Source: iwm_articles_new.cat_ebay
        Cross_Field_Adapters_Target_Injection:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: static_mapping_categories
                  Cross_Field: ebay_category
                  Mapping:
                      categoryPath_oms: oms_category
    cat_amazon:
        Source: iwm_articles_new.cat_amazon
        Cross_Field_Adapters_Target_Injection:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: static_mapping_categories
                  Cross_Field: amazon_category
                  Mapping:
                      categoryPath_oms: oms_category
    propertyGroupName: iwm_articles_new.propertyGroupName
    propertyValueName: iwm_articles_new.propertyValueName
    farbe:
        Source: iwm_articles_new.ordernumber
        Cross_Field_Adapters_Target_Injection:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_properties
                  Cross_Field: farbe
                  Mapping:
                      ordernumber: ordernumber
                      attr1: firma
    material:
        Source: iwm_articles_new.ordernumber
        Cross_Field_Adapters_Target_Injection:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_properties
                  Cross_Field: material
                  Mapping:
                      ordernumber: ordernumber
                      attr1: firma
    accessory: iwm_articles_new.accessory
    attr1: iwm_articles_new.attr1
    attr2: iwm_articles_new.attr2
    attr3: iwm_articles_new.attr3
    attr4: iwm_articles_new.attr4
    attr5: iwm_articles_new.attr5
    attr6:
        Source: iwm_articles_new.attr6
        File_Field_Adapter:
            File: articles_new.attr6
    attr7: iwm_articles_new.attr7
    attr8: iwm_articles_new.attr8
    attr10:
        Source: iwm_articles_new.attr10
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: iwm_articles_tkz_2 #name of cross datapool
                  Cross_Field: TVK_2_PROPERTIES #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: ordernumber
    attr11: iwm_articles_new.attr11
    anlieferart:
        Source: iwm_articles_new.anlieferart
        File_Field_Adapter:
          File: articles_new.anlieferart
    stock_ir:
        Source: iwm_articles_stock.stock_inventory
#        Cross_Field_Adapter:
#            Config: unitizeEngine
#            Cross_Datapool: iwm_articles_stock #name of cross datapool
#            Cross_Field: stock_inventory #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
    instock:
        Source: iwm_articles_new.attr18
        Cross_Field_Adapters:
          - Cross_Field_Adapter:
              Config: enhanceEngine
              Cross_Datapool: iwm_articles_stock #name of cross datapool
              Cross_Field: stock #field to select value from in cross datapool
              Mapping: #cross field adapter with more than one key
                ordernumber: ordernumber
                attr1: firma
#        Cross_Field_Adapter:
#            Config: enhanceEngine
#            Cross_Datapool: iwm_articles_stock #name of cross datapool
#            Cross_Field: stock #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: 0
        File_Field_Adapter:
            File: articles_new.instock
    attr12:
        Source: iwm_articles_new.attr12
        File_Field_Adapter:
            Config: enhanceEngine
            Engine: enhanceEngine
            Datapool: iwm_articles_lieferzeit_gesamt_mit_ausfallzeit
            Identifier: ordernumber
            File: articles_new.attr12
            Fields:
                - ordernumber
                - lieferzeit
                - firma
        Field_Adapter:
            - replace_empty: 0
            - replace_smaller: [0,0]
    attr13:
        Source: iwm_articles_new.attr13
        File_Field_Adapter:
            File: articles_new.attr13
    attr14:
        Source: iwm_articles_new.attr14
        File_Field_Adapter:
            File: articles_new.attr14
        Field_Adapter:
            - replace_empty: 0
            - replace_smaller: [0,0]
    attr16:
        Source: iwm_articles_new.attr16
        File_Field_Adapter:
          Config: importEngine
          Engine: importEngine
          Datapool: montagekosten
          Identifier: Produktart
          File: articles_new.attr16
          Fields:
            - Produktart
            - Montage
    attr17:
        Source: iwm_articles_new.attr17
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: iwm_articles_tkz_3 #name of cross datapool
                  Cross_Field: TVK_3_PROPERTIES #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: ordernumber
    attr18:
        Source: iwm_articles_new.attr18
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_prices #name of cross datapool
            Cross_Field: attr18 #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
    attr19: iwm_articles_new.attr19
    swag_attr23:
        Source: iwm_articles_stock.stock_inventory
        Field_Adapter:
            - replace_empty: 0
            - replace_not_equals: ['0', '1']
    swag_attr21:
        Source: iwm_articles_new.swag_attr21
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_kojen_per_article #name of cross datapool
                  Cross_Field: kojencode #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: mainnumber
                      attr1: firma
    swag_attr24:
        Source: iwm_articles_new.swag_attr24
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: synonyme_articles #name of cross datapool
                  Cross_Field: Synonyme #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: arte
            - Cross_Field_Adapter:
                  Config: importEngine
                  Cross_Datapool: iwm_articles_tkz_0 #name of cross datapool
                  Cross_Field: PROPERTIES #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: ordernumber
                  Options:
                      concat: ' '
    swag_attr25: iwm_articles_new.swag_attr25
    swag_attr26: #sortierte Ware
        Source: iwm_articles_new.konsigniert
    attr15: #Shippingcosts in_addition
        Source: iwm_articles_new.attr15
        File_Field_Adapter:
            Config: importEngine
            Engine: importEngine
            Datapool: versandkosten_addition
            Identifier: id
            File: articles_new.attr15
            Fields:
                - id
                - name
    swag_attr29:
        Source: iwm_articles_new.swag_attr29 #carrier
        File_Field_Adapter:
            File: articles_new.swag_attr29
    attr30: #local stock -> sum of local stocks without exhibition stocks
        Source: iwm_articles_new.attr18
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_stock #name of cross datapool
                  Cross_Field: stock_local #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: firma
        Field_Adapter:
            - replace_empty: 0
    attr31: # ir stock
        Source: iwm_articles_stock.stock_inventory
#        Cross_Field_Adapter:
#            Config: unitizeEngine
#            Cross_Datapool: iwm_articles_stock #name of cross datapool
#            Cross_Field: stock_inventory #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
    attr36: () #finanzierbare produkte -> gefüllt im export
    imageUrl:
        Source: iwm_articles_new.imageUrl
        File_Field_Adapter:
            File: articles_new.imageUrl
    ItemImageDate:
        Source: iwm_articles_new.ItemImageDate
        File_Field_Adapter:
            File: articles_new.ItemImageDate
    stock_witten:
        Source: iwm_articles_new.attr18
        Cross_Field_Adapters:
          - Cross_Field_Adapter:
              Config: enhanceEngine
              Cross_Datapool: iwm_articles_stock #name of cross datapool
              Cross_Field: witten #field to select value from in cross datapool
              Mapping: #cross field adapter with more than one key
                ordernumber: ordernumber
                attr1: firma
#        Cross_Field_Adapter:
#            Config: enhanceEngine
#            Cross_Datapool: iwm_articles_stock #name of cross datapool
 #           Cross_Field: witten #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: 0
    shippingfree: iwm_articles_new.shippingfree
#    attr37_pre_oms:
#        Source: iwm_articles_new.name_oms
#        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
#    attr37_pre_ost:
#        Source: iwm_articles_new.name_oms
#        Cross_Field_Adapter:
#            Config: exportEngine
#            Cross_Datapool: export_iwm_articles_prices_ost #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
#    attr37_pre_tre:
#        Source: iwm_articles_new.name_oms
#        Cross_Field_Adapter:
#            Config: exportEngine
#            Cross_Datapool: export_iwm_articles_prices_tre #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: [',','.']
#            - float_pricision: 2
#    attr37: #shipping costs (calculated in dataEngine)
#        Source: iwm_articles_new.shippingfree
#        File_Field_Adapter:
 #           Config: enhanceEngine
 #           Engine: enhanceEngine
 #           Datapool: iwm_articles_prices
 #           Identifier: ordernumber
 #           File: articles_new.attr37
 #           Fields:
 #               - ordernumber
 #               - verkaufshaus
 #               - abholpreis
 #               - lieferpreis
 #               - vollservicepreis
    attr38: #shipping time (calculated in dataEngine)
        Source: iwm_articles_new.shippingfree
        File_Field_Adapter:
            File: articles_new.attr38
    attr41: #enev new scale (1 = new scale, 0 = old scale)
        Source: iwm_articles_new.attr41
        File_Field_Adapter:
            File: articles_new.attr41
    attr48:
        Source: iwm_articles_new.attr48
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: diomex_config #name of cross datapool
                  Cross_Field: mainnumber #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: firma
        Field_Adapter:
            - replace_not_equals: ['','1']
    attr50:
        Source: iwm_articles_new.attr50
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: wandmontage_articles #name of cross datapool
                  Cross_Field: Wandmontage #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: arte
                      attr1: firma
    attr53:
        Source: iwm_articles_new.attr53
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_properties #name of cross datapool
                  Cross_Field: farbe #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: firma
    attr54: #Kalkulationsindex calculated in export
        Source: iwm_articles_new.attr54
    attr55:
        Source: iwm_articles_new.attr55
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: prospektartikel_gesamt #name of cross datapool
                  Cross_Field: text #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: arte
                      attr1: firma
        File_Field_Adapter:
            File: articles_new.attr55
     #   Field_Adapter:
     #       - replace_not_equals: ['Prospektartikel','Artikel']
    attr57: #Eigenmarke (0/1)
        Source: iwm_articles_new.attr57
        File_Field_Adapter:
            File: articles_new.attr57
    attr60:
        Source: iwm_articles_new.name_ost
        Cross_Field_Adapter:
            Config: enhanceEngine
            Engine: enhanceEngine
            Cross_Datapool: iwm_articles_properties #name of cross datapool
            Cross_Field: Form #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
    attr61: #nicht überschriebene Wiederbeschaffungszeit
        Source: iwm_articles_new.attr61
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_lieferzeit_gesamt_mit_ausfallzeit #name of cross datapool
            Cross_Field: lieferzeit #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
        File_Field_Adapter:
            File: articles_new.attr61
    attr67: #nicht überschriebene Wiederbeschaffungszeit
      Source: iwm_articles_new.attr67
  #    Cross_Field_Adapter:
  #      Config: importEngine
  #      Cross_Datapool: verpackungseinheit #name of cross datapool
  #      Cross_Field: Anzahl #field to select value from in cross datapool
  #      Local_Key: ordernumber #key for where condition from datapool
  #      Cross_Key: Artikel #key for where condition from cross datapool
      Cross_Field_Adapters:
          - Cross_Field_Adapter:
              Config: importEngine
              Cross_Datapool: verpackungseinheit #name of cross datapool
              Cross_Field: Anzahl #field to select value from in cross datapool
              Mapping: #cross field adapter with more than one key
                ordernumber: Artikel
    tpl_color_badge:
        Source: iwm_articles_new.tpl_color_badge
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: varianten #name of cross datapool
            Cross_Field: tpl_color_badge #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
        Field_Adapter:
            - replace_empty: 0
    textilkennzeichen_text:
        Source: iwm_articles_new.textilkennzeichen_text
      #  Cross_Field_Adapters:
      #    - Cross_Field_Adapter:
      #        Config: enhanceEngine
      #        Cross_Datapool: iwm_articles_textilkennzeichen_8 #name of cross datapool
      #        Cross_Field: textilkennzeichen #field to select value from in cross datapool
      #        Mapping: #cross field adapter with more than one key
      #          ordernumber: ordernumber
      #          attr1: firma
        Cross_Field_Adapter:
            Config: enhanceEngine
            Engine: enhanceEngine
            Cross_Datapool: iwm_articles_textilkennzeichen_8 #name of cross datapool
            Cross_Field: textilkennzeichen #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
    AHLZSD:
        Source: iwm_articles_new.AHLZSD
        Cross_Field_Adapter:
            Config: unitizeEngine
            Engine: unitizeEngine
            Cross_Datapool: iwm_articles_arhp #name of cross datapool
            Cross_Field: AHLZSD #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
    ARKMFR:
        Source: iwm_articles_new.ARKMFR
    nutschicht:
        Source: iwm_articles_new.nutschicht
    textilkennzeichen_needed:
        Source: iwm_articles_new.textilkennzeichen_needed
        File_Field_Adapter:
            Config: importEngine
            Engine: importEngine
            Datapool: static_mapping_textilkennzeichen_flag
            Identifier: id
            File: articles_new.textilkennzeichen_needed
            Fields:
                - id
                - hwg
                - uwg
                - keyword
                - AHLZSD
                - ARKMFR
                - nutschicht
                - textilkennzeichen_needed
    has_textilkennzeichen:
        Source: iwm_articles_new.has_textilkennzeichen
        File_Field_Adapter:
            File: articles_new.has_textilkennzeichen
    pil_needed_static:
        Source: iwm_articles_new.pil_needed_static
        File_Field_Adapter:
            Config: importEngine
            Engine: importEngine
            Datapool: static_mapping_pil_flag
            Identifier: id
            File: articles_new.pil_needed_static
            Fields:
                - id
                - hwg
                - uwg
                - keyword
                - ARKMFR
                - pil_needed
    pil_needed_dynamic:
        Source: iwm_articles_new.pil_needed_dynamic
        File_Field_Adapter:
            Config: importEngine
            Engine: importEngine
            Datapool: pflicht_enev
            Identifier: id
            File: articles_new.pil_needed_dynamic
            Fields:
                - id
                - Teilwort
    pil_needed:
        Source: iwm_articles_new.pil_needed
        File_Field_Adapter:
            File: articles_new.pil_needed
    pil_text:
        Source: iwm_articles_new.pil_text
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_properties_pil #name of cross datapool
                  Cross_Field: pil_html_gesamt #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber
                      attr1: firma
    has_pil:
        Source: iwm_articles_new.has_pil
        File_Field_Adapter:
            File: articles_new.has_pil
    ahstat:
        Source: iwm_articles_new.ahstat
        Cross_Field_Adapter:
            Config: unitizeEngine
            Cross_Datapool: iwm_articles_arhp #name of cross datapool
            Cross_Field: ahstat #field to select value from in cross datapool
            Mapping: #cross field adapter with more than one key
                ordernumber: ordernumber
                attr1: firma
    LBNTEK:
        Source: iwm_articles_new.LBNTEK
        Cross_Field_Adapter:
            Config: unitizeEngine
            Cross_Datapool: iwm_ek_prices_new #name of cross datapool
            Cross_Field: A9K300 #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
    LBKALK:
        Source: iwm_articles_new.LBKALK
        Cross_Field_Adapter:
          Config: exportEngine
          Cross_Datapool: export_articles_oms #name of cross datapool
          Cross_Field: LBKALK #field to select value from in cross datapool
          Mapping: #cross field adapter with more than one key
            ordernumber: ordernumber
            attr1: attr1
    mehrwertsteuerschluesselek: iwm_articles_new.mehrwertsteuerschluesselek
    mehrwertsteuerschluesselvk: iwm_articles_new.mehrwertsteuerschluesselvk
    lagernummer: iwm_articles_new.lagernummer
    koje: iwm_articles_new.koje
    #   farbe: iwm_articles_new.farbe
    aufbaukennzeichen: iwm_articles_new.aufbaukennzeichen
    stil: iwm_articles_new.stil
    montageeinheiten: iwm_articles_new.montageeinheiten
    dimensionsfolge: iwm_articles_new.dimensionsfolge
    abmessung_dimension_1: iwm_articles_new.abmessung_dimension_1
    abmessung_dimension_2: iwm_articles_new.abmessung_dimension_2
    abmessung_dimension_3: iwm_articles_new.abmessung_dimension_3
    tourenart: iwm_articles_new.tourenart
    versandart: iwm_articles_new.versandart
    groesse: iwm_articles_new.groesse
    knuepfart: iwm_articles_new.knuepfart
    variant_hbsn: iwm_articles_new.variant_hbsn
    variant_kurzbezeichnung: iwm_articles_new.variant_kurzbezeichnung
    variant_langbezeichnung: iwm_articles_new.variant_langbezeichnung
    bestellsperre:
        Source: iwm_articles_new.bestellsperre
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: exportEngine
                  Cross_Datapool: iwm_articles_new_bssp_and_auslauf_vkhs_0 #name of cross datapool
                  Cross_Field: bestellsperre #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      ordernumber: ordernumber #hier muss arte: ordernumber hin, damit Bestellsperre auf Varianten vererbt wird
                      attr1: firma
    auslaufkennzeichen:
        Source: iwm_articles_new.auslaufkennzeichen
        Cross_Field_Adapter:
            Config: unitizeEngine
            Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
            Cross_Field: auslaufkennzeichen #field to select value from in cross datapool
            Local_Key: arte #key for where condition from datapool
            Cross_Key: ordernumber #key for where condition from cross datapool
    konsigniert: iwm_articles_new.konsigniert
    zeltgut: iwm_articles_new.zeltgut
    lieferzeit:
        Source: iwm_articles_new.lieferzeit
        File_Field_Adapter:
            File: articles_new.lieferzeit
    gpsr_herstellerinfo:
        Source: iwm_articles_new.gpsr_herstellerinfo
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: herstellerinfo #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
    gpsr_verantwortlicher:
        Source: iwm_articles_new.gpsr_verantwortlicher
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: verantwortlicher #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
    ear_marke:
        Source: iwm_articles_new.ear_marke
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: ear_marke #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
    H_Name:
        Source: iwm_articles_new.H_Name
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: H_Name #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
    H_Strasse:
        Source: iwm_articles_new.H_Name
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: H_Strasse #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
    H_PLZOrt:
        Source: iwm_articles_new.H_Name
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: H_PLZOrt #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
    H_Email:
        Source: iwm_articles_new.H_Name
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: H_Email #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
    WEEE_RegNr:
        Source: iwm_articles_new.H_Name
        Cross_Field_Adapter:
            Config: enhanceEngine
            Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
            Cross_Field: WEEE_RegNr #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
    aktion_Sonderpreis: ()
#      Source: iwm_articles_new.aktion_Sonderpreis
#      File_Field_Adapter:
#        File: articles_new.attr20
#        Engine: unitizeEngine
#        Datapool: iwm_articles_tvk_8
#        Identifier: arte
#        Fields:
#          - arte
#          - properties
    aktion_Gutscheincode: ()
    prop1: ()  #Farbe
    prop2: ()	#Breite
    prop3: ()	#Länge
    prop4: () #Höhe
    prop5: ()	#Abmessung
    prop10: ()	#Modell
    prop11: ()	#Material
    prop12: ()	#Raum
    prop50: ()	#Matratze Größe
    prop51: ()	#Matratze Härtegrad
    prop52: ()	#Matratze Bezugsmaterial
    prop53: ()	#Matratze Matratzenart
    prop60: ()	#Teppich Flächengewicht
    prop61: ()	#Teppich Florhöhe
    prop62: ()	#Teppich Fußbodenheizung
    prop63: ()	#Teppich Form
    prop64: ()	#Teppich Muster
    attr20:
      Source: iwm_articles_new.name_oms
      File_Field_Adapter:
        File: articles_new.attr20
        Engine: unitizeEngine
        Datapool: iwm_articles_tvk_8
        Identifier: arte
        Fields:
          - arte
          - properties
    enev_klasse:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_klasse #mapping der Klasse auf die Farbe de
    enev_color:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_color #mapping der Klasse auf die Farbe des Etiketts
    enev_download:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_download
    enev_image:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_image #mapping der Klasse auf das entsprechende Bild
    enev_spectrumfrom:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_spectrumfrom
    enev_spectrum:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_spectrum
    enev_active:
        Source: iwm_articles_properties_pil.Energieeffizienzklasse1
        File_Field_Adapter:
            File: articles_new.enev_active
    certification:
        Source: iwm_articles_new.name_oms
        Cross_Field_Adapter:
            Config: unitizeEngine
            Cross_Datapool: iwm_articles_tvk_4_eprel #name of cross datapool
            Cross_Field: eprel #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
        File_Field_Adapter:
            File: articles_new.certification
    swag_attr28:
        Source: iwm_articles_new.swag_attr28
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: iwm_articles_tvk_4 #name of cross datapool
                  Cross_Field: eek #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: arte
                      attr1: firma
        File_Field_Adapter:
            File: articles_new.swag_attr28
    datenblatt:
        Source: iwm_articles_new.datenblatt
        File_Field_Adapter:
            File: articles_new.datenblatt
    has_datenblatt:
        Source: iwm_articles_new.has_datenblatt
        File_Field_Adapter:
            File: articles_new.has_datenblatt
    datenblatt_needed:
        Source: iwm_articles_new.datenblatt_needed
        File_Field_Adapter:
            File: articles_new.datenblatt_needed
    modellfamilie:
        Source: iwm_articles_new.name_ost
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: modellfamilie_articles #name of cross datapool
                  Cross_Field: Label #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: arte
                      attr1: firma
    no_packstation:
        Source: iwm_articles_new.name_ost
        Cross_Field_Adapters:
            - Cross_Field_Adapter:
                  Config: enhanceEngine
                  Cross_Datapool: packstation_articles #name of cross datapool
                  Cross_Field: no_packstation #field to select value from in cross datapool
                  Mapping: #cross field adapter with more than one key
                      arte: arte
                      attr1: firma


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 < 1) AND (stock_ir < 1) AND (attr2 == 91) AND (attr11 == 'B')
   #       reason: 'Corona-Problem IR-Bestand'
    - Filter:
          name: Corona-Problem IR-Bestand
          condition: (stock_witten == '0') AND (stock_ir == '0') AND (attr2 == '91') AND (attr11 == 'B')
          reason: 'Corona-Problem INVR-Bestand'
    - Filter:
          name: kein Bild  #there must always be a space between the key and the comparision operator and between the parentheses
          condition:
              Cross_Dataset_Filter_Adapter: enhance_articles_ost__filterNoPicture
          reason: 'kein Bild'
    # - Filter:
    #    name: Variante > 300  #there must always be a space between the key and the comparision operator and between the parentheses
    #    condition:
    #      File_Filter_Adapter: enhance_articles_new__filterHighVariantNumbers
    #    reason: 'Variante > 300'
    - Filter:
          name: 'Artikeldeaktivierung Gesamtmengenfilter'
          condition:
              In_Pool_Filter_Adapter:
                  Config: importEngine
                  Datapool: static_filter_inactive_articles
                  Reason_Key: reason
                  Mapping: #left is from current datapool, right from filter datapool
                      suppliernumber: supplier_number
                      supplier_ost: supplier_name
                      supplier_tre: supplier_name
                      ordernumber: ordernumber
                      attr1: attr1
                      attr2: attr2
                      attr3: attr3
                      attr4: attr4
                      attr11: attr11
                      attr12: attr12
                      attr30: attr30
                      anlieferart: anlieferart
                      price_ost: price
                      price_tre: price
                      instock: stock
                      stock_witten: stock_witten
                      name_ost: name
                      name_tre: name
                      description_long_ost: description
                      auslaufkennzeichen: auslauf
                      bestellsperre: bestellsperre
                      ahstat: AHSTAT
                      swag_attr26: konsigniert
                      swag_attr28: swag_attr28
                      textilkennzeichen_needed: textilkennzeichen_needed
                      has_textilkennzeichen: has_textilkennzeichen
                      pil_needed: pil_needed
                      has_pil: has_pil
                      enev_active: enev_active
                      datenblatt_needed: datenblatt_needed
                      has_datenblatt: has_datenblatt
                      height: laenge
                      width: breite
                      configuratorOptions: configuratorOptions