This question has been flagged
1 Reply
17491 Views

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()
   
   ?
               
   

Avatar
Discard
Best Answer

Hi Kannu.
Videos below can help you.

Best regards


 

Avatar
Discard