Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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:
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.
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
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 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 10/13/14, 8:06 PM|
|Seen: 1280 times|
|Last updated: 4/15/15, 1:56 AM|