Skip to Content
This question has been flagged
4227 Views
Avatar
Nicolas

Hello, 

I have an  error "null value in column "name" violates not-null constraint DETAIL: Failing row contains (218, null, null, MR132AS01, 1, 0, 0.00, 1, 42, null, null, null, 521, 1, 8, 2018-03-14 14:25:52.30837, 8, 2018-03-14 14:25:52.30837). à la ligne 2 "

when trying to import the following fields for articles:

categ_id

cost_method

name

default_code

seller_ids/product_code

product_variant_ids/seller_ids/name

product_variant_ids/seller_ids/product_name


All my cells are filled with data. 

Any idea? 

Where can I find more detailed informations about import troubles?


Thanks







Avatar
Discard
Ermin Trevisan

Did you do an export first in order to check the column titles and data? Do you want to import product.templates or product.products? Which Odoo version?

OdooBot
Hi, 
Thank you for youro answer.

I am on Odoo 11.0+ E 

I first exported product and found following columns id:

categ_id / cost_method / name/ default_code/ seller_ids/product_code/ product_variant_ids/seller_ids/name/ product_variant_ids/seller_ids/product_name

When testing import, I get :
"null value in column "name" violates not-null constraint DETAIL: Failing row contains (218, null, null, MR132AS01, 1, 0, 0.00, 1, 42, null, null, null, 521, 1, 8, 2018-03-14 14:25:52.30837, 8, 2018-03-14 14:25:52.30837). à la ligne 2 "

I want to import products products.


2018-03-14 21:02 GMT+00:00 Ermin Trevisan <trevi@twanda.com>:

Did you do an export first in order to check the column titles and data? Do you want to import product.templates or product.products? Which Odoo version?

--
Ermin Trevisan


Sent by Odoo S.A. using Odoo.