Legacy YAML / Detail

export / export_articles_plenty-oms

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_plenty_oms 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_Fields: [ordernumber, mainnumber, name_oms, tax, price_oms, pseudoprice_oms, baseprice, active_oms, description, description_long_oms, unitID, ean, categories, referenceUnit, purchaseUnit] #sql select
Source_Datapool: articles  #sql from

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma # One row per JOIN
- Left_Join:
  Datapool: iwm_properties
  Join_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma


#Mapping -> Mappings source fields are detected by Mapping
Mapping:
  ordernumber: articles.ordernumber
  mainnumber:
    Source: articles.mainnumber
    Field_Adapter:
     - replace: ['-1', '']
  name_ost:
    Source: articles.name_ost
    Field_Adapter:
     - addslashes
  name_tre:
    Source: articles.name_tre
    Field_Adapter:
     - addslashes
  name_oms:
    Source: articles.name_oms
    Field_Adapter:
     - addslashes
  name_bil:
    Source: articles.name_bil
    Field_Adapter:
     - addslashes
  supplier_ost:
    Source: articles.supplier_ost
    Field_Adapter:
     - addslashes
  supplier_tre:
    Source: articles.supplier_tre
    Field_Adapter:
     - addslashes
  supplier_oms:
    Source: articles.supplier_oms
    Field_Adapter:
     - addslashes
  supplier_bil:
    Source: articles.supplier_bil
    Field_Adapter:
     - addslashes
  tax: articles.tax
  kind: articles.kind
  price_ost: articles.price_ost
  price_tre: articles.price_tre
  price_oms: articles.price_oms
  price_bil: articles.price_bil
  pseudoprice_ost: articles.pseudoprice_ost
  pseudoprice_tre: articles.pseudoprice_tre
  pseudoprice_oms: articles.pseudoprice_oms
  pseudoprice_bil: articles.pseudoprice_bil
  active_ost: articles.active_ost
  active_tre: articles.active_tre
  active_oms: articles.active_oms
  active_bil: articles.active_bil
  categoryPath_ost:
    Source: articles.categoryPath_ost
    Field_Adapter:
     - addslashes
  categoryPath_tre:
    Source: articles.categoryPath_tre
    Field_Adapter:
     - addslashes
  categoryPath_oms:
    Source: articles.categoryPath_oms
    Field_Adapter:
     - addslashes
  categoryPath_bil:
    Source: articles.categoryPath_bil
    Field_Adapter:
     - addslashes
  configuratorOptions: articles.configuratorOptions
  description_long_ost:
    Source: articles.description_long_ost
    Field_Adapter:
     - addslashes
  description_long_tre:
    Source: articles.description_long_tre
    Field_Adapter:
     - addslashes
  description_long_oms:
    Source: articles.description_long_oms
    Field_Adapter:
     - addslashes
  description_long_bil:
    Source: articles.description_long_bil
    Field_Adapter:
     - addslashes
  attr1: articles.attr1
  attr2: articles.attr2
  attr3: articles.attr3
  attr4: articles.attr4
  attr5: articles.attr5
  attr6: articles.attr6
  attr7: articles.attr7
  attr8: articles.attr8
  attr9: articles.attr9
  attr10: articles.attr10
  attr11: articles.attr11
  attr12: articles.attr12
  attr13: articles.attr13
  attr14: articles.attr14
  attr15: articles.attr15
  attr16: articles.attr16
  attr17: articles.attr17
  attr18: articles.attr18
  attr19: articles.attr19
  attr20: articles.attr20
  swag_attr21: articles.swag_attr21
  swag_attr22:
    Source: articles.swag_attr22
    Field_Adapter:
     - addslashes
  swag_attr23: articles.swag_attr23
  swag_attr24: articles.swag_attr24
  swag_attr25: articles.swag_attr25
  swag_attr26: articles.swag_attr26
  swag_attr27: articles.swag_attr27
  swag_attr28: articles.swag_attr28
  swag_attr29: articles.swag_attr29
  swag_attr30: articles.swag_attr30
  ean: articles.ean
  imageUrl: articles.imageUrl
  stock_witten: iwm_articles_stock.witten
  propertyValueName:
    Source: iwm_properties.propertyValueName
    Field_Adapter:
     - replace: ['|',':de;']
  weight:
    Source: articles.weight
    Field_Adapter:
     - replace: ['.00', '']
     - replace: [',', '']
     - simple_division: 1000
  listingID:
    Source: articles.ordernumber
    Field_Adapter:
     - replace: ['-', '00']
  ebay_active: (1)
  LBKALK:
   Source: articles.LBKALK
   In_Export: no
  plenty_cat_id:
   Source: articles.name_oms
   File_Field_Adapter:
     Datapool: plenty_cat_ids
     Identifier: plenty_cat_id
     Fields:
      - plenty_cat_id
      - Level1
      - Level2


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


