Engine / Editor
iwm_articles
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 Source_Primary_Key: [ordernumber, ItemFirm] Target_Primary_Key: [ordernumber, attr1] #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: iwm_articles Datapool_Definition: ordernumber: VARCHAR(255) NOT NULL mainnumber: VARCHAR(255) DEFAULT NULL arte: VARCHAR(255) DEFAULT NULL name_ost: VARCHAR(255) DEFAULT NULL name_tre: VARCHAR(255) DEFAULT NULL name_oms: VARCHAR(255) DEFAULT NULL supplier_ost: VARCHAR(255) DEFAULT NULL supplier_tre: VARCHAR(255) DEFAULT NULL supplier_oms: VARCHAR(255) DEFAULT NULL tax: VARCHAR(255) DEFAULT NULL price_ost: VARCHAR(255) DEFAULT NULL price_tre: VARCHAR(255) DEFAULT NULL price_oms: VARCHAR(255) DEFAULT NULL pseudoprice_ost: VARCHAR(255) DEFAULT NULL pseudoprice_tre: VARCHAR(255) DEFAULT NULL pseudoprice_oms: VARCHAR(255) DEFAULT NULL baseprice: VARCHAR(255) DEFAULT NULL active_ost: INT(11) DEFAULT NULL active_tre: INT(11) DEFAULT NULL active_oms: INT(11) DEFAULT NULL description: MEDIUMTEXT DEFAULT NULL description_long_ost: TEXT DEFAULT NULL description_long_tre: TEXT DEFAULT NULL description_long_oms: TEXT DEFAULT NULL added: DATETIME DEFAULT NULL changed: DATETIME DEFAULT NULL unitID: VARCHAR(40) DEFAULT NULL ean: VARCHAR(255) DEFAULT NULL categories: VARCHAR(255) DEFAULT NULL purchaseprice: VARCHAR(255) DEFAULT NULL purchaseprice: VARCHAR(255) DEFAULT NULL referenceUnit: VARCHAR(255) DEFAULT NULL purchaseUnit: VARCHAR(255) DEFAULT NULL metaTitle: VARCHAR(255) DEFAULT NULL packUnit: VARCHAR(255) DEFAULT NULL configSetId: INT(11) DEFAULT NULL packUnit: VARCHAR(255) DEFAULT NULL configuratorType: VARCHAR(255) DEFAULT NULL configuratorOptions: VARCHAR(255) DEFAULT NULL kind: VARCHAR(255) DEFAULT NULL suppliernumber_original: VARCHAR(255) DEFAULT NULL suppliernumber: VARCHAR(255) DEFAULT NULL weight: VARCHAR(255) DEFAULT NULL height: VARCHAR(255) DEFAULT NULL width: VARCHAR(255) DEFAULT NULL categoryPath_ost: TEXT DEFAULT NULL categoryPath_tre: TEXT DEFAULT NULL categoryPath_oms: TEXT DEFAULT NULL cat_google: TEXT DEFAULT NULL cat_ebay: TEXT DEFAULT NULL cat_amazon: TEXT DEFAULT NULL propertyGroupName: VARCHAR(255) DEFAULT NULL propertyValueName: VARCHAR(255) DEFAULT NULL instock: INT(11) DEFAULT NULL accessory: VARCHAR(255) DEFAULT NULL attr1: VARCHAR(255) NOT NULL attr2: VARCHAR(255) DEFAULT NULL attr3: VARCHAR(255) DEFAULT NULL attr3: VARCHAR(255) DEFAULT NULL attr4: VARCHAR(255) DEFAULT NULL attr5: VARCHAR(255) DEFAULT NULL attr6: VARCHAR(255) DEFAULT NULL attr7: VARCHAR(255) DEFAULT NULL attr8: VARCHAR(255) DEFAULT NULL attr9: VARCHAR(255) DEFAULT NULL attr10: VARCHAR(255) DEFAULT NULL attr11: VARCHAR(255) DEFAULT NULL attr12: VARCHAR(255) DEFAULT NULL attr13: VARCHAR(255) DEFAULT NULL attr14: VARCHAR(255) DEFAULT NULL attr15: VARCHAR(255) DEFAULT NULL attr16: VARCHAR(255) DEFAULT NULL attr17: VARCHAR(255) DEFAULT NULL attr18: VARCHAR(255) DEFAULT NULL attr19: VARCHAR(255) DEFAULT NULL attr20: VARCHAR(255) DEFAULT NULL swag_attr21: TEXT DEFAULT NULL swag_attr22: VARCHAR(255) DEFAULT NULL swag_attr23: VARCHAR(255) DEFAULT NULL swag_attr24: VARCHAR(255) DEFAULT NULL swag_attr25: VARCHAR(255) DEFAULT NULL swag_attr26: VARCHAR(255) DEFAULT NULL swag_attr27: VARCHAR(255) DEFAULT NULL swag_attr28: TEXT DEFAULT NULL swag_attr29: VARCHAR(255) DEFAULT NULL attr30: VARCHAR(255) DEFAULT NULL attr31: VARCHAR(255) DEFAULT NULL stockmin_ost: INT(11) DEFAULT NULL stockmin_tre: INT(11) DEFAULT NULL stockmin_oms: INT(11) DEFAULT NULL ItemImageDate: VARCHAR(255) DEFAULT NULL imageUrl: TEXT DEFAULT NULL LBNTEK: VARCHAR(20) DEFAULT NULL LBKALK: VARCHAR(15) DEFAULT NULL LBMARGE: VARCHAR(10) DEFAULT NULL LBWAEISA: VARCHAR(10) DEFAULT NULL AbsatzMenge3M: VARCHAR(10) DEFAULT NULL shippingfree: INT(11) DEFAULT NULL bestellsperre: VARCHAR(10) DEFAULT NULL auslaufkennzeichen: VARCHAR(10) DEFAULT NULL textilkennzeichen_needed: VARCHAR(10) DEFAULT NULL textilkennzeichen_text: TEXT DEFAULT NULL has_textilkennzeichen: VARCHAR(10) DEFAULT NULL pil_needed: VARCHAR(10) DEFAULT NULL pil_text: TEXT DEFAULT NULL has_pil: VARCHAR(10) DEFAULT NULL AHLZSD: VARCHAR(10) DEFAULT NULL ARKMFR: VARCHAR(10) DEFAULT NULL nutschicht: VARCHAR(10) DEFAULT NULL has_textilkennzeichen: VARCHAR(10) DEFAULT NULL has_textilkennzeichen: VARCHAR(10) DEFAULT NULL stock_witten: VARCHAR(10) DEFAULT NULL stock_ir: VARCHAR(10) DEFAULT NULL stock_local: VARCHAR(10) DEFAULT NULL datenblatt: VARCHAR(100) DEFAULT NULL datenblatt_needed: VARCHAR(2) DEFAULT NULL has_datenblatt: VARCHAR(2) DEFAULT NULL ahstat: VARCHAR(10) DEFAULT NULL prop1: VARCHAR(255) DEFAULT NULL prop2: VARCHAR(255) DEFAULT NULL prop3: VARCHAR(255) DEFAULT NULL prop4: VARCHAR(255) DEFAULT NULL prop5: VARCHAR(255) DEFAULT NULL prop10: VARCHAR(255) DEFAULT NULL prop11: VARCHAR(255) DEFAULT NULL prop12: VARCHAR(255) DEFAULT NULL prop50: VARCHAR(255) DEFAULT NULL prop51: VARCHAR(255) DEFAULT NULL prop52: VARCHAR(255) DEFAULT NULL prop53: VARCHAR(255) DEFAULT NULL prop60: VARCHAR(255) DEFAULT NULL prop61: VARCHAR(255) DEFAULT NULL prop62: VARCHAR(255) DEFAULT NULL prop63: VARCHAR(255) DEFAULT NULL prop64: VARCHAR(255) DEFAULT NULL enev_color: VARCHAR(10) DEFAULT NULL enev_download: VARCHAR(100) DEFAULT NULL enev_image: VARCHAR(100) DEFAULT NULL enev_klasse: VARCHAR(10) DEFAULT NULL enev_spectrumfrom: VARCHAR(10) DEFAULT NULL enev_spectrum: VARCHAR(10) DEFAULT NULL enev_active: VARCHAR(1) DEFAULT NULL Mapping: ordernumber: IF(iwm_articles.ItemAspr = 0, IFNULL(iwm_articles.ItemNo,0), IFNULL(iwm_articles.VariationNo,0)) AS ordernumber mainnumber: Source: iwm_articles.ItemNo arte: iwm_articles.ItemNo name_ost: iwm_articles.ItemTextName_ost name_tre: iwm_articles.ItemTextName_tre name_oms: iwm_articles.ItemTextName_oms supplier_ost: iwm_articles.ItemProducer_ost supplier_tre: iwm_articles.ItemProducer_tre supplier_oms: iwm_articles.ItemProducer_oms tax: (19.00) price_ost: iwm_articles.Price1_ost price_tre: iwm_articles.Price1_tre price_oms: iwm_articles.Price1_oms pseudoprice_ost: iwm_articles.ItemMRP_ost pseudoprice_tre: iwm_articles.ItemMRP_tre pseudoprice_oms: iwm_articles.ItemMRP_oms baseprice: (1) active_ost: Source: IF(iwm_articles.ItemInactive_ost = 0, 1, 0) AS active_ost active_tre: Source: IF(iwm_articles.ItemInactive_tre = 0, 1, 0) AS active_tre active_oms: Source: IF(iwm_articles.ItemVisibilityWebshop_oms = 1, 1, 0) AS active_oms description: () description_long_ost: Source: iwm_articles.ItemTextDescription_ost Field_Adapter: description_long_tre: iwm_articles.ItemTextDescription_tre description_long_oms: iwm_articles.ItemTextDescription_oms added: (2018-08-01 00:00:00) changed: (2018-08-01 00:00:00) unitID: () ean: iwm_articles.ItemEAN categories: () purchaseprice: () purchaseprice: () referenceUnit: (1) purchaseUnit: () metaTitle: () packUnit: () configSetId: (1) configuratorType: () configuratorOptions: Source: CONCAT(iwm_articles.AttributName1,':',iwm_articles.AttributeValue1,'|',iwm_articles.AttributName2,':',iwm_articles.AttributeValue2,'|',iwm_articles.AttributName3,':',iwm_articles.AttributeValue3) as configuratorOptions Field_Adapter: - replace: [':|:|:', ''] - replace: ['|:', ''] - replace: ['|:', ''] kind: (1) suppliernumber_original: iwm_articles.ItemProducerID suppliernumber: iwm_articles.ItemProducerID weight: iwm_articles.PriceWeight height: iwm_articles.PriceHeight width: iwm_articles.PriceWidth categoryPath_ost: Source: CONCAT('Deutsch->', iwm_articles.ItemCategories_ost) as categoryPath_ost categoryPath_tre: Source: CONCAT('Deutsch->', iwm_articles.ItemCategories_tre) as categoryPath_tre categoryPath_oms: Source: CONCAT('Deutsch->', iwm_articles.ItemCategories_oms) as categoryPath_oms cat_google: () cat_ebay: () cat_amazon: () propertyGroupName: () propertyValueName: () accessory: () attr1: iwm_articles.ItemFreeTextField1 attr2: iwm_articles.ItemFreeTextField2 attr3: iwm_articles.ItemFreeTextField3 attr4: iwm_articles.ItemFreeTextField4 attr5: iwm_articles.ItemFreeTextField5 attr6: iwm_articles.ItemFreeTextField6 attr7: iwm_articles.ItemFreeTextField7 attr8: iwm_articles.ItemFreeTextField8 attr9: iwm_articles.ItemFreeTextField9 attr10: iwm_articles.ItemFreeTextField10 attr11: iwm_articles.ItemFreeTextField11 attr12: iwm_articles.ItemFreeTextField12 attr13: iwm_articles.ItemFreeTextField13 attr14: iwm_articles.ItemFreeTextField14 attr15: iwm_articles.ItemFreeTextField15 attr16: iwm_articles.ItemFreeTextField16 attr17: iwm_articles.ItemFreeTextField17 attr18: iwm_articles.ItemFreeTextField18 attr19: iwm_articles.ItemFreeTextField19 attr20: iwm_articles.ItemFreeTextField20 swag_attr21: () swag_attr22: iwm_articles.swag_attr22 swag_attr23: () swag_attr24: iwm_articles.swag_attr24 swag_attr25: iwm_articles.swag_attr25 swag_attr26: () #konsignierte Ware swag_attr27: () swag_attr28: () swag_attr29: () attr30: () attr31: () stockmin_ost: iwm_articles.ItemLimitOrderByStock_ost stockmin_tre: iwm_articles.ItemLimitOrderByStock_tre stockmin_oms: iwm_articles.ItemLimitOrderByStock_oms ItemImageDate: iwm_articles.ItemImageDate imageUrl: iwm_articles.imageUrl LBNTEK: iwm_articles.LBNTEK LBKALK: iwm_articles.LBKALK LBMARGE: iwm_articles.LBMARGE LBWAEISA: iwm_articles.LBWAEISA AbsatzMenge3M: iwm_articles.AbsatzMenge3M shippingfree: iwm_articles.shippingfree instock: (0) bestellsperre: () auslaufkennzeichen: () textilkennzeichen_needed: () textilkennzeichen_text: () has_textilkennzeichen: () pil_needed: () pil_text: () has_pil: () AHLZSD: () ARKMFR: () nutschicht: () stock_witten: () stock_ir: () stock_local: () ahstat: () datenblatt: () datenblatt_needed: () has_datenblatt: () 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 enev_color: () enev_download: () enev_image: () enev_klasse: () enev_spectrumfrom: () enev_spectrum: () enev_active: ()
Definition aktualisieren