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.

İlgili Gönderiler	Cevaplar	Görünümler
Importacion de Atributos y Valores import	2 May 25	1320
Import from Winbooks Çözüldü import	4 May 25	5017
can i import journal entries from Excel import	1 Ağu 24	2322
Odoo 17 Studio import	1 Şub 24	3086
Importing records--is there an option to create a related record if it does not exist yet? import	3 Eki 23	11123

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!