Odoo Help


Is it possible to import null values?

Jeff Beidler
on 8/29/14, 12:12 PM 1,093 views

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
On 8/29/14, 7:46 PM

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

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 8/30/14, 10:02 AM

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.


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/29/14, 12:12 PM
Seen: 1093 times
Last updated: 7/9/15, 1:26 PM