Legacy YAML / Detail

export / export_articles_properties_all_shops

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live
Zurück zum Browser
Managed Definition öffnen

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
export_articles_properties_all_shops Kurzinfo

Raw YAML

Dateiinhalt

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

#Connections
Source_Config: enhanceEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Source_Datapool: iwm_articles_properties  #sql from

Joins:
- Join: #each condition is joined with "AND"
  Datapool: articles_new
  Join_Condition: iwm_articles_properties.ordernumber = articles_new.ordernumber AND iwm_articles_properties.firma = articles_new.attr1

Mapping:
  ordernumber:
    Source: iwm_articles_properties.ordernumber
  mainnumber:
    Source: iwm_articles_properties.mainnumber
  arte:
    Source: iwm_articles_properties.arte
  firma:
    Source: iwm_articles_properties.firma
  title:
    Source: iwm_articles_properties.title
  attr2:
    Source: iwm_articles_properties.attr2
  attr3:
    Source: iwm_articles_properties.attr3
  versandart: #attr13
    Source: articles_new.attr13
  anlieferart:
    Source: articles_new.anlieferart
  additional_properties:
    Source: iwm_articles_properties.additional_properties
  configuratorOptions:
    Source: iwm_articles_properties.configuratorOptions
  farbe_exakt:
    Source: iwm_articles_properties.farbe_exakt
  farbe:
    Source: iwm_articles_properties.farbe
  material:
    Source: iwm_articles_properties.material
  stil:
    Source: iwm_articles_properties.stil
  gewicht:
    Source: iwm_articles_properties.gewicht
  groesse:
    Source: iwm_articles_properties.groesse
  knuepfart:
    Source: iwm_articles_properties.knuepfart
  Breite:
    Source: iwm_articles_properties.Breite_ohne_Einheit
  Laenge:
    Source: iwm_articles_properties.Laenge_ohne_Einheit
  Hoehe:
    Source: iwm_articles_properties.Hoehe_ohne_Einheit
  Tiefe:
    Source: iwm_articles_properties.Tiefe_ohne_Einheit
  Durchmesser:
    Source: iwm_articles_properties.Durchmesser_ohne_Einheit
  abmessung:
    Source: iwm_articles_properties.abmessung
  funktion:
    Source: iwm_articles_properties.funktion
  Energiesparklasse:
    Source: iwm_articles_properties.Energiesparklasse
