Engine / Editor
export_articles_synesty
Mandant default
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
export
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#Connections Source_Config: enhanceEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service #Source Source_Datapool: iwm_articles_synesty #sql from Joins: - Join: Datapool: articles Join_Condition: iwm_articles_synesty.ordernumber = articles_new.ordernumber AND iwm_articles_synesty.ItemFreeTextField1 = articles_new.attr1 # One row per JOIN - 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 Read_Conditions: #sql where - Read-Filter - articles_new.active_oms = 1 or articles_new.active_ost = 1 or articles_new.active_tre = 1 #Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: Source: iwm_articles_synesty.ordernumber In_Export: no ItemKey: Source: iwm_articles_synesty.ItemKey ItemFirm: Source: iwm_articles_synesty.ItemFirm ItemSpar: Source: iwm_articles_synesty.ItemSpar ItemNo: Source: iwm_articles_synesty.ItemNo ItemAspr: Source: iwm_articles_synesty.ItemAspr Variation: Source: iwm_articles_synesty.Variation VariationNo: Source: iwm_articles_synesty.VariationNo ItemEAN: Source: iwm_articles_synesty.ItemEAN ItemProducer_ost: Source: iwm_articles_synesty.ItemProducer_ost ItemProducer_tre: Source: iwm_articles_synesty.ItemProducer_tre ItemProducer_oms: Source: iwm_articles_synesty.ItemProducer_oms ItemProducer_bil: Source: iwm_articles_synesty.ItemProducer_bil ItemTextName_ost: Source: iwm_articles_synesty.ItemTextName_ost ItemTextName_tre: Source: iwm_articles_synesty.ItemTextName_tre ItemTextName_oms: Source: iwm_articles_synesty.ItemTextName_oms ItemTextName_bil: Source: iwm_articles_synesty.ItemTextName_bil ItemTextDescription_ost: Source: articles_new.description_long_ost ItemTextDescription_tre: Source: articles_new.description_long_tre ItemTextDescription_oms: Source: articles_new.description_long_oms ItemTextDescription_bil: Source: articles_new.description_long_bil Price1_ost: Source: articles_new.price_ost Price2_ost: Source: iwm_articles_synesty.Price2_ost Price3_ost: Source: iwm_articles_synesty.Price3_ost ItemMRP_ost: Source: articles_new.pseudoprice_ost Price1_tre: Source: articles_new.price_tre Price2_tre: Source: iwm_articles_synesty.Price2_tre Price3_tre: Source: iwm_articles_synesty.Price3_tre ItemMRP_tre: Source: articles_new.pseudoprice_tre Price1_oms: Source: articles_new.price_oms Price2_oms: Source: iwm_articles_synesty.Price2_oms Price3_oms: Source: iwm_articles_synesty.Price3_oms ItemMRP_oms: Source: articles_new.pseudoprice_oms Price1_bil: Source: articles_new.price_bil Price2_bil: Source: iwm_articles_synesty.Price2_bil Price3_bil: Source: iwm_articles_synesty.Price3_bil ItemMRP_bil: Source: articles_new.pseudoprice_bil AttributName1: Source: iwm_articles_synesty.AttributName1 AttributeValue1: Source: iwm_articles_synesty.AttributeValue1 AttributName2: Source: iwm_articles_synesty.AttributName2 AttributeValue2: Source: iwm_articles_synesty.AttributeValue2 AttributName3: Source: iwm_articles_synesty.AttributName3 AttributeValue3: Source: iwm_articles_synesty.AttributeValue3 PriceWidth: Source: iwm_articles_synesty.PriceWidth PriceHeight: Source: iwm_articles_synesty.PriceHeight PriceLength: Source: iwm_articles_synesty.PriceLength PriceWeight: Source: iwm_articles_synesty.PriceWeight PriceWeightNet: Source: iwm_articles_synesty.PriceWeightNet ItemVisibilityWebshop_ost: Source: iwm_articles_synesty.ItemVisibilityWebshop_ost ItemVisibilityWebshop_tre: Source: iwm_articles_synesty.ItemVisibilityWebshop_tre ItemVisibilityWebshop_oms: Source: iwm_articles_synesty.ItemVisibilityWebshop_oms ItemVisibilityWebshop_bil: Source: iwm_articles_synesty.ItemVisibilityWebshop_bil ItemVisibilityWebApi_ost: Source: iwm_articles_synesty.ItemVisibilityWebApi_ost ItemVisibilityWebApi_tre: Source: iwm_articles_synesty.ItemVisibilityWebApi_tre ItemVisibilityWebApi_oms: Source: iwm_articles_synesty.ItemVisibilityWebApi_oms ItemVisibilityWebApi_bil: Source: iwm_articles_synesty.ItemVisibilityWebApi_bil ItemStoreIDs_ost: Source: iwm_articles_synesty.ItemStoreIDs_ost ItemStoreIDs_tre: Source: iwm_articles_synesty.ItemStoreIDs_tre ItemStoreIDs_oms: Source: iwm_articles_synesty.ItemStoreIDs_oms ItemStoreIDs_bil: Source: iwm_articles_synesty.ItemStoreIDs_bil ItemLimitOrderByStock_ost: Source: iwm_articles_synesty.ItemLimitOrderByStock_ost ItemLimitOrderByStock_tre: Source: iwm_articles_synesty.ItemLimitOrderByStock_tre ItemLimitOrderByStock_oms: Source: iwm_articles_synesty.ItemLimitOrderByStock_oms ItemLimitOrderByStock_bil: Source: iwm_articles_synesty.ItemLimitOrderByStock_bil ItemPrimaryWarehouse_ost: Source: iwm_articles_synesty.ItemPrimaryWarehouse_ost ItemPrimaryWarehouse_tre: Source: iwm_articles_synesty.ItemPrimaryWarehouse_tre ItemPrimaryWarehouse_oms: Source: iwm_articles_synesty.ItemPrimaryWarehouse_oms ItemPrimaryWarehouse_bil: Source: iwm_articles_synesty.ItemPrimaryWarehouse_bil ItemCrossList_ost: Source: iwm_articles_synesty.ItemCrossList_ost ItemCrossList_tre: Source: iwm_articles_synesty.ItemCrossList_tre ItemCrossList_oms: Source: iwm_articles_synesty.ItemCrossList_oms ItemCrossList_bil: Source: iwm_articles_synesty.ItemCrossList_bil ItemInactive_ost: Source: iwm_articles_synesty.ItemInactive_ost ItemInactive_tre: Source: iwm_articles_synesty.ItemInactive_tre ItemInactive_oms: Source: iwm_articles_synesty.ItemInactive_oms ItemInactive_bil: Source: iwm_articles_synesty.ItemInactive_bil ItemFreeTextField1: Source: iwm_articles_synesty.ItemFreeTextField1 ItemFreeTextField2: Source: iwm_articles_synesty.ItemFreeTextField2 ItemFreeTextField3: Source: iwm_articles_synesty.ItemFreeTextField3 ItemFreeTextField4: Source: iwm_articles_synesty.ItemFreeTextField4 ItemFreeTextField5: Source: iwm_articles_synesty.ItemFreeTextField5 ItemFreeTextField6: Source: iwm_articles_synesty.ItemFreeTextField6 ItemFreeTextField7: Source: iwm_articles_synesty.ItemFreeTextField7 ItemFreeTextField8: Source: iwm_articles_synesty.ItemFreeTextField8 ItemFreeTextField9: Source: iwm_articles_synesty.ItemFreeTextField9 ItemFreeTextField10: Source: iwm_articles_synesty.ItemFreeTextField10 ItemFreeTextField11: Source: iwm_articles_synesty.ItemFreeTextField11 ItemFreeTextField12: Source: iwm_articles_synesty.ItemFreeTextField12 ItemFreeTextField13: Source: iwm_articles_synesty.ItemFreeTextField13 ItemFreeTextField14: Source: iwm_articles_synesty.ItemFreeTextField14 ItemFreeTextField15: Source: iwm_articles_synesty.ItemFreeTextField15 ItemFreeTextField16: Source: iwm_articles_synesty.ItemFreeTextField16 ItemFreeTextField17: Source: iwm_articles_synesty.ItemFreeTextField17 ItemFreeTextField18: Source: iwm_articles_synesty.ItemFreeTextField18 ItemFreeTextField19: Source: iwm_articles_synesty.ItemFreeTextField19 ItemFreeTextField20: Source: iwm_articles_synesty.ItemFreeTextField20 ItemCategories_ost: Source: iwm_articles_synesty.ItemCategories_ost ItemCategories_tre: Source: iwm_articles_synesty.ItemCategories_tre ItemCategories_oms: Source: iwm_articles_synesty.ItemCategories_oms ItemCategories_bil: Source: iwm_articles_synesty.ItemCategories_bil ItemPropertiesID_ost: Source: iwm_articles_synesty.ItemPropertiesID_ost ItemPropertiesID_tre: Source: iwm_articles_synesty.ItemPropertiesID_tre ItemPropertiesID_oms: Source: iwm_articles_synesty.ItemPropertiesID_oms ItemPropertiesID_bil: Source: iwm_articles_synesty.ItemPropertiesID_bil ItemPropertiesValue_ost: Source: iwm_articles_synesty.ItemPropertiesValue_ost ItemPropertiesValue_tre: Source: iwm_articles_synesty.ItemPropertiesValue_tre ItemPropertiesValue_oms: Source: iwm_articles_synesty.ItemPropertiesValue_oms ItemPropertiesValue_bil: Source: iwm_articles_synesty.ItemPropertiesValue_bil ItemImageDate: Source: iwm_articles_synesty.ItemImageDate ItemProducerID: Source: iwm_articles_synesty.ItemProducerID LBNTEK: Source: iwm_articles_synesty.LBNTEK LBKALK: Source: iwm_articles_synesty.LBKALK LBMARGE: Source: iwm_articles_synesty.LBMARGE LBWAEISA: Source: iwm_articles_synesty.LBWAEISA AbsatzMenge3M: Source: iwm_articles_synesty.AbsatzMenge3M imageUrl: Source: iwm_articles_synesty.imageUrl swag_attr24: Source: iwm_articles_synesty.swag_attr24 swag_attr25: Source: iwm_articles_synesty.swag_attr25 swag_attr22: Source: iwm_articles_synesty.swag_attr22 shippingfree: Source: iwm_articles_synesty.shippingfree stock_witten: Source: iwm_articles_stock.witten In_Export: no stock: Source: iwm_articles_stock.stock In_Export: no Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out) - Filter: name: Mindestbestand #there must always be a space between the key and the comparision operator condition: (Price1_ost < 6) AND (stock_witten < 10) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L') reason: 'Mindestbestand (price < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)' - Filter: name: 'Mindestbestand' condition: (Price1_ost < 25) AND (stock_witten < 3) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L') reason: 'Mindestbestand (price < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)' - Filter: name: 'Mindestbestand' condition: (Price1_ost < 100) AND (stock_witten < 1) AND (ItemFreeTextField2 == 90 or ItemFreeTextField2 == 91 or ItemFreeTextField2 == 92 or ItemFreeTextField2 == 96 or ItemFreeTextField2 == 101) AND (ItemFreeTextField11 == 'L') reason: 'Mindestbestand (price < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == L)' - Filter: name: 'Preis ungueltig' condition: (Price1_ost == '0') or (Price1_ost == '') or (Price1_ost == '0.00') or (Price1_ost == '0,00') or (Price1_ost == '0,0') reason: 'alle Preise = 0' - Filter: name: 'Zu lange Lieferzeit' condition: (ItemFreeTextField11 == 'L') and (ItemFreeTextField12 > 6) and (stock == 0) and (ItemFreeTextField2 > 89) reason: 'Zu lange Lieferzeit' - Filter: name: 'Zu lange Lieferzeit Suppliernumber 782577' condition: (ItemFreeTextField11 == 'L') and (ItemFreeTextField12 > 4) and (stock == 0) and (ItemProducer_ost == 'Casa Nova') reason: 'Zu lange Lieferzeit Suppliernumber 782577' #Target Datapool: export_articles_synesty #sql table Primary_Key: ItemKey
Definition aktualisieren