Categories
View Replies (4)

Resolved problem with product_desc in export

  1. ivordg
    ivordg
  2. RO CSVI
  3. Tuesday, 12 July 2016
  4.  Subscribe via email
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
0
Responses (4)
ivordg
ivordg
Accepted Answer Pending Moderation
great, it works now! :)
thank you
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
ivordg
ivordg
Accepted Answer Pending Moderation
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
Attachments (1)
CSVI_ExampleVirtueMartProductexport_13-07-2016_00.13.csv
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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