157 Posts
Hableur
1 year ago
4
Topic

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

Get a VIP membership
157 Posts
Hableur
1 year ago
0
Level 1

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 |

157 Posts
Hableur
1 year ago
0
Level 1

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

157 Posts
Hableur
1 year ago
0
Level 1

See post about Exporter

In fact, it seems to be a problem of encodage. œ make also problem.

157 Posts
Hableur
1 year ago
0
Level 1

Hello, I think it's resolved : just don't make UTF8 forced when importing.

Get a Book for SEBLOD