Legacy YAML / Detail

unitize / unitize_variant_properties

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

Raw YAML

Dateiinhalt

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

Engine: Unitize
Source_Config: enhanceEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: articles
Source_Primary_Key: [ordernumber, ItemFirm]
Target_Primary_Key: [ordernumber, attr1] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: variant_properties


Joins:
 - Left_Join:
   Datapool: iwm_properties_3
   Join_Condition:  articles.attr1 = iwm_properties_3.firma and articles.ordernumber = iwm_properties_3.ordernumber


Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    mainnumber: VARCHAR(255) DEFAULT NULL
    name_ost: VARCHAR(255) DEFAULT NULL
    name_tre: VARCHAR(255) DEFAULT NULL
    name_oms: VARCHAR(255) DEFAULT NULL
    supplier_ost: VARCHAR(255) DEFAULT NULL
    supplier_tre: VARCHAR(255) DEFAULT NULL
    supplier_oms: VARCHAR(255) DEFAULT NULL
    description_long_ost: MEDIUMTEXT DEFAULT NULL
    description_long_tre: MEDIUMTEXT DEFAULT NULL
    description_long_oms: MEDIUMTEXT DEFAULT NULL
    configuratorType: VARCHAR(255) DEFAULT NULL
    configuratorOptions: VARCHAR(255) DEFAULT NULL
    kind: VARCHAR(255) DEFAULT NULL
    suppliernumber: VARCHAR(255) DEFAULT NULL
    propertyGroupName: VARCHAR(255) DEFAULT NULL
    propertyValueName: MEDIUMTEXT DEFAULT NULL
    attr1: VARCHAR(255) NOT NULL
    attr2: VARCHAR(255) DEFAULT NULL
    attr3: VARCHAR(255) DEFAULT NULL
    main_properties: MEDIUMTEXT DEFAULT NULL
    prop1: VARCHAR(255) DEFAULT NULL
    prop2: VARCHAR(255) DEFAULT NULL
    prop3: VARCHAR(255) DEFAULT NULL
    prop4: VARCHAR(255) DEFAULT NULL
    prop5: VARCHAR(255) DEFAULT NULL
    prop10: VARCHAR(255) DEFAULT NULL
    prop11: VARCHAR(255) DEFAULT NULL
    prop12: VARCHAR(255) DEFAULT NULL
    prop50: VARCHAR(255) DEFAULT NULL
    prop51: VARCHAR(255) DEFAULT NULL
    prop52: VARCHAR(255) DEFAULT NULL
    prop53: VARCHAR(255) DEFAULT NULL
    prop60: VARCHAR(255) DEFAULT NULL
    prop61: VARCHAR(255) DEFAULT NULL
    prop62: VARCHAR(255) DEFAULT NULL
    prop63: VARCHAR(255) DEFAULT NULL
    prop64: VARCHAR(255) DEFAULT NULL



Mapping:
    ordernumber: articles.ordernumber
    mainnumber: articles.mainnumber
    name_ost: articles.name_ost
    name_tre: articles.name_tre
    name_oms: articles.name_oms
    supplier_ost: articles.supplier_ost
    supplier_tre: articles.supplier_tre
    supplier_oms: articles.supplier_oms
    configuratorType: articles.configuratorType
    configuratorOptions: articles.configuratorOptions
    kind: articles.kind
    suppliernumber: articles.suppliernumber
    propertyGroupName: articles.propertyGroupName
    propertyValueName: articles.propertyValueName
    attr1: articles.attr1
    attr2: articles.attr2
    attr3: articles.attr3
    main_properties: iwm_properties_3.propertyValueName
    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

Metadata

Erkannte Konfiguration

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

