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?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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."
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."
Accepted Answer
Pending Moderation
Hello,
Can you post your latest import file to check?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »