Categories
View Replies (21)

Resolved VM3 Error when importing " character

  1. atrus
    atrus
  2. RO CSVI
  3. Wednesday, 15 July 2015
  4.  Subscribe via email
Hi Roland,

Noted an issue when importing VM3 product names which include a " character. More specifically not the whole product_name enters the database but only the name up to the " character.

The weird is that at the VM product List screen, the name is ok:

Twister Front Wiper Blade for Trucks 24" 600mm

But in the Product Edit Screen the product name is:

Twister Front Wiper Blade for Trucks 24

See attached import file and log.

Would appreciate your feedback on this.

Rgrds,
Chris
0
Responses (21)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Chris,

Not really a CSVI issue but rather an incorrect CSV file. By default a CSV file has a comma as field delimiter and a double quote as text enclosure. Since you are not specifying any text enclosure, the system takes the double quote as text enclosure. That is why it stops. A valid CSV line in your case would look like this:
"TFW-24";"trucks-front-wiper-blades";"Twister Front Wiper Blade for Trucks 24"" 600mm"
The 24" is double double quoted because it is a sort of escape character, so the quote remains and you get 24".
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!