Getting Error while fetching report in CSV format

ERPNext Reports
1

Hello All,

I am getting an error while fetching report in CSV format from report builder. Attaching screenshot for reference.
In excel format working fine.

erpcsvexporterror
erpcsvexporterror901×456 54.2 KB

Release detail:
[bench@LS27 frappe-bench]$ bench --version
4.1.0
[bench@LS27 frappe-bench]$ bench version
bench_manager 0.0.1
erpnext 11.1.38
frappe 12.x.x-develop

2

Fetch the file in excel format and then Save-As?

3

Trent’s suggestion may work.

But expect problems since your branches do not match - erpenxt is on master while frappe is on develop

4

@clarkej thanks for your reply. As per your suggestion, I changed the branches and did the same (for erpnext and frappe) but no luck. still getting same error.

[bench@LS27 frappe-bench]$ bench version
bench_manager 0.0.1
erpnext 11.1.47
frappe 11.1.42

5

ok to recompile the lot may help

frappe@erpnext:~/frappe-bench$ find . -name '*.pyc' | xargs rm -f
6

I am using Japanese if I changed the python version as 2.7 then it works but while open CSV file in excel it shows the encoding issue,

If I use python 3.6 it gives the same error as mentioned above. please help me out.

7

I can’t say what the problem is here perhaps Japanese locale related.

To set a debug breakpoint in the for loop in export_query, to view the data, would help identify first hand say the line in the export file that is causing the problem.

best wishes