Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

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

By
ton123
on 7/29/13, 4:08 PM 2,153 views

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?

0
Danimar Ribeiro
On 5/18/15, 10:49 AM

Probably still has this bug.

https://bugs.launchpad.net/openobject-server/+bug/1100907

The problem is with % characters in your csv.

0

ton123

--ton123--
1418
| 5 6 9
Lisse, Netherlands
--ton123--
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
ton123
On 8/10/13, 5:48 AM

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 Company" in the Company name starting with a "B". No result. I changed the import field in "External ID" No result.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 7/29/13, 4:08 PM
Seen: 2153 times
Last updated: 5/18/15, 10:49 AM