Altbestand / Detail

import / iwm_articles_texte_txt40_3

Mandant csv-pipeline-smoke
Altbestand
Managed Definition öffnen
engine Typ
valid Parse-Status
Managed Status
draft
importEngine Kurzinfo

Raw YAML

Dateiinhalt

Engine: Import
Source_Config: oster400
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService

Queries:
 - Query:
     GetQuery: SELECT TXKEYD, RIGHT(LEFT(TXKEYD,2),1) AS FIRMA, RIGHT(TXKEYD,6) AS ARTE, REPLACE(TRIM(T3ZTXT),'·','<br>·') as T3ZTXT, T3TBVW, T3TXZN, T3TBVW from IWMV2R1DTA.TXHD00 txhd
                                JOIN IWMV2R1DTA.TX4000 ON (txhd.TXTXNR = IWMV2R1DTA.TX4000.T3TXNR) AND (txhd.TXTXTY = IWMV2R1DTA.TX4000.T3TXTY)
                              where txhd.TXDTNM = 'ARTS00' and TXTXTY = 'SP' and TXSTAT = 'A' and T3STAT='A' and T3TBVW LIKE '%3%' and T3ZTXT != ''


     TargetDatapool: iwm_articles_texte_txt40_3

Metadata

Erkannte Konfiguration

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

Engine Import
Source_Config oster400
Target_Config importEngine
Mysql_Engine InnoDB
Default_Charset latin1
Source_Connection_Type database
Source_Database_Connection_Service DatabaseConnectionService
Queries [ { "Query": { "GetQuery": "SELECT TXKEYD, RIGHT(LEFT(TXKEYD,2),1) AS FIRMA, RIGHT(TXKEYD,6) AS ARTE, REPLACE(TRIM(T3ZTXT),'\u00b7','<br>\u00b7') as T3ZTXT, T3TBVW, T3TXZN, T3TBVW from IWMV2R1DTA.TXHD00 txhd JOIN IWMV2R1DTA.TX4000 ON (txhd.TXTXNR = IWMV2R1DTA.TX4000.T3TXNR) AND (txhd.TXTXTY = IWMV2R1DTA.TX4000.T3TXTY) where txhd.TXDTNM = 'ARTS00' and TXTXTY = 'SP' and TXSTAT = 'A' and T3STAT='A' and T3TBVW LIKE '%3%' and T3ZTXT != ''", "TargetDatapool": "iwm_articles_texte_txt40_3" } } ]