Categories
View Replies (2)

Resolved Product export - paragraph tags identified as new row in excel

  1. colin-magee
    colin-magee
  2. RO CSVI
  3. Thursday, 22 October 2020
  4.  Subscribe via email
Hi, I am trying to perform a product export. The product description fields contain html. Every time I import into Excel the second opening paragraph is being identified as a new row instead of a continuation of the previous row's description field. I'm specifying a Field Delimiter of | and Text Enclosure of " (but have tried various things here). Have also tried exporting as normal csv and as Excel csv and have tried opening with Notepad and saving as different encoding but no matter what I do it does not make any difference. Can someone help please ? Small sample file attached, thank you.
Attachments (1)
product-export-example.txt
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
It is possible that you have line breaks in your product description field and that is causing break in description content. We have explained this in Replacing of line breaks in RO CSVI Exports document. You need to create RO CSVI Multi replace rule for product description field as explained in the document and then run the export. Let me know if that solves your issue.
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. # Permalink
Responses (2)
colin-magee
colin-magee
Accepted Answer Pending Moderation
Thanks a lot - yes that was it.
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


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