draft
Raw YAML
Dateiinhalt
Engine: Unitize
Source_Config: importEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: iwm_articles_new
Source_Primary_Key: [ordernumber, ItemFirm]
Target_Primary_Key: [ordernumber, attr1] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_articles_new
Add_Indices:
- Add_Index:
Datapool: iwm_articles_new
Index_Name: idx_FARBE
Fields: FARBE
- Add_Index:
Datapool: dynamic_mapping_colors
Index_Name: idx_FARB_ID
Fields: FARB_ID
- Add_Index:
Datapool: dynamic_mapping_variant_dimensions_AA01
Index_Name: idx_dimension_id
Fields: dimension_id
- Add_Index:
Datapool: iwm_articles_new
Index_Name: idx_AIAA01
Fields: AIAA01
- Add_Index:
Datapool: dynamic_mapping_variant_dimensions_AA02
Index_Name: idx_dimension_id
Fields: dimension_id
- Add_Index:
Datapool: iwm_articles_new
Index_Name: idx_AIAA02
Fields: AIAA02
- Add_Index:
Datapool: dynamic_mapping_variant_dimensions_AA03
Index_Name: idx_dimension_id
Fields: dimension_id
- Add_Index:
Datapool: iwm_articles_new
Index_Name: idx_AIAA03
Fields: AIAA03
Joins:
- Left_Join:
Datapool: dynamic_mapping_colors
Join_Condition: iwm_articles_new.FARBE = dynamic_mapping_colors.FARB_ID
- Left_Join:
Datapool: dynamic_mapping_variant_dimensions_AA01
Join_Condition: iwm_articles_new.AIAA01 = dynamic_mapping_variant_dimensions_AA01.dimension_id
- Left_Join:
Datapool: dynamic_mapping_variant_dimensions_AA02
Join_Condition: iwm_articles_new.AIAA02 = dynamic_mapping_variant_dimensions_AA02.dimension_id
- Left_Join:
Datapool: dynamic_mapping_variant_dimensions_AA03
Join_Condition: iwm_articles_new.AIAA03 = dynamic_mapping_variant_dimensions_AA03.dimension_id
# - Left_Join:
# Datapool: shopware_article_info_oms
# Join_Condition: iwm_articles_new.ordernumber = shopware_article_info_oms.ordernumber
# - Left_Join:
# Datapool: iwm_articles_new_eans_1
# Join_Condition: iwm_articles_new.ORDERNUMBER = iwm_articles_new_eans_1.ORDERNUMBER
# - Left_Join:
# Datapool: iwm_articles_new_eans_3
# Join_Condition: iwm_articles_new.ORDERNUMBER = iwm_articles_new_eans_3.ORDERNUMBER
# - Left_Join:
# Datapool: iwm_atab00
# Join_Condition: iwm_articles_new.FIRMA = iwm_atab00.ATFIRM AND iwm_articles_new.LIEFERANTENNUMMER = iwm_atab00.ATLINR AND iwm_articles_new.SYSTEMNUMMER = iwm_atab00.ATSYSN AND iwm_articles_new.AIAA01 = iwm_atab00.ATAA01 AND iwm_articles_new.AIAFN1 = iwm_atab00.ATAFNR
Datapool_Definition:
ordernumber: VARCHAR(50) NOT NULL
mainnumber: VARCHAR(50) DEFAULT NULL
arte: VARCHAR(50) DEFAULT NULL
name_ost: VARCHAR(255) DEFAULT NULL
name_tre: VARCHAR(255) DEFAULT NULL
name_oms: VARCHAR(255) DEFAULT NULL
supplier_ost: VARCHAR(100) DEFAULT NULL
supplier_tre: VARCHAR(100) DEFAULT NULL
supplier_oms: VARCHAR(100) DEFAULT NULL
tax: VARCHAR(10) DEFAULT NULL
price_ost: VARCHAR(20) DEFAULT NULL
price_tre: VARCHAR(20) DEFAULT NULL
price_oms: VARCHAR(20) DEFAULT NULL
shipping_ost: VARCHAR(20) DEFAULT NULL
shipping_tre: VARCHAR(20) DEFAULT NULL
shipping_oms: VARCHAR(20) DEFAULT NULL
pseudoprice_ost: VARCHAR(20) DEFAULT NULL
pseudoprice_tre: VARCHAR(20) DEFAULT NULL
pseudoprice_oms: VARCHAR(20) DEFAULT NULL
baseprice: VARCHAR(20) DEFAULT NULL
active_ost: INT(11) DEFAULT NULL
active_tre: INT(11) DEFAULT NULL
active_oms: INT(11) DEFAULT NULL
description: MEDIUMTEXT DEFAULT NULL
description_long_ost: TEXT DEFAULT NULL
description_long_tre: TEXT DEFAULT NULL
description_long_oms: TEXT DEFAULT NULL
added: DATETIME DEFAULT NULL
changed: DATETIME DEFAULT NULL
unitID: VARCHAR(40) DEFAULT NULL
variant_ean: VARCHAR(20) DEFAULT NULL
variant_hbsn: VARCHAR(20) DEFAULT NULL
ean: VARCHAR(50) DEFAULT NULL
attr9_strip: VARCHAR(20) DEFAULT NULL
categories: VARCHAR(255) DEFAULT NULL
purchaseprice: VARCHAR(20) DEFAULT NULL
referenceUnit: VARCHAR(20) DEFAULT NULL
purchaseUnit: VARCHAR(20) DEFAULT NULL
metaTitle: VARCHAR(255) DEFAULT NULL
configSetId: INT(11) DEFAULT NULL
packUnit: VARCHAR(20) DEFAULT NULL
configuratorType: VARCHAR(255) DEFAULT NULL
configuratorOptions: VARCHAR(255) DEFAULT NULL
kind: VARCHAR(5) DEFAULT NULL
suppliernumber_original: VARCHAR(50) DEFAULT NULL
suppliernumber: VARCHAR(50) DEFAULT NULL
weight: VARCHAR(20) DEFAULT NULL
height: VARCHAR(20) DEFAULT NULL
width: VARCHAR(20) DEFAULT NULL
categoryPath_ost: TEXT DEFAULT NULL
categoryPath_tre: TEXT DEFAULT NULL
categoryPath_oms: TEXT DEFAULT NULL
cat_google_produktart: TEXT DEFAULT NULL
cat_google_shop_category: TEXT DEFAULT NULL
cat_google: TEXT DEFAULT NULL
cat_ebay: TEXT DEFAULT NULL
cat_amazon: TEXT DEFAULT NULL
propertyGroupName: VARCHAR(255) DEFAULT NULL
propertyValueName: VARCHAR(255) DEFAULT NULL
accessory: VARCHAR(255) DEFAULT NULL
attr1: VARCHAR(10) NOT NULL
attr2: VARCHAR(10) DEFAULT NULL
attr3: VARCHAR(10) DEFAULT NULL
attr4: VARCHAR(10) DEFAULT NULL
attr5: VARCHAR(10) DEFAULT NULL
attr6: VARCHAR(150) DEFAULT NULL
attr7: VARCHAR(10) DEFAULT NULL
attr8: VARCHAR(10) DEFAULT NULL
attr9: VARCHAR(50) DEFAULT NULL
attr10: VARCHAR(100) DEFAULT NULL
attr11: VARCHAR(10) DEFAULT NULL
attr12: VARCHAR(10) DEFAULT NULL
attr13: VARCHAR(10) DEFAULT NULL
attr14: VARCHAR(10) DEFAULT NULL
attr15: VARCHAR(100) DEFAULT NULL
attr16: VARCHAR(10) DEFAULT NULL
attr17: VARCHAR(100) DEFAULT NULL
attr18: VARCHAR(10) DEFAULT NULL
attr19: VARCHAR(10) DEFAULT NULL
attr20: VARCHAR(350) DEFAULT NULL
swag_attr21: TEXT DEFAULT NULL
swag_attr22: VARCHAR(255) DEFAULT NULL
swag_attr23: VARCHAR(25) DEFAULT NULL
swag_attr24: VARCHAR(255) DEFAULT NULL
swag_attr25: VARCHAR(10) DEFAULT NULL
swag_attr26: VARCHAR(10) DEFAULT NULL
swag_attr27: VARCHAR(50) DEFAULT NULL
swag_attr28: TEXT DEFAULT NULL
swag_attr29: VARCHAR(25) DEFAULT NULL
attr30: VARCHAR(10) DEFAULT NULL
attr31: VARCHAR(10) DEFAULT NULL
attr36: VARCHAR(10) DEFAULT NULL
attr37_pre_ost: VARCHAR(50) DEFAULT NULL
attr37_pre_tre: VARCHAR(50) DEFAULT NULL
attr37_pre_oms: VARCHAR(50) DEFAULT NULL
attr37: VARCHAR(100) DEFAULT NULL
attr38: VARCHAR(50) DEFAULT NULL
attr41: VARCHAR(10) DEFAULT NULL
attr48: VARCHAR(10) DEFAULT NULL
attr50: VARCHAR(10) DEFAULT NULL
attr53: VARCHAR(25) DEFAULT NULL
attr54: VARCHAR(5) DEFAULT NULL
attr55: VARCHAR(25) DEFAULT NULL
attr57: VARCHAR(50) DEFAULT NULL
attr60: VARCHAR(50) DEFAULT NULL
attr61: VARCHAR(50) DEFAULT NULL
attr67: VARCHAR(50) DEFAULT NULL
tpl_color_badge: VARCHAR(2) DEFAULT NULL
stockmin_ost: INT(11) DEFAULT NULL
stockmin_tre: INT(11) DEFAULT NULL
stockmin_oms: INT(11) DEFAULT NULL
ItemImageDate: VARCHAR(255) DEFAULT NULL
imageUrl: TEXT DEFAULT NULL
LBNTEK: VARCHAR(20) DEFAULT NULL
LBKALK: VARCHAR(15) DEFAULT NULL
LBMARGE: VARCHAR(10) DEFAULT NULL
LBWAEISA: VARCHAR(10) DEFAULT NULL
AbsatzMenge3M: VARCHAR(10) DEFAULT NULL
shippingfree: VARCHAR(20) DEFAULT NULL
auslaufkennzeichen: VARCHAR(10) DEFAULT NULL
textilkennzeichen_needed: VARCHAR(10) DEFAULT NULL
textilkennzeichen_text: TEXT DEFAULT NULL
has_textilkennzeichen: VARCHAR(10) DEFAULT NULL
pil_needed: VARCHAR(10) DEFAULT NULL
pil_needed_static: VARCHAR(10) DEFAULT NULL
pil_needed_dynamic: VARCHAR(10) DEFAULT NULL
pil_text: TEXT DEFAULT NULL
has_pil: VARCHAR(10) DEFAULT NULL
AHLZSD: VARCHAR(10) DEFAULT NULL
ARKMFR: VARCHAR(10) DEFAULT NULL
anlieferart: VARCHAR(20) DEFAULT NULL
nutschicht: VARCHAR(10) DEFAULT NULL
stock_witten: VARCHAR(10) DEFAULT NULL
stock_ir: VARCHAR(10) DEFAULT NULL
stock_local: VARCHAR(10) DEFAULT NULL
ahstat: VARCHAR(10) DEFAULT NULL
bestellsperre: VARCHAR(10) DEFAULT NULL
mehrwertsteuerschluesselek: VARCHAR(20) DEFAULT NULL
mehrwertsteuerschluesselvk: VARCHAR(20) DEFAULT NULL
lagernummer: VARCHAR(255) DEFAULT NULL
koje: VARCHAR(255) DEFAULT NULL
material: VARCHAR(50) DEFAULT NULL
farbe: VARCHAR(45) DEFAULT NULL
aufbaukennzeichen: VARCHAR(10) DEFAULT NULL
stil: VARCHAR(20) DEFAULT NULL
montageeinheiten: VARCHAR(25) DEFAULT NULL
dimensionsfolge: VARCHAR(50) DEFAULT NULL
abmessung_dimension_1: VARCHAR(20) DEFAULT NULL
abmessung_dimension_2: VARCHAR(20) DEFAULT NULL
abmessung_dimension_3: VARCHAR(20) DEFAULT NULL
tourenart: VARCHAR(25) DEFAULT NULL
versandart: VARCHAR(25) DEFAULT NULL
groesse: VARCHAR(25) DEFAULT NULL
knuepfart: VARCHAR(25) DEFAULT NULL
variant_kurzbezeichnung: VARCHAR(50) DEFAULT NULL
variant_langbezeichnung: VARCHAR(50) DEFAULT NULL
variant_dimension_1: VARCHAR(50) DEFAULT NULL
variant_dimension_2: VARCHAR(50) DEFAULT NULL
variant_dimension_3: VARCHAR(50) DEFAULT NULL
variant_dimension_1_value: VARCHAR(50) DEFAULT NULL
variant_dimension_2_value: VARCHAR(50) DEFAULT NULL
variant_dimension_3_value: VARCHAR(50) DEFAULT NULL
instock: INT(5) DEFAULT NULL
lieferzeit: VARCHAR(50) DEFAULT NULL
konsigniert: VARCHAR(20) DEFAULT NULL
zeltgut: VARCHAR(2) DEFAULT NULL
ahstat: VARCHAR(10) DEFAULT NULL
datenblatt: VARCHAR(100) DEFAULT NULL
datenblatt_needed: VARCHAR(2) DEFAULT NULL
has_datenblatt: VARCHAR(2) DEFAULT NULL
modellfamilie: VARCHAR(50) DEFAULT NULL
no_packstation: VARCHAR(2) DEFAULT NULL
gpsr_herstellerinfo: TEXT DEFAULT NULL
gpsr_verantwortlicher: TEXT DEFAULT NULL
ear_marke: VARCHAR(100) DEFAULT NULL
H_Name: VARCHAR(100) DEFAULT NULL
H_Strasse: VARCHAR(100) DEFAULT NULL
H_PLZOrt: VARCHAR(100) DEFAULT NULL
H_Email: VARCHAR(100) DEFAULT NULL
WEEE_RegNr: VARCHAR(100) DEFAULT NULL
aktion_Sonderpreis: VARCHAR(10) DEFAULT NULL
aktion_Gutscheincode: VARCHAR(10) DEFAULT NULL
prop1: VARCHAR(50) DEFAULT NULL
prop2: VARCHAR(25) DEFAULT NULL
prop3: VARCHAR(25) DEFAULT NULL
prop4: VARCHAR(25) DEFAULT NULL
prop5: VARCHAR(50) DEFAULT NULL
prop10: VARCHAR(25) DEFAULT NULL
prop11: VARCHAR(25) DEFAULT NULL
prop12: VARCHAR(50) DEFAULT NULL
prop50: VARCHAR(25) DEFAULT NULL
prop51: VARCHAR(25) DEFAULT NULL
prop52: VARCHAR(25) DEFAULT NULL
prop53: VARCHAR(50) DEFAULT NULL
prop60: VARCHAR(25) DEFAULT NULL
prop61: VARCHAR(25) DEFAULT NULL
prop62: VARCHAR(25) DEFAULT NULL
prop63: VARCHAR(25) DEFAULT NULL
prop64: VARCHAR(50) DEFAULT NULL
enev_color: VARCHAR(10) DEFAULT NULL
enev_download: VARCHAR(100) DEFAULT NULL
enev_image: VARCHAR(100) DEFAULT NULL
enev_klasse: VARCHAR(10) DEFAULT NULL
enev_spectrumfrom: VARCHAR(10) DEFAULT NULL
enev_spectrum: VARCHAR(10) DEFAULT NULL
enev_active: VARCHAR(1) DEFAULT NULL
certification: VARCHAR(100) DEFAULT NULL
Mapping:
ordernumber: iwm_articles_new.ORDERNUMBER
mainnumber: iwm_articles_new.MAINNUMBER
arte: iwm_articles_new.MAINNUMBER
name_ost: IF (iwm_articles_new.LANGBEZEICHNUNG = '', iwm_articles_new.KURZBEZEICHNUNG, iwm_articles_new.LANGBEZEICHNUNG) as name_ost
name_tre: IF (iwm_articles_new.LANGBEZEICHNUNG = '', iwm_articles_new.KURZBEZEICHNUNG, iwm_articles_new.LANGBEZEICHNUNG) as name_tre
name_oms: IF (iwm_articles_new.LANGBEZEICHNUNG = '', iwm_articles_new.KURZBEZEICHNUNG, iwm_articles_new.LANGBEZEICHNUNG) as name_oms
supplier_ost: ()
supplier_tre: ()
supplier_oms: ()
tax: (19.00)
price_ost: ()
price_tre: ()
price_oms: ()
shipping_ost: ()
shipping_tre: ()
shipping_oms: ()
pseudoprice_ost: ()
pseudoprice_tre: ()
pseudoprice_oms: ()
purchaseprice: ()
baseprice: (1)
active_ost: (1)
active_tre: (1)
active_oms: (1)
description: ()
description_long_ost: ()
description_long_tre: ()
description_long_oms: ()
added:
Source: IF(iwm_articles_new.ADDED = '', '2020-01-01 00:00:00', iwm_articles_new.ADDED) AS added
changed:
Source: IF(iwm_articles_new.CHANGED = '', iwm_articles_new.ADDED, iwm_articles_new.CHANGED) AS changed
unitID: ()
# ean: IF (iwm_articles_new_eans_1.EAN = '', iwm_articles_new_eans_3.EAN, iwm_articles_new_eans_1.EAN) as ean
variant_ean: iwm_articles_new.variant_ean
variant_hbsn: iwm_articles_new.variant_hbsn
ean: iwm_articles_new.ean
attr9_strip: iwm_articles_new.ean
categories: ()
referenceUnit: (1)
purchaseUnit: ()
metaTitle: ()
packUnit: ()
configSetId: (1)
configuratorType: ()
configuratorOptions: ()
kind: (1)
suppliernumber_original: iwm_articles_new.LIEFERANTENNUMMER
suppliernumber: iwm_articles_new.LIEFERANTENNUMMER
weight: iwm_articles_new.WEIGHT
height: ()
width: iwm_articles_new.WIDTH
categoryPath_ost: ()
categoryPath_tre: ()
categoryPath_oms: ()
cat_google_produktart: ()
cat_google_shop_category: ()
cat_google: ()
cat_ebay: ()
cat_amazon: ()
propertyGroupName: ()
propertyValueName: ()
accessory: ()
attr1: iwm_articles_new.FIRMA
attr2: iwm_articles_new.HWG
attr3: iwm_articles_new.UWG
attr4: iwm_articles_new.SYSTEMNUMMER
attr5: iwm_articles_new.WARENPOOL
attr6: ()
attr7: ()
attr8: ()
attr9: iwm_articles_new.HBSN
attr10: ()
attr11: iwm_articles_new.DISPOART
attr12: iwm_articles_new.LIEFERZEITINWOCHEN
attr13: iwm_articles_new.VERSANDART
attr14: () #IWM Versand Addition
attr15: () #IWM Versandkosten
attr16: () #IWM Montagekosten
attr17: () #Textverwendungskennzeichen Mitbewerber Name
attr18: iwm_articles_new.ETIKETTENART
attr19: ()
attr20: () #IWM SEO Name - Artikelname angereichert mit weiteren Daten für Produktexporte
attr30: () #IWM SEO Name - Artikelname angereichert mit weiteren Daten für Produktexporte
attr31: () #IWM SEO Name - Artikelname angereichert mit weiteren Daten für Produktexporte
attr36: ()
attr37: () #shipping costs from dataEngine
attr38: () #shipping time from dataEngine
attr41: ()
attr48: ()
attr50: ()
attr53: ()
attr54: ()
attr55: ()
attr57: ()
attr60: ()
attr61: ()
attr67: ()
tpl_color_badge: ()
swag_attr23: ()
ItemImageDate: ()
imageUrl: ()
LBNTEK: ()
LBKALK: ()
LBMARGE: ()
LBWAEISA: ()
shippingfree: (0)
auslaufkennzeichen: ()
textilkennzeichen_needed: ()
textilkennzeichen_text: ()
has_textilkennzeichen: ()
pil_needed: ()
pil_needed_static: ()
pil_needed_dynamic: ()
pil_text: ()
has_pil: ()
AHLZSD: ()
ARKMFR: iwm_articles_new.ARKMFR
nutschicht: iwm_articles_new.nutschicht
stock_witten: ()
stock_ir: ()
stock_local: ()
ahstat: ()
bestellsperre: ()
mehrwertsteuerschluesselek: iwm_articles_new.mehrwertsteuerschluesselek
mehrwertsteuerschluesselvk: iwm_articles_new.mehrwertsteuerschluesselvk
lagernummer: iwm_articles_new.lagernummer
koje: iwm_articles_new.koje
material: iwm_articles_new.material
farbe: dynamic_mapping_colors.COLOR_NAME
aufbaukennzeichen: iwm_articles_new.aufbaukennzeichen
stil: iwm_articles_new.stil
anlieferart: iwm_articles_new.anlieferart
montageeinheiten: iwm_articles_new.montageeinheiten
dimensionsfolge: iwm_articles_new.dimensionsfolge
abmessung_dimension_1: iwm_articles_new.abmessung_dimension_1
abmessung_dimension_2: iwm_articles_new.abmessung_dimension_2
abmessung_dimension_3: iwm_articles_new.abmessung_dimension_3
tourenart: iwm_articles_new.tourenart
versandart: iwm_articles_new.versandart
groesse: iwm_articles_new.groesse
knuepfart: iwm_articles_new.knuepfart
variant_kurzbezeichnung: iwm_articles_new.variant_kurzbezeichnung
variant_langbezeichnung: iwm_articles_new.variant_langbezeichnung
variant_dimension_1: dynamic_mapping_variant_dimensions_AA01.dimension_name_AA01
variant_dimension_2: dynamic_mapping_variant_dimensions_AA02.dimension_name_AA02
variant_dimension_3: dynamic_mapping_variant_dimensions_AA03.dimension_name_AA03
# variant_dimension_1_value: IF (iwm_atab00.ATZUBZ = '', iwm_atab00.ATLABZ, iwm_atab00.ATZUBZ) as variant_dimension_1_value
# variant_dimension_2_value: IF (iwm_atab00.ATZUBZ = '', iwm_atab00.ATLABZ, iwm_atab00.ATZUBZ) as variant_dimension_2_value
# variant_dimension_3_value: IF (iwm_atab00.ATZUBZ = '', iwm_atab00.ATLABZ, iwm_atab00.ATZUBZ) as variant_dimension_2_value
instock: (0)
lieferzeit: ()
konsigniert: iwm_articles_new.konsigniert
zeltgut: iwm_articles_new.ZELTGUT
datenblatt: ()
datenblatt_needed: ()
has_datenblatt: ()
modellfamilie: ()
no_packstation: ()
gpsr_herstellerinfo: ()
gpsr_verantwortlicher: ()
ear_marke: ()
H_Name: ()
H_Strasse: ()
H_PLZOrt: ()
H_Email: ()
WEEE_RegNr: ()
aktion_Sonderpreis: ()
aktion_Gutscheincode: ()
prop1: () #Farbe
prop2: () #Breite
prop3: () #Länge
prop4: () #Höhe
prop5: () #Abmessung
prop10: () #Modell
prop11: () #Material
prop12: () #Raum
prop50: () #Matratze Größe
prop51: () #Matratze Härtegrad
prop52: () #Matratze Bezugsmaterial
prop53: () #Matratze Matratzenart
prop60: () #Teppich Flächengewicht
prop61: () #Teppich Florhöhe
prop62: () #Teppich Fußbodenheizung
prop63: () #Teppich Form
prop64: () #Teppich Muster
enev_color: ()
enev_download: ()
enev_image: ()
enev_klasse: ()
enev_spectrumfrom: ()
enev_spectrum: ()
enev_active: ()
certification: ()
Metadata
Erkannte Konfiguration
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Keine Metadaten verfügbar. |