Legacy YAML / Detail

export / export_articles_tre_google_local

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

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: trends_s_articles_details
  Join_Condition: articles_new.ordernumber = trends_s_articles_details.ordernumber and articles_new.attr1 = 3
#- Left_Join:
#  Datapool: shopware_article_info
#  Join_Condition: articles_new.ordernumber = shopware_article_info.ordernumber AND articles_new.attr1 = 3 AND shopware_article_info.shop = 'tre'
- Left_Join:
  Datapool: export_for_dataengine
  Join_Condition: articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'tre'




Read_Conditions:  #sql where - Read-Filter
  - articles_new.attr1 = 3
  - (articles_new.attr11 = 'L') or (articles_new.instock > 0)
  - export_for_dataengine.shop = 'tre'

Datapool_Definition:
    itemid: VARCHAR(255) NOT NULL
    arte: 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
    link: VARCHAR(255) DEFAULT NULL

Mapping:
    ordernumber:
      Source: articles_new.ordernumber
      In_Export: no
    creation_date:
      Source: articles_new.added
      In_Export: no
    itemid:
      Source: articles_new.ordernumber
      File_Field_Adapter:
        Config: importEngine
        Engine: importEngine
        Datapool: trends_s_articles_details
        Identifier: ordernumber
        File: export_articles_tre_google_local.id
        Fields:
          - ArticleId
          - ArticleDetailsId
          - ordernumber
    arte: articles_new.arte
    title: articles_new.name_tre
    description:
      Source: articles_new.description_long_tre
      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_tre
      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:
      Source: articles_new.price_tre
      Cross_Field_Adapter:
        Config: exportEngine
        Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
        Cross_Field: price_EK #field to select value from in cross datapool
        Local_Key: ordernumber #key for where condition from datapool
        Cross_Key: ordernumber #key for where condition from cross datapool
      Field_Adapter:
        - replace: [',', '.']
    link:
      Source: export_for_dataengine.link
      File_Field_Adapter:
        File: export_articles_tre_google.link


Filters:
 - Filter:
    name: not_in_stock_google_local
    condition:
      Not_In_Pool_Filter_Adapter:
        Config: exportEngine
        Datapool: export_articles_stock_tre_google_local
        Local_Key: itemid
        Cross_Key: itemid
    reason: 'not_in_stock_google_local'
 - Filter:
     name: not_online
     condition:
       Not_In_Pool_Filter_Adapter:
         Config: exportEngine
         Datapool: export_articles_tre
         Local_Key: arte
         Cross_Key: arte
     reason: 'not_online'
 - Filter:
     name: 'dynamic filter trends aus trends-deaktivieren.csv'
     condition:
       In_Pool_Filter_Adapter:
         Config: importEngine
         Datapool: dynamic_filter_trends
         reason: 'trends-deaktivieren.csv'
         Mapping:
           arte: Artikelnummer
     reason: 'dynamic filter trends aus trends-deaktivieren.csv'


#Target
Datapool: export_articles_tre_google_local #sql table
Primary_Key: [itemid]

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
Joins [ { "Left_Join": null, "Datapool": "trends_s_articles_details", "Join_Condition": "articles_new.ordernumber = trends_s_articles_details.ordernumber and articles_new.attr1 = 3" }, { "Left_Join": null, "Datapool": "export_for_dataengine", "Join_Condition": "articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'tre'" } ]
Read_Conditions [ "articles_new.attr1 = 3", "(articles_new.attr11 = 'L') or (articles_new.instock > 0)", "export_for_dataengine.shop = 'tre'" ]
Datapool_Definition { "itemid": "VARCHAR(255) NOT NULL", "arte": "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", "link": "VARCHAR(255) DEFAULT NULL" }
Mapping { "ordernumber": { "Source": "articles_new.ordernumber", "In_Export": "no" }, "creation_date": { "Source": "articles_new.added", "In_Export": "no" }, "itemid": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "trends_s_articles_details", "Identifier": "ordernumber", "File": "export_articles_tre_google_local.id", "Fields": [ "ArticleId", "ArticleDetailsId", "ordernumber" ] } }, "arte": "articles_new.arte", "title": "articles_new.name_tre", "description": { "Source": "articles_new.description_long_tre", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "image_link": { "Source": "articles_new.imageUrl", "Field_Adapter": [ { "explode": [ ",", 0 ] } ] }, "condition1": "(new)", "gtin": "articles_new.ean", "brand": { "Source": "articles_new.supplier_tre", "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": { "Source": "articles_new.price_tre", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_tre", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ",", "." ] } ] }, "link": { "Source": "export_for_dataengine.link", "File_Field_Adapter": { "File": "export_articles_tre_google.link" } } }
Filters [ { "Filter": { "name": "not_in_stock_google_local", "condition": { "Not_In_Pool_Filter_Adapter": { "Config": "exportEngine", "Datapool": "export_articles_stock_tre_google_local", "Local_Key": "itemid", "Cross_Key": "itemid" } }, "reason": "not_in_stock_google_local" } }, { "Filter": { "name": "not_online", "condition": { "Not_In_Pool_Filter_Adapter": { "Config": "exportEngine", "Datapool": "export_articles_tre", "Local_Key": "arte", "Cross_Key": "arte" } }, "reason": "not_online" } }, { "Filter": { "name": "dynamic filter trends aus trends-deaktivieren.csv", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "dynamic_filter_trends", "reason": "trends-deaktivieren.csv", "Mapping": { "arte": "Artikelnummer" } } }, "reason": "dynamic filter trends aus trends-deaktivieren.csv" } } ]
Datapool export_articles_tre_google_local
Primary_Key [ "itemid" ]