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	5032
can i import journal entries from Excel import	1 авг. 24	2325
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!