Engine / Editor
export_quick_delivery_oms
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 Target_Config: exportEngine #Source Source_Datapool: export_iwm_tracking_oms Joins: - Left_Join: Datapool: export_iwm_orders_oms Join_Condition: export_iwm_tracking_oms.auftragsnummer = export_iwm_orders_oms.Auftragsnummer - Join: Datapool: mail_addresses_all Join_Condition: export_iwm_orders_oms.Kundennummer = mail_addresses_all.Kundennummer Read_Condition_Vars: - date = date("d.m.Y", strtotime('-0 days')) Read_Conditions: - (export_iwm_tracking_oms.verkaufshaus = 86) or (export_iwm_tracking_oms.verkaufshaus = 87) - export_iwm_tracking_oms.versanddatum = %date% Mysql_Engine: InnoDB Default_Charset: utf8 Datapool_Definition: Bestellnummer: VARCHAR(50) NOT NULL Vorname: VARCHAR(25) DEFAULT NULL Name: VARCHAR(25) DEFAULT NULL email: VARCHAR(50) DEFAULT NULL Mapping_Vars: shop: 'oms' Mapping: Include_Mapping_quick_delivery: quick_delivery Filters: - Filter: name: Delivery not within 3 days condition: Cross_Dataset_Filter_Adapter: export_orders_quick_delivery__filterSlowDelivery reason: 'Delivery not within 3 days' - Filter: name: DuplicateIdentifierBestellnummer #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: filterByDuplicateIdentifierBestellnummer reason: 'There is another dataset' - Filter: name: 'Name empty' condition: (Name == '') reason: 'Name empty' - Filter: name: MarketplaceOrders #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: filterMarketplaceOrders reason: 'There is another dataset' #Target Datapool: 'export_orders_quick_delivery_oms' Primary_Key: [Bestellnummer]
Definition aktualisieren