Where or what can I change in order to CSVI let me import special characters or words with accents like: ç or é or ã or may others...
Thanks in advanced,
CSVI support can be found on http://www.csvimproved.com/
Hello!
The following worked for me, for importing special characters into virtuemart:
1--Use the HTML name/number: http://www.ascii.cl/htmlcodes.htm (http://www.ascii.cl/htmlcodes.htm)
Do a find/replace in your excel .csv, for example replace "," with ",".
2--Install this AWESOME Excel add-in: http://www.vbaexpress.com/kb/getarticle.php?kb_id=805 (http://www.vbaexpress.com/kb/getarticle.php?kb_id=805). It allows you to save your excel file with any delimiter and text enclosure (qualifier) of your choice. I was having trouble with the " enclosure (because I was using csvi to import METAdata into virtuemart, which requires the real " character) ... now I use ~ with csvi and it works great. Uncheck the "use leading delimiter" and "use trailing delimiter" boxes. enter cell "range" in this format: A1:R234.
I hope that this helps people, I imagine that it is a very common issue!