Engine / Editor
enhance_articles_new_new
Mandant codex-demo
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: enhanceEngine #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: articles_inhouse #sql from Order_By: ordernumber ASC 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: articles_inhouse.ordernumber mainnumber: articles_inhouse.mainnumber arte: articles_inhouse.arte name_oms: articles_inhouse.name_oms name_tre: articles_inhouse.name_tre name_ost: articles_inhouse.name_ost tax: articles_inhouse.tax price_ost: () price_tre: () price_oms: () shipping_ost: () shipping_tre: () shipping_oms: () pseudoprice_ost: () pseudoprice_tre: () pseudoprice_oms: () purchaseprice: articles_inhouse.purchaseprice baseprice: articles_inhouse.baseprice active_ost: articles_inhouse.active_ost active_tre: articles_inhouse.active_tre active_oms: articles_inhouse.active_oms description: articles_inhouse.description description_long_ost: articles_inhouse.description_long_ost description_long_tre: articles_inhouse.description_long_tre description_long_oms: articles_inhouse.description_long_oms added: articles_inhouse.added changed: articles_inhouse.changed unitID: articles_inhouse.unitID attr9: articles_inhouse.attr9 variant_ean: articles_inhouse.variant_ean suppliernumber_original: articles_inhouse.suppliernumber_original suppliernumber: articles_inhouse.suppliernumber ean: articles_inhouse.ean attr9_strip: articles_inhouse.attr9 categories: articles_inhouse.categories referenceUnit: articles_inhouse.referenceUnit supplier_ost: articles_inhouse.supplier_ost supplier_tre: articles_inhouse.supplier_tre supplier_oms: articles_inhouse.supplier_oms purchaseUnit: articles_inhouse.purchaseUnit metaTitle: articles_inhouse.metaTitle packUnit: articles_inhouse.packUnit configSetId: articles_inhouse.configSetId configuratorType: articles_inhouse.configuratorType configuratorOptions: articles_inhouse.configuratorOptions kind: articles_inhouse.kind weight: articles_inhouse.weight height: articles_inhouse.height width: articles_inhouse.width swag_attr27: articles_inhouse.swag_attr27 categoryPath_ost: articles_inhouse.categoryPath_ost categoryPath_tre: articles_inhouse.categoryPath_tre categoryPath_oms: articles_inhouse.categoryPath_oms cat_google_produktart: articles_inhouse.cat_google_produktart cat_google_shop_category: articles_inhouse.cat_google cat_google: articles_inhouse.cat_google cat_ebay: articles_inhouse.cat_ebay cat_amazon: articles_inhouse.cat_amazon propertyGroupName: articles_inhouse.propertyGroupName propertyValueName: articles_inhouse.propertyValueName farbe: articles_inhouse.farbe material: articles_inhouse.material accessory: articles_inhouse.accessory attr1: articles_inhouse.attr1 attr2: articles_inhouse.attr2 attr3: articles_inhouse.attr3 attr4: articles_inhouse.attr4 attr5: articles_inhouse.attr5 attr6: articles_inhouse.attr6 attr7: articles_inhouse.attr7 attr8: articles_inhouse.attr8 attr10: articles_inhouse.attr10 attr11: articles_inhouse.attr11 anlieferart: articles_inhouse.anlieferart stock_ir: articles_inhouse.stock_ir instock: articles_inhouse.instock attr12: articles_inhouse.attr12 attr13: articles_inhouse.attr13 attr14: articles_inhouse.attr14 attr16: articles_inhouse.attr16 attr17: articles_inhouse.attr17 attr18: articles_inhouse.attr18 attr19: articles_inhouse.attr19 swag_attr23: articles_inhouse.swag_attr23 swag_attr21: articles_inhouse.swag_attr21 swag_attr24: articles_inhouse.swag_attr24 swag_attr25: articles_inhouse.swag_attr25 swag_attr26: articles_inhouse.swag_attr26 attr15: articles_inhouse.attr15 swag_attr29: articles_inhouse.swag_attr29 #carrier attr30: articles_inhouse.attr30 attr31: articles_inhouse.attr31 attr36: () #finanzierbare produkte -> gefüllt im export imageUrl: articles_inhouse.imageUrl ItemImageDate: articles_inhouse.ItemImageDate stock_witten: articles_inhouse.stock_witten shippingfree: articles_inhouse.shippingfree attr37_pre_oms: articles_inhouse.attr37_pre_oms attr37_pre_ost: articles_inhouse.attr37_pre_ost attr37_pre_tre: articles_inhouse.attr37_pre_tre attr37: articles_inhouse.attr37 attr38: articles_inhouse.attr38 attr41: articles_inhouse.attr41 attr48: articles_inhouse.attr48 attr50: articles_inhouse.attr50 attr53: articles_inhouse.attr53 attr54: articles_inhouse.attr54 attr55: articles_inhouse.attr55 attr57: articles_inhouse.attr57 attr60: articles_inhouse.attr60 attr61: articles_inhouse.attr61 tpl_color_badge: articles_inhouse.tpl_color_badge textilkennzeichen_text: articles_inhouse.textilkennzeichen_text AHLZSD: articles_inhouse.AHLZSD ARKMFR: articles_inhouse.ARKMFR nutschicht: articles_inhouse.nutschicht textilkennzeichen_needed: articles_inhouse.textilkennzeichen_needed has_textilkennzeichen: articles_inhouse.has_textilkennzeichen pil_needed_static: articles_inhouse.pil_needed_static pil_needed_dynamic: articles_inhouse.pil_needed_dynamic pil_needed: articles_inhouse.pil_needed pil_text: articles_inhouse.pil_text has_pil: articles_inhouse.has_pil ahstat: articles_inhouse.ahstat LBNTEK: articles_inhouse.LBNTEK LBKALK: () mehrwertsteuerschluesselek: articles_inhouse.mehrwertsteuerschluesselek mehrwertsteuerschluesselvk: articles_inhouse.mehrwertsteuerschluesselvk lagernummer: articles_inhouse.lagernummer koje: articles_inhouse.koje aufbaukennzeichen: articles_inhouse.aufbaukennzeichen stil: articles_inhouse.stil montageeinheiten: articles_inhouse.montageeinheiten dimensionsfolge: articles_inhouse.dimensionsfolge abmessung_dimension_1: articles_inhouse.abmessung_dimension_1 abmessung_dimension_2: articles_inhouse.abmessung_dimension_2 abmessung_dimension_3: articles_inhouse.abmessung_dimension_3 tourenart: articles_inhouse.tourenart versandart: articles_inhouse.versandart groesse: articles_inhouse.groesse knuepfart: articles_inhouse.knuepfart variant_hbsn: articles_inhouse.variant_hbsn variant_kurzbezeichnung: articles_inhouse.variant_kurzbezeichnung variant_langbezeichnung: articles_inhouse.variant_langbezeichnung bestellsperre: articles_inhouse.bestellsperre auslaufkennzeichen: articles_inhouse.auslaufkennzeichen konsigniert: articles_inhouse.konsigniert zeltgut: articles_inhouse.zeltgut lieferzeit: articles_inhouse.lieferzeit gpsr_herstellerinfo: articles_inhouse.gpsr_herstellerinfo gpsr_verantwortlicher: articles_inhouse.gpsr_verantwortlicher ear_marke: articles_inhouse.ear_marke H_Name: articles_inhouse.H_Name H_Strasse: articles_inhouse.H_Strasse H_PLZOrt: articles_inhouse.H_PLZOrt H_Email: articles_inhouse.H_Email WEEE_RegNr: articles_inhouse.WEEE_RegNr 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: articles_inhouse.attr20 enev_klasse: articles_inhouse.enev_klasse enev_color: articles_inhouse.enev_color enev_download: articles_inhouse.enev_download enev_image: articles_inhouse.enev_image enev_spectrumfrom: articles_inhouse.enev_spectrumfrom enev_spectrum: articles_inhouse.enev_spectrum enev_active: articles_inhouse.enev_active certification: articles_inhouse.certification swag_attr28: articles_inhouse.swag_attr28 datenblatt: articles_inhouse.datenblatt has_datenblatt: articles_inhouse.has_datenblatt datenblatt_needed: articles_inhouse.datenblatt_needed modellfamilie: articles_inhouse.modellfamilie no_packstation: articles_inhouse.no_packstation Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out) - 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'
Definition aktualisieren