[Koha] ISSUE with Umlaut

[Stowasser Rainer]

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