Engine / Editor
export_articles_texts_online
Mandant codex-demo
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 - credentials of the source connection service Target_Config: exportEngine # config - credentials of the target connection service # Source Source_Datapool: articles_new # sql from Mysql_Engine: InnoDB Default_Charset: utf8 # Joins: # - Left_Join: # Datapool: iwm_articles_stock # Join_Condition: articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma # One row per JOIN # - Left_Join: # Datapool: iwm_articles_new_bssp_and_auslauf # Join_Condition: articles_new.ordernumber = iwm_articles_new_bssp_and_auslauf.ordernumber AND articles_new.attr1 = iwm_articles_new_bssp_and_auslauf.firma and (iwm_articles_new_bssp_and_auslauf.verkaufshaus = 86 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 87 or iwm_articles_new_bssp_and_auslauf.verkaufshaus = 0) # - Left_Join: # Datapool: iwm_articles_properties # Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma Datapool_Definition: ordernumber: VARCHAR(50) NOT NULL attr1: VARCHAR(2) NOT NULL mainnumber: VARCHAR(50) DEFAULT NULL arte: VARCHAR(50) DEFAULT NULL append_text: VARCHAR(2) DEFAULT NULL forbid_text_generation: VARCHAR(2) DEFAULT NULL TXT40_TEXT: TEXT DEFAULT NULL ARHT_TEXT: TEXT DEFAULT NULL 2TXT_TEXT_ost: TEXT DEFAULT NULL 2TXT_TEXT_tre: TEXT DEFAULT NULL 2TXT_TEXT_oms: TEXT DEFAULT NULL TKZ8: TEXT DEFAULT NULL PIL: TEXT DEFAULT NULL description_long_ost: TEXT DEFAULT NULL description_long_tre: TEXT DEFAULT NULL description_long_oms: TEXT DEFAULT NULL # Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: Source: articles_new.ordernumber attr1: Source: articles_new.attr1 mainnumber: Source: articles_new.mainnumber arte: Source: articles_new.arte append_text: Source: articles_new.name_ost Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_texts_scanned # name of the cross datapool Cross_Field: append_text # field to select value from in the cross datapool Local_Key: arte # key for the where condition from the datapool Cross_Key: arte # key for the where condition from the cross datapool forbid_text_generation: Source: articles_new.name_ost Cross_Field_Adapter: Config: exportEngine Cross_Datapool: export_texts_scanned # name of the cross datapool Cross_Field: forbid_text_generation # field to select value from in the cross datapool Local_Key: arte # key for the where condition from the datapool Cross_Key: arte # key for the where condition from the cross datapool TXT40_TEXT: Source: articles_new.arte Cross_Field_Adapters: - Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: iwm_articles_texte_txt40 # name of the cross datapool Cross_Field: text # field to select value from in the cross datapool Mapping: # cross field adapter with more than one key arte: arte attr1: firma ARHT_TEXT: Source: articles_new.arte Cross_Field_Adapters: - Cross_Field_Adapter: Config: unitizeEngine Cross_Datapool: iwm_articles_texte_arht # name of the cross datapool Cross_Field: text # field to select value from in the cross datapool Mapping: # cross field adapter with more than one key arte: arte attr1: firma 2TXT_TEXT_ost: Source: articles_new.arte Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: article_texts_generated_persistant_ost # name of the cross datapool Cross_Field: description # field to select value from in the cross datapool Local_Key: ordernumber # key for the where condition from the datapool Cross_Key: ordernumber # key for the where condition from the cross datapool 2TXT_TEXT_tre: Source: articles_new.arte Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: article_texts_generated_persistant_tre # name of the cross datapool Cross_Field: description # field to select value from in the cross datapool Local_Key: ordernumber # key for the where condition from the datapool Cross_Key: ordernumber # key for the where condition from the cross datapool 2TXT_TEXT_oms: Source: articles_new.arte Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: article_texts_generated_persistant_oms # name of the cross datapool Cross_Field: description # field to select value from in the cross datapool Local_Key: ordernumber # key for the where condition from the datapool Cross_Key: ordernumber # key for the where condition from the cross datapool TKZ8: Source: articles_new.arte Cross_Field_Adapters: - Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: iwm_articles_textilkennzeichen_8 # name of the cross datapool Cross_Field: textilkennzeichen # field to select value from in the cross datapool Mapping: # cross field adapter with more than one key ordernumber: ordernumber attr1: firma PIL: Source: articles_new.arte Cross_Field_Adapters: - Cross_Field_Adapter: Config: enhanceEngine Cross_Datapool: iwm_articles_properties_pil # name of the cross datapool Cross_Field: pil_html_gesamt # field to select value from in the cross datapool Mapping: # cross field adapter with more than one key ordernumber: ordernumber attr1: firma description_long_ost: Source: articles_new.description_long_oms File_Field_Adapter: File: export_articles_texts_online.description_long_ost description_long_tre: Source: articles_new.description_long_tre File_Field_Adapter: File: export_articles_texts_online.description_long_tre description_long_oms: Source: articles_new.description_long_oms File_Field_Adapter: File: export_articles_texts_online.description_long_oms # Target Datapool: export_articles_texts_online # sql table Primary_Key: [ordernumber, attr1]
Definition aktualisieren