Engine / Editor
export_articles_oms_beny
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: enhanceEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service #Source Source_Datapool: articles_new #sql from Mysql_Engine: InnoDB Default_Charset: latin1 Joins: - Left_Join: #each condition is joined with "AND" Datapool: dg_supplierdata_export.export_articles_oms Join_Condition: articles_new.ordernumber = export_articles_oms.ordernumber # One row per JOIN - Left_Join: Datapool: dg_supplierdata_export.export_iwm_articles_prices_oms Join_Condition: articles_new.ordernumber = export_iwm_articles_prices_oms.ordernumber Read_Conditions: #sql where - Read-Filter - (articles_new.active_oms = 1 or articles_new.active_ost = 1 or articles_new.active_tre = 1) - NOT (articles_new.attr2 = '92' AND articles_new.attr3 = '31') - NOT (articles_new.attr2 = '92' AND articles_new.attr3 = '36') - export_iwm_articles_prices_oms.price_EK > 10 - articles_new.ean != '' # - articles_new.attr4 != '99' Datapool_Definition: id: VARCHAR(255) NOT NULL ean: VARCHAR(255) DEFAULT NULL id_on_marketplace: VARCHAR(255) DEFAULT NULL category: VARCHAR(255) DEFAULT NULL mpn: VARCHAR(255) DEFAULT NULL manufacturer: VARCHAR(255) DEFAULT NULL model: VARCHAR(255) DEFAULT NULL name_on_marketplace: VARCHAR(255) DEFAULT NULL min_price: VARCHAR(255) DEFAULT NULL max_price: VARCHAR(255) DEFAULT NULL article_condition: VARCHAR(255) DEFAULT NULL deep_link: VARCHAR(255) DEFAULT NULL shipping_cost: VARCHAR(255) DEFAULT NULL current_price: VARCHAR(255) DEFAULT NULL #Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: Source: articles_new.ordernumber In_Export: no firma: Source: articles_new.attr1 In_Export: no id: Source: articles_new.ordernumber File_Field_Adapter: File: export_articles_oms_beny.id ean: articles_new.ean id_on_marketplace: () #??? category: articles_new.categoryPath_oms mpn: articles_new.attr9 manufacturer: Source: articles_new.supplier_oms Cross_Field_Adapters: - Cross_Field_Adapter: Config: importEngine Cross_Datapool: iwm_lieferanten_articles #name of cross datapool Cross_Field: LIEFERANTENNAME #field to select value from in cross datapool Mapping: #cross field adapter with more than one key ordernumber: ORDERNUMBER Options: keep_existing: true # Cross_Field_Adapter: # Config: importEngine # Cross_Datapool: iwm_lieferanten_articles #name of cross datapool # Cross_Field: LIEFERANTENNAME #field to select value from in cross datapool # Local_Key: ordernumber #key for where condition from datapool # Cross_Key: ORDERNUMBER #key for where condition from cross datapool model: articles_new.attr9 name_on_marketplace: articles_new.name_oms min_price: (000) max_price: (999900) article_condition: (new) deep_link: () #???? shipping_cost: Source: export_articles_oms.attr8 Field_Adapter: - replace: [',',''] - replace: ['.',''] current_price: Source: export_iwm_articles_prices_oms.price_EK Field_Adapter: - replace: [',',''] - replace: ['.',''] Filters: - Filter: name: DuplicateId #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: export_articles_oms_beny__filterByDuplicateId reason: 'There is another dataset with this id' - Filter: name: Filter articles that are not in main feed condition: Not_In_Pool_Filter_Adapter: Config: exportEngine Datapool: export_articles_oms Local_Key: ordernumber Cross_Key: ordernumber reason: 'Filter articles that are not in main shop export' # Mapping: #left is from current datapool, right from filter datapool # id: ordernumber #Target Datapool: export_articles_oms_beny #sql table Primary_Key: [id]
Definition aktualisieren