Engine / Editor
export_articles_oms_google_ohne_stern
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: #each condition is joined with "AND" Datapool: moebelshop_s_articles_details Join_Condition: articles_new.ordernumber = moebelshop_s_articles_details.ordernumber - Left_Join: Datapool: iwm_articles_properties Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma #- Left_Join: # Datapool: shopware_article_info # Join_Condition: articles_new.ordernumber = shopware_article_info.ordernumber AND shopware_article_info.shop = 'oms' - Left_Join: Datapool: export_for_dataengine Join_Condition: articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'oms' Read_Conditions: #sql where - Read-Filter - articles_new.attr2 != 60 - articles_new.attr2 != 63 - articles_new.supplier_oms != 'STERN' - articles_new.attr2 = 79 Datapool_Definition: # ordernumber: VARCHAR(255) NOT NULL id: VARCHAR(255) NOT NULL title: VARCHAR(255) DEFAULT NULL description: MEDIUMTEXT DEFAULT NULL google_product_category: VARCHAR(255) DEFAULT NULL product_type: VARCHAR(255) DEFAULT NULL link: VARCHAR(400) DEFAULT NULL image_link: VARCHAR(255) DEFAULT NULL additional_image_link: TEXT DEFAULT NULL condition1: VARCHAR(255) DEFAULT NULL availability: VARCHAR(255) DEFAULT NULL price: VARCHAR(255) DEFAULT NULL sale_price: VARCHAR(255) DEFAULT NULL brand: VARCHAR(255) DEFAULT NULL gtin: VARCHAR(255) DEFAULT NULL mpn: VARCHAR(255) DEFAULT NULL ads_grouping: VARCHAR(255) DEFAULT NULL custom_label_0: VARCHAR(255) DEFAULT NULL custom_label_1: VARCHAR(255) DEFAULT NULL custom_label_2: VARCHAR(255) DEFAULT NULL custom_label_3: VARCHAR(255) DEFAULT NULL custom_label_4: VARCHAR(255) DEFAULT NULL color: VARCHAR(255) DEFAULT NULL size: VARCHAR(255) DEFAULT NULL material: VARCHAR(255) DEFAULT NULL pattern: VARCHAR(255) DEFAULT NULL energy_efficiency_class: VARCHAR(10) DEFAULT NULL min_energy_efficiency_class: VARCHAR(10) DEFAULT NULL max_energy_efficiency_class: VARCHAR(10) DEFAULT NULL certification: VARCHAR(25) DEFAULT NULL shipping_weight: VARCHAR(255) DEFAULT NULL shipping: VARCHAR(255) DEFAULT NULL Mapping: ordernumber: Source: articles_new.ordernumber In_Export: no creation_date: Source: articles_new.added In_Export: no id: Source: articles_new.ordernumber File_Field_Adapter: Config: importEngine Engine: importEngine Datapool: moebelshop_s_articles_details Identifier: ordernumber File: export_articles_oms_google.id Fields: - ArticleId - ArticleDetailsId - ordernumber attr10: Source: articles_new.attr10 In_Export: no attr20: Source: articles_new.name_oms In_Export: no attr17: Source: articles_new.attr17 In_Export: no supplier: Source: articles_new.supplier_oms In_Export: no configurator_options: Source: articles_new.configuratorOptions In_Export: no farbe_exakt: Source: iwm_articles_properties.farbe_exakt In_Export: no color: Source: iwm_articles_properties.farbe File_Field_Adapter: File: export_articles_oms_google.color material: iwm_articles_properties.material abmessung: Source: iwm_articles_properties.abmessung In_Export: no title: Source: articles_new.name_ost File_Field_Adapter: File: export_articles_oms_google.title Field_Adapter: - replace: ['<',''] - replace: ['>',''] description: Source: articles_new.description_long_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms Cross_Field: description_long Local_Key: ordernumber Cross_Key: ordernumber File_Field_Adapter: File: export_articles_oms_google.description google_product_category: IF(articles_new.cat_google = "", "Möbel",articles_new.cat_google) AS google_product_category product_type: export_for_dataengine.category link: Source: export_for_dataengine.link File_Field_Adapter: File: export_articles_oms_google.link image_link: Source: export_for_dataengine.image_link # Field_Adapter: # - explode: [',', 0] #explode source field by ',' and chooses the first elements additional_image_link_1: Source: export_for_dataengine.additional_image_link_1 In_Export: no additional_image_link_2: Source: export_for_dataengine.additional_image_link_2 In_Export: no additional_image_link_3: Source: export_for_dataengine.additional_image_link_3 In_Export: no additional_image_link_4: Source: export_for_dataengine.additional_image_link_4 In_Export: no additional_image_link: Source: export_for_dataengine.additional_image_link_1 File_Field_Adapter: File: export_articles_oms_google.additional_image_link condition1: (new) availability: (in_stock) price_EK: #needed, because price field is overwritten and used for sale_price Source: articles_new.pseudoprice_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: price_EK #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 In_Export: no pseudoprice: Source: articles_new.price_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: pseudoprice_EK #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 In_Export: no price: Source: articles_new.pseudoprice_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: price_EK #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 File_Field_Adapter: File: export_articles_oms_google.price sale_price: Source: articles_new.price_oms File_Field_Adapter: File: export_articles_oms_google.sale_price brand: Source: articles_new.supplier_oms Field_Adapter: - replace: ['Sonstige',''] gtin: articles_new.ean mpn: articles_new.attr9 ads_grouping: articles_new.swag_attr27 custom_label_0: Source: articles_new.name_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: attr8 #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 Field_Adapter: - replace: [',', '.'] - concat_source: ' EUR' custom_label_1: articles_new.swag_attr29 custom_label_2: articles_new.attr4 custom_label_3: articles_new.attr13 custom_label_4: Source: articles_new.attr54 Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: attr54 #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 File_Field_Adapter: File: export_articles_oms_google.custom_label_4 size: iwm_articles_properties.groesse pattern: iwm_articles_properties.Muster energy_efficiency_class: iwm_articles_properties.Energieeffizienzklasse min_energy_efficiency_class: articles_new.enev_spectrumfrom max_energy_efficiency_class: articles_new.enev_spectrum certification: Source: articles_new.name_oms Cross_Field_Adapter: Config: unitizeEngine Cross_Datapool: iwm_articles_tvk_4_eprel #name of cross datapool Cross_Field: eprel #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 File_Field_Adapter: File: export_articles.certification shipping_weight: Source: articles_new.weight Field_Adapter: - float_pricision: ['2', '.', '' ] shipping: Source: articles_new.name_oms Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_articles_oms #name of cross datapool Cross_Field: attr8 #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 Field_Adapter: - replace: [',', '.'] File_Field_Adapter: File: export_articles_oms_google.shipping Filters: - Filter: name: 'empty id' condition: (id == '') reason: 'empty id' - Filter: name: not_in_oms_export condition: Not_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_google_ohne_stern #sql table Primary_Key: [id]
Definition aktualisieren