Page 1 of 1
AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut
Posted: 2023-03-08 15:45
by onoehring
Hi,
I am trying to import from a CSV where strings are containes in double quotes. This works, but only, if the strings do not contain german umlauts (öäüß).
If this is the case, either
- the rest of that string is not written to the field
- OR the field stays completely empty
- OR the record is not imported at all
Olaf
Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut
Posted: 2023-03-08 16:14
by jsetzer
I the CSV file encoded properly? Utf8?
Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut
Posted: 2023-03-10 16:26
by onoehring
Hi Jan,
I am not sure, but as the textstrings were embedded in doublequotes I do not see a reason, why it should break the import. Especially as different things occured: rest of the string missing, complete record missing.
Olaf
Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut
Posted: 2023-03-10 16:48
by jsetzer
Just from my experience: if there are problems with German Umlaute or other special characters during file-processing, first check encoding! It takes just 2 seconds and can save hours of search.
Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut
Posted: 2023-03-10 17:05
by onoehring
Hi Jan,
will do that next time. I did not think it could be the encoding (could have win windows-ansi as I exported data from Access to CSV and also to Excel from where I copied and pasted to notepad++).
Thanks for the hint anyways.
Olaf