Hello,
J4 Seblod4 Importer4
When importing articles with some type (csv file with pipe separator) a part of them are right imported, an other part is cancelled. But I don't see any problem in the cs file for these articles comparating to others. For exemple no pipe in introtext ;)
Have somebody an idea ? Why an article may be cancelled during import ?
Thanks
The import works when I deleted introtext field for theses contents. So, there is something in this field. But I don't see anything wrong.
For exemple :
<div><img style="margin-right: 20px; margin-left: 20px;"
alt="logo-chvStMartin" src="/images/adresses/logo-chvStMartin.jpg"
height="201" width="200" /></div>
<div>
<p>Le CHVSM s’inscrit dans la chaîne des soins vétérinaires en
regroupant l’ensemble des services concernés par la santé des
animaux de compagnie : médecine, soins
continus, chirurgie, imagerie
médicale, ophtalmologie, dermatologie, laboratoire
d’analyses, soins spécialisés aux nouveaux animaux de
compagnie.</p>
<p><br />Les consultations se font sur rendez-vous du lundi
au vendredi, de 8h à 19h30, le samedi de 8h à 12h30.</p>
<p>Urgences en permanence, 24/24h et 365 jours/an.</p>
</div>
As a reminder, separator for the csv is pipe |
So : import work's when I replace ’ by ' in the text. So, I think there is a problem in mysql request for import because of the character ’. My csv file for importing has been created by Seblod Exporter. It seems necessary Seblod exporter to escape ’
See post about Exporter
In fact, it seems to be a problem of encodage. œ make also problem.
Hello, I think it's resolved : just don't make UTF8 forced when importing.