Engine / Editor
export_articles_sw6.dev.oms_combined
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: exportEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service #Source Mysql_Engine: InnoDB Default_Charset: latin1 Source_Datapool: articles_new #sql from Sql: SELECT * FROM export_articles_sw6_dev_oms UNION SELECT * FROM export_articles_parents_sw6 Read_Conditions: #sql where - Read-Filter - articles_new.active_oms = 1 Order_By: ordernumber ASC Datapool_Definition: ordernumber: VARCHAR(255) NOT NULL mainnumber: VARCHAR(255) DEFAULT NULL productnumber: VARCHAR(255) DEFAULT NULL name: VARCHAR(350) DEFAULT NULL supplier: VARCHAR(255) DEFAULT NULL taxName: VARCHAR(10) DEFAULT NULL taxValue: VARCHAR(10) DEFAULT NULL tax_id: VARCHAR(10) DEFAULT NULL price_EK: VARCHAR(255) DEFAULT NULL price_gross: VARCHAR(255) DEFAULT NULL pseudoprice_EK: VARCHAR(255) DEFAULT NULL baseprice_EK: VARCHAR(255) DEFAULT NULL active: VARCHAR(2) DEFAULT NULL configurator_options: VARCHAR(100) DEFAULT NULL supplier_number: VARCHAR(10) DEFAULT NULL attr1: VARCHAR(2) NOT NULL attr2: VARCHAR(10) DEFAULT NULL attr3: VARCHAR(10) DEFAULT NULL attr4: VARCHAR(10) DEFAULT NULL attr5: VARCHAR(10) DEFAULT NULL attr6: VARCHAR(150) DEFAULT NULL attr7: VARCHAR(10) DEFAULT NULL attr9: VARCHAR(50) DEFAULT NULL attr10: VARCHAR(100) DEFAULT NULL attr11: VARCHAR(10) DEFAULT NULL attr12: VARCHAR(10) DEFAULT NULL attr13: VARCHAR(10) DEFAULT NULL attr14: VARCHAR(10) DEFAULT NULL attr15: VARCHAR(10) DEFAULT NULL attr16: VARCHAR(10) DEFAULT NULL attr17: VARCHAR(100) DEFAULT NULL attr18: VARCHAR(10) DEFAULT NULL attr19: VARCHAR(10) DEFAULT NULL attr20: VARCHAR(350) DEFAULT NULL attr21: VARCHAR(255) DEFAULT NULL attr22: VARCHAR(255) DEFAULT NULL attr23: VARCHAR(10) DEFAULT NULL attr24: VARCHAR(255) DEFAULT NULL attr25: VARCHAR(10) DEFAULT NULL attr26: VARCHAR(10) DEFAULT NULL attr27: VARCHAR(50) DEFAULT NULL attr28: TEXT DEFAULT NULL attr29: VARCHAR(10) DEFAULT NULL attr30: VARCHAR(10) DEFAULT NULL attr31: VARCHAR(10) DEFAULT NULL attr32: VARCHAR(10) DEFAULT NULL attr33: VARCHAR(100) DEFAULT NULL attr34: VARCHAR(255) DEFAULT NULL attr35: VARCHAR(100) DEFAULT NULL attr36: VARCHAR(10) DEFAULT NULL attr41: VARCHAR(10) DEFAULT NULL attr43: VARCHAR(10) DEFAULT NULL ean: VARCHAR(255) DEFAULT NULL weight: VARCHAR(10) DEFAULT NULL stock: VARCHAR(8) DEFAULT NULL kind: VARCHAR(10) DEFAULT NULL shipping_free: VARCHAR(2) DEFAULT NULL attr37: VARCHAR(100) DEFAULT NULL attr37_orig: VARCHAR(100) DEFAULT NULL attr8: VARCHAR(10) DEFAULT NULL attr49: VARCHAR(20) DEFAULT NULL attr50: VARCHAR(10) DEFAULT NULL attr51: VARCHAR(10) DEFAULT NULL attr52: VARCHAR(10) DEFAULT NULL description_long: TEXT DEFAULT NULL LBNTEK: VARCHAR(10) DEFAULT NULL LBKALK: VARCHAR(10) DEFAULT NULL attr53: VARCHAR(25) DEFAULT NULL attr54: VARCHAR(10) DEFAULT NULL attr55: VARCHAR(25) DEFAULT NULL attr56: LONGTEXT DEFAULT NULL attr57: LONGTEXT DEFAULT NULL attr58: LONGTEXT DEFAULT NULL attr59: LONGTEXT DEFAULT NULL attr60: LONGTEXT DEFAULT NULL attr61: VARCHAR(255) attr65: TEXT DEFAULT NULL attr66: TEXT DEFAULT NULL tpl_color_badge: VARCHAR(2) DEFAULT NULL bestellsperre: VARCHAR(10) DEFAULT NULL auslaufkennzeichen: VARCHAR(10) DEFAULT NULL prop1: VARCHAR(50) DEFAULT NULL prop2: VARCHAR(50) DEFAULT NULL prop3: VARCHAR(50) DEFAULT NULL prop4: VARCHAR(50) DEFAULT NULL prop5: VARCHAR(50) DEFAULT NULL prop10: VARCHAR(50) DEFAULT NULL prop11: VARCHAR(50) DEFAULT NULL prop12: VARCHAR(50) DEFAULT NULL prop50: VARCHAR(50) DEFAULT NULL prop51: VARCHAR(50) DEFAULT NULL prop52: VARCHAR(50) DEFAULT NULL prop53: VARCHAR(50) DEFAULT NULL prop60: VARCHAR(50) DEFAULT NULL prop61: VARCHAR(50) DEFAULT NULL prop62: VARCHAR(50) DEFAULT NULL prop63: VARCHAR(50) DEFAULT NULL prop64: VARCHAR(50) DEFAULT NULL prop_status: VARCHAR(50) DEFAULT NULL enev_color: VARCHAR(50) DEFAULT NULL enev_download: VARCHAR(255) DEFAULT NULL enev_image: VARCHAR(255) DEFAULT NULL enev_klasse: VARCHAR(255) DEFAULT NULL enev_spectrumfrom: VARCHAR(255) DEFAULT NULL enev_spectrum: VARCHAR(255) DEFAULT NULL enev_active: VARCHAR(2) DEFAULT NULL #Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: Source: ordernumber mainnumber: Source: mainnumber productnumber: Source: ordernumber name: Source: name supplier: Source: supplier taxName: Source: taxName taxValue: Source: taxValue tax_id: Source: tax_id price_EK: Source: price_EK price_gross: Source: price_gross pseudoprice_EK: Source: pseudoprice_EK baseprice_EK: Source: baseprice_EK active: Source: active configurator_options: Source: configurator_options supplier_number: Source: supplier_number attr1: Source: attr1 attr2: Source: attr2 attr3: Source: attr3 attr4: Source: attr4 attr5: Source: attr5 attr6: Source: attr6 attr7: Source: attr7 attr9: Source: attr9 attr10: Source: attr10 attr11: Source: attr11 attr12: Source: attr12 attr13: Source: attr13 attr14: Source: attr14 attr15: Source: attr15 attr16: Source: attr16 attr17: Source: attr17 attr18: Source: attr18 attr19: Source: attr19 attr20: Source: attr20 attr21: Source: attr21 attr22: Source: attr22 attr23: Source: attr23 attr24: #Synonyme Source: attr24 attr26: #sortierte Ware Source: attr26 attr27: #Produktart Source: attr27 attr28: #Produktart Source: attr28 attr29: #Produktart Source: attr29 attr30: #stock local Source: attr30 attr31: #stock inventory Source: attr31 attr32: #google category Source: attr32 attr33: #ebay category Source: attr33 attr34: #amazon category Source: attr34 attr35: #lieferzeit als Text Source: attr35 attr36: #finanzierbare Produkte Source: attr36 attr41: Source: attr41 attr43: Source: attr43 #beratungstexte ean: Source: ean weight: Source: weight stock: Source: stock kind: Source: kind shipping_free: Source: shipping_free attr37: Source: attr37 attr37_orig: Source: attr37_orig attr8: Source: attr8 attr49: Source: attr49 attr50: Source: attr50 attr51: Source: attr51 attr52: Source: attr52 description_long: Source: description_long LBNTEK: Source: LBNTEK LBKALK: Source: LBKALK attr53: Source: attr53 attr54: Source: attr54 attr55: Source: attr55 attr56: Source: attr56 attr57: Source: attr57 attr58: Source: attr58 attr59: Source: attr59 attr60: Source: attr60 attr61: Source: attr61 attr65: Source: attr65 attr66: Source: attr66 tpl_color_badge: Source: tpl_color_badge bestellsperre: Source: bestellsperre auslaufkennzeichen: Source: auslaufkennzeichen prop1: Source: prop1 #Farbe prop2: Source: prop2 #Breite prop3: Source: prop3 #Länge prop4: Source: prop4 #Höhe prop5: Source: prop5 #Abmessung prop10: Source: prop10 #Modell prop11: Source: prop11 #Material prop12: Source: prop12 #Raum prop50: Source: prop50 #Matratze Größe prop51: Source: prop51 #Matratze Härtegrad prop52: Source: prop52 #Matratze Bezugsmaterial prop53: Source: prop53 #Matratze Matratzenart prop60: Source: prop60 #Teppich Flächengewicht prop61: Source: prop61 #Teppich Florhöhe prop62: Source: prop62 #Teppich Fußbodenheizung prop63: Source: prop63 #Teppich Form prop64: Source: prop64 #Teppich Muster prop_status: #falls mindestens ein prop-Feld gefüllt ist, 1, sonst 0 Source: prop1 enev_color: Source: enev_color enev_download: Source: enev_download enev_image: Source: enev_image enev_klasse: Source: enev_klasse enev_spectrumfrom: Source: enev_spectrumfrom enev_spectrum: Source: enev_spectrum enev_active: Source: enev_active #Target Datapool: export_articles_sw6_dev_oms_combined #sql table Primary_Key: [ordernumber, attr1]
Definition aktualisieren