Legacy YAML / Detail

export / export_texts_scanned

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live

Legacy-Definition sicher vergleichen

Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.

engine Typ
valid Parse-Status
Managed Status
draft
export_texts_scanned Kurzinfo

Raw YAML

Dateiinhalt

Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.

#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]

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Source_Config enhanceEngine
Target_Config exportEngine
Source_Datapool iwm_articles_texte_txt40
Mysql_Engine InnoDB
Default_Charset utf8
Index [ "text_hash" ]
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" } } }
Datapool export_texts_scanned
Primary_Key [ "arte", "firma" ]