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

Relaterade inlägg	Svar	Vyer
Cannot import valid CSV import validate csv	1 juli 15	6842
Why no new client is created after importing a CSV file? error import csv	0 mars 15	4998
import file.csv error. How to fix it? error import csv totrongdanh	1 mars 15	8938
How to import parameter to OpenERP? error import csv parameters	1 mars 15	7042
Error importing CSV file to Odoo 15 error attachment import csv v15	3 okt. 23	5446

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!