Odoo Help


Best Practices: Import size recommendations

Dale Thomas
on 1/30/15, 1:42 PM 912 views

I am starting the process of a massive import.  

Is there a recommend maximum I should be importing.  I have about 100,000 contacts I am brining over.  Should I break that down to 10k sizes?  

Appreciate the suggestions

Pierre Lamarche
On 1/30/15, 2:11 PM


What we have already experienced on massive contact import is a real weakness of performance.

You should test it with a first 10k contact file to see the time for validation.

If the performance is great, maybe you can increase the next batch.


Pierre, I found a fantastic excel macro that took my master companies list and broke it out to 20 files with 5000 companies each. Pretty slick! Going to try that a few times.

Dale Thomas
on 1/30/15, 6:52 PM

@Dale. good to hear you have found a fantastic macro. Would you mind to share that?

on 1/31/15, 1:11 AM
Jordi Riera
On 1/30/15, 2:25 PM

You might want to check this module: https://github.com/OCA/server-tools/pull/100

It seems to increase the speed of imports but also the stability of the process.




Thanks Jordi! I will look.

Dale Thomas
on 1/30/15, 3:56 PM

I reviewed the Github page and I personally don't feel comfortable or knowledgeable enough to even try. :)

Dale Thomas
on 1/30/15, 6:28 PM

Hey Dale, You might want to contact Sandy Carter. He is the guy who did the module and should be able to help you to use it if you need. You can reach him on twitter @bwrsandman or at sandy.carter@savoirfairelinux.com

Savoir-Faire Linux, Jordi Riera
on 2/2/15, 8:53 AM
Dale Thomas
On 1/30/15, 2:21 PM

Hi Pierre!  Great advice!  Thank you! 

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: 1/30/15, 1:42 PM
Seen: 912 times
Last updated: 3/16/15, 8:10 AM