[6.1]import_sugarcrm column 'name' column too short
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) |
New
|
Undecided
|
Étienne Beaudry Auger |
Bug Description
--LOG--
2012-11-19 18:41:30,880 18841 INFO ? import_sugarcrm: Importing Users into res.users
2012-11-19 19:06:54,367 18841 INFO ? import_sugarcrm: Importing Accounts into res.partner
2012-11-19 19:07:30,956 18841 ERROR ? openerp.sql_db: bad query: insert into "res_partner_
Traceback (most recent call last):
File "/home/
res = self._obj.
DataError: value too long for type character varying(64)
2012-11-19 19:07:30,974 18841 ERROR ? openerp.sql_db: bad query: SELECT "res_partner_
Traceback (most recent call last):
File "/home/
res = self._obj.
InternalError: current transaction is aborted, commands ignored until end of transaction block
Traceback (most recent call last):
File "/home/
res = self._resolve_
File "/home/
r = self._import_
File "/home/
return self._save_
File "/home/
fields, values = self._fields_
File "/home/
value = val(dict(
File "/home/
id = self.get_
File "/home/
return self.import_
File "/home/
return self.import_
File "/home/
xml_ref = self.mapped_
File "/home/
ids = obj.search(self.cr, self.uid, domain, context=
File "/home/
return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
File "/home/
cr.
File "/home/
return f(self, *args, **kwargs)
File "/home/
res = self._obj.
InternalError: current transaction is aborted, commands ignored until end of transaction block
--LOG--
if you can seee 'Faculté d''aménagement, d''architecture et des arts visuels' is too long for 'name' column in res_partner_adress
Hi,
I try a full import from SugarCRM Version 6.3.0 (build 7004) to OpenERP 6.1.
The original column size in 'res_partner_
name character varying(64), -- Contact Name
Should be in SQL:
name character varying(128), -- Contact Name
I don't know if others columns can be affected by this error during the importation process.
A code review would be revelant.
description: | updated |
summary: |
- import_sugarcrm column 'name' column too short + [6.1]import_sugarcrm column 'name' column too short |
Changed in openobject-addons: | |
assignee: | nobody → Étienne Beaudry Auger (etienne-bauger) |