Legacy YAML enhance_iwm_articles_properties_farbe

Legacy-Definition sicher vergleichen

Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.

Zum Raw YAML Zu den Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

enhanceEngine Kurzinfo

Raw YAML

Dateiinhalt

Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.

#This engine is just for mapping configuration values/dimension values of farbe that are injected in the properties farbe

Engine: Enhance
Source_Config: enhanceEngine
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: full
Enhance_Mode: flexible

Joins:
 - Left_Join:
   Datapool: dg_supplierdata.dynamic_mapping_colors_csv
   Join_Condition: iwm_articles_properties.farbe = dynamic_mapping_colors_csv.farbe_exakt

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
    attr2:
      Source: iwm_articles_properties.attr2
    attr3:
      Source: iwm_articles_properties.attr3
    additional_properties: iwm_articles_properties.additional_properties
    configuratorOptions:
      Source: iwm_articles_properties.configuratorOptions
    farbe_exakt: iwm_articles_properties.farbe_exakt
    farbe:
      Source: dynamic_mapping_colors_csv.farbe
    material: iwm_articles_properties.material
    stil: iwm_articles_properties.stil
    gewicht:
      Source: iwm_articles_properties.gewicht
    groesse:
      Source: 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.Breite
    Laenge:
      Source: iwm_articles_properties.Laenge
    Hoehe:
      Source: iwm_articles_properties.Hoehe
    Tiefe:
      Source: iwm_articles_properties.Tiefe
    Durchmesser:
      Source: iwm_articles_properties.Durchmesser
    abmessung:
      Source: iwm_articles_properties.abmessung
    funktion:
      Source: iwm_articles_properties.funktion
    fuellung:
      Source: iwm_articles_properties.fuellung
    ausfuehrungsart: iwm_articles_properties.ausfuehrungsart
    bezug:
      Source: iwm_articles_properties.bezug
    massagefunktion: iwm_articles_properties.massagefunktion
    aufstehhilfe: iwm_articles_properties.aufstehhilfe
    Produkteigenschaften:
       Source: iwm_articles_properties.Produkteigenschaften
    PLPKAT: iwm_articles_properties.PLPKAT
    Fassung:
      Source: iwm_articles_properties.Fassung
    Energieeffizienzklasse: iwm_articles_properties.Energieeffizienzklasse
    Lichtstrom:
      Source: iwm_articles_properties.Lichtstrom
    Leistung:
      Source: iwm_articles_properties.Leistung
    Lebensdauer:
      Source: iwm_articles_properties.Lebensdauer
    Farbtemperatur:
      Source: iwm_articles_properties.Farbtemperatur
    Matratzenart:
      Source: iwm_articles_properties.Matratzenart
    Florhoehe_exakt:
      Source: iwm_articles_properties.Florhoehe_exakt
    Florhoehe:
      Source: iwm_articles_properties.Florhoehe
    Flaechengewicht_exakt:
      Source: iwm_articles_properties.Flaechengewicht_exakt
    Flaechengewicht:
      Source: iwm_articles_properties.Flaechengewicht
    Raum:
      Source: iwm_articles_properties.Raum
    Scheuertouren:
      Source: iwm_articles_properties.Scheuertouren
    Qualitaet:
      Source: iwm_articles_properties.Qualitaet
    IP:
      Source: iwm_articles_properties.IP
    Farbwechsler:
      Source: iwm_articles_properties.Farbwechsler
    Fernbedienung:
      Source: iwm_articles_properties.Fernbedienung
    Farbtemparatureinstellbar:
      Source: iwm_articles_properties.Farbtemparatureinstellbar
    Dimmbar:
      Source: iwm_articles_properties.Dimmbar
    fuer_fussbodenheizung_geeignet:
      Source: iwm_articles_properties.fuer_fussbodenheizung_geeignet
    Typ:
      Source: iwm_articles_properties.Typ
    Form:
      Source: iwm_articles_properties.Form
    Design:
      Source: iwm_articles_properties.Design
    Gesamtgewicht: iwm_articles_properties.Gesamtgewicht
    Muster:
      Source: iwm_articles_properties.Muster
    Liegeflaeche:
      Source: iwm_articles_properties.Liegeflaeche
    Haertegrad:
      Source: iwm_articles_properties.Haertegrad
    Dessin:
      Source: iwm_articles_properties.Dessin
    Fuss: iwm_articles_properties.Fuss
    Tischplatte:
      Source: iwm_articles_properties.Tischplatte
    Gestellfarbe: iwm_articles_properties.Gestellfarbe
    Front:
      Source: iwm_articles_properties.Front
    Korpus:
      Source: iwm_articles_properties.Korpus
    Anschlag: iwm_articles_properties.Anschlag
    Varianten: iwm_articles_properties.Varianten
    Holzart:
      Source: iwm_articles_properties.Holzart
    Kissenbezug: iwm_articles_properties.Kissenbezug
    Sitzschale: iwm_articles_properties.Sitzschale
    Oberflaeche: iwm_articles_properties.Oberflaeche
    Fussform: iwm_articles_properties.Fussform
    Mass: iwm_articles_properties.Mass
    Fussfarbe: iwm_articles_properties.Fussfarbe
    Farbvariante: iwm_articles_properties.Farbvariante
    Sitz: iwm_articles_properties.Sitz
    Gestell:
      Source: iwm_articles_properties.Gestell
    Materialvariante: iwm_articles_properties.Materialvariante
    Rueckenlehne: iwm_articles_properties.Rueckenlehne
    Polsterung: iwm_articles_properties.Polsterung
    Kontrastnaht:
      Source: iwm_articles_properties.Kontrastnaht
    Leder: iwm_articles_properties.Leder
    Holzausfuehrung: iwm_articles_properties.Holzausfuehrung
    Sitzhoehe: iwm_articles_properties.Sitzhoehe
    Nahtart: iwm_articles_properties.Nahtart
    Korpus_und_Arbeitsplatte: iwm_articles_properties.Korpus_und_Arbeitsplatte
    Griff:  iwm_articles_properties.Griff
    Armlehne: iwm_articles_properties.Armlehne
    Ruecken: iwm_articles_properties.Ruecken
    Korpusbezug: iwm_articles_properties.Korpusbezug
    Sitz_und_Kissen: iwm_articles_properties.Sitz_und_Kissen
    Arbeitsplatte: iwm_articles_properties.Arbeitsplatte
    Innenkorpus: iwm_articles_properties.Innenkorpus
    Applikationsfarbe: iwm_articles_properties.Applikationsfarbe
    Wangenform: iwm_articles_properties.Wangenform
    Tischsaeule: iwm_articles_properties.Tischsaeule
    Stauraum: iwm_articles_properties.Stauraum
    Wendematratze: iwm_articles_properties.Wendematratze
    Matratzenkern: iwm_articles_properties.Matratzenkern
    Zonen: iwm_articles_properties.Zonen
    Elektrische_Verstellung: iwm_articles_properties.Elektrische_Verstellung
    Maximale_Belastbarkeit: iwm_articles_properties.Maximale_Belastbarkeit
    propertyGroupName: (Eigenschaften)
    propertyValueName:
      Source: iwm_articles_properties.propertyValueName
      File_Field_Adapter:
        File: iwm_articles_properties.propertyValueName
    prop1: #Farbe
      Source: iwm_articles_properties.prop1
    prop2: 	#Breite
     Source: iwm_articles_properties.prop2
    prop3: 	#Länge
     Source: iwm_articles_properties.prop3
    prop4: 	#Höhe
     Source: iwm_articles_properties.prop4
    prop5: 	#Abmessung
     Source: iwm_articles_properties.prop5
    prop10: 	#Modell
      Source: iwm_articles_properties.prop10
    prop11: 	#Material
      Source: iwm_articles_properties.prop11
    prop12: 	#Raum
      Source: iwm_articles_properties.prop12
    prop50: 	#Matratze Größe
      Source: iwm_articles_properties.prop50
    prop51: 	#Matratze Härtegrad
      Source: iwm_articles_properties.prop51
    prop52: 	#Matratze Bezugsmaterial
      Source: iwm_articles_properties.prop52
    prop53: 	#Matratze Matratzenart
      Source: iwm_articles_properties.prop53
    prop60:	#Teppich Flächengewicht
      Source: iwm_articles_properties.prop60
    prop61: 	#Teppich Florhöhe
      Source: iwm_articles_properties.prop61
    prop62: 	#Teppich Fußbodenheizung
      Source: iwm_articles_properties.prop62
    prop63: 	#Teppich Form
      Source: iwm_articles_properties.prop63
    prop64: 	#Teppich Muster
      Source: iwm_articles_properties.prop64

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Engine	Enhance
Source_Config	enhanceEngine
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	full
Enhance_Mode	flexible
Joins	[ { "Left_Join": null, "Datapool": "dg_supplierdata.dynamic_mapping_colors_csv", "Join_Condition": "iwm_articles_properties.farbe = dynamic_mapping_colors_csv.\ufefffarbe_exakt" } ]
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" }, "attr2": { "Source": "iwm_articles_properties.attr2" }, "attr3": { "Source": "iwm_articles_properties.attr3" }, "additional_properties": "iwm_articles_properties.additional_properties", "configuratorOptions": { "Source": "iwm_articles_properties.configuratorOptions" }, "farbe_exakt": "iwm_articles_properties.farbe_exakt", "farbe": { "Source": "dynamic_mapping_colors_csv.farbe" }, "material": "iwm_articles_properties.material", "stil": "iwm_articles_properties.stil", "gewicht": { "Source": "iwm_articles_properties.gewicht" }, "groesse": { "Source": "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.Breite" }, "Laenge": { "Source": "iwm_articles_properties.Laenge" }, "Hoehe": { "Source": "iwm_articles_properties.Hoehe" }, "Tiefe": { "Source": "iwm_articles_properties.Tiefe" }, "Durchmesser": { "Source": "iwm_articles_properties.Durchmesser" }, "abmessung": { "Source": "iwm_articles_properties.abmessung" }, "funktion": { "Source": "iwm_articles_properties.funktion" }, "fuellung": { "Source": "iwm_articles_properties.fuellung" }, "ausfuehrungsart": "iwm_articles_properties.ausfuehrungsart", "bezug": { "Source": "iwm_articles_properties.bezug" }, "massagefunktion": "iwm_articles_properties.massagefunktion", "aufstehhilfe": "iwm_articles_properties.aufstehhilfe", "Produkteigenschaften": { "Source": "iwm_articles_properties.Produkteigenschaften" }, "PLPKAT": "iwm_articles_properties.PLPKAT", "Fassung": { "Source": "iwm_articles_properties.Fassung" }, "Energieeffizienzklasse": "iwm_articles_properties.Energieeffizienzklasse", "Lichtstrom": { "Source": "iwm_articles_properties.Lichtstrom" }, "Leistung": { "Source": "iwm_articles_properties.Leistung" }, "Lebensdauer": { "Source": "iwm_articles_properties.Lebensdauer" }, "Farbtemperatur": { "Source": "iwm_articles_properties.Farbtemperatur" }, "Matratzenart": { "Source": "iwm_articles_properties.Matratzenart" }, "Florhoehe_exakt": { "Source": "iwm_articles_properties.Florhoehe_exakt" }, "Florhoehe": { "Source": "iwm_articles_properties.Florhoehe" }, "Flaechengewicht_exakt": { "Source": "iwm_articles_properties.Flaechengewicht_exakt" }, "Flaechengewicht": { "Source": "iwm_articles_properties.Flaechengewicht" }, "Raum": { "Source": "iwm_articles_properties.Raum" }, "Scheuertouren": { "Source": "iwm_articles_properties.Scheuertouren" }, "Qualitaet": { "Source": "iwm_articles_properties.Qualitaet" }, "IP": { "Source": "iwm_articles_properties.IP" }, "Farbwechsler": { "Source": "iwm_articles_properties.Farbwechsler" }, "Fernbedienung": { "Source": "iwm_articles_properties.Fernbedienung" }, "Farbtemparatureinstellbar": { "Source": "iwm_articles_properties.Farbtemparatureinstellbar" }, "Dimmbar": { "Source": "iwm_articles_properties.Dimmbar" }, "fuer_fussbodenheizung_geeignet": { "Source": "iwm_articles_properties.fuer_fussbodenheizung_geeignet" }, "Typ": { "Source": "iwm_articles_properties.Typ" }, "Form": { "Source": "iwm_articles_properties.Form" }, "Design": { "Source": "iwm_articles_properties.Design" }, "Gesamtgewicht": "iwm_articles_properties.Gesamtgewicht", "Muster": { "Source": "iwm_articles_properties.Muster" }, "Liegeflaeche": { "Source": "iwm_articles_properties.Liegeflaeche" }, "Haertegrad": { "Source": "iwm_articles_properties.Haertegrad" }, "Dessin": { "Source": "iwm_articles_properties.Dessin" }, "Fuss": "iwm_articles_properties.Fuss", "Tischplatte": { "Source": "iwm_articles_properties.Tischplatte" }, "Gestellfarbe": "iwm_articles_properties.Gestellfarbe", "Front": { "Source": "iwm_articles_properties.Front" }, "Korpus": { "Source": "iwm_articles_properties.Korpus" }, "Anschlag": "iwm_articles_properties.Anschlag", "Varianten": "iwm_articles_properties.Varianten", "Holzart": { "Source": "iwm_articles_properties.Holzart" }, "Kissenbezug": "iwm_articles_properties.Kissenbezug", "Sitzschale": "iwm_articles_properties.Sitzschale", "Oberflaeche": "iwm_articles_properties.Oberflaeche", "Fussform": "iwm_articles_properties.Fussform", "Mass": "iwm_articles_properties.Mass", "Fussfarbe": "iwm_articles_properties.Fussfarbe", "Farbvariante": "iwm_articles_properties.Farbvariante", "Sitz": "iwm_articles_properties.Sitz", "Gestell": { "Source": "iwm_articles_properties.Gestell" }, "Materialvariante": "iwm_articles_properties.Materialvariante", "Rueckenlehne": "iwm_articles_properties.Rueckenlehne", "Polsterung": "iwm_articles_properties.Polsterung", "Kontrastnaht": { "Source": "iwm_articles_properties.Kontrastnaht" }, "Leder": "iwm_articles_properties.Leder", "Holzausfuehrung": "iwm_articles_properties.Holzausfuehrung", "Sitzhoehe": "iwm_articles_properties.Sitzhoehe", "Nahtart": "iwm_articles_properties.Nahtart", "Korpus_und_Arbeitsplatte": "iwm_articles_properties.Korpus_und_Arbeitsplatte", "Griff": "iwm_articles_properties.Griff", "Armlehne": "iwm_articles_properties.Armlehne", "Ruecken": "iwm_articles_properties.Ruecken", "Korpusbezug": "iwm_articles_properties.Korpusbezug", "Sitz_und_Kissen": "iwm_articles_properties.Sitz_und_Kissen", "Arbeitsplatte": "iwm_articles_properties.Arbeitsplatte", "Innenkorpus": "iwm_articles_properties.Innenkorpus", "Applikationsfarbe": "iwm_articles_properties.Applikationsfarbe", "Wangenform": "iwm_articles_properties.Wangenform", "Tischsaeule": "iwm_articles_properties.Tischsaeule", "Stauraum": "iwm_articles_properties.Stauraum", "Wendematratze": "iwm_articles_properties.Wendematratze", "Matratzenkern": "iwm_articles_properties.Matratzenkern", "Zonen": "iwm_articles_properties.Zonen", "Elektrische_Verstellung": "iwm_articles_properties.Elektrische_Verstellung", "Maximale_Belastbarkeit": "iwm_articles_properties.Maximale_Belastbarkeit", "propertyGroupName": "(Eigenschaften)", "propertyValueName": { "Source": "iwm_articles_properties.propertyValueName", "File_Field_Adapter": { "File": "iwm_articles_properties.propertyValueName" } }, "prop1": { "Source": "iwm_articles_properties.prop1" }, "prop2": { "Source": "iwm_articles_properties.prop2" }, "prop3": { "Source": "iwm_articles_properties.prop3" }, "prop4": { "Source": "iwm_articles_properties.prop4" }, "prop5": { "Source": "iwm_articles_properties.prop5" }, "prop10": { "Source": "iwm_articles_properties.prop10" }, "prop11": { "Source": "iwm_articles_properties.prop11" }, "prop12": { "Source": "iwm_articles_properties.prop12" }, "prop50": { "Source": "iwm_articles_properties.prop50" }, "prop51": { "Source": "iwm_articles_properties.prop51" }, "prop52": { "Source": "iwm_articles_properties.prop52" }, "prop53": { "Source": "iwm_articles_properties.prop53" }, "prop60": { "Source": "iwm_articles_properties.prop60" }, "prop61": { "Source": "iwm_articles_properties.prop61" }, "prop62": { "Source": "iwm_articles_properties.prop62" }, "prop63": { "Source": "iwm_articles_properties.prop63" }, "prop64": { "Source": "iwm_articles_properties.prop64" } }