Legacy YAML / Detail

export / export_list_articles_all_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
export_list_articles_all_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: exportEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service
Mysql_Engine: InnoDB
Default_Charset: utf8

Add_Indices:
  - Add_Index:
      Datapool: articles_new
      Index_Name: idx_ordernumber_attr1
      Fields: ordernumber, attr1
  - Add_Index:
      Datapool: articles_new_filtered
      Index_Name: idx_ordernumber_attr1
      Fields: ordernumber, attr1
  - Add_Index:
      Datapool: export_lists_export_data
      Index_Name: idx_ordernumber_attr1
      Fields: ordernumber, attr1
  - Add_Index:
      Datapool: iwm_articles_properties
      Index_Name: idx_ordernumber_firma
      Fields: ordernumber, firma


#Source
Source_Datapool: export_articles_tre_filtered  #sql from

Datapool_Definition:
    Artikelnummer: VARCHAR(255) NOT NULL
    Deaktivierungsgrund: VARCHAR(500) DEFAULt NULL
    Deaktivierungsgrund_OMS: VARCHAR(500) DEFAULt NULL
    Name: VARCHAR(255) NOT NULL
    Lieferant: VARCHAR(255) NOT NULL
    Lieferantennummer: VARCHAR(255) NOT NULL
    EAN: VARCHAR(255) DEFAULT NULL
    attr1: VARCHAR(255) NOT NULL
    attr2: VARCHAR(255) DEFAULT NULL
    attr3: VARCHAR(255) DEFAULT NULL
    attr4: VARCHAR(255) DEFAULT NULL
    attr9: VARCHAR(255) DEFAULT NULL
    attr11: VARCHAR(255) DEFAULT NULL
    attr12: VARCHAR(255) DEFAULT NULL
    Preis_Ost: VARCHAR(255) DEFAULT NULL
    Preis_Tre: VARCHAR(255) DEFAULT NULL
    Preis_Oms: VARCHAR(255) DEFAULT NULL
    Versandkosten_Ost: VARCHAR(255) DEFAULT NULL
    Versandkosten_Tre: VARCHAR(255) DEFAULT NULL
    Versandkosten_Oms: VARCHAR(255) DEFAULT NULL
    Montagekosten: VARCHAR(255) DEFAULT NULL
#    Versandkosten_Ost_old: VARCHAR(255) DEFAULT NULL
#    Versandkosten_Tre_old: VARCHAR(255) DEFAULT NULL
#    Versandkosten_Oms_old: VARCHAR(255) DEFAULT NULL
    Bestand: VARCHAR(255) DEFAULT NULL
    Bestellsperre: VARCHAR(255) DEFAULT NULL
    Bestand_Witten: VARCHAR(255) DEFAULT NULL
    Mindestbestand_Witten: VARCHAR(255) DEFAULT NULL
    Kojen: TEXT DEFAULT NULL
    Status: VARCHAR(255) DEFAULT NULL
    Versandart: VARCHAR(255) DEFAULT NULL
    Online: VARCHAR(255) DEFAULT NULL
    Stil: VARCHAR(100) DEFAULT NULL
#    Besonderheit: VARCHAR(10) DEFAULT NULL
    Farbe: VARCHAR(50) DEFAULT NULL
    Zeltgut: VARCHAR(10) DEFAULT NULL
    Direktversand_Crossdock: VARCHAR(10) DEFAULT NULL

Sql:  SELECT enhanced_data.*, enhanced_data.filter_reason as fr, export_lists_export_data.shipping_tre, export_lists_export_data.shipping_ost, export_lists_export_data.shipping_oms, enhanced_data.attr37 as attr37, iwm_articles_properties.stil, iwm_articles_properties.farbe, export_lists_export_data.filter_reason as eled_fr, export_lists_export_data.filter_reason_oms as eled_fro, export_lists_export_data.price_ost, export_lists_export_data.price_tre, export_lists_export_data.price_oms, enhanced_data.anlieferart FROM (
        SELECT * FROM dg_supplierdata_enhanced.articles_new
        UNION
        SELECT * FROM dg_supplierdata_enhanced.articles_new_filtered
       ) as enhanced_data
       LEFT JOIN export_lists_export_data ON enhanced_data.ordernumber = export_lists_export_data.ordernumber AND enhanced_data.attr1 = export_lists_export_data.attr1
       LEFT JOIN dg_supplierdata_enhanced.iwm_articles_properties ON enhanced_data.ordernumber = iwm_articles_properties.ordernumber AND enhanced_data.attr1 = iwm_articles_properties.firma
       WHERE enhanced_data.ordernumber is not null

