Engine / Editor
export_texts_scanned
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 Target_Config: exportEngine #Source Source_Datapool: iwm_articles_texte_txt40 Mysql_Engine: InnoDB Default_Charset: utf8 Index: [text_hash] #Read_Conditions: #notice for first time use: if export_texts_scanned_lastrun does not exist, commment Read_Conditions here and run the engine, then uncomment it and run engine again - text_hash has to have an index in both tables # - dg_supplierdata_export.export_texts_scanned_lastrun.arte IS NULL #Joins: # - Left_Join: #each condition is joined with "AND" # Datapool: dg_supplierdata_export.export_texts_scanned_lastrun # Join_Condition: iwm_articles_texte_txt40.arte = export_texts_scanned_lastrun.arte and iwm_articles_texte_txt40.firma = export_texts_scanned_lastrun.firma #Read_Conditions: #notice for first time use: if export_texts_scanned_lastrun does not exist, commment Read_Conditions here and run the engine, then uncomment it and run engine again - text_hash has to have an index in both tables # - iwm_articles_texte_txt40.text_hash NOT IN (SELECT text_hash FROM dg_supplierdata_export.export_texts_scanned_lastrun) Datapool_Definition: firma: VARCHAR(2) NOT NULL arte: VARCHAR(10) NOT NULL text: TEXT DEFAULT NULL text_hash: VARCHAR(50) DEFAULT NULL text_scanned: VARCHAR(2) DEFAULT NULL forbid_text_generation: VARCHAR(2) DEFAULT NULL append_text: VARCHAR(2) DEFAULT NULL Mapping: firma: Source: iwm_articles_texte_txt40.firma arte: Source: iwm_articles_texte_txt40.arte text: Source: iwm_articles_texte_txt40.text text_hash: Source: iwm_articles_texte_txt40.text Field_Adapter: - md5 text_scanned: (1) forbid_text_generation: Source: iwm_articles_texte_txt40.firma File_Field_Adapter: File: export_texts_scanned.forbid_text_generation append_text: Source: iwm_articles_texte_txt40.firma File_Field_Adapter: File: export_texts_scanned.append_text #Target Datapool: export_texts_scanned #sql table Primary_Key: [arte, firma]
Definition aktualisieren