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:

What i get in excel:
Polish letters: ą, ć, ę, ł, ń, ó, ś, ź, ż
Can we get a public link to a document / task / whatever for our own tests?
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.
Does anyone know of a way to not have to import the file, but just open it with the correct formatting?
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