Letter formatting in csv

1

Hello,

I have a problem with formatting Polish characters when exporting to csv. Everything is ok on the board, the problem occurs only when I open the csv file in Excel. What is interesting, when I open csv file using notepad or notepad++ Polish characters are displayed correctly. Does anyone know what the problem is or how to fix it?

How is in board view:
image

What i get in excel:
Polish letters: ą, ć, ę, ł, ń, ó, ś, ź, ż

2

try method 2

3

Can we get a public link to a document / task / whatever for our own tests?

4

Great, the second method actually works, thanks, it is a significant improvement. It’s a pity that it’s not possible to change this so that when opening the file normally, it opens already properly formatted.

5

Does anyone know of a way to not have to import the file, but just open it with the correct formatting?

6

I found a solution, in file app\Core\csv.php, i think bom was missing i added in write section line 110, like this and now is working:

public static function output(array $rows)
{
$csv = new static;
$csv->write(‘php://output’, $rows);
}

To this:

public static function output(array $rows)
{
$csv = new static;
header(‘Content-Type: text/csv; charset=utf-8’);
header(‘Content-Disposition: attachment; filename="’.date(“Y-m-d”).‘_export.csv"’);
echo “\xEF\xBB\xBF”; // add BOM
$csv->write(‘php://output’, $rows);
}

1 Like