Well ... importing via web interface / csv import is realy slow , specially when dealing with thousands of records.
For example import of 50000 products may last as long as 5-7 hours (tested myself)...
The main reason for that slow behaivour is because odoo check and werify every single line and record one by one before doing actual import. Benefit of using it it you can be apsolutley sure that all imported data is consistent and correct. Another great benefit of importing data via web interface is using external ids, wich can later be used for updating or modifying imported data. Also via web interface you are able to import data in more than one model in a single row of csv data. Also while importing wia web inteface you cak use external ids as foreign key data ( many2one, x2many fields..)
The othey way of importing is via sql insert , but it is not recomended to use it if you are not realy sure what are you doing.
Importing via sql is much faster ( up to 10 times , even more... for example, same 50k products was imported via sql in less than half hour). The one and only benefit of using sql import is speed. Here is an example of how to do it faster...
It is up to you to choose the way you want to import your data.
Hope this helps
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
|Asked: 9/18/14, 2:03 AM|
|Seen: 2306 times|
|Last updated: 3/16/15, 8:10 AM|