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	Відповіді	Переглядів
Importacion de Atributos y Valores import	2 трав. 25	1322
Import from Winbooks Вирішено import	4 трав. 25	5031
can i import journal entries from Excel import	1 серп. 24	2323
Odoo 17 Studio import	1 лют. 24	3088
Importing records--is there an option to create a related record if it does not exist yet? import	3 жовт. 23	11124

Це запитання позначене

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