#Sql:  SELECT ed.ordernumber AS Artikelnummer,ed.filter_reason AS fr,eled.filter_reason AS eled_fr,eled.filter_reason_oms AS eled_fro,ed.name_ost,ed.supplier_ost,ed.suppliernumber,ed.ean,ed.attr1,ed.attr2,ed.attr3,ed.attr4,ed.attr9,ed.attr11,ed.attr12,eled.price_ost,eled.price_tre,eled.price_oms,eled.shipping_ost,eled.shipping_tre,eled.shipping_oms,ed.attr16,ed.instock,ed.bestellsperre,ed.stock_witten,ed.swag_attr21,ed.ahstat,ed.attr13,ed.zeltgut,ed.anlieferart,ap.stil,ap.farbe FROM (SELECT ordernumber,filter_reason,name_ost,supplier_ost,suppliernumber,ean,attr1,attr2,attr3,attr4,attr9,attr11,attr12,attr16,instock,bestellsperre,stock_witten,swag_attr21,ahstat,attr13,zeltgut,anlieferart FROM dg_supplierdata_enhanced.articles_new WHERE ordernumber IS NOT NULL UNION ALL SELECT ordernumber,filter_reason,name_ost,supplier_ost,suppliernumber,ean,attr1,attr2,attr3,attr4,attr9,attr11,attr12,attr16,instock,bestellsperre,stock_witten,swag_attr21,ahstat,attr13,zeltgut,anlieferart FROM dg_supplierdata_enhanced.articles_new_filtered WHERE ordernumber IS NOT NULL) AS ed LEFT JOIN export_lists_export_data AS eled ON eled.ordernumber=ed.ordernumber AND eled.attr1=ed.attr1 LEFT JOIN dg_supplierdata_enhanced.iwm_articles_properties AS ap ON ap.ordernumber=ed.ordernumber AND ap.firma=ed.attr1

Mapping:
 Artikelnummer:
   Source: enhanced_data.ordernumber
 filter_reason_enhanced:
   Source: enhanced_data.fr
   In_Export: no
 filter_reason_export:
   Source: export_lists_export_data.eled_fr
   In_Export: no
 filter_reason_export_oms:
   Source: export_lists_export_data.eled_fro
   In_Export: no
 Deaktivierungsgrund:
   Source: enhanced_data.ordernumber
   File_Field_Adapter:
     File: export_list_articles_all_new.Deaktivierungsgrund
 Deaktivierungsgrund_OMS:
   Source: enhanced_data.ordernumber
   File_Field_Adapter:
     File: export_list_articles_all_new.Deaktivierungsgrund_OMS
 Name: enhanced_data.name_ost
 Lieferant:
   Source: enhanced_data.supplier_ost
 Lieferantennummer:
   Source: enhanced_data.suppliernumber
 EAN: enhanced_data.ean
 attr1:
   Source: enhanced_data.attr1
 attr2:
   Source: enhanced_data.attr2
 attr3:
   Source: enhanced_data.attr3
 attr4:
   Source: enhanced_data.attr4
 attr9:
   Source: enhanced_data.attr9
 attr11:
   Source: enhanced_data.attr11
 attr12:
   Source: enhanced_data.attr12
 Preis_Ost:
   Source: price_ost
 Preis_Tre:
   Source: price_tre
 Preis_Oms:
   Source: price_oms
 Versandkosten_Ost:
   Source: export_lists_export_data.shipping_ost
   Field_Adapter:
     - replace: [ '.',',' ]
 Versandkosten_Tre:
   Source: export_lists_export_data.shipping_tre
   Field_Adapter:
     - replace: [ '.',',' ]
 Versandkosten_Oms:
   Source: export_lists_export_data.shipping_oms
   Field_Adapter:
     - replace: [ '.',',' ]
 Montagekosten:
   Source: enhanced_data.attr16
