Odoo Help


Customer Names Not Showing Up In List View

Alex Gallien
on 10/13/14, 8:06 PM 1,669 views

Hi All,

I have been migrating data from SugarCRM to Odoo via .csv files, and have come across some strange behavior. My initial import of active customers went perfectly, everything seems great. I also had a bunch of inactive customers that I wanted to have in the database as well, in case they show up in the future. I set the 'Active' field to FALSE for each of those, and they imported as inactive partners, but for some reason their names aren't showing up in list view. Even when I make them active again the names don't show up. Any idea what's going on here? Or how to get around it? Here is a screenshot:


were you able to solve it? If yes, then please provide info on how to solve this.

Atchuthan - Technical Consultant, Sodexis Inc
on 4/7/15, 1:35 AM
Alex Gallien
On 4/15/15, 1:56 AM

I solved this by changing the way that I imported the data. Instead of importing the 'Active' field as false in my initial import, I imported them all normally with a 'Inactive' tag, then exported all of the fields with the 'Inactive' tag, so I had a .csv with the ids of all the records (__export__.res_partner_291). I then imported again with the 'Active' field set to false, and it worked as expected. Hope this helps! I'm running v7 for what it's worth.

thanks for sharing this info.

Atchuthan - Technical Consultant, Sodexis Inc
on 4/15/15, 1:57 AM
On 1/2/15, 9:12 PM

Don't know if you resolved this. If not, see what those records look like in the database.  

Keep in mind, there is a "name" field and a "display_name" field.  They usually both need to be set.

Check this by doing:

select * from res_partner where active = 0

as compared to the ones that you say are active and work, 

select * from res_partner where active = 1


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

2 follower(s)


Asked: 10/13/14, 8:06 PM
Seen: 1669 times
Last updated: 4/15/15, 1:56 AM