Page 1 of 1

Import passwords (CSV) with German Umlauts errorneous

Posted: Tue Jul 28, 2020 11:33 pm
by VolkerM
I imported an csv file (; separated) with German Umlauts. The German Umlauts are not decoded or maybe recoded correctly.
E.g. "Böttcher" becomes "Böttcher", "Schlüssel" becomes "Schlüssel", "Postfächer" becomes "Postfächer", " – " becomes " – " etc. (The latter one isn't a German Umlaut but a graphical sign, a dash).
I am using EPIM Pro 9.2 on a Windows 10 Notebook.

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 8:06 am
by admin
Was the CSV file stored in the UTF-8 (Unicode) encoding? If you could edit the file, leaving just couple of unimportant entries without passwords and forward to us, we would have a look at it. Thanks!

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 10:46 am
by VolkerM
Yes, it was. to ensure this, I imported it into Excel and exported it again as a csv file with codepage set to utf-8. Importing this led to the same error.
I shortened it and attached it. Thanks for your support!

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 9:24 pm
by mb65
I found out that Windows Editor is not working correct with coding of UTF-8

Try changing the coding with notepad++
(like in the attached screenshot)

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 10:32 pm
by VolkerM
I did the export again and shortened the csv file (w/ Notepad++).
From the beginning Notepad++ displayed it as utf-8 encoded. Umlauts are displayed correctly. See screenshot!
Then I imported this csv file to EPIM and found the Umlauts displayed errorneous. See second screenshot!

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 10:36 pm
by mb65
Konvertiere zu UTF-8 auch probiert?

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 11:09 pm
by Keldi
Converting into UTF-8 with BOM in Notepad++ should do the trick as EPIM will recognize the coding correctly after that.
 
epim_German-Umlauts.png
epim_German-Umlauts.png (31.87 KiB) Viewed 2494 times

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 11:33 pm
by VolkerM
Excellent! That did the trick. :D

Thank you very much, Keldi!

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 11:38 pm
by mb65
Als ob ich was ganz anderes gepostet hätte...

Re: Import passwords (CSV) with German Umlauts errorneous

Posted: Wed Jul 29, 2020 11:41 pm
by VolkerM
DIe Konvertierung nach UTF-8 (ohne BOM) hat nicht funktioniert!