#  fuellung:
#    Source: iwm_articles_properties.fuellung
  ausfuehrungsart:
    Source: iwm_articles_properties.ausfuehrungsart
  bezug:
    Source: iwm_articles_properties.bezug
  massagefunktion:
    Source: iwm_articles_properties.massagefunktion
  Produkteigenschaften:
    Source: iwm_articles_properties.Produkteigenschaften
  PLPKAT:
    Source: iwm_articles_properties.PLPKAT
  Fassung:
    Source: iwm_articles_properties.Fassung
  Energieeffizienzklasse:
    Source: 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:
    Source: 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:
    Source: iwm_articles_properties.Fuss
  Tischplatte:
    Source: iwm_articles_properties.Tischplatte
  Gestellfarbe:
    Source: iwm_articles_properties.Gestellfarbe
  Front:
    Source: iwm_articles_properties.Front
  Korpus:
    Source: iwm_articles_properties.Korpus
  Anschlag:
    Source: iwm_articles_properties.Anschlag
  Varianten:
    Source: iwm_articles_properties.Varianten
  Holzart:
    Source: iwm_articles_properties.Holzart
  Kissenbezug:
    Source: iwm_articles_properties.Kissenbezug
  Sitzschale:
    Source: iwm_articles_properties.Sitzschale
  Oberflaeche:
    Source: iwm_articles_properties.Oberflaeche
  Fussform:
    Source: iwm_articles_properties.Fussform
  Mass:
    Source: iwm_articles_properties.Mass
  Fussfarbe:
    Source: iwm_articles_properties.Fussfarbe
  Farbvariante:
    Source: iwm_articles_properties.Farbvariante
  Sitz:
    Source: iwm_articles_properties.Sitz
  Gestell:
    Source: iwm_articles_properties.Gestell
  Materialvariante:
    Source: iwm_articles_properties.Materialvariante
  Rueckenlehne:
    Source: iwm_articles_properties.Rueckenlehne
  Polsterung:
    Source: iwm_articles_properties.Polsterung
  Kontrastnaht:
    Source: iwm_articles_properties.Kontrastnaht
  Leder:
    Source: iwm_articles_properties.Leder
  Holzausfuehrung:
    Source: iwm_articles_properties.Holzausfuehrung
  Sitzhoehe:
    Source: iwm_articles_properties.Sitzhoehe
  Nahtart:
    Source: iwm_articles_properties.Nahtart
  Korpus_und_Arbeitsplatte:
    Source: iwm_articles_properties.Korpus_und_Arbeitsplatte
  Griff:
    Source: iwm_articles_properties.Griff
  Ruecken:
    Source: iwm_articles_properties.Ruecken
  Korpusbezug:
    Source: iwm_articles_properties.Korpusbezug
  Sitz_und_Kissen:
    Source: iwm_articles_properties.Sitz_und_Kissen
  Arbeitsplatte:
    Source: iwm_articles_properties.Arbeitsplatte
  Innenkorpus:
    Source: iwm_articles_properties.Innenkorpus
  Applikationsfarbe:
    Source: iwm_articles_properties.Applikationsfarbe
  Wangenform:
    Source: iwm_articles_properties.Wangenform
  Tischsaeule:
    Source: iwm_articles_properties.Tischsaeule
  Stauraum:
    Source: iwm_articles_properties.Stauraum
  Wendematratze:
    Source: iwm_articles_properties.Wendematratze
  Matratzenkern:
    Source: iwm_articles_properties.Matratzenkern
  Zonen:
    Source: iwm_articles_properties.Zonen
  Elektrische_Verstellung:
    Source: iwm_articles_properties.Elektrische_Verstellung
  Maximale_Belastbarkeit:
    Source: iwm_articles_properties.Maximale_Belastbarkeit
  Sitztiefenverstellung:
    Source: iwm_articles_properties.Sitztiefenverstellung
  Schlaffunktion:
    Source: iwm_articles_properties.Schlaffunktion
  Wall_Free:
    Source: iwm_articles_properties.Wall_Free
  Ruecken_echt:
    Source: iwm_articles_properties.Ruecken_echt
  Verstellbar:
    Source: iwm_articles_properties.Verstellbar
  Drehbar:
    Source: iwm_articles_properties.Drehbar
  Hoehenverstellbar:
    Source: iwm_articles_properties.Hoehenverstellbar
  Armlehne:
    Source: iwm_articles_properties.Armlehne
  Gestellmaterial:
    Source: iwm_articles_properties.Gestellmaterial
  Aufstehhilfe:
    Source: iwm_articles_properties.Aufstehhilfe
  Ausziehbar:
    Source: iwm_articles_properties.Ausziehbar
  Tischform:
    Source: iwm_articles_properties.Tischform
  Gestellform:
    Source: iwm_articles_properties.Gestellform
  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
  prop_status:
    Source: iwm_articles_properties.prop_status

Filters:
  - Filter:
      name: DuplicateOrdernumber
      condition:
        Cross_Dataset_Filter_Adapter: filterByDuplicateOrdernumber
      reason: 'There is another dataset with this ordernumber due to selection from trends and ostermann'

#Target
Datapool: export_articles_properties_all_shops #sql table
Primary_Key: [ordernumber]

Metadata

Erkannte Konfiguration

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

