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
#Source
#Source_Fields: [ordernumber, mainnumber, name_oms, tax, price_oms, pseudoprice_oms, baseprice, active_oms, description, description_long_oms, unitID, ean, categories, referenceUnit, purchaseUnit] #sql select
Source_Datapool: articles #sql from
Joins:
- Left_Join: #each condition is joined with "AND"
Datapool: iwm_articles_stock
Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma # One row per JOIN
- Left_Join:
Datapool: iwm_properties
Join_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma
Read_Conditions: #sql where - Read-Filter
- articles.attr1 = 1 AND articles.active_tre = 1
#Mapping -> Mappings source fields are detected by Mapping
Mapping:
ordernumber: articles.ordernumber
mainnumber:
Source: articles.mainnumber
Field_Adapter:
- replace: ['-1', '']
name_ost:
Source: articles.name_ost
Field_Adapter:
- addslashes
name_tre:
Source: articles.name_tre
Field_Adapter:
- addslashes
name_oms:
Source: articles.name_oms
Field_Adapter:
- addslashes
name_bil:
Source: articles.name_bil
Field_Adapter:
- addslashes
supplier_ost:
Source: articles.name_bil
Field_Adapter:
- addslashes
supplier_tre:
Source: articles.name_bil
Field_Adapter:
- addslashes
supplier_oms:
Source: articles.name_bil
Field_Adapter:
- addslashes
supplier_bil:
Source: articles.name_bil
Field_Adapter:
- addslashes
tax: articles.tax
kind: articles.kind
price_ost: articles.price_ost
price_tre: articles.price_tre
price_oms: articles.price_oms
price_bil: articles.price_bil
pseudoprice_ost: articles.pseudoprice_ost
pseudoprice_tre: articles.pseudoprice_tre
pseudoprice_oms: articles.pseudoprice_oms
pseudoprice_bil: articles.pseudoprice_bil
active_ost: articles.active_ost
active_tre: articles.active_tre
active_oms: articles.active_oms
active_bil: articles.active_bil
categoryPath_ost:
Source: articles.categoryPath_ost
Field_Adapter:
- addslashes
categoryPath_tre:
Source: articles.categoryPath_tre
Field_Adapter:
- addslashes
categoryPath_oms:
Source: articles.categoryPath_oms
Field_Adapter:
- addslashes
categoryPath_bil:
Source: articles.categoryPath_bil
Field_Adapter:
- addslashes
configuratorOptions: articles.configuratorOptions
description_long_ost:
Source: articles.description_long_ost
Field_Adapter:
- addslashes
description_long_tre:
Source: articles.description_long_tre
Field_Adapter:
- addslashes
description_long_oms:
Source: articles.description_long_oms
Field_Adapter:
- addslashes
description_long_bil:
Source: articles.description_long_bil
Field_Adapter:
- addslashes
attr1: articles.attr1
attr2: articles.attr2
attr3: articles.attr3
attr4: articles.attr4
attr5: articles.attr5
attr6: articles.attr6
attr7: articles.attr7
attr8: articles.attr8
attr9: articles.attr9
attr10: articles.attr10
attr11: articles.attr11
attr12: articles.attr12
attr13: articles.attr13
attr14: articles.attr14
attr15: articles.attr15
attr16: articles.attr16
attr17: articles.attr17
attr18: articles.attr18
attr19: articles.attr19
attr20: articles.attr20
swag_attr21: articles.swag_attr21
swag_attr22: articles.swag_attr22
Source: articles.swag_attr22
Field_Adapter:
- addslashes
swag_attr23: articles.swag_attr23
swag_attr24: articles.swag_attr24
swag_attr25: articles.swag_attr25
swag_attr26: articles.swag_attr26
swag_attr27: articles.swag_attr27
swag_attr28: articles.swag_attr28
swag_attr29: articles.swag_attr29
swag_attr30: articles.swag_attr30
ean: articles.ean
imageUrl: articles.imageUrl
stock_witten: iwm_articles_stocks.witten
propertyValueName:
Cross_Field_Adapter: #cross field adapter leads to sub select -> iwm_properties is not in join
Cross_Datapool: iwm_properties
Cross_Field: propertyValueName
Cross_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma #not needed for refereced tables
Field_Adapter:
- replace: ['|',':de;']
weight:
Source: articles.weight
Field_Adapter:
- replace: ['.00', '']
- replace: [',', '']
- simple_division: 1000
listingID: articles.listingID
Source: articles.ordernumber
Field_Adapter:
- replace: ['-', '00']
ebay_active: (1)
plenty_cat_id:
Source: (0)
File_Field_Adapter:
Datapool: plenty_cat_ids #The data of this datapool is injected in the function to have access via stmt
Fields: [plenty_cat_id, Level1, Level2]
#Target
Target_Datapool: export_articles_plenty_tre #sql table
Filters:
- Filter:
name: filter_plenty_tre_suppliers
condition: supplier_tre = PAIDI or supplier_tre = weber or supplier_tre = vito or supplier_tre = MONDO or supplier_tre = VALMONDO or supplier_tre = LIV´IN or supplier_tre = SELF or supplier_tre = KETTLER or supplier_tre = hülsta or supplier_tre = Kollektion-Wiedemann or supplier_tre = ROLF BENZ
output: positive
reason: 'excluded supplier'
- Filter:
name: filter_plenty_oms_kalkulation
condition: LBKALK < 60
output: positive
reason: 'bad calculation'
- Filter:
name: filter_plenty_oms_kalkulation
condition: LBKALK < 60
output: positive
reason: 'bad calculation'
- Filter:
name: 'Preis ungueltig'
condition: (price_tre == '0') or (price_tre == '') or (price_tre == '0.00') or (price_tre == '0,00') or (price_tre == '0,0')
reason: 'alle Preise = 0'
Metadata
Erkannte Konfiguration
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Keine Metadaten verfügbar. |