Skip to Content
Menu
This question has been flagged
2 Replies
3650 Views
I have a problem with the article import. when I try to import a file of more than 5000 articles and a file of 38000 articles, but when I try to import it stops after more than two hours without importing, what should I do?
I use odoo16


Avatar
Discard

I think you have a timeout issue, could you please check the Odoo log file to get more details about the error? Also need to know your Odoo hosting?

can you detail, what you are importing? how importing

The reason could be a time-out or memory limit issue. 

So, Configure the following parameters in odoo.conf file

limit_memory_hard , limit_memory_soft ,limit_request, limit_time_cpu , limit_time_real

Best Answer

The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.

Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.

Avatar
Discard
Best Answer

you can take to troubleshoot and resolve the problem. Here's what you can do:

1.Increase Server Resources: Importing a large number of articles can be resource-intensive. Ensure that your server has sufficient resources allocated, such as CPU, memory, and disk space. If necessary, consider upgrading your server or optimizing its configuration.

2.Optimize Odoo Configuration: Review and optimize your Odoo server configuration settings. Increase the values of configuration parameters related to file size, memory, and timeout settings. The specific parameters to adjust depend on your server setup. Common ones include limit_memory_hard, limit_memory_soft, limit_request, limit_time_cpu, limit_time_real, and csv_internal_sep.

3.Split Import Files: Instead of importing a single large file, split the import files into smaller chunks. For example, divide the 38,000-article file into multiple files of 5,000 articles each or smaller. Import the smaller files one by one. This approach reduces the load on the server and improves the import process.

3.Optimize CSV File: Ensure that the CSV file you are importing is well-structured and optimized. Remove any unnecessary columns or data that are not required for the import. Simplifying the file can improve the import performance.

4.Batch Processing: Consider using batch processing techniques. Import a portion of the articles in each batch, and after completion, proceed with the next batch. This approach allows you to import the articles incrementally without overwhelming the system.

5.Enable Debug Mode: Enable the debug mode in Odoo to get more detailed error messages and information during the import process. This can help you identify any specific errors or issues causing the import to fail. You can enable debug mode by adding --debug or --log-level=debug to the Odoo command line when starting the server.

6.Check Logs: Monitor the Odoo server logs for any error messages or warnings related to the import process. The logs can provide insights into the specific issues causing the import to fail. Review the logs and address any identified errors accordingly.

7.Consider Using Data Import Tools: If the above steps don't resolve the issue, consider using third-party data import tools specifically designed for large data imports in Odoo. These tools often offer advanced features, optimizations, and performance improvements to handle large-scale imports more efficiently.

Thank you
Galaxy Weblinks
Skype-live:.cid.32795179bb452e97

Avatar
Discard
Related Posts Replies Views Activity
2
Apr 25
308
1
Aug 24
1180
3
Aug 24
3278
1
Feb 24
2037
3
Oct 23
10069