Hi Experts,

I have made a python script to import data into leads database, and below is a sample code.

sql ="insert into crm_lead(create_uid,write_uid,active,type,color,day_close,day_open,section_id,company_id,priority," \
                    "create_date,write_date,name,street,contact_name,partner_id,city,description,user_id,state,stage_id,planned_revenue,ref2) "\
                                    " values('1','1','1','lead',0,0,0,2,1,3,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s',%s,'%s')  " \
                                    "" % (create_date,write_date,location,location,contactname,partner_id,city,notes,user_id,state,stage_id,planned_revenue,quote_id)
                                
                            

cursor.execute(sql)
                            

conn.commit()

It is inserting data into the table without any problem and I can view them in a leads tree view and form views. But when I wanted to make some changes and save in form view it gives following error.

Server Traceback (most recent call last): File "C:\Program Files (x86)\OpenERP7\server\openerp\addons\web\session.py", line 89, in send File "C:\Program Files (x86)\OpenERP7\server\.\openerp\netsvc.py", line 296, in dispatch_rpc File "C:\Program Files (x86)\OpenERP7\server\.\openerp\service\web_services.py", line 626, in dispatch File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\osv.py", line 190, in execute_kw File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\osv.py", line 132, in wrapper File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\osv.py", line 199, in execute File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\osv.py", line 187, in execute_cr File "C:\Program Files (x86)\OpenERP7\server\openerp\addons\base_action_rule\base_action_rule.py", line 181, in wrapper File "C:\Program Files (x86)\OpenERP7\server\openerp\addons\crm\crm_lead.py", line 951, in write File "C:\Program Files (x86)\OpenERP7\server\openerp\addons\mail\mail_thread.py", line 297, in write File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\orm.py", line 4396, in write File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\orm.py", line 4734, in _store_set_values File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\fields.py", line 1152, in get File "C:\Program Files (x86)\OpenERP7\server\openerp\addons\crm\crm_lead.py", line 197, in _compute_day File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\orm.py", line 503, in __getattr__ File "C:\Program Files (x86)\OpenERP7\server\.\openerp\osv\orm.py", line 481, in __getitem__ ValueError: need more than 1 value to unpack

I am new to openerp and not sure I am following the correct way to import data. But, also I tried to import data using csv in leads and it does not give such error. Is it some dependancy in leads like message, followers, etc that I am missing here. Your guide much appreciated. Thanks in advance.