News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Special characters

Started by gpessoa, October 18, 2012, 20:32:10 PM

Previous topic - Next topic

gpessoa

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,
J 4.4.4; VM 4.2.6; PHP 8.3.6

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

ArtRight

Hello!

The following worked for me, for importing special characters into virtuemart:

1--Use the HTML name/number:  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.  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!