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.
draft
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: ostermann_s_articles_details
Join_Condition: articles_new.ordernumber = ostermann_s_articles_details.ordernumber
Read_Conditions: #sql where - Read-Filter
- articles_new.attr1 = 1
- articles_new.instock > 0
Datapool_Definition:
itemid: 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:
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: ostermann_s_articles_details
Identifier: ordernumber
File: export_articles_ost_google_local.itemid
Fields:
- ArticleId
- ArticleDetailsId
- 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:
Source: articles_new.price_ost
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_ost #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: [',', '.']
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_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": "ostermann_s_articles_details", "Join_Condition": "articles_new.ordernumber = ostermann_s_articles_details.ordernumber" } ] |
| Read_Conditions | [ "articles_new.attr1 = 1", "articles_new.instock > 0" ] |
| Datapool_Definition | { "itemid": "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 | { "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": "ostermann_s_articles_details", "Identifier": "ordernumber", "File": "export_articles_ost_google_local.itemid", "Fields": [ "ArticleId", "ArticleDetailsId", "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": { "Source": "articles_new.price_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_ost", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ",", "." ] } ] } } |
| 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_google_local |
| Primary_Key | [ "itemid" ] |