-2

For now the closest thing to an ETL process I can get is using the Import Wizard to upload data from a periodic SAP job. The problem is that our SAP implementation outputs a txt file that is failing to import. Please see below a sample of the txt files I am attempting to import.

Sample file

27.07.2018                                                                              Dynamic List Display                                                                                      1
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|  Material |Plnt|SLoc|Batch     |Created   |Created by|Last Chg  |Changed by|Year|Pe|PIB|Unrestricted|Stock in tfr|In Qual. Insp.|Restricted|Blocked|Returns|GrV     |Stock Category|Reserved qty|
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|  00R000002|US03|Z101|0021662831|19.12.2017|RFCDWP    |27.07.2018|PFPREMOTE1|2018| 7|   |    920,000 |      0,000 |        0,000 |    0,000 | 0,000 | 0,000 |1800  57|TWA999999     |      0,000 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Robpagan
  • 19
  • 2
  • 1
    It sounds like you've solved it. In future, please don't link to files just paste them in like I did. Also helps to be more descriptive than "failing to import" – Nick.Mc May 23 '22 at 07:57

1 Answers1

1

The import wizard was creating a "Column0" and although I was ignoring it, when selecting a data source the DataType had to be changed to "text stream" (string(x) might have also worked but I am ignoring the column later on anyways so I didn't care to find out)

Nimantha
  • 6,405
  • 6
  • 28
  • 69
Robpagan
  • 19
  • 2