Engine / Editor
unitize_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
unitize
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
Engine: Unitize Source_Config: importEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: iwm_articles_new Source_Primary_Key: ItemKey Target_Primary_Key: ItemKey #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: iwm_articles_synesty Datapool_Definition: ordernumber: VARCHAR(255) DEFAULT NULL ItemKey: VARCHAR(255) NOT NULL ItemFirm: VARCHAR(255) DEFAULT NULL ItemSpar: INT(11) DEFAULT NULL ItemNo: VARCHAR(40) DEFAULT NULL ItemAspr: VARCHAR(40) DEFAULT NULL Variation: VARCHAR(255) DEFAULT NULL VariationNo: VARCHAR(255) DEFAULT NULL ItemEAN: VARCHAR(255) DEFAULT NULL ItemProducer_ost: VARCHAR(255) DEFAULT NULL ItemProducer_tre: VARCHAR(255) DEFAULT NULL ItemProducer_oms: VARCHAR(255) DEFAULT NULL ItemProducer_bil: VARCHAR(255) DEFAULT NULL ItemTextName_ost: VARCHAR(255) DEFAULT NULL ItemTextName_tre: VARCHAR(255) DEFAULT NULL ItemTextName_oms: VARCHAR(255) DEFAULT NULL ItemTextName_bil: VARCHAR(255) DEFAULT NULL ItemTextDescription_ost: TEXT DEFAULT NULL ItemTextDescription_tre: TEXT DEFAULT NULL ItemTextDescription_oms: TEXT DEFAULT NULL ItemTextDescription_bil: TEXT DEFAULT NULL Price1_ost: VARCHAR(255) DEFAULT NULL Price2_ost: VARCHAR(255) DEFAULT NULL Price3_ost: VARCHAR(255) DEFAULT NULL ItemMRP_ost: VARCHAR(255) DEFAULT NULL Price1_tre: VARCHAR(255) DEFAULT NULL Price2_tre: VARCHAR(255) DEFAULT NULL Price3_tre: VARCHAR(255) DEFAULT NULL ItemMRP_tre: VARCHAR(255) DEFAULT NULL Price1_oms: VARCHAR(255) DEFAULT NULL Price2_oms: VARCHAR(255) DEFAULT NULL Price3_oms: VARCHAR(255) DEFAULT NULL ItemMRP_oms: VARCHAR(255) DEFAULT NULL Price1_bil: VARCHAR(255) DEFAULT NULL Price2_bil: VARCHAR(255) DEFAULT NULL Price3_bil: VARCHAR(255) DEFAULT NULL ItemMRP_bil: VARCHAR(255) DEFAULT NULL AttributName1: VARCHAR(255) DEFAULT NULL AttributeValue1: VARCHAR(255) DEFAULT NULL AttributName2: VARCHAR(255) DEFAULT NULL AttributeValue2: VARCHAR(255) DEFAULT NULL AttributName3: VARCHAR(255) DEFAULT NULL AttributeValue3: VARCHAR(255) DEFAULT NULL PriceWidth: VARCHAR(255) DEFAULT NULL PriceHeight: VARCHAR(255) DEFAULT NULL PriceLength: VARCHAR(255) DEFAULT NULL PriceWeight: VARCHAR(255) DEFAULT NULL PriceWeightNet: VARCHAR(255) DEFAULT NULL ItemVisibilityWebshop_ost: VARCHAR(255) DEFAULT NULL ItemVisibilityWebshop_tre: VARCHAR(255) DEFAULT NULL ItemVisibilityWebshop_oms: VARCHAR(255) DEFAULT NULL ItemVisibilityWebshop_bil: VARCHAR(255) DEFAULT NULL ItemVisibilityWebApi_ost: VARCHAR(255) DEFAULT NULL ItemVisibilityWebApi_tre: VARCHAR(255) DEFAULT NULL ItemVisibilityWebApi_oms: VARCHAR(255) DEFAULT NULL ItemVisibilityWebApi_bil: VARCHAR(255) DEFAULT NULL ItemStoreIDs_ost: VARCHAR(255) DEFAULT NULL ItemStoreIDs_tre: VARCHAR(255) DEFAULT NULL ItemStoreIDs_oms: VARCHAR(255) DEFAULT NULL ItemStoreIDs_bil: VARCHAR(255) DEFAULT NULL ItemLimitOrderByStock_ost: VARCHAR(255) DEFAULT NULL ItemLimitOrderByStock_tre: VARCHAR(255) DEFAULT NULL ItemLimitOrderByStock_oms: VARCHAR(255) DEFAULT NULL ItemLimitOrderByStock_bil: VARCHAR(255) DEFAULT NULL ItemPrimaryWarehouse_ost: VARCHAR(255) DEFAULT NULL ItemPrimaryWarehouse_tre: VARCHAR(255) DEFAULT NULL ItemPrimaryWarehouse_oms: VARCHAR(255) DEFAULT NULL ItemPrimaryWarehouse_bil: VARCHAR(255) DEFAULT NULL ItemCrossList_ost: VARCHAR(255) DEFAULT NULL ItemCrossList_tre: VARCHAR(255) DEFAULT NULL ItemCrossList_oms: VARCHAR(255) DEFAULT NULL ItemCrossList_bil: VARCHAR(255) DEFAULT NULL ItemInactive_ost: VARCHAR(255) DEFAULT NULL ItemInactive_tre: VARCHAR(255) DEFAULT NULL ItemInactive_oms: VARCHAR(255) DEFAULT NULL ItemInactive_bil: VARCHAR(255) DEFAULT NULL ItemFreeTextField1: VARCHAR(255) DEFAULT NULL ItemFreeTextField2: VARCHAR(255) DEFAULT NULL ItemFreeTextField3: VARCHAR(255) DEFAULT NULL ItemFreeTextField4: VARCHAR(255) DEFAULT NULL ItemFreeTextField5: VARCHAR(255) DEFAULT NULL ItemFreeTextField6: VARCHAR(255) DEFAULT NULL ItemFreeTextField7: VARCHAR(255) DEFAULT NULL ItemFreeTextField8: VARCHAR(255) DEFAULT NULL ItemFreeTextField9: VARCHAR(255) DEFAULT NULL ItemFreeTextField10: VARCHAR(255) DEFAULT NULL ItemFreeTextField11: VARCHAR(255) DEFAULT NULL ItemFreeTextField12: VARCHAR(255) DEFAULT NULL ItemFreeTextField13: VARCHAR(255) DEFAULT NULL ItemFreeTextField14: VARCHAR(255) DEFAULT NULL ItemFreeTextField15: VARCHAR(255) DEFAULT NULL ItemFreeTextField16: VARCHAR(255) DEFAULT NULL ItemFreeTextField17: VARCHAR(255) DEFAULT NULL ItemFreeTextField18: VARCHAR(255) DEFAULT NULL ItemFreeTextField19: VARCHAR(255) DEFAULT NULL ItemFreeTextField20: VARCHAR(255) DEFAULT NULL ItemCategories_ost: TEXT DEFAULT NULL ItemCategories_tre: TEXT DEFAULT NULL ItemCategories_oms: TEXT DEFAULT NULL ItemCategories_bil: TEXT DEFAULT NULL ItemPropertiesID_ost: VARCHAR(255) DEFAULT NULL ItemPropertiesID_tre: VARCHAR(255) DEFAULT NULL ItemPropertiesID_oms: VARCHAR(255) DEFAULT NULL ItemPropertiesID_bil: VARCHAR(255) DEFAULT NULL ItemPropertiesValue_ost: VARCHAR(255) DEFAULT NULL ItemPropertiesValue_tre: VARCHAR(255) DEFAULT NULL ItemPropertiesValue_oms: VARCHAR(255) DEFAULT NULL ItemPropertiesValue_bil: VARCHAR(255) DEFAULT NULL ItemImageDate: VARCHAR(255) DEFAULT NULL ItemProducerID: VARCHAR(255) DEFAULT NULL LBNTEK: VARCHAR(255) DEFAULT NULL LBKALK: VARCHAR(255) DEFAULT NULL LBMARGE: VARCHAR(255) DEFAULT NULL LBWAEISA: VARCHAR(255) DEFAULT NULL AbsatzMenge3M: VARCHAR(255) DEFAULT NULL imageUrl: VARCHAR(255) DEFAULT NULL swag_attr24: VARCHAR(255) DEFAULT NULL swag_attr25: VARCHAR(255) DEFAULT NULL swag_attr22: VARCHAR(255) DEFAULT NULL shippingfree: VARCHAR(255) DEFAULT NULL Mapping: ordernumber: Source: iwm_articles_new.VariationNo Field_Adapter: - replace: ['-0', ''] ItemKey: Source: iwm_articles_new.ItemKey ItemFirm: Source: iwm_articles_new.ItemFirm ItemSpar: Source: iwm_articles_new.ItemSpar ItemNo: Source: iwm_articles_new.ItemNo ItemAspr: Source: iwm_articles_new.ItemAspr Variation: Source: iwm_articles_new.Variation VariationNo: Source: iwm_articles_new.VariationNo ItemEAN: Source: iwm_articles_new.ItemEAN ItemProducer_ost: Source: iwm_articles_new.ItemProducer_ost ItemProducer_tre: Source: iwm_articles_new.ItemProducer_tre ItemProducer_oms: Source: iwm_articles_new.ItemProducer_oms ItemProducer_bil: Source: iwm_articles_new.ItemProducer_bil ItemTextName_ost: Source: iwm_articles_new.ItemTextName_ost ItemTextName_tre: Source: iwm_articles_new.ItemTextName_tre ItemTextName_oms: Source: iwm_articles_new.ItemTextName_oms ItemTextName_bil: Source: iwm_articles_new.ItemTextName_bil ItemTextDescription_ost: Source: iwm_articles_new.ItemTextDescription_ost ItemTextDescription_tre: Source: iwm_articles_new.ItemTextDescription_tre ItemTextDescription_oms: Source: iwm_articles_new.ItemTextDescription_oms ItemTextDescription_bil: Source: iwm_articles_new.ItemTextDescription_bil Price1_ost: Source: iwm_articles_new.Price1_ost Price2_ost: Source: iwm_articles_new.Price2_ost Price3_ost: Source: iwm_articles_new.Price3_ost ItemMRP_ost: Source: iwm_articles_new.ItemMRP_ost Price1_tre: Source: iwm_articles_new.Price1_tre Price2_tre: Source: iwm_articles_new.Price2_tre Price3_tre: Source: iwm_articles_new.Price3_tre ItemMRP_tre: Source: iwm_articles_new.ItemMRP_tre Price1_oms: Source: iwm_articles_new.Price1_oms Price2_oms: Source: iwm_articles_new.Price2_oms Price3_oms: Source: iwm_articles_new.Price3_oms ItemMRP_oms: Source: iwm_articles_new.ItemMRP_oms Price1_bil: Source: iwm_articles_new.Price1_bil Price2_bil: Source: iwm_articles_new.Price2_bil Price3_bil: Source: iwm_articles_new.Price3_bil ItemMRP_bil: Source: iwm_articles_new.ItemMRP_bil AttributName1: Source: iwm_articles_new.AttributName1 AttributeValue1: Source: iwm_articles_new.AttributeValue1 AttributName2: Source: iwm_articles_new.AttributName2 AttributeValue2: Source: iwm_articles_new.AttributeValue2 AttributName3: Source: iwm_articles_new.AttributName3 AttributeValue3: Source: iwm_articles_new.AttributeValue3 PriceWidth: Source: iwm_articles_new.PriceWidth PriceHeight: Source: iwm_articles_new.PriceHeight PriceLength: Source: iwm_articles_new.PriceLength PriceWeight: Source: iwm_articles_new.PriceWeight PriceWeightNet: Source: iwm_articles_new.PriceWeightNet ItemVisibilityWebshop_ost: Source: iwm_articles_new.ItemVisibilityWebshop_ost ItemVisibilityWebshop_tre: Source: iwm_articles_new.ItemVisibilityWebshop_tre ItemVisibilityWebshop_oms: Source: iwm_articles_new.ItemVisibilityWebshop_oms ItemVisibilityWebshop_bil: Source: iwm_articles_new.ItemVisibilityWebshop_bil ItemVisibilityWebApi_ost: Source: iwm_articles_new.ItemVisibilityWebApi_ost ItemVisibilityWebApi_tre: Source: iwm_articles_new.ItemVisibilityWebApi_tre ItemVisibilityWebApi_oms: Source: iwm_articles_new.ItemVisibilityWebApi_oms ItemVisibilityWebApi_bil: Source: iwm_articles_new.ItemVisibilityWebApi_bil ItemStoreIDs_ost: Source: iwm_articles_new.ItemStoreIDs_ost ItemStoreIDs_tre: Source: iwm_articles_new.ItemStoreIDs_tre ItemStoreIDs_oms: Source: iwm_articles_new.ItemStoreIDs_oms ItemStoreIDs_bil: Source: iwm_articles_new.ItemStoreIDs_bil ItemLimitOrderByStock_ost: Source: iwm_articles_new.ItemLimitOrderByStock_ost ItemLimitOrderByStock_tre: Source: iwm_articles_new.ItemLimitOrderByStock_tre ItemLimitOrderByStock_oms: Source: iwm_articles_new.ItemLimitOrderByStock_oms ItemLimitOrderByStock_bil: Source: iwm_articles_new.ItemLimitOrderByStock_bil ItemPrimaryWarehouse_ost: Source: iwm_articles_new.ItemPrimaryWarehouse_ost ItemPrimaryWarehouse_tre: Source: iwm_articles_new.ItemPrimaryWarehouse_tre ItemPrimaryWarehouse_oms: Source: iwm_articles_new.ItemPrimaryWarehouse_oms ItemPrimaryWarehouse_bil: Source: iwm_articles_new.ItemPrimaryWarehouse_bil ItemCrossList_ost: Source: iwm_articles_new.ItemCrossList_ost ItemCrossList_tre: Source: iwm_articles_new.ItemCrossList_tre ItemCrossList_oms: Source: iwm_articles_new.ItemCrossList_oms ItemCrossList_bil: Source: iwm_articles_new.ItemCrossList_bil ItemInactive_ost: Source: iwm_articles_new.ItemInactive_ost ItemInactive_tre: Source: iwm_articles_new.ItemInactive_tre ItemInactive_oms: Source: iwm_articles_new.ItemInactive_oms ItemInactive_bil: Source: iwm_articles_new.ItemInactive_bil ItemFreeTextField1: Source: iwm_articles_new.ItemFreeTextField1 ItemFreeTextField2: Source: iwm_articles_new.ItemFreeTextField2 ItemFreeTextField3: Source: iwm_articles_new.ItemFreeTextField3 ItemFreeTextField4: Source: iwm_articles_new.ItemFreeTextField4 ItemFreeTextField5: Source: iwm_articles_new.ItemFreeTextField5 ItemFreeTextField6: Source: iwm_articles_new.ItemFreeTextField6 ItemFreeTextField7: Source: iwm_articles_new.ItemFreeTextField7 ItemFreeTextField8: Source: iwm_articles_new.ItemFreeTextField8 ItemFreeTextField9: Source: iwm_articles_new.ItemFreeTextField9 ItemFreeTextField10: Source: iwm_articles_new.ItemFreeTextField10 ItemFreeTextField11: Source: iwm_articles_new.ItemFreeTextField11 ItemFreeTextField12: Source: iwm_articles_new.ItemFreeTextField12 ItemFreeTextField13: Source: iwm_articles_new.ItemFreeTextField13 ItemFreeTextField14: Source: iwm_articles_new.ItemFreeTextField14 ItemFreeTextField15: Source: iwm_articles_new.ItemFreeTextField15 ItemFreeTextField16: Source: iwm_articles_new.ItemFreeTextField16 ItemFreeTextField17: Source: iwm_articles_new.ItemFreeTextField17 ItemFreeTextField18: Source: iwm_articles_new.ItemFreeTextField18 ItemFreeTextField19: Source: iwm_articles_new.ItemFreeTextField19 ItemFreeTextField20: Source: iwm_articles_new.ItemFreeTextField20 ItemCategories_ost: Source: iwm_articles_new.ItemCategories_ost ItemCategories_tre: Source: iwm_articles_new.ItemCategories_tre ItemCategories_oms: Source: iwm_articles_new.ItemCategories_oms ItemCategories_bil: Source: iwm_articles_new.ItemCategories_bil ItemPropertiesID_ost: Source: iwm_articles_new.ItemPropertiesID_ost ItemPropertiesID_tre: Source: iwm_articles_new.ItemPropertiesID_tre ItemPropertiesID_oms: Source: iwm_articles_new.ItemPropertiesID_oms ItemPropertiesID_bil: Source: iwm_articles_new.ItemPropertiesID_bil ItemPropertiesValue_ost: Source: iwm_articles_new.ItemPropertiesValue_ost ItemPropertiesValue_tre: Source: iwm_articles_new.ItemPropertiesValue_tre ItemPropertiesValue_oms: Source: iwm_articles_new.ItemPropertiesValue_oms ItemPropertiesValue_bil: Source: iwm_articles_new.ItemPropertiesValue_bil ItemImageDate: Source: iwm_articles_new.ItemImageDate ItemProducerID: Source: iwm_articles_new.ItemProducerID LBNTEK: Source: iwm_articles_new.LBNTEK LBKALK: Source: iwm_articles_new.LBKALK LBMARGE: Source: iwm_articles_new.LBMARGE LBWAEISA: Source: iwm_articles_new.LBWAEISA AbsatzMenge3M: Source: iwm_articles_new.AbsatzMenge3M imageUrl: Source: iwm_articles_new.imageUrl swag_attr24: Source: iwm_articles_new.swag_attr24 swag_attr25: Source: iwm_articles_new.swag_attr25 swag_attr22: Source: iwm_articles_new.swag_attr22 shippingfree: Source: iwm_articles_new.shippingfree
Definition aktualisieren