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.
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.
Raw YAML
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_suggestions_beny #sql from
Mapping:
Firm: articles_suggestions_beny.Firm
Hwg: articles_suggestions_beny.Hwg
Uwg: articles_suggestions_beny.Uwg
Sys: articles_suggestions_beny.Sys
# Pool: articles_suggestions_beny.Pool
ItemEAN: articles_suggestions_beny.ItemEAN
No: articles_suggestions_beny.No
Asnr: articles_suggestions_beny.Asnr
LiefNo: articles_suggestions_beny.LiefNo
LiefName: articles_suggestions_beny.LiefName
Name: articles_suggestions_beny.Name
Hsbn: articles_suggestions_beny.Hsbn
EK300: articles_suggestions_beny.EK300
VK: articles_suggestions_beny.VK
Kalk300: articles_suggestions_beny.Kalk300
# VKVorschlag: articles_suggestions_beny.VKVorschlag
# KalkVorschlag:
# Source: articles_suggestions_beny.KalkVorschlag
# Field_Adapter:
# - float_pricision: [ 2,',','.' ]
Dif:
Source: articles_suggestions_beny.Dif
Field_Adapter:
- float_pricision: [ 2,',','.' ]
Anbieter1:
Source: articles_suggestions_beny.Anbieter1
File_Field_Adapter:
File: beny.charset_conversion
Preis1:
Source: articles_suggestions_beny.Preis1
Field_Adapter:
- float_pricision: [ 2,',','.' ]
- add_string: €
Anbieter2:
Source: articles_suggestions_beny.Anbieter2
File_Field_Adapter:
File: beny.charset_conversion
Preis2:
Source: articles_suggestions_beny.Preis2
Field_Adapter:
- float_pricision: [ 2,',','.' ]
- add_string: €
Anbieter3:
Source: articles_suggestions_beny.Anbieter3
File_Field_Adapter:
File: beny.charset_conversion
Preis3:
Source: articles_suggestions_beny.Preis3
Field_Adapter:
- float_pricision: [ 2,',','.' ]
- add_string: €
# AbsatzMenge3M: articles_suggestions_beny.AbsatzMenge3M
Werbepreis: ()
# changed_7_days: ()
MARKETPLACE: articles_suggestions_beny.MARKETPLACE
RANKING:
Source: articles_suggestions_beny.RANKING
In_Export: no
# ID: beny_suggestions.ID
# PRODUCTNAME: beny_suggestions.PRODUCTNAME
# CATEGORY: beny_suggestions.CATEGORY
# MANUFACTURER: beny_suggestions.MANUFACTURER
# MODEL: beny_suggestions.MODEL
# EAN: beny_suggestions.EAN
# MPN: beny_suggestions.MPN
# STATUS: beny_suggestions.STATUS
# RANKING: beny_suggestions.RANKING
# SHIPPINGCOSTS: beny_suggestions.SHIPPINGCOSTS
# SHOP: beny_suggestions.SHOP
# SHOP_URL: beny_suggestions.SHOP_URL
# NEWPRICE: beny_suggestions.NEWPRICE
# OLDPRICE: beny_suggestions.OLDPRICE
# PRICECHANGE: beny_suggestions.PRICECHANGE
# LASTUPDATE: beny_suggestions.LASTUPDATE
# BESTOFFERER: beny_suggestions.BESTOFFERER
# BESTPRICE: beny_suggestions.BESTPRICE
# TOTALPRICE: beny_suggestions.TOTALPRICE
# NEWTOTALPRICE: beny_suggestions.NEWTOTALPRICE
# AVAILABILITY: beny_suggestions.AVAILABILITY
# DEEPLINK: beny_suggestions.DEEPLINK
# LISTED: beny_suggestions.LISTED
# CURRENTPRICE: beny_suggestions.CURRENTPRICE
Filters:
- Filter:
name: 'nur ost hwg 10 30'
condition: ((Hwg == '10') or (Hwg == '30')) and (Firm == '1')
reason: 'nur ost hwg 10 30'
#Target
Datapool: suggestions_beny_ost_hwg_10_30 #sql table
Primary_Key: [Firm, No, Asnr, RANKING, MARKETPLACE]
Metadata
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_suggestions_beny |
| Mapping | { "Firm": "articles_suggestions_beny.Firm", "Hwg": "articles_suggestions_beny.Hwg", "Uwg": "articles_suggestions_beny.Uwg", "Sys": "articles_suggestions_beny.Sys", "ItemEAN": "articles_suggestions_beny.ItemEAN", "No": "articles_suggestions_beny.No", "Asnr": "articles_suggestions_beny.Asnr", "LiefNo": "articles_suggestions_beny.LiefNo", "LiefName": "articles_suggestions_beny.LiefName", "Name": "articles_suggestions_beny.Name", "Hsbn": "articles_suggestions_beny.Hsbn", "EK300": "articles_suggestions_beny.EK300", "VK": "articles_suggestions_beny.VK", "Kalk300": "articles_suggestions_beny.Kalk300", "Dif": { "Source": "articles_suggestions_beny.Dif", "Field_Adapter": [ { "float_pricision": [ 2, ",", "." ] } ] }, "Anbieter1": { "Source": "articles_suggestions_beny.Anbieter1", "File_Field_Adapter": { "File": "beny.charset_conversion" } }, "Preis1": { "Source": "articles_suggestions_beny.Preis1", "Field_Adapter": [ { "float_pricision": [ 2, ",", "." ] }, { "add_string": "\u20ac" } ] }, "Anbieter2": { "Source": "articles_suggestions_beny.Anbieter2", "File_Field_Adapter": { "File": "beny.charset_conversion" } }, "Preis2": { "Source": "articles_suggestions_beny.Preis2", "Field_Adapter": [ { "float_pricision": [ 2, ",", "." ] }, { "add_string": "\u20ac" } ] }, "Anbieter3": { "Source": "articles_suggestions_beny.Anbieter3", "File_Field_Adapter": { "File": "beny.charset_conversion" } }, "Preis3": { "Source": "articles_suggestions_beny.Preis3", "Field_Adapter": [ { "float_pricision": [ 2, ",", "." ] }, { "add_string": "\u20ac" } ] }, "Werbepreis": "()", "MARKETPLACE": "articles_suggestions_beny.MARKETPLACE", "RANKING": { "Source": "articles_suggestions_beny.RANKING", "In_Export": "no" } } |
| Filters | [ { "Filter": { "name": "nur ost hwg 10 30", "condition": "((Hwg == '10') or (Hwg == '30')) and (Firm == '1')", "reason": "nur ost hwg 10 30" } } ] |
| Datapool | suggestions_beny_ost_hwg_10_30 |
| Primary_Key | [ "Firm", "No", "Asnr", "RANKING", "MARKETPLACE" ] |