How to solve CSV import validate error (unsupported format character)?

Question

I try to import an exported 6.1.1 products csv file to 7.0 . The validation error I get is:
"unsupported format character 'B' (0x42) at index 39"

I do not see this in my file. How can I solve this?

Danimar Ribeiro · Answer

Probably still has this bug.
https://bugs.launchpad.net/openobject-server/+bug/1100907
The problem is with % characters in your csv.

ton123 · Answer

There is a field Company in the importdata.
It is in all the import lines. So the error which indicateds there is something wrong with index 39 is not correct I think.
The data in this field company_id start with the character "B".
I think this is not recognized and this gives this error.
It is not recognized because I try to import in a fresh database. In this fresh database the Company name is "Your Company" and the company starting with the character "B" doesn't exist.

I changed "Your Compan

Powiązane posty	Odpowiedzi	Widoki
Cannot import valid CSV import validate csv	1 lip 15	6027
Why no new client is created after importing a CSV file? error import csv	0 mar 15	4169
import file.csv error. How to fix it? error import csv totrongdanh	1 mar 15	7492
How to import parameter to OpenERP? error import csv parameters	1 mar 15	5907
Error importing CSV file to Odoo 15 error attachment import csv v15	3 paź 23	4470

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!