Legacy YAML / Detail

enhance / enhance_articles_new_new

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live
Zurück zum Browser
Managed Definition öffnen

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.

Zum Raw YAML Zu den Metadaten
engine Typ
valid Parse-Status
Managed Status
draft
articles_new Kurzinfo

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: enhanceEngine #config - credentials of target connection service

Enhance_Mode: flexible

#Engine Mode
Engine_Mode: delta


#Source
Source_Datapool: articles_inhouse  #sql from

Order_By: ordernumber ASC



Exclude_From_Hash: [instock, stock_ir, stock_witten, swag_attr23, attr30, attr31, attr37_pre_oms, attr37_pre_ost, attr37_pre_tre, attr37]


#Target
Datapool: articles_new #sql table
Target_Datapool: articles_new  #sql from
Primary_Key: [ordernumber, attr1]



#Mapping -> Mappings source fields are detected by Mapping
Mapping:
    ordernumber: articles_inhouse.ordernumber
    mainnumber: articles_inhouse.mainnumber
    arte: articles_inhouse.arte
    name_oms: articles_inhouse.name_oms
    name_tre: articles_inhouse.name_tre
    name_ost: articles_inhouse.name_ost
    tax: articles_inhouse.tax
    price_ost: ()
    price_tre: ()
    price_oms: ()
    shipping_ost: ()
    shipping_tre: ()
    shipping_oms: ()
    pseudoprice_ost: ()
    pseudoprice_tre: ()
    pseudoprice_oms: ()
    purchaseprice: articles_inhouse.purchaseprice
    baseprice: articles_inhouse.baseprice
    active_ost: articles_inhouse.active_ost
    active_tre: articles_inhouse.active_tre
    active_oms: articles_inhouse.active_oms
    description: articles_inhouse.description
    description_long_ost: articles_inhouse.description_long_ost
    description_long_tre: articles_inhouse.description_long_tre
    description_long_oms: articles_inhouse.description_long_oms
    added: articles_inhouse.added
    changed: articles_inhouse.changed
    unitID: articles_inhouse.unitID
    attr9: articles_inhouse.attr9
    variant_ean: articles_inhouse.variant_ean
    suppliernumber_original: articles_inhouse.suppliernumber_original
    suppliernumber: articles_inhouse.suppliernumber
    ean: articles_inhouse.ean
    attr9_strip: articles_inhouse.attr9
    categories: articles_inhouse.categories
    referenceUnit: articles_inhouse.referenceUnit
    supplier_ost: articles_inhouse.supplier_ost
    supplier_tre: articles_inhouse.supplier_tre
    supplier_oms: articles_inhouse.supplier_oms
    purchaseUnit: articles_inhouse.purchaseUnit
    metaTitle: articles_inhouse.metaTitle
    packUnit: articles_inhouse.packUnit
    configSetId: articles_inhouse.configSetId
    configuratorType: articles_inhouse.configuratorType
    configuratorOptions: articles_inhouse.configuratorOptions
    kind: articles_inhouse.kind
    weight: articles_inhouse.weight
    height: articles_inhouse.height
    width: articles_inhouse.width
    swag_attr27: articles_inhouse.swag_attr27
    categoryPath_ost: articles_inhouse.categoryPath_ost
    categoryPath_tre: articles_inhouse.categoryPath_tre
    categoryPath_oms: articles_inhouse.categoryPath_oms
    cat_google_produktart: articles_inhouse.cat_google_produktart
    cat_google_shop_category: articles_inhouse.cat_google
    cat_google: articles_inhouse.cat_google
    cat_ebay: articles_inhouse.cat_ebay
    cat_amazon: articles_inhouse.cat_amazon
    propertyGroupName: articles_inhouse.propertyGroupName
    propertyValueName: articles_inhouse.propertyValueName
    farbe: articles_inhouse.farbe
    material: articles_inhouse.material
    accessory: articles_inhouse.accessory
    attr1: articles_inhouse.attr1
    attr2: articles_inhouse.attr2
    attr3: articles_inhouse.attr3
    attr4: articles_inhouse.attr4
    attr5: articles_inhouse.attr5
    attr6:  articles_inhouse.attr6
    attr7: articles_inhouse.attr7
    attr8: articles_inhouse.attr8
    attr10: articles_inhouse.attr10
    attr11: articles_inhouse.attr11
    anlieferart: articles_inhouse.anlieferart
    stock_ir: articles_inhouse.stock_ir
    instock: articles_inhouse.instock
    attr12: articles_inhouse.attr12
    attr13: articles_inhouse.attr13
    attr14: articles_inhouse.attr14
    attr16: articles_inhouse.attr16
    attr17: articles_inhouse.attr17
    attr18: articles_inhouse.attr18
    attr19: articles_inhouse.attr19
    swag_attr23: articles_inhouse.swag_attr23
    swag_attr21: articles_inhouse.swag_attr21
    swag_attr24: articles_inhouse.swag_attr24
    swag_attr25: articles_inhouse.swag_attr25
    swag_attr26: articles_inhouse.swag_attr26
    attr15: articles_inhouse.attr15
    swag_attr29: articles_inhouse.swag_attr29 #carrier
    attr30: articles_inhouse.attr30
    attr31: articles_inhouse.attr31
    attr36: () #finanzierbare produkte -> gefüllt im export
    imageUrl: articles_inhouse.imageUrl
    ItemImageDate: articles_inhouse.ItemImageDate
    stock_witten: articles_inhouse.stock_witten
    shippingfree: articles_inhouse.shippingfree
    attr37_pre_oms: articles_inhouse.attr37_pre_oms
    attr37_pre_ost: articles_inhouse.attr37_pre_ost
    attr37_pre_tre: articles_inhouse.attr37_pre_tre
    attr37: articles_inhouse.attr37
    attr38: articles_inhouse.attr38
    attr41: articles_inhouse.attr41
    attr48: articles_inhouse.attr48
    attr50: articles_inhouse.attr50
    attr53: articles_inhouse.attr53
    attr54: articles_inhouse.attr54
    attr55: articles_inhouse.attr55
    attr57: articles_inhouse.attr57
    attr60: articles_inhouse.attr60
    attr61: articles_inhouse.attr61
    tpl_color_badge:  articles_inhouse.tpl_color_badge
    textilkennzeichen_text: articles_inhouse.textilkennzeichen_text
    AHLZSD: articles_inhouse.AHLZSD
    ARKMFR: articles_inhouse.ARKMFR
    nutschicht: articles_inhouse.nutschicht
    textilkennzeichen_needed: articles_inhouse.textilkennzeichen_needed
    has_textilkennzeichen: articles_inhouse.has_textilkennzeichen
    pil_needed_static: articles_inhouse.pil_needed_static
    pil_needed_dynamic: articles_inhouse.pil_needed_dynamic
    pil_needed: articles_inhouse.pil_needed
    pil_text: articles_inhouse.pil_text
    has_pil: articles_inhouse.has_pil
    ahstat: articles_inhouse.ahstat
    LBNTEK: articles_inhouse.LBNTEK
    LBKALK: ()
    mehrwertsteuerschluesselek: articles_inhouse.mehrwertsteuerschluesselek
    mehrwertsteuerschluesselvk: articles_inhouse.mehrwertsteuerschluesselvk
    lagernummer: articles_inhouse.lagernummer
    koje: articles_inhouse.koje
    aufbaukennzeichen: articles_inhouse.aufbaukennzeichen
    stil: articles_inhouse.stil
    montageeinheiten: articles_inhouse.montageeinheiten
    dimensionsfolge: articles_inhouse.dimensionsfolge
    abmessung_dimension_1: articles_inhouse.abmessung_dimension_1
    abmessung_dimension_2: articles_inhouse.abmessung_dimension_2
    abmessung_dimension_3: articles_inhouse.abmessung_dimension_3
    tourenart: articles_inhouse.tourenart
    versandart: articles_inhouse.versandart
    groesse: articles_inhouse.groesse
    knuepfart: articles_inhouse.knuepfart
    variant_hbsn: articles_inhouse.variant_hbsn
    variant_kurzbezeichnung: articles_inhouse.variant_kurzbezeichnung
    variant_langbezeichnung: articles_inhouse.variant_langbezeichnung
    bestellsperre: articles_inhouse.bestellsperre
    auslaufkennzeichen: articles_inhouse.auslaufkennzeichen
    konsigniert: articles_inhouse.konsigniert
    zeltgut: articles_inhouse.zeltgut
    lieferzeit: articles_inhouse.lieferzeit
    gpsr_herstellerinfo: articles_inhouse.gpsr_herstellerinfo
    gpsr_verantwortlicher: articles_inhouse.gpsr_verantwortlicher
    ear_marke: articles_inhouse.ear_marke
    H_Name: articles_inhouse.H_Name
    H_Strasse: articles_inhouse.H_Strasse
    H_PLZOrt: articles_inhouse.H_PLZOrt
    H_Email: articles_inhouse.H_Email
    WEEE_RegNr: articles_inhouse.WEEE_RegNr
    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
    attr20: articles_inhouse.attr20
    enev_klasse: articles_inhouse.enev_klasse
    enev_color: articles_inhouse.enev_color
    enev_download: articles_inhouse.enev_download
    enev_image: articles_inhouse.enev_image
    enev_spectrumfrom: articles_inhouse.enev_spectrumfrom
    enev_spectrum: articles_inhouse.enev_spectrum
    enev_active: articles_inhouse.enev_active
    certification: articles_inhouse.certification
    swag_attr28: articles_inhouse.swag_attr28
    datenblatt: articles_inhouse.datenblatt
    has_datenblatt: articles_inhouse.has_datenblatt
    datenblatt_needed: articles_inhouse.datenblatt_needed
    modellfamilie: articles_inhouse.modellfamilie
    no_packstation: articles_inhouse.no_packstation


Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - 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'

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Source_Config enhanceEngine
Target_Config enhanceEngine
Enhance_Mode flexible
Engine_Mode delta
Source_Datapool articles_inhouse
Order_By ordernumber ASC
Exclude_From_Hash [ "instock", "stock_ir", "stock_witten", "swag_attr23", "attr30", "attr31", "attr37_pre_oms", "attr37_pre_ost", "attr37_pre_tre", "attr37" ]
Datapool articles_new
Target_Datapool articles_new
Primary_Key [ "ordernumber", "attr1" ]
Mapping { "ordernumber": "articles_inhouse.ordernumber", "mainnumber": "articles_inhouse.mainnumber", "arte": "articles_inhouse.arte", "name_oms": "articles_inhouse.name_oms", "name_tre": "articles_inhouse.name_tre", "name_ost": "articles_inhouse.name_ost", "tax": "articles_inhouse.tax", "price_ost": "()", "price_tre": "()", "price_oms": "()", "shipping_ost": "()", "shipping_tre": "()", "shipping_oms": "()", "pseudoprice_ost": "()", "pseudoprice_tre": "()", "pseudoprice_oms": "()", "purchaseprice": "articles_inhouse.purchaseprice", "baseprice": "articles_inhouse.baseprice", "active_ost": "articles_inhouse.active_ost", "active_tre": "articles_inhouse.active_tre", "active_oms": "articles_inhouse.active_oms", "description": "articles_inhouse.description", "description_long_ost": "articles_inhouse.description_long_ost", "description_long_tre": "articles_inhouse.description_long_tre", "description_long_oms": "articles_inhouse.description_long_oms", "added": "articles_inhouse.added", "changed": "articles_inhouse.changed", "unitID": "articles_inhouse.unitID", "attr9": "articles_inhouse.attr9", "variant_ean": "articles_inhouse.variant_ean", "suppliernumber_original": "articles_inhouse.suppliernumber_original", "suppliernumber": "articles_inhouse.suppliernumber", "ean": "articles_inhouse.ean", "attr9_strip": "articles_inhouse.attr9", "categories": "articles_inhouse.categories", "referenceUnit": "articles_inhouse.referenceUnit", "supplier_ost": "articles_inhouse.supplier_ost", "supplier_tre": "articles_inhouse.supplier_tre", "supplier_oms": "articles_inhouse.supplier_oms", "purchaseUnit": "articles_inhouse.purchaseUnit", "metaTitle": "articles_inhouse.metaTitle", "packUnit": "articles_inhouse.packUnit", "configSetId": "articles_inhouse.configSetId", "configuratorType": "articles_inhouse.configuratorType", "configuratorOptions": "articles_inhouse.configuratorOptions", "kind": "articles_inhouse.kind", "weight": "articles_inhouse.weight", "height": "articles_inhouse.height", "width": "articles_inhouse.width", "swag_attr27": "articles_inhouse.swag_attr27", "categoryPath_ost": "articles_inhouse.categoryPath_ost", "categoryPath_tre": "articles_inhouse.categoryPath_tre", "categoryPath_oms": "articles_inhouse.categoryPath_oms", "cat_google_produktart": "articles_inhouse.cat_google_produktart", "cat_google_shop_category": "articles_inhouse.cat_google", "cat_google": "articles_inhouse.cat_google", "cat_ebay": "articles_inhouse.cat_ebay", "cat_amazon": "articles_inhouse.cat_amazon", "propertyGroupName": "articles_inhouse.propertyGroupName", "propertyValueName": "articles_inhouse.propertyValueName", "farbe": "articles_inhouse.farbe", "material": "articles_inhouse.material", "accessory": "articles_inhouse.accessory", "attr1": "articles_inhouse.attr1", "attr2": "articles_inhouse.attr2", "attr3": "articles_inhouse.attr3", "attr4": "articles_inhouse.attr4", "attr5": "articles_inhouse.attr5", "attr6": "articles_inhouse.attr6", "attr7": "articles_inhouse.attr7", "attr8": "articles_inhouse.attr8", "attr10": "articles_inhouse.attr10", "attr11": "articles_inhouse.attr11", "anlieferart": "articles_inhouse.anlieferart", "stock_ir": "articles_inhouse.stock_ir", "instock": "articles_inhouse.instock", "attr12": "articles_inhouse.attr12", "attr13": "articles_inhouse.attr13", "attr14": "articles_inhouse.attr14", "attr16": "articles_inhouse.attr16", "attr17": "articles_inhouse.attr17", "attr18": "articles_inhouse.attr18", "attr19": "articles_inhouse.attr19", "swag_attr23": "articles_inhouse.swag_attr23", "swag_attr21": "articles_inhouse.swag_attr21", "swag_attr24": "articles_inhouse.swag_attr24", "swag_attr25": "articles_inhouse.swag_attr25", "swag_attr26": "articles_inhouse.swag_attr26", "attr15": "articles_inhouse.attr15", "swag_attr29": "articles_inhouse.swag_attr29", "attr30": "articles_inhouse.attr30", "attr31": "articles_inhouse.attr31", "attr36": "()", "imageUrl": "articles_inhouse.imageUrl", "ItemImageDate": "articles_inhouse.ItemImageDate", "stock_witten": "articles_inhouse.stock_witten", "shippingfree": "articles_inhouse.shippingfree", "attr37_pre_oms": "articles_inhouse.attr37_pre_oms", "attr37_pre_ost": "articles_inhouse.attr37_pre_ost", "attr37_pre_tre": "articles_inhouse.attr37_pre_tre", "attr37": "articles_inhouse.attr37", "attr38": "articles_inhouse.attr38", "attr41": "articles_inhouse.attr41", "attr48": "articles_inhouse.attr48", "attr50": "articles_inhouse.attr50", "attr53": "articles_inhouse.attr53", "attr54": "articles_inhouse.attr54", "attr55": "articles_inhouse.attr55", "attr57": "articles_inhouse.attr57", "attr60": "articles_inhouse.attr60", "attr61": "articles_inhouse.attr61", "tpl_color_badge": "articles_inhouse.tpl_color_badge", "textilkennzeichen_text": "articles_inhouse.textilkennzeichen_text", "AHLZSD": "articles_inhouse.AHLZSD", "ARKMFR": "articles_inhouse.ARKMFR", "nutschicht": "articles_inhouse.nutschicht", "textilkennzeichen_needed": "articles_inhouse.textilkennzeichen_needed", "has_textilkennzeichen": "articles_inhouse.has_textilkennzeichen", "pil_needed_static": "articles_inhouse.pil_needed_static", "pil_needed_dynamic": "articles_inhouse.pil_needed_dynamic", "pil_needed": "articles_inhouse.pil_needed", "pil_text": "articles_inhouse.pil_text", "has_pil": "articles_inhouse.has_pil", "ahstat": "articles_inhouse.ahstat", "LBNTEK": "articles_inhouse.LBNTEK", "LBKALK": "()", "mehrwertsteuerschluesselek": "articles_inhouse.mehrwertsteuerschluesselek", "mehrwertsteuerschluesselvk": "articles_inhouse.mehrwertsteuerschluesselvk", "lagernummer": "articles_inhouse.lagernummer", "koje": "articles_inhouse.koje", "aufbaukennzeichen": "articles_inhouse.aufbaukennzeichen", "stil": "articles_inhouse.stil", "montageeinheiten": "articles_inhouse.montageeinheiten", "dimensionsfolge": "articles_inhouse.dimensionsfolge", "abmessung_dimension_1": "articles_inhouse.abmessung_dimension_1", "abmessung_dimension_2": "articles_inhouse.abmessung_dimension_2", "abmessung_dimension_3": "articles_inhouse.abmessung_dimension_3", "tourenart": "articles_inhouse.tourenart", "versandart": "articles_inhouse.versandart", "groesse": "articles_inhouse.groesse", "knuepfart": "articles_inhouse.knuepfart", "variant_hbsn": "articles_inhouse.variant_hbsn", "variant_kurzbezeichnung": "articles_inhouse.variant_kurzbezeichnung", "variant_langbezeichnung": "articles_inhouse.variant_langbezeichnung", "bestellsperre": "articles_inhouse.bestellsperre", "auslaufkennzeichen": "articles_inhouse.auslaufkennzeichen", "konsigniert": "articles_inhouse.konsigniert", "zeltgut": "articles_inhouse.zeltgut", "lieferzeit": "articles_inhouse.lieferzeit", "gpsr_herstellerinfo": "articles_inhouse.gpsr_herstellerinfo", "gpsr_verantwortlicher": "articles_inhouse.gpsr_verantwortlicher", "ear_marke": "articles_inhouse.ear_marke", "H_Name": "articles_inhouse.H_Name", "H_Strasse": "articles_inhouse.H_Strasse", "H_PLZOrt": "articles_inhouse.H_PLZOrt", "H_Email": "articles_inhouse.H_Email", "WEEE_RegNr": "articles_inhouse.WEEE_RegNr", "prop1": "()", "prop2": "()", "prop3": "()", "prop4": "()", "prop5": "()", "prop10": "()", "prop11": "()", "prop12": "()", "prop50": "()", "prop51": "()", "prop52": "()", "prop53": "()", "prop60": "()", "prop61": "()", "prop62": "()", "prop63": "()", "prop64": "()", "attr20": "articles_inhouse.attr20", "enev_klasse": "articles_inhouse.enev_klasse", "enev_color": "articles_inhouse.enev_color", "enev_download": "articles_inhouse.enev_download", "enev_image": "articles_inhouse.enev_image", "enev_spectrumfrom": "articles_inhouse.enev_spectrumfrom", "enev_spectrum": "articles_inhouse.enev_spectrum", "enev_active": "articles_inhouse.enev_active", "certification": "articles_inhouse.certification", "swag_attr28": "articles_inhouse.swag_attr28", "datenblatt": "articles_inhouse.datenblatt", "has_datenblatt": "articles_inhouse.has_datenblatt", "datenblatt_needed": "articles_inhouse.datenblatt_needed", "modellfamilie": "articles_inhouse.modellfamilie", "no_packstation": "articles_inhouse.no_packstation" }
Filters [ { "Filter": { "name": "kein Bild", "condition": { "Cross_Dataset_Filter_Adapter": "enhance_articles_ost__filterNoPicture" }, "reason": "kein Bild" } } ]