Categories
View Replies (3)

Resolved Export product description line break (HTML) issue

  1. figee
    figee
  2. RO CSVI
  3. Wednesday, 20 July 2016
  4.  Subscribe via email
Hi,

I'm trying a simple export test, using "\" as a delimiter and exporting two fields:
product_SKU\product_desc

I'm running into a problem because the product descriptions have line breaks in between HTML tag blocks. I guess they are inserted by the editor. When I try to import the CSV, these line breaks are considered new entry (lines) for each new line break. Ideally these line breaks could be removed/ignored, except for after the last description tag (and a line break for the next SKU).

This means the output is something like this:
SKU1 \ DESC1_tagblock1
DESC1_tagblock2
DESC1_tagblock3
SKU2 \ DESC2_tagblock1
DESC2_tagblock2
etc

I've imported the CSV file into excel, using "\" as the delimiter and attached the xlsx (and original CSV), for a more clear picture.
I also tried to remove all line breaks (flattening the file to one line), but ideally the data would still have a line break for each entry, that is:

SKU1 \ DESC1
SKU2 \ DESC2

Any ideas how I could do this?

Thanks!
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Try opening your export file with OpenOffice/LibreOffice, this will manipulate line breaks. Let me know if it helps.
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
figee
figee
Accepted Answer Pending Moderation
Thanks for the response!

Is there a setting / something I should do in particular with OpenOffice? I tried opening it in OpenOffice, but the same problem exists (as in importing it to excel, or looking at it as a standard CSV).

Again, here's an example of what it looks like in OpenOffice or Excel. This is due to the line breaks after HTML blocks, which makes the interpreter think it should be a new entry:

product_name | product_desc
PRODUCT1 | <b>PRODUCT1</b>
<p>desc blah blah</p>
<p>desc line 2 blah blah</p>
PRODUCT 2 | <b>PRODUCT1</b>
<p>desc blah blah</p>
...

I would ideally like for line breaks to be between products, not in the middle of the HTML statements. For instance:

product_name | product_desc
PRODUCT1 | <b>PRODUCT1</b><p>desc blah blah</p><p>desc line 2 blah blah</p>
PRODUCT 2 | <b>PRODUCT1</b><p>desc blah blah</p><p>desc blah blah</p><p>desc blah blah</p>
...

Is there a way to enforce this with the CSVi export? Or do I have to post-process the export somehow? It seems like a common problem for anyone who uses markup in their product descriptions.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Is there a way to enforce this with the CSVi export? Or do I have to post-process the export somehow? It seems like a common problem for anyone who uses markup in their product descriptions.

Use text enclosures and comma or semi-colon instead of backslash for delimiter in your export template. Try export then and let me know if it solves.
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
  • Page :
  • 1


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