Legacy YAML / Detail

export / export_articles_texts_online

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
Zurück zum Browser
Managed Definition öffnen

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.

Zum Raw YAML Zu den Metadaten
engine Typ
valid Parse-Status
Managed Status
draft
export_articles_texts_online 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 # 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]

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 articles_new
Mysql_Engine InnoDB
Default_Charset utf8
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 { "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", "Cross_Field": "append_text", "Local_Key": "arte", "Cross_Key": "arte" } }, "forbid_text_generation": { "Source": "articles_new.name_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_texts_scanned", "Cross_Field": "forbid_text_generation", "Local_Key": "arte", "Cross_Key": "arte" } }, "TXT40_TEXT": { "Source": "articles_new.arte", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_texte_txt40", "Cross_Field": "text", "Mapping": { "arte": "arte", "attr1": "firma" } } } ] }, "ARHT_TEXT": { "Source": "articles_new.arte", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_texte_arht", "Cross_Field": "text", "Mapping": { "arte": "arte", "attr1": "firma" } } } ] }, "2TXT_TEXT_ost": { "Source": "articles_new.arte", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "article_texts_generated_persistant_ost", "Cross_Field": "description", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "2TXT_TEXT_tre": { "Source": "articles_new.arte", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "article_texts_generated_persistant_tre", "Cross_Field": "description", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "2TXT_TEXT_oms": { "Source": "articles_new.arte", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "article_texts_generated_persistant_oms", "Cross_Field": "description", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "TKZ8": { "Source": "articles_new.arte", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_textilkennzeichen_8", "Cross_Field": "textilkennzeichen", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "PIL": { "Source": "articles_new.arte", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_properties_pil", "Cross_Field": "pil_html_gesamt", "Mapping": { "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" } } }
Datapool export_articles_texts_online
Primary_Key [ "ordernumber", "attr1" ]