I am using CS-Cart 4.13. I had this issue in my store front where I imported the data with the XML and CSV add-on by Simtech. The special characters in my CSV file are displayed as is and aren’t converted to the proper format.
I tried to encode using R, and I was successful. However, when I tried to save the CSV with UTF-8 with Ms-excel, it didn’t work. I am confused. I want to know if there is an automatic mechanism that handles the special characters during the import or if it depends on the file. Now, saving the file with excel should have done the trick but it did not. Is there any other thing I am missing? Does CS-cart have an automatic setting for UTF-8 characters?
Unfortunately, from your post, I was unable to understand what exactly is the issue. Could you please provide some additional details?
I meant if the CS-Cart system automatically handles the special characters and converts them. Like TM, Registered mark, and all. They have to be UTF-8 encoded for that, right? The CSV file?
Yes, sure it has to be in UTF-8.
Yes, but when I use the “Save As” function in Ms-Excel, to save the CSV file with “UTF-8” encoding, and then I import the CSV file, some of the encoded characters are not processed properly. Some work fine and there are issues with some.
When I use R to do it and use “Save As” as CSV without UTF-8 encoding, it works. Is that an issue with the overwriting part in Excel?
Open the csv file with Notepad++ or similar. Look at the bottom for the encoding. If it says “Windows (CR LF) ANSI”, then select “Encoding” and “Convert to UTF-8” then save the file.
In Excell, make sure that it saves all Web pages as UTF-8
instead of excel… use open office…
when u save as CSV, check settings, and chose directly UTF-8