Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

'utf8' codec can't decode byte error when importing a list of products as a CSV file

import csv

11 Vastaukset

65206 Näkymät

Marco

'utf8' codec can't decode byte 0xb0 in position 16: invalid start byte

I have about 13k products that I need to get into OpenERP, so I tried exporting an example and then filling the fields with the information regarding all the other products but when I try importing it back it gives me the error on the first line.

Where is pÃ²sition 16 and what exactly is causing this?

UPDATE: As Grover Menacho said, I did have "Â°" in my info, I erased those and now the error is as follows.

'utf8' codec can't decode byte 0xc7 in position 3: invalid continuation byte

kaynis

Copy your csv sheet to an Open Office spreadsheet and save as ods file and then save as csv form the ods format if you are using MS Excel. Excel does not format csv properly most times.

Marco

Tekijä

That did not work, it keeps giving me the error: .'utf8' codec can't decode byte 0xc7 in position 3: invalid continuation byte

Eric

Paras vastaus

I also had this problem once. When you choose your csv file to import, then select the "latin-1" encoding option from the Encoding drop down menu rather than the "utf-8". The "latin-1" option accepts the different symbols like the " Â° " and this way I didnt have to modify the csv file at all.

Marco

Tekijä

I do not have this drop down menu, do you know if I have to activate it somewhere and if so, where exactly?

Rich Granata

No need to activate. After you browse to and select the CSV file, an option appears below that says "File Format Options..." You can expand that to select encoding.

Marco

Tekijä

I found it, it worked now and imported all 12k products without a hitch, thank you.

Simplify it!

You have a degree symbol or crossed d "Â°" or "Ã°" Check this and import it again.

Marco

Tekijä

Thank you, it did have the "Â°" symbol.

Wayne Nelson

This works on Macs and Windows versions of Excel:

In Excel, Save As.. and select format as Windows Comma Separated (.csv)

When importing into OpenERP change the + File Format Options ecoding from utf-8 to windows-1252.

Dennis Ndegwa

Hi,
I had this problem until I realized that Office has two csv formats in it. I saved using the "UTF-8" format and it worked. Hope this will save someone a lot of headache.

Mariusz Mizgier

Did you save your csv with utf-8 coding? Remember that editing with Excel does not always work this way (usually the best choice is to use OpenOffice to be sure that coding is right). Otherwise, if you did, could you post a line with a product, which could not be imported?

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Disable automatic follow when importing res.partner csv import csv	3 kesäk. 20	5066
Enable/disable import rights? import csv	1 marrask. 18	10525
Import contacts through CSV Ratkaistu import csv	2 maalisk. 15	12309
Import csv file with related field other than id, external id, name import csv importing data from excel file	4 marrask. 24	13093
How to convert csv files encoding to utf-8 Ratkaistu import csv encoding	2 marrask. 24	39063

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!