Engine Unitize
Source_Config enhanceEngine
Target_Config unitizeEngine
Mysql_Engine InnoDB
Default_Charset latin1
Source_Connection_Type database
Source_Database_Connection_Service DatabaseConnectionService
Source_Datapool articles
Source_Primary_Key [ "ordernumber", "ItemFirm" ]
Target_Primary_Key [ "ordernumber", "attr1" ]
Datapool variant_properties
Joins [ { "Left_Join": null, "Datapool": "iwm_properties_3", "Join_Condition": "articles.attr1 = iwm_properties_3.firma and articles.ordernumber = iwm_properties_3.ordernumber" } ]
Datapool_Definition { "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) DEFAULT NULL", "name_ost": "VARCHAR(255) DEFAULT NULL", "name_tre": "VARCHAR(255) DEFAULT NULL", "name_oms": "VARCHAR(255) DEFAULT NULL", "supplier_ost": "VARCHAR(255) DEFAULT NULL", "supplier_tre": "VARCHAR(255) DEFAULT NULL", "supplier_oms": "VARCHAR(255) DEFAULT NULL", "description_long_ost": "MEDIUMTEXT DEFAULT NULL", "description_long_tre": "MEDIUMTEXT DEFAULT NULL", "description_long_oms": "MEDIUMTEXT DEFAULT NULL", "configuratorType": "VARCHAR(255) DEFAULT NULL", "configuratorOptions": "VARCHAR(255) DEFAULT NULL", "kind": "VARCHAR(255) DEFAULT NULL", "suppliernumber": "VARCHAR(255) DEFAULT NULL", "propertyGroupName": "VARCHAR(255) DEFAULT NULL", "propertyValueName": "MEDIUMTEXT DEFAULT NULL", "attr1": "VARCHAR(255) NOT NULL", "attr2": "VARCHAR(255) DEFAULT NULL", "attr3": "VARCHAR(255) DEFAULT NULL", "main_properties": "MEDIUMTEXT DEFAULT NULL", "prop1": "VARCHAR(255) DEFAULT NULL", "prop2": "VARCHAR(255) DEFAULT NULL", "prop3": "VARCHAR(255) DEFAULT NULL", "prop4": "VARCHAR(255) DEFAULT NULL", "prop5": "VARCHAR(255) DEFAULT NULL", "prop10": "VARCHAR(255) DEFAULT NULL", "prop11": "VARCHAR(255) DEFAULT NULL", "prop12": "VARCHAR(255) DEFAULT NULL", "prop50": "VARCHAR(255) DEFAULT NULL", "prop51": "VARCHAR(255) DEFAULT NULL", "prop52": "VARCHAR(255) DEFAULT NULL", "prop53": "VARCHAR(255) DEFAULT NULL", "prop60": "VARCHAR(255) DEFAULT NULL", "prop61": "VARCHAR(255) DEFAULT NULL", "prop62": "VARCHAR(255) DEFAULT NULL", "prop63": "VARCHAR(255) DEFAULT NULL", "prop64": "VARCHAR(255) DEFAULT NULL" }
Mapping { "ordernumber": "articles.ordernumber", "mainnumber": "articles.mainnumber", "name_ost": "articles.name_ost", "name_tre": "articles.name_tre", "name_oms": "articles.name_oms", "supplier_ost": "articles.supplier_ost", "supplier_tre": "articles.supplier_tre", "supplier_oms": "articles.supplier_oms", "configuratorType": "articles.configuratorType", "configuratorOptions": "articles.configuratorOptions", "kind": "articles.kind", "suppliernumber": "articles.suppliernumber", "propertyGroupName": "articles.propertyGroupName", "propertyValueName": "articles.propertyValueName", "attr1": "articles.attr1", "attr2": "articles.attr2", "attr3": "articles.attr3", "main_properties": "iwm_properties_3.propertyValueName", "prop1": "()", "prop2": "()", "prop3": "()", "prop4": "()", "prop5": "()", "prop10": "()", "prop11": "()", "prop12": "()", "prop50": "()", "prop51": "()", "prop52": "()", "prop53": "()", "prop60": "()", "prop61": "()", "prop62": "()", "prop63": "()", "prop64": "()" }