Odoo Help


Can't import/export custom fields in v7?

Sean Samborski
on 4/7/14, 3:37 PM 2,051 views

When creating fields, I can't export or import these fields in v7. I can view the fields in the export popup, but it will never actually export if this field is in the add column.

The fields are created under Settings->Database Structure->Fields and look like this:

Field Name: x_user.id
Field Label: Outside Salesperson

Type: Custom Field
Model: Partner
In Modules: Null

Field Type: many2one
Object Relation: res.users
Relation Field: Null
Selection Options: Null
Domain: []
Serialization Field: Null
On Delete: Set NULL

Required: Null
Readonly: Null
Searchable: Not Searchable
Translatable: Null

When viewing the export popup, this field is displayed and I move it to the Add Column. Now, when I press Export, it just will never export.

EDIT: openero-server.log has the message:

KeyError: u"Field 'x_user' does not exist in object 'browse_record(res.partner, 14367)'"

There's also a traceback error:

Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1245, in export_data
    datas += self.__export_row(cr, uid, row, fields_to_export, context)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1162, in __export_row
    r = r[f[i]]
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 386, in __getitem__
    raise KeyError(error_msg)

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

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. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 4/12/14, 6:08 PM

I believe the problem is the dot in the name.


  • field must be in lowercase, separated by underscores. T
  • try to use commonly used names for fields: name, state, active, partner_id, eso.

Conventions for the field name depends on the field type:

  • many2one: must end by '_id' (eg: partner_id, order_line_id)
  • many2many: must end by '_ids' (eg: category_ids)
  • one2many: must end by '_ids' (eg: line_ids

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/7/14, 3:37 PM
Seen: 2051 times
Last updated: 3/16/15, 8:10 AM