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

unsupported format character on import

By
Dale
on 7/4/13, 3:34 AM 2,322 views

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

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.

Bista Solutions US, Ray Carnes
on 5/18/15, 6:43 PM
0

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 5/18/15, 6:42 PM

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.







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
Dale
On 7/9/13, 4:16 AM

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?

0

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 7/5/13, 9:42 AM

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.

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?

Dale
on 7/9/13, 4:16 AM

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 %.

patrick
on 7/9/13, 8:02 AM

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

1 follower(s)

Stats

Asked: 7/4/13, 3:34 AM
Seen: 2322 times
Last updated: 5/18/15, 6:43 PM