Engine / Editor
enhance_iwm_articles_properties
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
enhance
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
Engine: Enhance Source_Config: unitizeEngine Target_Config: enhanceEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: iwm_articles_properties Target_Datapool: iwm_articles_properties Engine_Mode: delta Enhance_Mode: flexible Joins: - Left_Join: Datapool: dg_supplierdata.static_mapping_colors Join_Condition: iwm_articles_properties.farbe = static_mapping_colors.LANGTXT - Join: Datapool: dg_supplierdata_enhanced.articles_new Join_Condition: iwm_articles_properties.ordernumber = articles_new.ordernumber and iwm_articles_properties.firma = articles_new.attr1 Mapping: ordernumber: iwm_articles_properties.ordernumber mainnumber: iwm_articles_properties.mainnumber arte: iwm_articles_properties.arte firma: iwm_articles_properties.firma title: Source: iwm_articles_properties.title Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: articles_new #name of cross datapool Cross_Field: name_ost #field to select value from in cross datapool Local_Key: ordernumber #key for where condition from datapool Cross_Key: ordernumber #key for where condition from cross datapool attr2: Source: iwm_articles_properties.attr2 Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: articles_new #name of cross datapool Cross_Field: attr2 #field to select value from in cross datapool Local_Key: ordernumber #key for where condition from datapool Cross_Key: ordernumber #key for where condition from cross datapool attr3: Source: iwm_articles_properties.attr3 Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: articles_new #name of cross datapool Cross_Field: attr3 #field to select value from in cross datapool Local_Key: ordernumber #key for where condition from datapool Cross_Key: ordernumber #key for where condition from cross datapool additional_properties: iwm_articles_properties.additional_properties configuratorOptions: Source: iwm_articles_properties.title Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: articles_new #name of cross datapool Cross_Field: configuratorOptions #field to select value from in cross datapool Local_Key: ordernumber #key for where condition from datapool Cross_Key: ordernumber #key for where condition from cross datapool farbe_exakt: iwm_articles_properties.farbe farbe_pre: Source: static_mapping_colors.LANGTXTMAN File_Field_Adapter: File: iwm_articles_properties.farbe_pre # Cross_Field_Adapters_Target_Injection: # - Cross_Field_Adapter: # Config: importEngine # Cross_Datapool: dynamic_mapping_colors_csv # Cross_Field: farbe # Mapping: # farbe_pre: farbe_exakt # Options: # - case_sensitiv: false farbe: Source: static_mapping_colors.LANGTXTMAN # File_Field_Adapter: # File: iwm_articles_properties.farbe # Cross_Field_Adapters_Target_Injection: # - Cross_Field_Adapter: # Config: importEngine # Cross_Datapool: dynamic_mapping_colors_csv # Cross_Field: farbe # Mapping: # farbe: farbe_exakt # Options: # - case_sensitiv: false material: iwm_articles_properties.material stil: Source: iwm_articles_properties.stil File_Field_Adapter: Files: - iwm_articles_properties.standard_property_variant_and_flat - iwm_articles_properties.process_multi_values_per_property gewicht: Source: iwm_articles_properties.gewicht File_Field_Adapter: File: iwm_articles_properties.gewicht groesse: Source: iwm_articles_properties.groesse File_Field_Adapter: File: iwm_articles_properties.groesse knuepfart: iwm_articles_properties.knuepfart dim1: iwm_articles_properties.dim1 dim2: iwm_articles_properties.dim2 dim3: iwm_articles_properties.dim3 Breite: Source: iwm_articles_properties.dim1 File_Field_Adapter: File: iwm_articles_properties.Breite Laenge: Source: iwm_articles_properties.dim1 File_Field_Adapter: File: iwm_articles_properties.Laenge Hoehe: Source: iwm_articles_properties.dim1 File_Field_Adapter: File: iwm_articles_properties.Hoehe Tiefe: Source: iwm_articles_properties.dim1 File_Field_Adapter: File: iwm_articles_properties.Tiefe Durchmesser: Source: iwm_articles_properties.dim1 File_Field_Adapter: File: iwm_articles_properties.Durchmesser abmessung: Source: iwm_articles_properties.dim1 File_Field_Adapter: File: iwm_articles_properties.abmessung # Breite_ohne_Einheit: # Source: iwm_articles_properties.Breite_ohne_Einheit # Field_Adapter: # - get_current_field_data: Breite # - trim: 'cm ' Breite_ohne_Einheit: Source: iwm_articles_properties.Breite File_Field_Adapter: File: iwm_articles_properties.ohne_Einheit Laenge_ohne_Einheit: Source: iwm_articles_properties.Laenge File_Field_Adapter: File: iwm_articles_properties.ohne_Einheit Hoehe_ohne_Einheit: Source: iwm_articles_properties.Hoehe File_Field_Adapter: File: iwm_articles_properties.ohne_Einheit Tiefe_ohne_Einheit: Source: iwm_articles_properties.Tiefe File_Field_Adapter: File: iwm_articles_properties.ohne_Einheit Durchmesser_ohne_Einheit: Source: iwm_articles_properties.Durchmesser File_Field_Adapter: File: iwm_articles_properties.ohne_Einheit funktion: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Funktion:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.funktion Energiesparklasse: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Energiesparklasse:[A-Za-z0-9öüäß\+ -\/]*\|{0,1}/' ] # File_Field_Adapter: # File: iwm_articles_properties.Energiesparklasse fuellung: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Füllung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.fuellung ausfuehrungsart: iwm_articles_properties.ausfuehrungsart bezug: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Bezug:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat massagefunktion: iwm_articles_properties.massagefunktion Produkteigenschaften: Source: iwm_articles_properties.Produkteigenschaften File_Field_Adapter: File: iwm_articles_properties.Produkteigenschaften Datapool: iwm_articles_tvk_htag Engine: unitizeEngine Identifier: arte Fields: - firma - arte - properties PLPKAT: iwm_articles_properties.PLPKAT Fassung: Source: iwm_articles_properties.Fassung File_Field_Adapter: File: iwm_articles_properties.Fassung Energieeffizienzklasse: Source: iwm_articles_properties.Energieeffizienzklasse File_Field_Adapter: File: iwm_articles_properties.Energieeffizienzklasse Lichtstrom: Source: iwm_articles_properties.Lichtstrom File_Field_Adapter: File: iwm_articles_properties.Lichtstrom Leistung: Source: iwm_articles_properties.Leistung File_Field_Adapter: File: iwm_articles_properties.Leistung Lebensdauer: Source: iwm_articles_properties.Lebensdauer File_Field_Adapter: File: iwm_articles_properties.Lebensdauer Farbtemperatur: Source: iwm_articles_properties.Farbtemperatur File_Field_Adapter: File: iwm_articles_properties.Farbtemperatur Matratzenart: Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.Matratzenart Florhoehe_exakt: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Florhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Florhoehe_exakt Florhoehe: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Florhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Florhoehe Datapool: static_mapping_properties Engine: importEngine Identifier: id Fields: - id - property - up_to_value - group_name Flaechengewicht_exakt: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Flächengewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Flaechengewicht_exakt Flaechengewicht: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Flächengewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Flaechengewicht Datapool: static_mapping_properties Engine: importEngine Identifier: id Fields: - id - property - up_to_value - group_name Raum: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Raum Scheuertouren: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Scheuertouren Qualitaet: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Qualitaet IP: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.IP Farbwechsler: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Farbwechsler Fernbedienung: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Fernbedienung Farbtemparatureinstellbar: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Farbtemparatureinstellbar Dimmbar: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Dimmbar fuer_fussbodenheizung_geeignet: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Fußbodenheizung geeignet:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.fuer_fussbodenheizung_geeignet Typ: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Typ:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Typ Form: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Form:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Form Design: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Design:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: iwm_articles_properties.Design Gesamtgewicht: () Muster: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: ['/Muster:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: Files: - iwm_articles_properties.standard_property_variant_and_flat - iwm_articles_properties.process_multi_values_per_property Liegeflaeche: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Liegefläche:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: Files: - iwm_articles_properties.Liegeflaeche - iwm_articles_properties.standard_property_variant_and_flat - iwm_articles_properties.process_multi_values_per_property - iwm_articles_properties.format_Liegeflaeche Haertegrad: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Härtegrad:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: Files: - iwm_articles_properties.standard_property_variant_and_flat - iwm_articles_properties.Haertegrad Dessin: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Dessin:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Fuss: () Tischplatte: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Tischplatte Gestellfarbe: () Front: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Front Korpus: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Korpus Anschlag: () Varianten: () Holzart: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Holzart:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: Files: - iwm_articles_properties.standard_property_variant_and_flat - iwm_articles_properties.process_multi_values_per_property Kissenbezug: () Sitzschale: () Oberflaeche: () Fussform: () Mass: () Fussfarbe: () Farbvariante: () Sitz: () Gestell: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Gestell Materialvariante: () Rueckenlehne: () Polsterung: () Kontrastnaht: Source: iwm_articles_properties.additional_properties File_Field_Adapter: File: iwm_articles_properties.Kontrastnaht Leder: () Holzausfuehrung: () Sitzhoehe: () Nahtart: () Korpus_und_Arbeitsplatte: () Griff: () Ruecken: () Korpusbezug: () Sitz_und_Kissen: () Arbeitsplatte: () Innenkorpus: () Applikationsfarbe: () Wangenform: () Tischsaeule: () Stauraum: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Stauraum:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Wendematratze: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Wendematratze:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Matratzenkern: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Matratzenkern:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: Files: - iwm_articles_properties.standard_property_variant_and_flat - iwm_articles_properties.Matratzenkern Zonen: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Zonen:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Elektrische_Verstellung: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Elektrische Verstellung:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Maximale_Belastbarkeit: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Maximale Belastbarkeit:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Sitztiefenverstellung: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Sitztiefenverstellung:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Schlaffunktion: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Schlaffunktion:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Wall_Free: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Wall Free:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Ruecken_echt: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Rücken echt:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Verstellbar: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Verstellbar:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Drehbar: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Drehbar:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Hoehenverstellbar: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Höhenverstellbar:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Armlehne: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Armlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Gestellmaterial: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Gestellmaterial:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Aufstehhilfe: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Aufstehhilfe:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Ausziehbar: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Ausziehbar:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Tischform: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Tischform:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Gestellform: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Gestellform:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Klappbar: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Klappbar:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat Stapelbar: Source: iwm_articles_properties.additional_properties Field_Adapter: - get_preg_match: [ '/Stapelbar:[A-Za-z0-9öüäß -\/]*\|{0,1}/' ] File_Field_Adapter: File: iwm_articles_properties.standard_property_variant_and_flat propertyGroupName: (Eigenschaften) propertyValueName: Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.propertyValueName prop1: #Farbe Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: File: iwm_articles_properties.prop1 prop2: #Breite Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop2 prop3: #Länge Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop3 prop4: #Höhe Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop4 prop5: #Abmessung Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop5 prop10: #Modell Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: File: iwm_articles_properties.prop10 prop11: #Material Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: File: iwm_articles_properties.prop11 prop12: #Raum Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: File: iwm_articles_properties.prop12 prop50: #Matratze Größe Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: Config: importEngine Engine: importEngine Datapool: static_mapping_matratzengroessen Identifier: id File: iwm_articles_properties.prop50 Fields: - id - hoehe - laenge - breite prop51: #Matratze Härtegrad Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: File: iwm_articles_properties.prop51 prop52: #Matratze Bezugsmaterial Source: iwm_articles_properties.configuratorOptions File_Field_Adapter: File: iwm_articles_properties.prop52 prop53: #Matratze Matratzenart Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop53 prop60: #Teppich Flächengewicht Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop60 prop61: #Teppich Florhöhe Source: iwm_articles_properties.title File_Field_Adapter: File: variant_properties.prop61 prop62: #Teppich Fußbodenheizung Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop62 prop63: #Teppich Form Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop63 prop64: #Teppich Muster Source: iwm_articles_properties.title File_Field_Adapter: File: iwm_articles_properties.prop64 prop_status: #Teppich Muster Source: iwm_articles_properties.prop_status File_Field_Adapter: File: enhance_properties.prop_status
Definition aktualisieren