Skip to Content
Menu
This question has been flagged
1 Reply
15509 Views

Traceback (most recent call last):
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/OpenERPWS/addons/employee_system/department.py", line 27, in access_to_postgresql
    statement = "INSERT INTO product_template (name,description) VALUES ('"+str(row[1])+"','"+str(row[2])+"') RETURNING id"
IndexError: list index out of range
2014-09-03 15:40:10,931 18342 ERROR toc openerp.netsvc: list index out of range
Traceback (most recent call last):
  File "/opt/OpenERPWS/server/openerp/netsvc.py", line 296, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/OpenERPWS/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/OpenERPWS/server/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/OpenERPWS/addons/employee_system/department.py", line 27, in access_to_postgresql
    statement = "INSERT INTO product_template (name,description) VALUES ('"+str(row[1])+"','"+str(row[2])+"') RETURNING id"
IndexError: list index out of range?

 

 

 

 

CODE-

def access_to_postgresql(self, cr, uid, ids, context=None):
        import csv
        import psycopg2
        conn_string = "dbname= 'toc' user='openerp' password='sigma@123' host='localhost'"
        conn = psycopg2.connect(conn_string)
         
        cursor = conn.cursor()
         
        reader = csv.reader(open('prod.csv','rb'))
        for row in reader:
            print row[1]
             
            statement = "INSERT INTO product_template (name,description) VALUES ('"+str(row[1])+"','"+str(row[2])+"') RETURNING id"
                 
            cursor.execute(statement)
            conn.commit()
            templateid=cursor.fetchone()[0]
                    
            statement = "INSERT INTO product_product (product_tmpl_id,default_code,active,valuation) VALUES \
            (" + str(templateid) + ",'" + row[0] + "',True,'manual_periodic')"
                
            cursor.execute(statement)
            conn.commit()

csv fields- name,description

?

Avatar
Discard