Legacy YAML export_list_articles_all

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_list_articles_all 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_filtered  #sql from

Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    Deaktivierungsgrund: VARCHAR(500) NOT NULL
    name: VARCHAR(255) NOT NULL
    supplier: VARCHAR(255) NOT NULL
    supplier_number: VARCHAR(255) NOT NULL
    ean: VARCHAR(255) DEFAULT NULL
    attr1: VARCHAR(255) NOT NULL
    attr2: VARCHAR(255) DEFAULT NULL
    attr3: VARCHAR(255) DEFAULT NULL
    attr4: VARCHAR(255) DEFAULT NULL
    attr9: VARCHAR(255) DEFAULT NULL
    attr11: VARCHAR(255) DEFAULT NULL
    attr12: VARCHAR(255) DEFAULT NULL
    price_ost: VARCHAR(255) DEFAULT NULL
    price_tre: VARCHAR(255) DEFAULT NULL
    price_oms: VARCHAR(255) DEFAULT NULL
    shipping_ost: VARCHAR(255) DEFAULT NULL
    shipping_tre: VARCHAR(255) DEFAULT NULL
    shipping_oms: VARCHAR(255) DEFAULT NULL
    shipping_ost_new: VARCHAR(255) DEFAULT NULL
    shipping_tre_new: VARCHAR(255) DEFAULT NULL
    shipping_oms_new: VARCHAR(255) DEFAULT NULL
    stock: VARCHAR(255) DEFAULT NULL
    bestellsperre: VARCHAR(255) DEFAULT NULL
    stock_witten: VARCHAR(255) DEFAULT NULL
    min_stock_witten: VARCHAR(255) DEFAULT NULL
    kojen: TEXT DEFAULT NULL
    ahstat: VARCHAR(255) DEFAULT NULL
    versandart: VARCHAR(255) DEFAULT NULL
    online: VARCHAR(255) DEFAULT NULL
    zeltgut: VARCHAR(10) DEFAULT NULL

Sql:  SELECT t2.*, articles_new.stock_witten, articles_new.shipping_ost, articles_new.shipping_tre, articles_new.shipping_oms, articles_new.attr37 FROM (
      SELECT t1.*, iwm_articles_new.name_ost, iwm_articles_new.stock_witten, iwm_articles_new.attr9, iwm_articles_new.swag_attr21, iwm_articles_new.ahstat, iwm_articles_new.attr13, iwm_articles_new.zeltgut FROM (
      SELECT * FROM export_list_articles_active_channel_ost
      UNION
      SELECT * FROM export_list_articles_inactive_channel_ost
      UNION
      SELECT * FROM export_list_articles_active_channel_tre
      UNION
      SELECT * FROM export_list_articles_inactive_channel_tre
      UNION
      SELECT * FROM export_list_articles_inactive_general
      ) as t1
      LEFT JOIN dg_supplierdata_unitized.iwm_articles_new ON t1.ordernumber = iwm_articles_new.ordernumber AND t1.attr1 = iwm_articles_new.attr1 ) as t2
      LEFT JOIN dg_supplierdata_enhanced.articles_new ON t2.ordernumber = articles_new.ordernumber AND t2.attr1 = articles_new.attr1


Mapping:
 ordernumber:
   Source: t2.ordernumber
 Deaktivierungsgrund:
   Source: t2.Deaktivierungsgrund
 name: IF (TRIM(t2.name) = '', t2.name_ost, t2.name) as name
 supplier:
   Source: t2.supplier
 supplier_number:
   Source: t2.supplier_number
 ean: IF (t2.ean IS null, t1.ean, t2.ean) as ean
 attr1:
   Source: t2.attr1
 attr2:
   Source: t2.attr2
 attr3:
   Source: t2.attr3
 attr4:
   Source: t2.attr4
 attr9:
   Source: t2.attr9
 attr11:
   Source: t2.attr11
 attr12:
   Source: t2.attr12
 price_ost:
   Source: price_ost
 price_tre:
   Source: price_tre
 price_oms:
   Source: t1.price_oms
 shipping_ost:
   Source: articles_new.shipping_ost
 shipping_tre:
   Source: articles_new.shipping_tre
 shipping_oms:
   Source: articles_new.shipping_oms
 shipping_ost_new:
   Source: articles_new.attr37
   Field_Adapter:
     - getFromJsonField: 'ost'
 shipping_tre_new:
   Source: articles_new.attr37
   Field_Adapter:
     - getFromJsonField: 'tre'
 shipping_oms_new:
   Source: articles_new.attr37
   Field_Adapter:
     - getFromJsonField: 'oms'
 stock:
   Source: t2.stock
 bestellsperre:
   Source: bestellsperre
 stock_witten:
   Source: IF (articles_new.stock_witten = '', t2.stock_witten, articles_new.stock_witten) as stock_witten
 min_stock_witten:
   Source: t2.stock_witten
   File_Field_Adapter:
     File: export_list_articles_all.min_stock_witten
 kojen:
   Source: t2.attr21
 ahstat:
   Source: t2.ahstat
 versandart:
   Source: t2.attr13
 online:
   Source: t2.Deaktivierungsgrund
   Field_Adapter:
     - replace_empty_else: ['ja','nein']
 zeltgut:
   Source: zeltgut

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

Source

Datei und Status