Filters:
 - Filter:
    name: Mindestbestand
    condition: (price_oms < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand price_ost < 6 AND stock_witten < 10'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_oms < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand price_ost < 25 AND stock_witten < 3'
 - Filter:
    name: 'Mindestbestand'
    condition: (price_oms < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')
    reason: 'Mindestbestand price_ost < 100 AND stock_witten < 1'
 - Filter:
    name: filter_plenty_oms_suppliers
    condition: supplier_oms == 'PAIDI' or supplier_oms == 'weber' or supplier_oms == 'vito' or supplier_oms == 'MONDO' or supplier_oms == 'VALMONDO' or supplier_oms == 'LIV´IN' or supplier_oms == 'SELF' or supplier_oms == 'KETTLER' or supplier_oms == 'hülsta' or supplier_oms == 'Kollektion-Wiedemann' or supplier_oms == 'ROLF BENZ'
    output: positive
    reason: 'excluded supplier'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: attr2 == 63 OR attr2 == 97
    output: positive
    reason: 'bad calculation: attr2 = 63 OR attr2 = 97 ok'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: LBKALK < 50
    output: positive
    reason: 'bad calculation: LBKALK < 60'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: LBKALK < 70 AND attr2 == 10
    output: positive
    reason: 'bad calculation: LBKALK < 80 AND attr2 = 10'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: LBKALK < 70 AND attr2 == 20
    output: positive
    reason: 'bad calculation: LBKALK < 80 AND attr2 = 20'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: LBKALK < 70 AND attr2 == 29
    output: positive
    reason: 'bad calculation: LBKALK < 80 AND attr2 = 29'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: LBKALK < 70 AND attr2 == 30
    output: positive
    reason: 'bad calculation: LBKALK < 80 AND attr2 = 30'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: LBKALK < 70 AND attr2 == 40
    output: positive
    reason: 'bad calculation: LBKALK < 80 AND attr2 = 40'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: attr2 == 91 AND attr3 == 70
    output: positive
    reason: 'bad calculation: attr2 = 91 AND attr3 = 70'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: attr2 == 92 AND attr3 == 54
    output: positive
    reason: 'bad calculation: attr2 = 92 AND attr3 = 54'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: (attr11 != 'L')
    output: positive
    reason: 'Bestellartikel'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: (stock_witten < 1)
    output: positive
    reason: 'Bestellartikel'
 - Filter:
    name: 'Preis ungueltig'
    condition: (price_oms == '0') or (price_oms == '') or (price_oms == '0.00')  or (price_oms == '0,00')  or (price_oms == '0,0')
    reason: 'alle Preise = 0'

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
Joins [ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma" }, { "Left_Join": null, "Datapool": "iwm_properties", "Join_Condition": "articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma" } ]
Mapping { "ordernumber": "articles.ordernumber", "mainnumber": { "Source": "articles.mainnumber", "Field_Adapter": [ { "replace": [ "-1", "" ] } ] }, "name_ost": { "Source": "articles.name_ost", "Field_Adapter": [ "addslashes" ] }, "name_tre": { "Source": "articles.name_tre", "Field_Adapter": [ "addslashes" ] }, "name_oms": { "Source": "articles.name_oms", "Field_Adapter": [ "addslashes" ] }, "name_bil": { "Source": "articles.name_bil", "Field_Adapter": [ "addslashes" ] }, "supplier_ost": { "Source": "articles.supplier_ost", "Field_Adapter": [ "addslashes" ] }, "supplier_tre": { "Source": "articles.supplier_tre", "Field_Adapter": [ "addslashes" ] }, "supplier_oms": { "Source": "articles.supplier_oms", "Field_Adapter": [ "addslashes" ] }, "supplier_bil": { "Source": "articles.supplier_bil", "Field_Adapter": [ "addslashes" ] }, "tax": "articles.tax", "kind": "articles.kind", "price_ost": "articles.price_ost", "price_tre": "articles.price_tre", "price_oms": "articles.price_oms", "price_bil": "articles.price_bil", "pseudoprice_ost": "articles.pseudoprice_ost", "pseudoprice_tre": "articles.pseudoprice_tre", "pseudoprice_oms": "articles.pseudoprice_oms", "pseudoprice_bil": "articles.pseudoprice_bil", "active_ost": "articles.active_ost", "active_tre": "articles.active_tre", "active_oms": "articles.active_oms", "active_bil": "articles.active_bil", "categoryPath_ost": { "Source": "articles.categoryPath_ost", "Field_Adapter": [ "addslashes" ] }, "categoryPath_tre": { "Source": "articles.categoryPath_tre", "Field_Adapter": [ "addslashes" ] }, "categoryPath_oms": { "Source": "articles.categoryPath_oms", "Field_Adapter": [ "addslashes" ] }, "categoryPath_bil": { "Source": "articles.categoryPath_bil", "Field_Adapter": [ "addslashes" ] }, "configuratorOptions": "articles.configuratorOptions", "description_long_ost": { "Source": "articles.description_long_ost", "Field_Adapter": [ "addslashes" ] }, "description_long_tre": { "Source": "articles.description_long_tre", "Field_Adapter": [ "addslashes" ] }, "description_long_oms": { "Source": "articles.description_long_oms", "Field_Adapter": [ "addslashes" ] }, "description_long_bil": { "Source": "articles.description_long_bil", "Field_Adapter": [ "addslashes" ] }, "attr1": "articles.attr1", "attr2": "articles.attr2", "attr3": "articles.attr3", "attr4": "articles.attr4", "attr5": "articles.attr5", "attr6": "articles.attr6", "attr7": "articles.attr7", "attr8": "articles.attr8", "attr9": "articles.attr9", "attr10": "articles.attr10", "attr11": "articles.attr11", "attr12": "articles.attr12", "attr13": "articles.attr13", "attr14": "articles.attr14", "attr15": "articles.attr15", "attr16": "articles.attr16", "attr17": "articles.attr17", "attr18": "articles.attr18", "attr19": "articles.attr19", "attr20": "articles.attr20", "swag_attr21": "articles.swag_attr21", "swag_attr22": { "Source": "articles.swag_attr22", "Field_Adapter": [ "addslashes" ] }, "swag_attr23": "articles.swag_attr23", "swag_attr24": "articles.swag_attr24", "swag_attr25": "articles.swag_attr25", "swag_attr26": "articles.swag_attr26", "swag_attr27": "articles.swag_attr27", "swag_attr28": "articles.swag_attr28", "swag_attr29": "articles.swag_attr29", "swag_attr30": "articles.swag_attr30", "ean": "articles.ean", "imageUrl": "articles.imageUrl", "stock_witten": "iwm_articles_stock.witten", "propertyValueName": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "replace": [ "|", ":de;" ] } ] }, "weight": { "Source": "articles.weight", "Field_Adapter": [ { "replace": [ ".00", "" ] }, { "replace": [ ",", "" ] }, { "simple_division": 1000 } ] }, "listingID": { "Source": "articles.ordernumber", "Field_Adapter": [ { "replace": [ "-", "00" ] } ] }, "ebay_active": "(1)", "LBKALK": { "Source": "articles.LBKALK", "In_Export": "no" }, "plenty_cat_id": { "Source": "articles.name_oms", "File_Field_Adapter": { "Datapool": "plenty_cat_ids", "Identifier": "plenty_cat_id", "Fields": [ "plenty_cat_id", "Level1", "Level2" ] } } }
Datapool export_articles_plenty_oms
Primary_Key [ "ordernumber", "attr1" ]
Filters [ { "Filter": { "name": "Mindestbestand", "condition": "(price_oms < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')", "reason": "Mindestbestand price_ost < 6 AND stock_witten < 10" } }, { "Filter": { "name": "Mindestbestand", "condition": "(price_oms < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')", "reason": "Mindestbestand price_ost < 25 AND stock_witten < 3" } }, { "Filter": { "name": "Mindestbestand", "condition": "(price_oms < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L')", "reason": "Mindestbestand price_ost < 100 AND stock_witten < 1" } }, { "Filter": { "name": "filter_plenty_oms_suppliers", "condition": "supplier_oms == 'PAIDI' or supplier_oms == 'weber' or supplier_oms == 'vito' or supplier_oms == 'MONDO' or supplier_oms == 'VALMONDO' or supplier_oms == 'LIV\u00b4IN' or supplier_oms == 'SELF' or supplier_oms == 'KETTLER' or supplier_oms == 'h\u00fclsta' or supplier_oms == 'Kollektion-Wiedemann' or supplier_oms == 'ROLF BENZ'", "output": "positive", "reason": "excluded supplier" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "attr2 == 63 OR attr2 == 97", "output": "positive", "reason": "bad calculation: attr2 = 63 OR attr2 = 97 ok" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "LBKALK < 50", "output": "positive", "reason": "bad calculation: LBKALK < 60" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "LBKALK < 70 AND attr2 == 10", "output": "positive", "reason": "bad calculation: LBKALK < 80 AND attr2 = 10" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "LBKALK < 70 AND attr2 == 20", "output": "positive", "reason": "bad calculation: LBKALK < 80 AND attr2 = 20" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "LBKALK < 70 AND attr2 == 29", "output": "positive", "reason": "bad calculation: LBKALK < 80 AND attr2 = 29" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "LBKALK < 70 AND attr2 == 30", "output": "positive", "reason": "bad calculation: LBKALK < 80 AND attr2 = 30" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "LBKALK < 70 AND attr2 == 40", "output": "positive", "reason": "bad calculation: LBKALK < 80 AND attr2 = 40" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "attr2 == 91 AND attr3 == 70", "output": "positive", "reason": "bad calculation: attr2 = 91 AND attr3 = 70" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "attr2 == 92 AND attr3 == 54", "output": "positive", "reason": "bad calculation: attr2 = 92 AND attr3 = 54" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "(attr11 != 'L')", "output": "positive", "reason": "Bestellartikel" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "(stock_witten < 1)", "output": "positive", "reason": "Bestellartikel" } }, { "Filter": { "name": "Preis ungueltig", "condition": "(price_oms == '0') or (price_oms == '') or (price_oms == '0.00') or (price_oms == '0,00') or (price_oms == '0,0')", "reason": "alle Preise = 0" } } ]