When I import my excel input file Anki doesn’t detect that entry already exists and thus creates duplicates. Each time I upload my excel file I have to delete manually entries which contain a ć.
The whole entry is like this #word picture gender,personal connection, extra info (back side) pronunciation (recording and/or IPA) test spelling tags
odeća IPA(key): /ôdet͡ɕa/ ȍdeća f (short vowel with falling tone)
Sing Nom. odeća Gen. odeće Dat. odeći Akk. odeću Lok. odeći Ins. odećom Vok. odećo!
Wear comfortable, loose clothing to your exercise class. Nosite udobnu široku odeću na času vežbanja. weibliche Substantive in der Regel auf ein -a enden. [sound:odeća.mp3] y clothing
It looks as if Anki has difficulties with word1.
The note type is picture words. Import option is
Update existing notes when first field matches.
Allow HTML in fields is ticked.
I mean you appear to only have uploaded the Excel file, without the deck package. See Exporting - Anki Manual for info on exporting decks. This is also needed so I can test with the same note type that you’re using.
I guess the problem is that the first field in your note type is set to a field you don’t want to check duplicates against. Anki only checks for duplicates in the first field (the one that appears at the top of the note editor).
You can go to Tools > Manage Note Types, select the note type you’re using, click fields, and use the Reposition button to reposition the field you want Anki to check for duplicates in (the “word” field I guess) to be the first field.
625 wichtigsten Wörter auf Serbisch csv Vorlage notiz typ picture words.csv
import settings are such
that
update existing notes when first field matches.
This setting works for 90% of the notes just not for the notes with character “ć” like in iseći / seći / odeća / ćerka / naći / ići / srećan / kuća / cveće .
Unfortunately the find duplicates function is not that helpful either.
Technical details: some characters like “ć” can be written using either two separate codepoints for both the “c” letter and the accent (U+0063 + U+0301), or alternatively as a precomposed character (U+0107). The two forms should be treated as equivalent for comparison purposes but Anki was failing to do that when importing.