# Versandkosten_Ost_old:
#   Source: enhanced_data.shipping_ost
# Versandkosten_Tre_old:
#   Source: enhanced_data.shipping_tre
# Versandkosten_Oms_old:
#   Source: enhanced_data.shipping_oms
#   Field_Adapter:
#     - replace: [ '.',',' ]
 Bestand:
   Source: enhanced_data.instock
 Bestellsperre:
   Source: enhanced_data.bestellsperre
 Bestand_Witten:
   Source: enhanced_data.stock_witten
 Mindestbestand_Witten:
   Source: enhanced_data.stock_witten
   File_Field_Adapter:
     File: export_list_articles_all_new.min_stock_witten
 Kojen:
   Source: enhanced_data.swag_attr21
 Status:
   Source: enhanced_data.ahstat
 Versandart:
   Source: enhanced_data.attr13
 Online:
   Source: filter_reason
   File_Field_Adapter:
     File: export_list_articles_all_new.Online
#   Field_Adapter:
#     - replace_empty_else: ['ja','nein']
 Stil:
   Source: iwm_articles_properties.stil
# Besonderheit:
#   Source: iwm_articles_properties.Besonderheit
 Farbe:
   Source: iwm_articles_properties.farbe
 Zeltgut:
   Source: enhanced_data.zeltgut
 Direktversand_Crossdock:
   Source: enhanced_data.anlieferart
   Field_Adapter:
     - replace_empty: 'L'
     - replace_not_equals: ['D','L']

