Hi,
When I export my products to csv, I notice that the content inside the product_desc field is not exported in the right columns and rather spread across several other columns containing different field names. I tried changing text delimiters but no luck. Is there a setting that prevents my export to be distorted like this?
thank you
Ivor
Hello Ivor,
You must use both the field delimiter and text enclosure. If you set the field delimiter to a comma and the text enclosure to a double-quote " then the data can be read fine.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi,
Thanks, but I have tested it with those settings as well. The problem arises with html coded content inside the 'product_desc' field. I have attached a shortened version so you can have a look.
thank you
Hello Ivor,
The problem could be because of line breaks, can you try to use OpenOffice/LibreOffice to open the CSV file and see if it looks good?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
great, it works now! :)
thank you
Log in to reply to this topic.