Legacy YAML / Detail

export / export_articles_oms_beny

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_beny 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: dg_supplierdata_export.export_articles_oms
  Join_Condition: articles_new.ordernumber = export_articles_oms.ordernumber  # One row per JOIN
- Left_Join:
  Datapool: dg_supplierdata_export.export_iwm_articles_prices_oms
  Join_Condition: articles_new.ordernumber = export_iwm_articles_prices_oms.ordernumber

Read_Conditions:  #sql where - Read-Filter
  - (articles_new.active_oms = 1 or articles_new.active_ost = 1 or articles_new.active_tre = 1)
  - NOT (articles_new.attr2 = '92' AND articles_new.attr3 = '31')
  - NOT (articles_new.attr2 = '92' AND articles_new.attr3 = '36')
  - export_iwm_articles_prices_oms.price_EK > 10
  - articles_new.ean != ''
#  - articles_new.attr4 != '99'



Datapool_Definition:
 id: VARCHAR(255) NOT NULL
 ean: VARCHAR(255) DEFAULT NULL
 id_on_marketplace: VARCHAR(255) DEFAULT NULL
 category: VARCHAR(255) DEFAULT NULL
 mpn: VARCHAR(255) DEFAULT NULL
 manufacturer: VARCHAR(255) DEFAULT NULL
 model: VARCHAR(255) DEFAULT NULL
 name_on_marketplace: VARCHAR(255) DEFAULT NULL
 min_price: VARCHAR(255) DEFAULT NULL
 max_price: VARCHAR(255) DEFAULT NULL
 article_condition: VARCHAR(255) DEFAULT NULL
 deep_link: VARCHAR(255) DEFAULT NULL
 shipping_cost: VARCHAR(255) DEFAULT NULL
 current_price: VARCHAR(255) DEFAULT NULL



#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
   Source: articles_new.ordernumber
   In_Export: no
 firma:
   Source: articles_new.attr1
   In_Export: no
 id:
   Source: articles_new.ordernumber
   File_Field_Adapter:
     File: export_articles_oms_beny.id
 ean: articles_new.ean
 id_on_marketplace: () #???
 category: articles_new.categoryPath_oms
 mpn: articles_new.attr9
 manufacturer:
  Source: articles_new.supplier_oms
  Cross_Field_Adapters:
      - Cross_Field_Adapter:
         Config: importEngine
         Cross_Datapool: iwm_lieferanten_articles #name of cross datapool
         Cross_Field: LIEFERANTENNAME #field to select value from in cross datapool
         Mapping: #cross field adapter with more than one key
           ordernumber: ORDERNUMBER
         Options:
           keep_existing: true
 # Cross_Field_Adapter:
 #   Config: importEngine
 #   Cross_Datapool: iwm_lieferanten_articles #name of cross datapool
 #   Cross_Field: LIEFERANTENNAME #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
 model: articles_new.attr9
 name_on_marketplace: articles_new.name_oms
 min_price: (000)
 max_price: (999900)
 article_condition: (new)
 deep_link: ()  #????
 shipping_cost:
   Source: export_articles_oms.attr8
   Field_Adapter:
    - replace: [',','']
    - replace: ['.','']
 current_price:
   Source: export_iwm_articles_prices_oms.price_EK
   Field_Adapter:
    - replace: [',','']
    - replace: ['.','']


Filters:
 - Filter:
     name: DuplicateId  #there must always be a space between the key and the comparision operator and between the parentheses
     condition:
       Cross_Dataset_Filter_Adapter: export_articles_oms_beny__filterByDuplicateId
     reason: 'There is another dataset with this id'
 - Filter:
    name: Filter articles that are not in main feed
    condition:
      Not_In_Pool_Filter_Adapter:
        Config: exportEngine
        Datapool: export_articles_oms
        Local_Key: ordernumber
        Cross_Key: ordernumber
    reason: 'Filter articles that are not in main shop export'
 #       Mapping: #left is from current datapool, right from filter datapool
 #        id: ordernumber


#Target
Datapool: export_articles_oms_beny #sql table
Primary_Key: [id]

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": "dg_supplierdata_export.export_articles_oms", "Join_Condition": "articles_new.ordernumber = export_articles_oms.ordernumber" }, { "Left_Join": null, "Datapool": "dg_supplierdata_export.export_iwm_articles_prices_oms", "Join_Condition": "articles_new.ordernumber = export_iwm_articles_prices_oms.ordernumber" } ]
Read_Conditions [ "(articles_new.active_oms = 1 or articles_new.active_ost = 1 or articles_new.active_tre = 1)", "NOT (articles_new.attr2 = '92' AND articles_new.attr3 = '31')", "NOT (articles_new.attr2 = '92' AND articles_new.attr3 = '36')", "export_iwm_articles_prices_oms.price_EK > 10", "articles_new.ean != ''" ]
Datapool_Definition { "id": "VARCHAR(255) NOT NULL", "ean": "VARCHAR(255) DEFAULT NULL", "id_on_marketplace": "VARCHAR(255) DEFAULT NULL", "category": "VARCHAR(255) DEFAULT NULL", "mpn": "VARCHAR(255) DEFAULT NULL", "manufacturer": "VARCHAR(255) DEFAULT NULL", "model": "VARCHAR(255) DEFAULT NULL", "name_on_marketplace": "VARCHAR(255) DEFAULT NULL", "min_price": "VARCHAR(255) DEFAULT NULL", "max_price": "VARCHAR(255) DEFAULT NULL", "article_condition": "VARCHAR(255) DEFAULT NULL", "deep_link": "VARCHAR(255) DEFAULT NULL", "shipping_cost": "VARCHAR(255) DEFAULT NULL", "current_price": "VARCHAR(255) DEFAULT NULL" }
Mapping { "ordernumber": { "Source": "articles_new.ordernumber", "In_Export": "no" }, "firma": { "Source": "articles_new.attr1", "In_Export": "no" }, "id": { "Source": "articles_new.ordernumber", "File_Field_Adapter": { "File": "export_articles_oms_beny.id" } }, "ean": "articles_new.ean", "id_on_marketplace": "()", "category": "articles_new.categoryPath_oms", "mpn": "articles_new.attr9", "manufacturer": { "Source": "articles_new.supplier_oms", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "iwm_lieferanten_articles", "Cross_Field": "LIEFERANTENNAME", "Mapping": { "ordernumber": "ORDERNUMBER" }, "Options": { "keep_existing": true } } } ] }, "model": "articles_new.attr9", "name_on_marketplace": "articles_new.name_oms", "min_price": "(000)", "max_price": "(999900)", "article_condition": "(new)", "deep_link": "()", "shipping_cost": { "Source": "export_articles_oms.attr8", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "" ] } ] }, "current_price": { "Source": "export_iwm_articles_prices_oms.price_EK", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "" ] } ] } }
Filters [ { "Filter": { "name": "DuplicateId", "condition": { "Cross_Dataset_Filter_Adapter": "export_articles_oms_beny__filterByDuplicateId" }, "reason": "There is another dataset with this id" } }, { "Filter": { "name": "Filter articles that are not in main feed", "condition": { "Not_In_Pool_Filter_Adapter": { "Config": "exportEngine", "Datapool": "export_articles_oms", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "reason": "Filter articles that are not in main shop export" } } ]
Datapool export_articles_oms_beny
Primary_Key [ "id" ]