#Target
Datapool: export_list_articles_all_new #sql table
Primary_Key: [Artikelnummer, 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 utf8
Add_Indices [ { "Add_Index": { "Datapool": "articles_new", "Index_Name": "idx_ordernumber_attr1", "Fields": "ordernumber, attr1" } }, { "Add_Index": { "Datapool": "articles_new_filtered", "Index_Name": "idx_ordernumber_attr1", "Fields": "ordernumber, attr1" } }, { "Add_Index": { "Datapool": "export_lists_export_data", "Index_Name": "idx_ordernumber_attr1", "Fields": "ordernumber, attr1" } }, { "Add_Index": { "Datapool": "iwm_articles_properties", "Index_Name": "idx_ordernumber_firma", "Fields": "ordernumber, firma" } } ]
Source_Datapool export_articles_tre_filtered
Datapool_Definition { "Artikelnummer": "VARCHAR(255) NOT NULL", "Deaktivierungsgrund": "VARCHAR(500) DEFAULt NULL", "Deaktivierungsgrund_OMS": "VARCHAR(500) DEFAULt NULL", "Name": "VARCHAR(255) NOT NULL", "Lieferant": "VARCHAR(255) NOT NULL", "Lieferantennummer": "VARCHAR(255) NOT NULL", "EAN": "VARCHAR(255) DEFAULT NULL", "attr1": "VARCHAR(255) NOT NULL", "attr2": "VARCHAR(255) DEFAULT NULL", "attr3": "VARCHAR(255) DEFAULT NULL", "attr4": "VARCHAR(255) DEFAULT NULL", "attr9": "VARCHAR(255) DEFAULT NULL", "attr11": "VARCHAR(255) DEFAULT NULL", "attr12": "VARCHAR(255) DEFAULT NULL", "Preis_Ost": "VARCHAR(255) DEFAULT NULL", "Preis_Tre": "VARCHAR(255) DEFAULT NULL", "Preis_Oms": "VARCHAR(255) DEFAULT NULL", "Versandkosten_Ost": "VARCHAR(255) DEFAULT NULL", "Versandkosten_Tre": "VARCHAR(255) DEFAULT NULL", "Versandkosten_Oms": "VARCHAR(255) DEFAULT NULL", "Montagekosten": "VARCHAR(255) DEFAULT NULL", "Bestand": "VARCHAR(255) DEFAULT NULL", "Bestellsperre": "VARCHAR(255) DEFAULT NULL", "Bestand_Witten": "VARCHAR(255) DEFAULT NULL", "Mindestbestand_Witten": "VARCHAR(255) DEFAULT NULL", "Kojen": "TEXT DEFAULT NULL", "Status": "VARCHAR(255) DEFAULT NULL", "Versandart": "VARCHAR(255) DEFAULT NULL", "Online": "VARCHAR(255) DEFAULT NULL", "Stil": "VARCHAR(100) DEFAULT NULL", "Farbe": "VARCHAR(50) DEFAULT NULL", "Zeltgut": "VARCHAR(10) DEFAULT NULL", "Direktversand_Crossdock": "VARCHAR(10) DEFAULT NULL" }
Sql SELECT enhanced_data.*, enhanced_data.filter_reason as fr, export_lists_export_data.shipping_tre, export_lists_export_data.shipping_ost, export_lists_export_data.shipping_oms, enhanced_data.attr37 as attr37, iwm_articles_properties.stil, iwm_articles_properties.farbe, export_lists_export_data.filter_reason as eled_fr, export_lists_export_data.filter_reason_oms as eled_fro, export_lists_export_data.price_ost, export_lists_export_data.price_tre, export_lists_export_data.price_oms, enhanced_data.anlieferart FROM ( SELECT * FROM dg_supplierdata_enhanced.articles_new UNION SELECT * FROM dg_supplierdata_enhanced.articles_new_filtered ) as enhanced_data LEFT JOIN export_lists_export_data ON enhanced_data.ordernumber = export_lists_export_data.ordernumber AND enhanced_data.attr1 = export_lists_export_data.attr1 LEFT JOIN dg_supplierdata_enhanced.iwm_articles_properties ON enhanced_data.ordernumber = iwm_articles_properties.ordernumber AND enhanced_data.attr1 = iwm_articles_properties.firma WHERE enhanced_data.ordernumber is not null
Mapping { "Artikelnummer": { "Source": "enhanced_data.ordernumber" }, "filter_reason_enhanced": { "Source": "enhanced_data.fr", "In_Export": "no" }, "filter_reason_export": { "Source": "export_lists_export_data.eled_fr", "In_Export": "no" }, "filter_reason_export_oms": { "Source": "export_lists_export_data.eled_fro", "In_Export": "no" }, "Deaktivierungsgrund": { "Source": "enhanced_data.ordernumber", "File_Field_Adapter": { "File": "export_list_articles_all_new.Deaktivierungsgrund" } }, "Deaktivierungsgrund_OMS": { "Source": "enhanced_data.ordernumber", "File_Field_Adapter": { "File": "export_list_articles_all_new.Deaktivierungsgrund_OMS" } }, "Name": "enhanced_data.name_ost", "Lieferant": { "Source": "enhanced_data.supplier_ost" }, "Lieferantennummer": { "Source": "enhanced_data.suppliernumber" }, "EAN": "enhanced_data.ean", "attr1": { "Source": "enhanced_data.attr1" }, "attr2": { "Source": "enhanced_data.attr2" }, "attr3": { "Source": "enhanced_data.attr3" }, "attr4": { "Source": "enhanced_data.attr4" }, "attr9": { "Source": "enhanced_data.attr9" }, "attr11": { "Source": "enhanced_data.attr11" }, "attr12": { "Source": "enhanced_data.attr12" }, "Preis_Ost": { "Source": "price_ost" }, "Preis_Tre": { "Source": "price_tre" }, "Preis_Oms": { "Source": "price_oms" }, "Versandkosten_Ost": { "Source": "export_lists_export_data.shipping_ost", "Field_Adapter": [ { "replace": [ ".", "," ] } ] }, "Versandkosten_Tre": { "Source": "export_lists_export_data.shipping_tre", "Field_Adapter": [ { "replace": [ ".", "," ] } ] }, "Versandkosten_Oms": { "Source": "export_lists_export_data.shipping_oms", "Field_Adapter": [ { "replace": [ ".", "," ] } ] }, "Montagekosten": { "Source": "enhanced_data.attr16" }, "Bestand": { "Source": "enhanced_data.instock" }, "Bestellsperre": { "Source": "enhanced_data.bestellsperre" }, "Bestand_Witten": { "Source": "enhanced_data.stock_witten" }, "Mindestbestand_Witten": { "Source": "enhanced_data.stock_witten", "File_Field_Adapter": { "File": "export_list_articles_all_new.min_stock_witten" } }, "Kojen": { "Source": "enhanced_data.swag_attr21" }, "Status": { "Source": "enhanced_data.ahstat" }, "Versandart": { "Source": "enhanced_data.attr13" }, "Online": { "Source": "filter_reason", "File_Field_Adapter": { "File": "export_list_articles_all_new.Online" } }, "Stil": { "Source": "iwm_articles_properties.stil" }, "Farbe": { "Source": "iwm_articles_properties.farbe" }, "Zeltgut": { "Source": "enhanced_data.zeltgut" }, "Direktversand_Crossdock": { "Source": "enhanced_data.anlieferart", "Field_Adapter": [ { "replace_empty": "L" }, { "replace_not_equals": [ "D", "L" ] } ] } }
Datapool export_list_articles_all_new
Primary_Key [ "Artikelnummer", "attr1" ]