1. dagoberto
  2. RO CSVI
  3. Saturday, 09 December 2017
  4.  Subscribe via email
Joomla -3.8.1
VM -3.2.2
CSVI Pro -7.3.2

Hi,

I've imported product_sku and product_desc. My delimiter are comma and double quotes. The only problem I have is the double quotes are showing up in my product description on the front end. e.g. "Another nice ornate, moulded mirror in antique gold."

How do I stop the quotes from appearing in the frontend please?

Jamie
Accepted Answer Pending Moderation
Hello Jamie,
Can you post the sample of your import file along with import debug log to check?
Kind regards,

Tharuna

=========================
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. # 1
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Jamie,
You don't seem to have double quotes as text delimiter in your import. The double quotes is only on product_desc field and not on product_sku . If you want double quotes as text enclosure then you need to use it around both of fields product_sku and product_desc and set Text Enclosure to " on File tab in your import template settings as you have set Auto detect delimiter to No. If you want CSVI to detect the delimiters then set Auto detect delimiter to Yes and save the template.
Kind regards,

Tharuna

=========================
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. # 3
Accepted Answer Pending Moderation
Hello Jamie,
I noticed that you are having 3 double quotes around your product_desc text where it should be only one. You need to correct that in your file so you don't see the double quotes in your product description.
Kind regards,

Tharuna

=========================
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. # 4
Accepted Answer Pending Moderation
I've loaded only the following products but still can't get rid of the double quotes.
I've tried removing the apostrophies and this also has no effect.

product_sku product_desc
16896 "Argente' mirrored coffee table. Elegance with 'bling'."
16897 "Argente mirrored console table. Suitable for ornament display or simply reliant on its own merits."
16899 "Argente mirrored wardrobe. One of the most striking features in the entire range."
16900 "Argente king size mirrored bed. Don't reflect too much on this item."
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Can you post your latest import file to check?
Kind regards,

Tharuna

=========================
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. # 6
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
You import file still has three double quotes instead of one for product_desc field. If you open your import file using any text editor or open office you can see your import content as below. You need to correct those extra double quotes to not have double quotes in your product description.


product_sku,product_desc
16896,"""Argente mirrored coffee table. Elegance with 'bling'."""
16897,"""Argente mirrored console table. Suitable for ornament display or simply reliant on its own merits."""
16899,"""Argente mirrored wardrobe. One of the most striking features in the entire range."""
16900,"""Argente king size mirrored bed. Don't reflect too much on this item."""
Kind regards,

Tharuna

=========================
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. # 8
  • Page :
  • 1


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