Legacy YAML / Detail

export / export_quick_delivery_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_orders_quick_delivery_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: exportEngine
Target_Config: exportEngine

#Source
Source_Datapool: export_iwm_tracking_oms

Joins:
  - Left_Join:
    Datapool: export_iwm_orders_oms
    Join_Condition: export_iwm_tracking_oms.auftragsnummer = export_iwm_orders_oms.Auftragsnummer
  - Join:
    Datapool: mail_addresses_all
    Join_Condition: export_iwm_orders_oms.Kundennummer = mail_addresses_all.Kundennummer

Read_Condition_Vars:
  - date = date("d.m.Y", strtotime('-0 days'))

Read_Conditions:
  - (export_iwm_tracking_oms.verkaufshaus = 86) or (export_iwm_tracking_oms.verkaufshaus = 87)
  - export_iwm_tracking_oms.versanddatum = %date%

Mysql_Engine: InnoDB
Default_Charset: utf8

Datapool_Definition:
  Bestellnummer: VARCHAR(50) NOT NULL
  Vorname: VARCHAR(25) DEFAULT NULL
  Name: VARCHAR(25) DEFAULT NULL
  email: VARCHAR(50) DEFAULT NULL



Mapping_Vars:
  shop: 'oms'

Mapping:
  Include_Mapping_quick_delivery: quick_delivery


Filters:
  - Filter:
      name: Delivery not within 3 days
      condition:
        Cross_Dataset_Filter_Adapter: export_orders_quick_delivery__filterSlowDelivery
      reason: 'Delivery not within 3 days'
  - Filter:
      name: DuplicateIdentifierBestellnummer  #there must always be a space between the key and the comparision operator and between the parentheses
      condition:
        Cross_Dataset_Filter_Adapter: filterByDuplicateIdentifierBestellnummer
      reason: 'There is another dataset'
  - Filter:
      name: 'Name empty'
      condition: (Name == '')
      reason: 'Name empty'
  - Filter:
      name: MarketplaceOrders  #there must always be a space between the key and the comparision operator and between the parentheses
      condition:
        Cross_Dataset_Filter_Adapter: filterMarketplaceOrders
      reason: 'There is another dataset'

#Target
Datapool: 'export_orders_quick_delivery_oms'
Primary_Key: [Bestellnummer]

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Source_Config exportEngine
Target_Config exportEngine
Source_Datapool export_iwm_tracking_oms
Joins [ { "Left_Join": null, "Datapool": "export_iwm_orders_oms", "Join_Condition": "export_iwm_tracking_oms.auftragsnummer = export_iwm_orders_oms.Auftragsnummer" }, { "Join": null, "Datapool": "mail_addresses_all", "Join_Condition": "export_iwm_orders_oms.Kundennummer = mail_addresses_all.Kundennummer" } ]
Read_Condition_Vars [ "date = date(\"d.m.Y\", strtotime('-0 days'))" ]
Read_Conditions [ "(export_iwm_tracking_oms.verkaufshaus = 86) or (export_iwm_tracking_oms.verkaufshaus = 87)", "export_iwm_tracking_oms.versanddatum = %date%" ]
Mysql_Engine InnoDB
Default_Charset utf8
Datapool_Definition { "Bestellnummer": "VARCHAR(50) NOT NULL", "Vorname": "VARCHAR(25) DEFAULT NULL", "Name": "VARCHAR(25) DEFAULT NULL", "email": "VARCHAR(50) DEFAULT NULL" }
Mapping_Vars { "shop": "oms" }
Mapping { "Include_Mapping_quick_delivery": "quick_delivery" }
Filters [ { "Filter": { "name": "Delivery not within 3 days", "condition": { "Cross_Dataset_Filter_Adapter": "export_orders_quick_delivery__filterSlowDelivery" }, "reason": "Delivery not within 3 days" } }, { "Filter": { "name": "DuplicateIdentifierBestellnummer", "condition": { "Cross_Dataset_Filter_Adapter": "filterByDuplicateIdentifierBestellnummer" }, "reason": "There is another dataset" } }, { "Filter": { "name": "Name empty", "condition": "(Name == '')", "reason": "Name empty" } }, { "Filter": { "name": "MarketplaceOrders", "condition": { "Cross_Dataset_Filter_Adapter": "filterMarketplaceOrders" }, "reason": "There is another dataset" } } ]
Datapool export_orders_quick_delivery_oms
Primary_Key [ "Bestellnummer" ]