Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Product Attribute Values containing comma character: csv-Import seems to work differently when importing into Attribute Values and when importing into Product Templates

import field csv attributes char

4 الردود

9486 أدوات العرض

Ermin Trevisan

It is easy to import such values into fields of type "text" by surrounding them by quotation marks, but it does not work for fields of type "char", all characters after a comma are lost.

I simply want to import product attribute values containing commas.

*** Update ***

he behaviour is strange enough: I was able to import the exact same value correctly into the field Value in the model product.attribute.value before without any problems (and without any quotes). The values are stored properly in the attribute values table. It only happens, when I try to import these values into the product templates.

Import into Attribute Values (working properly):

The field odooattribute_id is the External ID of the attribute.

This is how I want to import the corresponding values into the product templates (which works flawlessy, when the attribute values do not contain commas):

The external ID here is the External ID of the corresponding Product Template.

And this is the result:

The value to be imported gets truncated after the comma and therefore the corresponding value could not be found.

Meanwhile I did report an issue on Github: https://github.com/odoo/odoo/issues/27569

Any ideas/hints are very appreciated.

Samuel Ballé

Hi, did you found a solution ?

This is still an issue in latest version for imports and not only in products.

As you I tried Excel format without success

Thuy Ngoc

Hi Ermin,

I think this video can help you:

https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1

Juan Felipe Tettay

Import using another character, semicolon for example, and then import again changing only the name.

Mitul Shingala

Hello,

using below code you can achieve your goal.

import csv
with open("filepath/file.csv", "rb") as f:
    reader = csv.reader(f, delimiter="\t")
    for i, line in enumerate(reader):
        print 'line[{}] = {}'.format(i, line)  # here you can get result line by line into the list, comma separate value into the quote.

Ermin Trevisan

الكاتب

Thanks for your answer, but I'm afraid I can not follow you. I simply want to import product attribute values containing commas.

ayman mohammed adam

Dear Ermin Trevisan

Try to import by using Excel File instead of CSV file.

I hope I helped you ...

Ermin Trevisan

الكاتب

Thanks for your answer. I did try it in several ways, none of them did work: as .xls and .xlsx files, without quotation marks, with single quotation marks, with double quotation marks. How does your Excel file looks like?

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Import One2many field sales import one2many field csv	4 مارس 20	6928
Custom field and export/import from CSV module export import field csv	1 أكتوبر 15	13094
Matching fields with csv import fields import field csv importing	2 مارس 15	8705
Disable automatic follow when importing res.partner csv import csv	3 يونيو 20	4931
Enable/disable import rights? import csv	1 نوفمبر 18	10405

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!