Legacy YAML export_articles_ost_idealo_local

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_ost_idealo_local 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 - 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


Read_Conditions:  #sql where - Read-Filter
  - articles_new.attr1 = 1
  - articles_new.instock > 0

Datapool_Definition:
    artikelnummer: VARCHAR(255) NOT NULL
    title: VARCHAR(255) DEFAULT NULL
    description: MEDIUMTEXT DEFAULT NULL
    image_link: VARCHAR(255) DEFAULT NULL
    condition1: VARCHAR(255) DEFAULT NULL
    gtin: VARCHAR(255) DEFAULT NULL
    brand: VARCHAR(255) DEFAULT NULL
    google_product_category: VARCHAR(255) DEFAULT NULL
    mpn: VARCHAR(255) DEFAULT NULL
    price: VARCHAR(255) DEFAULT NULL

Mapping:
    artikelnummer: articles_new.ordernumber
    title: articles_new.name_ost
    description:
      Source: articles_new.description_long_ost
      Field_Adapter:
          - replace: [';', '']
    image_link:
      Source: articles_new.imageUrl
      Field_Adapter:
       - explode: [',', 0] #explode source field by ',' and chooses the first element
    condition1: (new)
    gtin: articles_new.ean
    brand:
      Source: articles_new.supplier_ost
      Field_Adapter:
       - replace: ['Sonstige','']
    google_product_category: IF(articles_new.cat_google = "", "Möbel",articles_new.cat_google) AS google_product_category
    mpn: articles_new.attr9
    price: articles_new.price_ost

Filters:
 - Filter:
    name: not_in_stock_google_local
    condition:
      Not_In_Pool_Filter_Adapter:
        Config: exportEngine
        Datapool: export_articles_stock_ost_google_local
        Local_Key: itemid
        Cross_Key: itemid
    reason: 'not_in_stock_google_local'


#Target
Datapool: export_articles_ost_idealo_local #sql table
Primary_Key: [artikelnummer]

Source

Datei und Status

Dateipfad: /srv/app/backend/export/exportEngines/export_articles_ost_idealo_local.yaml
Runner: export
Feature Flags: Datapool_Definition, Field_Adapter, Filters, Mapping, Read_Conditions
Connections: enhanceEngine, exportEngine

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
Mysql_Engine	InnoDB
Default_Charset	latin1
Source_Datapool	articles_new
Read_Conditions	[ "articles_new.attr1 = 1", "articles_new.instock > 0" ]
Datapool_Definition	{ "artikelnummer": "VARCHAR(255) NOT NULL", "title": "VARCHAR(255) DEFAULT NULL", "description": "MEDIUMTEXT DEFAULT NULL", "image_link": "VARCHAR(255) DEFAULT NULL", "condition1": "VARCHAR(255) DEFAULT NULL", "gtin": "VARCHAR(255) DEFAULT NULL", "brand": "VARCHAR(255) DEFAULT NULL", "google_product_category": "VARCHAR(255) DEFAULT NULL", "mpn": "VARCHAR(255) DEFAULT NULL", "price": "VARCHAR(255) DEFAULT NULL" }
Mapping	{ "artikelnummer": "articles_new.ordernumber", "title": "articles_new.name_ost", "description": { "Source": "articles_new.description_long_ost", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "image_link": { "Source": "articles_new.imageUrl", "Field_Adapter": [ { "explode": [ ",", 0 ] } ] }, "condition1": "(new)", "gtin": "articles_new.ean", "brand": { "Source": "articles_new.supplier_ost", "Field_Adapter": [ { "replace": [ "Sonstige", "" ] } ] }, "google_product_category": "IF(articles_new.cat_google = \"\", \"M\u00f6bel\",articles_new.cat_google) AS google_product_category", "mpn": "articles_new.attr9", "price": "articles_new.price_ost" }
Filters	[ { "Filter": { "name": "not_in_stock_google_local", "condition": { "Not_In_Pool_Filter_Adapter": { "Config": "exportEngine", "Datapool": "export_articles_stock_ost_google_local", "Local_Key": "itemid", "Cross_Key": "itemid" } }, "reason": "not_in_stock_google_local" } } ]
Datapool	export_articles_ost_idealo_local
Primary_Key	[ "artikelnummer" ]