Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Facing an different scenario altogether. I had a master data csv created from the original MS-excel document. I have ensure it has got comma separator and UTF-8 encoding while saving it. When i try to import into customers, suppliers or products i am getting an error
utf8' codec can't decode byte 0x92 in position 15: invalid start byte
but when i try to import the same csv from ubuntu it succeeds in validation and import as well. Looks strange.
Can some one tell me where is the issue ? any one facing a similar issue of mine ?
Thanks in advance for your suggestions.
Using Excel to create UTF8 CSV files is problematic (sometimes saving as XLS instead of XLSX first produces different results, sometimes the UTF8 files are not in fact UTF8).
I have better luck using a different text editor, or using a codepage conversion program.
Also, don't overlook that some conversion may be happening when you move your files between operating systems.
Importing datas with MS Excel most of the time gives you this error except when you first export some datas from Openerp.
To solve this problem while using MS Excel just change the encoding methode from UTF-8 to windows-1252 and use "Semicolon" as separator , even if you are 100% sure that MS Excel has saved your file in .csv
About This Community
This platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 3/22/14, 4:20 AM|
|Seen: 4132 times|
|Last updated: 3/16/15, 8:10 AM|