Odoo Help

Welcome!

This community 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.

0

Can't re-import datafor products

By
Claudius
on 3/8/16, 9:10 AM 374 views

Hi,

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

"id","seller_ids/pricelist_ids/min_quantity","seller_ids/pricelist_ids/price","seller_ids/product_code"
"__export__.product_template_1306","1.0","30.0","1210470"
"","10.0","28.0",""

 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.

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

Hi,

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.

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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