AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut

Post by onoehring » 2023-03-08 15:45

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

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut

Post by jsetzer » 2023-03-08 16:14

I the CSV file encoded properly? Utf8?
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut

Post by onoehring » 2023-03-10 16:26

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

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut

Post by jsetzer » 2023-03-10 16:48

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.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: AG 22.14 rv 1293: CSV (new page) fails on record if string contains umlaut

Post by onoehring » 2023-03-10 17:05

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

Post Reply