c2c-oerpscenario team mailing list archive

["Kyle Waid - http://www.gcotech.com" <673614@xxxxxxxxxxxxxxxxxx>]

It appears to be caught in an infinite loop

2011-03-16 13:52:17,980][midwestsupplies] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
  File "/opt/openerp/server/bin/service/netrpc_server.py", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/opt/openerp/server/bin/netsvc.py", line 499, in dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException
[2011-03-16 13:52:18,049][midwestsupplies] DEBUG:init:loading 1 packages..
[2011-03-16 13:52:18,050][midwestsupplies] INFO:init:module base: loading objects
[2011-03-16 13:52:18,161][midwestsupplies] INFO:init:module base: creating or updating database tables
[2011-03-16 13:52:18,226][midwestsupplies] DEBUG:orm.schema:Table 'ir_model_fields': dropped constraint 'ir_model_fields_size_gt_zero'. Reason: its definition changed from 'check (size > 0)' to 'CHECK (size>0)'
[2011-03-16 13:52:18,231][midwestsupplies] DEBUG:orm.schema:Table 'ir_model_fields': added constraint 'ir_model_fields_size_gt_zero' with definition=CHECK (size>0)
[2011-03-16 13:52:19,306][midwestsupplies] DEBUG:orm.schema:Table 'ir_model_data': dropped constraint 'ir_model_data_module_name_uniq'. Reason: its definition changed from 'unique (name, module)' to 'unique(name, module)'
[2011-03-16 13:52:22,232][midwestsupplies] DEBUG:orm.schema:Table 'ir_model_data': added constraint 'ir_model_data_module_name_uniq' with definition=unique(name, module)
[2011-03-16 13:52:22,371][midwestsupplies] DEBUG:orm.schema:Table 'ir_ui_view_sc': dropped constraint 'ir_ui_view_sc_shortcut_unique'. Reason: its definition changed from 'unique (res_id, resource, user_id)' to 'unique(res_id, resource, user_id)'
[2011-03-16 13:52:22,388][midwestsupplies] DEBUG:orm.schema:Table 'ir_ui_view_sc': added constraint 'ir_ui_view_sc_shortcut_unique' with definition=unique(res_id, resource, user_id)
[2011-03-16 13:52:22,628][midwestsupplies] DEBUG:orm.schema:Table 'ir_model_fields': dropped constraint 'ir_model_fields_size_gt_zero'. Reason: its definition changed from 'check (size > 0)' to 'CHECK (size>0)'
[2011-03-16 13:52:22,637][midwestsupplies] DEBUG:orm.schema:Table 'ir_model_fields': added constraint 'ir_model_fields_size_gt_zero' with definition=CHECK (size>0)
[2011-03-16 13:52:23,113][midwestsupplies] DEBUG:orm.schema:Table 'ir_rule': dropped constraint 'ir_rule_no_access_rights'. Reason: its definition changed from 'check (perm_read <> false or perm_write <> false or perm_create <> false or perm_unlink <> false)' to 'CHECK (perm_read!=False or perm_write!=False or perm_create!=False or perm_unlink!=False)'
[2011-03-16 13:52:23,116][midwestsupplies] DEBUG:orm.schema:Table 'ir_rule': added constraint 'ir_rule_no_access_rights' with definition=CHECK (perm_read!=False or perm_write!=False or perm_create!=False or perm_unlink!=False)
[2011-03-16 13:52:24,028][midwestsupplies] DEBUG:orm.schema:Table 'publisher_warranty_contract': dropped constraint 'publisher_warranty_contract_uniq_name'. Reason: its definition changed from 'unique (name)' to 'unique(name)'
[2011-03-16 13:52:24,056][midwestsupplies] DEBUG:orm.schema:Table 'publisher_warranty_contract': added constraint 'publisher_warranty_contract_uniq_name' with definition=unique(name)

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

Title:
  Base_external_referential : ID problem with export-import CSV

Status in Magento Open ERP Connector:
  Fix Released

Bug description:
  Hi everyone,

  Today I needed to tick a checkbox field on 2000+ product in OpenERP
  with magentoerpconnect enabled. To do it, I used the easiest method :
  a CSV export of all the products with column "Database ID", "Name",
  and the field checkbox.

  I modified the checkbox field to True in my OpenOffice Calc, and then
  I re-imported the CSV in OpenERP.

  But I had a very ugly message :

  Error trying to import this record :
  	track_production: True

  Error message :
  Line 1 : "extref.society_name.product.product_8" contains too many dots. XML ids should not contain dots ! These are used to refer to other modules data, as in module.reference_id

  I should precise that I didn't try to import the column "Id". But
  after this I did a CSV export with the column "Id" and I effectively
  get the value "extref.society_name.product.product_8".

  I don't know why I had a bug with a field that was not imported,
  probably because it was the field "Id" that is relatively important
  for OpenERP.

  Anyway, my devs men say to me that this absolutely not normal that we
  have an Id with several dots, and so there is several very bad
  consequences on the CSV system. For example here, Impossible to modify
  a product by update CSV.

  I see in Administration / Customization / Database Structure / External Referential / Data two interesting fields  : module and XML identifier. For example with the example product, I have 
  Module : product.product_8
  XML identifier : extref.society_name

  This quite obvious that the id is generated by
  base_external_referential with the concatenation "Module"."XML
  identifier". But this is bad because with this approach we have an id
  with several dots. I am already surprised that only the CSV system was
  compromised.

  What do you think?