Legacy YAML / Detail

export / export_articles_oms_channelpilot_marketplaces

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

#Source
Source_Datapool: articles_new  #sql from

Mysql_Engine: InnoDB
Default_Charset: latin1

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma # One row per JOIN
#- Left_Join: #each condition is joined with "AND"
#  Datapool: shopware_article_info
#  Join_Condition: articles_new.ordernumber = shopware_article_info.ordernumber and shopware_article_info.shop = 'oms' # One row per JOIN
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_properties
  Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma
- Left_Join:
  Datapool: export_for_dataengine
  Join_Condition: articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'oms'


Order_By: ordernumber, mainnumber ASC


#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 sku:
   Source: articles_new.ordernumber
 variation_parent_sku:
   Source: articles_new.mainnumber
   File_Field_Adapter:
     File: export_articles.variation_parent_sku
 relationship_name:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.relationship_name
 Produktart:
   Source: articles_new.name_oms
   Field_Adapter:
     - explode: [' ','0']
 description:
  Source: articles_new.description_long_oms
  Field_Adapter:
      - replace: [';', '']
  File_Field_Adapter:
      File: export_articles.description
 category:
   Source: export_for_dataengine.category
 ean: articles_new.ean
 attr23: articles_new.swag_attr23
 wiederbeschaffungszeit: articles_new.attr12
 product_condition: (new)
 ear_marke: articles_new.ear_marke
 shipping:
   Source: articles_new.attr8
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_articles_oms #name of cross datapool
     Cross_Field: attr8 #field to select value from in cross datapool
     Local_Key: sku #key for where condition from datapool
     Cross_Key: ordernumber #key for where condition from cross datapool
 supplier:
  Source: articles_new.supplier_oms
  Field_Adapter:
    - replace_empty: 'Sonstige'
 suppliernumber_original: ()
 tax:
  Source: articles_new.tax
 Include_Mapping_prices_tre: prices_oms
 supplier_number:
  Source: articles_new.suppliernumber
 active:
   Source: articles_new.active_oms
   In_Export: no
 configurator_options:
   Source: articles_new.configuratorOptions
 weight:
  Source: articles_new.weight
 firma:
    Source: articles_new.attr1
    Field_Adapter:
      - replace: [';', '']
 attr2:
     Source: articles_new.attr2
     Field_Adapter:
       - replace: [';', '']
 unterwarengruppe:
     Source: articles_new.attr3
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 systemnummer:
     Source: articles_new.attr4
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 warenpool:
     Source: articles_new.attr5
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 metatext:
     Source: articles_new.swag_attr22
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 typenplan_id:
     Source: articles_new.attr7
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 versandkosten_berechnet:
     Source: articles_new.attr8
     Field_Adapter:
       - replace: [';', '']
 herstellerartikelnummer:
     Source: articles_new.attr9
     Field_Adapter:
       - replace: [';', '']
 textverwendungskennzeichen_hersteller_name:
     Source: articles_new.swag_attr25
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 dispositionsart:
     Source: articles_new.attr11
     Field_Adapter:
       - replace: [';', '']
 lieferzeitinwochen:
     Source: articles_new.attr12
     Field_Adapter:
       - replace: [';', '']
 lieferzeit_text:
   Source: articles_new.lieferzeit
 versandart:
     Source: articles_new.attr13
     Field_Adapter:
       - replace: [';', '']
 versandkosten_addition:
     Source: articles_new.attr14
     Field_Adapter:
       - replace: [';', '']
 iwm_versandkosten:
     Source: articles_new.attr15
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 montagekosten:
     Source: articles_new.attr16
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 textverwendungskennzeichen_mitbewerber_name:
     Source: articles_new.swag_attr24
     Field_Adapter:
       - replace: [';', '']
 etikettenart:
     Source: articles_new.attr18
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 document_id:
     Source: articles_new.attr19
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 iwm_seo_name:
     Source: articles_new.name_oms
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 kind:
   Source: articles_new.kind
   In_Export: no
 shippingfree:
   Source: articles_new.shippingfree
   In_Export: no
 LBKALK:
   Source: articles_new.LBKALK
   Cross_Field_Adapter:
     Config: exportEngine
     Cross_Datapool: export_articles_oms #name of cross datapool
     Cross_Field: LBKALK #field to select value from in cross datapool
     Local_Key: ordernumber #key for where condition from datapool
     Cross_Key: ordernumber #key for where condition from cross datapool
   Field_Adapter:
     - replace_empty: '0'
   In_Export: no
 stock_witten:
   Source: iwm_articles_stock.witten
   In_Export: no
 stock_ir:
   Source: articles_new.stock_ir
   In_Export: no
 stock:
   Source: iwm_articles_stock.witten
   Field_Adapter:
     - replace_empty: '0'
   File_Field_Adapter:
     File: export_articles.stock
 Include_Mapping_properties: iwm_articles_properties.properties
 color:
   Source: iwm_articles_properties.farbe_pre #color with color from variants
   File_Field_Adapter:
     File: export_articles_oms_channelpilot.color
 Include_Mapping_enev: articles_new.enev
 Include_Mapping_produktsicherheitsverordnung: articles_new.produktsicherheitsverordnung
 supplier_for_otto:
   Source: articles_new.supplier_oms
   File_Field_Adapter:
     File: export_articles.supplier_for_otto
 supplier_for_check24:
   Source: articles_new.supplier_oms
   File_Field_Adapter:
     File: export_articles.supplier_for_check24
 Synonyme:
    Source: articles_new.swag_attr24
 Modellfamilie:
   Source: articles_new.modellfamilie
 sortiert:
    Source: articles_new.swag_attr26
 title:
  Source: articles_new.name_ost
  File_Field_Adapter:
    File: export_articles.title
 Bulletpoints:
  Source: articles_new.description_long_oms
  File_Field_Adapter:
    File: export_articles.Bulletpoints
 imageUrl:
   Source: articles_new.imageUrl
   File_Field_Adapter:
     File: export_articles.imageUrl
 bestellsperre: articles_new.bestellsperre
 auslaufkennzeichen: articles_new.auslaufkennzeichen
 active_amazon:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.active_amazon
 active_ebay:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.active_ebay
 active_otto:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles.active_otto
 active_check24:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles.active_check24
 active_kaufland:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
     File: export_articles.active_kaufland
 Labels:
   Source: articles_new.configuratorOptions
   File_Field_Adapter:
    File: export_articles.Labels





Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Include_Filter: prices_equals_0
 - Filter:
    name: 'inactive for all platforms'
    condition: (active_ebay == 0) and (active_amazon == 0) and (active_otto == 0) and (active_check24 == 0) and (active_kaufland == 0)
    reason: 'inactive for all platforms'
 - Filter:
    name: 'channelfilter moebel-shop.de -> Artikel, die auf moebel-shop.de nicht sind, bekommen sonst bei den Rückimportfeldern keine Kategorie und keine Versandkosten'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_oms
        Reason_Key: reason
        Mapping: #left is from current datapool, right from filter datapool
         supplier_number: supplier_number
         supplier: supplier_name
         sku: ordernumber
         firma: attr1
         attr2: attr2
         unterwarengruppe: attr3
         systemnummer: attr4
         dispositionsart: attr11
         lieferzeitinwochen: attr12
         price: price
         stock: stock
         stock_witten: stock_witten
         title: name
         description: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre
 - Filter:
    name: 'Artikeldeaktivierung Gesamtmengenfilter'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: static_filter_inactive_articles_oms_channelpilot_marketplaces
        Reason_Key: reason
        Mapping: #left is from current datapool, right from filter datapool
         supplier_number: supplier_number
         supplier: supplier_name
         sku: ordernumber
         firma: attr1
         attr2: attr2
         unterwarengruppe: attr3
         systemnummer: attr4
         dispositionsart: attr11
         lieferzeitinwochen: attr12
         price: price
         stock: stock
         stock_witten: stock_witten
         title: name
         description: description
         sortiert: sortiert
         LBKALK: LBKALK
 #- Filter:
 #    name: 'channel group filter online shops'
 #    condition:
 #      In_Pool_Filter_Adapter:
 #        Config: importEngine
 #        Datapool: static_filter_inactive_articles_online
 #        Reason_Key: reason
 #        Mapping: #left is from current datapool, right from filter datapool
 #          supplier_number: supplier_number
 #          supplier: supplier_name
 #          ordernumber: ordernumber
 #          firma: attr1
 #          attr2: attr2
 #          unterwarengruppe: attr3
 #          systemnummer: attr4
 #          dispositionsart: attr11
 #          lieferzeitinwochen: attr12
 #          price: price
 #          stock: stock
 #          stock_witten: stock_witten
 #          title: name
 #          description: description
 #          auslaufkennzeichen: auslauf
 #          bestellsperre: bestellsperre


