Legacy YAML / Detail

export / export_articles_sw6.dev.oms_combined

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
export_articles_sw6_dev_oms_combined 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: exportEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Mysql_Engine: InnoDB
Default_Charset: latin1

Source_Datapool: articles_new  #sql from


Sql: SELECT * FROM export_articles_sw6_dev_oms
  UNION
  SELECT * FROM export_articles_parents_sw6


Read_Conditions:  #sql where - Read-Filter
  - articles_new.active_oms = 1

Order_By: ordernumber ASC

Datapool_Definition:
  ordernumber: VARCHAR(255) NOT NULL
  mainnumber: VARCHAR(255) DEFAULT NULL
  productnumber: VARCHAR(255) DEFAULT NULL
  name: VARCHAR(350) DEFAULT NULL
  supplier: VARCHAR(255) DEFAULT NULL
  taxName: VARCHAR(10) DEFAULT NULL
  taxValue: VARCHAR(10) DEFAULT NULL
  tax_id: VARCHAR(10) DEFAULT NULL
  price_EK: VARCHAR(255) DEFAULT NULL
  price_gross: VARCHAR(255) DEFAULT NULL
  pseudoprice_EK: VARCHAR(255) DEFAULT NULL
  baseprice_EK: VARCHAR(255) DEFAULT NULL
  active: VARCHAR(2) DEFAULT NULL
  configurator_options: VARCHAR(100) DEFAULT NULL
  supplier_number: VARCHAR(10) DEFAULT NULL
  attr1: VARCHAR(2) 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
  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(10) 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
  attr21: VARCHAR(255) DEFAULT NULL
  attr22: VARCHAR(255) DEFAULT NULL
  attr23: VARCHAR(10) DEFAULT NULL
  attr24: VARCHAR(255) DEFAULT NULL
  attr25: VARCHAR(10) DEFAULT NULL
  attr26: VARCHAR(10) DEFAULT NULL
  attr27: VARCHAR(50) DEFAULT NULL
  attr28: TEXT DEFAULT NULL
  attr29: VARCHAR(10) DEFAULT NULL
  attr30: VARCHAR(10) DEFAULT NULL
  attr31: VARCHAR(10) DEFAULT NULL
  attr32: VARCHAR(10) DEFAULT NULL
  attr33: VARCHAR(100) DEFAULT NULL
  attr34: VARCHAR(255) DEFAULT NULL
  attr35: VARCHAR(100) DEFAULT NULL
  attr36: VARCHAR(10) DEFAULT NULL
  attr41: VARCHAR(10) DEFAULT NULL
  attr43: VARCHAR(10) DEFAULT NULL
  ean: VARCHAR(255) DEFAULT NULL
  weight: VARCHAR(10) DEFAULT NULL
  stock: VARCHAR(8) DEFAULT NULL
  kind: VARCHAR(10) DEFAULT NULL
  shipping_free: VARCHAR(2) DEFAULT NULL
  attr37: VARCHAR(100) DEFAULT NULL
  attr37_orig: VARCHAR(100) DEFAULT NULL
  attr8: VARCHAR(10) DEFAULT NULL
  attr49: VARCHAR(20) DEFAULT NULL
  attr50: VARCHAR(10) DEFAULT NULL
  attr51: VARCHAR(10) DEFAULT NULL
  attr52: VARCHAR(10) DEFAULT NULL
  description_long: TEXT DEFAULT NULL
  LBNTEK: VARCHAR(10) DEFAULT NULL
  LBKALK: VARCHAR(10) DEFAULT NULL
  attr53: VARCHAR(25) DEFAULT NULL
  attr54: VARCHAR(10) DEFAULT NULL
  attr55: VARCHAR(25) DEFAULT NULL
  attr56: LONGTEXT DEFAULT NULL
  attr57: LONGTEXT DEFAULT NULL
  attr58: LONGTEXT DEFAULT NULL
  attr59: LONGTEXT DEFAULT NULL
  attr60: LONGTEXT DEFAULT NULL
  attr61: VARCHAR(255)
  attr65: TEXT DEFAULT NULL
  attr66: TEXT DEFAULT NULL
  tpl_color_badge: VARCHAR(2) DEFAULT NULL
  bestellsperre: VARCHAR(10) DEFAULT NULL
  auslaufkennzeichen: VARCHAR(10) DEFAULT NULL
  prop1: VARCHAR(50) DEFAULT NULL
  prop2: VARCHAR(50) DEFAULT NULL
  prop3: VARCHAR(50) DEFAULT NULL
  prop4: VARCHAR(50) DEFAULT NULL
  prop5: VARCHAR(50) DEFAULT NULL
  prop10: VARCHAR(50) DEFAULT NULL
  prop11: VARCHAR(50) DEFAULT NULL
  prop12: VARCHAR(50) DEFAULT NULL
  prop50: VARCHAR(50) DEFAULT NULL
  prop51: VARCHAR(50) DEFAULT NULL
  prop52: VARCHAR(50) DEFAULT NULL
  prop53: VARCHAR(50) DEFAULT NULL
  prop60: VARCHAR(50) DEFAULT NULL
  prop61: VARCHAR(50) DEFAULT NULL
  prop62: VARCHAR(50) DEFAULT NULL
  prop63: VARCHAR(50) DEFAULT NULL
  prop64: VARCHAR(50) DEFAULT NULL
  prop_status: VARCHAR(50) DEFAULT NULL
  enev_color: VARCHAR(50) DEFAULT NULL
  enev_download: VARCHAR(255) DEFAULT NULL
  enev_image: VARCHAR(255) DEFAULT NULL
  enev_klasse: VARCHAR(255) DEFAULT NULL
  enev_spectrumfrom: VARCHAR(255) DEFAULT NULL
  enev_spectrum: VARCHAR(255) DEFAULT NULL
  enev_active: VARCHAR(2) DEFAULT NULL





