Skip to Content
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
All Posts Ihmiset Merkit
Tunnisteet (View all)
odoo v14 accounting v15 odoo16features
Tietoa tästä foorumista
Tämä kysymys on merkitty
4228 Näkymät
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
Hylkää
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.