Skip ke Konten
Pertanyaan ini telah diberikan tanda
import
6 Replies
20405 Tampilan
Avatar
Dale

Hi

I am having incredible difficulty importing leads to partners. I imported my partners from another system using that systems account number field. I was then able to import the contacts using the same account number field as a match however now importing leads using the same account number again i keep gettin the error

Unsupported format character '{' (0x7b) at index 57

Why is it now having problems with an account number i have used twice already? What can i do now to inport my lead? Any ideas appreciated

Avatar
Buang
Ray Carnes

There is an offending row which is different from what you've imported before - see my answer for a suggested way of cleansing your data.

Avatar
Danimar Ribeiro
Jawaban Terbai

Probably still has this bug.

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

The problem is with % characters in your csv.

Avatar
Buang
Avatar
patrick
Jawaban Terbai

The cryptic code 0x7b is an indication, that somehow your import has either special characters, or probably in your case the character { (accolade opening). Example from here.

Avatar
Buang
Dale
Penulis

Thanks for your response. I hear what you are saying HOWEVER, OpenERP allowed me to import companies with that same number and thereafter it allowed me to import and match contacts to the imported companies with that same number. Why would it only be giving me errors now when I am importing quotes?

patrick

According to the information I found, it is a combination of characters, often starting with %. Somehow it tries to interpret your string with an { as some kind of special character. Just check your sources, and see if there is either a { or a %.

Avatar
Dale
Penulis Jawaban Terbai

Hi Patrick

Thanks for your response. I hear what you are saying HOWEVER, OpenERP allowed me to import companies with that same number and thereafter it allowed me to import and match contacts to the imported companies with that same number. Why would it only be giving me errors now when I am importing quotes?

Avatar
Buang
Avatar
Ray Carnes
Jawaban Terbai

Before pointing Odoo at your CSV data:

1) Load it into Notepad++

2) From the ENCODING menu, select CONVERT TO UTF 8.

3) Save a new copy of your CSV data

I've had this problem several times before and it is due to special characters which are supported via ISO encoding but not supported by UTF8 encoding (which Odoo supports). Typically when you have a Windows platform and/or Excel conversion somewhere in the mix.

You can also expand File Format Options below where you point to your CSV and set the encoding there (if you know it), but I've had better success by re-encoding to UTF8.







Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Import Contact Notes (Help! Which is the correct Odoo Field?)
import
Avatar
Avatar
Avatar
2
Des 25
125
Importacion de Atributos y Valores
import
Avatar
Avatar
Avatar
Avatar
3
Des 25
2475
Issue with import and comma in Excel File (odoo 19)
import
Avatar
0
Sep 25
235
Import from Winbooks Diselesaikan
import
Avatar
Avatar
Avatar
Avatar
Avatar
4
Mei 25
7101
can i import journal entries from Excel
import
Avatar
Avatar
1
Agu 24
3677