I'm try to import my customers from magento1 to magento2 but got a few errors on import validation.

The import is aimed at a german shop so special chars like "ä, ö, ü" are pretty common, especially in names and addresses.

I have to change the charset but can't find any spot to do that. So here's the question:

• Where do I change the charset to make the import possible ?

• What do I wrong if it isn't the charset ?

Charset is: utf8_general_ci

  • If your tables have utf8_general_ci set as default charset, all should be OK. Make sure your import scripts have the correct charset too. – Julien Lachal Jan 18 '17 at 13:42
  • blame me... got the wrong charset on the csv. Thanks man. – Marcel H. Jan 18 '17 at 15:14
  • These things happen haha. I suggest you answer your own question and accept it, or if you think you question wasn't really due to a bug in the first place, close it. – Julien Lachal Jan 18 '17 at 15:23

Problem solved:

The default charset of my CSV editor wasn't UTF-8.

Thats why the import was invalid. Once i changed the csv charset in my editor to UTF-8 the import was valid.

So, the issue is

Wrong charset on my .csv file

|improve this answer|||||
  • You can explain more details? – Khoa TruongDinh Jan 19 '17 at 2:10
  • 1
    The default charset of my csv editor wasnt UTF-8 - Thats why the import was invalid. Once i changed the csv charset in my editor to UTF-8 the import was valid – Marcel H. Jan 19 '17 at 11:30
  • btw when exporting, UTF-8 BOM is the encoding used (Idk if this affects smth, thought I should mention it) – medmek Oct 8 '18 at 13:06
  • But! if you can't change file encoding? In my case i get data from the file that located on another server by FTP. In this case nee to encode "Name" "on fly". – orthener 2 days ago

We can use this website to encode your special characters: http://www.web2generators.com/html-based-tools/online-html-entities-encoder-and-decoder

After getting the encoded chars, we need to use the string replace tool to replace the special characters.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.