Odoo8.0,尝试导入时无法使csv文件有效

2024-04-27 18:23:35 发布

您现在位置:Python中文网/ 问答频道 /正文

尝试导入.csv文件时遇到问题。我试图将图像转换为base64,我还试图创建一个名为csv文件的条形码。它成功地将图像转换为base64,但当我尝试用csv文件名创建条形码时,总是出现如下错误:

Unknown error during import: <class 'openerp.exceptions.ValidationError'>: ('ValidateError', u'Field(s) `ean13` failed against a constraint: You provided an invalid "EAN13 Barcode" reference. You may use the "Internal Reference" field instead.') at row 2 Resolve other errors first

这是我的密码:

files = []
text = ''"
data_text3 = []

header_column2 = ["id","product_variant_ids/ean13_barcode", "product_variant_ids/ean13", "ean13", "image", "ean13_barcode", "default_code", "product_variant_ids/default_code"]

number = 1 for file in os.listdir("gmbr/"):
    file_name = os.path.splitext(file)[0]

    for n in str(number):
        directory_file = "gmbr/"+str(file)
        img = open(directory_file, 'rb').read()
        img_64 = base64.encodestr
        text = str(number)+","+str(name_product)+","+str(file_name)+","+str(file_name)+","+str(img_64+","+" "+","+" "+","+" ")
        number += 1
        data_text3.append(text)

with open('sample2.csv', 'wb') as f:
    writer = csv.writer(f, delimiter='\t', dialect='excel')
    writer.writerow(header_column2)
    for l in data_text3:
        writer.writerow(l.split(','))

Tags: csvtextnameidsnumberfordataproduct