Hi,
I found problem that Japanese strings become corrupted with export report to CSV.
I opened the exported file with UTF-8, then Japanese field names in first line is display correctly, but other lines are corrupted.
On brower, these strings is display correctly.
So, I modified the line 71 of report.export.php as below, then category name is display correctly.
if ($useCategory) {
if (0 != $data['category_parent']) {
$text[$i][] = $data['category_parent'];
} else {
$text[$i][] = $data['category_name'];
//$text[$i][] = $report->convertEncoding($data['category_name']);
}
}
It seems convertEncoding is not need with Japansese or not works correctly.
Best regards,
Hiromi Suzuki
V 2.7 beta 3 exported csv including corrupt Japanese str
Moderator: Thorsten
-
- Posts: 5
- Joined: Mon Aug 22, 2011 1:07 pm
Re: V 2.7 beta 3 exported csv including corrupt Japanese str
Hi,
do you use MS Excel, LibreOffice or Apple Numbers?
bye
Thorsten
do you use MS Excel, LibreOffice or Apple Numbers?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
-
- Posts: 5
- Joined: Mon Aug 22, 2011 1:07 pm
Re: V 2.7 beta 3 exported csv including corrupt Japanese str
Hi,
I opened the CSV file with text editor (sakura editor).
I also used MS Excel, but it display corrupted without first line.
Regards,
I opened the CSV file with text editor (sakura editor).
I also used MS Excel, but it display corrupted without first line.
Regards,
Thorsten wrote:Hi,
do you use MS Excel, LibreOffice or Apple Numbers?
bye
Thorsten
Re: V 2.7 beta 3 exported csv including corrupt Japanese str
Hi,
okay, I'll check it.
bye
Thorsten
okay, I'll check it.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist