Import passwords (CSV) with German Umlauts errorneous

Support related problems and questions

Moderators: Max, TerryRogers

Post Reply
User avatar
VolkerM
Novice
Posts: 32
Joined: Fri Aug 09, 2013 7:51 pm
Has thanked: 12 times
Been thanked: 2 times

Import passwords (CSV) with German Umlauts errorneous

Post 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.

admin
Site Admin
Posts: 8672
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 794 times
Been thanked: 426 times

Re: Import passwords (CSV) with German Umlauts errorneous

Post 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!
Android version of EssentialPIM. Keep all your data in sync!

User avatar
VolkerM
Novice
Posts: 32
Joined: Fri Aug 09, 2013 7:51 pm
Has thanked: 12 times
Been thanked: 2 times

Re: Import passwords (CSV) with German Umlauts errorneous

Post 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!
Attachments
Passwortexport_sample.txt
I had to rename the extension from csv to txt because of the phpBB import filter !
(1022 Bytes) Downloaded 8 times

mb65
Novice
Posts: 19
Joined: Tue Aug 29, 2017 9:50 pm
Been thanked: 1 time

Re: Import passwords (CSV) with German Umlauts errorneous

Post 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)
Attachments
20200723_123338.jpg

User avatar
VolkerM
Novice
Posts: 32
Joined: Fri Aug 09, 2013 7:51 pm
Has thanked: 12 times
Been thanked: 2 times

Re: Import passwords (CSV) with German Umlauts errorneous

Post 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!
Attachments
Notepad++ screenshot showing utf8 encoding
Notepad++ screenshot showing utf8 encoding
EPIM screenshot showing the result of the import
EPIM screenshot showing the result of the import

mb65
Novice
Posts: 19
Joined: Tue Aug 29, 2017 9:50 pm
Been thanked: 1 time

Re: Import passwords (CSV) with German Umlauts errorneous

Post by mb65 »

Konvertiere zu UTF-8 auch probiert?

Keldi
Guru
Posts: 173
Joined: Thu Aug 23, 2012 11:42 am
Has thanked: 12 times
Been thanked: 40 times

Re: Import passwords (CSV) with German Umlauts errorneous

Post 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 2499 times

User avatar
VolkerM
Novice
Posts: 32
Joined: Fri Aug 09, 2013 7:51 pm
Has thanked: 12 times
Been thanked: 2 times

Re: Import passwords (CSV) with German Umlauts errorneous

Post by VolkerM »

Excellent! That did the trick. :D

Thank you very much, Keldi!

mb65
Novice
Posts: 19
Joined: Tue Aug 29, 2017 9:50 pm
Been thanked: 1 time

Re: Import passwords (CSV) with German Umlauts errorneous

Post by mb65 »

Als ob ich was ganz anderes gepostet hätte...

User avatar
VolkerM
Novice
Posts: 32
Joined: Fri Aug 09, 2013 7:51 pm
Has thanked: 12 times
Been thanked: 2 times

Re: Import passwords (CSV) with German Umlauts errorneous

Post by VolkerM »

DIe Konvertierung nach UTF-8 (ohne BOM) hat nicht funktioniert!

Post Reply