Altbestand iwm_articles

Definition prüfen

Raw YAML Metadaten Run erst nach YAML-Reparatur
engine Typ
invalid Parse-Status
Managed Status
draft
YAML konnte nicht geparst werden Kurzinfo
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
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


Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    mainnumber: VARCHAR(255) DEFAULT NULL
    arte: VARCHAR(255) DEFAULT NULL
    name_ost: VARCHAR(255) DEFAULT NULL
    name_tre: VARCHAR(255) DEFAULT NULL
    name_oms: VARCHAR(255) DEFAULT NULL
    supplier_ost: VARCHAR(255) DEFAULT NULL
    supplier_tre: VARCHAR(255) DEFAULT NULL
    supplier_oms: VARCHAR(255) DEFAULT NULL
    tax: VARCHAR(255) DEFAULT NULL
    price_ost: VARCHAR(255) DEFAULT NULL
    price_tre: VARCHAR(255) DEFAULT NULL
    price_oms: VARCHAR(255) DEFAULT NULL
    pseudoprice_ost: VARCHAR(255) DEFAULT NULL
    pseudoprice_tre: VARCHAR(255) DEFAULT NULL
    pseudoprice_oms: VARCHAR(255) DEFAULT NULL
    baseprice: VARCHAR(255) 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
    ean: VARCHAR(255) DEFAULT NULL
    categories: VARCHAR(255) DEFAULT NULL
    purchaseprice: VARCHAR(255) DEFAULT NULL
    purchaseprice: VARCHAR(255) DEFAULT NULL
    referenceUnit: VARCHAR(255) DEFAULT NULL
    purchaseUnit: VARCHAR(255) DEFAULT NULL
    metaTitle: VARCHAR(255) DEFAULT NULL
    packUnit: VARCHAR(255) DEFAULT NULL
    configSetId: INT(11) DEFAULT NULL
    packUnit: VARCHAR(255) DEFAULT NULL
    configuratorType: VARCHAR(255) DEFAULT NULL
    configuratorOptions: VARCHAR(255) DEFAULT NULL
    kind: VARCHAR(255) DEFAULT NULL
    suppliernumber_original: VARCHAR(255) DEFAULT NULL
    suppliernumber: VARCHAR(255) DEFAULT NULL
    weight: VARCHAR(255) DEFAULT NULL
    height: VARCHAR(255) DEFAULT NULL
    width: VARCHAR(255) DEFAULT NULL
    categoryPath_ost: TEXT DEFAULT NULL
    categoryPath_tre: TEXT DEFAULT NULL
    categoryPath_oms: 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
    instock: INT(11) DEFAULT NULL
    accessory: VARCHAR(255) DEFAULT NULL
    attr1: VARCHAR(255) NOT NULL
    attr2: VARCHAR(255) DEFAULT NULL
    attr3: VARCHAR(255) DEFAULT NULL
    attr3: VARCHAR(255) DEFAULT NULL
    attr4: VARCHAR(255) DEFAULT NULL
    attr5: VARCHAR(255) DEFAULT NULL
    attr6: VARCHAR(255) DEFAULT NULL
    attr7: VARCHAR(255) DEFAULT NULL
    attr8: VARCHAR(255) DEFAULT NULL
    attr9: VARCHAR(255) DEFAULT NULL
    attr10: VARCHAR(255) DEFAULT NULL
    attr11: VARCHAR(255) DEFAULT NULL
    attr12: VARCHAR(255) DEFAULT NULL
    attr13: VARCHAR(255) DEFAULT NULL
    attr14: VARCHAR(255) DEFAULT NULL
    attr15: VARCHAR(255) DEFAULT NULL
    attr16: VARCHAR(255) DEFAULT NULL
    attr17: VARCHAR(255) DEFAULT NULL
    attr18: VARCHAR(255) DEFAULT NULL
    attr19: VARCHAR(255) DEFAULT NULL
    attr20: VARCHAR(255) DEFAULT NULL
    swag_attr21: TEXT DEFAULT NULL
    swag_attr22: VARCHAR(255) DEFAULT NULL
    swag_attr23: VARCHAR(255) DEFAULT NULL
    swag_attr24: VARCHAR(255) DEFAULT NULL
    swag_attr25: VARCHAR(255) DEFAULT NULL
    swag_attr26: VARCHAR(255) DEFAULT NULL
    swag_attr27: VARCHAR(255) DEFAULT NULL
    swag_attr28: TEXT DEFAULT NULL
    swag_attr29: VARCHAR(255) DEFAULT NULL
    attr30: VARCHAR(255) DEFAULT NULL
    attr31: VARCHAR(255) 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: INT(11) DEFAULT NULL
    bestellsperre: VARCHAR(10) 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_text: TEXT DEFAULT NULL
    has_pil: VARCHAR(10) DEFAULT NULL
    AHLZSD: VARCHAR(10) DEFAULT NULL
    ARKMFR: VARCHAR(10) DEFAULT NULL
    nutschicht: VARCHAR(10) DEFAULT NULL
    has_textilkennzeichen: VARCHAR(10) DEFAULT NULL
    has_textilkennzeichen: VARCHAR(10) DEFAULT NULL
    stock_witten: VARCHAR(10) DEFAULT NULL
    stock_ir: VARCHAR(10) DEFAULT NULL
    stock_local: VARCHAR(10) DEFAULT NULL
    datenblatt: VARCHAR(100) DEFAULT NULL
    datenblatt_needed: VARCHAR(2) DEFAULT NULL
    has_datenblatt: VARCHAR(2) DEFAULT NULL
    ahstat: VARCHAR(10) DEFAULT NULL
    prop1: VARCHAR(255) DEFAULT NULL
    prop2: VARCHAR(255) DEFAULT NULL
    prop3: VARCHAR(255) DEFAULT NULL
    prop4: VARCHAR(255) DEFAULT NULL
    prop5: VARCHAR(255) DEFAULT NULL
    prop10: VARCHAR(255) DEFAULT NULL
    prop11: VARCHAR(255) DEFAULT NULL
    prop12: VARCHAR(255) DEFAULT NULL
    prop50: VARCHAR(255) DEFAULT NULL
    prop51: VARCHAR(255) DEFAULT NULL
    prop52: VARCHAR(255) DEFAULT NULL
    prop53: VARCHAR(255) DEFAULT NULL
    prop60: VARCHAR(255) DEFAULT NULL
    prop61: VARCHAR(255) DEFAULT NULL
    prop62: VARCHAR(255) DEFAULT NULL
    prop63: VARCHAR(255) DEFAULT NULL
    prop64: VARCHAR(255) 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


