ERPNext Conference 2019* ERPNext.com Blog

Getting Error while fetching report in CSV format

foundation

#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.

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