search

YetiForceCompany / YetiForceCRM

Our team created for you one of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
https://yetiforce.com
Other
1.72k stars 742 forks source link

Data Import Problem with Umlauts #17393

Open ralphkretzschmar opened 6 months ago

ralphkretzschmar commented 6 months ago

Dear Yetiforce Team,

i'm testing YetiForce 6.5 When i try to import testdata it identifies accounts as duplicates but they are not really duplicates.

Example data (csv-content):

Organisationnames: Müller Muller Möller Moller

When trying to import these organisation names as accounts it idetifies "Müller" as "Muller" -> false duplicates (in germany we have Ü Ö Ä etc.)

So i can't import such data because of false duplicates

Best regards Ralph

ralphkretzschmar commented 6 months ago

After digging more into deep i recognized that it was the config of mysql db. Sorry for the false report.

Best regrads Ralph

ralphkretzschmar commented 6 months ago

Unfortunately its not only the DB i thought i have to convert it to another collation like "utf8mb4_bin" of the DB. but this has negative side effects. i guess the comparison for accountnames has to be done at code level?

s2b-git commented 6 months ago

Open CSV in Notepad ++ and change encoding to UTF-8 BOM. Save / import

ralphkretzschmar commented 6 months ago

Thank you @s2b-git a lot your tip, but unfortunately it doesn't work out.

A simple example as well is when you create an accountname "Möller GmbH" and afterwards you can search for "Moller" and it finds "Möller GmbH". This gets even more tricky if you try to import Contacts -> the contacts will be associated to the wrong company.

Best regards Ralph