#Target
Datapool: export_articles_oms_channelpilot #sql table
Primary_Key: [sku, firma]

Metadata

Erkannte Konfiguration

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

Source_Config enhanceEngine
Target_Config exportEngine
Source_Datapool articles_new
Mysql_Engine InnoDB
Default_Charset latin1
Joins [ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma" }, { "Left_Join": null, "Datapool": "iwm_articles_properties", "Join_Condition": "articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma" }, { "Left_Join": null, "Datapool": "export_for_dataengine", "Join_Condition": "articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'oms'" } ]
Order_By ordernumber, mainnumber ASC
Mapping { "sku": { "Source": "articles_new.ordernumber" }, "variation_parent_sku": { "Source": "articles_new.mainnumber", "File_Field_Adapter": { "File": "export_articles.variation_parent_sku" } }, "relationship_name": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.relationship_name" } }, "Produktart": { "Source": "articles_new.name_oms", "Field_Adapter": [ { "explode": [ " ", "0" ] } ] }, "description": { "Source": "articles_new.description_long_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "File_Field_Adapter": { "File": "export_articles.description" } }, "category": { "Source": "export_for_dataengine.category" }, "ean": "articles_new.ean", "attr23": "articles_new.swag_attr23", "wiederbeschaffungszeit": "articles_new.attr12", "product_condition": "(new)", "ear_marke": "articles_new.ear_marke", "shipping": { "Source": "articles_new.attr8", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_oms", "Cross_Field": "attr8", "Local_Key": "sku", "Cross_Key": "ordernumber" } }, "supplier": { "Source": "articles_new.supplier_oms", "Field_Adapter": [ { "replace_empty": "Sonstige" } ] }, "suppliernumber_original": "()", "tax": { "Source": "articles_new.tax" }, "Include_Mapping_prices_tre": "prices_oms", "supplier_number": { "Source": "articles_new.suppliernumber" }, "active": { "Source": "articles_new.active_oms", "In_Export": "no" }, "configurator_options": { "Source": "articles_new.configuratorOptions" }, "weight": { "Source": "articles_new.weight" }, "firma": { "Source": "articles_new.attr1", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "attr2": { "Source": "articles_new.attr2", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "unterwarengruppe": { "Source": "articles_new.attr3", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "systemnummer": { "Source": "articles_new.attr4", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "warenpool": { "Source": "articles_new.attr5", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "metatext": { "Source": "articles_new.swag_attr22", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "typenplan_id": { "Source": "articles_new.attr7", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "versandkosten_berechnet": { "Source": "articles_new.attr8", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "herstellerartikelnummer": { "Source": "articles_new.attr9", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "textverwendungskennzeichen_hersteller_name": { "Source": "articles_new.swag_attr25", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "dispositionsart": { "Source": "articles_new.attr11", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "lieferzeitinwochen": { "Source": "articles_new.attr12", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "lieferzeit_text": { "Source": "articles_new.lieferzeit" }, "versandart": { "Source": "articles_new.attr13", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "versandkosten_addition": { "Source": "articles_new.attr14", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "iwm_versandkosten": { "Source": "articles_new.attr15", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "montagekosten": { "Source": "articles_new.attr16", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "textverwendungskennzeichen_mitbewerber_name": { "Source": "articles_new.swag_attr24", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "etikettenart": { "Source": "articles_new.attr18", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "document_id": { "Source": "articles_new.attr19", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "iwm_seo_name": { "Source": "articles_new.name_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "kind": { "Source": "articles_new.kind", "In_Export": "no" }, "shippingfree": { "Source": "articles_new.shippingfree", "In_Export": "no" }, "LBKALK": { "Source": "articles_new.LBKALK", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_oms", "Cross_Field": "LBKALK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": "0" } ], "In_Export": "no" }, "stock_witten": { "Source": "iwm_articles_stock.witten", "In_Export": "no" }, "stock_ir": { "Source": "articles_new.stock_ir", "In_Export": "no" }, "stock": { "Source": "iwm_articles_stock.witten", "Field_Adapter": [ { "replace_empty": "0" } ], "File_Field_Adapter": { "File": "export_articles.stock" } }, "Include_Mapping_properties": "iwm_articles_properties.properties", "color": { "Source": "iwm_articles_properties.farbe_pre", "File_Field_Adapter": { "File": "export_articles_oms_channelpilot.color" } }, "Include_Mapping_enev": "articles_new.enev", "Include_Mapping_produktsicherheitsverordnung": "articles_new.produktsicherheitsverordnung", "supplier_for_otto": { "Source": "articles_new.supplier_oms", "File_Field_Adapter": { "File": "export_articles.supplier_for_otto" } }, "supplier_for_check24": { "Source": "articles_new.supplier_oms", "File_Field_Adapter": { "File": "export_articles.supplier_for_check24" } }, "Synonyme": { "Source": "articles_new.swag_attr24" }, "Modellfamilie": { "Source": "articles_new.modellfamilie" }, "sortiert": { "Source": "articles_new.swag_attr26" }, "title": { "Source": "articles_new.name_ost", "File_Field_Adapter": { "File": "export_articles.title" } }, "Bulletpoints": { "Source": "articles_new.description_long_oms", "File_Field_Adapter": { "File": "export_articles.Bulletpoints" } }, "imageUrl": { "Source": "articles_new.imageUrl", "File_Field_Adapter": { "File": "export_articles.imageUrl" } }, "bestellsperre": "articles_new.bestellsperre", "auslaufkennzeichen": "articles_new.auslaufkennzeichen", "active_amazon": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.active_amazon" } }, "active_ebay": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.active_ebay" } }, "active_otto": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.active_otto" } }, "active_check24": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.active_check24" } }, "active_kaufland": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.active_kaufland" } }, "Labels": { "Source": "articles_new.configuratorOptions", "File_Field_Adapter": { "File": "export_articles.Labels" } } }
Filters [ { "Include_Filter": "prices_equals_0" }, { "Filter": { "name": "inactive for all platforms", "condition": "(active_ebay == 0) and (active_amazon == 0) and (active_otto == 0) and (active_check24 == 0) and (active_kaufland == 0)", "reason": "inactive for all platforms" } }, { "Filter": { "name": "channelfilter moebel-shop.de -> Artikel, die auf moebel-shop.de nicht sind, bekommen sonst bei den R\u00fcckimportfeldern keine Kategorie und keine Versandkosten", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles_oms", "Reason_Key": "reason", "Mapping": { "supplier_number": "supplier_number", "supplier": "supplier_name", "sku": "ordernumber", "firma": "attr1", "attr2": "attr2", "unterwarengruppe": "attr3", "systemnummer": "attr4", "dispositionsart": "attr11", "lieferzeitinwochen": "attr12", "price": "price", "stock": "stock", "stock_witten": "stock_witten", "title": "name", "description": "description", "auslaufkennzeichen": "auslauf", "bestellsperre": "bestellsperre" } } } } }, { "Filter": { "name": "Artikeldeaktivierung Gesamtmengenfilter", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles_oms_channelpilot_marketplaces", "Reason_Key": "reason", "Mapping": { "supplier_number": "supplier_number", "supplier": "supplier_name", "sku": "ordernumber", "firma": "attr1", "attr2": "attr2", "unterwarengruppe": "attr3", "systemnummer": "attr4", "dispositionsart": "attr11", "lieferzeitinwochen": "attr12", "price": "price", "stock": "stock", "stock_witten": "stock_witten", "title": "name", "description": "description", "sortiert": "sortiert", "LBKALK": "LBKALK" } } } } } ]
Datapool export_articles_oms_channelpilot
Primary_Key [ "sku", "firma" ]