Legacy YAML export_articles_oms_channelpilot_stock

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_stock 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 wit<h "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

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

Order_By: ordernumber ASC

Datapool_Definition:
 sku: VARCHAR(255) NOT NULL
 firma: VARCHAR(2) NOT NULL
 stock: VARCHAR(255) DEFAULT NULL

Mapping:
 sku:
   Source: articles_new.ordernumber
 firma:
    Source: articles_new.attr1
    Field_Adapter:
      - replace: [';', '']
 price:
  Source: articles_new.price_oms
  Cross_Field_Adapter:
    Config: exportEngine
    Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
    Cross_Field: price_EK #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
  In_Export: no
 #price:
 # Source: articles_new.price_oms
 # Field_Adapter:
 #   - replace: [',', '']
 #   - replace: ['.', ',']
 # In_Export: no
 dispositionsart:
     Source: articles_new.attr11
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 attr2:
     Source: articles_new.attr2
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 stock_witten:
   Source: iwm_articles_stock.witten
   In_Export: no
 stock_ir:
   Source: articles_new.stock_ir
   In_Export: no
 supplier:
   Source: articles_new.supplier_oms
   In_Export: no
 stock:
   Source: iwm_articles_stock.witten
   Field_Adapter:
     - replace_empty: 0
   File_Field_Adapter:
     File: export_articles.stock

Filters:
  - Filter:
      name: 'Filter articles not in main feed'
    condition:
      In_Pool_Filter_Adapter:
        Config: importEngine
        Datapool: export_articles_oms_channelpilot_combined
        Reason_Key: 'not in main feed'
        Mapping: #left is from current datapool, right from filter datapool
          sku: sku
          firma: firma


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

Source

Datei und Status

Dateipfad: /srv/app/backend/export/exportEngines/export_articles_oms_channelpilot_stock.yaml
Runner: export
Feature Flags: Datapool_Definition, Field_Adapter, File_Field_Adapter, Filters, Mapping, Read_Conditions
Connections: enhanceEngine, exportEngine

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" } ]
Read_Conditions	[ "articles_new.active_oms = 1" ]
Order_By	ordernumber ASC
Datapool_Definition	{ "sku": "VARCHAR(255) NOT NULL", "firma": "VARCHAR(2) NOT NULL", "stock": "VARCHAR(255) DEFAULT NULL" }
Mapping	{ "sku": { "Source": "articles_new.ordernumber" }, "firma": { "Source": "articles_new.attr1", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "price": { "Source": "articles_new.price_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "price_EK", "Local_Key": "sku", "Cross_Key": "ordernumber" }, "In_Export": "no" }, "dispositionsart": { "Source": "articles_new.attr11", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "attr2": { "Source": "articles_new.attr2", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "stock_witten": { "Source": "iwm_articles_stock.witten", "In_Export": "no" }, "stock_ir": { "Source": "articles_new.stock_ir", "In_Export": "no" }, "supplier": { "Source": "articles_new.supplier_oms", "In_Export": "no" }, "stock": { "Source": "iwm_articles_stock.witten", "Field_Adapter": [ { "replace_empty": 0 } ], "File_Field_Adapter": { "File": "export_articles.stock" } } }
Filters	[ { "Filter": { "name": "Filter articles not in main feed" }, "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "export_articles_oms_channelpilot_combined", "Reason_Key": "not in main feed", "Mapping": { "sku": "sku", "firma": "firma" } } } } ]
Datapool	export_articles_oms_channelpilot_stock
Primary_Key	[ "sku", "firma" ]