#Mapping -> Mappings source fields are detected by Mapping
Mapping:
  ordernumber:
    Source: ordernumber
  mainnumber:
    Source: mainnumber
  productnumber:
    Source: ordernumber
  name:
    Source: name
  supplier:
    Source: supplier
  taxName:
    Source: taxName
  taxValue:
    Source: taxValue
  tax_id:
    Source: tax_id
  price_EK:
    Source: price_EK
  price_gross:
    Source: price_gross
  pseudoprice_EK:
    Source: pseudoprice_EK
  baseprice_EK:
    Source: baseprice_EK
  active:
    Source: active
  configurator_options:
    Source: configurator_options
  supplier_number:
    Source: supplier_number
  attr1:
    Source: attr1
  attr2:
    Source: attr2
  attr3:
    Source: attr3
  attr4:
    Source: attr4
  attr5:
    Source: attr5
  attr6:
    Source: attr6
  attr7:
    Source: attr7
  attr9:
    Source: attr9
  attr10:
    Source: attr10
  attr11:
    Source: attr11
  attr12:
    Source: attr12
  attr13:
    Source: attr13
  attr14:
    Source: attr14
  attr15:
    Source: attr15
  attr16:
    Source: attr16
  attr17:
    Source: attr17
  attr18:
    Source: attr18
  attr19:
    Source: attr19
  attr20:
    Source: attr20
  attr21:
    Source: attr21
  attr22:
    Source: attr22
  attr23:
    Source: attr23
  attr24: #Synonyme
    Source: attr24
  attr26: #sortierte Ware
    Source: attr26
  attr27: #Produktart
    Source: attr27
  attr28: #Produktart
    Source: attr28
  attr29: #Produktart
    Source: attr29
  attr30: #stock local
    Source: attr30
  attr31: #stock inventory
    Source: attr31
  attr32: #google category
    Source: attr32
  attr33: #ebay category
    Source: attr33
  attr34: #amazon category
    Source: attr34
  attr35: #lieferzeit als Text
    Source: attr35
  attr36: #finanzierbare Produkte
    Source: attr36
  attr41:
    Source: attr41
  attr43:
    Source: attr43 #beratungstexte
  ean:
    Source: ean
  weight:
    Source: weight
  stock:
    Source: stock
  kind:
    Source: kind
  shipping_free:
    Source: shipping_free
  attr37:
    Source: attr37
  attr37_orig:
    Source: attr37_orig
  attr8:
    Source: attr8
  attr49:
    Source: attr49
  attr50:
    Source: attr50
  attr51:
    Source: attr51
  attr52:
    Source: attr52
  description_long:
    Source: description_long
  LBNTEK:
    Source: LBNTEK
  LBKALK:
    Source: LBKALK
  attr53:
    Source: attr53
  attr54:
    Source: attr54
  attr55:
    Source: attr55
  attr56:
    Source: attr56
  attr57:
    Source: attr57
  attr58:
    Source: attr58
  attr59:
    Source: attr59
  attr60:
    Source: attr60
  attr61:
    Source: attr61
  attr65:
    Source: attr65
  attr66:
    Source: attr66
  tpl_color_badge:
    Source: tpl_color_badge
  bestellsperre:
     Source: bestellsperre
  auslaufkennzeichen:
     Source: auslaufkennzeichen
  prop1:
    Source: prop1  #Farbe
  prop2:
    Source: prop2	#Breite
  prop3:
    Source: prop3	#Länge
  prop4:
    Source: prop4	#Höhe
  prop5:
    Source: prop5	#Abmessung
  prop10:
    Source: prop10	#Modell
  prop11:
    Source: prop11	#Material
  prop12:
    Source: prop12	#Raum
  prop50:
    Source: prop50	#Matratze Größe
  prop51:
    Source: prop51	#Matratze Härtegrad
  prop52:
    Source: prop52	#Matratze Bezugsmaterial
  prop53:
    Source: prop53	#Matratze Matratzenart
  prop60:
    Source: prop60	#Teppich Flächengewicht
  prop61:
    Source: prop61	#Teppich Florhöhe
  prop62:
    Source: prop62	#Teppich Fußbodenheizung
  prop63:
    Source: prop63	#Teppich Form
  prop64:
    Source: prop64	#Teppich Muster
  prop_status: #falls mindestens ein prop-Feld gefüllt ist, 1, sonst 0
    Source: prop1
  enev_color:
    Source: enev_color
  enev_download:
    Source: enev_download
  enev_image:
    Source: enev_image
  enev_klasse:
    Source: enev_klasse
  enev_spectrumfrom:
    Source: enev_spectrumfrom
  enev_spectrum:
    Source: enev_spectrum
  enev_active:
    Source: enev_active



