Line breaks in textarea fields break CSV export

[lkssmnt]

It seems like linebreaks in textarea fields are not correctly escaped and thus break the csv file when exporting. In this case I added a line break (pressed Enter) right after "Before linebreak.".

ID;Name;Email;Description;Received
;Lukas Siemoneit;hello@lsiemoneit.de;Before linebreak.
After linebreak.;2025-11-19 13:02:34
;Lukas Siemoneit;hello@lsiemoneit.de;Another text with spaces.;2025-11-19 12:36:38
;Lukas Siemoneit;hello@lsiemoneit.de;A text with spaces.;2025-11-19 12:33:57

I confirm that the Troubleshooting chapter does not solve my problem and that installation does not contain any custom form templates.

[lkssmnt]

A quick fix I did was add a csvLine function:

private function csvLine(array $columns): string
{
  $normalized = array_map(static function ($value) {
      if ($value === null) {
          $value = '';
      } elseif (is_bool($value)) {
          $value = $value ? '1' : '0';
      } elseif (is_array($value)) {
          $value = json_encode($value, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
      } elseif (is_object($value)) {
          if (method_exists($value, 'value')) {
              $value = $value->value();
          } elseif (method_exists($value, '__toString')) {
              $value = (string) $value;
          } else {
              $value = json_encode($value, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
          }
      }

      $string = (string) $value;

      return str_replace(["\r\n", "\r"], "\n", $string);
  }, $columns);

  $stream = fopen('php://temp', 'r+');
  fputcsv($stream, $normalized, ';');
  rewind($stream);
  $line = rtrim(stream_get_contents($stream), "\r\n");
  fclose($stream);

  return $line;
}

and then adapt the download function in Request.php like this:

public function download()
{

    $output = null;

    $parseField = static function ($field) {
        $array = json_decode($field->value(), true);
        unset($array['summary']);
        return array_values($array);
    };

    foreach ($this->container->drafts()->sortBy('received', 'desc') as $b) {

        $content = $b->content();
        $received = $content->received()->toValue();
        $id = $content->slug();

        if ($output === null) {
            $header = array_merge(['ID'], $parseField($content->formfields()), ['Received']);
            $output = $this->csvLine($header) . "\n";
        }

        $row = array_merge([$id], $parseField($content->formdata()), [$received]);
        $output .= $this->csvLine($row) . "\n";
        
    }
    
    return $output;
}

[plain-solutions-gmbh]

Thanks for report. could you create a pull request for your recomodation, that i can implement it to the next version?
Free license is waiting. 😉

[plain-solutions-gmbh]

Thanks. Your pull request is merged on v5.1.8. Send me an mail to info@plain-solutions.net for a free license for your effort.