Odoo Help

Welcome!

This community 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.

2

Customer Names Not Showing Up In List View

By
Alex Gallien
on 10/13/14, 8:06 PM 1,179 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:

Thanks!

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
1
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
0
john5000
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

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

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