draft
Raw YAML
Dateiinhalt
#Connections
Source_Config: unitizeEngine #config - credetials of source connection service
Target_Config: enhanceEngine #config - credentials of target connection service
Enhance_Mode: flexible
#Engine Mode
Engine_Mode: full
#Source
Source_Datapool: iwm_articles #sql from
Joins:
- Left_Join:
Datapool: iwm_articles_stock
Join_Condition: iwm_articles.attr1 = iwm_articles_stock.firma and iwm_articles.ordernumber = iwm_articles_stock.ordernumber
- Left_Join:
Datapool: dg_supplierdata_enhanced.iwm_articles_properties
Join_Condition: iwm_articles.ordernumber = iwm_articles_properties.ordernumber and iwm_articles.attr1 = iwm_articles_properties.firma
- Left_Join:
Datapool: dg_supplierdata_enhanced.iwm_articles_properties_pil
Join_Condition: iwm_articles.ordernumber = iwm_articles_properties_pil.ordernumber and iwm_articles.attr1 = iwm_articles_properties_pil.firma
#Target
Datapool: articles #sql table
Target_Datapool: articles #sql from
Primary_Key: [ordernumber, attr1]
#Mapping -> Mappings source fields are detected by Mapping
Mapping:
arte:
Source: iwm_articles.arte
name_oms:
Source: iwm_articles.name_oms
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_3
Cross_Field: name_oms
Mapping:
arte: arte
attr1: firma
name_tre:
Source: iwm_articles.name_tre
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_3
Cross_Field: name_tre
Mapping:
arte: arte
attr1: firma
name_ost:
Source: iwm_articles.name_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_3
Cross_Field: name_ost
Mapping:
arte: arte
attr1: firma
name_bil:
Source: iwm_articles.name_bil
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_3
Cross_Field: name_bil
Mapping:
arte: arte
attr1: firma
active_ost: iwm_articles.active_ost
active_tre: iwm_articles.active_tre
active_oms: iwm_articles.active_oms
active_bil: iwm_articles.active_bil
added: iwm_articles.added
changed: iwm_articles.changed
unitID: iwm_articles.unitID
attr9:
Source: iwm_articles.attr9
Field_Adapter:
- addslashes:
configuratorOptions:
Source: iwm_articles.configuratorOptions
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: configuratorOptions #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
attr1: attr1
ordernumber: ordernumber
suppliernumber_original:
Source: iwm_articles.suppliernumber
suppliernumber:
Source: iwm_articles.suppliernumber
File_Field_Adapter:
Engine: importEngine
Datapool: static_mapping_suppliernumber
Identifier: id
File: articles.suppliernumber
Fields:
- id
- name_ost
- firma
- systemnummer
- lieferantennummer
- attr9
- hwg
- suppliernumber
ean:
Source: iwm_articles.ean
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: ean #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
attr1: attr1
ordernumber: ordernumber
categories: iwm_articles.categories
metaTitle: iwm_articles.metaTitle
packUnit: iwm_articles.packUnit
configuratorType: iwm_articles.configuratorType
weight: iwm_articles.weight
height: iwm_articles.height
width: iwm_articles.width
propertyGroupName: iwm_articles.propertyGroupName
propertyValueName: iwm_articles.propertyValueName
accessory: iwm_articles.accessory
attr2: iwm_articles.attr2
attr3: iwm_articles.attr3
attr4: iwm_articles.attr4
attr5: iwm_articles.attr5
attr6: iwm_articles.attr6
attr7: iwm_articles.attr7
attr8: iwm_articles.attr8
attr10: iwm_articles.attr10
attr11: iwm_articles.attr11
attr17: iwm_articles.attr17
attr19: iwm_articles.attr19
attr20: iwm_articles.attr20
swag_attr23:
Source: iwm_articles_stock.stock_inventory
Field_Adapter:
- replace_empty: 0
- replace_not_equals: ['0', '1']
swag_attr21:
Source: iwm_articles.swag_attr21
File_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Datapool: iwm_articles_kojen_per_article
Identifier: mainnumber
File: articles.swag_attr21
Fields:
- mainnumber
- firma
- kojencode
swag_attr24:
Source: iwm_articles.swag_attr24
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_oms #name of cross datapool
Cross_Field: attr24 #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: iwm_articles_tkz_0 #name of cross datapool
Cross_Field: PROPERTIES #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: ORDERNUMBER
Options:
concat: ' '
swag_attr25: iwm_articles.swag_attr25
swag_attr26: #sortierte Ware
Source: iwm_articles.swag_attr26
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_new #name of cross datapool
Cross_Field: konsigniert #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
swag_attr27: #Produktart
Source: iwm_articles.name_oms
Field_Adapter:
- explode: [' ','0']
attr30: #local stock -> sum of local stocks without exhibition stocks
Source: iwm_articles.attr18
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock_local #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_empty: 0
attr31: # ir stock
Source: iwm_articles.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock_inventory #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
stockmin_ost: iwm_articles.stockmin_ost
stockmin_tre: iwm_articles.stockmin_tre
stockmin_oms: iwm_articles.stockmin_oms
stockmin_bil: iwm_articles.stockmin_bil
AbsatzMenge3M: iwm_articles.AbsatzMenge3M
referenceUnit: (1)
attr1: iwm_articles.attr1
instock:
Source: iwm_articles.attr18
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock #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_empty: 0
stock_witten:
Source: iwm_articles.attr1
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: witten #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_empty: 0
attr12:
Source: iwm_articles.attr12
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_new #name of cross datapool
Cross_Field: attr12 #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
File_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Datapool: iwm_articles_lieferzeit_gesamt_mit_ausfallzeit
Identifier: ordernumber
File: articles.attr12
Fields:
- ordernumber
- lieferzeit
- firma
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr13:
Source: iwm_articles.attr13
File_Field_Adapter:
File: articles.attr13
attr14:
Source: iwm_articles.attr14
File_Field_Adapter:
File: articles.attr14
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr15:
Source: iwm_articles.attr15
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr16:
Source: iwm_articles.attr16
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr18:
Source: iwm_articles.attr18
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_prices #name of cross datapool
Cross_Field: attr18 #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
categoryPath_ost:
Source: iwm_articles.categoryPath_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_ost
Cross_Field: category
Mapping:
ordernumber: ordernumber
categoryPath_tre:
Source: iwm_articles.categoryPath_tre
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_tre
Cross_Field: category
Mapping:
ordernumber: ordernumber
categoryPath_oms:
Source: iwm_articles.categoryPath_oms
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_oms
Cross_Field: category
Mapping:
ordernumber: ordernumber
categoryPath_bil:
Source: iwm_articles.categoryPath_bil
File_Field_Adapter:
File: articles.categoryPath_bil
cat_google:
Source: iwm_articles.cat_google
Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: static_mapping_categories #name of cross datapool
Cross_Field: google_category #field to select value from in cross datapool
Local_Key: categoryPath_oms #key for where condition from datapool
Cross_Key: oms_category #key for where condition from cross datapool
# Cross_Field_Adapters:
# - Cross_Field_Adapter:
# Config: importEngine
# Cross_Datapool: static_mapping_categories
# Cross_Field: google_category
# Mapping:
# categoryPath_oms: oms_category
cat_ebay:
Source: iwm_articles.cat_ebay
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: static_mapping_categories
Cross_Field: ebay_category
Mapping:
categoryPath_oms: oms_category
cat_amazon:
Source: iwm_articles.cat_amazon
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: static_mapping_categories
Cross_Field: amazon_category
Mapping:
categoryPath_oms: oms_category
description:
Source: iwm_articles.description
Field_Adapter:
- addslashes:
- replace: ['http://', 'https://']
description_long_ost:
Source: iwm_articles.description_long_ost
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: description_long_ost #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: ['http://', 'https://']
description_long_tre:
Source: iwm_articles.description_long_tre
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: description_long_tre #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: ['http://', 'https://']
description_long_oms:
Source: iwm_articles.description_long_oms
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: description_long_oms #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: ['http://', 'https://']
description_long_bil:
Source: iwm_articles.description_long_bil
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: articles_new #name of cross datapool
Cross_Field: description_long_bil #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: ['http://', 'https://']
ordernumber: iwm_articles.ordernumber
mainnumber:
Source: iwm_articles.mainnumber
File_Field_Adapter:
File: articles.mainnumber
imageUrl:
Source: iwm_articles.imageUrl
File_Field_Adapter:
File: articles.imageUrl
ItemImageDate:
Source: iwm_articles.ItemImageDate
File_Field_Adapter:
File: articles.ItemImageDate
kind:
Source: iwm_articles.kind
File_Field_Adapter:
File: articles.kind
baseprice:
Source: iwm_articles.baseprice
Field_Adapter:
- replace: [',','.']
configSetId:
Source: IF(iwm_articles.configSetId = '', 1, 0) AS configSetId
height:
Source: iwm_articles.height
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
price_ost:
Source: iwm_articles.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: [',','.']
- float_pricision: 2
price_tre:
Source: iwm_articles.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: [',','.']
- float_pricision: 2
price_oms:
Source: iwm_articles.price_oms
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_oms #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: [',','.']
- float_pricision: 2
price_bil:
Source: iwm_articles.price_oms
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_oms #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: [',','.']
- float_pricision: 2
pseudoprice_ost:
Source: iwm_articles.pseudoprice_ost
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
Cross_Field: pseudoprice_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: [',','.']
- float_pricision: 2
pseudoprice_tre:
Source: iwm_articles.pseudoprice_tre
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
Cross_Field: pseudoprice_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: [',','.']
- float_pricision: 2
pseudoprice_oms:
Source: iwm_articles.pseudoprice_oms
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
Cross_Field: pseudoprice_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: [',','.']
- float_pricision: 2
pseudoprice_bil:
Source: iwm_articles.pseudoprice_bil
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
purchaseprice:
Source: iwm_articles.purchaseprice
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
purchaseUnit:
Source: iwm_articles.purchaseUnit
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
referenceUnit: (1)
supplier_ost:
Source: iwm_articles.supplier_ost
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
Cross_Field: supplier_ost #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
supplier_tre:
Source: iwm_articles.supplier_tre
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
Cross_Field: supplier_tre #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
supplier_oms:
Source: iwm_articles.supplier_oms
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
Cross_Field: supplier_oms #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
supplier_bil:
Source: iwm_articles.supplier_bil
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_2 #name of cross datapool
Cross_Field: supplier_bil #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
swag_attr29:
Source: iwm_articles.swag_attr29 #carrier -> e.g. DHL, DPD etc.
File_Field_Adapter:
File: articles.swag_attr29
swag_attr22:
Source: iwm_articles.swag_attr22
File_Field_Adapter:
File: articles.swag_attr22
Field_Adapter:
- addslashes:
tax: (19.00)
shippingfree:
Source: iwm_articles.shippingfree
bestellsperre:
Source: iwm_articles.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
Cross_Field: bestellsperre #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
auslaufkennzeichen:
Source: iwm_articles.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
Cross_Field: auslaufkennzeichen #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
textilkennzeichen_text:
Source: iwm_articles.textilkennzeichen_text
Cross_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Cross_Datapool: iwm_articles_textilkennzeichen_8 #name of cross datapool
Cross_Field: textilkennzeichen #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
AHLZSD:
Source: iwm_articles.AHLZSD
Cross_Field_Adapter:
Config: unitizeEngine
Engine: unitizeEngine
Cross_Datapool: iwm_articles_arhp #name of cross datapool
Cross_Field: AHLZSD #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
ARKMFR:
Source: iwm_articles.ARKMFR
Cross_Field_Adapter:
Config: unitizeEngine
Engine: unitizeEngine
Cross_Datapool: iwm_articles_new #name of cross datapool
Cross_Field: ARKMFR #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
nutschicht:
Source: iwm_articles.nutschicht
Cross_Field_Adapter:
Config: unitizeEngine
Engine: unitizeEngine
Cross_Datapool: iwm_articles_new #name of cross datapool
Cross_Field: nutschicht #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
textilkennzeichen_needed:
Source: iwm_articles.textilkennzeichen_needed
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: static_mapping_textilkennzeichen_flag
Identifier: id
File: articles.textilkennzeichen_needed
Fields:
- id
- hwg
- uwg
- keyword
- AHLZSD
- ARKMFR
- nutschicht
- textilkennzeichen_needed
has_textilkennzeichen:
Source: iwm_articles.has_textilkennzeichen
File_Field_Adapter:
File: articles.has_textilkennzeichen
pil_needed:
Source: iwm_articles.pil_needed
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: static_mapping_pil_flag
Identifier: id
File: articles.pil_needed
Fields:
- id
- hwg
- uwg
- keyword
- ARKMFR
- pil_needed
pil_text:
Source: iwm_articles.pil_text
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_properties_pil
Cross_Field: pil_html_gesamt
Mapping:
ordernumber: ordernumber
attr1: firma
has_pil:
Source: iwm_articles.has_pil
File_Field_Adapter:
File: articles.has_pil
stock_ir:
Source: iwm_articles.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock_inventory #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
ahstat:
Source: iwm_articles.ahstat
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_arhp #name of cross datapool
Cross_Field: ahstat #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: firma
LBNTEK:
Source: iwm_articles.LBNTEK
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_ek_prices #name of cross datapool
Cross_Field: A9K300 #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
LBKALK:
Source: iwm_articles.LBKALK
File_Field_Adapter:
File: articles.LBKALK
LBMARGE: iwm_articles.LBMARGE
LBWAEISA: iwm_articles.LBWAEISA
prop1: iwm_articles_properties.prop1 #Farbe
prop2: iwm_articles_properties.prop2 #Breite
prop3: iwm_articles_properties.prop3 #Länge
prop4: iwm_articles_properties.prop4 #Höhe
prop5: iwm_articles_properties.prop5 #Abmessung
prop10: iwm_articles_properties.prop10 #Modell
prop11: iwm_articles_properties.prop11 #Material
prop12: iwm_articles_properties.prop12 #Raum
prop50: iwm_articles_properties.prop50 #Matratze Größe
prop51: iwm_articles_properties.prop51 #Matratze Härtegrad
prop52: iwm_articles_properties.prop52 #Matratze Bezugsmaterial
prop53: iwm_articles_properties.prop53 #Matratze Matratzenart
prop60: iwm_articles_properties.prop60 #Teppich Flächengewicht
prop61: iwm_articles_properties.prop61 #Teppich Florhöhe
prop62: iwm_articles_properties.prop62 #Teppich Fußbodenheizung
prop63: iwm_articles_properties.prop63 #Teppich Form
prop64: iwm_articles_properties.prop64 #Teppich Muster
enev_klasse: iwm_articles_properties_pil.Energieeffizienzklasse1
enev_color:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles.enev_color #mapping der Klasse auf die Farbe des Etiketts
enev_download:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles.enev_download
enev_image:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles.enev_image #mapping der Klasse auf das entsprechende Bild
enev_spectrumfrom:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles.enev_spectrumfrom
enev_spectrum:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles.enev_spectrum
enev_active:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles.enev_active
swag_attr28:
Source: iwm_articles.swag_attr28
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_tvk_4 #name of cross datapool
Cross_Field: eek #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
attr1: firma
File_Field_Adapter:
File: articles.swag_attr28
datenblatt:
Source: iwm_articles.datenblatt
File_Field_Adapter:
File: articles.datenblatt
has_datenblatt:
Source: iwm_articles.has_datenblatt
File_Field_Adapter:
File: articles.has_datenblatt
datenblatt_needed:
Source: iwm_articles.datenblatt_needed
File_Field_Adapter:
File: articles.datenblatt_needed
Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
- Filter:
name: Corona-Problem IR-Bestand
condition: (stock_witten < 1) AND (stock_ir < 1) AND (attr2 == 91) AND (attr11 == 'B')
reason: 'Corona-Problem IR-Bestand'
- Filter:
name: Corona-Problem IR-Bestand
condition: (stock_witten == '0') AND (stock_ir == '0') AND (attr2 == '91') AND (attr11 == 'B')
reason: 'Corona-Problem INVR-Bestand'
- Filter:
name: kein Bild #there must always be a space between the key and the comparision operator and between the parentheses
condition:
Cross_Dataset_Filter_Adapter: enhance_articles_ost__filterNoPicture
reason: 'kein Bild'
- Filter:
name: 'Artikeldeaktivierung Gesamtmengenfilter'
condition:
In_Pool_Filter_Adapter:
Config: importEngine
Datapool: static_filter_inactive_articles
Reason_Key: reason
Mapping: #left is from current datapool, right from filter datapool
suppliernumber: supplier_number
supplier_ost: supplier_name
supplier_tre: supplier_name
ordernumber: ordernumber
attr1: attr1
attr2: attr2
attr3: attr3
attr4: attr4
attr11: attr11
attr12: attr12
price_ost: price
price_tre: price
instock: stock
stock_witten: stock_witten
name_ost: name
name_tre: name
description_long_ost: description
auslaufkennzeichen: auslauf
bestellsperre: bestellsperre
ahstat: AHSTAT
swag_attr26: konsigniert
textilkennzeichen_needed: textilkennzeichen_needed
has_textilkennzeichen: has_textilkennzeichen
pil_needed: pil_needed
has_pil: has_pil
enev_active: enev_active
datenblatt_needed: datenblatt_needed
has_datenblatt: has_datenblatt
Metadata
Erkannte Konfiguration
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Keine Metadaten verfügbar. |