[Solved] Incorrect text encoding for Cyrillic characters when import UTF-8 CSV-file

Advanced Renamer forum
#1 : 09/02-18 01:05
Ivan
Ivan
Posts: 3
I described everything in the topic title.

Screenshot with error: http://i.imgur.com/aArhiHc.png

Files for Test: https://cloud.mail.ru/public/BBxW/11C3QLoRg


09/02-18 01:05 - edited 20/04-18 13:34
#2 : 09/02-18 03:39
Brian Hanlon
Brian Hanlon
Posts: 29
Reply to #1:
Verified behaviour. As there is a space in the original filename, I even tried quoting the filenames - no change. I looked at that csv file with a Hex editor, which led me to try Unicode, still no change.

My best suggestion is to use an approach similar to the suggestion for '1 source file, multi files' - see:

https://www.advancedrenamer.com/forum_thread?for um_id=4829

If you can get the Renaming done by using a batch file produced in that manner, then all is good, job done. If that method does NOT work, then you would have to start investigating just what codepage(s) your System is set to use.

Cyrillic and Chinese or Japanese characters have always given Windows great big headaches. - There are just so many different ways of encoding / decoding any character which is outside the old ANSII Punch-card range, and very often, it all happens "under the hood", hidden from the user. Even EXCEL and other spread-sheets can create errors when they import a csv which was exported by the same programme! - That's why I suggest Copy/Paste in my answer to '1 source file, multi files' rather than relying on a spread-sheet exported file.

Hope this helps a little, and gets your job done.

Brian.

----------
If this brilliant little tool has saved you time, or helped get your files in a better order, or just cleaned-up the crazy names from downloaded files, maybe you could donate a Dollar or Ten to Kim?
See https://www.advancedrenamer.com/download


09/02-18 03:39
#3 : 11/02-18 16:57
Kim Jensen
Kim Jensen
Administrator
Posts: 783
Reply to #1:
Thank you for supplying test files. It can be difficult to test such encoding issues.

The problem is that the file is encoded with UTF-8. The CSV import does not support UTF-8 in current version. In the next version of Advanced Renamer the CSV import will support UTF-8.


11/02-18 16:57
#4 : 22/02-18 15:04
Ivan
Ivan
Posts: 3
Reply to #3:
Thank you! You can to email me if you need the testers.


22/02-18 15:04
#5 : 22/02-18 15:58
Mark
Mark
Posts: 174
Reply to #4:
This may well have been implemented in v3.81

Advanced Renamer 3.81 - 13. feb. 2018
* CSV Import: Default Apply To fields to name and extension instead of just name
* CSV Import: Program will remember field values when window is closed
* CSV Import: Changed to use UTF-8 encoding
* Renumber method: Fixed renumbering relative numbers when the number is very long
* When using media tags like Img or Video for folders the program will now use the properties of the first file in the folder
* Load list now supports UTF-8
* New case method did not support UTF-8 in the pattern match modes
* Fixed <Inc Nr> zeropadding and <Num Files> value when working with file pairs


22/02-18 15:58
#6 : 20/04-18 13:32
Ivan
Ivan
Posts: 3
Reply to #5:
Thanks!


20/04-18 13:32