Engine / Editor
enhance_articles_new_old
Mandant local-safety-smoke
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
enhance
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#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 #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 # name_bil: # Source: iwm_articles_new.name_bil # Cross_Field_Adapter: # Config: enhanceEngine # Cross_Datapool: iwm_articles_names_6 # Cross_Field: name_bil # 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 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 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 # description_long_bil: # Source: iwm_articles_new.description_long_bil # Cross_Field_Adapters: # - Cross_Field_Adapter: # Config: exportEngine # Cross_Datapool: export_articles_texts_online #name of cross datapool # Cross_Field: description_long_bil #field to select value from in cross datapool # Mapping: #cross field adapter with more than one key # ordernumber: ordernumber # attr1: attr1 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: iwm_articles_new.anlieferart stock_ir: Source: iwm_articles_new.name_oms 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_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 Field_Adapter: - replace_empty: 0 - replace_smaller: [0,0] 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_new.name_oms 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_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: unitizeEngine 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 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 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_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 #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 # File_Field_Adapter: # File: articles.LBKALK 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 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 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
Definition aktualisieren