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*
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@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-commun... Koha@lists.katipo.co.nz Unsubscribe: https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.kati...
Dear Russel this sound like a UTF16 Problem. Microsoft (=Excel) encodes the text in a „different“ format so the easiest way is to export to csv use a text editor to get the encoding to UTF8 This solution works for me Kind regards Hofrat Mag. Rainer Stowasser Head of Library and Archives ZAMG
Am 09.02.2022 um 12:04 schrieb Russel G. P. Shihepo <russellgeeps@gmail.com>:
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 http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha EXTERNAL EMAIL: Do not click any links or open any attachments unless you trust the sender and know the content is safe.
participants (3)
-
Boettcher, Uwe -
Russel G. P. Shihepo -
Stowasser Rainer