Importing Product File Error

Question

Odoo Community Version 11

Hi Odoo Community! I am attempting to import a product data set (in CSV and Excel formatting) and I am receiving an error in the name column it looks like. Our developers recommended us to 'Encode' the files as Unicode (UTF-8) (accessed through Save As>Tools>Web Options>Encoding) then saving the document as Unicode (UTF-8). This is the error I am receiving:

null value in column "name" violates not-null constraint DETAIL: Failing row contains (140215, null, null, 62825

Ashish Singh · Answer

Hi, Adam

Seems like "*name*" *column *is not present in your *CSV *or there is false value for "*name*" *column *due to this you are getting "*null column*" issue. So please check and update these values as "*name*" field is *required *for the *product*.
*In case you still have the same issue then please share your CSV in order to check this issue.*
Thanks, Ashish Singh (Team Lead) Webkul Software Private Limited

Adam Noll · Answer

Ashish Singh - I can share the file but unfortunately I don't have enough 'coins' if you will to do so. I need to gain Karma to comment or share anything with you. I can certainly email you directly the file in CVS format? My direct email below.
I can certainly try that Mustufa Rangwala but I have over 1,000 and I still find trouble exporting data and re-uploading the data set back in troubling.
anoll@mingleteam.com

Mustufa Rangwala · Answer

Hello,
It is not issue of Odoo 11 setup but format of your excel file.
You may try to first export from product and try to use same csv/excel to import - may be it can help.
Regards,
Mustufa Rangwala

İlgili Gönderiler	Cevaplar	Görünümler
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y' importing	3 Tem 25	2001
Odoo journal entry modification after posting by import importing	1 Nis 25	1497
Import mehrerer Artikel mit Varianten importing	0 Eki 24	1233
Importing Excel/CSV using custom unique field instead of XML ID importing	2 May 24	4057
Product export then import duplicates everything importing	0 Nis 24	1352

Bu soru işaretlendi

Thanks,

Ashish Singh (Team Lead)

Webkul Software Private Limited

Enjoying the discussion? Don't just read, join in!