Is it possible to import null values?

Question

I'm trying to import suppliers. Some are for foreign companies that have no state codes, which makes the import process return errors. Looking in the database, I see that field "state" in "res.partner" is nullable, so why can't I import a blank field? I have also tried replacing empty strings with "NULL" and "(null)", but neither works.

Jeff Beidler · Accepted Answer

What ended up working for me was to open the .csv file in OpenOffice, select the blank fields, and hit the "Delete" key.  I then got a pop-up asking if I wanted to delete numbers, text, etc., or "Delete All".  I chose "Delete All", then re-saved the file.  After that, it validated and imported without problems!  Hope this helps someone else when they run into the same issue.

michel Guénard · Answer

I suspect that the fields of your initial csv file were not blank but filled with one symbol/caracter like ' which you cannot see by default.

Bài viết liên quan	Trả lời	Lượt xem
Importacion de Atributos y Valores import	2 thg 5 25	1313
Import from Winbooks Đã xử lý import	4 thg 5 25	5003
can i import journal entries from Excel import	1 thg 8 24	2315
Odoo 17 Studio import	1 thg 2 24	3079
Importing records--is there an option to create a related record if it does not exist yet? import	3 thg 10 23	11115

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!