Legacy YAML / Detail

export / export_articles_auswertung_preise

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_auswertung_preise 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


#Mapping -> Mappings source fields are detected by Mapping
Mapping:
  Artikelnummer:
    Source: articles_new.ordernumber
  Firma:
    Source: articles_new.attr1
  mainnumber:
    Source: articles_new.mainnumber
    In_Export: no
  Bezeichnung:
    Source: articles_new.name_ost
  HWG:
    Source: articles_new.attr2
    Field_Adapter:
      - replace: [';', '']
  Etikett:
    Source: articles_new.name_ost
    Cross_Field_Adapters:
       - Cross_Field_Adapter:
            Config: exportEngine
            Cross_Datapool: export_iwm_articles_prices_vkhs_0 #name of cross datapool
            Cross_Field: etikettenart #field to select value from in cross datapool
            Mapping: #cross field adapter with more than one key
              ordernumber: ordernumber
              attr1: firma
  Versandart:
    Source: articles_new.attr13
    Field_Adapter:
      - replace: [';', '']
  Gewicht:
    Source: articles_new.weight
    Field_Adapter:
      - float_pricision: 2
  Abholpreis:
    Source: articles_new.pseudoprice_oms
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_iwm_articles_prices_vkhs_0 #name of cross datapool
      Cross_Field: abholpreis #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.00'
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Lieferpreis:
    Source: articles_new.pseudoprice_oms
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_iwm_articles_prices_vkhs_0 #name of cross datapool
      Cross_Field: abholpreis #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.00'
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Vollservicepreis:
    Source: articles_new.pseudoprice_oms
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_iwm_articles_prices_vkhs_0 #name of cross datapool
      Cross_Field: vollservicepreis #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.00'
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Shoppreis_Ost:
    Source: articles_new.price_ost
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
      Cross_Field: price_EK #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
  Shoppreis_Tre:
    Source: articles_new.price_tre
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
      Cross_Field: price_EK #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
  Shoppreis_Oms:
    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: ordernumber #key for where condition from datapool
      Cross_Key: ordernumber #key for where condition from cross datapool
  Versandkosten_Ost:
    Source: articles_new.name_ost
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_articles_ost #name of cross datapool
      Cross_Field: attr8 #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.00
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Versandkosten_Tre:
    Source: articles_new.name_tre
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_articles_tre #name of cross datapool
      Cross_Field: attr8 #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.00
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Versandkosten_Oms:
    Source: articles_new.name_oms
    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: ordernumber #key for where condition from datapool
      Cross_Key: ordernumber #key for where condition from cross datapool
    Field_Adapter:
      - replace_empty: 0.00
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Montage_Ost:
    Source: articles_new.name_ost
    Cross_Field_Adapter:
      Config: exportEngine
      Cross_Datapool: export_articles_ost #name of cross datapool
      Cross_Field: attr16 #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.00
      - float_pricision: 2
      - replace: [ ',', '' ]
      - replace: [ '.', ',' ]
  Anlieferart:
    Source: articles_new.anlieferart


#Target
Datapool: export_articles_auswertung_preise #sql table
Primary_Key: [Artikelnummer, 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
Mapping { "Artikelnummer": { "Source": "articles_new.ordernumber" }, "Firma": { "Source": "articles_new.attr1" }, "mainnumber": { "Source": "articles_new.mainnumber", "In_Export": "no" }, "Bezeichnung": { "Source": "articles_new.name_ost" }, "HWG": { "Source": "articles_new.attr2", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "Etikett": { "Source": "articles_new.name_ost", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_vkhs_0", "Cross_Field": "etikettenart", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "Versandart": { "Source": "articles_new.attr13", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "Gewicht": { "Source": "articles_new.weight", "Field_Adapter": [ { "float_pricision": 2 } ] }, "Abholpreis": { "Source": "articles_new.pseudoprice_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_vkhs_0", "Cross_Field": "abholpreis", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": "0.00" }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Lieferpreis": { "Source": "articles_new.pseudoprice_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_vkhs_0", "Cross_Field": "abholpreis", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": "0.00" }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Vollservicepreis": { "Source": "articles_new.pseudoprice_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_vkhs_0", "Cross_Field": "vollservicepreis", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": "0.00" }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Shoppreis_Ost": { "Source": "articles_new.price_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_ost", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "Shoppreis_Tre": { "Source": "articles_new.price_tre", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_tre", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "Shoppreis_Oms": { "Source": "articles_new.price_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "price_EK", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "Versandkosten_Ost": { "Source": "articles_new.name_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_ost", "Cross_Field": "attr8", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": 0 }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Versandkosten_Tre": { "Source": "articles_new.name_tre", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_tre", "Cross_Field": "attr8", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": 0 }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Versandkosten_Oms": { "Source": "articles_new.name_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_oms", "Cross_Field": "attr8", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": 0 }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Montage_Ost": { "Source": "articles_new.name_ost", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_ost", "Cross_Field": "attr16", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": 0 }, { "float_pricision": 2 }, { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "Anlieferart": { "Source": "articles_new.anlieferart" } }
Datapool export_articles_auswertung_preise
Primary_Key [ "Artikelnummer", "Firma" ]