openerp-india team mailing list archive

[risto3 <938675@xxxxxxxxxxxxxxxxxx>]

just tried again with the file attached with 6.1 pulled to the latest as
of today.

~/src/openerp/server/6.1$ bzr version-info
revision-id: launchpad_translations_on_behalf_of_openerp-20120310052625-78n2341gtv2zrgwg
date: 2012-03-10 05:26:25 +0000
build-date: 2012-03-10 18:56:12 +0100
revno: 4097
branch-nick: 6.1

8] "GET /web/static/src/img/gradientlinebg.gif HTTP/1.1" 304 -
2012-03-10 17:44:54,815 7791 ERROR ? openerp.sql_db: bad query: insert into "res_partner_bank" (id,"city","owner_name","name","zip","footer","country_id","street","state_id","partner_id","acc_number",create_uid,create_date) values (1,'','','/','','False',NULL,'',NULL,2,'FR76 3000 4021 4600 0100 0409 374',1,(now() at time zone 'UTC'))
Traceback (most recent call last):
  File "/home/richard/src/openerp/server/6.1/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "state" violates not-null constraint


** Attachment added: "testimp.csv"
   https://bugs.launchpad.net/openobject-addons/+bug/938675/+attachment/2846067/+files/testimp.csv

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

Title:
  import party with bank bugs out

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  importing csv with party info containing:
  Customer	Supplier	name	address/street	address/street2	address/zip	address/city	address/phone	address/fax	bank_ids/acc_number	bank_ids/bank_bic	

  the server log contains:
  2012-02-22 13:23:38,729 16095 ERROR ? openerp.sql_db: bad query: insert into "res_partner_bank" (id,"city","owner_name","name","zip","bank_code","footer","country_id","street","state_id","partner_id",create_uid,create_date) values (9,'','','/','','DE3630007999990426149100031','False',NULL,'',NULL,325,1,now())
  Traceback (most recent call last):
    File "/home/richard/src/openerp/server/trunk/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "state" violates not-null constraint

  and the screen shows (capture included):
  L'import a échoué à cause de :Error during import: Line 5 : null value in column "state" violates not-null constraint

  in France (Europe) and working with IBAN, only the IBAN and BIC are
  necessary.

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