← Back to team overview

openerp-india team mailing list archive

[Bug 1091184] Re: Importing csv file with children of existing parent gives error

 

** Attachment added: "import_with_parent.ogv"
   https://bugs.launchpad.net/openobject-server/+bug/1091184/+attachment/3463537/+files/import_with_parent.ogv

** Changed in: openobject-server
   Importance: Undecided => Low

** Changed in: openobject-server
       Status: New => Confirmed

** Changed in: openobject-server
     Assignee: (unassigned) => OpenERP's Framework R&D (openerp-dev-framework)

** Changed in: openobject-server
   Importance: Low => Medium

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1091184

Title:
  Importing csv file with children of existing parent gives error

Status in OpenERP Server:
  Confirmed
Status in Therp Backports:
  Fix Released

Bug description:
  I have a csv files with product categories, that should be linked to
  the main category (the one with xml ID cat0). I try to import the csv
  file trough the user interface. This results in in error, saying that
  None can not be linked to an int.

  The csv file looks like this:

  id,parent_id/id,name
  cat_bevestiging,product.cat0,Bevestiging
  cat_elektra,product.cat0,Elektra
  cat_gereedschap,product.cat0,Gereedschap

  The import creates the first record (committed to the database), then
  returns an error, and the rest of the import fails.

  So apart from the original error, there is the error that a partial
  import is committed.

  The error occurs during computation of the parent_left, parent_right
  values. Because the main category, does not have parent_left or
  parent_right set in the database. (I think this is an error too, by
  the way).

  The import error can be easily solved by patching one line in orm.py.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1091184/+subscriptions


References