I Kept this python file as well as csv file in server-folder. But it's not importing products!
Python Script-
import csv
import psycopg2
conn_string = "dbname= 'toc' user='openerp' password='sigma@123'"
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 ('" +row[1]+"','" +(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()
?