Engine / Editor
export_articles_plenty-tre
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_Fields: [ordernumber, mainnumber, name_oms, tax, price_oms, pseudoprice_oms, baseprice, active_oms, description, description_long_oms, unitID, ean, categories, referenceUnit, purchaseUnit] #sql select Source_Datapool: articles #sql from Joins: - Left_Join: #each condition is joined with "AND" Datapool: iwm_articles_stock Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma # One row per JOIN - Left_Join: Datapool: iwm_properties Join_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma Read_Conditions: #sql where - Read-Filter - articles.attr1 = 1 AND articles.active_tre = 1 #Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: articles.ordernumber mainnumber: Source: articles.mainnumber Field_Adapter: - replace: ['-1', ''] name_ost: Source: articles.name_ost Field_Adapter: - addslashes name_tre: Source: articles.name_tre Field_Adapter: - addslashes name_oms: Source: articles.name_oms Field_Adapter: - addslashes name_bil: Source: articles.name_bil Field_Adapter: - addslashes supplier_ost: Source: articles.name_bil Field_Adapter: - addslashes supplier_tre: Source: articles.name_bil Field_Adapter: - addslashes supplier_oms: Source: articles.name_bil Field_Adapter: - addslashes supplier_bil: Source: articles.name_bil Field_Adapter: - addslashes tax: articles.tax kind: articles.kind price_ost: articles.price_ost price_tre: articles.price_tre price_oms: articles.price_oms price_bil: articles.price_bil pseudoprice_ost: articles.pseudoprice_ost pseudoprice_tre: articles.pseudoprice_tre pseudoprice_oms: articles.pseudoprice_oms pseudoprice_bil: articles.pseudoprice_bil active_ost: articles.active_ost active_tre: articles.active_tre active_oms: articles.active_oms active_bil: articles.active_bil categoryPath_ost: Source: articles.categoryPath_ost Field_Adapter: - addslashes categoryPath_tre: Source: articles.categoryPath_tre Field_Adapter: - addslashes categoryPath_oms: Source: articles.categoryPath_oms Field_Adapter: - addslashes categoryPath_bil: Source: articles.categoryPath_bil Field_Adapter: - addslashes configuratorOptions: articles.configuratorOptions description_long_ost: Source: articles.description_long_ost Field_Adapter: - addslashes description_long_tre: Source: articles.description_long_tre Field_Adapter: - addslashes description_long_oms: Source: articles.description_long_oms Field_Adapter: - addslashes description_long_bil: Source: articles.description_long_bil Field_Adapter: - addslashes attr1: articles.attr1 attr2: articles.attr2 attr3: articles.attr3 attr4: articles.attr4 attr5: articles.attr5 attr6: articles.attr6 attr7: articles.attr7 attr8: articles.attr8 attr9: articles.attr9 attr10: articles.attr10 attr11: articles.attr11 attr12: articles.attr12 attr13: articles.attr13 attr14: articles.attr14 attr15: articles.attr15 attr16: articles.attr16 attr17: articles.attr17 attr18: articles.attr18 attr19: articles.attr19 attr20: articles.attr20 swag_attr21: articles.swag_attr21 swag_attr22: articles.swag_attr22 Source: articles.swag_attr22 Field_Adapter: - addslashes swag_attr23: articles.swag_attr23 swag_attr24: articles.swag_attr24 swag_attr25: articles.swag_attr25 swag_attr26: articles.swag_attr26 swag_attr27: articles.swag_attr27 swag_attr28: articles.swag_attr28 swag_attr29: articles.swag_attr29 swag_attr30: articles.swag_attr30 ean: articles.ean imageUrl: articles.imageUrl stock_witten: iwm_articles_stocks.witten propertyValueName: Cross_Field_Adapter: #cross field adapter leads to sub select -> iwm_properties is not in join Cross_Datapool: iwm_properties Cross_Field: propertyValueName Cross_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma #not needed for refereced tables Field_Adapter: - replace: ['|',':de;'] weight: Source: articles.weight Field_Adapter: - replace: ['.00', ''] - replace: [',', ''] - simple_division: 1000 listingID: articles.listingID Source: articles.ordernumber Field_Adapter: - replace: ['-', '00'] ebay_active: (1) plenty_cat_id: Source: (0) File_Field_Adapter: Datapool: plenty_cat_ids #The data of this datapool is injected in the function to have access via stmt Fields: [plenty_cat_id, Level1, Level2] #Target Target_Datapool: export_articles_plenty_tre #sql table Filters: - Filter: name: filter_plenty_tre_suppliers condition: supplier_tre = PAIDI or supplier_tre = weber or supplier_tre = vito or supplier_tre = MONDO or supplier_tre = VALMONDO or supplier_tre = LIV´IN or supplier_tre = SELF or supplier_tre = KETTLER or supplier_tre = hülsta or supplier_tre = Kollektion-Wiedemann or supplier_tre = ROLF BENZ output: positive reason: 'excluded supplier' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 60 output: positive reason: 'bad calculation' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 60 output: positive reason: 'bad calculation' - Filter: name: 'Preis ungueltig' condition: (price_tre == '0') or (price_tre == '') or (price_tre == '0.00') or (price_tre == '0,00') or (price_tre == '0,0') reason: 'alle Preise = 0'
Definition aktualisieren