Engine / Editor
export_list_articles_all_for_ametr_export
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 Produktname: VARCHAR(255) DEFAULT NULL supplier: VARCHAR(255) NOT NULL supplier_number: VARCHAR(255) NOT NULL ean: VARCHAR(255) DEFAULT 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 swag_attr23: 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 pil_needed: VARCHAR(10) DEFAULT NULL eek_needed: VARCHAR(10) DEFAULT NULL textilkennzeichen_needed: VARCHAR(10) DEFAULT NULL Sql: SELECT t4.* FROM ( SELECT t3.*, articles_new_filtered.swag_attr23 as swag_attr23_an, articles_new_filtered.pil_needed as pil_needed_an, articles_new_filtered.textilkennzeichen_needed as textilkennzeichen_needed_an, articles_new_filtered.enev_active as eek_needed_an FROM ( SELECT t2.*, articles_new.swag_attr23, articles_new.stock_witten as stock_w, articles_new.shipping_ost, articles_new.shipping_tre, articles_new.shipping_oms, articles_new.price_ost as price_o, articles_new.price_tre as price_t, articles_new.price_oms as price_moebels, articles_new.pil_needed, articles_new.textilkennzeichen_needed, articles_new.enev_active as eek_needed 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 ) as t3 LEFT JOIN dg_supplierdata_enhanced.articles_new_filtered ON t3.ordernumber = articles_new_filtered.ordernumber AND t3.attr1 = articles_new_filtered.attr1) as t4 Mapping: ordernumber: Source: t4.ordernumber Deaktivierungsgrund: Source: t4.Deaktivierungsgrund name: IF (TRIM(t2.name) IS NULL, t2.name_ost, t2.name) as name Produktname: Source: t2.name File_Field_Adapter: File: export_list_articles_all_for_ametr_export.Produktname supplier: Source: t4.supplier supplier_number: Source: t4.supplier_number ean: IF (t2.ean IS null, t1.ean, t2.ean) as ean attr2: Source: t4.attr2 attr3: Source: t4.attr3 attr4: Source: t4.attr4 attr9: Source: t4.attr9 attr11: Source: t4.attr11 attr12: Source: t4.attr12 swag_attr23: Source: IF (t4.swag_attr23_an IS NULL, t4.swag_attr23, t4.swag_attr23_an) as swag_attr23 price_ost: Source: IF (export_list_articles_active_channel_tre.price_ost is null, IF (export_list_articles_inactive_channel_tre.price_ost is null, export_list_articles_inactive_general.price_ost, export_list_articles_inactive_channel_ost.price_ost), export_list_articles_active_channel_ost.price_ost) as price_ost price_tre: Source: IF (export_list_articles_active_channel_tre.price_tre is null, IF (export_list_articles_inactive_channel_tre.price_tre is null, export_list_articles_inactive_general.price_tre, export_list_articles_inactive_channel_tre.price_tre), export_list_articles_active_channel_tre.price_tre) as price_tre price_oms: Source: IF (export_list_articles_active_channel_tre.price_oms is null, IF (export_list_articles_inactive_channel_tre.price_oms is null, export_list_articles_inactive_general.price_oms, export_list_articles_inactive_channel_tre.price_oms), export_list_articles_active_channel_oms.price_oms) as price_oms shipping_ost: Source: t4.shipping_ost shipping_tre: Source: t4.shipping_tre shipping_oms: Source: t4.shipping_oms stock: Source: t4.stock bestellsperre: Source: t4.bestellsperre stock_witten: Source: IF (articles_new.stock_w IS NULL, t2.stock_witten, articles_new.stock_w) as stock_witten min_stock_witten: Source: t4.stock_witten File_Field_Adapter: File: export_list_articles_all_for_ametr_export.min_stock_witten kojen: Source: t4.attr21 ahstat: Source: t4.ahstat versandart: Source: t4.attr13 online: Source: t4.Deaktivierungsgrund Field_Adapter: - replace_empty_else: ['ja','nein'] zeltgut: Source: zeltgut pil_needed: IF (TRIM(t2.pil_needed) IS NULL, t3.pil_needed, t2.pil_needed) as pil_needed eek_needed: IF (TRIM(t2.eek_needed) IS NULL, t3.eek_needed, t2.eek_needed) as eek_needed textilkennzeichen_needed: IF (TRIM(t2.textilkennzeichen_needed) IS NULL, t3.textilkennzeichen_needed, t2.textilkennzeichen_needed) as textilkennzeichen_needed #Target Datapool: export_list_articles_all_for_ametr_export #sql table Primary_Key: [ordernumber]
Definition aktualisieren