[Koha] ISSUE with Umlaut

[Boettcher, Uwe]

Dear Russel,

sounds to me as if the character encoding does not match. Try to make sure that the data is stored in UTF-8 (Unicode) character encoding before importing. Excel uses ANSI by default, which usually messes up special characters. 

Hope that helps.

Best

Uwe Boettcher
Germany - home of the Umlaut ;-)

-----Ursprüngliche Nachricht-----
Von: Koha <koha-bounces at lists.katipo.co.nz> Im Auftrag von Russel G. P. Shihepo
Gesendet: Mittwoch, 9. Februar 2022 12:04
An: Koha at lists.katipo.co.nz
Betreff: [Koha] ISSUE with Umlaut

Dear Community

I have a prepared data set in excel format (.xlsx), some of it contains umlaut (German texts)  and click sounds symbols of African languages such as field 245, and  260. But whenever I import the file to MARC editor through the Delimited Text Translator, I lose all the umlaut and punctuation marks for click sounds in the data.
Does anybody have a clue or alternative method that can be used to take records from excel files to MARC editor without losing umlaut?

Regards
Russel Shihepo
*Librarian*
*Africa/Namibia*
_______________________________________________

Koha mailing list  https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=04%7C01%7Cuwe.boettcher%40whu.edu%7Cedc3690f3eec493cd26908d9ebbbfa37%7Cfd0fb88881d0438694628a094cc4592e%7C0%7C0%7C637800014865614203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=g7OAxKgcM2gOPX8T1kYqsgdstVGh46rbxLitAxBCR6c%3D&reserved=0
Koha at lists.katipo.co.nz
Unsubscribe: https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=04%7C01%7Cuwe.boettcher%40whu.edu%7Cedc3690f3eec493cd26908d9ebbbfa37%7Cfd0fb88881d0438694628a094cc4592e%7C0%7C0%7C637800014865614203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=wIwwHMw%2FYIrXhegK266lDoZYHQhIIcDa8puWDm%2FCpmw%3D&reserved=0