Source_Config enhanceEngine
Target_Config exportEngine
Source_Datapool iwm_articles_properties
Joins [ { "Join": null, "Datapool": "articles_new", "Join_Condition": "iwm_articles_properties.ordernumber = articles_new.ordernumber AND iwm_articles_properties.firma = articles_new.attr1" } ]
Mapping { "ordernumber": { "Source": "iwm_articles_properties.ordernumber" }, "mainnumber": { "Source": "iwm_articles_properties.mainnumber" }, "arte": { "Source": "iwm_articles_properties.arte" }, "firma": { "Source": "iwm_articles_properties.firma" }, "title": { "Source": "iwm_articles_properties.title" }, "attr2": { "Source": "iwm_articles_properties.attr2" }, "attr3": { "Source": "iwm_articles_properties.attr3" }, "versandart": { "Source": "articles_new.attr13" }, "anlieferart": { "Source": "articles_new.anlieferart" }, "additional_properties": { "Source": "iwm_articles_properties.additional_properties" }, "configuratorOptions": { "Source": "iwm_articles_properties.configuratorOptions" }, "farbe_exakt": { "Source": "iwm_articles_properties.farbe_exakt" }, "farbe": { "Source": "iwm_articles_properties.farbe" }, "material": { "Source": "iwm_articles_properties.material" }, "stil": { "Source": "iwm_articles_properties.stil" }, "gewicht": { "Source": "iwm_articles_properties.gewicht" }, "groesse": { "Source": "iwm_articles_properties.groesse" }, "knuepfart": { "Source": "iwm_articles_properties.knuepfart" }, "Breite": { "Source": "iwm_articles_properties.Breite_ohne_Einheit" }, "Laenge": { "Source": "iwm_articles_properties.Laenge_ohne_Einheit" }, "Hoehe": { "Source": "iwm_articles_properties.Hoehe_ohne_Einheit" }, "Tiefe": { "Source": "iwm_articles_properties.Tiefe_ohne_Einheit" }, "Durchmesser": { "Source": "iwm_articles_properties.Durchmesser_ohne_Einheit" }, "abmessung": { "Source": "iwm_articles_properties.abmessung" }, "funktion": { "Source": "iwm_articles_properties.funktion" }, "Energiesparklasse": { "Source": "iwm_articles_properties.Energiesparklasse" }, "ausfuehrungsart": { "Source": "iwm_articles_properties.ausfuehrungsart" }, "bezug": { "Source": "iwm_articles_properties.bezug" }, "massagefunktion": { "Source": "iwm_articles_properties.massagefunktion" }, "Produkteigenschaften": { "Source": "iwm_articles_properties.Produkteigenschaften" }, "PLPKAT": { "Source": "iwm_articles_properties.PLPKAT" }, "Fassung": { "Source": "iwm_articles_properties.Fassung" }, "Energieeffizienzklasse": { "Source": "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": { "Source": "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": { "Source": "iwm_articles_properties.Fuss" }, "Tischplatte": { "Source": "iwm_articles_properties.Tischplatte" }, "Gestellfarbe": { "Source": "iwm_articles_properties.Gestellfarbe" }, "Front": { "Source": "iwm_articles_properties.Front" }, "Korpus": { "Source": "iwm_articles_properties.Korpus" }, "Anschlag": { "Source": "iwm_articles_properties.Anschlag" }, "Varianten": { "Source": "iwm_articles_properties.Varianten" }, "Holzart": { "Source": "iwm_articles_properties.Holzart" }, "Kissenbezug": { "Source": "iwm_articles_properties.Kissenbezug" }, "Sitzschale": { "Source": "iwm_articles_properties.Sitzschale" }, "Oberflaeche": { "Source": "iwm_articles_properties.Oberflaeche" }, "Fussform": { "Source": "iwm_articles_properties.Fussform" }, "Mass": { "Source": "iwm_articles_properties.Mass" }, "Fussfarbe": { "Source": "iwm_articles_properties.Fussfarbe" }, "Farbvariante": { "Source": "iwm_articles_properties.Farbvariante" }, "Sitz": { "Source": "iwm_articles_properties.Sitz" }, "Gestell": { "Source": "iwm_articles_properties.Gestell" }, "Materialvariante": { "Source": "iwm_articles_properties.Materialvariante" }, "Rueckenlehne": { "Source": "iwm_articles_properties.Rueckenlehne" }, "Polsterung": { "Source": "iwm_articles_properties.Polsterung" }, "Kontrastnaht": { "Source": "iwm_articles_properties.Kontrastnaht" }, "Leder": { "Source": "iwm_articles_properties.Leder" }, "Holzausfuehrung": { "Source": "iwm_articles_properties.Holzausfuehrung" }, "Sitzhoehe": { "Source": "iwm_articles_properties.Sitzhoehe" }, "Nahtart": { "Source": "iwm_articles_properties.Nahtart" }, "Korpus_und_Arbeitsplatte": { "Source": "iwm_articles_properties.Korpus_und_Arbeitsplatte" }, "Griff": { "Source": "iwm_articles_properties.Griff" }, "Ruecken": { "Source": "iwm_articles_properties.Ruecken" }, "Korpusbezug": { "Source": "iwm_articles_properties.Korpusbezug" }, "Sitz_und_Kissen": { "Source": "iwm_articles_properties.Sitz_und_Kissen" }, "Arbeitsplatte": { "Source": "iwm_articles_properties.Arbeitsplatte" }, "Innenkorpus": { "Source": "iwm_articles_properties.Innenkorpus" }, "Applikationsfarbe": { "Source": "iwm_articles_properties.Applikationsfarbe" }, "Wangenform": { "Source": "iwm_articles_properties.Wangenform" }, "Tischsaeule": { "Source": "iwm_articles_properties.Tischsaeule" }, "Stauraum": { "Source": "iwm_articles_properties.Stauraum" }, "Wendematratze": { "Source": "iwm_articles_properties.Wendematratze" }, "Matratzenkern": { "Source": "iwm_articles_properties.Matratzenkern" }, "Zonen": { "Source": "iwm_articles_properties.Zonen" }, "Elektrische_Verstellung": { "Source": "iwm_articles_properties.Elektrische_Verstellung" }, "Maximale_Belastbarkeit": { "Source": "iwm_articles_properties.Maximale_Belastbarkeit" }, "Sitztiefenverstellung": { "Source": "iwm_articles_properties.Sitztiefenverstellung" }, "Schlaffunktion": { "Source": "iwm_articles_properties.Schlaffunktion" }, "Wall_Free": { "Source": "iwm_articles_properties.Wall_Free" }, "Ruecken_echt": { "Source": "iwm_articles_properties.Ruecken_echt" }, "Verstellbar": { "Source": "iwm_articles_properties.Verstellbar" }, "Drehbar": { "Source": "iwm_articles_properties.Drehbar" }, "Hoehenverstellbar": { "Source": "iwm_articles_properties.Hoehenverstellbar" }, "Armlehne": { "Source": "iwm_articles_properties.Armlehne" }, "Gestellmaterial": { "Source": "iwm_articles_properties.Gestellmaterial" }, "Aufstehhilfe": { "Source": "iwm_articles_properties.Aufstehhilfe" }, "Ausziehbar": { "Source": "iwm_articles_properties.Ausziehbar" }, "Tischform": { "Source": "iwm_articles_properties.Tischform" }, "Gestellform": { "Source": "iwm_articles_properties.Gestellform" }, "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" }, "prop_status": { "Source": "iwm_articles_properties.prop_status" } }
Filters [ { "Filter": { "name": "DuplicateOrdernumber", "condition": { "Cross_Dataset_Filter_Adapter": "filterByDuplicateOrdernumber" }, "reason": "There is another dataset with this ordernumber due to selection from trends and ostermann" } } ]
Datapool export_articles_properties_all_shops
Primary_Key [ "ordernumber" ]