#Target
Datapool: export_articles_sw6_dev_oms_combined #sql table
Primary_Key: [ordernumber, attr1]

Metadata

Erkannte Konfiguration

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

Source_Config exportEngine
Target_Config exportEngine
Mysql_Engine InnoDB
Default_Charset latin1
Source_Datapool articles_new
Sql SELECT * FROM export_articles_sw6_dev_oms UNION SELECT * FROM export_articles_parents_sw6
Read_Conditions [ "articles_new.active_oms = 1" ]
Order_By ordernumber ASC
Datapool_Definition { "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) DEFAULT NULL", "productnumber": "VARCHAR(255) DEFAULT NULL", "name": "VARCHAR(350) DEFAULT NULL", "supplier": "VARCHAR(255) DEFAULT NULL", "taxName": "VARCHAR(10) DEFAULT NULL", "taxValue": "VARCHAR(10) DEFAULT NULL", "tax_id": "VARCHAR(10) DEFAULT NULL", "price_EK": "VARCHAR(255) DEFAULT NULL", "price_gross": "VARCHAR(255) DEFAULT NULL", "pseudoprice_EK": "VARCHAR(255) DEFAULT NULL", "baseprice_EK": "VARCHAR(255) DEFAULT NULL", "active": "VARCHAR(2) DEFAULT NULL", "configurator_options": "VARCHAR(100) DEFAULT NULL", "supplier_number": "VARCHAR(10) DEFAULT NULL", "attr1": "VARCHAR(2) 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", "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(10) 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", "attr21": "VARCHAR(255) DEFAULT NULL", "attr22": "VARCHAR(255) DEFAULT NULL", "attr23": "VARCHAR(10) DEFAULT NULL", "attr24": "VARCHAR(255) DEFAULT NULL", "attr25": "VARCHAR(10) DEFAULT NULL", "attr26": "VARCHAR(10) DEFAULT NULL", "attr27": "VARCHAR(50) DEFAULT NULL", "attr28": "TEXT DEFAULT NULL", "attr29": "VARCHAR(10) DEFAULT NULL", "attr30": "VARCHAR(10) DEFAULT NULL", "attr31": "VARCHAR(10) DEFAULT NULL", "attr32": "VARCHAR(10) DEFAULT NULL", "attr33": "VARCHAR(100) DEFAULT NULL", "attr34": "VARCHAR(255) DEFAULT NULL", "attr35": "VARCHAR(100) DEFAULT NULL", "attr36": "VARCHAR(10) DEFAULT NULL", "attr41": "VARCHAR(10) DEFAULT NULL", "attr43": "VARCHAR(10) DEFAULT NULL", "ean": "VARCHAR(255) DEFAULT NULL", "weight": "VARCHAR(10) DEFAULT NULL", "stock": "VARCHAR(8) DEFAULT NULL", "kind": "VARCHAR(10) DEFAULT NULL", "shipping_free": "VARCHAR(2) DEFAULT NULL", "attr37": "VARCHAR(100) DEFAULT NULL", "attr37_orig": "VARCHAR(100) DEFAULT NULL", "attr8": "VARCHAR(10) DEFAULT NULL", "attr49": "VARCHAR(20) DEFAULT NULL", "attr50": "VARCHAR(10) DEFAULT NULL", "attr51": "VARCHAR(10) DEFAULT NULL", "attr52": "VARCHAR(10) DEFAULT NULL", "description_long": "TEXT DEFAULT NULL", "LBNTEK": "VARCHAR(10) DEFAULT NULL", "LBKALK": "VARCHAR(10) DEFAULT NULL", "attr53": "VARCHAR(25) DEFAULT NULL", "attr54": "VARCHAR(10) DEFAULT NULL", "attr55": "VARCHAR(25) DEFAULT NULL", "attr56": "LONGTEXT DEFAULT NULL", "attr57": "LONGTEXT DEFAULT NULL", "attr58": "LONGTEXT DEFAULT NULL", "attr59": "LONGTEXT DEFAULT NULL", "attr60": "LONGTEXT DEFAULT NULL", "attr61": "VARCHAR(255)", "attr65": "TEXT DEFAULT NULL", "attr66": "TEXT DEFAULT NULL", "tpl_color_badge": "VARCHAR(2) DEFAULT NULL", "bestellsperre": "VARCHAR(10) DEFAULT NULL", "auslaufkennzeichen": "VARCHAR(10) DEFAULT NULL", "prop1": "VARCHAR(50) DEFAULT NULL", "prop2": "VARCHAR(50) DEFAULT NULL", "prop3": "VARCHAR(50) DEFAULT NULL", "prop4": "VARCHAR(50) DEFAULT NULL", "prop5": "VARCHAR(50) DEFAULT NULL", "prop10": "VARCHAR(50) DEFAULT NULL", "prop11": "VARCHAR(50) DEFAULT NULL", "prop12": "VARCHAR(50) DEFAULT NULL", "prop50": "VARCHAR(50) DEFAULT NULL", "prop51": "VARCHAR(50) DEFAULT NULL", "prop52": "VARCHAR(50) DEFAULT NULL", "prop53": "VARCHAR(50) DEFAULT NULL", "prop60": "VARCHAR(50) DEFAULT NULL", "prop61": "VARCHAR(50) DEFAULT NULL", "prop62": "VARCHAR(50) DEFAULT NULL", "prop63": "VARCHAR(50) DEFAULT NULL", "prop64": "VARCHAR(50) DEFAULT NULL", "prop_status": "VARCHAR(50) DEFAULT NULL", "enev_color": "VARCHAR(50) DEFAULT NULL", "enev_download": "VARCHAR(255) DEFAULT NULL", "enev_image": "VARCHAR(255) DEFAULT NULL", "enev_klasse": "VARCHAR(255) DEFAULT NULL", "enev_spectrumfrom": "VARCHAR(255) DEFAULT NULL", "enev_spectrum": "VARCHAR(255) DEFAULT NULL", "enev_active": "VARCHAR(2) DEFAULT NULL" }
Mapping { "ordernumber": { "Source": "ordernumber" }, "mainnumber": { "Source": "mainnumber" }, "productnumber": { "Source": "ordernumber" }, "name": { "Source": "name" }, "supplier": { "Source": "supplier" }, "taxName": { "Source": "taxName" }, "taxValue": { "Source": "taxValue" }, "tax_id": { "Source": "tax_id" }, "price_EK": { "Source": "price_EK" }, "price_gross": { "Source": "price_gross" }, "pseudoprice_EK": { "Source": "pseudoprice_EK" }, "baseprice_EK": { "Source": "baseprice_EK" }, "active": { "Source": "active" }, "configurator_options": { "Source": "configurator_options" }, "supplier_number": { "Source": "supplier_number" }, "attr1": { "Source": "attr1" }, "attr2": { "Source": "attr2" }, "attr3": { "Source": "attr3" }, "attr4": { "Source": "attr4" }, "attr5": { "Source": "attr5" }, "attr6": { "Source": "attr6" }, "attr7": { "Source": "attr7" }, "attr9": { "Source": "attr9" }, "attr10": { "Source": "attr10" }, "attr11": { "Source": "attr11" }, "attr12": { "Source": "attr12" }, "attr13": { "Source": "attr13" }, "attr14": { "Source": "attr14" }, "attr15": { "Source": "attr15" }, "attr16": { "Source": "attr16" }, "attr17": { "Source": "attr17" }, "attr18": { "Source": "attr18" }, "attr19": { "Source": "attr19" }, "attr20": { "Source": "attr20" }, "attr21": { "Source": "attr21" }, "attr22": { "Source": "attr22" }, "attr23": { "Source": "attr23" }, "attr24": { "Source": "attr24" }, "attr26": { "Source": "attr26" }, "attr27": { "Source": "attr27" }, "attr28": { "Source": "attr28" }, "attr29": { "Source": "attr29" }, "attr30": { "Source": "attr30" }, "attr31": { "Source": "attr31" }, "attr32": { "Source": "attr32" }, "attr33": { "Source": "attr33" }, "attr34": { "Source": "attr34" }, "attr35": { "Source": "attr35" }, "attr36": { "Source": "attr36" }, "attr41": { "Source": "attr41" }, "attr43": { "Source": "attr43" }, "ean": { "Source": "ean" }, "weight": { "Source": "weight" }, "stock": { "Source": "stock" }, "kind": { "Source": "kind" }, "shipping_free": { "Source": "shipping_free" }, "attr37": { "Source": "attr37" }, "attr37_orig": { "Source": "attr37_orig" }, "attr8": { "Source": "attr8" }, "attr49": { "Source": "attr49" }, "attr50": { "Source": "attr50" }, "attr51": { "Source": "attr51" }, "attr52": { "Source": "attr52" }, "description_long": { "Source": "description_long" }, "LBNTEK": { "Source": "LBNTEK" }, "LBKALK": { "Source": "LBKALK" }, "attr53": { "Source": "attr53" }, "attr54": { "Source": "attr54" }, "attr55": { "Source": "attr55" }, "attr56": { "Source": "attr56" }, "attr57": { "Source": "attr57" }, "attr58": { "Source": "attr58" }, "attr59": { "Source": "attr59" }, "attr60": { "Source": "attr60" }, "attr61": { "Source": "attr61" }, "attr65": { "Source": "attr65" }, "attr66": { "Source": "attr66" }, "tpl_color_badge": { "Source": "tpl_color_badge" }, "bestellsperre": { "Source": "bestellsperre" }, "auslaufkennzeichen": { "Source": "auslaufkennzeichen" }, "prop1": { "Source": "prop1" }, "prop2": { "Source": "prop2" }, "prop3": { "Source": "prop3" }, "prop4": { "Source": "prop4" }, "prop5": { "Source": "prop5" }, "prop10": { "Source": "prop10" }, "prop11": { "Source": "prop11" }, "prop12": { "Source": "prop12" }, "prop50": { "Source": "prop50" }, "prop51": { "Source": "prop51" }, "prop52": { "Source": "prop52" }, "prop53": { "Source": "prop53" }, "prop60": { "Source": "prop60" }, "prop61": { "Source": "prop61" }, "prop62": { "Source": "prop62" }, "prop63": { "Source": "prop63" }, "prop64": { "Source": "prop64" }, "prop_status": { "Source": "prop1" }, "enev_color": { "Source": "enev_color" }, "enev_download": { "Source": "enev_download" }, "enev_image": { "Source": "enev_image" }, "enev_klasse": { "Source": "enev_klasse" }, "enev_spectrumfrom": { "Source": "enev_spectrumfrom" }, "enev_spectrum": { "Source": "enev_spectrum" }, "enev_active": { "Source": "enev_active" } }
Datapool export_articles_sw6_dev_oms_combined
Primary_Key [ "ordernumber", "attr1" ]