Legacy YAML export_stock_ost

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_stock_ost 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: iwm_stock  #sql from


Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: ausstellungsbestand
  Join_Condition: ausstellungsbestand.ordernumber = iwm_stock.ordernumber AND ausstellungsbestand.firma = iwm_stock.firma # One row per JOIN



Read_Conditions:  #sql where - Read-Filter
  - iwm_stock.firma = 1

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
 ordernumber:
  Source: iwm_stock.ordernumber
  Field_Adapter:
    - replace: [' ', '']
 mainnumber: iwm_stock.mainnumber
 stock: iwm_stock.stock
 stock_WIT: iwm_stock.witten
 stock_BOT: iwm_stock.bottrop
 stock_REC: iwm_stock.recklinghausen
 stock_HAA: iwm_stock.haan
 stock_LEV: iwm_stock.leverkusen
 exhibit_WIT:
  Source: ausstellungsbestand.exhibit_WIT
  Field_Adapter:
   - replace_empty: 0
   - replace_greater: [0,1]
 exhibit_BOT:
  Source: ausstellungsbestand.exhibit_BOT
  Field_Adapter:
   - replace_empty: 0
   - replace_greater: [0,1]
 exhibit_REC:
  Source: ausstellungsbestand.exhibit_REC
  Field_Adapter:
   - replace_empty: 0
   - replace_greater: [0,1]
 exhibit_HAA:
  Source: ausstellungsbestand.exhibit_HAA
  Field_Adapter:
   - replace_empty: 0
   - replace_greater: [0,1]
 exhibit_LEV:
  Source: ausstellungsbestand.exhibit_LEV
  Field_Adapter:
   - replace_empty: 0
   - replace_greater: [0,1]

#Target
Datapool: export_stock_ost #sql table
Primary_Key: [ordernumber]

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	iwm_stock
Joins	[ { "Left_Join": null, "Datapool": "ausstellungsbestand", "Join_Condition": "ausstellungsbestand.ordernumber = iwm_stock.ordernumber AND ausstellungsbestand.firma = iwm_stock.firma" } ]
Read_Conditions	[ "iwm_stock.firma = 1" ]
Mapping	{ "ordernumber": { "Source": "iwm_stock.ordernumber", "Field_Adapter": [ { "replace": [ " ", "" ] } ] }, "mainnumber": "iwm_stock.mainnumber", "stock": "iwm_stock.stock", "stock_WIT": "iwm_stock.witten", "stock_BOT": "iwm_stock.bottrop", "stock_REC": "iwm_stock.recklinghausen", "stock_HAA": "iwm_stock.haan", "stock_LEV": "iwm_stock.leverkusen", "exhibit_WIT": { "Source": "ausstellungsbestand.exhibit_WIT", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_greater": [ 0, 1 ] } ] }, "exhibit_BOT": { "Source": "ausstellungsbestand.exhibit_BOT", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_greater": [ 0, 1 ] } ] }, "exhibit_REC": { "Source": "ausstellungsbestand.exhibit_REC", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_greater": [ 0, 1 ] } ] }, "exhibit_HAA": { "Source": "ausstellungsbestand.exhibit_HAA", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_greater": [ 0, 1 ] } ] }, "exhibit_LEV": { "Source": "ausstellungsbestand.exhibit_LEV", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_greater": [ 0, 1 ] } ] } }
Datapool	export_stock_ost
Primary_Key	[ "ordernumber" ]