Hi Tharuna,
In fact, the import is fine. This is, as the video shows, an issue in Virtuemart during the saving of the product : as soon there is a " ' ".
In the database, the product name is then save with the #39 html entity. If shown in the page, all is shown "correctly" (as the page translate the entity), but in the dropdown, this is not "translated" and shown as it.
I was wandering if you know enough Virtuemart (either save, either the dropdown constructor in the subtemplate) to try to avoid this, or even if i create a new menu item in Joomla backend, how to run a php script to "correct" the name (with a replace).
So far, i know it is far away from your regular support perimeter (Ro CSVI) but as you have a good knowledge and also as you are "present" (when other support board have no answer at all...), i'm asking if you could help me by driving me here
I see 2 solutions :
1 - change the code of Virtuemart, either when i save the product, either when the dropdown is constructed to avoid the #39 on screen,
2 - create a mini script in php with something like "in the table xxxx_product_fr_fr, replace all the #39 by a ' "
but in both case, i dont know many little things like :
- how to run a script on a table in Joomla to replace a value in a column, and to run it from a backend menu directly
and
- if i modifiy Virtuemart, on the next update, i will loose all my "fixes", so is the script the best way ?
Anyway, i would understand if you answer me "hey man, wrong support board !"
Have a good day Tharuna
Xavier
