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...