Engine / Editor
export_list_articles_all_new
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 Add_Indices: - Add_Index: Datapool: articles_new Index_Name: idx_ordernumber_attr1 Fields: ordernumber, attr1 - Add_Index: Datapool: articles_new_filtered Index_Name: idx_ordernumber_attr1 Fields: ordernumber, attr1 - Add_Index: Datapool: export_lists_export_data Index_Name: idx_ordernumber_attr1 Fields: ordernumber, attr1 - Add_Index: Datapool: iwm_articles_properties Index_Name: idx_ordernumber_firma Fields: ordernumber, firma #Source Source_Datapool: export_articles_tre_filtered #sql from Datapool_Definition: Artikelnummer: VARCHAR(255) NOT NULL Deaktivierungsgrund: VARCHAR(500) DEFAULt NULL Deaktivierungsgrund_OMS: VARCHAR(500) DEFAULt NULL Name: VARCHAR(255) NOT NULL Lieferant: VARCHAR(255) NOT NULL Lieferantennummer: 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 Preis_Ost: VARCHAR(255) DEFAULT NULL Preis_Tre: VARCHAR(255) DEFAULT NULL Preis_Oms: VARCHAR(255) DEFAULT NULL Versandkosten_Ost: VARCHAR(255) DEFAULT NULL Versandkosten_Tre: VARCHAR(255) DEFAULT NULL Versandkosten_Oms: VARCHAR(255) DEFAULT NULL Montagekosten: VARCHAR(255) DEFAULT NULL # Versandkosten_Ost_old: VARCHAR(255) DEFAULT NULL # Versandkosten_Tre_old: VARCHAR(255) DEFAULT NULL # Versandkosten_Oms_old: VARCHAR(255) DEFAULT NULL Bestand: VARCHAR(255) DEFAULT NULL Bestellsperre: VARCHAR(255) DEFAULT NULL Bestand_Witten: VARCHAR(255) DEFAULT NULL Mindestbestand_Witten: VARCHAR(255) DEFAULT NULL Kojen: TEXT DEFAULT NULL Status: VARCHAR(255) DEFAULT NULL Versandart: VARCHAR(255) DEFAULT NULL Online: VARCHAR(255) DEFAULT NULL Stil: VARCHAR(100) DEFAULT NULL # Besonderheit: VARCHAR(10) DEFAULT NULL Farbe: VARCHAR(50) DEFAULT NULL Zeltgut: VARCHAR(10) DEFAULT NULL Direktversand_Crossdock: VARCHAR(10) DEFAULT NULL Sql: SELECT enhanced_data.*, enhanced_data.filter_reason as fr, export_lists_export_data.shipping_tre, export_lists_export_data.shipping_ost, export_lists_export_data.shipping_oms, enhanced_data.attr37 as attr37, iwm_articles_properties.stil, iwm_articles_properties.farbe, export_lists_export_data.filter_reason as eled_fr, export_lists_export_data.filter_reason_oms as eled_fro, export_lists_export_data.price_ost, export_lists_export_data.price_tre, export_lists_export_data.price_oms, enhanced_data.anlieferart FROM ( SELECT * FROM dg_supplierdata_enhanced.articles_new UNION SELECT * FROM dg_supplierdata_enhanced.articles_new_filtered ) as enhanced_data LEFT JOIN export_lists_export_data ON enhanced_data.ordernumber = export_lists_export_data.ordernumber AND enhanced_data.attr1 = export_lists_export_data.attr1 LEFT JOIN dg_supplierdata_enhanced.iwm_articles_properties ON enhanced_data.ordernumber = iwm_articles_properties.ordernumber AND enhanced_data.attr1 = iwm_articles_properties.firma WHERE enhanced_data.ordernumber is not null #Sql: SELECT ed.ordernumber AS Artikelnummer,ed.filter_reason AS fr,eled.filter_reason AS eled_fr,eled.filter_reason_oms AS eled_fro,ed.name_ost,ed.supplier_ost,ed.suppliernumber,ed.ean,ed.attr1,ed.attr2,ed.attr3,ed.attr4,ed.attr9,ed.attr11,ed.attr12,eled.price_ost,eled.price_tre,eled.price_oms,eled.shipping_ost,eled.shipping_tre,eled.shipping_oms,ed.attr16,ed.instock,ed.bestellsperre,ed.stock_witten,ed.swag_attr21,ed.ahstat,ed.attr13,ed.zeltgut,ed.anlieferart,ap.stil,ap.farbe FROM (SELECT ordernumber,filter_reason,name_ost,supplier_ost,suppliernumber,ean,attr1,attr2,attr3,attr4,attr9,attr11,attr12,attr16,instock,bestellsperre,stock_witten,swag_attr21,ahstat,attr13,zeltgut,anlieferart FROM dg_supplierdata_enhanced.articles_new WHERE ordernumber IS NOT NULL UNION ALL SELECT ordernumber,filter_reason,name_ost,supplier_ost,suppliernumber,ean,attr1,attr2,attr3,attr4,attr9,attr11,attr12,attr16,instock,bestellsperre,stock_witten,swag_attr21,ahstat,attr13,zeltgut,anlieferart FROM dg_supplierdata_enhanced.articles_new_filtered WHERE ordernumber IS NOT NULL) AS ed LEFT JOIN export_lists_export_data AS eled ON eled.ordernumber=ed.ordernumber AND eled.attr1=ed.attr1 LEFT JOIN dg_supplierdata_enhanced.iwm_articles_properties AS ap ON ap.ordernumber=ed.ordernumber AND ap.firma=ed.attr1 Mapping: Artikelnummer: Source: enhanced_data.ordernumber filter_reason_enhanced: Source: enhanced_data.fr In_Export: no filter_reason_export: Source: export_lists_export_data.eled_fr In_Export: no filter_reason_export_oms: Source: export_lists_export_data.eled_fro In_Export: no Deaktivierungsgrund: Source: enhanced_data.ordernumber File_Field_Adapter: File: export_list_articles_all_new.Deaktivierungsgrund Deaktivierungsgrund_OMS: Source: enhanced_data.ordernumber File_Field_Adapter: File: export_list_articles_all_new.Deaktivierungsgrund_OMS Name: enhanced_data.name_ost Lieferant: Source: enhanced_data.supplier_ost Lieferantennummer: Source: enhanced_data.suppliernumber EAN: enhanced_data.ean attr1: Source: enhanced_data.attr1 attr2: Source: enhanced_data.attr2 attr3: Source: enhanced_data.attr3 attr4: Source: enhanced_data.attr4 attr9: Source: enhanced_data.attr9 attr11: Source: enhanced_data.attr11 attr12: Source: enhanced_data.attr12 Preis_Ost: Source: price_ost Preis_Tre: Source: price_tre Preis_Oms: Source: price_oms Versandkosten_Ost: Source: export_lists_export_data.shipping_ost Field_Adapter: - replace: [ '.',',' ] Versandkosten_Tre: Source: export_lists_export_data.shipping_tre Field_Adapter: - replace: [ '.',',' ] Versandkosten_Oms: Source: export_lists_export_data.shipping_oms Field_Adapter: - replace: [ '.',',' ] Montagekosten: Source: enhanced_data.attr16 # Versandkosten_Ost_old: # Source: enhanced_data.shipping_ost # Versandkosten_Tre_old: # Source: enhanced_data.shipping_tre # Versandkosten_Oms_old: # Source: enhanced_data.shipping_oms # Field_Adapter: # - replace: [ '.',',' ] Bestand: Source: enhanced_data.instock Bestellsperre: Source: enhanced_data.bestellsperre Bestand_Witten: Source: enhanced_data.stock_witten Mindestbestand_Witten: Source: enhanced_data.stock_witten File_Field_Adapter: File: export_list_articles_all_new.min_stock_witten Kojen: Source: enhanced_data.swag_attr21 Status: Source: enhanced_data.ahstat Versandart: Source: enhanced_data.attr13 Online: Source: filter_reason File_Field_Adapter: File: export_list_articles_all_new.Online # Field_Adapter: # - replace_empty_else: ['ja','nein'] Stil: Source: iwm_articles_properties.stil # Besonderheit: # Source: iwm_articles_properties.Besonderheit Farbe: Source: iwm_articles_properties.farbe Zeltgut: Source: enhanced_data.zeltgut Direktversand_Crossdock: Source: enhanced_data.anlieferart Field_Adapter: - replace_empty: 'L' - replace_not_equals: ['D','L'] #Target Datapool: export_list_articles_all_new #sql table Primary_Key: [Artikelnummer, attr1]
Definition aktualisieren