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.
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
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.
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
|Asked: 3/22/14, 4:20 AM|
|Seen: 3448 times|
|Last updated: 3/16/15, 8:10 AM|