Mapping:
    ordernumber: IF(iwm_articles.ItemAspr = 0, IFNULL(iwm_articles.ItemNo,0), IFNULL(iwm_articles.VariationNo,0)) AS ordernumber
    mainnumber:
      Source: iwm_articles.ItemNo
    arte: iwm_articles.ItemNo
    name_ost: iwm_articles.ItemTextName_ost
    name_tre: iwm_articles.ItemTextName_tre
    name_oms: iwm_articles.ItemTextName_oms
    supplier_ost: iwm_articles.ItemProducer_ost
    supplier_tre: iwm_articles.ItemProducer_tre
    supplier_oms: iwm_articles.ItemProducer_oms
    tax: (19.00)
    price_ost: iwm_articles.Price1_ost
    price_tre: iwm_articles.Price1_tre
    price_oms: iwm_articles.Price1_oms
    pseudoprice_ost: iwm_articles.ItemMRP_ost
    pseudoprice_tre: iwm_articles.ItemMRP_tre
    pseudoprice_oms: iwm_articles.ItemMRP_oms
    baseprice: (1)
    active_ost:
      Source: IF(iwm_articles.ItemInactive_ost = 0, 1, 0) AS active_ost
    active_tre:
      Source: IF(iwm_articles.ItemInactive_tre = 0, 1, 0) AS active_tre
    active_oms:
      Source: IF(iwm_articles.ItemVisibilityWebshop_oms = 1, 1, 0) AS active_oms
    description: ()
    description_long_ost:
      Source: iwm_articles.ItemTextDescription_ost
      Field_Adapter:
    description_long_tre: iwm_articles.ItemTextDescription_tre
    description_long_oms: iwm_articles.ItemTextDescription_oms
    added: (2018-08-01 00:00:00)
    changed: (2018-08-01 00:00:00)
    unitID: ()
    ean: iwm_articles.ItemEAN
    categories: ()
    purchaseprice: ()
    purchaseprice: ()
    referenceUnit: (1)
    purchaseUnit: ()
    metaTitle: ()
    packUnit: ()
    configSetId: (1)
    configuratorType: ()
    configuratorOptions:
      Source: CONCAT(iwm_articles.AttributName1,':',iwm_articles.AttributeValue1,'|',iwm_articles.AttributName2,':',iwm_articles.AttributeValue2,'|',iwm_articles.AttributName3,':',iwm_articles.AttributeValue3) as configuratorOptions
      Field_Adapter:
        - replace: [':|:|:', '']
        - replace: ['|:', '']
        - replace: ['|:', '']
    kind: (1)
    suppliernumber_original: iwm_articles.ItemProducerID
    suppliernumber: iwm_articles.ItemProducerID
    weight: iwm_articles.PriceWeight
    height: iwm_articles.PriceHeight
    width: iwm_articles.PriceWidth
    categoryPath_ost:
      Source: CONCAT('Deutsch->', iwm_articles.ItemCategories_ost) as categoryPath_ost
    categoryPath_tre:
      Source: CONCAT('Deutsch->', iwm_articles.ItemCategories_tre) as categoryPath_tre
    categoryPath_oms:
      Source: CONCAT('Deutsch->', iwm_articles.ItemCategories_oms) as categoryPath_oms
    cat_google: ()
    cat_ebay: ()
    cat_amazon: ()
    propertyGroupName: ()
    propertyValueName: ()
    accessory: ()
    attr1: iwm_articles.ItemFreeTextField1
    attr2: iwm_articles.ItemFreeTextField2
    attr3: iwm_articles.ItemFreeTextField3
    attr4: iwm_articles.ItemFreeTextField4
    attr5: iwm_articles.ItemFreeTextField5
    attr6: iwm_articles.ItemFreeTextField6
    attr7: iwm_articles.ItemFreeTextField7
    attr8: iwm_articles.ItemFreeTextField8
    attr9: iwm_articles.ItemFreeTextField9
    attr10: iwm_articles.ItemFreeTextField10
    attr11: iwm_articles.ItemFreeTextField11
    attr12: iwm_articles.ItemFreeTextField12
    attr13: iwm_articles.ItemFreeTextField13
    attr14: iwm_articles.ItemFreeTextField14
    attr15: iwm_articles.ItemFreeTextField15
    attr16: iwm_articles.ItemFreeTextField16
    attr17: iwm_articles.ItemFreeTextField17
    attr18: iwm_articles.ItemFreeTextField18
    attr19: iwm_articles.ItemFreeTextField19
    attr20: iwm_articles.ItemFreeTextField20
    swag_attr21: ()
    swag_attr22: iwm_articles.swag_attr22
    swag_attr23: ()
    swag_attr24: iwm_articles.swag_attr24
    swag_attr25: iwm_articles.swag_attr25
    swag_attr26: () #konsignierte Ware
    swag_attr27: ()
    swag_attr28: ()
    swag_attr29: ()
    attr30: ()
    attr31: ()
    stockmin_ost: iwm_articles.ItemLimitOrderByStock_ost
    stockmin_tre: iwm_articles.ItemLimitOrderByStock_tre
    stockmin_oms: iwm_articles.ItemLimitOrderByStock_oms
    ItemImageDate: iwm_articles.ItemImageDate
    imageUrl: iwm_articles.imageUrl
    LBNTEK: iwm_articles.LBNTEK
    LBKALK: iwm_articles.LBKALK
    LBMARGE: iwm_articles.LBMARGE
    LBWAEISA: iwm_articles.LBWAEISA
    AbsatzMenge3M: iwm_articles.AbsatzMenge3M
    shippingfree: iwm_articles.shippingfree
    instock: (0)
    bestellsperre: ()
    auslaufkennzeichen: ()
    textilkennzeichen_needed: ()
    textilkennzeichen_text: ()
    has_textilkennzeichen: ()
    pil_needed: ()
    pil_text: ()
    has_pil: ()
    AHLZSD: ()
    ARKMFR: ()
    nutschicht: ()
    stock_witten: ()
    stock_ir: ()
    stock_local: ()
    ahstat: ()
    datenblatt: ()
    datenblatt_needed: ()
    has_datenblatt: ()
    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: ()
Source
Datei und Status

Dateipfad: /srv/app/backend/unitize/unitizeEngines/iwm_articles.yaml
Runner: unitize
Feature Flags: keine erkannt
Connections: keine erkannt
Hinweis
Diese Legacy-Datei konnte aktuell nicht geparst werden. Du kannst sie trotzdem als Managed Draft importieren und dort reparieren.
Metadata
Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
Keine Metadaten verfügbar.