Engine / Editor
export_list_articles_inhouse_all
Mandant default
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
export
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#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 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.price_ost, articles_new.price_tre, articles_new.price_oms 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_inhouse UNION SELECT * FROM export_list_articles_inactive_channel_ost_inhouse UNION SELECT * FROM export_list_articles_active_channel_tre_inhouse UNION SELECT * FROM export_list_articles_inactive_channel_tre_inhouse 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: t1.price_oms price_tre: Source: IF (export_list_articles_active_channel_tre_inhouse.price_tre is null, IF (export_list_articles_inactive_channel_tre_inhouse.price_tre is null, export_list_articles_inactive_general.price_tre, export_list_articles_inactive_channel_tre_inhouse.price_tre), export_list_articles_active_channel_tre_inhouse.price_tre) as 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 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_inhouse_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_inhouse_all #sql table Primary_Key: [ordernumber, attr1, Deaktivierungsgrund]
Definition aktualisieren