← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 861348] [NEW] not able to import customer due to payable an receivable fields

 

Public bug reported:

in web client :

- export customers from a db with demo data  (export also fields payable and receivable account)
- import those data in a  same db without demo data
-> all data seems ok

Click import :

[2011-09-28 12:08:29,167][?] INFO:werkzeug:127.0.0.1 - - [28/Sep/2011 12:08:29] "POST /web/import/detect_data HTTP/1.1" 200 -
[2011-09-28 12:08:30,756][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 173, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1335, in import_data
    process_liness(self, datas, [], current_module, self._name, fields_def, position=position)
  File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1294, in process_liness
    res = _get_id(relation, line[i], current_module, mode)
  File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1188, in _get_id
    record_id = ir_model_data_obj._get_id(cr, uid, module, xml_id)
  File "/home/aline/openerp/server/trunk/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/home/aline/openerp/server/trunk/openerp/tools/cache.py", line 46, in lookup
    value = d[args] = self.method(self2, cr, *args)
  File "/home/aline/openerp/server/trunk/openerp/addons/base/ir/ir_model.py", line 621, in _get_id
    raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
ValueError: No such external ID currently defined in the system: .res_partner_525

** Affects: openerp-web
     Importance: Medium
         Status: Confirmed

** Description changed:

  in web client :
  
  - export customers from a db with demo data  (export also fields payable and receivable account)
  - import those data in a  same db without demo data
- -> all data seems ok 
- 
- 
- Client Traceback (most recent call last):
-   File "/home/aline/openerp/web/openerp-web/addons/web/common/dispatch.py", line 161, in dispatch
-     response["result"] = method(controller, self, **self.params)
-   File "/home/aline/openerp/web/openerp-web/addons/web/controllers/main.py", line 628, in search_read
-     return self.do_search_read(req, model, fields, offset, limit, domain, sort)
-   File "/home/aline/openerp/web/openerp-web/addons/web/controllers/main.py", line 653, in do_search_read
-     ids = Model.search(domain, 0, False, sort or False, context)
-   File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 367, in proxy
-     *args)
-   File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 244, in proxy
-     result = self.connector.send(self.service_name, method, *args)
-   File "/home/aline/openerp/web/openerp-web/addons/web/common/openerplib/main.py", line 214, in send
-     raise fault
- 
- 
- Server Traceback (most recent call last):
-   File "/home/aline/openerp/server/trunk/openerp/netsvc.py", line 411, in dispatch_rpc
-     result = ExportService.getService(service_name).dispatch(method, auth, params)
-   File "/home/aline/openerp/server/trunk/openerp/service/web_services.py", line 575, in dispatch
-     res = fn(db, uid, *params)
-   File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 119, in wrapper
-     return f(self, dbname, *args, **kwargs)
-   File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 173, in execute
-     res = self.execute_cr(cr, uid, obj, method, *args, **kw)
-   File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
-     return getattr(object, method)(cr, uid, *args, **kw)
-   File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 2138, in search
-     return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
-   File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 4347, in _search
-     cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
-   File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 153, in wrapper
-     return f(self, *args, **kwargs)
-   File "/home/aline/openerp/server/trunk/openerp/sql_db.py", line 215, in execute
-     res = self._obj.execute(query, params)
- ProgrammingError: ERREUR:  l'opérateur n'existe pas : integer ~~* unknown
- LIGNE 1 : ...er."user_id" = 1)  AND  ((sale_order."project_id" ilike E'%%...
-                                                                ^
- ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
- Vous devez ajouter des conversions explicites de type.
+ -> all data seems ok

** Description changed:

  in web client :
  
  - export customers from a db with demo data  (export also fields payable and receivable account)
  - import those data in a  same db without demo data
  -> all data seems ok
+ 
+ Click import :
+ 
+ [2011-09-28 12:08:29,167][?] INFO:werkzeug:127.0.0.1 - - [28/Sep/2011 12:08:29] "POST /web/import/detect_data HTTP/1.1" 200 -
+ [2011-09-28 12:08:30,756][?] ERROR:web-services:Uncaught exception
+ Traceback (most recent call last):
+   File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 119, in wrapper
+     return f(self, dbname, *args, **kwargs)
+   File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 173, in execute
+     res = self.execute_cr(cr, uid, obj, method, *args, **kw)
+   File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
+     return getattr(object, method)(cr, uid, *args, **kw)
+   File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1335, in import_data
+     process_liness(self, datas, [], current_module, self._name, fields_def, position=position)
+   File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1294, in process_liness
+     res = _get_id(relation, line[i], current_module, mode)
+   File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1188, in _get_id
+     record_id = ir_model_data_obj._get_id(cr, uid, module, xml_id)
+   File "/home/aline/openerp/server/trunk/openerp/tools/cache.py", line 18, in lookup
+     r = self.lookup(self2, cr, *args)
+   File "/home/aline/openerp/server/trunk/openerp/tools/cache.py", line 46, in lookup
+     value = d[args] = self.method(self2, cr, *args)
+   File "/home/aline/openerp/server/trunk/openerp/addons/base/ir/ir_model.py", line 621, in _get_id
+     raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
+ ValueError: No such external ID currently defined in the system: .res_partner_525

** Changed in: openerp-web
       Status: New => Confirmed

** Changed in: openerp-web
   Importance: Undecided => Medium

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/861348

Title:
  not able to import customer due to payable an receivable fields

Status in OpenERP Web:
  Confirmed

Bug description:
  in web client :

  - export customers from a db with demo data  (export also fields payable and receivable account)
  - import those data in a  same db without demo data
  -> all data seems ok

  Click import :

  [2011-09-28 12:08:29,167][?] INFO:werkzeug:127.0.0.1 - - [28/Sep/2011 12:08:29] "POST /web/import/detect_data HTTP/1.1" 200 -
  [2011-09-28 12:08:30,756][?] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 119, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 173, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/aline/openerp/server/trunk/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1335, in import_data
      process_liness(self, datas, [], current_module, self._name, fields_def, position=position)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1294, in process_liness
      res = _get_id(relation, line[i], current_module, mode)
    File "/home/aline/openerp/server/trunk/openerp/osv/orm.py", line 1188, in _get_id
      record_id = ir_model_data_obj._get_id(cr, uid, module, xml_id)
    File "/home/aline/openerp/server/trunk/openerp/tools/cache.py", line 18, in lookup
      r = self.lookup(self2, cr, *args)
    File "/home/aline/openerp/server/trunk/openerp/tools/cache.py", line 46, in lookup
      value = d[args] = self.method(self2, cr, *args)
    File "/home/aline/openerp/server/trunk/openerp/addons/base/ir/ir_model.py", line 621, in _get_id
      raise ValueError('No such external ID currently defined in the system: %s.%s' % (module, xml_id))
  ValueError: No such external ID currently defined in the system: .res_partner_525

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/861348/+subscriptions


Follow ups

References