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-boun...@lists.katipo.co.nz> Im Auftrag von Russel G. P. Shihepo Gesendet: Mittwoch, 9. Februar 2022 12:04 An: Koha@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@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
