Categories
View Replies (3)

Resolved VM Products Export CSV: How to handle CR/LF (end of lines)

  1. konstantinos29
    konstantinos29
  2. RO CSVI
  3. Tuesday, 22 October 2019
  4.  Subscribe via email
Hello,

I am exporting VM products into CSV, for later processing with custom PHP code interpreter.

Unfortunately, when including product short (or regular) descriptions, the line-breaks are included in the CSV file. A CSV row is broken into multiple lines, hence confusing the PHP interpreter.

What is the recommended way to deal with this situation?

Thank you

[Latest CSVi 7.14]
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In your export template on File tab set Text enclosure field to " and save the template and run the export.
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
konstantinos29
konstantinos29
Accepted Answer Pending Moderation
Thanks. It was already set to that.

The problem was with our custom PHP script responsible for post-processing the CSV files.
PHP's built-in CSV parser expects each record to be in a new line, hence in-field line-breaks create errors.

The solution was to use a 3rd party library.

Thanks again
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Glad to know that your issue is solved.
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!