Dateipfad: /srv/app/backend/export/exportEngines/export_list_articles_all.yaml
Runner: export
Feature Flags: Datapool_Definition, Field_Adapter, File_Field_Adapter, Mapping
Connections: exportEngine

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_filtered
Datapool_Definition	{ "ordernumber": "VARCHAR(255) NOT NULL", "Deaktivierungsgrund": "VARCHAR(500) NOT NULL", "name": "VARCHAR(255) NOT NULL", "supplier": "VARCHAR(255) NOT NULL", "supplier_number": "VARCHAR(255) NOT NULL", "ean": "VARCHAR(255) DEFAULT NULL", "attr1": "VARCHAR(255) NOT NULL", "attr2": "VARCHAR(255) DEFAULT NULL", "attr3": "VARCHAR(255) DEFAULT NULL", "attr4": "VARCHAR(255) DEFAULT NULL", "attr9": "VARCHAR(255) DEFAULT NULL", "attr11": "VARCHAR(255) DEFAULT NULL", "attr12": "VARCHAR(255) DEFAULT NULL", "price_ost": "VARCHAR(255) DEFAULT NULL", "price_tre": "VARCHAR(255) DEFAULT NULL", "price_oms": "VARCHAR(255) DEFAULT NULL", "shipping_ost": "VARCHAR(255) DEFAULT NULL", "shipping_tre": "VARCHAR(255) DEFAULT NULL", "shipping_oms": "VARCHAR(255) DEFAULT NULL", "shipping_ost_new": "VARCHAR(255) DEFAULT NULL", "shipping_tre_new": "VARCHAR(255) DEFAULT NULL", "shipping_oms_new": "VARCHAR(255) DEFAULT NULL", "stock": "VARCHAR(255) DEFAULT NULL", "bestellsperre": "VARCHAR(255) DEFAULT NULL", "stock_witten": "VARCHAR(255) DEFAULT NULL", "min_stock_witten": "VARCHAR(255) DEFAULT NULL", "kojen": "TEXT DEFAULT NULL", "ahstat": "VARCHAR(255) DEFAULT NULL", "versandart": "VARCHAR(255) DEFAULT NULL", "online": "VARCHAR(255) DEFAULT NULL", "zeltgut": "VARCHAR(10) DEFAULT NULL" }
Sql	SELECT t2., articles_new.stock_witten, articles_new.shipping_ost, articles_new.shipping_tre, articles_new.shipping_oms, articles_new.attr37 FROM ( SELECT t1., iwm_articles_new.name_ost, iwm_articles_new.stock_witten, iwm_articles_new.attr9, iwm_articles_new.swag_attr21, iwm_articles_new.ahstat, iwm_articles_new.attr13, iwm_articles_new.zeltgut FROM ( SELECT * FROM export_list_articles_active_channel_ost UNION SELECT * FROM export_list_articles_inactive_channel_ost UNION SELECT * FROM export_list_articles_active_channel_tre UNION SELECT * FROM export_list_articles_inactive_channel_tre UNION SELECT * FROM export_list_articles_inactive_general ) as t1 LEFT JOIN dg_supplierdata_unitized.iwm_articles_new ON t1.ordernumber = iwm_articles_new.ordernumber AND t1.attr1 = iwm_articles_new.attr1 ) as t2 LEFT JOIN dg_supplierdata_enhanced.articles_new ON t2.ordernumber = articles_new.ordernumber AND t2.attr1 = articles_new.attr1
Mapping	{ "ordernumber": { "Source": "t2.ordernumber" }, "Deaktivierungsgrund": { "Source": "t2.Deaktivierungsgrund" }, "name": "IF (TRIM(t2.name) = '', t2.name_ost, t2.name) as name", "supplier": { "Source": "t2.supplier" }, "supplier_number": { "Source": "t2.supplier_number" }, "ean": "IF (t2.ean IS null, t1.ean, t2.ean) as ean", "attr1": { "Source": "t2.attr1" }, "attr2": { "Source": "t2.attr2" }, "attr3": { "Source": "t2.attr3" }, "attr4": { "Source": "t2.attr4" }, "attr9": { "Source": "t2.attr9" }, "attr11": { "Source": "t2.attr11" }, "attr12": { "Source": "t2.attr12" }, "price_ost": { "Source": "price_ost" }, "price_tre": { "Source": "price_tre" }, "price_oms": { "Source": "t1.price_oms" }, "shipping_ost": { "Source": "articles_new.shipping_ost" }, "shipping_tre": { "Source": "articles_new.shipping_tre" }, "shipping_oms": { "Source": "articles_new.shipping_oms" }, "shipping_ost_new": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "ost" } ] }, "shipping_tre_new": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "tre" } ] }, "shipping_oms_new": { "Source": "articles_new.attr37", "Field_Adapter": [ { "getFromJsonField": "oms" } ] }, "stock": { "Source": "t2.stock" }, "bestellsperre": { "Source": "bestellsperre" }, "stock_witten": { "Source": "IF (articles_new.stock_witten = '', t2.stock_witten, articles_new.stock_witten) as stock_witten" }, "min_stock_witten": { "Source": "t2.stock_witten", "File_Field_Adapter": { "File": "export_list_articles_all.min_stock_witten" } }, "kojen": { "Source": "t2.attr21" }, "ahstat": { "Source": "t2.ahstat" }, "versandart": { "Source": "t2.attr13" }, "online": { "Source": "t2.Deaktivierungsgrund", "Field_Adapter": [ { "replace_empty_else": [ "ja", "nein" ] } ] }, "zeltgut": { "Source": "zeltgut" } }
Datapool	export_list_articles_all
Primary_Key	[ "ordernumber", "attr1", "Deaktivierungsgrund" ]