Legacy YAML / Detail

export / export_lists_export_data

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_lists_export_data 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: exportEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service
Mysql_Engine: InnoDB
Default_Charset: utf8

#Source
Source_Datapool: export_articles_tre  #sql from

Datapool_Definition:
  ordernumber: VARCHAR(20) NOT NULL
  attr1: VARCHAR(10) NOT NULL
  shipping_oms: VARCHAR(255) DEFAULT NULL
  shipping_oms_filtered: VARCHAR(255) DEFAULT NULL
  shipping_ost: VARCHAR(255) DEFAULT NULL
  shipping_tre: VARCHAR(255) DEFAULT NULL
  price_ost: VARCHAR(255) DEFAULT NULL
  price_tre: VARCHAR(255) DEFAULT NULL
  price_oms: VARCHAR(255) DEFAULT NULL
  filter_reason: VARCHAR(255) DEFAULT NULL
  filter_reason_oms: VARCHAR(255) DEFAULT NULL

Sql: SELECT t1.*, export_articles_oms.attr8 as attr8_oms, export_articles_oms_filtered.attr8 as attr8_oms_filtered, export_articles_oms_filtered.filter_reason as filter_reason_oms, export_articles_oms.price_EK as price_oms, IF(t1.attr1=3,t1.price_EK,'') as price_tre, IF(t1.attr1=1,t1.price_EK,'') as price_ost FROM (
      SELECT * FROM export_articles_ost
      UNION
      SELECT * FROM export_articles_ost_filtered
      UNION
      SELECT * FROM export_articles_tre
      UNION
      SELECT * FROM export_articles_tre_filtered
  ) as t1
  LEFT JOIN export_articles_oms ON t1.ordernumber = export_articles_oms.ordernumber AND t1.attr1 = export_articles_oms.attr1
  LEFT JOIN export_articles_oms_filtered ON t1.ordernumber = export_articles_oms_filtered.ordernumber AND t1.attr1 = export_articles_oms_filtered.attr1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: t1.ordernumber
 attr1:
    Source: t1.attr1
    Field_Adapter:
      - replace: [';', '']
 shipping_oms_filtered:
   Source: attr8_oms_filtered
 shipping_oms:
   Source: attr8_oms
   File_Field_Adapter:
     File: export_lists_export_data.shipping_oms
 shipping_ost:
   Source: t1.attr8
   File_Field_Adapter:
     File: export_lists_export_data.shipping_ost
 shipping_tre:
   Source: t1.attr8
   File_Field_Adapter:
     File: export_lists_export_data.shipping_tre
 price_ost:
   Source: price_ost
 price_tre:
   Source: price_tre
 price_oms:
   Source: price_oms
 filter_reason:
   Source: t1.filter_reason
 filter_reason_oms:
   Source: export_articles_oms_filtered.filter_reason_oms


#Target
Datapool: export_lists_export_data #sql table
Primary_Key: [ordernumber, attr1]

Metadata

Erkannte Konfiguration

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

Source_Config exportEngine
Target_Config exportEngine
Mysql_Engine InnoDB
Default_Charset utf8
Source_Datapool export_articles_tre
Datapool_Definition { "ordernumber": "VARCHAR(20) NOT NULL", "attr1": "VARCHAR(10) NOT NULL", "shipping_oms": "VARCHAR(255) DEFAULT NULL", "shipping_oms_filtered": "VARCHAR(255) DEFAULT NULL", "shipping_ost": "VARCHAR(255) DEFAULT NULL", "shipping_tre": "VARCHAR(255) DEFAULT NULL", "price_ost": "VARCHAR(255) DEFAULT NULL", "price_tre": "VARCHAR(255) DEFAULT NULL", "price_oms": "VARCHAR(255) DEFAULT NULL", "filter_reason": "VARCHAR(255) DEFAULT NULL", "filter_reason_oms": "VARCHAR(255) DEFAULT NULL" }
Sql SELECT t1.*, export_articles_oms.attr8 as attr8_oms, export_articles_oms_filtered.attr8 as attr8_oms_filtered, export_articles_oms_filtered.filter_reason as filter_reason_oms, export_articles_oms.price_EK as price_oms, IF(t1.attr1=3,t1.price_EK,'') as price_tre, IF(t1.attr1=1,t1.price_EK,'') as price_ost FROM ( SELECT * FROM export_articles_ost UNION SELECT * FROM export_articles_ost_filtered UNION SELECT * FROM export_articles_tre UNION SELECT * FROM export_articles_tre_filtered ) as t1 LEFT JOIN export_articles_oms ON t1.ordernumber = export_articles_oms.ordernumber AND t1.attr1 = export_articles_oms.attr1 LEFT JOIN export_articles_oms_filtered ON t1.ordernumber = export_articles_oms_filtered.ordernumber AND t1.attr1 = export_articles_oms_filtered.attr1
Mapping { "ordernumber": { "Source": "t1.ordernumber" }, "attr1": { "Source": "t1.attr1", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "shipping_oms_filtered": { "Source": "attr8_oms_filtered" }, "shipping_oms": { "Source": "attr8_oms", "File_Field_Adapter": { "File": "export_lists_export_data.shipping_oms" } }, "shipping_ost": { "Source": "t1.attr8", "File_Field_Adapter": { "File": "export_lists_export_data.shipping_ost" } }, "shipping_tre": { "Source": "t1.attr8", "File_Field_Adapter": { "File": "export_lists_export_data.shipping_tre" } }, "price_ost": { "Source": "price_ost" }, "price_tre": { "Source": "price_tre" }, "price_oms": { "Source": "price_oms" }, "filter_reason": { "Source": "t1.filter_reason" }, "filter_reason_oms": { "Source": "export_articles_oms_filtered.filter_reason_oms" } }
Datapool export_lists_export_data
Primary_Key [ "ordernumber", "attr1" ]