Hi, Im trying to import products list directly to the database using an script found...
Using this tutorial I have created my own script as follows:
import csv
import psycopg2
conn_string = "host='localhost' dbname='uuuu' user='openerp' password='uuuuu'"
conn = psycopg2.connect(conn_string)
cursor = conn.cursor()
reader = csv.reader(open('productcatalog.csv','rb'))
for row in reader:
print row[1]
statement = "INSERT INTO product_template (name,uom_id,uom_po_id,categ_id,standard_price,list_price,supply_method,mes_type,procure_method,cost_method,type,sale_ok) VALUES \
('" + row[1] + "','" + (row[2]) + "','" + (row[3]) + "','" + (row[4]) + "'," + str(row[5]) + "," + str(row[5]) + ",'produce','fixed','make_to_stock','standard','product',True) 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()
But I receive the following error:
Traceback (most recent call last): File "pruebaupload.py", line 11, in <module> print row[1] IndexError: list index out of range
Any clues? Thanks...