Engine / Editor
export_articles_oms_priceshape
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 Mysql_Engine: InnoDB Default_Charset: latin1 #Source Source_Datapool: articles_new #sql from Joins: - Left_Join: Datapool: shopware_article_info Join_Condition: articles_new.ordernumber = shopware_article_info.ordernumber AND shopware_article_info.shop = 'oms' Datapool_Definition: Artikelnr: VARCHAR(255) NOT NULL Bezeichnung: VARCHAR(255) DEFAULT NULL Produktart: VARCHAR(255) DEFAULT NULL Shoppreis: VARCHAR(255) DEFAULT NULL Versandkosten: VARCHAR(255) DEFAULT NULL Marke: VARCHAR(255) DEFAULT NULL EAN: VARCHAR(255) DEFAULT NULL MPN: VARCHAR(255) DEFAULT NULL Bild_URL_bild1: TEXT DEFAULT NULL Lagerbestand_gesamt: VARCHAR(255) DEFAULT NULL ProduktURL: TEXT DEFAULT NULL #Mapping -> Mappings source fields are detected by Mapping Mapping: Artikelnr: Source: articles_new.ordernumber firma: Source: articles_new.attr1 In_Export: no Bezeichnung: articles_new.name_ost Produktart: articles_new.swag_attr27 Shoppreis: Source: articles_new.price_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool Cross_Field: price_EK #field to select value from in cross datapool Local_Key: Artikelnr #key for where condition from datapool Cross_Key: ordernumber #key for where condition from cross datapool Versandkosten: VARCHAR(255) DEFAULT NULL Marke: 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 EAN: articles_new.ean MPN: articles_new.attr9 Bild_URL_bild1: Source: articles_new.imageUrl File_Field_Adapter: File: export_articles.bild1 Lagerbestand_gesamt: articles_new.instock ProduktURL: Source: shopware_article_info.link Field_Adapter: - replace: [ '"', '' ] - replace: [ 'sPartner=Channelpilot%22&number=%22', 'number=' ] - replace: [ 'sPartner=Channelpilot&number=', 'number=' ] Filters: - Filter: name: DuplicateArtikelnr #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: filterByDuplicateArtikelnr reason: 'There is another dataset with this ordernumber' - Filter: name: not_in_oms_online_export condition: In_Pool_Filter_Adapter: Config: exportEngine Datapool: export_articles_oms Local_Key: ordernumber Cross_Key: ordernumber reason: 'not in oms online export' #Target Datapool: export_articles_oms_priceshape #sql table Primary_Key: [Artikelnr]
Definition aktualisieren