Import with simple quote generate html entity... #62449

Hi Tharuna :)

The debug log show : No debug log available
and the file is very "simple", i use the import example for product with a csv file like this :

product_skuproduct_namemanufacturer_namecategory_pathresumeproduct_parent_skupublisheddispo
P000001Bande résiliente en fibre de bois - STEICO phaltexSTEICOIsolation|Isolation/Fibre de boisLa bande résiliente phaltex empêche les fissurations des cloisons et limite la transmission du bruit.~~1Stocké
P000002Bande résiliente en liège aggloméréSTEICOIsolation|Isolation/LiègeBande résiliente pour une isolation phonique entre lambourdes et lames de parquets ou en semelle pour désolidarisation de murs ou cloisons.~~1Stocké
P000003Billes de carbone expansé - EcographiteBIOFIBIsolation|Isolation/Isolants en vracIsolant thermo-acoustique à base de carbone expansé à déverser ou injecter pour l'isolation en sous-toiture, en vide sanitaire, sous le plancher, derrière toute paroi extérieure ou toute cloison.~~1Stocké
P000004Chanvre et coton en vrac - Jetfib'naturMETISSEIsolation|Isolation/Isolants en vracProduit d'isolation thermique en vrac constitué de fibres de chanvre et de coton pour soufflage en combles perdus et planchers caissons. ~~1~Sur commande

So nothing "exotic" here :)
Check for example the product name like the one i put in bold here.
You can see also that I have changed the separator symbol for the import (to avoid issue with comma in description for example)

Thanks for your help :)
Xavier

Hi Tharuna,
Sure, it shows the quote in your results, as mine, but in the database, it is encoded in the table with ?#39;

I had to manually correct all the product name : open each one, save.

This is shown in example with children products in a dropdown : all the html entities are not decoded...

Thanks for the help :)
Xavier

I use VirtueMart 3.6.10 10211

And unbelievable... i do it again to verify, i get the ?#39; in my list.
To show you, i start again to show you in video... and tried 3 times to show you.... THE QUOTES WAS CORRECT !!!!

I cant understand... maybe an evil devil playing with me (it was showing the code in the first test before recording the video !!!)... Why is this working well when i want to show you ?
Mistery for me... If this is happening again, i will then show you a page.

I complete this with the video i made : you will see another issue i see here.
In my import file, i have the short desc product, the name in my file is "resume" (résumé in french means short desc).
Now, even if i have this "resume" in the csv file, it does not import the content...

Check the video, you'll see (start à 5'30'') for the short description import..
As this is 12,5Mo, i put it here on my dropbox : https://www.dropbox.com/s/3qvwm52v3ek5wf7/csviissue-2020-04-23_13-01-48.mkv?dl=0

(so mad to not be able to show you, as if this happened before and i don't know why, for me, my issue remains...).

Thanks for your answer and your time Tharuna :)

Xavier

Tharuna,
Thanks so much to give me this answers : i know it is so "obvious" for you but more less for me as i discover the component (i know the very old one when virtuemart 1 was running but this new one is far more developped !).

Thanks for this answers, all is ok (so far !).

I will come back in this post if i get again the ?#39; curse from the little devil in my computer ;)

Best wishes and thanks again :)
Xavier