Legacy YAML / Detail

enhance / enhance_iwm_articles_properties_2

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
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.

Adapter_Name: iwm_properties
Engine: Unitize
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_2
Engine_Mode: full

Sql: SELECT * FROM (
           SELECT t1.ordernumber, t1.mainnumber, t1.firma, t1.propertyGroupName, GROUP_CONCAT(t1.propertyValueName SEPARATOR'| ') as propertyValueName
           FROM ( SELECT ordernumber, mainnumber, firma, propertyGroupName, propertyValueName FROM `iwm_additional_properties_new`
                   UNION ALL
                  SELECT ordernumber, mainnumber, firma, propertyGroupName, propertyValueName FROM iwm_articles_properties
                ) as t1
           GROUP by ordernumber ) as t2


Mapping:
 ordernumber:
  Source: t2.ordernumber
 mainnumber:
   Source: t2.mainnumber
   File_Field_Adapter:
    File: iwm_articles_properties_2.mainnumber
 firma: t2.firma
 propertyGroupName:
  Source: t2.propertyGroupName
 propertyValueName:
  Source: t2.propertyValueName
  File_Field_Adapter:
   File: iwm_articles_properties_2.propertyValueName
   Datapool: static_mapping_properties
   Engine: importEngine
   Identifier: id
   Fields:
     - id
     - property
     - up_to_value
     - group_name

Metadata

Erkannte Konfiguration

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

Adapter_Name iwm_properties
Engine Unitize
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_2
Engine_Mode full
Sql SELECT * FROM ( SELECT t1.ordernumber, t1.mainnumber, t1.firma, t1.propertyGroupName, GROUP_CONCAT(t1.propertyValueName SEPARATOR'| ') as propertyValueName FROM ( SELECT ordernumber, mainnumber, firma, propertyGroupName, propertyValueName FROM `iwm_additional_properties_new` UNION ALL SELECT ordernumber, mainnumber, firma, propertyGroupName, propertyValueName FROM iwm_articles_properties ) as t1 GROUP by ordernumber ) as t2
Mapping { "ordernumber": { "Source": "t2.ordernumber" }, "mainnumber": { "Source": "t2.mainnumber", "File_Field_Adapter": { "File": "iwm_articles_properties_2.mainnumber" } }, "firma": "t2.firma", "propertyGroupName": { "Source": "t2.propertyGroupName" }, "propertyValueName": { "Source": "t2.propertyValueName", "File_Field_Adapter": { "File": "iwm_articles_properties_2.propertyValueName", "Datapool": "static_mapping_properties", "Engine": "importEngine", "Identifier": "id", "Fields": [ "id", "property", "up_to_value", "group_name" ] } } }