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.

Related Posts	Replies	Zobrazenia
Importacion de Atributos y Valores import	2 máj 25	1314
Import from Winbooks Solved import	4 máj 25	5008
can i import journal entries from Excel import	1 aug 24	2316
Odoo 17 Studio import	1 feb 24	3081
Importing records--is there an option to create a related record if it does not exist yet? import	3 okt 23	11115

This question has been flagged

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