Odoo Help


Can't re-import datafor products

on 3/8/16, 9:10 AM 935 views


I created a product and a supplier. Then, I used the integrated export-function to create a csv with external_ID plus 3 values . I get


 All perfect, so far.

Then, I tried to import this csv. odoo recognized automatically all column-names. When I validate, I get

FEHLER: NULL-Wert in Spalte „name“ verletzt Not-Null-Constraint DETAIL: Fehlgeschlagene Zeile enthält (35, 1, 2016-03-08 13:59:01.270331, null, 1, 1, 1, null, 1, 2016-03-08 13:59:01.270331, 0, 1210470, 1306, null). between rows 2 and 3 

 Same problem, when I try to import only the first two lines.

Thanh Loyal
On 3/9/16, 12:02 AM


There are alot of fields which are required for every product. It seems to be that your Fehlgeschlagene Zeile  (I dont know what does this mean in English) column is missing.

You should also get that column exported too.

Fehlgeschlagene Zeile could be translated with failed row. Complete Error means: "NULL-value in row "name" breaks Not-Null-Constraint" I'm confused, because I want to import exactly the same data I exported a few seconds before. Without any changes of the data. For export I choose type "import-compatible export". I tried to export also the product name (row "name"), but get the same error.

Mbio, Claudius
on 3/9/16, 3:27 AM

I have the same problem with stock pickings. I have exported a few lines and then tried to re-import them: FEHLER: NULL-Wert in Spalte „name“ verletzt Not-Null-Constraint DETAIL: Fehlgeschlagene Zeile enthält (10, null, null, 2016-04-25 12:30:13.765067, null, 20, null, 7.000, 1, 2016-04-25 09:25:00, null, null, 8, 1, null, null, null, draft, null, null, 2016-04-25 09:25:00, null, null, 1, null, null, f, t, null, make_to_stock, 1, null, null, 13, null, 10, 12, 2016-04-25 12:30:13.765067, null, null, none, null). in Zeile 2 I tried adding a column named "name", that did not help. When checking the dropdown-menu in the import interface I did not even find a column "name".

Sophie Kowalski
on 4/25/16, 8:35 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/8/16, 9:10 AM
Seen: 935 times
Last updated: 3/9/16, 12:02 AM