Legacy YAML iwm_properties

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_properties
Target_Datapool: iwm_properties
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_properties
                ) as t1
           GROUP by ordernumber ) as t2


Mapping:
 ordernumber:
  Source: t2.ordernumber
 mainnumber:
   Source: t2.mainnumber
   File_Field_Adapter:
    File: iwm_properties.mainnumber
 firma: t2.firma
 propertyGroupName:
  Source: t2.propertyGroupName
 propertyValueName:
  Source: t2.propertyValueName
  File_Field_Adapter:
   File: iwm_properties.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_properties
Target_Datapool	iwm_properties
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_properties ) as t1 GROUP by ordernumber ) as t2
Mapping	{ "ordernumber": { "Source": "t2.ordernumber" }, "mainnumber": { "Source": "t2.mainnumber", "File_Field_Adapter": { "File": "iwm_properties.mainnumber" } }, "firma": "t2.firma", "propertyGroupName": { "Source": "t2.propertyGroupName" }, "propertyValueName": { "Source": "t2.propertyValueName", "File_Field_Adapter": { "File": "iwm_properties.propertyValueName", "Datapool": "static_mapping_properties", "Engine": "importEngine", "Identifier": "id", "Fields": [ "id", "property", "up_to_value", "group_name" ] } } }