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.
draft
Raw YAML
Dateiinhalt
Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.
Engine: Unitize
Source_Config: importEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: shopware_orders_oms
Source_Primary_Key: [ordernumber]
Target_Primary_Key: [ordernumber]
Datapool: shopware_orders_oms
Read_Conditions:
- shopware_orders_oms.orderNumber != 0
Datapool_Definition:
ordernumber: VARCHAR(11) NOT NULL
invoice_firstname: VARCHAR(50) NOT NULL
invoice_lastname: VARCHAR(60) NOT NULL
customernumber_iwm: VARCHAR(60) NOT NULL
marketplace: VARCHAR(30) NOT NULL
marketplace_ordernumber: VARCHAR(50) NOT NULL
invoice_amount: VARCHAR(20) NOT NULL
Sql: SELECT DISTINCT orderNumber, billingFirstName, billingLastName, marketplace_name, marketplace_ordernumber, invoiceAmount
FROM shopware_orders_oms as t1 WHERE orderNumber != 0
Mapping:
ordernumber: t1.orderNumber
invoice_firstname: t1.billingFirstName
invoice_lastname: t1.billingLastName
customernumber_iwm: ()
marketplace: t1.marketplace_name
marketplace_ordernumber: t1.marketplace_ordernumber
invoice_amount: t1.invoiceAmount
Metadata
Erkannte Konfiguration
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Engine | Unitize |
|---|---|
| Source_Config | importEngine |
| Target_Config | unitizeEngine |
| Mysql_Engine | InnoDB |
| Default_Charset | latin1 |
| Source_Connection_Type | database |
| Source_Database_Connection_Service | DatabaseConnectionService |
| Source_Datapool | shopware_orders_oms |
| Source_Primary_Key | [ "ordernumber" ] |
| Target_Primary_Key | [ "ordernumber" ] |
| Datapool | shopware_orders_oms |
| Read_Conditions | [ "shopware_orders_oms.orderNumber != 0" ] |
| Datapool_Definition | { "ordernumber": "VARCHAR(11) NOT NULL", "invoice_firstname": "VARCHAR(50) NOT NULL", "invoice_lastname": "VARCHAR(60) NOT NULL", "customernumber_iwm": "VARCHAR(60) NOT NULL", "marketplace": "VARCHAR(30) NOT NULL", "marketplace_ordernumber": "VARCHAR(50) NOT NULL", "invoice_amount": "VARCHAR(20) NOT NULL" } |
| Sql | SELECT DISTINCT orderNumber, billingFirstName, billingLastName, marketplace_name, marketplace_ordernumber, invoiceAmount FROM shopware_orders_oms as t1 WHERE orderNumber != 0 |
| Mapping | { "ordernumber": "t1.orderNumber", "invoice_firstname": "t1.billingFirstName", "invoice_lastname": "t1.billingLastName", "customernumber_iwm": "()", "marketplace": "t1.marketplace_name", "marketplace_ordernumber": "t1.marketplace_ordernumber", "invoice_amount": "t1.invoiceAmount" } |